4 messages in com.mysql.lists.clusterRe: Bug #28077
FromSent OnAttachments
Chris Picton09 Jul 2008 02:59 
Chris Picton15 Jul 2008 05:57 
Jonathan Miller15 Jul 2008 11:34 
Chris Picton18 Jul 2008 10:29 
Subject:Re: Bug #28077
From:Chris Picton (lis@tangent.co.za)
Date:07/18/2008 10:29:11 AM
List:com.mysql.lists.cluster

Jonathan Miller wrote:

mysql> truncate ECN_cdr;

I did that, as well as dropping and recreating the table.

After 3 days, The same bug has appeared. I have added info to the bug report, and will follow up there.

Chris Picton wrote:

On Wed, 2008-07-09 at 12:00 +0200, Chris Picton wrote:

I have just added some info to this bug, but cannot change the status from No Feedback to Open, as I am not the original reporter

I am hitting this bug more often than I should (about once a day during my testing phase)

Time: Tuesday 15 July 2008 - 14:43:01 Status: Temporary error, restart node Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug) Error: 2341 Error data: lgman.cpp Error object: LGMAN (Line: 1462) 0x0000000a Program: /usr/sbin/ndbd Pid: 4369 Trace: /var/lib/mysql-cluster/ndb_4_trace.log.3 Version: mysql-5.1.23 ndb-6.2.15 ***EOM***

Bug number is in the subject of this email.

Does anyone have any idea or workarounds for me?

The bug appears to be triggered when updating large amounts of data at a time. (approximately around 50000 rows)

mysql> delete from ECN_cdr limit 50000; Query OK, 50000 rows affected (1 min 2.58 sec)

mysql> delete from ECN_cdr limit 50000; Query OK, 50000 rows affected (8.17 sec)

mysql> delete from ECN_cdr limit 50000; ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER

------------------------------------------------------------------------