Thanks, Marcin!! bacula-dir: ua_dotcmds.c:177-0 Cmd: .bvfs_lsdirs jobid=17911 path= bacula-dir: ua_cmds.c:2613-0 UA Open database bacula-dir: mysql.c:119-0 db_init_database first time bacula-dir: mysql.c:224-0 mysql_init done bacula-dir: mysql.c:263-0 mysql_real_connect done bacula-dir: mysql.c:265-0 db_user=bacula db_name=bacula db_password=xxxxxxxxx bacula-dir: mysql.c:301-0 opendb ref=1 connected=1 db=7f17f4003480 bacula-dir: ua_cmds.c:2662-0 DB bacula opened bacula-dir: bvfs.c:139-0 No ACL bacula-dir: bvfs.c:1084-0 ls_special_dirs(92295) bacula-dir: bvfs.c:1121-0 q=SELECT 'D', tmp.PathId, 0, tmp.Path, JobId, LStat, FileId, FileIndex FROM (SELECT PathHierarchy.PPathId AS PathId, '..' AS Path FROM PathHierarchy JOIN PathVisibility USING (PathId) WHERE PathHierarchy.PathId = 92295 AND PathVisibility.JobId IN (17911) UNION SELECT 92295 AS PathId, '.' AS Path) AS tmp LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId, File1.FileIndex AS FileIndex, Job1.JobTDate AS JobTDate FROM File AS File1 JOIN Job AS Job1 USING (JobId)WHERE File1.FilenameId = 3 AND File1.JobId IN (17911)) AS listfile1 ON (tmp.PathId = listfile1.PathId) ORDER BY tmp.Path, JobTDate DESC bacula-dir: ua_dotcmds.c:418-0 type=D bacula-dir: bvfs.c:1128-0 ls_dirs(92295) bacula-dir: bvfs.c:1193-0 q=SELECT 'D', PathId, 0, Path, JobId, LStat, FileId, FileIndex FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path, lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat, listfile1.FileId AS FileId, listfile1.JobTDate AS JobTDate, listfile1.FileIndex AS FileIndex FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 92295 AND PathVisibility1.JobId IN (17911) ) AS listpath1 JOIN Path AS Path1 ON (listpath1.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId, File1.FileIndex, Job1.JobTDate AS JobTDate FROM File AS File1 JOIN Job AS Job1 USING (JobId) WHERE File1.FilenameId = 3 AND File1.JobId IN (17911)) AS listfile1 ON (listpath1.PathId = listfile1.PathId) ) AS A ORDER BY Path,JobTDate DESC LIMIT 2000 OFFSET 0 bacula-dir: ua_dotcmds.c:418-0 type=D bacula-dir: mysql.c:325-0 closedb ref=0 connected=1 db=7f17f4003480 bacula-dir: mysql.c:332-0 close db=7f17f4003480 bacula-dir: job.c:1466-0 Start dird free_jcr bacula-dir: mem_pool.c:372-0 garbage collect memory pool bacula-dir: job.c:1522-0 End dird free_jcr
On Fri, Oct 2, 2020 at 12:23 AM Marcin Haba <ganius...@gmail.com> wrote: > Hello Elias, > > There is something wrong with BVFS on your side. As far as I can see > Webacula doesn't use BVFS but it uses restore command directly, so it > can explain why you see files there. > > You can enable Director debug and check if there is anything wrong. > You can do it for example by the bconsole command: > > setdebug level=400 tags=bvfs,sql trace=1 dir > > In the Director working directory you will have a bacula-dir.trace > file. You can try this command once again: > > .bvfs_lsdirs jobid=17911 path= > > and then please past here the trace content starting from line like > below to the end: > > bacula-dir: ua_dotcmds.c:177-0 Cmd: .bvfs_lsdirs jobid=17911 path= > > Thanks in advance for this checking. > > Best regards, > Marcin Haba (gani) > > On Fri, 2 Oct 2020 at 05:00, Elias Pereira <empbi...@gmail.com> wrote: > > > > Still not showing the files to restore. > > > > On Thu, Oct 1, 2020 at 10:24 PM Jose Alberto <j.se...@gmail.com> wrote: > >> > >> For the moments. It only occurs to me to clear the bvfs cache and > generate it. This should preferably be run when a backup is not running. > >> > >> .bvfs_clear_cache yes > >> > >> .bvfs_update > >> > >> > >> > >> > >> On Thu, Oct 1, 2020 at 5:58 PM Elias Pereira <empbi...@gmail.com> > wrote: > >>> > >>> Enter a period to cancel a command. > >>> *list files jobid=17911 > >>> Automatically selected Catalog: MyCatalog > >>> Using Catalog "MyCatalog" > >>> +----------+ > >>> | Filename | > >>> +----------+ > >>> | /home/backup/datapump/BDETCOM.log | > >>> | /home/backup/datapump/BDETCOM.dmp | > >>> | /home/backup/datapump/ | > >>> | /home/backup/ | > >>> +----------+ > >>> > +--------+-------------------+---------------------+------+-------+----------+------------+-----------+ > >>> | JobId | Name | StartTime | Type | Level | > JobFiles | JobBytes | JobStatus | > >>> > +--------+-------------------+---------------------+------+-------+----------+------------+-----------+ > >>> | 17,911 | Backup_SCA_Oracle | 2020-10-01 12:02:16 | B | D | > 6 | 27,396,081 | T | > >>> > +--------+-------------------+---------------------+------+-------+----------+------------+-----------+ > >>> You have messages. > >>> > >>> As I have already said. Through the webacula I can check the files in > the restore, but through the baculum nothing appears. > >>> > >>> On Thu, Oct 1, 2020 at 5:51 PM Jose Alberto <j.se...@gmail.com> wrote: > >>>> > >>>> Hi. > >>>> > >>>> No show when go to Restore or when "info Job" ???? > >>>> > >>>> prune files? for FileRetention. > >>>> > >>>> list files jobid=17911 > >>>> > >>>> show files? > >>>> > >>>> > >>>> > >>>> On Thu, Oct 1, 2020 at 9:02 AM Elias Pereira <empbi...@gmail.com> > wrote: > >>>>> > >>>>> Hello, > >>>>> > >>>>> I updated my old version to 9.6.5.1, but now the recovery function > doesn't show job files. I verify this via webacula and the files are there. > >>>>> > >>>>> Any idea? > >>>>> _______________________________________________ > >>>>> Bacula-users mailing list > >>>>> Bacula-users@lists.sourceforge.net > >>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users > >>>> > >>>> > >>>> > >>>> -- > >>>> ############################# > >>>> # Sistema Operativo: Debian # > >>>> # Caracas, Venezuela # > >>>> ############################# > >>> > >>> > >>> > >>> -- > >>> Elias Pereira > >> > >> > >> > >> -- > >> ############################# > >> # Sistema Operativo: Debian # > >> # Caracas, Venezuela # > >> ############################# > > > > > > > > -- > > Elias Pereira > > _______________________________________________ > > 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 > -- Elias Pereira
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
