threads/136345: Recursive read rwlocks in thread A cause deadlock with write lock in thread B

[Nick Esborn]

On Jul 16, 2009, at 10:53 AM, Attilio Rao wrote:

> 2009/7/16 Nick Esborn <nick at desert.net>:
>>
>>
>> KDB, DDB, SCHED_ULE, and PREEMPTION are already turned on.  I will  
>> try
>> FULL_PREEMPTION, INVARIANT_SUPPORT, INVARIANTS, and WITNESS, but  
>> when I
>> first upgraded to 8.0, this server was unable to handle its  
>> workload with
>> the INVARIANTS and WITNESS options turned on.
>
> What do you mean with 'unable'? What was happening precisely?

System time would rise during periods of peak demand, and the system  
would quickly fall behind on its workload of queries.

However, I have some hardware I can dedicate to this, and only run the  
one MySQL data set which exhibits this problem.  That should be enough  
of a workload reduction to allow the server to keep up even with all  
the above options turned on.

-nick

>
>> Also, it can take a while for it to become clear that the deadlock  
>> has
>> occurred -- usually our monitoring picks it up when replication falls
>> behind.  So it may be 15-20 minutes after the deadlock that I am  
>> able to run
>> the above db commands.  Of course the thread will still be  
>> deadlocked.
>> Hopefully that doesn't reduce the value of the data obtained.
>
> It should be still fine.
>
> Thanks,
> Attilio
>
>
> -- 
> Peace can only be achieved by understanding - A. Einstein

--
nick at desert.net - all messages cryptographically signed

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part
Url : http://lists.freebsd.org/pipermail/freebsd-threads/attachments/20090716/0bfaf912/PGP.pgp