James Fillman wrote:
% I've recently upgraded from 1.2 to 1.5 and then migrated from Oracle to
PostgreSQL. Ever since the migration, this regularly scheduled action is
failing on 21 of my 135 servers.
%
% The daily action in question is: 'Show differences between profiled config
files and deployed config files scheduled by (none)'
%
% The output of this action is:
%
% This action will be executed after 12/12/11 11:00:04 PM PST.
%
% This action's status is: Failed.
% The client picked up this action on 12/13/11 3:36:25 AM PST.
% The client completed this action on 12/13/11 4:33:48 AM PST.
% Client execution returned "This action has been picked up multiple times
without a successful transaction; this action is now failed for this system."
(code )
% Config Files:
% /etc/logrotate.d/snmpd (rev. 1)
% /etc/ntp.conf (rev. 1)
...
% File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 277, in _execute_
% self._real_cursor.execute(self.sql, params)
% DataError: invalid input syntax for type bytea at character 115
...
% params = <type 'instance'> {'result': '---
/opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++
/tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000
-0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n
name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n-
url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+
url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n
username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n
</Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n',
'action_config_revision_id': 554813}
Hi James,
I guess you hit the problem with backslash discussed in thread
https://www.redhat.com/archives/spacewalk-list/2011-December/msg00050.html
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
