SearchBuilder error when adding zipfile attachment (RT 3.2.2)

The zip file is ~15 compressed html files, uncompressed ~33MB,
compressed ~2.5MB.

Is RT trying to uncompress them? Can this be avoided?

[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [warning]: DBD::mysql::st execute failed: Got
a packet bigger than ‘max_allowed_packet’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 481.
(/usr/local/rt3/lib/RT.pm:269)
[Tue Nov 9 16:41:09 2004] [warning]: RT::Handle=HASH(0xb77fad8)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 495.
(/usr/local/rt3/lib/RT.pm:269)
[Tue Nov 9 16:41:09 2004] [debug]: About to think about scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:140)
[Tue Nov 9 16:41:09 2004] [debug]: About to prepare scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:144)
[Tue Nov 9 16:41:09 2004] [debug]: Found 3 scrips
(/usr/local/rt3/lib/RT/Scrips_Overlay.pm:349)
[Tue Nov 9 16:41:11 2004] [debug]: About to commit scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:153)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-8.17.2532067311439@inscriber.com #586/5815 - Scrip
8 (/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:231)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-8.17.2532067311439@inscriber.com No recipients
found. Not sending.
(/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:243)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-9.5.93085818439206@inscriber.com #586/5815 - Scrip
9 (/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:231)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-9.5.93085818439206@inscriber.com No recipients
found. Not sending.
(/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:243)

Thanks,
Graham

The zip file is ~15 compressed html files, uncompressed ~33MB,
compressed ~2.5MB.

Is RT trying to uncompress them? Can this be avoided?

[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: utf8
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [debug]: Guessed encoding: ascii
(/usr/local/rt3/lib/RT/I18N.pm:379)
[Tue Nov 9 16:41:09 2004] [warning]: DBD::mysql::st execute failed: Got
a packet bigger than ‘max_allowed_packet’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 481.
(/usr/local/rt3/lib/RT.pm:269)
[Tue Nov 9 16:41:09 2004] [warning]: RT::Handle=HASH(0xb77fad8)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename, Headers, Creator, Parent, Created,
ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 495.
(/usr/local/rt3/lib/RT.pm:269)
[Tue Nov 9 16:41:09 2004] [debug]: About to think about scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:140)
[Tue Nov 9 16:41:09 2004] [debug]: About to prepare scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:144)
[Tue Nov 9 16:41:09 2004] [debug]: Found 3 scrips
(/usr/local/rt3/lib/RT/Scrips_Overlay.pm:349)
[Tue Nov 9 16:41:11 2004] [debug]: About to commit scrips for
transaction5815 (/usr/local/rt3/lib/RT/Transaction_Overlay.pm:153)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-8.17.2532067311439@inscriber.com #586/5815 - Scrip
8 (/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:231)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-8.17.2532067311439@inscriber.com No recipients
found. Not sending.
(/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:243)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-9.5.93085818439206@inscriber.com #586/5815 - Scrip
9 (/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:231)
[Tue Nov 9 16:41:11 2004] [info]:
rt-3.2.2-586-5815-9.5.93085818439206@inscriber.com No recipients
found. Not sending.
(/usr/local/rt3/local/lib/RT/Action/SendEmail.pm:243)

Thanks,
Graham

The zip file is ~15 compressed html files, uncompressed ~33MB,
compressed ~2.5MB.

Is RT trying to uncompress them? Can this be avoided?

Nope.

max_allowed_packet is the key from that error.
i
http://wiki.bestpractical.com/index.cgi?FAQ

Look for ‘Attachments’

Jesse Vincent wrote:

The zip file is ~15 compressed html files, uncompressed ~33MB,
compressed ~2.5MB.

Is RT trying to uncompress them? Can this be avoided?

Nope.

max_allowed_packet is the key from that error.
i
http://wiki.bestpractical.com/index.cgi?FAQ

Look for ‘Attachments’

Ah-ha. Should know better than to rely only on google…

So was that a Nope, it’s not trying to uncompress them, or nope, it
can’t be avoided, or both?

Graham

I thought that was a MySQL error myself. It’s trying to send a 2.5Mb+ packet to
MySQL and MySQL is rejecting it. This article should point you in the right
direction perhaps?

http://www.mysql.com/news-and-events/newsletter/2003-08/a0000000216.html

Graham Dunn wrote:

Jesse Vincent wrote:

The zip file is ~15 compressed html files, uncompressed ~33MB,
compressed ~2.5MB.

Is RT trying to uncompress them? Can this be avoided?

Nope.

max_allowed_packet is the key from that error.
i
http://wiki.bestpractical.com/index.cgi?FAQ

Look for ‘Attachments’

Ah-ha. Should know better than to rely only on google…

So was that a Nope, it’s not trying to uncompress them, or nope, it
can’t be avoided, or both?

Graham


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

With regards,

Say_Ten

This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.

In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137
or return the E.mail to postmaster@multiplay.co.uk.