List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:December 21 2007 9:52am
Subject:Odd item in MySql error log
View as plain text  
MySql 5.0.41
SUSE 10.2
Linux dbms-04-r1 #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 
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.
Odd item in MySql error logBen Clewett21 Dec
  • Re: Odd item in MySql error logMartin Gainty21 Dec