Hello, Le Monday 18 May 2009 10:35:35 Ulrich Leodolter, vous avez écrit : > 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.
I should have fixed this bug yesterday, so please update your version and try again. I have also added an index to speed up the (SELECT FileId) join for mysql. Bye > 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> ------------------------------------------------------------------------------ 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
