[rt-users] Db errors

[Judson Main]

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' <gt at eu.pearldoc.net> 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 [torsten.brumm at googlemail.com','','','')">torsten.brumm at googlemail.com] 
>> Sent: Monday, October 02, 2006 8:54 AM
>> To: Geert Theys
>> Cc: rt-users at lists.bestpractical.com
>> 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 gt at eu.pearldoc.net>:
>> 
>> 	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
>> 	
>> 
>> 
>> 
>> 
>> --
>> 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: sales at bestpractical.com
>
>
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>Buy a copy at http://rtbook.bestpractical.com