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" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]