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.

Good Morning Ben

this is an acknowledged bug
http://bugs.mysql.com/bug.php?id=20090
which was fixed in 5.1.22-beta +

can you upgrade?
Martin--
----- Original Message -----
From: "Ben Clewett" <ben@clewett.org.uk>
To: <mysql@lists.mysql.com>
Sent: Friday, December 21, 2007 4:52 AM
Subject: Odd item in MySql error log


> 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.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgainty@hotmail.com
>
>