Bareos Bug Tracker
Bareos Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000975bareos-core[All Projects] apipublic2018-06-28 15:442018-07-12 09:45
Reporterfrank 
Assigned Tostephand 
PrioritynormalSeveritymajorReproducibilityalways
StatusassignedResolutionopen 
PlatformLinuxOSCentOSOS Version7
Product Version17.2.6 
Target VersionFixed in Version 
Summary0000975: .bvfs_lsdirs limit offset command parameters do not work properly
Description.bvfs_lsdirs limit offset command parameters do not work properly.

Steps To Reproduce*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
809 0 0 A A A A A A A A A A A A A A ..
112 1426 2 P0A DBG22 EHt H A A A CG BAA A Ba+/we BbB9X7 BbB9X7 A A C NetworkManager/
96 1478 2 P0A BADLX EHt F A A A 5 BAA A BazZZL BbB85h BbB85h A A C X11/
231 1192 2 P0A BAA8i EHt C A A A Ds BAA A BbB9YK BbB9X7 BbB9X7 A A C alternatives/
239 3476 2 P0A DBcGD EHo D A A A r BAA A BazZQQ BbB853 BbB853 A A C audisp/
66 3482 2 P0A BBLZn EHo D A A A BT BAA A BazZQQ BbB8/P BbB8/P A A C audit/
41 11499 138 P0A ClO8 EHt H A Pj A Cr BAA A BbNLO1 BbNLO1 BbNLO1 A A C bareos/
251 1481 2 P0A J82 EHt C A A A s BAA A BazYwT BbB9a/ BbB9a/ A A C bash_completion.d/
19 1290 2 P0A DA17e EHt C A A A G BAA A BbB8/O BazbsQ BbB85h A A C binfmt.d/
46 1193 2 P0A CAKIj EHt C A A A G BAA A BZhHqO BZhHqO BbB84m A A C chkconfig.d/
188 1737 2 P0A DBG5Y EHt C A A A V BAA A BbB8/P BbB85o BbB85o A A C cron.d/
111 1724 2 P0A BAear EHt C A A A q BAA A BbB+MV BbB85y BbB85y A A C cron.daily/
148 1671 2 P0A BA704 EHt C A A A W BAA A BbB9DN BTljHH BbB85o A A C cron.hourly/
88 1750 2 P0A CBPGb EHt C A A A G BAA A BbB+x1 BTljHH BbB85o A A C cron.monthly/
200 1673 2 P0A DBG5f EHt C A A A G BAA A BbB+fF BTljHH BbB85o A A C cron.weekly/
223 1378 2 P0A DA17c EHt E A A A BO BAA A Bazbfp BbB85j BbB85j A A C dbus-1/
7 1279 2 P0A ILy EHt C A A A s BAA A BazG5z BbB891 BbB891 A A C default/
70 1264 2 P0A DA17I EHt C A A A X BAA A BbB86T BbB85f BbB85f A A C depmod.d/
202 3447 2 P0A BFVS EHo E A A A 1 BAA A Ba+vUZ Ba+vUZ BbB9X9 A A C dhcp/
10 1268 2 P0A 6be EHt C A A A G BAA A BbB86p BazbmK BbB85f A A C dracut.conf.d/
61 1945 2 P0A CBStG EHo H A A A CF BAA A BazZR8 BbB85y BbB85y A A C firewalld/
47 1677 2 P0A CAfA9 EHt C A A A G BAA A BZgfW+ BZgfW+ BbB842 A A C gcrypt/
106 3452 2 P0A DBSa8 EHt C A A A G BAA A BYHgOf BYHgOf BbB85v A A C gnupg/
170 1709 2 P0A BASuH EHt E A A A o BAA A BTlhZM BbB849 BbB849 A A C groff/
250 1173 2 P0A CAKAT EHA C A A A C2 BAA A BbB892 BbB86S BbB86S A A C grub.d/
174 1684 2 P0A SAS EHt D A A A U BAA A Ba8vw+ Ba8vw+ BbB9YG A A C gss/
43 1721 2 P0A DAObA EHt C A A A Cf BAA A BazcKB BbB85E BbB85E A A C iproute2/
128 3500 2 P0A DBi+O EHt D A A A Y BAA A BbB86C BbB86C BbB86C A A C kernel/
254 1675 2 P0A CAfAw EHt C A A A G BAA A Ba8vw+ Ba8vw+ BbB9YG A A C krb5.conf.d/
195 10811 111 P0A CAeXE EHt C A A A Ck BAA A BbKjdw BbJ9aM BbJ9aM A A C ld.so.conf.d/
172 1226 2 P0A CAfA+ EHt C A A A j BAA A BZg34Z BbB843 BbB843 A A C libnl/
232 11444 138 P0A DAnhS EHt C A A A Bk BAA A BbM3Hi BbNLOz BbNLOz A A C logrotate.d/
131 1404 2 P0A DBSjo EHt G A A A Bk BAA A BbB87A BbB85z BbB85z A A C lvm/
57 10807 111 P0A 6cc EHt C A A A BR BAA A BbMLpP BbJ9aM BbJ9aM A A C modprobe.d/
115 1292 2 P0A 6eK EHt C A A A G BAA A BbB87B BazbsQ BbB85h A A C modules-load.d/
539 1753 2 P0A BAo2a EHt C A A A f BAA A BZhL1I BbB85Z BbB85Z A A C my.cnf.d/
42 1747 2 P0A CBM68 EHt D A A A k BAA A Ba/ABV BbB9X8 BbB9X8 A A C openldap/
5 1482 2 P0A BADLY EHt C A A A G BAA A BazZZL BazZZL BbB84r A A C opt/
98 1261 2 P0A SC/ EHt C A A A BAA BAA I BazX9d BbB9zP BbB9zP A A C pam.d/
163 1635 2 P0A BALKP EHt D A A A V BAA A BZhQUN BbB84y BbB84y A A C pkcs11/
198 1542 2 P0A CAKIu EHt K A A A B0 BAA A BazZZL BbB85y BbB85y A A C pki/
74 3451 2 P0A BImx EHt C A A A c BAA A Ba0Khn BbB85u BbB85u A A C plymouth/
94 1546 2 P0A DACnD EHt F A A A 0 BAA A BazZZL BbB84r BbB84r A A C pm/
177 1461 2 P0A CBNcL EHt F A A A BI BAA A BazVZ5 BbB85k BbB85k A A C polkit-1/
63 1631 2 P0A R+F EHt C A A A G BAA A BbB85Y BTloOK BbB84w A A C popt.d/
479 3492 2 P0A DBcGU EHt C A A A Ca BAA A BbB8/S BbB854 BbB855 A A C postfix/
636 1470 2 P0A BA7yu EHt D A A A B7 BAA A BazZih BbB85k BbB85k A A C ppp/
92 1275 2 P0A BAA9U EHt C A A A BO BAA A Ba+3OX BbB9X6 BbB9X6 A A C prelink.conf.d/
136 1444 2 P0A DACm/ EHt C A A A EY BAA A BbB9wW BbB9a/ BbB9a/ A A C profile.d/
516 1711 2 P0A CAg/e EHt C A A A j BAA A BazbsB BbB84/ BbB84/ A A C python/
441 3495 2 P0A DBi9r EHt D A A A y BAA A BZhCM/ BbB86B BbB86B A A C qemu-ga/
152 1223 2 P0A DAASf EHt K A A A B/ BAA A BZhHqO BbB85h BbB85h A A C rc.d/
226 1640 2 P0A R/l EHt C A A A s BAA A BbB9p2 BbB9a3 BbB9a3 A A C rpm/
109 1288 2 P0A BAo6t EHt C A A A Z BAA A BbB9YN Ba/BWx BbB9YH A A C rsyslog.d/
235 1726 2 P0A CAyML EHt C A A A X BAA A BazZih BazZih BbB85k A A C rwtab.d/
113 1648 2 P0A BALKY EHt C A A A Y BAA A BazY0n BbB854 BbB854 A A C sasl2/
25 1703 2 P0A BALT6 EHt G A A A BAA BAA I BazX9d BbB847 BbB847 A A C security/
21 3442 2 P0A CBM79 EHt F A A A BR BAA A Ba8xHa Ba8xHa BbB9X9 A A C selinux/
134 1178 2 P0A CAKIC EHt C A A A + BAA A BbB896 BazZZL BbB84r A A C skel/
99 1763 2 P0A BFVI EHt C A A A Dh BAA A BazY1J BbB8/P BbB8/P A A C ssh/
173 1637 2 P0A CAfAH EHt C A A A T BAA A Ba+7UQ BbB9YH BbB9YH A A C ssl/
215 1632 2 P0A DBG27 EHt C A A A G BAA A BazZih BazZih BbB85k A A C statetab.d/
6 3506 2 P0A Be+V EHo C A A A G BAA A BazY9P BazY9P BbB86D A A C sudoers.d/
13 10809 111 P0A DACnE EHt G A A A BAA BAA I BbKjdw BbJ9aS BbJ9aS A A C sysconfig/
53 1381 2 P0A BAo62 EHt C A A A c BAA A BbB87B BbB85k BbB85k A A C sysctl.d/
176 1351 2 P0A CBM/Z EHt E A A A CX BAA A BazbsQ BbB85h BbB85h A A C systemd/
190 1174 2 P0A Bx EHt C A A A G BAA A BZsHHM BZsHHM BbB84j A A C terminfo/
220 1383 2 P0A BAo63 EHt C A A A G BAA A BbB85j BazbsQ BbB85h A A C tmpfiles.d/
635 3459 2 P0A BIrs EHt D A A A Bt BAA A BbB8/S BbB85x BbB85x A A C tuned/
213 1388 2 P0A CBNAA EHt D A A A 2 BAA A BazbsR BbB8/O BbB8/O A A C udev/
143 3449 2 P0A BA927 EHt C A A A h BAA A BazZwI BbB85r BbB85r A A C wpa_supplicant/
182 1617 2 P0A J84 EHt E A A A m BAA A BazZZL BbB85h BbB85h A A C xdg/
119 1618 2 P0A CAKIw EHt C A A A G BAA A BazZZL BazZZL BbB84r A A C xinetd.d/
130 10814 111 P0A BALKk EHt C A A A D4 BAA A BbKQb2 BbKQbX BbKQbX A A C yum.repos.d/
32 1663 2 P0A CAfAM EHt G A A A Bk BAA A BbB8+0 BbB85w BbB85w A A C yum/
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=12 offset=0
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
809 0 0 A A A A A A A A A A A A A A ..
112 1426 2 P0A DBG22 EHt H A A A CG BAA A Ba+/we BbB9X7 BbB9X7 A A C NetworkManager/
96 1478 2 P0A BADLX EHt F A A A 5 BAA A BazZZL BbB85h BbB85h A A C X11/
231 1192 2 P0A BAA8i EHt C A A A Ds BAA A BbB9YK BbB9X7 BbB9X7 A A C alternatives/
239 3476 2 P0A DBcGD EHo D A A A r BAA A BazZQQ BbB853 BbB853 A A C audisp/
66 3482 2 P0A BBLZn EHo D A A A BT BAA A BazZQQ BbB8/P BbB8/P A A C audit/
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=3 offset=0
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=5
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
*

Additional Informationbareos-dir (10): bvfs.c:642-0 ls_dirs(123)
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_ls_special_dirs_3 (73)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId)
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_ls_sub_dirs_5 (74)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', PathId, Path, JobId, LStat, FileId 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 FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_lsdirs_4 (63)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId 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 FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
bareos-dir (15): bvfs.c:371-0 q=SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId 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 FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
bareos-dir (100): sql_query.c:140-0 called: bool B_DB::sql_query(const char*, int (*)(void*, int, char**), void*) with query SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId 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 FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
TagsNo tags attached.
bareos-master: impact
bareos-master: action
bareos-18.2: impact
bareos-18.2: action
bareos-17.2: impact
bareos-17.2: action
bareos-16.2: impact
bareos-16.2: action
bareos-15.2: impact
bareos-15.2: action
bareos-14.2: impact
bareos-14.2: action
bareos-13.2: impact
bareos-13.2: action
bareos-12.4: impact
bareos-12.4: action
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2018-06-28 15:44 frank New Issue
2018-06-28 15:53 frank Status new => confirmed
2018-07-12 09:45 stephand Assigned To => stephand
2018-07-12 09:45 stephand Status confirmed => assigned


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker