Bacula-users

Re: [Bacula-users] ERROR: Msg delivery error: Unable to store data in database

2013-11-23 17:21:32
Subject: Re: [Bacula-users] ERROR: Msg delivery error: Unable to store data in database
From: Greg Woods <greg AT gregandeva DOT net>
To: bacula-users AT lists.sourceforge DOT net
Date: Sat, 23 Nov 2013 15:18:13 -0700
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