Re: [Bacula-users] Bacula-users Digest, Vol 36, Issue 38
2009-04-28 08:14:11
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Eitan,
I had a similar problem.
The database contains a table name Version containing just one column named
VersionId.
You need to update the VersionId from '10' to '11'.
The easiest way to do this is to copy the sqlite3.exe program from the "Program
Files\bacula\bin" directory to the "Document and Settings\All User\Application
Data\bacula\work" directory because the bacula.db database file is here.
Open a command prompt (DOS) windows and go to the work directory using the 'cd'
command.
Type in:
sqlite3 bacula.db
>
type in .help to get help, .exit to exit
You need to update the VersionId. The relevant sql command is:
update table Version set VersionId='11' where VersionId='10';
Then check running command:
select * from Version;
This should display just '11'.
Exit the program; you're done.
Hope this helps,
Bernd
On Tue, 28 Apr 2009 10:51:11 +0000
bacula-users-request AT lists.sourceforge DOT net wrote:
> Message: 16
> Date: Tue, 28 Apr 2009 10:01:25 +0300
> From: Eitan Talmi <eitant AT gmail DOT com>
> Subject: [Bacula-users] Director is not starting after backup
> To: Bacula-users AT lists.sourceforge DOT net
> Message-ID:
> <10dcacc80904280001gf7d322h5ec69ec618cc39d3 AT mail.gmail DOT com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all
>
> After upgrading from version 2.4.4 to 3.0.0 the director is not starting.
>
> If I am running bacula-dir -t I am getting this error message
>
> bacula-dir: dird.c:878 Could not open Catalog "MyCatalog", database
> "bacula".
> bacula-dir: dird.c:883 Version error for database "bacula". Wanted 10, got
> 11
> 28-Apr 09:11 bacula-dir ERROR TERMINATION
>
>
> I already run the update_bacula_tables script couple of times with no luck
> this is what I am receiving after running the script
>
> Altering MySQL tables
>
> This script will update a Bacula MySQL database from version 10 to 11
> which is needed to convert from Bacula version 2.0.x to 3.0.x or higher
>
> ERROR 1060 (42S21) at line 8: Duplicate column name 'ReadBytes'
> ERROR 1060 (42S21) at line 9: Duplicate column name 'ActionOnPurge'
> ERROR 1060 (42S21) at line 10: Duplicate column name 'ActionOnPurge'
> ERROR 1050 (42S01) at line 19: Table 'JobHisto' already exists
> Update of Bacula MySQL tables succeeded.
>
>
> Thanks
> Eitan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkn28ZgACgkQpYU8M8PbPV4a2wCdG76xDzWzE5h40DQqeCg0c8t7
DwYAn0mzwGbyQPXSmaIDpu/6t0deoVXJ
=OOyG
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Re: [Bacula-users] Bacula-users Digest, Vol 36, Issue 38,
Bernd Plagge <=
|
|
|