Hmmm. The repair table info is disturbing. I've seen this when permissions are hosed. I realize this is probably obvious, but make sure everything inside the /var/lib/mysql/data directory is owned by mysql:admin. You know: cd /var/lib/mysql/data; chown -R mysql:admin *
That sort of thing.... Jud. On Mon Oct 2 3:47 , 'Geert Theys' <[EMAIL PROTECTED]> sent: >Hello, > >I installed RT as apache2-modperl2.conf. RT and mysql is installed on the same >host. > >It seems that the error is no longer in syslog... > >Regards, >Geert Theys. > >> -----Original Message----- >> From: Torsten Brumm [EMAIL PROTECTED]','','','')">[EMAIL PROTECTED] >> Sent: Monday, October 02, 2006 8:54 AM >> To: Geert Theys >> Cc: [email protected] >> Subject: Re: [rt-users] Db errors >> >> Hi Geert, >> >> have you installed RT and the DB at the same host or have you >> splitted RT from the DB? Do you use FastCGI? >> >> I know this Error: MySQL server has gone away at, if you have >> FastCGI, this means usally the Session from FastCGI timedout. >> >> Torsten >> >> >> 2006/9/29, Geert Theys [EMAIL PROTECTED]>: >> >> 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 >> >> >> >> >> >> -- >> MFG >> >> Torsten Brumm >> >> http://www.torsten-brumm.de >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.1.407 / Virus Database: 268.12.11/460 - Release >> Date: 10/1/2006 >> >> >> > >-- >No virus found in this outgoing message. >Checked by AVG Free Edition. >Version: 7.1.407 / Virus Database: 268.12.11/460 - Release Date: 10/1/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
