Bug #60516 UPDATE within a function fails and causes infinite loop
Submitted: 17 Mar 2011 15:26 Modified: 24 Nov 2011 11:33
Reporter: John Crowley Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:5.5.10 OS:Linux (Fedora 14)
Assigned to: 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:

[17 Mar 2011 15:31] John Crowley
getUID function

Attachment: mysql.getuid.txt (text/plain), 1.71 KiB.

[18 Apr 2011 21:30] John Crowley
Last 100 lines of general log (full log was 1.6G of these lines)

Attachment: tail.SAVE (application/octet-stream, text), 11.96 KiB.

[26 Apr 2011 23:42] John Crowley
getUID function w debug statements

Attachment: getUID.txt (text/plain), 3.30 KiB.

[26 Apr 2011 23:43] John Crowley
Java code log messages after getUID() fails

Attachment: getUID.fail.txt (text/plain), 10.80 KiB.

[28 Apr 2011 20:31] John Crowley
getUID as a PROCEDURE instead of FUNCTION

Attachment: getUIDProc.txt (text/plain), 3.37 KiB.