Hello Elias, Thanks for this debug output.
Could you execute in bconsole a 'sql' command and after that the following SQL query? 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; Also it might be useful output from: SELECT * FROM Path WHERE Path=''; SELECT * FROM Path WHERE PathId=92295; Best regards, Marcin Haba (gani) On Fri, 2 Oct 2020 at 05:46, Elias Pereira <empbi...@gmail.com> wrote: > > 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 -- "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
