View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000609bareos-coredirectorpublic2016-01-25 15:322017-06-08 15:38
Reporterfrank Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version15.2.2 
Summary0000609: Status dir output differs with info queried from catalog db
DescriptionExecuting the command "status dir" shows following.

170355 Differe kristian.2016-01-25_09.30.00_08 is waiting for its start time at 25-Jan-16 15:18
170359 Increme ting.2016-01-25_09.30.00_12 is waiting for its start time at 25-Jan-16 15:48
170360 Differe marvin.2016-01-25_09.30.00_13 is waiting for its start time at 25-Jan-16 15:18

Executing "list jobs jobsstatus=t" shows nothing.

*list jobs jobstatus=t
No results to list.

If you query the catalog via sql those jobs which should have the status "t" are also not shown.

bareos=# select * from job where jobstatus='t';
 jobid | job | name | type | level | clientid | jobstatus | schedtime | starttime | endtime | realendtime | jobtdate | volsessionid | volsessiontime | jobfiles | jobbytes | readbytes | joberrors | jobmissingfiles | poolid | filesetid | priorjobid | purgedfiles | hasbase | hascache | reviewed | comment
-------+-----+------+------+-------+----------+-----------+-----------+-----------+---------+-------------+----------+--------------+----------------+----------+----------+-----------+-----------+-----------------+--------+-----------+------------+-------------+---------+----------+----------+---------
(0 Zeilen)


But if you look for the jobids of the waiting jobs shown by "status dir" above, you get a result but with a not expected state.

bareos=# select * from job where jobid='170335';
 jobid | job | name | type | level | clientid | jobstatus | schedtime | starttime | endtime | realendtime | jobtdate | volsessionid | volsessiontime | jobfiles | jobbytes | readbytes | joberrors | jobmissingfiles | poolid | filesetid | priorjobid | purgedfiles | hasbase | hascache | reviewed | comment
--------+---------------------------------------+----------------+------+-------+----------+-----------+---------------------+---------------------+---------------------+---------------------+------------+--------------+----------------+----------+------------+------------+-----------+-----------------+--------+-----------+------------+-------------+---------+----------+----------+---------
 170335 | database1-base.2016-01-25_00.07.01_46 | database1-base | B | I | 17 | T | 2016-01-25 00:07:01 | 2016-01-25 00:31:39 | 2016-01-25 00:33:47 | 2016-01-25 00:33:47 | 1453678427 | 88 | 1453474581 | 27 | 1883997101 | 1883997101 | 0 | 0 | 12 | 18 | 0 | 0 | 0 | 0 | 0 |
(1 Zeile)

bareos=# select * from job where jobid='170359';
 jobid | job | name | type | level | clientid | jobstatus | schedtime | starttime | endtime | realendtime | jobtdate | volsessionid | volsessiontime | jobfiles | jobbytes | readbytes | joberrors | jobmissingfiles | poolid | filesetid | priorjobid | purgedfiles | hasbase | hascache | reviewed | comment
--------+-----------------------------+------+------+-------+----------+-----------+---------------------+---------------------+---------------------+---------------------+------------+--------------+----------------+----------+----------+-----------+-----------+-----------------+--------+-----------+------------+-------------+---------+----------+----------+---------
 170359 | ting.2016-01-25_09.30.00_12 | ting | B | I | 5 | E | 2016-01-25 09:30:00 | 2016-01-25 14:45:31 | 2016-01-25 14:48:36 | 2016-01-25 14:48:36 | 1453729716 | 134 | 1453474581 | 0 | 0 | 0 | 2 | 0 | 12 | 247 | 0 | 0 | 0 | 0 | 0 |
(1 Zeile)

bareos=# select * from job where jobid='170360';
 jobid | job | name | type | level | clientid | jobstatus | schedtime | starttime | endtime | realendtime | jobtdate | volsessionid | volsessiontime | jobfiles | jobbytes | readbytes | joberrors | jobmissingfiles | poolid | filesetid | priorjobid | purgedfiles | hasbase | hascache | reviewed | comment
--------+-------------------------------+--------+------+-------+----------+-----------+---------------------+---------------------+---------------------+---------------------+------------+--------------+----------------+----------+----------+-----------+-----------+-----------------+--------+-----------+------------+-------------+---------+----------+----------+---------
 170360 | marvin.2016-01-25_09.30.00_13 | marvin | B | D | 88 | E | 2016-01-25 09:30:00 | 2016-01-25 14:15:22 | 2016-01-25 14:18:27 | 2016-01-25 14:18:27 | 1453727907 | 132 | 1453474581 | 0 | 0 | 0 | 2 | 0 | 13 | 255 | 0 | 0 | 0 | 0 | 0 |
(1 Zeile)

bareos=#

Looks like rescheduled jobs are not handled correctly.
TagsNo tags attached.

Relationships

child of 0000625 closedmaik Release bareos-15.2.3 

Activities

mvwieringen

mvwieringen

2016-02-05 17:27

developer   ~0002187

Fix committed to bareos master branch with changesetid 6110.

Related Changesets

bareos: master 7e7f95cc

2015-12-10 21:03

mvwieringen

Ported: N/A

Details Diff		 Update database job status on reschedule.

Reflect in the database that we are about to reschedule the Job to run
again under the same JobId.

Fixes 0000609: Status dir output differs with info queried from catalog db		 Affected Issues
0000609
mod - src/dird/jobq.c Diff File

Issue History

Date Modified Username Field Change
2016-01-25 15:32 frank New Issue
2016-02-05 17:27 mvwieringen Changeset attached => bareos master 7e7f95cc
2016-02-05 17:27 mvwieringen Note Added: 0002187
2016-02-05 17:27 mvwieringen Status new => resolved
2016-02-05 17:27 mvwieringen Resolution open => fixed
2016-03-11 14:30 maik Relationship added child of 0000625
2017-06-08 15:38 joergs Status resolved => closed