I'm looking at the SQL syntax and can't figure out why it wants to insert
these values into "batch" table. There was absolutely NO changes made to the
database. This table has not existed previously. The only change that I've
made recently was enabling data encryption for these clients. I can't see
why this would cause it to want to insert values into a non-existent table
however....
Thanks
On Jan 10, 2008 11:34 AM, Mingus Dew <[EMAIL PROTECTED]> wrote:
> My bad... MySQL 4.1.22
>
>
> On Jan 10, 2008 11:06 AM, Ryan Novosielski <[EMAIL PROTECTED]> wrote:
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Mingus Dew wrote:
> > > All,
> > > I am running Bacula 2.2.5 on Solaris 10_x86. This morning one of
> > my
> > > incremental backups failed, thought I'm not sure why. The previous 24
> > > hours' jobs were successful however. Here is the error I received in
> > the
> > > status email.
> > >
> > > 10-Jan 10:48 mt-back4.director JobId 533: Fatal error:
> > sql_create.c:732
> > > sql_create.c:732 insert INSERT INTO batch VALUES
> > > (15679,533,'/var/log/','lastlog','gG BoAC IEA B A A A SP///7c BAA B4
> > > BHhNjJ BHhNjJ BHhNjJ A A U','UVI7Ouq/KvquKKOnKbNs+Q') failed:
> > > Table 'bacula.batch' doesn't exist
> > > 10-Jan 10:48 mt-back4.director JobId 533: sql_create.c:732 INSERT INTO
> > > batch VALUES (15679,533,'/var/log/','lastlog','gG BoAC IEA B A A A
> > > SP///7c BAA B4 BHhNjJ BHhNjJ BHhNjJ A A U','UVI7Ouq/KvquKKOnKbNs+Q')
> > > 10-Jan 10:48 mt-back4.director JobId 533: Fatal error: catreq.c:478
> > > Attribute create error. Query failed: DROP INDEX DelInx1: ERR=You have
> > > an error in your SQL syntax; check the manual that corresponds to your
> >
> > > MySQL server version for the right syntax to use near '' at line 1
> > > 10-Jan 10:48 mt-back4.storage JobId 533: Job
> > > bop-prod-db2_Daily_Disk.2008-01-10_02.30.38 marked to be canceled.
> > > 10-Jan 10:48 mt-back4.storage JobId 533: Job write elapsed time =
> > > 08:18:50, Transfer rate = 41.90 M bytes/second
> > > 10-Jan 10:48 mt-back4.storage JobId 533: Job
> > > bop-prod-db2_Daily_Disk.2008-01-10_02.30.38 marked to be canceled.
> > > 10-Jan 10:48 mt-back4.storage JobId 533: Job
> > > bop-prod-db2_Daily_Disk.2008-01-10_02.30.38 marked to be canceled.
> > > 10-Jan 10:48 mt-back4.storage JobId 533: Job
> > > bop-prod-db2_Daily_Disk.2008-01-10_02.30.38 marked to be canceled.
> > > 10-Jan 10:48 bop-prod-db2.shopbop:
> > > bop-prod-db2_Daily_Disk.2008-01-10_02.30.38 Fatal error: backup.c:860
> > > Network send error to SD. ERR=Broken pipe
> > > 10-Jan 10:49 mt-back4.director JobId 533: Error: Bacula
> > > mt-back4.director 2.2.5 (09Oct07): 10-Jan-2008 10:49:04
> > >
> > > Now this table "bacula.batch " doesn't exist, but I don't know why it
> > > should want this table now, backups have run successfully for this
> > > client before.
> >
> > You do not mention your MySQL version, which is critical if you are
> > having a MySQL problem.
> >
> > - --
> > ---- _ _ _ _ ___ _ _ _
> > |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II
> > |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
> > \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.6 (GNU/Linux)
> > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> >
> > iD8DBQFHhkJ8mb+gadEcsb4RAoq9AKDlLWjNKeb0S6rVB/yfdnAe5VMQ2ACeK7c6
> > TanPCMMEucaqUwLsM40Rbz8=
> > =udRI
> > -----END PGP SIGNATURE-----
> >
>
>
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
