View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000612bareos-corewebuipublic2016-02-02 15:362017-04-03 16:11
Reporterolga Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionwon't fix 
PlatformLinuxOSDebianOS Version7
Product Version15.2.2 
Summary0000612: restore in webui is unsuccessful- table not found in db
DescriptionWhen I try to restore files from webui and choose "Merge all related jobs to last full backup of selected backup job?" NO, select files from file tree to restore and press "restore" button I get error that table not found in db. The restore itself works normally via bconsole.

Query failed: SELECT JobId,FileIndex FROM b200062406 ORDER BY JobId, FileIndex ASC. ERR=Query failed: SELECT JobId,FileIndex FROM b200062406 ORDER BY JobId, FileIndex ASC: ERR=Table 'bareos.b200062406' doesn't exist

No table found: b200062406
No files selected to be restored.
   
Additional InformationWhen "Merge all related jobs to last full backup of selected backup job?"selection is YES, then I cannot see any files to restore at all.

.bvfs_update, .bvfs_clear_cache yes and bareos-dbcheck -f -c /etc/bareos/bareos-dir.conf did not help
TagsNo tags attached.

Activities

frank

frank

2016-06-10 17:16

developer   ~0002291

Is this still a problem?
olga

olga

2016-06-13 09:41

reporter   ~0002299

Yes, just tried.
 Query failed: SELECT JobId,FileIndex FROM b2000601952 ORDER BY JobId, FileIndex ASC. ERR=Query failed: SELECT JobId,FileIndex FROM b2000601952 ORDER BY JobId, FileIndex ASC: ERR=Table 'bareos.b2000601952' doesn't exist

No table found: b2000601952
No files selected to be restored.
 
BTW, upgraded bareos to 15.2.3 version and still no luck.
frank

frank

2016-11-03 13:23

developer   ~0002433

Please verify, if the permissions on your catalog database are setup correctly, so you are able to create temporary tables.

Also check your command acl in the used console profile if it is lacking needed bvfs_commands. If your command acl includes e.g. .bvfs_.* you should be fine, as all commands from bvfs api are allowed.
frank

frank

2017-04-03 16:11

developer   ~0002621

Due to no feedback for a pretty long time and no other reports like this, I'm going to close the report.

Please feel free to re-open, if a similar or same problem like this exists.

Issue History

Date Modified Username Field Change
2016-02-02 15:36 olga New Issue
2016-02-25 17:35 maik Assigned To => frank
2016-02-25 17:35 maik Status new => assigned
2016-06-10 17:16 frank Note Added: 0002291
2016-06-10 17:16 frank Status assigned => feedback
2016-06-13 09:41 olga Note Added: 0002299
2016-06-13 09:41 olga Status feedback => assigned
2016-11-03 13:23 frank Note Added: 0002433
2016-11-03 13:27 frank Status assigned => feedback
2017-04-03 16:11 frank Note Added: 0002621
2017-04-03 16:11 frank Status feedback => closed
2017-04-03 16:11 frank Assigned To frank =>
2017-04-03 16:11 frank Resolution open => won't fix