Hello Karl,
Thanks for providing the debug log.
You are trying to restore the file "Screencast_2021-06-25_15:10:14.webm".
The command responsible for creating the temporary Bvfs table for this
restore fails with the following error message "Can't create restore list":
[0] => .bvfs_restore jobid="3,1" path="b2460" fileid="14"
[1] => Using Catalog "MyCatalog"
[2] => Can't create restore list
For me the Baculum part looks correct. From this reason I would propose to
look in the Bacula Director to find an answer on the question why the
temporary Bvfs table is not created. For this purpose you can enable debug
on the Director side by the following Bconsole command:
setdebug level=100 trace=1 tags=bvfs,sql dir
When you go through the Baculum restore wizard once again in your Bacula
Director working directory (defined in bacula-dir.conf in the
WorkingDirectory directive) you will see a new file named:
your_director_name.trace In this file will be logged all SQL queries from
Bvfs commands. One from them will fail for some reason and the reason will
tell us why you are not able to do the restore.
Good luck.
Best regards,
Marcin Haba (gani)
On Mon, 14 Nov 2022 at 15:06, Mag. Dr. Karl Kashofer <k...@kashofer.org>
wrote:
> Hi Marcin !
>
> Thanks for your help, i have generated and a log from the
> failing request, posted here:
>
> https://pastebin.com/EUXemHZM
>
> Do you see anything obvious in there ?
>
> Cheers,
> KK
>
> Am Montag, dem 14.11.2022 um 04:55 +0100 schrieb Marcin Haba:
> > Hello Karl,
> >
> > The problem here is because from some reason the Bvfs temporary
> > table 'b25796' has not been created. The bconsole command that
> > creates this temporary table is .bvfs_restore.
> >
> > To see the problem, I would propose to enable debug in the Baculum
> > API, then do a restore try once again and check in the debug file
> > what is output from .bvfs_restore.
> >
> > Good luck.
> >
> > Best regards,
> > Marcin Haba (gani)
> >
> > On Sun, 13 Nov 2022 at 12:25, Mag. Dr. Karl Kashofer
> > <k...@kashofer.org> wrote:
> > > Hi !
> > >
> > > I use baculum 11.0.6 from docker image pwa666/bacula-server:latest
> > >
> > > I successfully generated file storage and set up clients via
> > > baculum.
> > > I then did a backup job from my laptop for testing.
> > > It is generated OK.
> > >
> > > However, when i try to restore anything from the backup via the
> > > restore wizard i get:
> > >
> > > > Error
> > > >
> > > > restore client="Karl Laptop" file="?b25796" replace="never"
> > > > restorejob="RestoreFiles" where="/tmp/restore" yes
> > > > Using Catalog "MyCatalog"
> > > > Query failed: SELECT JobId, FileIndex FROM b25796 ORDER BY
> > > JobId,
> > > > FileIndex ASC. ERR=Query failed: SELECT JobId, FileIndex FROM
> > > b25796
> > > > ORDER BY JobId, FileIndex ASC: ERR=no such table: b25796
> > > >
> > > > No table found: b25796
> > > > No files selected to be restored.
> > >
> > > When i select different files for restore, the number in bXXX
> > > changes.
> > >
> > > Inspecting the bacula.db i see no tables with that bXXX names, nor
> > > anything resembling that.
> > >
> > > Any help appreciated.
> > > Regards,
> > > Karl
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > Bacula-users mailing list
> > > Bacula-users@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
> >
>
>
--
"Greater love hath no man than this, that a man lay down his life for his
friends." Jesus Christ
"Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za
przyjaciół swoich." Jezus Chrystus
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
