Hello,
you sent this to me, not to the list... I corrected that mistake :-)
On 11.10.2005 13:50, Traub, Kevin (KTRAUB) wrote:
Arno;
Thank you for the reply.
I am doing a pg_dumpall right now and then will re-run the
"update_postgresql_tables" script.
You mentioned running "dbckeck", I'm assuming you mean "dbcheck", but I
don't see a "dbcheck" command in the bacula directory.
Sorry, yes, sure, you're right... it should have been dbcheck and it is
actually part of bacula... if it isn't in the install directory, and you
installed from a distribution package, I don't know where to find it - I
always compiled Bacula myself, and the program was generated in the
src/tools directory.
Is this a bacula command, or a postgres command, or did you mean
something else?
No, I mean the bacula program dbcheck.
Arno
You help is greatly appreciated.
-Kev
-----Original Message-----
From: Arno Lehmann [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 11, 2005 7:35 AM
To: Traub, Kevin (KTRAUB)
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Help - Label failed after DB version change
Hello,
On 11.10.2005 13:07, Traub, Kevin (KTRAUB) wrote:
Hello all;
I've been using Bacula for about a year now to back up some linux
machines using RAID disk storage instead to tape and all has been
working great.
I upgraded some months ago to 1.34.6 and all seemed to go well. I used
the DB upgrade script when I upgraded.
However, I had to restart my server last week and when the bacula-sd
tried to start it would stop with an error message saying:
bacula-dir: Fatal error: Version error for database "bacula". Wanted
7, got 6
bacula-dir: Fatal error: Version error for database "bacula". Wanted
7, got 6
bacula-dir: Fatal error: Could not open database "bacula".
bacula-dir: Fatal error: Version error for database "bacula". Wanted
7, got 6 bacula-dir ERROR TERMINATION
That looks as though the database upgrade didn't work correctly.
The next error you report might be a result of that, too.
I'd suggest to change back the version in the database, and run the
upgrade script again. After that, better do a dbckeck run to see if the
catalog is usable.
After that, I'd suggest upgrading to 1.36.3 as this has some
improvements.
Of course, don't forget to backup your database before further
modifications - pg_dump is the tool you might want.
Arno
I went into the postgres bacula database and changed the versionid to
7 as in:
bacula=# update version set versionid = 7;
And now the director will start and backups will run but when I go to
label a new volume I get the following message:
*label
Automatically selected Storage: File
Enter new Volume name: Vol_34
Automatically selected Pool: Default
Connecting to Storage daemon File at acsbackup.arinc.com:9103 ...
Sending label command for Volume "Vol_34" Slot 0 ... 3000 OK label.
Volume=Vol_34 Device=/mnt/raid0/ sql_create.c:279 Create DB Media
record INSERT INTO Media
(VolumeName,MediaType,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolR
et
ention,VolUseDuration,MaxVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InC
hanger,VolReadTime,VolWriteTime) VALUES
('Vol_34','File',2,0,0,0,47347200,604800,0,0,'Append',0,1,1,0,0)
failed.
ERR=ERROR: ExecInsert: Fail to add null value in not null attribute
endfile
Do not forget to mount the drive!!!
Any help would be appreciated.
-Kevin Traub
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads,
discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
