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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
