Nevermind all... The answer was
to run "mysql" then kill the offending process which was apparently
leftover from the dbcheck command. In my case the output showed it was
process 517, so I did...
mysql> kill 517 ;
That allowed bacula to continue normally.
But methinks that's a bug for dbcheck not to abort stuff properly when
you ctrl-c it. Clearly not something I would deem a high priority bug
though.
Bob
Previously, I wrote:
>
> Hi all,
>
> I'm using bacula 2.4.3 and I'm thinking I might have created a problem
> by terminating dbcheck with ctrl-c. I had read about it taking a long
> time to complete if you haven't run it in a while and don't have the
> right temporary indexes created. Anyway... I didn't restart the
> database server after terminating it, but then I started the bacula
> daemons and now the running jobs have all been stuck with status "Dir
> inserting Attributes" for 14 hrs or so. These jobs normally only take a
> few minutes.
>
> I started googling and came up with this command to see what bacula is
> doing.
>
> # mysqladmin -u root processlist
> +-----+--------+-----------+--------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
>
>
> | Id | User | Host | db | Command | Time | State |
> Info |
> +-----+--------+-----------+--------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
>
>
> | 517 | bacula | localhost | bacula | Query | 68125 | Copying to tmp
> table | SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER
> JOIN File ON (Path.PathId=File.PathId) |
> | 519 | bacula | localhost | bacula | Sleep | 270 | |
> |
> | 520 | bacula | localhost | bacula | Query | 50855 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 521 | bacula | localhost | bacula | Query | 50803 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 522 | bacula | localhost | bacula | Query | 50802 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 523 | bacula | localhost | bacula | Query | 50799 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 524 | bacula | localhost | bacula | Query | 50797 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 525 | bacula | localhost | bacula | Query | 50782 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 526 | bacula | localhost | bacula | Query | 50735 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 527 | bacula | localhost | bacula | Query | 50689 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 528 | bacula | localhost | bacula | Query | 50641 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 529 | bacula | localhost | bacula | Query | 50518 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 530 | bacula | localhost | bacula | Query | 50242 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 531 | bacula | localhost | bacula | Query | 50060 | Locked |
> LOCK TABLES Path write, batch write, Path as p write
> |
> | 536 | root | localhost | | Query | 0 | | show
> processlist |
> +-----+--------+-----------+--------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
>
>
>
> ====
> Can anybody tell me what my next step should be to let those backups
> finish normally?
>
> Bob
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
