On 05/04/18 14:58, Ken Mandelberg wrote: [...] > So I ran > > /usr/share/bacula-director/update_mysql_tables > > I had to change db_name in the script to "bacula", but it seemed to have > worked and the the director was able to start > ------------- > > I hope I ran the right script. To be honest I was surprised the only copy was > in /usr/share and that I had to hand edit the db_name to 'bacula" in the > script. > > It did change from 14 to 16. The Query to Media has a long list of fields and > comparing the query to fields in the Media Table > I see 7 missing fields: VolType,VolHoles,VolHoleBytes, > VolABytes,VolCloudParts,LastPart,LastPartBytes. > > Looking at the script it should have added these fields but didn't. I wonder > if that was because I ran it before the zero date > issue was fixed.
That is very likely the problem. > Any suggestion on how to recover? The VersionId does show 16, so the script > is not going to re-run as is. Can you restore a previous-to-upgrade version of the database from a backup and re-run the upgrade script? -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
