select avg force key never finishes (by vadim)

Bug #936409 reported by Henrik Ingo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
New
Undecided
Unassigned

Bug Description

Vadim reported this on drizzle-discuss, using Drizzle 7 RPMs.

> ( mysql -e "select avg(id) from sbtest$i FORCE KEY (PRIMARY); " sbtest
> ) > $OUTDIR/warmup.${i}.out 2>&1 &
>
> This is 16 connections running in parallel.
>
> This process never finished in drizzle,
> as it seems it was serialized somewhere and I saw only 1 thread running.

All threads seem to be either in
pthread_cond_wait or pthread_cond_timedwait

Revision history for this message
Stewart Smith (stewart) wrote : Re: [Bug 936409] [NEW] select avg force key never finishes (by vadim)

On Sun, 19 Feb 2012 18:01:44 -0000, Henrik Ingo <email address hidden> wrote:
> All threads seem to be either in
> pthread_cond_wait or pthread_cond_timedwait

That's pretty interesting. Do we know on what mutex?

--
Stewart Smith

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.