Db errors

RT Users
1

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

2

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@eu.pearldoc.net sent:

3

I know the command repair:

Repair table sessions;

But when I log into mysql I get following:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn’t find any fields in table ‘FM_ArticleCFValues’
Didn’t find any fields in table ‘FM_Articles’
Didn’t find any fields in table ‘FM_ClassCustomFields’
Didn’t find any fields in table ‘FM_Classes’
Didn’t find any fields in table ‘FM_CustomFieldValues’
Didn’t find any fields in table ‘FM_CustomFields’
Didn’t find any fields in table ‘FM_Transactions’

I try to:

mysql> repair table FM_ArticleCFValues;
| Table | Op | Msg_type | Msg_text |
| rtdb.FM_ArticleCFValues | repair | error | Can’t open file: ‘FM_ArticleCFValues.ibd’ (errno: 1) |
1 row in set (0.00 sec)

How to optimise the tables I don’t know…

Regards,
Geert Theys.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Judson Main
Sent: Friday, September 29, 2006 4:39 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Db errors

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@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

The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial
support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.9/458 - Release
Date: 9/27/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

4

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.

Torsten2006/9/29, Geert Theys gt@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

5

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@googlemail.com]
Sent: Monday, October 02, 2006 8:54 AM
To: Geert Theys
Cc: rt-users@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

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

6

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@eu.pearldoc.net sent: