Can you post the full output of this command in mysql:
show FULL processlist;
FULL gives the whole query.
Also if you are subject to locking problems try moving the table types to InnoDB
and try using the dbi:mysql setting in the database definition within bacula,
the dbi driver helped fix a bconsole lock up issue that I've had for along time
now due to a full backup after using a base job which uses temporary
tablespace (that get written to disk due to how they query constructed within
the director), this too will allow concurrent access in other area's of bacula
(specifically many area's of bconsole)
I suspect you are using the default DB setup within the director, here is the
config line you would need (as an example) within the defined Catalog:
dbdriver = "dbi:mysql"; dbaddress = 127.0.0.1; dbport = 3306
+----------------------------------------------------------------------
|This was sent by ccspro AT hotmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|