Bug #7318 ERROR 1297 (HY000) at line 340: Got temporary error 270 'Transaction aborted du
Submitted: 15 Dec 2004 14:45 Modified: 17 Dec 2004 22:24
Reporter: Olivier Kaloudoff Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:4.1.8 OS:Linux (linux x86)
Assigned to: Tomas Ulin CPU Architecture:Any

[15 Dec 2004 14:45] Olivier Kaloudoff
Description:
Using latest bk pull from yesterday night,

    playing with 2 nodes in the following setup breaks an established connection
to mysqld using the command line client:

-- NDB Cluster -- Management Client --
Connected to Management Server at: mgm:2200
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.5.3  (Version: 4.1.8, Nodegroup: 0, Master)
id=3    @192.168.5.4  (Version: 4.1.8, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.2.199  (Version: 4.1.8)

[mysqld(API)]   2 node(s)
id=4    @192.168.5.3  (Version: 4.1.8)
id=5    @192.168.5.4  (Version: 4.1.8)

ERROR 1297 (HY000) at line 340: Got temporary error 270 'Transaction aborted due to node shutdown' from ndbcluster

NDBd on ID3 Crashed and gerenated a trace, available on request:

root@lb1d:/var/lib/mysql-cluster# ls -l *trace*
-rw-r--r--  1 root root 1849692 Dec 15 14:38 ndb_3_trace.log.1

How to repeat:
Start a 2 nodes setup with 2 machines, One API, One DB on each.

Source a big sql requests file.

Stop the "Slave" DB node from the management server.
[17 Dec 2004 8:18] Olivier Kaloudoff
Hi,

   I was unable to reproduce the DB node crash after a node STOP or node RESTART (using a more recent bk pull). So you can close this bug.

  the temporary error message seems to be normal and acceptable for the moment.

Kind regards,

Olivier
[17 Dec 2004 22:24] Tomas Ulin
Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.