Bug #69969 Failing assertion: prebuilt->trx->conc_state == 1 from subselect
Submitted: 9 Aug 2013 5:47 Modified: 7 Feb 2014 2:14
Reporter: Raghavendra Prabhu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.5.33 OS:Any
Assigned to: CPU Architecture:Any
Tags: crash, subselect

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[9 Aug 2013 5:49] Raghavendra Prabhu
RQG Grammar

Attachment: subselect.yy (application/octet-stream, text), 3.00 KiB.

[9 Aug 2013 5:49] Raghavendra Prabhu
Gendata file

Attachment: data.zz (application/octet-stream, text), 1.17 KiB.

[9 Aug 2013 5:50] Raghavendra Prabhu
Full backtrace of the crash.

Attachment: full-bt-of-crash (application/octet-stream, text), 326.99 KiB.

[13 Aug 2013 18:46] Shane Bester
a pseudo-random testcase for the RQG-impaired :)

Attachment: bug69969.c (text/plain), 6.98 KiB.

[4 Sep 2013 20:57] Roel Van de Paar
error log

Attachment: master_6_050913-0654.err (application/octet-stream, text), 69.54 KiB.

[4 Sep 2013 21:10] Roel Van de Paar
thread apply all bt on core

Attachment: gdb_6_050913-0654_STD.txt (text/plain), 87.68 KiB.

[4 Sep 2013 21:11] Roel Van de Paar
thread apply all bt FULL on core

Attachment: gdb_6_050913-0654_FULL.txt (text/plain), 573.69 KiB.