On Mon, 12 May 2008, Arno Lehmann wrote:

> > Again, one of them is consistently failing with similar database errors.
>
> That looks... interesting.

To say the least.

> Well, I guess you checked the obvious. The only thing you don't
> mention is if the job entries exist in the catalog. In your example,
> JobId 56964. Have you verified this?


> query
Available queries:

    12: List Files for a selected JobId

Choose a query (1-28): 12
Enter JobId: 56964
No results to list.

query
Available queries:

    26: List all backups for a particular Job

Choose a query (1-28): 26
Enter JobName: mssllw-Home
+--------+-------------+---+---+---------------------+---------------------+
| JobId  | Name        | L | S | StartTime           | Gb
|
+--------+-------------+---+---+---------------------+---------------------+
[snippage]
| 51,887 | mssllw-Home | I | T | 2008-03-06 22:37:39 | 0.082590121776
|
| 51,889 | mssllw-Home | D | T | 2008-03-06 23:18:10 | 1.556862215512
|
| 51,972 | mssllw-Home | F | T | 2008-03-07 17:44:01 | 33.818542443216
|
| 52,860 | mssllw-Home | F | T | 2008-03-19 10:47:34 | 33.383734967560
|
| 52,863 | mssllw-Home | F | T | 2008-03-19 17:02:12 | 33.383744673803
|
| 55,129 | mssllw-Home | F | T | 2008-04-16 19:06:57 | 34.195946797729
|
+--------+-------------+---+---+---------------------+---------------------+


It doesn't exist

> If it does exist, and MySQL reports no error details on the update, I
> would try to run the update command from the mysql console program.

I'm at the point of destroying and recreating the database, but that's
probably overkill.

> Perhaps that shows some more details. (By the way - could it be that
> the table grew above the default limit of I believe 2GB?)

It's innoDB and I reset that limit (for MyISAM) a couple of years ago

> If the job record does not exist it's time to find why it can't be
> created. Perhaps searching through the (Bacula) console log reveals
> some eralier, non-critical error, or the MySQL logs show something.
>
> In any case, this looks like a MySQL related problem, and trying to
> create the records by hand might give you more error details.

OK

AB

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users