On Mon, Jan 14, 2013 at 04:58:24PM -0600, Percy Wegmann wrote:Last week we fixed another, (even) less frequent problem. Hopefully this
> Hi Niels,
>
> Sorry about the delay. I grabbed the code from the the Oct2012 branch
> in mercurial, built it and ran the test from http://bugs.monetdb.org/
> show_bug.cgi?id=3210. mserver5 shows a version of 11.13.8.
>
> Sadly, it still fails occasionally. It might be failing less
> frequently than before, but that's just anecdotal - it's always been
> non-deterministic and I haven't run it often enough to come up with a
> statistically significant result.
also solve your concurrency problems.
Niels
>
> Thanks,
> Percy
>
>
> On Mon, Jan 7, 2013 at 8:49 AM, Percy Wegmann <percy@clicksecurity.com>
> wrote:
>
> Hi Niels,
>
> I will do that. It might be a few days before I get to this as
> we're in the middle of testing with the SP2 release, but I'll
> definitely get around to it.
>
> Thanks!
> Percy
>
>
> On Mon, Jan 7, 2013 at 8:44 AM, Niels Nes <Niels.Nes@cwi.nl> wrote:
>
> On Mon, Dec 17, 2012 at 04:59:03PM -0600, Percy Wegmann wrote:
> > Dear MonetDB Team,
> >
> > We're starting to exercise our MonetDB installation more
> heavily now
> > and I've run into a strange issue where I get an occasional
> "COMMIT:
> > failed" message.
> >
> > It seems that the conditions required to produce this are:
> >
> > - Concurrently inserting into two different tables
> > - At the same time, issuing a SELECT COUNT(*) against either
> of those
> > tables
> >
> > I've logged a bug with more detailed information, including a
> Java test
> > case:
> >
> > http://bugs.monetdb.org/show_bug.cgi?id=3210
> >
> > I'm only just starting my investigation, but I suspect that
> COUNT(*)
> > may be the culprit, since other selects like SELECT * don't
> seem to
> > have this problem.
> >
> > Does this ring any bells? Are there any special
> optimizations for
> > COUNT(*) that bypass the underlying BAT and/or have side
> effects on
> > some shared table somewhere that could be causing a
> concurrency
> > violation?
> >
> > Thanks,
>
> Percy
>
> We fixed a problem today which looks very similar too yours.
> Could you
> verify if the fixes checked in to the Oct2012 and Feb2013
> branches also
> solve your problem?
>
> Niels
> >
> > --
> >
> > Percy Wegmann
> > +1 512 637 8500 ext 148
> >
>
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
>
>
> --
> Niels Nes, Centrum Wiskunde & Informatica (CWI)
> Science Park 123, 1098 XG Amsterdam, The Netherlands
> room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl
> url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>
>
>
>
>
> --
>
> Percy Wegmann
> +1 512 637 8500 ext 148
>
>
>
>
> --
>
> Percy Wegmann
> +1 512 637 8500 ext 148
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
--
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list