Hmm. Have you repaired and optimized the tables after the recovery? my mysql, in the rt3 database use this command: "show table status;"
Jud. On Fri Sep 29 8:19 , 'Geert Theys' <[EMAIL PROTECTED]> sent: >Hello, > >I have googled and looked around what the error means but I can’t find a >answer. > >I had a default debian Sarge RT 3.4 installation and my server crashed. I >recovered the mysql DB with a mysqldump. I have installed a new debian machine >and loaded de data into the new machine. Everything seems to work ok apart >from the fact it is quite slow. > >So I checked /var/log/syslog and every second(even few times during one >second) I see following: > >Sep 29 13:04:59 localhost RT: DBD::mysql::st execute failed: MySQL server has >gone away at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480. >(/usr/share/request-tracker3.4/lib/RT.pm:277) >Sep 29 13:04:59 localhost RT: RT::Handle=HASH(0x8d58898) couldn't execute the >query 'SELECT main.* FROM Attributes main WHERE ((main.ObjectId = 609)) AND >((main.ObjectType = 'RT::Ticket')) ' at >/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494. >(/usr/share/request-tracker3.4/lib/RT.pm:277) >Sep 29 13:05:01 localhost /USR/SBIN/CRON[18281]: (rt) CMD (fetchmail -s) >Sep 29 13:05:01 localhost RT: DBD::mysql::st execute failed: MySQL server has >gone away at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480. >(/usr/share/request-tracker3.4/lib/RT.pm:277) >Sep 29 13:05:01 localhost RT: RT::Handle=HASH(0x8d58898) ((main.ObjectId = >610)) AND ((main.ObjectType = 'RT::Ticket')) ' at >/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494. >(/usr/share/request-tracker3.4/lib/RT.pm:277) > > >Can someone guide me to a solution? > >Regards, >Geert Theys. > >-- >No virus found in this outgoing message. >Checked by AVG Free Edition. >Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 > >_______________________________________________ >http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > >Community help: http://wiki.bestpractical.com >Commercial support: [EMAIL PROTECTED] > > >Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
