[rt-users] FW: rt3 Attachement Table Issue

Mon Jun 25 10:21:48 EDT 2012

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120625/b5bd3aa7/attachment.htm>