[Spacewalk-list] Errors in postgresql Log File

[Michael Mraka]

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