34320 - Got "Software Error" when trying to attach some specific text file

Status: VERIFIED WONTFIX

(Bugzilla :: Bugzilla-General, defect, P3)

Description

[Karen Huang]

Got "Software Error" when trying to attach some specific text file

I am just wondering to know whether there is limitation for attaching file for 
bugzilla..... when I was trying to attach some specific text file (about 6MB),
I got a "Software Error" message.....

Comment 1

[Terry Weissman]

[e-mail] is the new owner of Bugzilla and Bonsai.  (For details,
see my posting in netscape.public.mozilla.webtools,
news://news.mozilla.org/38F5D90D.F40E8C1A%40geocast.com .)

Comment 2

[Karen Huang]

Anybody taking care of this problem yet?

Comment 3

[Terry Weissman]

I believe the bugzilla.mozilla.org installation of bugzilla will choke on
attachments bigger than 1 megabyte.  It's a MySQL thing; this is mentioned
somewhere in Bugzilla's README file.

Comment 4

[Karen Huang]

If this is bugzilla limitation, shouldn't it display the message to let users 
know the limitation instead of just get the "software error" message?

Comment 5

[Chris Yeh]

it is a mysql thing. and it's not something that can be displayed in a bugzilla 
form because it's a command line argument to the mysql daemon at start time. 
basically.

marking as won't fix, because there isn't a good way of fixing this.

Comment 6

[Matthew Tuck [:CodeMachine]]

Is there any way of informing the user of this problem as a possibility on _any_
error that occurs when you try to attach a file?

Comment 7

[Dave Miller [:justdave]]

Just for completeness, the error message generated is:

Software error:

insert into attachments (bug_id, filename, description, mimetype, ispatch, 
submitter_id, thedata) values
(34320,'MacMozillaInstaller.sea', 'testing multiMB attachments to get the error 
message', 'application/octet-stream', 0,
10297, '<<10.7 MB of data omitted>>'): MySQL server has gone away at globals.pl 
line 134, <STDIN> chunk 34324. 

I agree, that's not something we can easily trap.  verif. wontfix

Comment 8

[Brian 'netdragon' Bober]

I got a similiar error.

Bugzilla version 2.11

Create attachment
  Bug 34320
Content-type: text/html
Software error:
insert into attachments (bug_id, filename, description, mimetype, ispatch,
submitter_id, thedata) values (34320,'eeevil.txt', 'eeeeevil text file > 7MB',
'text/plain', 0, 7322, 'blah de dah wo de doh ha ha ha bwahahaha i am you\'re
master! Get in my belly you little twirp. I am you\'re father! I 0wn j00! /* -*-
Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- * * The
contents of this file are subject to the Netscape Public * License Version 1.1
(the "License"); you may not use this file * except in compliance with the
License. You may obtain a copy of * the License at http://www.mozilla.org/NPL/ *
* Software distributed under the License is distributed on an "AS * IS" basis,
WITHOUT WARRANTY OF ANY KIND, either express or * implied. See the License for
the specific language governing * rights and limitations under the License. * *
The Original Code is mozilla.org code. * * The Initial Developer of the Original
Code is Netscape * Communications Corporation. Portions created by Netscape are
* Copyright (C) 1998 Netscape Communications Corporation. All * Rights Reserved.
* * Contributor(s): */ #include "nsIRequest.idl" interface nsIURI; interface
nsIInputStream; interface nsIOutputStream; interface nsIStreamObserver;
interface nsIStreamListener; interface nsIStreamProvider; interface
nsILoadGroup; interface nsIInterfaceRequestor; interface nsIFile; 
.
.
.


!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI
ETH!AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!! THE
INSANITY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YTINASNI ETH!'): MySQL server has gone away at globals.pl line 134, <STDIN>
chunk 164712.

Please send mail to this site's webmaster for help.
u little twirp. I am you\'re father! I 0wn j00! /* -*- Mode: C++; tab-width: 4;
indent-tabs-mode: nil; c-basic-offset: 4 -*- * * The contents of this file are
subject to the Nets

Comment 9

[Brian 'netdragon' Bober]

justdave: Is there a way we could break up attachments that are too large for
MySql? Or maybe there is some other way we can send the data to MySql - ie:
write it to a file and then tell MySql to open the file and copy it to the
attachments.

Comment 10

[Dave Miller [:justdave]]

I don't think timing is the issue.  From experience writing other mySQL apps 
(some are text-based command-line driven shells) mySQL doesn't time out and go 
away after a while.  Something triggered it.  In this case, probably the query it 
too big for it to handle or something so it "hangs up" on the caller mid-query.

You probably could read in a file, but how do you know when to do so?  We don't 
know how big the file is until after it's been uploaded.

Comment 11

[Andreas Franke (gone)]

See also bug 59390 "Abort large (>1MB) attachments before uploading and with a
reasonable error message".

Comment 12

[Dave Miller [:justdave]]

moving to Bugzilla product
reassign to default owner/qa for INVALID/WONTFIX/WORKSFORME/DUPLICATE