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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users