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

------------------------------------------------------------------------------
What happens now with your Lotus Notes apps - do you make another costly 
upgrade, or settle for being marooned without product support? Time to move
off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
use, and manage than apps on traditional platforms. Sign up for the Lotus 
Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users