It appears that the File table may be corrupted. I get the following results from various checks. It should be noted that all other tables respond fine with these checks.
mysql> repair table File; +-------------+--------+----------+------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------+--------+----------+------------------------------------------------+ | bacula.File | repair | error | Can't create new tempfile: './bacula/File.TMD' | | bacula.File | repair | status | Operation failed | +-------------+--------+----------+------------------------------------------------+ 2 rows in set (0.00 sec) skippy:/vol/mysql/bacula# myisamchk File --check Checking MyISAM file: File Data records: 46514953 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links MyISAM-table 'File' is usable but should be fixed If I try to run isamchk -r -q on this I get a seg fault +---------------------------------------------------------------------- |This was sent by neilerobe...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
