[Rt-devel] rt-3.4.4 / mod_perl 2.0.1 / MySQL server has gone away

[Christophe Banal]

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 at 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 at 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