Wojtak, Greg wrote: % I found a corresponding entry in httpd's error_log: % % [Mon Oct 31 10:51:11 2011] [error] DataError: invalid input syntax for % type bytea % [Mon Oct 31 10:51:11 2011] [error] LINE 4: values (71254, E'--- % /root/.bashrc Wed Sep 22 23:59:52 2... % % It looks like it's dying due to the 'E' character outside of the quotes. % Any idea where that might be getting introduced?
E'string' is the escaped bytea string representation, there's nothing wrong with it. See http://www.postgresql.org/docs/current/static/datatype-binary.html for the details. Unfortunately that 114 char is just reference to the beginning of bytea string which has something wrong inside. Try 'od -c /root/.bashrc' on your client to see whether there is a weird char or not. % >I think I might have found why certain actions aren't being picked up by % >my spacewalk clients. % > % >The actions are indeed being picked up, but there are bunch of "compare % >config file revision tasks" blocking the queue. These are not % >completing, I'm hypothesizing, because of: % > % >ERROR: invalid input syntax for type bytea at character 114 % >STATEMENT: % > insert into rhnActionConfigRevisionResult % > (action_config_revision_id, result) % > values (69925, E'--- /root/.bashrc Wed Sep 22 23:59:52 2004 % > +++ /tmp/.rhn-cfg-tmp-30263-g_Y4rn Fri Oct 28 11:21:36 2011 % > @@ -6,7 +6,36 @@ % > alias cp=''cp -i'' % > alias mv=''mv -i'' % >Š % > % >I'm having a hard time deciphering where character 114 is in this output. % > Is it the double-single quotes in the alias lines there that are % >throwing it off? The actual file contains only a single quote (alias % >cp='cp -i'). Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
