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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
