No files for jobs in restore WebUI after upgrate 18.2.5 -> 19.2.5

[Vladislav Solovei]

I've upgraded bareos 18.2.5 -> 19.2.5

PostgreSQL.

/usr/lib/bareos/scripts/update_bareos_tables

DB migrated to version 2192

.bvfs_clear_cache yes done without errors.

After .bvfs_update, some error messages appears in the logfile:

09-Feb 13:08 bareos-dir JobId 0: Fatal error: cats/bvfs.cc:244 cats/bvfs.cc:244 query INSERT INTO PathVisibility (PathId, JobId) SELECT DISTINCT PathId, JobId FROM (SELECT PathId, JobId FROM File WHERE JobId = 13066 UNION SELECT PathId, BaseFiles.JobId FROM BaseFiles JOIN File AS F USING (FileId) WHERE BaseFiles.JobId = 13066) AS B failed:       ERROR:  duplicate key value violates unique constraint "pathvisibility_pkey"

Restore dialog in WebUI shows all jobs for clients, but files list is empty for all of them :(

[Vladislav Solovei]

It looks like the job list has been sorted in reverse order :) Can this be fixed somehow?

воскресенье, 9 февраля 2020 г., 13:26:53 UTC+2 пользователь Vladislav Solovei написал:

[aeron...@gmail.com]

FYI

I reported this as an issue on the bug site. I think Frank got the assignment.

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/12c0df73-676f-4066-b1c9-578e343739b7%40googlegroups.com.