[Spacewalk-list] Help with a failing Spacewalk task

[Michael Mraka]

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