Bug #25493 Data Node Shutdown Initiated by signal 0. Caused by error 2341
Submitted: 9 Jan 2007 14:56 Modified: 8 May 2007 7:02
Reporter: Thomas Zahari
Status: Duplicate
Category:Server: Cluster Severity:S1 (Critical)
Version:5.0.27 OS:Linux (Debian)
Assigned to: Jonas Oreland Target Version:
Tags: 2341, 64bit, amd64, Debian, cluster

[9 Jan 2007 14:56] Thomas Zahari 
Description:
Hello,

we have a mysql cluster with 2 MySQL frontend server and 2 MySQL datanode server.
Because of many problems with one datanode we stopped one datanode.

Now we have two times this problem on the other (running) datanode:

2007-01-08 18:35:37 [ndbd] INFO     -- Configuration fetched at mysql1 port 1186
2007-01-08 18:35:38 [ndbd] INFO     -- Start initiated (version 5.0.27)
2007-01-09 13:32:33 [ndbd] INFO     -- Error handler shutting down system
2007-01-09 13:32:34 [ndbd] INFO     -- Error handler shutdown completed - exiting
2007-01-09 13:32:34 [ndbd] ALERT    -- Node 3: Forced node shutdown completed. Initiated
by signal 0. Caused by error 2341: 'Internal program error (failed dbrequire)(Internal
error, programming error or missing error message, please report a bug). Temporary error,
restart node'.

Then we must start the datanode manually again.

How to repeat:
Dont know, because we have a few developer that working on the cluster.
[10 Jan 2007 2:16] Jonas Oreland 
Hi,

these tracefiles look really "interesting",
is this in any way reproducable?

/Jonas
[10 Jan 2007 9:16] Thomas Zahari 
Hello Jonas,

no sorry. I asked every body but they all are doing normal querys on the database.
When I should knew the way to repreduce this error, then I will inform you.

Regards
Thomas
[10 Jan 2007 11:46] Thomas Zahari 
I still investigating in this issue.
Unfortunately nobody can help me.
Do you have any clue from the trace files?
All help is appreciated.

/Thomas
[10 Jan 2007 12:42] Jonas Oreland 
Hi,

It looks like it's somthing related to auto-increment.
Maybe it helps....

/Jonas

jonas notes:
It looks like a really rare combination of TUPKEY_REF and LCP start.
The table used is 0 -> using auto-increment.
[8 May 2007 7:02] Jonas Oreland 
closing as duplicate of 27437