Bug #62116 | Complete cluster crash during INSERT statement | ||
---|---|---|---|
Submitted: | 8 Aug 2011 14:36 | Modified: | 31 Jan 2012 17:23 |
Reporter: | Fabio Valentini | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S1 (Critical) |
Version: | 7.1.15 | OS: | Linux (RHEL5) |
Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[8 Aug 2011 14:36]
Fabio Valentini
[8 Aug 2011 14:56]
Fabio Valentini
ndb_error_reporter generated archive
Attachment: ndb_error_report_20110808165350.tar.bz2 (application/x-bzip2, text), 367.61 KiB.
[8 Aug 2011 15:15]
Fabio Valentini
Additional tests reported below. Same cluster set up and database/table creation, INSERT working: > INSERT INTO bug.t1 VALUES (1,'Test',2,'Test2'); Query OK, 1 row affected (0.01 sec) > TRUNCATE bug.t1; Query OK, 0 rows affected (0.27 sec > INSERT INTO bug.t1 VALUES (1,'Test',2,'Test2'),(1,'Test',2,'Test2'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 > TRUNCATE bug.t1; Query OK, 0 rows affected (0.31 sec) > INSERT INTO bug.t1 VALUES (1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'); Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 INSERT NOT WORKING: > TRUNCATE bug.t1; Query OK, 0 rows affected (0.34 sec) > INSERT INTO bug.t1 VALUES (1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'); ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER Both data nodes crash. Trying with more rows, still cause both data nodes crash: mysql> INSERT INTO bug.t1 VALUES (1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'),(1,'Test',2,'Test2'); ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER and so on...
[8 Aug 2011 15:26]
Fabio Valentini
ndb_error_reporter generated archive - All nodes at 7.1.15
Attachment: ndb_error_report_20110808172339.tar.bz2 (application/x-bzip2, text), 351.58 KiB.
[8 Aug 2011 15:29]
Fabio Valentini
First attached ndb_error_reporter generated archive was related to test performed with sql node at version 7.1.8. Please, find attached the proper ndb_error_reporter generated archive related to tests with all nodes at 7.1.15. The problem is still there, with both version of sql nodes.
[9 Aug 2011 19:55]
Jonas Oreland
Hi Fabio, I tried with your exact config, create-table and insert and could not reproduce. Have you built the cluster your self, or downloaded binaries ? /Jonas
[10 Aug 2011 9:11]
Fabio Valentini
Hi Jonas, I downloaded the RHEL RPMs: MySQL-Cluster-gpl-<package>-7.1.15-1.rhel5.x86_64.rpm Installed on a RHEL 5.4 64bit hosted on a VMware ESXi 4.0 Virtual Machine. I'll try to re-create the VMs . Anyway, for your information, on the same server infrastructure with all nodes at version 7.1.8 there's no crash or problem. I tried version 7.1.8 because we have a cluster at that version in production and we're testing the new 7.1.15 before upgrading. Thanks for you support, Fabio
[16 Aug 2011 9:01]
Jonas Oreland
we found it, and will release a new version asap /Jonas
[16 Aug 2011 12:44]
Jonas Oreland
Fix
Attachment: bug.12873640.patch (application/octet-stream, text), 1.41 KiB.