This message was forwarded from [email protected]. The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
[email protected], and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/developers-list
Send developers-list mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
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 <[email protected]>
To: "Communication channel for developers of the MonetDB suite."
<[email protected]>
Subject: Re: Unique key constraint violation violated
Message-ID: <[email protected]>
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 <[email protected]>
> To: "[email protected]" <[email protected]>
> 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
> [email protected]
> http://mail.monetdb.org/mailman/listinfo/developers-list
>
>
> _______________________________________________
> developers-list mailing list
> [email protected]
> 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:[email protected]
url: http://www.cwi.nl/~niels e-mail: [email protected]
-------------- 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
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
