Bareos Bug Tracker
Bareos Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000939bareos-core[All Projects] directorpublic2018-04-19 11:492018-04-27 13:30
ReporterIvanBayan 
Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformLinuxOSUbuntuOS Version16.04
Product Version17.2.4 
Target VersionFixed in Version 
Summary0000939: Bareos director stays malfunction if DB server was un-available for a time
DescriptionIf DB server has gone away, bareos director would stays malfunction even after DB returns back.

As you can see below sqlquery from bconsole works fine, but estimate command doesn't:
*.sql query="SELECT COUNT(Job) FROM JOB;"
Using Catalog "MyCatalog"
+-------+
| count |
+-------+
| 4,360 |
+-------+
*estimate job=ow-mssql01_mssql
Using Catalog "MyCatalog"
You have messages.
*

In log file I've found next error messages:
19-Apr 05:40 mia-backup03-dir JobId 0: Fatal error: sql_create.c:537 sql_create.c:537 query SELECT ClientId,Uname FROM Client WHERE Name='ow-mssql01-fd' failed:
no connection to the server

19-Apr 05:40 mia-backup03-dir JobId 0: Error: sql_create.c:579 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('ow-mssql01-fd','',0,5184000,15552000) failed. ERR=no connection to the server

19-Apr 05:40 mia-backup03-dir JobId 0: Fatal error: Could not create Client record. ERR=sql_create.c:579 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('ow-mssql01-fd','',0,5184000,15552000) failed. ERR=no connection to the server

Moreover, backup became broken too, all jobs executions just stuck:
*run job=mia-backup03_bareos yes
Using Catalog "MyCatalog"

In log file:
19-Apr 05:43 mia-backup03-dir JobId 0: Fatal error: sql_create.c:537 sql_create.c:537 query SELECT ClientId,Uname FROM Client WHERE Name='mia-backup03-fd' failed:
no connection to the server

19-Apr 05:45 mia-backup03-dir JobId 0: Error: sql_create.c:579 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('mia-backup03-fd','',0,5184000,15552000) failed. ERR=no connection to the server
Steps To Reproduce1. Stop DB service
2. Wait for a while
3. Start DB service
Additional InformationI have active monitoring checks via bareos api, may be it can affects on situation.
TagsNo tags attached.
bareos-master: impact
bareos-master: 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
(0002977)
aron_s (developer)
2018-04-27 13:30

Reproduced, can be temporarily fixed by forcing the restart of bareos-dir service.

- Issue History
Date Modified Username Field Change
2018-04-19 11:49 IvanBayan New Issue
2018-04-27 13:30 aron_s Note Added: 0002977


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker