[rt-users] Db errors

[Geert Theys]

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 [mailto: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