Hello,
after bresto client, job and file selection
and clicking on "Run restore" i tried to find
Media needed by clicking "Compute with directories".
Result: nothing and browser timeout.
After browser timeout i looked into mysql (see below).
There is a subselect (SELECT FileId FROM b213335), but
temporary table b213335 has no column FileId.
Looks like a bresto bug.
Regards
Ulrich
mysql> show full processlist;
+-------+--------+-----------+--------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State |
Info
|
+-------+--------+-----------+--------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 29820 | bacula | localhost | bacula | Query | 25 | preparing |
SELECT DISTINCT VolumeName, Enabled, InChanger
FROM File,
( -- Get all media from this job
SELECT MIN(FirstIndex) AS FirstIndex, MAX(LastIndex) AS LastIndex,
VolumeName, Enabled, Inchanger
FROM JobMedia JOIN Media USING (MediaId)
WHERE JobId IN (SELECT DISTINCT JobId FROM b213335)
GROUP BY VolumeName,Enabled,InChanger
) AS allmedia
WHERE File.FileId IN (SELECT FileId FROM b213335)
AND File.FileIndex >= allmedia.FirstIndex
AND File.FileIndex <= allmedia.LastIndex |
| 29821 | root | localhost | bacula | Query | 0 | NULL |
show full processlist
|
+-------+--------+-----------+--------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> describe b213335;
+------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| JobId | int(10) unsigned | NO | | | |
| FileIndex | int(10) unsigned | YES | | 0 | |
| FilenameId | int(10) unsigned | NO | | | |
| PathId | int(10) unsigned | NO | | | |
| FileId | bigint(20) unsigned | NO | MUL | 0 | |
+------------+---------------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql>
--
Ulrich Leodolter <[email protected]>
OBVSG
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
