From: Ben Clewett
Date: December 21 2007 9:52am
Subject: Odd item in MySql error log
List-Archive: http://lists.mysql.com/mysql/210560
Message-Id: <476B8CED.8030109@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

MySql 5.0.41
SUSE 10.2
Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 
x86_64 x86_64 x86_64 GNU/Linux

Dear MySql,

I have an odd item in my error log, I wonder if you can tell me what 
this means?  Also whether should do anything about it?

(This table once corrupted before, I could not start MySql, and had 
several hours downtime recovering it...)


071219  0:00:15  InnoDB: Error: trying to declare trx to enter InnoDB, but
InnoDB: it already is declared.
TRANSACTION 0 3825296174, ACTIVE 0 sec, process no 6929, OS thread id 
1141946688, thread declared inside InnoDB 0
mysql tables in use 1, locked 1
1 lock struct(s), heap size 368
MySQL thread id 16, query id 158 fls-16-03.roadtech.private 172.16.14.12 
sdi update
INSERT INTO terminal_log (mem_code, terminal_id, last_call, latitude, 
longitude, speed_knots, course, cablink_string, ip_addr, temperature) 
VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' , 
'5.15055649999999900501e+01' , '-3.69621666666666681689e-01' , 
'8.00000000000000016653e-02' , '1.0

Many thanks!

Ben Clewett.