Re: [Bacula-devel] bweb bresto mysql problem

2009-05-22 Thread Ulrich Leodolter
Hello, I have updated bweb + bresto to latest svn. But there ist still a mysql performance problem/bug :-( The following sub query from function get_media_list_with_dir() runs very long: mysql> SELECT MIN(FirstIndex) AS FirstIndex, MAX(LastIndex) AS LastIndex, VolumeName, Enabled, Inchanger FRO

Re: [Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Eric Bollengier
Le Monday 18 May 2009 12:55:00 Ulrich Leodolter, vous avez écrit : > Hello, > > On Mon, 2009-05-18 at 12:13 +0200, Eric Bollengier wrote: > > Le Monday 18 May 2009 11:52:26 Ulrich Leodolter, vous avez écrit : > > > On Mon, 2009-05-18 at 11:24 +0200, Eric Bollengier wrote: > > > > Hello, > > > > > >

Re: [Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Ulrich Leodolter
Hello, On Mon, 2009-05-18 at 12:13 +0200, Eric Bollengier wrote: > Le Monday 18 May 2009 11:52:26 Ulrich Leodolter, vous avez écrit : > > On Mon, 2009-05-18 at 11:24 +0200, Eric Bollengier wrote: > > > Hello, > > > > > > Le Monday 18 May 2009 10:35:35 Ulrich Leodolter, vous avez écrit : > > > > He

Re: [Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Eric Bollengier
Le Monday 18 May 2009 11:52:26 Ulrich Leodolter, vous avez écrit : > On Mon, 2009-05-18 at 11:24 +0200, Eric Bollengier wrote: > > Hello, > > > > Le Monday 18 May 2009 10:35:35 Ulrich Leodolter, vous avez écrit : > > > Hello, > > > > > > after bresto client, job and file selection > > > and clickin

Re: [Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Ulrich Leodolter
On Mon, 2009-05-18 at 11:24 +0200, Eric Bollengier wrote: > 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 dire

Re: [Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Eric Bollengier
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 timeo

[Bacula-devel] bweb bresto mysql problem

2009-05-18 Thread Ulrich Leodolter
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), bu