chris at thetrafalgartravel
Jun 25, 2012, 7:21 AM
Post #1 of 1
(187 views)
Permalink
|
|
FW: rt3 Attachement Table Issue
|
|
Hello All
My Network guy is having a problem with RT and the attachment file, has
anyone had this error before and how do you think we should proceed. The
person who set it up in the first place left suddenly and we don't have much
support
Regards
_____
From: Ivan Arias [mailto:ivan [at] thetrafalgartravel]
Sent: Monday, June 25, 2012 8:27 AM
To: 'Chris Preston'
Cc: 'Tanielle'
Subject: rt3 Attachement Table Issue
Good morning Chris/Tanielle
This morning I did try to backup the Attachment after change a parameter
innodb_force_recovery = 4 on the my.cnf follow instruction on documentation
http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html that
Tanielle send me and with value of 4 I get this when I try to backup the rt3
db
07:32:54 Dumping rt3 (Scrips)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpnfi85u.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Scrips"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Scrips`': Incorrect key file for table 'Scrips'; try to repair it (1034)
Operation failed with exitcode 2
07:32:54 Dumping rt3 (Tickets)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpbhepzb.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Tickets"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Tickets`': Incorrect key file for table 'Tickets'; try to repair it (1034)
Operation failed with exitcode 2
07:32:54 Dumping rt3 (FM_Articles)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp5y25y8.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "FM_Articles"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`FM_Articles`': Incorrect key file for table 'FM_Articles'; try to repair it
(1034)
Operation failed with exitcode 2
07:32:54 Dumping rt3 (sessions)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmppnfsmy.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "sessions"
07:32:58 Dumping rt3 (CustomFieldValues)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpc8shb_.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "CustomFieldValues"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`CustomFieldValues`': Incorrect key file for table 'CustomFieldValues'; try
to repair it (1034)
Operation failed with exitcode 2
07:32:58 Dumping rt3 (Queues)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpbwkutk.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Queues"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Queues`': Incorrect key file for table 'Queues'; try to repair it (1034)
Operation failed with exitcode 2
07:32:58 Dumping rt3 (GroupMembers)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpjmryjd.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "GroupMembers"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`GroupMembers`': Incorrect key file for table 'GroupMembers'; try to repair
it (1034)
Operation failed with exitcode 2
07:32:58 Dumping rt3 (ACL)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmptsrhum.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "ACL"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `ACL`':
Incorrect key file for table 'ACL'; try to repair it (1034)
Operation failed with exitcode 2
07:32:58 Dumping rt3 (Attributes)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpyrhiwo.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Attributes"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Attributes`': Incorrect key file for table 'Attributes'; try to repair it
(1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (CustomFields)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpnvs_ku.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "CustomFields"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`CustomFields`': Incorrect key file for table 'CustomFields'; try to repair
it (1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (Principals)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpomlfuo.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Principals"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Principals`': Incorrect key file for table 'Principals'; try to repair it
(1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (ObjectCustomFieldValues)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpm0exy6.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "ObjectCustomFieldValues"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ObjectCustomFieldValues`': Incorrect key file for table
'ObjectCustomFieldValues'; try to repair it (1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (Attachments)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp_qg2ag.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Attachments"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Attachments`': Incorrect key file for table 'Attachments'; try to repair it
(1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (Templates)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp0li6bx.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Templates"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Templates`': Incorrect key file for table 'Templates'; try to repair it
(1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (Users)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpw1tk7u.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Users"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Users`': Incorrect key file for table 'Users'; try to repair it (1034)
Operation failed with exitcode 2
07:32:59 Dumping rt3 (Links)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpkkzz7f.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Links"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Links`': Incorrect key file for table 'Links'; try to repair it (1034)
Operation failed with exitcode 2
07:33:00 Dumping rt3 (Transactions)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmplunr8o.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Transactions"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Transactions`': Incorrect key file for table 'Transactions'; try to repair
it (1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (FM_Classes)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpvyg8t6.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "FM_Classes"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`FM_Classes`': Incorrect key file for table 'FM_Classes'; try to repair it
(1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (ScripActions)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpe22lqh.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "ScripActions"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ScripActions`': Incorrect key file for table 'ScripActions'; try to repair
it (1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (FM_ObjectTopics)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp_h1wvk.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "FM_ObjectTopics"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`FM_ObjectTopics`': Incorrect key file for table 'FM_ObjectTopics'; try to
repair it (1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (ScripConditions)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpjnh3wo.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "ScripConditions"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ScripConditions`': Incorrect key file for table 'ScripConditions'; try to
repair it (1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (Groups)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpnkzepo.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Groups"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Groups`': Incorrect key file for table 'Groups'; try to repair it (1034)
Operation failed with exitcode 2
07:33:01 Dumping rt3 (ObjectCustomFields)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpfnkbug.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "ObjectCustomFields"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ObjectCustomFields`': Incorrect key file for table 'ObjectCustomFields';
try to repair it (1034)
Operation failed with exitcode 2
07:33:02 Dumping rt3 (FM_Topics)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpp2ut3r.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "FM_Topics"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`FM_Topics`': Incorrect key file for table 'FM_Topics'; try to repair it
(1034)
Operation failed with exitcode 2
07:33:02 Dumping rt3 (CachedGroupMembers)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp4axxy_.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "CachedGroupMembers"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`CachedGroupMembers`': Incorrect key file for table 'CachedGroupMembers';
try to repair it (1034)
Operation failed with exitcode 2
07:33:03 Export of C:\Documents and Settings\ivan\My
Documents\dumps\Dump20120625 has finished with 24 errors
07:33:49 Dumping rt3 (Attachments)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmp6127qj.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Attachments"
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`Attachments`': Incorrect key file for table 'Attachments'; try to repair it
(1034)
Operation failed with exitcode 2
07:33:50 Export of C:\Documents and Settings\ivan\My
Documents\dumps\Dump20120625-1 has finished with 1 errors
Then I change the value to innodb_force_recovery = 3 and I try to backup
only the Attachment table and I get this:
07:35:59 Dumping rt3 (Attachments)
Running: mysqldump.exe
--defaults-extra-file="c:\docume~1\ivan\locals~1\temp\tmpmbjvyi.cnf"
--user=ivan --max_allowed_packet=1G --host=192.168.0.7 --port=3306
--default-character-set=utf8 "rt3" "Attachments"
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table `Attachments` at row: 356775
Operation failed with exitcode 3
07:42:22 Export of C:\Documents and Settings\ivan\My
Documents\dumps\Dump20120625-2 has finished with 1 errors
As you can see I did get error again.
Some more work(research) need to be done to try to solve this issue with the
huge Attachment table.
Ivan
|
