There was really no error message. Rebooted the server and recompiled and
reinstalled mysql51-server and client and it's working again. Don't know why
the problem disappeared.
Arno Lehmann wrote:
>
> Hi,
>
> 10.07.2007 10:56,, Pieter (NL) wrote::
>> Updated MySQL yesterday and all backups fail with the following
>> message(s):
>>
>> Job failed.
>> 10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720)
>> 10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
>> sql_create.c:93 Create DB Job record INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720) failed. ERR=
>
> Really no error message printed?
>
>> Any suggestions?
>
> Yup... check the database. MySQL can fill its table space, the cure is
> simple.
> It's also possible that the MySQL server disconnected after a long
> idle time, which can also easily be fixed.
> Finally, you might have a more serious problem with the database,
> which you could analyze and hopefully fix using the MySQL tools.
>
> Since you write you updated the database, but give no more details, I
> suggest looking through the MySQL related log files first.
>
> Arno
>
>> Pieter
>
> --
> Arno Lehmann
> IT-Service Lehmann
> www.its-lehmann.de
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
--
View this message in context:
http://www.nabble.com/Job-Failed-Fatal-error%3A-sql_create.c%3A93-Create-DB-Job-record-tf4054580.html#a11522451
Sent from the Bacula - Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
