[Bacula-users] Error: create_file.c:329 Could not hard link and Error: attribs.c:558 File size of restored file
During a test restore I received the following two error message. Can someone assist in understand these errors beyond the obvious? One point of note, I upgraded from 9.0.4 to 9.0.5 between backup job and restore job. 07-Nov 11:53 bacula-fd JobId 4177: Error: attribs.c:558 File size of restored file /backup/bacula/restore/Data/gfs/gfs_datavol/awsdata/eventdb/CUSTOMER_1/default/17474/419376-419399-2886795624/seg-0-48-1748948308/stat/CUSTOMER_2031.stat not correct. Original 13297, restored 13299. 07-Nov 11:53 bacula-fd JobId 4177: Error: attribs.c:558 File size of restored file /backup/bacula/restore/L360Data/gfs/gfs_datavol/awsdata/eventdb/CUSTOMER_1/default/17474/419376-419399-2886795624/seg-0-48-1748948308/stat/CUSTOMER_2031.stat not correct. Original 13297, restored 13299. I have attached the backup chain, the full restore job log, and the logs of the backups they are associated with. Thank you in advance. Jim Richardson CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email in error, please notify the sender and delete this email from your system. Thank you. 06-Nov 21:30 bacula-dir JobId 4160: Start Backup JobId 4160, Job=C2T-LargeApp-Data.2017-11-06_21.30.00_33 06-Nov 21:30 bacula-dir JobId 4160: Created new Volume="H-4160-C2T-LargeApp-Data.2017-11-06_21.30.00_33.bak", Pool="Pool_Hourly2Disk", MediaType="HourlyDisk" in catalog. 06-Nov 21:30 bacula-dir JobId 4160: Using Device "HourlyDevice1" to write. 06-Nov 21:30 bacula-sd JobId 4160: Labeled new Volume "H-4160-C2T-LargeApp-Data.2017-11-06_21.30.00_33.bak" on File device "HourlyDevice1" (/backup/bacula/hourly). 06-Nov 21:30 bacula-sd JobId 4160: Wrote label to prelabeled Volume "H-4160-C2T-LargeApp-Data.2017-11-06_21.30.00_33.bak" on File device "HourlyDevice1" (/backup/bacula/hourly) 06-Nov 22:09 bacula-sd JobId 4160: Elapsed time=00:39:10, Transfer rate=67.90 M Bytes/second 06-Nov 22:09 bacula-sd JobId 4160: Sending spooled attrs to the Director. Despooling 21,909,257 bytes ... 06-Nov 22:09 bacula-dir JobId 4160: Bacula bacula-dir 9.0.4 (06Sep17): Build OS: x86_64-redhat-linux-gnu redhat (Core) JobId: 4160 Job:C2T-LargeApp-Data.2017-11-06_21.30.00_33 Backup Level: Incremental, since=2017-11-06 18:30:25 Client: "bacula-fd" 9.0.4 (06Sep17) x86_64-redhat-linux-gnu,redhat,(Core) FileSet:"LargeApp Data" 2017-06-25 12:35:50 Pool: "Pool_Hourly2Disk" (From Run Pool override) Catalog:"MyCatalog" (From Client resource) Storage:"Storage_Hourly2Disk" (From Pool resource) Scheduled time: 06-Nov-2017 21:30:00 Start time: 06-Nov-2017 21:30:02 End time: 06-Nov-2017 22:09:22 Elapsed time: 39 mins 20 secs Priority: 12 FD Files Written: 62,318 SD Files Written: 62,318 FD Bytes Written: 159,562,232,380 (159.5 GB) SD Bytes Written: 159,577,113,024 (159.5 GB) Rate: 67611.1 KB/s Software Compression: None Comm Line Compression: None Snapshot/VSS: no Encryption: no Accurate: no Volume name(s): H-4160-C2T-LargeApp-Data.2017-11-06_21.30.00_33.bak Volume Session Id: 1235 Volume Session Time:1507129810 Last Volume Bytes: 159,697,482,602 (159.6 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination:Backup OK 06-Nov 22:09 bacula-dir JobId 4160: Begin pruning Jobs older than 6 months . 06-Nov 22:09 bacula-dir JobId 4160: No Jobs found to prune. 06-Nov 22:09 bacula-dir JobId 4160: Begin pruning Files. 06-Nov 22:09 bacula-dir JobId 4160: No Files found to prune. 06-Nov 22:09 bacula-dir JobId 4160: End auto prune. 06-Nov 18:30 bacula-dir JobId 4147: Start Backup JobId 4147, Job=C2T-LargeApp-Data.2017-11-06_18.30.00_20 06-Nov 18:30 bacula-sd JobId 4147: 3307 Issuing autochanger "unload Volume 09L7, Slot 6, Drive 0" command. 06-Nov 18:30 bacula-dir JobId 4147: Using Device "ULT3580" to write. 06-Nov 18:30 bacula-sd JobId 4147: 3304 Issuing autochanger "load Volume 08L7, Slot 3, Drive 0" command. 06-Nov 18:30 bacula-sd JobId 4147: 3305 Autochanger "load Volume 08L7, Slot 3, Drive 0", status is OK. 06-Nov 18:30 bacula-sd JobId 4147: Volume "08L7" previously written, moving to end of data. 06-Nov 18:31 bacula-sd JobId 4147: Ready to append to end of Volume "08L7" at file=2661. 06-Nov 19:52 bacula-sd JobId 4147: Elapsed time=01:21:12, Transfer rate=55.15 M Bytes/second 06-Nov 19:52 bacula-sd JobId 4147: Sending spooled attrs to the Director. Despooling 59,002,575 bytes ... 06-Nov 19:52 bacula-dir JobId 4147: Bacula bacula-dir 9.0.4 (06Sep17):
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
Oops, my error. I was looking at a file that was created with the Enterprise Source. The correct version for the current community version is actually 16 (not 1019, which is the BEE version). Anyway, I see that your problem is resolved. Best regards, Kern On 11/08/2017 03:44 PM, Kern Sibbald wrote: Either it is a Bacula bug, or you are not using version 9.0.x On 11/08/2017 02:40 PM, bernhard.glomm wrote: UPDATE Version SET VersionId=1019; why is that so when bacula-director want version 16 instead of 15 as said in the logfile "Fatal error: Version error for database "bacula". Wanted 16, got 15" On 2017-11-08 13:44, Kern Sibbald wrote: Hello, In source form the script may not be too useful because the paths are different for each packager. I recommend that you look at your binary files as they should have included the script. You can also do: find / -name "update_bacula_tables" if there are multiple copies, you will need to look at either update_postgresql_tables or update_mysql_tables (depending on what database you are using) and make sure it has: UPDATE Version SET VersionId=1019; as the last UPDATE Version command in the file. So, in your upgrade the version will go from 15 up to 1019 in several updates. Best regards, Kern On 11/08/2017 01:23 PM, bernhard.glomm wrote: ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
Either it is a Bacula bug, or you are not using version 9.0.x On 11/08/2017 02:40 PM, bernhard.glomm wrote: UPDATE Version SET VersionId=1019; why is that so when bacula-director want version 16 instead of 15 as said in the logfile "Fatal error: Version error for database "bacula". Wanted 16, got 15" On 2017-11-08 13:44, Kern Sibbald wrote: Hello, In source form the script may not be too useful because the paths are different for each packager. I recommend that you look at your binary files as they should have included the script. You can also do: find / -name "update_bacula_tables" if there are multiple copies, you will need to look at either update_postgresql_tables or update_mysql_tables (depending on what database you are using) and make sure it has: UPDATE Version SET VersionId=1019; as the last UPDATE Version command in the file. So, in your upgrade the version will go from 15 up to 1019 in several updates. Best regards, Kern On 11/08/2017 01:23 PM, bernhard.glomm wrote: ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
[Bacula-users] SOLVED: Fatal error: Version error for database "bacula". Wanted 16, got 15
Sorry for the fuzz, thnx Martin that was "the right answer" ;-) that script is okay (one only has to set the dbname in the script) after executing it the director starts as expected. thnx everybody for the various hints best Bernhard On 2017-11-08 14:17, Martin Simmons wrote: You could try: dpkg -S update_mysql_tables I think it should be here: /usr/share/bacula-director/update_mysql_tables __Martin Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
UPDATE Version SET VersionId=1019; why is that so when bacula-director want version 16 instead of 15 as said in the logfile "Fatal error: Version error for database "bacula". Wanted 16, got 15" On 2017-11-08 13:44, Kern Sibbald wrote: Hello, In source form the script may not be too useful because the paths are different for each packager. I recommend that you look at your binary files as they should have included the script. You can also do: find / -name "update_bacula_tables" if there are multiple copies, you will need to look at either update_postgresql_tables or update_mysql_tables (depending on what database you are using) and make sure it has: UPDATE Version SET VersionId=1019; as the last UPDATE Version command in the file. So, in your upgrade the version will go from 15 up to 1019 in several updates. Best regards, Kern On 11/08/2017 01:23 PM, bernhard.glomm wrote: ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
You could try: dpkg -S update_mysql_tables I think it should be here: /usr/share/bacula-director/update_mysql_tables __Martin > On Wed, 08 Nov 2017 11:58:14 +0100, bernhard glomm said: > > hi all > after a regular apt-get update && apt-get upgrade > on a "trusty" ubuntu system > the upgrade of package bacula-director FAILED > with the following errors in bacula_daemon.log: > > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database > "bacula". Wanted 16, got 15 > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog > "", database "bacula". > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database > "bacula". Wanted 16, got 15 > 08-Nov 10:27 bacula-dir ERROR TERMINATION > Please correct configuration file: /etc/bacula/bacula-dir.conf > > I can't find any > > update_mysql_tables > > script or the like, > has anybody successfully upgraded bacula-director to version: > > [/0]:/tmp # dpkg -l | egrep bacula-director > iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 > amd64network backup service - Director daemon > iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 > amd64transitional package for bacula-director > ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 > amd64network backup service - MySQL storage for Director > > Any hint how to proceed from here is VERY welcome. > > best regards > > Bernhard > > > Ecologic Institut gemeinnuetzige GmbH > Pfalzburger Str. 43/44, D-10717 Berlin > Geschaeftsfuehrerin / Director: Dr. Camilla Bausch > Sitz der Gesellschaft / Registered Office: Berlin (Germany) > Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), > HRB 57947 > > -- > 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 > -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
I use Git for compil from source. And to have a v9.x.x not in binary (?) ... i under CentOs 7.4 / Postgres Prod -> bacula v7.4.7 Test -> bacula v9.0.4 ( -> 9.0.5 at 20171102 ) Le 08/11/2017 à 13:23, bernhard.glomm a écrit : ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
Hello, In source form the script may not be too useful because the paths are different for each packager. I recommend that you look at your binary files as they should have included the script. You can also do: find / -name "update_bacula_tables" if there are multiple copies, you will need to look at either update_postgresql_tables or update_mysql_tables (depending on what database you are using) and make sure it has: UPDATE Version SET VersionId=1019; as the last UPDATE Version command in the file. So, in your upgrade the version will go from 15 up to 1019 in several updates. Best regards, Kern On 11/08/2017 01:23 PM, bernhard.glomm wrote: ?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
?? you mean the script might be in the source packages but not in the binary packages ?? bizarre but I will have a look On 2017-11-08 13:03, Olivier Delestre wrote: For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) @page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 120% } pre.cjk { font-family: "NSimSun", monospace } a:link { so-language: zxx } Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - Director daemon iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 amd64transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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 Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
> hi all Hello, Bernhard, > after a regular apt-get update && apt-get upgrade > on a "trusty" ubuntu system > the upgrade of package bacula-director FAILED > with the following errors in bacula_daemon.log: > > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database > "bacula". Wanted 16, got 15 > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog > "", database "bacula". > 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database > "bacula". Wanted 16, got 15 > 08-Nov 10:27 bacula-dir ERROR TERMINATION > Please correct configuration file: /etc/bacula/bacula-dir.conf > > I can't find any > > update_mysql_tables > > script or the like, > has anybody successfully upgraded bacula-director to version: > > [/0]:/tmp # dpkg -l | egrep bacula-director > iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 > amd64network backup service - Director daemon > iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 > amd64transitional package for bacula-director > ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 > amd64network backup service - MySQL storage for Director > > Any hint how to proceed from here is VERY welcome. Probably this package built was incomplete (that's one reason I like to build Bacula from source - http://bacula.us/compilation). Anyway, I'm sending my 9.0.3 Ubuntu build update script attached, so you can try your luck. > best regards Regards, > Bernhard > > > Ecologic Institut gemeinnuetzige GmbH > Pfalzburger Str. 43/44, D-10717 Berlin > Geschaeftsfuehrerin / Director: Dr. Camilla Bausch > Sitz der Gesellschaft / Registered Office: Berlin (Germany) > Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), > HRB 57947 > > -- > 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 -- === Heitor Medrado de Faria | CEO Bacula do Brasil & USA | Visto EB-1 | LPIC-III | EMC 05-001 | ITIL-F • Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula Enterprise http://www.bacula.com.br/enterprise/ • Ministro treinamento e implementação in-company do Bacula Community http://www.bacula.com.br/in-company/ Brazil +55 (61) 98268-4220 | USA +1 (323) 300-5387 | www.bacula.com.br Indicamos as capacitações complementares: Shell básico e Programação em Shell com Julio Neves | Zabbix com Adail Host. update_mysql_tables Description: application/shellscript -- 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
Re: [Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
For me with bacula 7.4.7 /usr/local/src/bacula/bacula/src/cats/update_bacula_tables et grant_bacula_privileges ( with user postgres ) bacula=# select * from version; versionid --- 15 And 16 for version 9 (?) Le 08/11/2017 à 11:58, bernhard.glomm a écrit : hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - Director daemon iU bacula-director-common 9.0.4+dfsg-2+hawk~trusty+1 amd64 transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64 network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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 -- 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
[Bacula-users] Fatal error: Version error for database "bacula". Wanted 16, got 15
hi all after a regular apt-get update && apt-get upgrade on a "trusty" ubuntu system the upgrade of package bacula-director FAILED with the following errors in bacula_daemon.log: 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Could not open Catalog "", database "bacula". 08-Nov 10:27 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 16, got 15 08-Nov 10:27 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf I can't find any update_mysql_tables script or the like, has anybody successfully upgraded bacula-director to version: [/0]:/tmp # dpkg -l | egrep bacula-director iF bacula-director 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - Director daemon iU bacula-director-common9.0.4+dfsg-2+hawk~trusty+1 amd64transitional package for bacula-director ii bacula-director-mysql 9.0.4+dfsg-2+hawk~trusty+1 amd64network backup service - MySQL storage for Director Any hint how to proceed from here is VERY welcome. best regards Bernhard Ecologic Institut gemeinnuetzige GmbH Pfalzburger Str. 43/44, D-10717 Berlin Geschaeftsfuehrerin / Director: Dr. Camilla Bausch Sitz der Gesellschaft / Registered Office: Berlin (Germany) Registergericht / Court of Registration: Amtsgericht Berlin (Charlottenburg), HRB 57947 -- 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