[rt-users] Recovering RT data base

[Matthew Hattersley]

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 at 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.
 
-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: 09 March 2011 21:57
To: CLOSE Dave
Cc: rt-users at 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.

On Wed, Mar 9, 2011 at 10:31 PM, CLOSE Dave
<Dave.Close at 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.