Bug #3984 Subquery w/foreign keys crash server
Submitted: 3 Jun 2004 16:19 Modified: 24 Jun 2004 20:59
Reporter: Christopher Jeffus Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.2 OS:Linux (Red Hat AS 2.1)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

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:

[3 Jun 2004 16:32] Christopher Jeffus
Resolved Stack trace

Attachment: mysqld.stack (text/plain), 1.05 KiB.

[3 Jun 2004 16:33] Christopher Jeffus
Error log

Attachment: hvcwy0918.corp.acxiom.net.err (text/plain), 4.24 KiB.

[3 Jun 2004 16:34] Christopher Jeffus
Table create script

Attachment: create_tables.sql (application/octet-stream, text), 937 bytes.

[3 Jun 2004 16:34] Christopher Jeffus
Problematic query

Attachment: prob_query.sql (application/octet-stream, text), 814 bytes.

[3 Jun 2004 16:35] Christopher Jeffus
My.cnf

Attachment: my.cnf (application/octet-stream, text), 2.54 KiB.

[3 Jun 2004 16:44] Christopher Jeffus
compressed trace file (had to gut it in order to get under the 200K upload limit)

Attachment: mysqld.zip (application/x-zip-compressed, text), 22.23 KiB.