I still think you should use the same columns for searching for the duplicate that cause the collision. Using col4 seem problematic. Can you change the code to use col2 and col3?
On 12/1/2010 8:24 AM, Hemant Shah wrote: > This is a single thread/process. No other thread or process is accessing the > data. > > This is a single process that reads data from message queue and dumps into > database to look for duplicate rows. > > The problem occurs for some rows only (about 3 to 5 an hour). > > > Hemant Shah > E-mail: hj...@yahoo.com > > > --- On Wed, 12/1/10, Jim Morris<jmor...@bearriver.com> wrote: > >> From: Jim Morris<jmor...@bearriver.com> >> Subject: Re: [sqlite] Select fails even though data is in the table. >> To: sqlite-users@sqlite.org >> Date: Wednesday, December 1, 2010, 10:15 AM >> If you have another thread running >> that deletes or modifies the table, >> then move the commit to after the select for duplicate to >> ensure >> transactional integrity. >> >> On 12/1/2010 8:10 AM, Black, Michael (IS) wrote: >>> The problem is probably in the bind calls that you are >> not showing. >>> If you care to share them we may be able to help. >>> >>> Michael D. Black >>> Senior Scientist >>> Advanced Analytics Directorate >>> Northrop Grumman Information Systems >>> >>> >>> ________________________________ >>> >>> From: sqlite-users-boun...@sqlite.org >> on behalf of Hemant Shah >>> Sent: Wed 12/1/2010 10:08 AM >>> To: General Discussion of SQLite Database >>> Subject: EXTERNAL:Re: [sqlite] Select fails even >> though data is in the table. >>> >>> >>> The unique key is col3 and col4 (SeqNum and MD5Sum). >>> >>> If the insert fails for this unique key then col4 >> should be the same. >>> It should find the row for the even if I select for >> col4 only. >>> Hemant Shah >>> E-mail: hj...@yahoo.com >>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
