Phil Stracchino wrote on 05/04/2018 03:03 PM:
On 05/04/18 14:58, Ken Mandelberg wrote:
[...]
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?
Well the backup I was counting on doesn't exist. I Duplicated the Ubuntu
16.04 filesystem in another slice before doing the OS upgrade, assuming
I would have a copy of everything pre-update. It was a big surprise to
find that the update updated both the live slice and the backup slice
to 18.04.
Furthermore looking at the mysql bacula database post install, it looks
corrupted. See below.
I didn't do anything that isn't default for a mysql or a bacula saved
copy of the mysql bacula database. Presumably I can extract one from the
volumes (which are actually files not tapes). I could use some advise on
how to do that.
I had planned just to fix up the database I had by manually doing what
the update script does, but when I ran into what must be corruption
shown below, it seems like I should start over from a backup.
mysql> use bacula;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------+
| Tables_in_bacula |
+------------------+
| BaseFiles |
| CDImages |
| Client |
| Counters |
| Device |
| File |
| FileSet |
| Filename |
| Job |
| JobHisto |
| JobMedia |
| Location |
| LocationLog |
| Log |
| Media |
| MediaType |
| Path |
| PathHierarchy |
| PathVisibility |
| Pool |
| RestoreObject |
| Status |
| Storage |
| UnsavedFiles |
| Version |
+------------------+
25 rows in set (0.00 sec)
mysql> describe Media;
ERROR 1146 (42S02): Table 'bacula.Media' doesn't exist
(I haven't tried them all, but many of the other tables exist).
------------------------------------------------------------------------------
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
