> On 3 Aug 2007 at 23:17, Scott Ruckh wrote: > >> I am running Bacula version 2.1.28 (built from sources) on CentOS 4.5 >> x86_64. > > That is the latest BETA version of Bacula. > >> I recently upgraded php to PHP 5.2.3 and subsequently I also upgraded >> MySQL to version 5.0.45. >> >> I hit a few bumps but all-in-all most things are back to normal. >> >> Unfortunately bacula is giving me some fits. >> >> Before MySQL upgrade I was running bacula 2.0.8 without too many >> issues. After the upgrade bacula did not work as expected. >> >> After trying a few things, I downloaded the latest beta from >> sourceforge and started over. >> >> I used the scripts in the /etc/bacula directory to create the MySQL >> database and tables, and then the grant permission script to grant >> permissions. >> >> The storage daemon, the client, and the director all start without >> errors. >> >> I kick off a backup job for a remote client and all starts off normal >> as it did before. The pre backup job runs fine and terminates. Then >> bacula looks like it is off to the races doing it thing. >> >> Unfortunately nothing is being written to the database during the >> backup, and in the log I get a ton of errors that look like the >> following: >> >> 03-Aug 22:49 firewall-dir: AMD01_FULL.2007-08-03_22.42.29 Fatal error: >> catreq.c:478 Attribute create error. sql_get.c:1005 Media record for >> Volume "FULL-0001" not found. 03-Aug 22:49 firewall-dir: >> AMD01_FULL.2007-08-03_22.42.29 Fatal error: sql_create.c:730 >> sql_create.c:730 insert INSERT INTO batch VALUES >> (8774,1,'C:/path/','filename.ext','A A IH/ B A A A CJ/ A A BGm2w7 >> BGS3tM BGS3tM A A M','1QMVRHuM+6/LjZpNVY/8KQ') failed: Table >> 'bacula.batch' doesn't exist >> >> There definitely is not a bacula.batch table. Where does this table >> get created? Do I need to do any special initialization of the >> database before running the backup job. Is there something with >> MySQL5 that I need to consider that I did not have to with MySQL4? > > There is an upgrade script which you need to run manually. This will > perform any database modifications required for the latest version > you are running
When I looked at the upgrade script it did not look like it would have any impact and the script was for upgrading older 1.38 type databases. > FYI, I'm running 2.0.3 and do not have a batch table. > > I checked the database creation and update files. It does not seem > to create the batch table. I'll check with devel@ and find out the > story. > >> I did a quick google for Media record for Volume "xxxx" not found and >> did not come up with anything useful. I am not sure what that error >> is telling me. > > It's tell you that it could not find an entry for the Volume it is > trying to backup. > > BTW: Did you happen to drop the old database and create a new one for > Bacula? Is FULL-0001 a VOLUME label that you created with the > previous version of Bacula? I dropped tables and database after I could not get things working with old database. I have created the database and tables from scratch several times. Each time, the scripts completes successfully and database/tables are created. When the daemons are started for the first time, the bacula.Pool table is updated with the information from the bacula-dir.conf file. As such, I assumed bacula/MySQL are playing nice with each other. The FULL-001 is an auto-labled/auto-created volume (on disk). >> I will admit I have not looked at the manual in quite some time as the >> backups were working fine before the MySQL upgrade. >> >> I am hoping someone knows what this error means and can point me in >> the right direction. > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users