This message was forwarded from developers-l...@monetdb.org. The MonetDB mailing lists have moved to monetdb.org. Please subscribe to developers-l...@monetdb.org, and unsubscribe from this list. See: http://mail.monetdb.org/mailman/listinfo/developers-list
Send developers-list mailing list submissions to developers-l...@monetdb.org To subscribe or unsubscribe via the World Wide Web, visit http://mail.monetdb.org/mailman/listinfo/developers-list or, via email, send a message with subject or body 'help' to developers-list-requ...@monetdb.org You can reach the person managing the list at developers-list-ow...@monetdb.org When replying, please edit your Subject line so it is more specific than "Re: Contents of developers-list digest..." Today's Topics: 1. Re: Unique key constraint violation violated (Niels Nes) ---------------------------------------------------------------------- Message: 1 Date: Fri, 28 Dec 2012 12:25:06 +0100 From: Niels Nes <niels....@cwi.nl> To: "Communication channel for developers of the MonetDB suite." <developers-l...@monetdb.org> Subject: Re: Unique key constraint violation violated Message-ID: <20121228112506.ga18...@niels.cwi.nl> Content-Type: text/plain; charset="utf-8" On Fri, Dec 28, 2012 at 02:04:52AM -0800, Tapomay Dey wrote: > Confirmed that it occurs even with MonetDataSource. > Also tried switching to July12 SP2. > > Need pointers to diagnosing it further. > Any ideas? To beable to debug this problem we need a 'script' which triggers the bug. Given you setup this probably isn't very easy. Niels > > ??????????????????????????????????????????????????????????????????????? > From: Tapomay Dey <tapo...@yahoo.com> > To: "developers-l...@monetdb.org" <developers-l...@monetdb.org> > Sent: Thursday, December 27, 2012 9:15 PM > Subject: Unique key constraint violation violated > > Is this a known issue that you are working on? If so please give me the > bug id where I would know when its fixed. > > The case is as follows: > I have a table with 32 columns with unique key on 3 of them. > I am running live ETLs for putting data into monetdb. These ETLs are > generating sql insert scripts.(inserts/updates/ddls) > Using JDBC and c3p0 connection pooling. > Have developed an external wrapper module to achieve master-master > replication. > One common consistency check would be a count*. > > Observation: > Queries are run in batches of 100 inserts clubbed into a single insert. > I do a select count(*) after each batch of 100. > After running 9100 queries the count* on one DB was 9100 but in the > other was 9200. > The second DB had 100 records that were duplicates of 8901-9000. > It means when I inserted 9001 to 9100 the previous batch went into the > store again with it and somehow surpassed the unique key constraint > check. > I have also observed another case where count(*) gave less results than > actual no. of rows in the DB. > > REQUEST: > Just want to confirm if such kind of issues are part of active > development. > Otherwise it would be really difficult for me to push monetdb usage > into production. > > Will try again with MonetDataSource instead of c3p0. But I doubt if the > issues are client side or connection-related. > Plz note that the keys for which this occurs is random and thus I > concluded it's not a data issue. > > Regards, > Tapomay Dey. > Software Design Engg. > Sokrati Inc. > Email: tapomayATsokratiDOTcom > > _______________________________________________ > developers-list mailing list > developers-l...@monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > > > _______________________________________________ > developers-list mailing list > developers-l...@monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list -- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4...@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: niels....@cwi.nl -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 198 bytes Desc: not available URL: <http://mail.monetdb.org/pipermail/developers-list/attachments/20121228/2d1a8246/attachment.sig> ------------------------------ _______________________________________________ developers-list mailing list developers-l...@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list End of developers-list Digest, Vol 4, Issue 20 ********************************************** ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122912 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers