| Bug #13893 | INSERTION BLOCKED (WITH TRIGGER) MEANWHILE A BIG SELECT ON THE TABLE IS RUNNING | ||
|---|---|---|---|
| Submitted: | 10 Oct 2005 10:59 | Modified: | 24 May 2006 12:17 |
| Reporter: | ANGEL MARTIN | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Locking | Severity: | S1 (Critical) |
| Version: | 5.0.13/5.0.16 BK source | OS: | Windows (WINXP/Linux) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
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
[10 Oct 2005 13:56]
ANGEL MARTIN
[10 Oct 2005 14:49]
ANGEL MARTIN
Second file ot the compressed file wrkcomisics (2/9)
Attachment: wrkcomisics.part002.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:50]
ANGEL MARTIN
third file ot the compressed file wrkcomisics (3/9)
Attachment: wrkcomisics.part003.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:50]
ANGEL MARTIN
fourth file ot the compressed file wrkcomisics (4/9)
Attachment: wrkcomisics.part004.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:50]
ANGEL MARTIN
fifth file ot the compressed file wrkcomisics (5/9)
Attachment: wrkcomisics.part005.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:51]
ANGEL MARTIN
sixth file ot the compressed file wrkcomisics (6/9)
Attachment: wrkcomisics.part006.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:52]
ANGEL MARTIN
seventh file ot the compressed file wrkcomisics (7/9)
Attachment: wrkcomisics.part007.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:52]
ANGEL MARTIN
eighth file ot the compressed file wrkcomisics (8/9)
Attachment: wrkcomisics.part008.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 14:53]
ANGEL MARTIN
nineth file ot the compressed file wrkcomisics (9/9)
Attachment: wrkcomisics.part009.rar (application/octet-stream, text), 150.48 KiB.
[10 Oct 2005 15:01]
ANGEL MARTIN
wrkcash table (1/23)
Attachment: wrkcash.part0001.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:01]
ANGEL MARTIN
wrkcash table (2/23)
Attachment: wrkcash.part0002.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:02]
ANGEL MARTIN
wrkcash table (3/23)
Attachment: wrkcash.part0003.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:02]
ANGEL MARTIN
wrkcash table (4/23)
Attachment: wrkcash.part0004.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:03]
ANGEL MARTIN
wrkcash table (5/23)
Attachment: wrkcash.part0005.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:03]
ANGEL MARTIN
wrkcash table (6/23)
Attachment: wrkcash.part0006.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:03]
ANGEL MARTIN
wrkcash table (7/23)
Attachment: wrkcash.part0007.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:04]
ANGEL MARTIN
wrkcash table (8/23)
Attachment: wrkcash.part0008.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:04]
ANGEL MARTIN
wrkcash table (9/23)
Attachment: wrkcash.part0009.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:04]
ANGEL MARTIN
wrkcash table (10/23)
Attachment: wrkcash.part0010.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:05]
ANGEL MARTIN
wrkcash table (11/23)
Attachment: wrkcash.part0011.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:05]
ANGEL MARTIN
wrkcash table (12/23)
Attachment: wrkcash.part0012.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:05]
ANGEL MARTIN
wrkcash table (13/23)
Attachment: wrkcash.part0013.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:05]
ANGEL MARTIN
wrkcash table (14/23)
Attachment: wrkcash.part0014.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:06]
ANGEL MARTIN
wrkcash table (15/23)
Attachment: wrkcash.part0015.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:06]
ANGEL MARTIN
wrkcash table (16/23)
Attachment: wrkcash.part0016.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:06]
ANGEL MARTIN
wrkcash table (17/23)
Attachment: wrkcash.part0017.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:07]
ANGEL MARTIN
wrkcash table (18/23)
Attachment: wrkcash.part0018.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:07]
ANGEL MARTIN
wrkcash table (19/23)
Attachment: wrkcash.part0019.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:07]
ANGEL MARTIN
wrkcash table (20/23)
Attachment: wrkcash.part0020.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:08]
ANGEL MARTIN
wrkcash table (21/23)
Attachment: wrkcash.part0021.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:08]
ANGEL MARTIN
wrkcash table (22/23)
Attachment: wrkcash.part0022.rar (application/octet-stream, text), 195.31 KiB.
[10 Oct 2005 15:08]
ANGEL MARTIN
wrkcash table (23/23)
Attachment: wrkcash.part0023.rar (application/octet-stream, text), 117.05 KiB.
[10 Oct 2005 15:15]
ANGEL MARTIN
More tables needed for the problem.
Attachment: MORETABLES.zip (application/zip, text), 36.07 KiB.
[10 Oct 2005 15:16]
ANGEL MARTIN
Sentences in which there is the problem
Attachment: sentences.txt (text/plain), 2.65 KiB.
[13 Oct 2005 6:17]
ANGEL MARTIN
wrkcash (1/24)
Attachment: wrkcash.part0001.exe (application/x-msdownload, text), 195.31 KiB.
[13 Oct 2005 6:17]
ANGEL MARTIN
wrkcash (2/24)
Attachment: wrkcash.part0002.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:17]
ANGEL MARTIN
wrkcash (3/24)
Attachment: wrkcash.part0003.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:18]
ANGEL MARTIN
wrkcash (4/24)
Attachment: wrkcash.part0004.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:18]
ANGEL MARTIN
wrkcash (5/24)
Attachment: wrkcash.part0005.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:18]
ANGEL MARTIN
wrkcash (6/24)
Attachment: wrkcash.part0006.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:19]
ANGEL MARTIN
wrkcash (7/24)
Attachment: wrkcash.part0007.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:19]
ANGEL MARTIN
wrkcash (8/24)
Attachment: wrkcash.part0008.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:19]
ANGEL MARTIN
wrkcash (9/24)
Attachment: wrkcash.part0009.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:19]
ANGEL MARTIN
wrkcash (10/24)
Attachment: wrkcash.part0010.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:20]
ANGEL MARTIN
wrkcash (11/24)
Attachment: wrkcash.part0011.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:20]
ANGEL MARTIN
wrkcash (12/24)
Attachment: wrkcash.part0012.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:20]
ANGEL MARTIN
wrkcash (13/24)
Attachment: wrkcash.part0013.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:21]
ANGEL MARTIN
wrkcash (14/24)
Attachment: wrkcash.part0014.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:21]
ANGEL MARTIN
wrkcash (15/24)
Attachment: wrkcash.part0015.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:21]
ANGEL MARTIN
wrkcash (16/24)
Attachment: wrkcash.part0016.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:22]
ANGEL MARTIN
wrkcash (17/24)
Attachment: wrkcash.part0017.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:22]
ANGEL MARTIN
wrkcash (18/24)
Attachment: wrkcash.part0018.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:23]
ANGEL MARTIN
wrkcash (19/24)
Attachment: wrkcash.part0019.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:23]
ANGEL MARTIN
wrkcash (20/24)
Attachment: wrkcash.part0020.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:24]
ANGEL MARTIN
wrkcash (21/24)
Attachment: wrkcash.part0021.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:24]
ANGEL MARTIN
wrkcash (22/24)
Attachment: wrkcash.part0022.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:24]
ANGEL MARTIN
wrkcash (23/24)
Attachment: wrkcash.part0023.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:25]
ANGEL MARTIN
wrkcash (24/24)
Attachment: wrkcash.part0024.rar (application/octet-stream, text), 191.53 KiB.
[13 Oct 2005 6:37]
ANGEL MARTIN
wrkcomisics (1/23)
Attachment: wrkcomisics.part0001.exe (application/x-msdownload, text), 195.31 KiB.
[13 Oct 2005 6:37]
ANGEL MARTIN
wrkcomisics (2/23)
Attachment: wrkcomisics.part0002.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:38]
ANGEL MARTIN
wrkcomisics (3/23)
Attachment: wrkcomisics.part0003.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:38]
ANGEL MARTIN
wrkcomisics (4/23)
Attachment: wrkcomisics.part0004.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:38]
ANGEL MARTIN
wrkcomisics (5/23)
Attachment: wrkcomisics.part0005.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:39]
ANGEL MARTIN
wrkcomisics (6/23)
Attachment: wrkcomisics.part0006.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:39]
ANGEL MARTIN
wrkcomisics (7/23)
Attachment: wrkcomisics.part0007.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:39]
ANGEL MARTIN
wrkcomisics (8/23)
Attachment: wrkcomisics.part0008.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:40]
ANGEL MARTIN
wrkcomisics (9/23)
Attachment: wrkcomisics.part0009.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:40]
ANGEL MARTIN
wrkcomisics (10/23)
Attachment: wrkcomisics.part0010.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:40]
ANGEL MARTIN
wrkcomisics (11/23)
Attachment: wrkcomisics.part0011.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:41]
ANGEL MARTIN
wrkcomisics (12/23)
Attachment: wrkcomisics.part0012.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:41]
ANGEL MARTIN
wrkcomisics (13/23)
Attachment: wrkcomisics.part0013.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:42]
ANGEL MARTIN
wrkcomisics (14/23)
Attachment: wrkcomisics.part0014.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:42]
ANGEL MARTIN
wrkcomisics (15/23)
Attachment: wrkcomisics.part0015.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:42]
ANGEL MARTIN
wrkcomisics (16/23)
Attachment: wrkcomisics.part0016.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:43]
ANGEL MARTIN
wrkcomisics (17/23)
Attachment: wrkcomisics.part0017.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:43]
ANGEL MARTIN
wrkcomisics (18/23)
Attachment: wrkcomisics.part0018.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:43]
ANGEL MARTIN
wrkcomisics (19/23)
Attachment: wrkcomisics.part0019.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:44]
ANGEL MARTIN
wrkcomisics (20/23)
Attachment: wrkcomisics.part0020.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:45]
ANGEL MARTIN
wrkcomisics (21/23)
Attachment: wrkcomisics.part0021.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:45]
ANGEL MARTIN
wrkcomisics (22/23)
Attachment: wrkcomisics.part0022.rar (application/octet-stream, text), 195.31 KiB.
[13 Oct 2005 6:45]
ANGEL MARTIN
wrkcomisics (23/23)
Attachment: wrkcomisics.part0023.rar (application/octet-stream, text), 19.91 KiB.
[14 Oct 2005 6:32]
ANGEL MARTIN
trigger that makes the problem and the view for SELECT sentence
Attachment: trigger_and_view.txt (text/plain), 3.19 KiB.
[14 Oct 2005 6:33]
ANGEL MARTIN
Table needed for the view
Attachment: pflradm.txt (text/plain), 4.13 KiB.
[14 Oct 2005 6:33]
ANGEL MARTIN
Table needed for the select sentence.
Attachment: pfrcnto.txt (text/plain), 76.92 KiB.
[21 Oct 2005 6:45]
ANGEL MARTIN
PFDTDES FILE
Attachment: pfdtdes.txt (text/plain), 4.05 KiB.
[21 Oct 2005 8:40]
ANGEL MARTIN
file that contents the result of the sentence
Attachment: result_of_the_sentence.txt (text/plain), 62.87 KiB.
