Hello Silver I'd like to discover what is causing this. Please turn on sql debugging in preferences and we should be able to isolate the sql command that is getting the list of files. The result should be an sql query that should look alot like this:
bat: restore/restoretree.cpp:534 Query cmd : SELECT DISTINCT Filename.Name AS FileName, Filename.FilenameId AS FilenameId FROM File INNER JOIN Filename on (Filename.FilenameId=File.FilenameId) WHERE File.PathId=269827 AND File.Jobid IN (3641,3632,3619,3606,3593) AND Filename.Name!='' ORDER BY FileName The first big question is if the sql query is returning the files in question. Once I know that I can recommend the next step in figuring out what is happening. In psql, I get results like: filename | filenameid ---------------+------------ ATTXX_001.pdf | 1067479 CINTA_001.pdf | 1250307 COVER_001.pdf | 1063069 COVER_002.pdf | 1266269 ENGPR_003.pdf | 1411193 ENGPR_004.pdf | 1664069 OUTSO_001.pdf | 1320048 RELST_001.pdf | 1640153 (8 rows) On Thu, 2007-12-06 at 14:47 +0200, Silver Salonen wrote: > Hello > > I have Bat installed from 2.2.5 version on FreeBSD-6.2. The problem is that > Version Browser doesn't show some of the folders. If I browse files > via "Restore" command, they're there though. > > I just checked what does debugging show me and I see that while querying > folders, Bat continues querying subfolders of the next folder when it meets > an estonian word "Töögraafikud" in foldername: > ===== > ... > bat: console/console.cpp:623 got: /mnt/snap/usr/home/rakvere/Palgalipikud/ > > 15631 > bat: console/console.cpp:623 got: /mnt/snap/usr/home/rakvere/Töögraafikud/ > > 12861 > bat: console/console.cpp:623 got: /mnt/snap/usr/home/roccaalmare/Maildir/ > > 8164 > ... > bat: console/console.cpp:623 got: /mnt/snap/usr/home/sikupilli/Raport/ 13415 > bat: console/console.cpp:623 got: /mnt/snap/usr/home/sikupilli/Töögraafikud/ > > 12857 > bat: console/console.cpp:623 got: /mnt/snap/usr/home/silver/ 7840 > ... > ===== > May it be related to it? I also see that there's another folder "Töötajad", > which contains subfolders, and its subfolders are queried OK. > > Also (here comes the second issue ;), if I browse files in Version Browser, > some of the jobs are marked dark-yellow-green and cannot be selected - why is > that? One of these jobs is full backup done a month ago and its volume is not > purged from database yet (although there's a newer full backup of the same > job that was not completed successfully and its volume is purged now). After inspecting the code, I tend to think that your assesment of the volumes showing up yellow as not being purged as possibly being inaccurate. Unless I've done something usually correct like with the above case seems like it may be. Please double check, all jobs which have been purged should show up as uncheckable and darkYellow. Grey is for jobs that are not purged but have been unchecked and then a refresh has been done. Dirk ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
