[rt-users] Db errors

Torsten Brumm torsten.brumm at googlemail.com
Mon Oct 2 02:54:02 EDT 2006


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061002/572268ad/attachment.htm>


More information about the rt-users mailing list