[rt-users] Db errors

[Judson Main]

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' <gt at eu.pearldoc.net> 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: sales at bestpractical.com
>
>
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>Buy a copy at http://rtbook.bestpractical.com