Hi, 07.08.2007 11:43,, Monstad wrote:: > > Hi there, > > For the past day bacula has been unresponsive eg: not mounting tapes, not > purging records etc. > > Today I got this mail: > > > > > *cacti.poller_output > error : Can't find file: 'poller_output.MYI' (errno: 2) > cacti.poller_time > warning : Table is marked as crashed > error : Found key at page 1024 that points to record outside datafile > error : Corrupt > syslog.logs > warning : Table is marked as crashed > error : Size of indexfile is: 5218078720 Should be: 5218079744 > error : Corrupt > > Improperly closed tables are also reported if clients are accessing > the tables *now*. A list of current connections is below. > > +----+------------------+-----------+----+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | Info > > | > +----+------------------+-----------+----+---------+------+-------+------------------+ > | 52 | debian-sys-maint | localhost | | Query | 0 | | show > processlist | > +----+------------------+-----------+----+---------+------+-------+------------------+ > Uptime: 4 Threads: 1 Questions: 379 Slow queries: 0 Opens: 255 Flush > tables: 1 Open tables: 64 Queries per second avg: 94.750*
Your MySQL is databases are broken. MySQL does write a log file where it reports errors, and the system log might also have valuable information. Shut down MySQL and run the related tools to check and repair the databases. There is information in the MySQL manual. One of the more common problems, in my experience, is the infamous "disk full" one, by the way :-) As the problem is not directly related to Bacula, I can only recommend to ask for more detailed help in the MySQL-related mailing lists, forums, or newsgroups. Once you've got the database running again and checked the Bacula-related ones with dbcheck, I'm sure we can help you restoring your data or getting Bacula running again. Arno > Can anyone suggest how to repair this? I'm afraid I'm relatively new to > bacula (and I apologise if this is a documented problem). > > I would be extremely grateful for any advice, > > Kris > > -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
