On 05/02/13 09:43, Luis H. Forchesatto wrote: > Greetings. > > I'm receiving this intermitent error when some random jobs run: > ---8<---- > 02-May 07:24 backup-dir JobId 8241: 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 'batch' is marked as crashed and should be > repaired
Hi Louis... I cut that Fatal error line to reveal the cause at the end of the line: ---8<---- ERR=Table 'batch' is marked as crashed and should be repaired ---8<---- I believe that your answer. If other jobs fail with other tables being reported as crashed, then they should be repaired as well. I would stop bacula and all other programs accessing your database and run a mysqlcheck on all tables. (Assuming mysql since that looks like a mysql error to me) -- Bill Arlofski Reverse Polarity, LLC ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
