Rt-3.4.4 / mod_perl 2.0.1 / MySQL server has gone away

RT Developers,

I’ve done a clean install of rt-3.4.4 using mod_perl 2.0.1 and main web
interface seems to work without any problems. The issue comes into play
when we try and add a request to rt through the rt-mailgate script. rt
reports that the “MySQL server has gone away” and as expected the
request never makes it into the database. I’ve reconfigured rt to use
mod_fastcgi and the entire system seems to work without any problems.

We’d prefer to use mod_perl as it is how the rest of our software runs.
Any help in getting the issue corrected would be greatly appreciated.

Using the following software:
SuSE-9.3
apache2-prefork-2.0.53
DBD-mysql-3.0002
DBIx-SearchBuilder-1.33
DBI-1.48
mysql-4.1.10a

mysqld config:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 16M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
log = /var/lib/mysql/query.log

syslogd:
Oct 19 09:46:31 linux RT: DBD::mysql::st execute failed: MySQL server
has gone away at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 493. (/srv/
www/htdocs/rt3/lib/RT.pm:287)
Oct 19 09:46:31 linux RT: RT::Handle=HASH(0x92ae528) couldn’t execute
the query ‘INSERT INTO Transactions (OldValue, NewReference,
OldReference, NewValue, Creator,
ObjectId, Type, Field, ReferenceType, Created, Data, ObjectType) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder
/Handle.pm line 506
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x92ae528)’,
‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’,
‘undef’, ‘undef’, ‘undef’, ‘undef’, 1, 5, ‘EmailRecord’, …) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 366
DBIx::SearchBuilder
::Handle::Insert(‘RT::Handle=HASH(0x92ae528)’, ‘Transactions’,
‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’,
‘NewValue’, …) called at /u
sr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle/mysql.pm line
39
DBIx::SearchBuilder::Handle::mysql::Insert(‘RT::Handle=HASH(0x92ae528)’,
‘Transacti
ons’, ‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’,
‘undef’, ‘NewValue’, …) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm
line 1291
DBIx::SearchBuilder::Record::Create(‘RT::Transaction=HASH(0x9de81b4)’,
‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’, ‘NewV
alue’, ‘undef’, …) called at /srv/www/htdocs/rt3/lib/RT/Record.pm line
300 RT::Record::Create(‘RT::Transaction=HASH(0x9de81b4)’, ‘OldValue’,
‘undef’, ‘NewRefe
rence’, ‘undef’, ‘OldReference’, ‘undef’, ‘NewValue’, ‘undef’, …)
called at /srv/www/htdocs/rt3/lib/RT/Transaction_Overlay.pm line
150 RT::Transaction::Cr
eate(‘RT::Transaction=HASH(0x9de81b4)’, ‘Ticket’, 5, ‘Type’,
‘EmailRecord’, ‘Data’,
rt-3.4.4-12356-1129740390-246.5-3-0@example.com’, ‘MIMEObj’,
‘MIME::Entity=H
ASH(0x9dced38)’, …) called at
/srv/www/htdocs/rt3/lib/RT/Action/SendEmail.pm line 406
RT::Action::SendEmail::RecordOutgoingMailTransaction(‘RT::Action::A
utoreply=HASH(0x9dc5844)’, ‘MIME::Entity=HASH(0x9dced38)’) called at
/srv/www/htdocs/rt3/lib/RT/Action/SendEmail.pm line 295 RT::Action::Sen
Oct 19 09:46:31 linux RT: DBD::mysql::st execute failed: MySQL server
has gone away at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 493. (/srv/
www/htdocs/rt3/lib/RT.pm:287)
Oct 19 09:46:31 linux RT: RT::Handle=HASH(0x92ae528) couldn’t execute
the query ‘SELECT * FROM Transactions WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.8.6/DBIx/S
earchBuilder/Handle.pm line 506
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x92ae528)’,
‘SELECT * FROM Transactions WHERE id = ?’, 0) calle
d at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1218
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Transaction=HASH(0x9de81b4)’,
‘SELEC
T * FROM Transactions WHERE id = ?’, 0) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1133 DBIx::SearchBuilder::Record::LoadBy
Cols(‘RT::Transaction=HASH(0x9de81b4)’, ‘id’, 0) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record/Cachable.pm
line 137 DBIx::SearchBuilder
::Record::Cachable::LoadByCols(‘RT::Transaction=HASH(0x9de81b4)’, ‘id’,
0) called at /srv/www/htdocs/rt3/lib/RT/Record.pm line 392
RT::Record::LoadByCols(‘RT:
:Transaction=HASH(0x9de81b4)’, ‘id’, 0) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1152 DBIx::SearchBuilder::Record::LoadBy
Id(‘RT::Transaction=HASH(0x9de81b4)’, 0) called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1059 DBIx::SearchBuilder::Record::Load(’
RT::Transaction=HASH(0x9de81b4)', 0) called at
/srv/www/htdocs/rt3/lib/RT/Transaction_Overlay.pm line 151
RT::Transaction::Create(‘RT::Transaction=HASH(0x9de
81b4)’, ‘Ticket’, 5, ‘Type’, ‘EmailRecord’, ‘Data’,
rt-3.4.4-12356-1129740390-246.5-3-0@example.com’, ‘MIMEObj’,
‘MIME::Entity=HASH(0x9dced38)’, …) called at
/srv/www/htdocs/rt3/lib/RT/Action/SendEmail.pm line 406
RT::Action::SendEmail::RecordOutgoingMailTransaction(‘RT::Action::Autoreply=HASH(0x9dc5844)’,
‘MIME
::Entity=HASH(0x9dced38)’) called at
/srv/www/htdocs/rt3/lib/RT/Action/SendEmail.pm line 295
RT::Action::SendEmail::SendMessage(‘RT::Action::Autoreply=HASH(0x9d
c5844)’, ‘MIME::Entity=HASH(0x9dced38)’) called at
/srv/www/htdocs/rt3/lib/RT/Action/SendEmail.pm line 102
RT::Action::SendEmail::Commit('RT::Action::Autorepl
y=HAS

Thank you,
Christophe Banal