-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Search the list. IIRC, there is a minimum PostgreSQL version associated
with Bacula 2.2.x
Disaster wrote:
> 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
- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II
|$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHJV3Mmb+gadEcsb4RArkJAKCcXg2YLnh1ySMxR6+xeiEZTLxPAwCfbrc5
/lCUCQDWZEd7/ANmYcP0yhs=
=JDGg
-----END PGP SIGNATURE-----
begin:vcard
fn:Ryan Novosielski
n:Novosielski;Ryan
org:UMDNJ;IST/AST
adr;dom:MSB C630;;185 South Orange Avenue;Newark;NJ;07103
email;internet:[EMAIL PROTECTED]
title:Systems Programmer III
tel;work:(973) 972-0922
tel;fax:(973) 972-7412
tel;pager:(866) 20-UMDNJ
x-mozilla-html:FALSE
version:2.1
end:vcard
-------------------------------------------------------------------------
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
