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

RegardsFrom: Ivan Arias [mailto:ivan@thetrafalgartravel.com]
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