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