Backup Central

Hi all!

I'm trying to update the database tables of Bacula 3.0.2 using the
script update_bacula_tables, but when doing I obtain it the following
errors:

---------------------------------------------------------------------
backup:/etc/bacula/scripts# ./update_bacula_tables
Altering MySQL tables

This script will update a Bacula MySQL database from version 11 to 12
which is needed to convert from Bacula Enterprise 2.6 to 4.0 or
Standard version 3.0 to 5.0

ERROR 1091 (42000) at line 3: Can't DROP 'Stripe'; check that column/key exists
ERROR 1050 (42S01) at line 20: Table 'PathHierarchy' already exists
ERROR 1061 (42000) at line 27: Duplicate key name 'pathhierarchy_ppathid'
ERROR 1050 (42S01) at line 30: Table 'PathVisibility' already exists
ERROR 1061 (42000) at line 38: Duplicate key name 'pathvisibility_jobid'
Update of Bacula MySQL tables succeeded.
---------------------------------------------------------------------

Which can be the problem? I would have to use another procedure?


Thanks in advance for your reply.

Regards,
Daniel
--
Fingerprint: BFB3 08D6 B4D1 31B2 72B9 29CE 6696 BF1B 14E6 1D37
Powered by Debian GNU/Linux Lenny - Linux user #188.598

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Am Sun, 28 Feb 2010 11:42:59 -0300 schrieb Daniel Bareiro:

Hi all!

I'm trying to update the database tables of Bacula 3.0.2 using the
script update_bacula_tables, but when doing I obtain it the following
errors:

---------------------------------------------------------------------
backup:/etc/bacula/scripts# ./update_bacula_tables Altering MySQL tables

This script will update a Bacula MySQL database from version 11 to 12
which is needed to convert from Bacula Enterprise 2.6 to 4.0 or
Standard version 3.0 to 5.0

ERROR 1091 (42000) at line 3: Can't DROP 'Stripe'; check that column/key
exists ERROR 1050 (42S01) at line 20: Table 'PathHierarchy' already
exists ERROR 1061 (42000) at line 27: Duplicate key name
'pathhierarchy_ppathid' ERROR 1050 (42S01) at line 30: Table
'PathVisibility' already exists ERROR 1061 (42000) at line 38: Duplicate
key name 'pathvisibility_jobid' Update of Bacula MySQL tables succeeded.
---------------------------------------------------------------------

Which can be the problem? I would have to use another procedure?

IMHO these don't seem to be "error" messages. it tries to delete a column
but it doesn't exist. it tries to create new tables, but they already
exist. tries to create a new index, but it already exists.

maybe you ran it twice?

i would say: all is fine.

- Thomas


------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Hi, Thomas.

On Tuesday, 02 March 2010 12:29:31 +0000,
Thomas Mueller wrote:

I'm trying to update the database tables of Bacula 3.0.2 using the
script update_bacula_tables, but when doing I obtain it the
following errors:

---------------------------------------------------------------------
backup:/etc/bacula/scripts# ./update_bacula_tables Altering MySQL tables

This script will update a Bacula MySQL database from version 11 to 12
which is needed to convert from Bacula Enterprise 2.6 to 4.0 or
Standard version 3.0 to 5.0

ERROR 1091 (42000) at line 3: Can't DROP 'Stripe'; check that column/key
exists ERROR 1050 (42S01) at line 20: Table 'PathHierarchy' already
exists ERROR 1061 (42000) at line 27: Duplicate key name
'pathhierarchy_ppathid' ERROR 1050 (42S01) at line 30: Table
'PathVisibility' already exists ERROR 1061 (42000) at line 38: Duplicate
key name 'pathvisibility_jobid' Update of Bacula MySQL tables succeeded.
---------------------------------------------------------------------

Which can be the problem? I would have to use another procedure?

IMHO these don't seem to be "error" messages. it tries to delete a
column but it doesn't exist. it tries to create new tables, but they
already exist. tries to create a new index, but it already exists.

maybe you ran it twice?

i would say: all is fine.

It drew attention to me because after to have seen this error, I've
executed to bacula-dir with -d 200 and this failed saying that it did
not find a MySQL database version 12. I try again to realise the update
from Bacula 3 and this time were no problems.

Thanks for your reply.

Regards,
Daniel
--
Fingerprint: BFB3 08D6 B4D1 31B2 72B9 29CE 6696 BF1B 14E6 1D37
Powered by Debian GNU/Linux Lenny - Linux user #188.598

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users