Isn't there some way I can debug this? I have spent my entire Saturday
trying to fix this unsuccessfully. My backup jobs work, but copy jobs
fail. I really haven't changed anything in the Bacula or Mysql
configurations before today in quite a while (that I know of). Today I
played games trying to give Mysql more resources in my.cnf, but I don't
think that's really where the problem is. It looks like an
authorization/grants issue but I'm damned if I can figure out what grant
is needed or why this has suddenly started happening when it has been
working fine for months.  I'll put in the time, I'll read the docs, if
somebody can just point me to somewhere that will help me make some
progress. I have to give up for today because I am totally frustrated. I
will post relevant config files if that will help.

Today I tried updating Bacula and Mysql on the director server (now at
5.2.13-17 and  5.5.34-1 respectively) but it didn't make any difference.
I am running 64-bit Fedora 18 if that matters (and yes, I know it will
be end-of-life soon but as of now it's still supported).

--Greg

On Thu, 2013-11-21 at 11:13 -0700, Greg Woods wrote:

On the surface this is obvious, but I don't see why this should suddenly
be happening. I haven't modified the configurations for either
bacula-dir or mysql in some time, yet suddenly now the director can't
access the database. Even weirder, this is only happening for Copy jobs,
normal backups work fine. Manually accessing the database from the
bacula account command line also works fine.

Anybody ever seen anything like this or have any tips for debugging
this?

Thanks,
--Greg

Nov 21 11:05:33 confusion bacula-dir[14226]: 21-Nov 11:05  Message
delivery ERROR: Msg delivery error: Unable to store data in database.
Nov 21 11:05:33 confusion bacula-dir[14226]: 21-Nov 11:05  Message
delivery ERROR: Msg delivery error: Unable to store data in database.
Nov 21 11:05:33 confusion bacula-dir: 21-Nov 11:05  Message delivery
ERROR: Msg delivery error: Unable to store data in database.
Nov 21 11:05:33 confusion bacula-dir: 21-Nov 11:05  Message delivery
ERROR: Msg delivery error: Unable to store data in database.
Nov 21 11:05:33 confusion bacula-dir[14226]: 21-Nov 11:05 bdir: ABORTING
due to ERROR in mem_pool.c:167
Nov 21 11:05:33 confusion bacula-dir[14226]: obuf is NULL
Nov 21 11:05:33 confusion bacula-dir[14226]: bacula-dir: message.c:1270:
void e_msg(const char*, int, int, int, const char*, ...): Assertion `p!
=__null' failed.
Nov 21 11:05:33 confusion bacula-dir[14226]: Bacula interrupted by
signal 6: IOT trap
Nov 21 11:05:33 confusion bacula-dir[14226]: Kaboom! bacula-dir, bdir
got signal 6 - IOT trap. Attempting traceback.
Nov 21 11:05:33 confusion bacula-dir[14226]: Kaboom! exepath=/usr/sbin/
Nov 21 11:05:33 confusion bacula-dir: bdir: ABORTING due to ERROR in
mem_pool.c:167
Nov 21 11:05:33 confusion bacula-dir: Bacula interrupted by signal 6:
IOT trap
Nov 21 11:05:33 confusion bacula-dir[14226]:
Calling: /usr/sbin/btraceback /usr/sbin/bacula-dir
14226 /var/spool/bacula
Nov 21 11:05:33 confusion bacula-dir[14226]: It looks like the traceback
worked...

------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing 
conversations that shape the rapidly evolving mobile landscape. Sign up now. 
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users