topic Re: Splunk DB Connect 3.6 Duplicate, Miss Data when sync a larger table around 1000 TPS in Splunk Search https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570697#M198879 <P>can&nbsp;anyone see this post?</P> Wed, 13 Oct 2021 03:07:38 GMT dailv1808 2021-10-13T03:07:38Z Splunk DB Connect 3.6 Duplicate, Miss Data when sync a larger table around 1000 TPS https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570591#M198851 <P>Hi,<BR />I am using splunk DB connect 2.1.4 to get data from&nbsp;A table in Oracle database, (table with around 1000 transactions per second, real time sync) to splunk server (running as heavy forwarder) --&gt; It works ok.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dailv1808_0-1634035311256.png" style="width: 686px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16364i47AF6A7F093FA35E/image-dimensions/686x168?v=v2" width="686" height="168" role="button" title="dailv1808_0-1634035311256.png" alt="dailv1808_0-1634035311256.png" /></span></P><P>My query in DB Connect (2.1.4) look like this. SEQ_NO as rising column.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dailv1808_3-1634035684479.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16367iC0A79456C2293333/image-size/medium?v=v2&amp;px=400" role="button" title="dailv1808_3-1634035684479.png" alt="dailv1808_3-1634035684479.png" /></span></P><P>For some reason, i need to upgrade to DB connect 3.6 (latest). So i created new heavy server installed DB connect 3.6. It works fail. Some data Duplicated, some missed.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dailv1808_1-1634035380282.png" style="width: 733px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16365i296B8DCBE5FF0B9D/image-dimensions/733x180?v=v2" width="733" height="180" role="button" title="dailv1808_1-1634035380282.png" alt="dailv1808_1-1634035380282.png" /></span></P><P>My query in DB Connect (3.6) look like this. SEQ_NO as rising column.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dailv1808_2-1634035504954.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16366iBABBB255211FB648/image-size/medium?v=v2&amp;px=400" role="button" title="dailv1808_2-1634035504954.png" alt="dailv1808_2-1634035504954.png" /></span></P><P>Please let me know as how can I solve the issue. Thanks!</P> Tue, 12 Oct 2021 10:50:43 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570591#M198851 dailv1808 2021-10-12T10:50:43Z Re: Splunk DB Connect 3.6 Duplicate, Miss Data when sync a larger table around 1000 TPS https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570697#M198879 <P>can&nbsp;anyone see this post?</P> Wed, 13 Oct 2021 03:07:38 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570697#M198879 dailv1808 2021-10-13T03:07:38Z Re: Splunk DB Connect 3.6 Duplicate, Miss Data when sync a larger table around 1000 TPS https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570926#M198953 <P>This is big bug.</P> Thu, 14 Oct 2021 09:23:16 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-DB-Connect-3-6-Duplicate-Miss-Data-when-sync-a-larger/m-p/570926#M198953 dailv1808 2021-10-14T09:23:16Z