Please note that we do not officially support MariaDB -- one prior
version has some serious problems falsely detecting deadlocks. Bacula
works perfectly well with all "out of the box" installations of MySQL.
Concerning the error message you are getting, either this is a MariaDB
problem or you are not running MySQL out of the box and you have applied
some stricter SQL requirements which require default values for DATETIME
fields. Either remove those requirements (I forget exactly what they
are but they have been reported numerous times on this list), or you
must explicitly define default values for those fields. Note if you do
define default values, you *must* ensure that the default value is
stored as a zero in the database (probably 1 Jan 1970). This value of 0
is used by Bacula in certain cases for Volume table references. If the
value does not default to 0 Bacula will fail in some places.
Best regards,
Kern
On 08/01/2018 10:46 AM, George Anchev via Bacula-users wrote:
So... after successfully building Bacula 9.2.0 and
running all 3 daemons, backup doesn't work. Mounting a
tape and running the regular job which I have been
running for years now gives me:
01-Aug 11:32 pc-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record
INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
('pc_Backup.2018-08-01_11.32.58_05','pc_Backup','B','I','C','2018-08-01
11:32:58',1533112378,5,'') failed. ERR=Field 'StartTime' doesn't have a default
value
1. Why JobId 0? I already have more than 4000 jobs.
2. Why is this failing? I have successfully updated db
tables as mentioned in a previous reply.
3. (unrelated to the error): When building Bacula I
specified /var/run as PID directory. Although all the
bacula-*.service are started and running fine, there
are no PID files for bacula in /var/run. Only if I run
manually 'bacula restart' the 3 PID files appear
in /var/run. Is this a bug to be reported?
Any help please?
--
George
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
