Hi, Greetings first: I am a long term Red Hat / Fedora user, Fedora packager and PostgreSQL contributor. Currently managing PostgreSQL official YUM repository, along with several packages for Fedora and EPEL.
Recently, I deployed Spacewalk on a CentOS 7.2 box, and used PostgreSQL 9.6 in
the backend, along with the latest JDBC driver (For the archives, I managed to
run Spacewalk using community PostgreSQL repositories with a few minor hacks,
Every day, a few times, getting a traceback email:
==============================================================================
Extra information about this error:
SQL Error generated: ('ERROR: syntax error at or near "method"\nLINE 3: ...
sa.remaining_tries, at.label method,\n
^\n', <connection object at
0x7f0101b19180; dsn: 'password=xxxxxxxxxxxxx dbname=spacewalkdb
user=spacewalkuser', closed: 0>, '\n select sa.action_id id,
a.version,\n sa.remaining_tries, at.label method,\n
at.unlocked_only,\n
a.prerequisite\n from rhnServerAction sa,\n
rhnAction a,\n rhnActionType at\n
where sa.server_id = %(server_id)s\n and
sa.action_id = a.id\n and a.action_type = at.id\n
and sa.status in (0, 1) -- Queued or picked up\n
and a.earliest_action <= current_timestamp -- Check earliest_action\n
and not exists (\n select 1\n
from rhnServerAction sap\n
where sap.server_id = %(server_id)s\n and
sap.action_id = a.prerequisite\n and sap.status !=
2 -- completed\n )\n order by
a.earliest_action, a.prerequisite nulls first, a.id\n ')
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py",
line 135, in call_function
response = func(*params)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 327, in get
h.execute(server_id=self.server_id)
File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 151, in execute
return self._execute_wrapper(self._execute, *p, **kw)
File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 303, in _execute_wrapper
raise sql_base.SQLStatementPrepareError(self.dbh, e.pgerror, self.sql)
SQLStatementPrepareError: ('ERROR: syntax error at or near "method"\nLINE 3:
... sa.remaining_tries, at.label method,\n
^\n', <connection object at
0x7f0101b19180; dsn: 'password=xxxxxxxxxxxxx dbname=spacewalkdb
user=spacewalkuser', closed: 0>, '\n select sa.action_id id,
a.version,\n sa.remaining_tries, at.label method,\n
at.unlocked_only,\n
a.prerequisite\n from rhnServerAction sa,\n
rhnAction a,\n rhnActionType at\n
where sa.server_id = %(server_id)s\n and
sa.action_id = a.id\n and a.action_type = at.id\n
and sa.status in (0, 1) -- Queued or picked up\n
and a.earliest_action <= current_timestamp -- Check earliest_action\n
and not exists (\n select 1\n
from rhnServerAction sap\n
where sap.server_id = %(server_id)s\n and
sap.action_id = a.prerequisite\n and sap.status !=
2 -- completed\n )\n order by
a.earliest_action, a.prerequisite nulls first, a.id\n ')
Local variables by frame
Frame _execute_wrapper in
/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
at line 303
function = <type 'instancemethod'> <bound method
Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance
at 0x7f0101def758>>
e = <class 'psycopg2.ProgrammingError'> syntax error
at or near "method"
LINE 3: ... sa.remaining_tries, at.label method,
^
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x7f0101def758>
value = <type 'int'> 1000010020
p = <type 'tuple'> ()
kw = <type 'dict'> {'server_id': 1000010020}
key = <type 'str'> server_id
params = <type 'str'> server_id: 1000010020
Frame execute in
/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 151
p = <type 'tuple'> ()
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x7f0101def758>
kw = <type 'dict'> {'server_id': 1000010020}
Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 327
status = <type 'dict'> {'uname': ['Linux',
'koji-sl6-x86-64-pg93', '2.6.32-642.4.2.el6.x86_64', '#1 SMP Tue Aug 23
11:15:56 CDT 2016', 'x86_64'], 'uptime': [4483833, 4428834]}
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x7f0101def758>
self = <type 'instance'>
<server.handlers.xmlrpc.queue.Queue instance at 0x7f0101dedab8>
ret = <type 'dict'> {}
version = <type 'int'> 2
system_id = <type 'str'> <?xml version="1.0"?>
==============================================================================
It looks like the SQL query is throwing errors somewhere. I think this is
related to PostgreSQL 9.6. If you can point me to the place that I can look, I
will be more than happy to provide a patch.
Thanks!
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
