[Mediawiki-l] deadlock frequency

[Jim Hu]

We've been getting this a lot lately at EcoliWiki:

> A database query syntax error has occurred. This may indicate a bug  
> in the software. The last attempted database query was:
> INSERT IGNORE INTO `objectcache` (keyname,value,exptime) VALUES  
> ('colipedia:sitenotice','U��N�0D�| 
> �ʗ����Jj7�U��pA���N
�.! 
> ���B�Fow4����_�8�iv�y�V�t(�% 
> (ﰣ(\0#�2j=B�z���6��
������C 
> \'�=�f�G�4�?�ծ�	 
> U 
> � 
> �Ǚ@��tO��x���3γ
���
b��_��2��& 
> \"~#\n���)�9�^��S�g1��� 
> + 
> � 
> a 
> � 
> 5 
> � 
> 8K 
> � 
> #= 
> g 
> � 
> x 
>  
> ^ 
> � 
> 7 
> � 
> | 
> ]M 
> 
 
> W 
> 
 
> � 
> � 
> 
 
> � 
> � 
> � 
>  
> T 
> � 
> *Э 
> � 
> � 
> ˻ 
> � 
> d 
> � 
> Y 
> � 
> kN 
> �z�0UK�Y˦�ɖ
ٞ��m��t����','20080704213140')
> from within function "MediaWikiBagOStuff::_doinsert". MySQL returned  
> error "1213: Deadlock found when trying to get lock; try restarting  
> transaction (trimer.local)".

I'm suspecting that it's related to some kind of optimization I need  
to do on MySQL, but could there be something about the sitenotice that  
causes it?  There's an extension call in the Sitenotice to add an  
image.  Advice would be appreciated.

MediaWiki	1.12.0
PHP	5.2.4 (apache)
MySQL	5.0.41
Mac OSX Server 10.4

Traffic doesn't seem particularly high, and the cpus are not breaking  
a sweat.

Thanks.

JH

=====================================
Jim Hu
Associate Professor
Dept. of Biochemistry and Biophysics
2128 TAMU
Texas A&M Univ.
College Station, TX 77843-2128
979-862-4054