[rt-users] dbd::mysql:st execute failed

[Jason Parsons]

Folks:

I have a new RT installation that has been causing me nightmares.  When I
mail the system, it replies with a ticket number, but then fails to
actually create the ticket.  The error given is:

[Mon Jun  5 19:55:57 2006] [warning]: DBD::mysql::st execute failed: MySQL
server has gone away at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:287)

Note that it got a ticket number and read some scrips before throwing this
error, so mysql is "clearly" available.  I have tried reinstalling
dbd::mysql, and even tried reinstalling all of mod_perl2.

'make testdeps' does succeed properly, and I've noted no other problems
with mysql.  I've tried dropping and rebuilding the mysql database, and
the same problem recurs (make dropdb; make initialize-database).

I'm running rt 3.4.5 on RHEL ES 4.

Any ideas?

Thank you.
 - Jason Parsons

[Mon Jun  5 19:55:54 2006] [debug]: Found 3 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:356)
[Mon Jun  5 19:55:55 2006] [debug]: About to commit scrips for transaction
#75 (/opt/rt3/lib/RT/Transaction_Overlay.pm:169)
[Mon Jun  5 19:55:55 2006] [info]:
<rt-3.4.5-26062-1149537355-625.110004-3-0 at Foo-Inc> #110004/75 - Scrip 3
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Mon Jun  5 19:55:56 2006] [debug]: About to think about scrips for
transaction #76 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Mon Jun  5 19:55:56 2006] [info]:
<rt-3.4.5-26062-1149537355-625.110004-3-0 at Foo-Inc> sent To:
devnull at saffron.net Cc:  Bcc:  (/opt/rt3/lib/RT/Action/SendEmail.pm:297)
[Mon Jun  5 19:55:56 2006] [info]:
<rt-3.4.5-26062-1149537355-178.110004-4-0 at Foo-Inc> #110004/75 - Scrip 4
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Mon Jun  5 19:55:57 2006] [warning]: DBD::mysql::st execute failed: MySQL
server has gone away at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:287)