392926 - attached file is automatically deleted

Status: VERIFIED INVALID

(Bugzilla :: Attachments & Requests, defect)

Description

[Nelson Theves]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; pt-BR; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Build Identifier: version 3.0

After attach a specific file (AL3406.pb), Bugzilla returns one error and the attached file is automatically deleted. The bug is commited but a message is presented for attached file ("The content of this attachment has been deleted.").
See "Additional Information" for more information about returned message.
I tried to attach bigger files than this one and was possible.

Reproducible: Always

Steps to Reproduce:
1. uncompress the file attached to this bug
2. create a new bug
3. try to attach the uncompressed file AL3406.pb



Software error:

DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes [for Statement "INSERT INTO attach_data
                         (id, thedata) VALUES (302, ?)"] at Bugzilla/Attachment.pm line 807
	Bugzilla::Attachment::insert_attachment_for_bug('Bugzilla::Attachment', '', 'Bugzilla::Bug=HASH(0x60837c0)', 'Bugzilla::User=HASH(0x5f668d8)', '2007-08-20 16:36:01', 'REF(0x53b9738)') called at C:/Demandas/Bugzilla/post_bug.cgi line 190

For help, please send mail to the webmaster ([e-mail]), giving this error message and the time and date of the error.

Comment 1

[Nelson Theves]

Attachment: compressed file with the AL3406.pb file

Comment 2

[Frédéric Buclin]

what's the value of 'max_allowed_packet', and what are the size of attachments you try to insert? If the attachment is too big for your DB, you can use the "Big File" option when inserting the attachment. This will store it in a folder instead of in the DB.

Comment 3

[Frédéric Buclin]

We don't have enough information to go further.

Comment 4

[Nelson Theves]

Did you try to reproduce the problem, following the steps I listed?
Try to reproduce before change status to resolved... ohhh, you are limiting Bugzilla attached files to 300kb, so I can't reproduce the problem!

Comment 5

[Nelson Theves]

More informations:
- The value of 'max_allowed_packet' is 1M.
- The size of the AL3406.pb file is less than 1M (642KB).
- I tried to attach another file (a BMP file), bigger than AL3406.pb, and was possible (I wrote this on my first description). I could attach without problems!
- After changing value of 'max_allowed_packet' to 2M, it was possible to attach AL3406.pb file. But remember, the file has not 1M.

I think that one of the applications involved with this problem, is misinterpreting the size of this specific file (AL3406.pb).

Comment 6

[Max Kanat-Alexander]

Well, if you changed max_allowed_packet to 2M and it worked, then apparently MySQL saw it as a 1MB file for some reason or other. In any case, it's not a bug in Bugzilla. Thank you for the report, though!

Comment 7

[Nelson Theves]

Thanks!
I reported the problem on MySQL bug zone.
http://bugs.mysql.com/bug.php?id=30540