Bug #34072 | Multi-threaded update off on-disk BLOB data creates inconsistencies/crash | ||
---|---|---|---|
Submitted: | 25 Jan 2008 22:51 | Modified: | 19 Dec 2008 18:22 |
Reporter: | Jeff Wang | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | 5.1.22 | OS: | Any |
Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[25 Jan 2008 22:51]
Jeff Wang
[25 Jan 2008 22:53]
Jeff Wang
Java class that crashes nodes
Attachment: CrashTest.java (, text), 4.66 KiB.
[25 Jan 2008 22:55]
Jeff Wang
I've attached a java class that will insert and update content. Change the connect string in the java file to connect to your mysql. Then, run "java CrashTest insert" to insert data. Then run "java CrashTest update" to start updating. Stop the script at 10-30 second intervals and re-run it. After several runs, errors should occur.
[26 Jan 2008 8:02]
Jonas Oreland
Hi, We fixed a blob inconsistency matching your description (wo/ bug report :( which will be in 5.1.23 but we never (as far as i know) got this to crash Can you 1) upload tracefiles (if it's ndbd crashing) 2) test your program on 5.1.23 (when it's released if not already) /jonas
[28 Jan 2008 18:02]
Jeff Wang
Hi, I've submitted the end of my trace log for the data node crash. The whole log was too large to submit (1.9 MB). The error log said: Time: Monday 28 January 2008 - 09:54:15 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: dblqh/DblqhMain.cpp Error object: DBLQH (Line: 6950) 0x0000000a Program: ndbd Pid: 7641 Trace: /Users/dbsp/work/cluster/data/ndb_2_trace.log.19 Version: Version 5.1.22 (rc) ***EOM*** Version 5.1.23 is not available yet but I'll test when it comes out. thanks
[13 Aug 2008 21:00]
Jonas Oreland
did you retest this on a newer version (maybe 6.2 or 6.3) or did you give up ? /jonas
[13 Aug 2008 23:48]
Jeff Wang
We gave up on this for the moment as it was too a little too unstable for full production use. As I recall, I did try it on 5.1.24 and the problem didn't appear... but that was so many months ago that I can't be sure.