Recovering RT data base

Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working correctly
for several months, though with only casual use. Approximately three
weeks ago, two MySQL tables started reporting corruption. This was
coincident with installation of NagiosQL, which created a new data base,
but I don’t know that the two events are related. Now all tables for RT
report OK with mysqlcheck except Attachments and Transactions. For
those, any attempt to reference them results in loss of the data base
connection.

./rt-validator -c

[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
1058. (./rt-validator:1058)
[Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
connection to MySQL server during query at ./rt-validator line 1058.
(/opt/rt3/sbin/…/lib/RT.pm:379)
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.

mysqlcheck -p --repair rt3 Attachments

Enter password:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing 'REPAIR TABLE … ’

Unfortunately, I do not have MySQL backups from before this situation.
The corrupt MySQL data base is backed-up by actual copy (cp while mysqld
was stopped). The non-corrupt tables are backed-up by mysqldump.

Is there any way to recover use of these two tables short of dropping
the entire data base and recreating? If I did that, would the mysqldump
of the remaining tables allow me to restore most content?
Dave Close

You should look into Innodb recovery manuals.

http://dev.mysql.com/doc/refman/5.0/en/innodb-recovery.html

Also, you should look at mysql logs for more info.

And it’s really better to move forward to mysql forums/lists for help.On Wed, Mar 9, 2011 at 10:31 PM, CLOSE Dave Dave.Close@us.thalesgroup.com wrote:

Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working correctly
for several months, though with only casual use. Approximately three
weeks ago, two MySQL tables started reporting corruption. This was
coincident with installation of NagiosQL, which created a new data base,
but I don’t know that the two events are related. Now all tables for RT
report OK with mysqlcheck except Attachments and Transactions. For
those, any attempt to reference them results in loss of the data base
connection.

./rt-validator -c

[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
1058. (./rt-validator:1058)
[Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
connection to MySQL server during query at ./rt-validator line 1058.
(/opt/rt3/sbin/…/lib/RT.pm:379)
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.

mysqlcheck -p --repair rt3 Attachments

Enter password:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing 'REPAIR TABLE … ’

Unfortunately, I do not have MySQL backups from before this situation.
The corrupt MySQL data base is backed-up by actual copy (cp while mysqld
was stopped). The non-corrupt tables are backed-up by mysqldump.

Is there any way to recover use of these two tables short of dropping
the entire data base and recreating? If I did that, would the mysqldump
of the remaining tables allow me to restore most content?

Dave Close

Best regards, Ruslan.

Just to chip in with this one, chances are that the corruption is down
to a hard disk problem of some sort. MySQL only tends to corrupt
(assuming innodb), if you messed with the innodb engine settings during
the install of NagioSQL or a underlying HDD issue. At which point MySQL
will have binlogs it struggles with and a world of other problems. Check
for changes to my.cnf and dmesg for kernel messages regarding the disc.

Kind Regards,
Find Vaioni’s latest Terms and Conditions & SLA docs http://www.vaioni.com/tcaupsla.html.
http://www.vaioni.com/ http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285 http://www.cbawards.co.uk/Reader_Vote_3.cfm
http://www.vaioni.com/
Matthew Hattersley

Email: mailto:matthew.hattersley@vaioni.com
Mobile:

Address: 14 Leslie Hough Way
Manchester
Lancashire
M6 6AJ

Tel: 0870-160-0650 Ext 201
Fax: 0870-160-0651
Web: http://www.vaioni.com

http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285
The information transmitted in and with this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the Company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.
Please also note, Vaioni filter incoming email for spam and inappropriate words. Unfortunately this does mean that sometimes genuine messages can be filtered out. Although we take measures to recover such messages, it must not be assumed that an email has been received by us and important communications should always be followed up by a phone call, fax or printed copy.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: 09 March 2011 21:57
To: CLOSE Dave
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Recovering RT data base

You should look into Innodb recovery manuals.

http://dev.mysql.com/doc/refman/5.0/en/innodb-recovery.html

Also, you should look at mysql logs for more info.

And it’s really better to move forward to mysql forums/lists for help.

Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working
correctly
for several months, though with only casual use. Approximately three
weeks ago, two MySQL tables started reporting corruption. This was
coincident with installation of NagiosQL, which created a new data
base,
but I don’t know that the two events are related. Now all tables for
RT
report OK with mysqlcheck except Attachments and Transactions. For
those, any attempt to reference them results in loss of the data base
connection.

./rt-validator -c

[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
1058. (./rt-validator:1058)
[Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
connection to MySQL server during query at ./rt-validator line 1058.
(/opt/rt3/sbin/…/lib/RT.pm:379)
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.

mysqlcheck -p --repair rt3 Attachments

Enter password:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing 'REPAIR TABLE … ’

Unfortunately, I do not have MySQL backups from before this situation.
The corrupt MySQL data base is backed-up by actual copy (cp while
mysqld
was stopped). The non-corrupt tables are backed-up by mysqldump.

Is there any way to recover use of these two tables short of dropping
the entire data base and recreating? If I did that, would the
mysqldump
of the remaining tables allow me to restore most content?

Dave Close

Best regards, Ruslan.