Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Friday 19 September 2008 02:50:48 Robert Treat wrote: > On Thursday 18 September 2008 18:10:35 Kern Sibbald wrote: > > On Thursday 18 September 2008 23:42:52 Robert Treat wrote: > > > On Thursday 18 September 2008 15:58:18 Dan Langille wrote: > > > > Robert Treat wrote: > > > > >> Kern Sibbald w

Re: [Bacula-devel] Bug? "No Job found for JobId X" after successful backup

2008-09-18 Thread Kern Sibbald
You probably either purged the job manually or set you pruning time so low that it was pruned while it was running. Since there is no full job output, it is impossible to tell. On Friday 19 September 2008 00:37:53 Joshua J. Kugler wrote: > [Post on Bacula User, but didn't get a response. Then i

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Jason A. Kates
On Thu, 2008-09-18 at 21:00 -0400, Robert Treat wrote: > On Thursday 18 September 2008 18:39:49 Bill Moran wrote: > > > > > [EMAIL PROTECTED]:~/src/bacula-trunk/bacula/src/dird] $ grep -i > > > > > "select " * > > > > > autoprune.c: const char *select = "SELECT DISTINCT > > > > > MediaId,LastWri

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Robert Treat
On Thursday 18 September 2008 18:39:49 Bill Moran wrote: > > > > [EMAIL PROTECTED]:~/src/bacula-trunk/bacula/src/dird] $ grep -i "select > > > > " * > > > > autoprune.c: const char *select = "SELECT DISTINCT > > > > MediaId,LastWritten FROM Media WHERE " > > > > backup.c: Mmsg(buf, "SELECT sum

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Robert Treat
On Thursday 18 September 2008 18:10:35 Kern Sibbald wrote: > On Thursday 18 September 2008 23:42:52 Robert Treat wrote: > > On Thursday 18 September 2008 15:58:18 Dan Langille wrote: > > > Robert Treat wrote: > > > >> Kern Sibbald wrote: > > > >>> On Thursday 18 September 2008 17:23:06 Dan Langille

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Bill Moran
Kern Sibbald <[EMAIL PROTECTED]> wrote: > > On Thursday 18 September 2008 23:42:52 Robert Treat wrote: > > On Thursday 18 September 2008 15:58:18 Dan Langille wrote: > > > Robert Treat wrote: > > > >> Kern Sibbald wrote: > > > >>> On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > > > >>>

[Bacula-devel] Bug? "No Job found for JobId X" after successful backup

2008-09-18 Thread Joshua J. Kugler
[Post on Bacula User, but didn't get a response. Then it hit me this might be some kind of bug.] I just got a couple job reports tonight with an error I've never seen before. I googled, but didn't see anything. FYI, empty SQLite database created from the SQLite create scripts. The full e-mai

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Friday 19 September 2008 00:07:21 Kern Sibbald wrote: > On Thursday 18 September 2008 22:46:04 John Huttley wrote: > > Actually I don't know what to think. > > > > its not, however, good press for bacula. > > > > No news may be good news, > > But some news is bad news! > > > > I do think that it

Re: [Bacula-devel] bad sql??

2008-09-18 Thread John Huttley
To cut to the chase on this. It really needs someone to try and do what he seems to have done and see what, if any, issues arise. Since I build from source (gentoo) , I volunteer. I'll pick up on this next week I hope. --John Kern Sibbald wrote: On Thursday 18 September 2008 20:08:27 Dan

[Bacula-devel] provability of correctness

2008-09-18 Thread John Huttley
Since I'm talking I'll add something else. The biggest problem with bacula is that its behaviour is undocumented. The behaviour of any system is given by its state diagram. 1. The initial state 2. The set of possible states 3. The set of transitions from any state Lets leave out straight bug

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 23:42:52 Robert Treat wrote: > On Thursday 18 September 2008 15:58:18 Dan Langille wrote: > > Robert Treat wrote: > > >> Kern Sibbald wrote: > > >>> On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > > Kern Sibbald wrote: > > > On Thursday 18 Septemb

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 22:46:04 John Huttley wrote: > Actually I don't know what to think. > > its not, however, good press for bacula. > > No news may be good news, > But some news is bad news! > > I do think that it needs to be fixed Quite honestly, I don't understand what needs to be fi

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Robert Treat
On Thursday 18 September 2008 16:46:04 John Huttley wrote: > The real issue is the DB's may need a conversion script to change the > names. This is not the sort of thing than can be done in point release. > So much is obvious. > actually the changes to an existing system would be pretty minmal, yo

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Robert Treat
On Thursday 18 September 2008 15:58:18 Dan Langille wrote: > Robert Treat wrote: > >> Kern Sibbald wrote: > >>> On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > Kern Sibbald wrote: > > On Thursday 18 September 2008 15:40:04 Dan Langille wrote: > >> resending, with CC to lis

[Bacula-devel] Alternative DB structures, food for thought, What I think about SQL..

2008-09-18 Thread John Huttley
Hi, Years back I was going to write my own backup software, to be called 'darkserve' Even got the domain name. I did some preliminary work, then gave it up. This programming stuff is hard work! However I did put thought into the catalogue. In those days netware was still viable so multisystem c

Re: [Bacula-devel] bad sql??

2008-09-18 Thread John Huttley
Actually I don't know what to think. its not, however, good press for bacula. No news may be good news, But some news is bad news! I do think that it needs to be fixed Kern says that it could need a 'massive' rewrite, really, though I don't think so. It may be in lots of funny places but should

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Dan Langille
Robert Treat wrote: >> Kern Sibbald wrote: >>> On Thursday 18 September 2008 17:23:06 Dan Langille wrote: Kern Sibbald wrote: > On Thursday 18 September 2008 15:40:04 Dan Langille wrote: >> resending, with CC to list. >> >> John Huttley wrote: >>> https://people.planetpostg

[Bacula-devel] bls and DVD (Windows Version)

2008-09-18 Thread Dr. Marco Schaerfke
I try to use the Windows version of bls.exe for reading DVDs. The DVDs was created with a Linux Bacula installation. My goal is it to share archive DVDs . Unfortunately I was not successful. Windows creates a error report (Dr, Watson). Does the windows version of bls the reading of "Linux" DVDs

[Bacula-devel] FileSet example of how to include a common subdirectory

2008-09-18 Thread Martin Simmons
This issue is frequently discussed on the users list, so I think it should be addressed in the manual. The example below uses Windows pathnames, but the concept is generic so it could goin the FileSet Examples section and not just the Windows FileSets section. Feel free to use the text below. -

Re: [Bacula-devel] small dbcheck patch for mysql

2008-09-18 Thread Kern Sibbald
Hello Yuri, I have now applied your patch and committed it to the SVN. I made a few minor changes to reduce the number of #ifdefs in the body of the code. I would appreciate it if you would test the new code and let me know. Best regards, Kern On Tuesday 09 September 2008 15:30:18 Yuri Timof

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Robert Treat
> Kern Sibbald wrote: > > On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > >> Kern Sibbald wrote: > >>> On Thursday 18 September 2008 15:40:04 Dan Langille wrote: > resending, with CC to list. > > John Huttley wrote: > > https://people.planetpostgresql.org/xzilla/inde

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 20:08:27 Dan Langille wrote: > Kern Sibbald wrote: > > On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > >> Kern Sibbald wrote: > >>> On Thursday 18 September 2008 15:40:04 Dan Langille wrote: > resending, with CC to list. > > John Huttley wro

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Dan Langille
Kern Sibbald wrote: > On Thursday 18 September 2008 17:23:06 Dan Langille wrote: >> Kern Sibbald wrote: >>> On Thursday 18 September 2008 15:40:04 Dan Langille wrote: resending, with CC to list. John Huttley wrote: > https://people.planetpostgresql.org/xzilla/index.php?/archives/

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 17:23:06 Dan Langille wrote: > Kern Sibbald wrote: > > On Thursday 18 September 2008 15:40:04 Dan Langille wrote: > >> resending, with CC to list. > >> > >> John Huttley wrote: > >>> https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacu > >>>la ,-Sqli

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Dan Langille
Kern Sibbald wrote: > On Thursday 18 September 2008 15:40:04 Dan Langille wrote: >> resending, with CC to list. >> >> John Huttley wrote: >>> https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula >>> ,-Sqlite,-Postgres...-when-good-tools-go-horribly-horribly-wrong.html >> John:

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 15:40:04 Dan Langille wrote: > resending, with CC to list. > > John Huttley wrote: > > https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula > >,-Sqlite,-Postgres...-when-good-tools-go-horribly-horribly-wrong.html > > John: whenever people post a UR

Re: [Bacula-devel] trunk: src/filed/accurate.c Dmsg

2008-09-18 Thread Kern Sibbald
On Thursday 18 September 2008 15:21:44 João Henrique Freitas wrote: > Hello, > > make[1]: Leaving directory > `/home_local/usuario/workspace_dsng/Bacula/src/findlib' > ==>Entering directory /home_local/usuario/workspace_dsng/Bacula/src/filed > make[1]: Entering directory > `/home_local/usuario/work

Re: [Bacula-devel] bad sql??

2008-09-18 Thread Dan Langille
resending, with CC to list. John Huttley wrote: > https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula,-Sqlite,-Postgres...-when-good-tools-go-horribly-horribly-wrong.html John: whenever people post a URL without commenting up on it, I always ask them for their comments upon

[Bacula-devel] trunk: src/filed/accurate.c Dmsg

2008-09-18 Thread João Henrique Freitas
Hello, make[1]: Leaving directory `/home_local/usuario/workspace_dsng/Bacula/src/findlib' ==>Entering directory /home_local/usuario/workspace_dsng/Bacula/src/filed make[1]: Entering directory `/home_local/usuario/workspace_dsng/Bacula/src/filed' Compiling accurate.c accurate.c: In function 'bool a

[Bacula-devel] bad sql??

2008-09-18 Thread John Huttley
https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula,-Sqlite,-Postgres...-when-good-tools-go-horribly-horribly-wrong.html - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge B