Backup Central

All,

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...

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

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

On Fri, 2 Dec 2011 10:08:49 +0100, Armin Tueting said:

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.

Check the sql_mode of mysqld. The most likely cause of this error is non-ANSI
mode (see
http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ansi).

__Martin

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

Hello Martin,

Friday, December 2, 2011, 12:47:53 PM, you wrote:

Check the sql_mode of mysqld. The most likely cause of this error is non-ANSI
mode (see
http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ansi).
Put MySQL in ANSI mode and it works. This solved my issue.

Thx,
Armin




------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users