Hi,
04.12.2008 17:11, Bob Hetzel wrote:
> 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.
I was just about to point this out ;-)
> 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.
Well, I believe the different supported catalog backends might behave
differently, and I also don't know if it's common to cancel running
database operations when the program initiating them terminates.
That said, it might be possible to unconditionally cancel all active
queries when dbcheck terminates, but it might also be possible that
database-dependent code would be needed for this purpose.
I'm sure that a patch would be seriously considered, but as you point
out, this is probably not very pressing for the regular developers
right now...
Arno
> 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
>
--
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
