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
signature.asc
Description: Digital signature
------------------------------------------------------------------------------
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 DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
| 