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:	None
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

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:

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

One of the files needed for the problem

Attachment: pfpreev.zip (application/zip, text), 201.81 KiB.

Second file ot the compressed file wrkcomisics (2/9)

Attachment: wrkcomisics.part002.rar (application/octet-stream, text), 195.31 KiB.

third file ot the compressed file wrkcomisics (3/9)

Attachment: wrkcomisics.part003.rar (application/octet-stream, text), 195.31 KiB.

fourth file ot the compressed file wrkcomisics (4/9)

Attachment: wrkcomisics.part004.rar (application/octet-stream, text), 195.31 KiB.

fifth file ot the compressed file wrkcomisics (5/9)

Attachment: wrkcomisics.part005.rar (application/octet-stream, text), 195.31 KiB.

sixth file ot the compressed file wrkcomisics (6/9)

Attachment: wrkcomisics.part006.rar (application/octet-stream, text), 195.31 KiB.

seventh file ot the compressed file wrkcomisics (7/9)

Attachment: wrkcomisics.part007.rar (application/octet-stream, text), 195.31 KiB.

eighth file ot the compressed file wrkcomisics (8/9)

Attachment: wrkcomisics.part008.rar (application/octet-stream, text), 195.31 KiB.

nineth file ot the compressed file wrkcomisics (9/9)

Attachment: wrkcomisics.part009.rar (application/octet-stream, text), 150.48 KiB.

wrkcash table (1/23)

Attachment: wrkcash.part0001.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (2/23)

Attachment: wrkcash.part0002.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (3/23)

Attachment: wrkcash.part0003.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (4/23)

Attachment: wrkcash.part0004.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (5/23)

Attachment: wrkcash.part0005.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (6/23)

Attachment: wrkcash.part0006.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (7/23)

Attachment: wrkcash.part0007.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (8/23)

Attachment: wrkcash.part0008.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (9/23)

Attachment: wrkcash.part0009.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (10/23)

Attachment: wrkcash.part0010.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (11/23)

Attachment: wrkcash.part0011.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (12/23)

Attachment: wrkcash.part0012.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (13/23)

Attachment: wrkcash.part0013.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (14/23)

Attachment: wrkcash.part0014.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (15/23)

Attachment: wrkcash.part0015.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (16/23)

Attachment: wrkcash.part0016.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (17/23)

Attachment: wrkcash.part0017.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (18/23)

Attachment: wrkcash.part0018.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (19/23)

Attachment: wrkcash.part0019.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (20/23)

Attachment: wrkcash.part0020.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (21/23)

Attachment: wrkcash.part0021.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (22/23)

Attachment: wrkcash.part0022.rar (application/octet-stream, text), 195.31 KiB.

wrkcash table (23/23)

Attachment: wrkcash.part0023.rar (application/octet-stream, text), 117.05 KiB.

More tables needed for the problem.

Attachment: MORETABLES.zip (application/zip, text), 36.07 KiB.

Sentences in which there is the problem

Attachment: sentences.txt (text/plain), 2.65 KiB.

wrkcash (1/24)

Attachment: wrkcash.part0001.exe (application/x-msdownload, text), 195.31 KiB.

wrkcash (2/24)

Attachment: wrkcash.part0002.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (3/24)

Attachment: wrkcash.part0003.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (4/24)

Attachment: wrkcash.part0004.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (5/24)

Attachment: wrkcash.part0005.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (6/24)

Attachment: wrkcash.part0006.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (7/24)

Attachment: wrkcash.part0007.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (8/24)

Attachment: wrkcash.part0008.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (9/24)

Attachment: wrkcash.part0009.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (10/24)

Attachment: wrkcash.part0010.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (11/24)

Attachment: wrkcash.part0011.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (12/24)

Attachment: wrkcash.part0012.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (13/24)

Attachment: wrkcash.part0013.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (14/24)

Attachment: wrkcash.part0014.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (15/24)

Attachment: wrkcash.part0015.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (16/24)

Attachment: wrkcash.part0016.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (17/24)

Attachment: wrkcash.part0017.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (18/24)

Attachment: wrkcash.part0018.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (19/24)

Attachment: wrkcash.part0019.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (20/24)

Attachment: wrkcash.part0020.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (21/24)

Attachment: wrkcash.part0021.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (22/24)

Attachment: wrkcash.part0022.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (23/24)

Attachment: wrkcash.part0023.rar (application/octet-stream, text), 195.31 KiB.

wrkcash (24/24)

Attachment: wrkcash.part0024.rar (application/octet-stream, text), 191.53 KiB.

wrkcomisics (1/23)

Attachment: wrkcomisics.part0001.exe (application/x-msdownload, text), 195.31 KiB.

wrkcomisics (2/23)

Attachment: wrkcomisics.part0002.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (3/23)

Attachment: wrkcomisics.part0003.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (4/23)

Attachment: wrkcomisics.part0004.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (5/23)

Attachment: wrkcomisics.part0005.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (6/23)

Attachment: wrkcomisics.part0006.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (7/23)

Attachment: wrkcomisics.part0007.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (8/23)

Attachment: wrkcomisics.part0008.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (9/23)

Attachment: wrkcomisics.part0009.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (10/23)

Attachment: wrkcomisics.part0010.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (11/23)

Attachment: wrkcomisics.part0011.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (12/23)

Attachment: wrkcomisics.part0012.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (13/23)

Attachment: wrkcomisics.part0013.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (14/23)

Attachment: wrkcomisics.part0014.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (15/23)

Attachment: wrkcomisics.part0015.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (16/23)

Attachment: wrkcomisics.part0016.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (17/23)

Attachment: wrkcomisics.part0017.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (18/23)

Attachment: wrkcomisics.part0018.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (19/23)

Attachment: wrkcomisics.part0019.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (20/23)

Attachment: wrkcomisics.part0020.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (21/23)

Attachment: wrkcomisics.part0021.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (22/23)

Attachment: wrkcomisics.part0022.rar (application/octet-stream, text), 195.31 KiB.

wrkcomisics (23/23)

Attachment: wrkcomisics.part0023.rar (application/octet-stream, text), 19.91 KiB.

trigger that makes the problem and the view for SELECT sentence

Attachment: trigger_and_view.txt (text/plain), 3.19 KiB.

Table needed for the view

Attachment: pflradm.txt (text/plain), 4.13 KiB.

Table needed for the select sentence.

Attachment: pfrcnto.txt (text/plain), 76.92 KiB.

PFDTDES FILE

Attachment: pfdtdes.txt (text/plain), 4.05 KiB.

file that contents the result of the sentence

Attachment: result_of_the_sentence.txt (text/plain), 62.87 KiB.

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.