Re: [Bacula-users] ERR=Table 'p' is marked as crashed and should be repaired

[Frank S. <fs...@WP...>]

On 12/7/2010 3:00 AM, Eric Yellin wrote:
> Hi,
>
> I recently upgraded Bacula from 1.38 to 5.0.3. I also moved the system
> from FreeBSD and it is now running on CentOS 5.5 with MySQL 5.0.77.
>
> I get the following error for all backup jobs:
>
> Fatal error: sql_create.c:858 Fill Path table Query failed: INSERT INTO Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT Path FROM Path AS p WHERE p.Path = a.Path): ERR=Table 'p' is marked as crashed and should be repaired
>
> Any ideas why this may be happening and can be fixed?

Strictly speaking, this is actually a mysql problem, not a bacula one.

It sounds like you copied the database tables over while the database was still 
live, so the files were in a dirty state.  You should be able to get them back 
into a clean state with the repair mysql command:

http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html

After that, make sure to also run the bacula dbcheck command to look for any 
remaining problems.

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
     GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC