Hi,

I noticed that a file for mysql was lost on the server:
/var/db/mysql/mysql/general_log.CSV

Creating an empty file with the right ownership and permissions solved
the problem.

Best wishes,
Rainer

Rainer Schwarze wrote:
> Hi,
> 
> I have bacula 2.2.5 running on a FreeBSD 6.2 server with MySQL 5.1.22.
> Things ran smoothly for about two years. Now I am getting this error:
> 
> [...]
> 30-Mar 20:49 srv-sd JobId 2860: Ready to append to end of Volume
> "Full-0004" size=750415
> 30-Mar 20:49 srv-dir JobId 2860: Fatal error: sql_create.c:732
> sql_create.c:732 insert INSERT INTO batch VALUES (1,2860,'/etc/def
> aults/','rc.conf','Bg MDD IEk B A A xHg IAD BAA BE BJ0RQ3 BFpzvc 4bh1o A
> A C','0') failed:
> Table 'bacula.batch' doesn't exist
> [...]
> 
> I added the *_timeout lines mentioned in the FAQ to my.cnf - no success.
> 
> I checked the database username and password for bacula and they are ok.
> (I would expect that if this would be the problem, it should fail
> somewhere else?)
> 
> The job is a very small one ( /etc ) and it shouldn't be a timeout issue.
> 
> 
> Can you give me a hint, what I should check next?
> Is there a trivial solution?
> 
> Thanks and best wishes,
> Rainer
-- 

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users