Spoke too soon, I see what's going on, I was running update script from
new location (7.2.0) and it's referencing old location (7.0.5) and
running the wrong mysql script.



On 09/25/2015 08:34 AM, Stephen Thompson wrote:
>
> Help?
>
> Well, the compile and install went fine, but the update tables script is
> having issue.
>
> I was running 7.0.5 before.  Not sure what database version, but likely
> whatever was appropriate to 7.0.5.
>
>
> First time I ran script as su'ed user which caused this...
> ----------
> Altering mysql tables
>
> This script will update a Bacula MySQL database from version 12 to 14
>    which is needed to convert from Bacula Community version 5.0.x to 5.2.x
>
> ERROR 1045 (28000): Access denied for user 'stephen'@'localhost' (using
> password: YES)
> /home/bacula/conf/update_mysql_tables: line 31: [: !=: unary operator
> expected
> ERROR 1045 (28000): Access denied for user 'stephen'@'localhost' (using
> password: YES)
> Update of Bacula MySQL tables failed.
> ----------
>
> I assumed because access denied, that the script failed entirely, but
> then running it again as proper user...
>
> Second time...
> -----------
> ./update_bacula_tables
> Altering mysql tables
>
> This script will update a Bacula MySQL database from version 12 to 14
>    which is needed to convert from Bacula Community version 5.0.x to 5.2.x
>
> /home/bacula/conf/update_mysql_tables: line 31: [: too many arguments
> ERROR 1050 (42S01) at line 1: Table 'RestoreObject' already exists
> ERROR 1061 (42000) at line 17: Duplicate key name 'jobhisto_jobid_idx'
> ERROR 1060 (42S21) at line 19: Duplicate column name 'DeltaSeq'
> Update of Bacula MySQL tables succeeded.
> ----------
>
> Seems like it either partially ran before or I had changes already
> present from 7.0.5 update.
>
> However, my Director will not start due to database version number not
> being 15, and if I run the script any more times...
> ----------
> Altering mysql tables
>
> This script will update a Bacula MySQL database from version 12 to 14
>    which is needed to convert from Bacula Community version 5.0.x to 5.2.x
>
>
> The existing database is version 14 !!
> This script can only update an existing version 12 database to version 14.
> Error. Cannot upgrade this database.
> ----------
>
>
> If it updatad the database to 14, why is it not able to update to 15 if
> that's what the Director requires?
>
>
> thanks!
> Stephen
>
>
>
>
>
> On 09/24/2015 11:21 AM, Kern Sibbald wrote:
>> Hello,
>>
>> We put a caution message in every release, particularly for new features
>> which are generally tested but not always tested in production. Normally
>> most of the issues turn up for non-Linux distributions where we either
>> have not tested or have tested less than Linux.
>>
>> Version 7.2.0 is as stable or more so than any prior major release. That
>> said, there are always a few minor problems for each release and this
>> one is no different.  All the important problems (build issues on
>> Solaris and FreeBSD) have been corrected in the public git repository.
>>
>> Best regards,
>> Kern
>>
>> On 15-09-24 11:40 AM, Stephen Thompson wrote:
>>> All,
>>>
>>> I typically patch bacula pretty frequently, but I saw the somewhat
>>> unusual notice on the latest release notes that warns it may not be
>>> ready for use in production.  How stable is it?  I don't really have the
>>> resources to test this out, but rather would have to go straight to
>>> production with it.  I could always roll back, but that might entail the
>>> recovery from dump of a 900GB database.  Opinions?
>>>
>>> thanks,
>>> Stephen
>

--
Stephen Thompson               Berkeley Seismological Laboratory
stephen AT seismo.berkeley DOT edu    215 McCone Hall # 4760
Office: 510.664.9177           University of California, Berkeley
Remote: 510.214.6506 (Tue,Wed) Berkeley, CA 94720-4760

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users