Hi, thanks for your reply. Ad 1: they are the same, specifically 7.4.3+dfsg-1+sid1~bpo8+1 from jessie-backports (I just verified it). For this test, even the FDs were this version.
Ad 2: I worked with clean catalog: - stop director and storages - psql: drop database bacula - psql: create database bacula owner bacula - PGPASSWORD=XXXXX db_name=bacula /usr/share/bacula-director/make_postgresql_tables -U bacula -h bacdb1.cent -d bacula - start director and storages, enable trace To be sure, i checked PostgreSQL logs, and there is only one error, repeating every time bacula runs a job: Apr 3 20:00:01 bacdb1 postgres[10867]: [24-1] 2017-04-03 20:00:01 CEST [10867-43] bacula@bacula ERROR: table "delcandidates" does not exist Apr 3 20:00:01 bacdb1 postgres[10867]: [24-2] 2017-04-03 20:00:01 CEST [10867-44] bacula@bacula STATEMENT: DROP TABLE DelCandidates I don't know why bacula tries to delete nonexistent tables, but looking to the source code, this query is used only when pruning jobs to clean up temporary tables. I think it is harmless. I ran dbcheck against my catalog, and it found 2 orphaned clients (one is not accessible in testing env and not needed, one have it's job stuck) and 2 orphaned filesets (both have jobs that didn't run yet). So no errors there either. The server is OpenStack virtual server running on our infrastructure, there were no crashes nor any problems I know of. Is there any other way to check for catalog damage? Ad 3: I run the jobs manualy after setting up new catalog, it takes only few minutes. My retention periods are 7 days minimum. Ad 4: I do not edit the catalog manually. I was using bacula-web to display contents of the catalog, so to be sure I just re-run the test with clean catalog and bacula-web disabled and the bug is still here. Ad 5: I created it fresh by running make_postgresql_tables (from bacula package) in empty database. root@bacdir1:~# dpkg -S /usr/share/bacula-director/make_postgresql_tables bacula-director-pgsql: /usr/share/bacula-director/make_postgresql_tables root@bacdir1:~# dpkg -l bacula-director-pgsql | grep "^ii" ii bacula-director-pgsql 7.4.3+dfsg-1+sid1~bpo8+1 amd64 network backup service - PostgreSQL storage for Director [PREP]root@bacdir1:~# grep /usr/share/bacula-director/make_postgresql_tables -e Version INSERT INTO Version (VersionId) VALUES (15); Ad 6: there are 3 programs that could do it automatically: bacula director, bacula-web (I disabled it) and nagios check (we don't run nagios in test environment). I am quite sure nobody except bacula can do it. And yes, I am sure no of my co-workers could mess with catalog either, I did ask. Looking at the above, I am starting to think it may be a bug in Bacula. Should i report it? Where? With regards, Zdeněk Bělehrádek Dne 3.4.2017 v 18:51 Kern Sibbald napsal(a): > Hello, > > The error you are getting should never happen, which means that > something is seriously wrong with your Bacula installation. A few of > the multiple possibilities are: > > 1. Your DIR and SDs are not on the same version. They *must* all be the > same. With the little information you provided, for the moment this > seems to be the most likely problem. > > 2. Your catalog is damaged. > > 3. Your Retention periods are too short and records are being removed > from the catalog. > > 4. You have manually modified your catalog, so that now the records are > not consistent. > > 5. Your catalog does not correspond to the Bacula Director version you > are running. This should be detected, but perhaps the catalog was later > manually modified. > > 6. Either manually or some program is removing Volume records from the > catalog or changing them (this point is probably a duplication of point 4) > > Best regards, > > Kern > ------------------------------------------------------------------------------ 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
