Dear all, after an upgrade I get those error (via Bacula daemon message). I've upgraded from 1.36 to 2.2.5 on gentoo running postgres (I've successfully updated db to version 9 and then 10). backups are running ok and if I issue those query manually on my db they works.
thanks Andrea On Wed, 2007-10-17 at 19:20 +0200, Bacula wrote: > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:346 > sql_create.c:346 query SELECT MediaTypeId,MediaType FROM MediaType WHERE > MediaType='File' failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:364 > sql_create.c:364 insert INSERT INTO MediaType (MediaType,ReadOnly) VALUES > ('File',0) failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:288 > sql_create.c:288 query SELECT StorageId,AutoChanger FROM Storage WHERE > Name='File' failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:316 > sql_create.c:316 insert INSERT INTO Storage (Name,AutoChanger) VALUES > ('File',0) failed: > > 17-Oct 19:17 bacula-dir JobId 0: Error: sql_create.c:318 Create DB Storage > record INSERT INTO Storage (Name,AutoChanger) VALUES ('File',0) failed. ERR= > 17-Oct 19:17 bacula-dir JobId 0: Error: sql_update.c:294 sql_update.c:294 > update UPDATE Storage SET AutoChanger=0 WHERE StorageId=0 failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:346 > sql_create.c:346 query SELECT MediaTypeId,MediaType FROM MediaType WHERE > MediaType='LTO-2' failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:364 > sql_create.c:364 insert INSERT INTO MediaType (MediaType,ReadOnly) VALUES > ('LTO-2',0) failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:288 > sql_create.c:288 query SELECT StorageId,AutoChanger FROM Storage WHERE > Name='Tape' failed: > > 17-Oct 19:17 bacula-dir JobId 0: Fatal error: sql_create.c:316 > sql_create.c:316 insert INSERT INTO Storage (Name,AutoChanger) VALUES > ('Tape',0) failed: > > 17-Oct 19:17 bacula-dir JobId 0: Error: sql_create.c:318 Create DB Storage > record INSERT INTO Storage (Name,AutoChanger) VALUES ('Tape',0) failed. ERR= > 17-Oct 19:17 bacula-dir JobId 0: Error: sql_update.c:294 sql_update.c:294 > update UPDATE Storage SET AutoChanger=0 WHERE StorageId=0 failed: > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users