| Bug #46947 | Embedded SELECT without FOR UPDATE is causing a lock | ||
|---|---|---|---|
| Submitted: | 26 Aug 2009 20:59 | Modified: | 14 Oct 2010 13:34 |
| Reporter: | Bob Hansen | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Locking | Severity: | S2 (Serious) |
| Version: | 5.1.35, 5.1.37, 5.1, next-mr bzr | OS: | Any |
| Assigned to: | Dmitry Lenev | CPU Architecture: | Any |
| Tags: | crash, embedded select locking for update, regression | ||
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[26 Aug 2009 21:01]
Bob Hansen
[26 Aug 2009 21:01]
Bob Hansen
ClientB server information.
Attachment: server2_noip.JPG (image/jpeg, text), 67.09 KiB.
[27 Aug 2009 21:24]
Bob Hansen
Error log for server1.
Attachment: server1 error log.JPG (image/jpeg, text), 113.29 KiB.
[27 Aug 2009 21:26]
Bob Hansen
Error log for server1.
Attachment: distadmin.biglake.k12.mn.us.err (application/octet-stream, text), 4.07 KiB.
[28 Aug 2009 14:44]
Bob Hansen
Output of SHOW INNODB STATUS.
Attachment: example.JPG (image/jpeg, text), 113.57 KiB.
[10 Sep 2009 18:40]
Bob Hansen
Example Backup file.
Attachment: lock testing 20090910 1337.sql (application/octet-stream, text), 1.88 KiB.
[10 Sep 2009 18:50]
Bob Hansen
Another client, same issue, also MacOS X Server edition.
Attachment: server3_noip.JPG (image/jpeg, text), 123.33 KiB.
