Bacula-users

Re: [Bacula-users] SQL Failure while upgrading from 5.0.3 to 5.2.1

2011-12-02 04:24:47
Subject: Re: [Bacula-users] SQL Failure while upgrading from 5.0.3 to 5.2.1
From: Armin Tueting <armin.tueting AT tueting-online DOT com>
To: bacula-users AT lists.sourceforge DOT net <bacula-users AT lists.sourceforge DOT net>
Date: Fri, 2 Dec 2011 10:08:49 +0100
>>26-Nov 12:43 sydney-dir JobId 10: Error: sql_update.c:255 sql_update.c:255 
>>update UPDATE Counters SET 
>>"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE 
>>Counter='DiffFileVolumeCounter' failed: 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 
>>'"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE 
>>Counter='' at line 1
>>26-Nov 12:43 sydney-dir JobId 10: Error: Count not update counter 
>>DiffFileVolumeCounter: ERR=sql_update.c:255 update UPDATE Counters SET 
>>"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE 
>>Counter='DiffFileVolumeCounter'
> failed: 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
> '"MinValue"=1,"MaxValue"=2147483647,CurrentValue=2,WrapCounter='' WHERE 
> Counter='' at line 1
>>26-Nov 12:43 sydney-dir JobId 10: Created new Volume "DiffFile-0001" in 
>>catalog.
> I'm getting the error message when upgrading from 5.0.3 to 5.2.1...

I've done some research and found the following in GIT
>Fix bug #1504 -- Error when creating tables in MySQL 5.5
This  seems  to  resolve  the issue for version 5.5.  RHEL, CentOS are
running version 5.0...

Any help appreciated.


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>