Hi,
concerning your question:
below I pasted my error-log for this problem I encountered & fixed (and
I tried a few times, the others are just the same):
[Sun Mar 25 00:20:40 2012] [error] Exception reported from srv08.xx.de
[Sun Mar 25 00:20:40 2012] [error] Time: Sun Mar 25 00:20:40 2012
[Sun Mar 25 00:20:40 2012] [error] Exception type <class
'spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError'>
[Sun Mar 25 00:20:40 2012] [error] Exception while handling function
registration.new_system
[Sun Mar 25 00:20:40 2012] [error] Request object information:
[Sun Mar 25 00:20:40 2012] [error] URI: /XMLRPC
[Sun Mar 25 00:20:40 2012] [error] Remote Host: srv01.xx.de
[Sun Mar 25 00:20:40 2012] [error] Server Name: srv08.xx.de:443
[Sun Mar 25 00:20:40 2012] [error] Headers passed in:
[Sun Mar 25 00:20:40 2012] [error] \tAccept-Encoding: identity
[Sun Mar 25 00:20:40 2012] [error] \tCONTENT_LENGTH: 1530
[Sun Mar 25 00:20:40 2012] [error] \tCONTENT_TYPE: text/xml
[Sun Mar 25 00:20:40 2012] [error] \tDOCUMENT_ROOT: /var/www/html
[Sun Mar 25 00:20:40 2012] [error] \tGATEWAY_INTERFACE: CGI/1.1
[Sun Mar 25 00:20:40 2012] [error] \tHTTPS: 1
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_ACCEPT_ENCODING: identity
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_HOST: srv08.xx.de:443
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_USER_AGENT:
rhn.rpclib.py/$Revision$
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_CLIENT_VERSION: 1
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_INFO: RPC Processor (C) Red
Hat, Inc (version $Revision$)
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_RHN_CLIENT_CAPABILITY:
caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.updd
ate(2)=2,packages.rollBack(1)=1
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_RHN_TRANSPORT_CAPABILITY:
follow-redirects=3
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_TRANSPORT_INFO: Extended
Capabilities Transport (C) Red Hat, Inc (version $Revision$)
[Sun Mar 25 00:20:40 2012] [error] \tHTTP_X_UP2DATE_VERSION: 1.7.14-1.el5
[Sun Mar 25 00:20:40 2012] [error] \tHost: srv08.xx.de:443
[Sun Mar 25 00:20:40 2012] [error] \tPATH_INFO:
[Sun Mar 25 00:20:40 2012] [error] \tQUERY_STRING:
[Sun Mar 25 00:20:40 2012] [error] \tREMOTE_ADDR: 10.152.30.93
[Sun Mar 25 00:20:40 2012] [error] \tREMOTE_PORT: 45039
[Sun Mar 25 00:20:40 2012] [error] \tREQUEST_METHOD: POST
[Sun Mar 25 00:20:40 2012] [error] \tREQUEST_URI: /XMLRPC
[Sun Mar 25 00:20:40 2012] [error] \tSCRIPT_FILENAME:
/usr/share/rhn/wsgi/xmlrpc.py
[Sun Mar 25 00:20:40 2012] [error] \tSCRIPT_NAME: /XMLRPC
[Sun Mar 25 00:20:40 2012] [error] \tSCRIPT_URI: https://srv08.xx.de/XMLRPC
[Sun Mar 25 00:20:40 2012] [error] \tSCRIPT_URL: /XMLRPC
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_ADDR: 10.152.30.117
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_ADMIN: root@localhost
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_NAME: srv08.xx.de
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_PORT: 443
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_PROTOCOL: HTTP/1.1
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_SIGNATURE: <address>Apache
Server at srv08.xx.de Port 443</address>
[Sun Mar 25 00:20:40 2012] [error]
[Sun Mar 25 00:20:40 2012] [error] \tSERVER_SOFTWARE: Apache
[Sun Mar 25 00:20:40 2012] [error] \tUser-Agent: rhn.rpclib.py/$Revision$
[Sun Mar 25 00:20:40 2012] [error] \tX-Client-Version: 1
[Sun Mar 25 00:20:40 2012] [error] \tX-Info: RPC Processor (C) Red Hat,
Inc (version $Revision$)
[Sun Mar 25 00:20:40 2012] [error] \tX-RHN-Client-Capability:
caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
[Sun Mar 25 00:20:40 2012] [error] \tX-RHN-Transport-Capability:
follow-redirects=3
[Sun Mar 25 00:20:40 2012] [error] \tX-Transport-Info: Extended
Capabilities Transport (C) Red Hat, Inc (version $Revision$)
[Sun Mar 25 00:20:40 2012] [error] \tX-Up2Date-Version: 1.7.14-1.el5
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.application_group:
srv08.xx.de|/xmlrpc
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.callable_object: application
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.handler_script:
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.input_chunked: 0
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.listener_host:
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.listener_port: 443
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.process_group:
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.request_handler: wsgi-script
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.script_reloading: 1
[Sun Mar 25 00:20:40 2012] [error] \tmod_wsgi.version: (3, 3)
[Sun Mar 25 00:20:40 2012] [error] \twsgi.errors: <mod_wsgi.Log object
at 0x7f0e45b81fb0>
[Sun Mar 25 00:20:40 2012] [error] \twsgi.file_wrapper: <built-in method
file_wrapper of mod_wsgi.Adapter object at 0x7f0e45c52120>
[Sun Mar 25 00:20:40 2012] [error] \twsgi.input: <mod_wsgi.Input object
at 0x7f0e45b81eb0>
[Sun Mar 25 00:20:40 2012] [error] \twsgi.multiprocess: True
[Sun Mar 25 00:20:40 2012] [error] \twsgi.multithread: False
[Sun Mar 25 00:20:40 2012] [error] \twsgi.run_once: False
[Sun Mar 25 00:20:40 2012] [error] \twsgi.url_scheme: https
[Sun Mar 25 00:20:40 2012] [error] \twsgi.version: (1, 1)
[Sun Mar 25 00:20:40 2012] [error] Extra information about this error:
[Sun Mar 25 00:20:40 2012] [error] SQL Error generated: ('syntax error
at or near "label"\\nLINE 2: select kvt.label
label\\n ^\\n', 0, '\\n select
kvt.label label\\n from rhnKickstartVirtualizationType
kvt\\n where kvt.id = %(id)s\\n ')
[Sun Mar 25 00:20:40 2012] [error]
[Sun Mar 25 00:20:40 2012] [error] Exception Handler Information
[Sun Mar 25 00:20:40 2012] [error] Traceback (most recent call last):
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py",
line 122, in call_function
[Sun Mar 25 00:20:40 2012] [error] response = apply(func, params)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 502, in
new_system
[Sun Mar 25 00:20:40 2012] [error] architecture, data)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 403, in
create_system
[Sun Mar 25 00:20:40 2012] [error] newserv.process_kickstart_info()
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_class.py",
line 780, in process_kickstart_info
[Sun Mar 25 00:20:40 2012] [error] kickstart_session_id)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_kickstart.py",
line 253, in subscribe_to_tools_channel
[Sun Mar 25 00:20:40 2012] [error] ks_type =
_get_ks_virt_type(ks_type_id)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_kickstart.py",
line 229, in _get_ks_virt_type
[Sun Mar 25 00:20:40 2012] [error] prepared_query.execute(id=type_id)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 163, in execute
[Sun Mar 25 00:20:40 2012] [error] return
apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 282, in _execute_wrapper
[Sun Mar 25 00:20:40 2012] [error] retval = apply(function, p, kw)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 217, in _execute
[Sun Mar 25 00:20:40 2012] [error] return self._execute_(args, kwargs)
[Sun Mar 25 00:20:40 2012] [error] File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 295, in _execute_
[Sun Mar 25 00:20:40 2012] [error]
self._real_cursor.execute(self.sql, params)
[Sun Mar 25 00:20:40 2012] [error] SQLStatementPrepareError: ('syntax
error at or near "label"\\nLINE 2: select kvt.label
label\\n ^\\n', 0, '\\n select
kvt.label label\\n from rhnKickstartVirtualizationType
kvt\\n where kvt.id = %(id)s\\n ')
[Sun Mar 25 00:20:40 2012] [error]
Best
-Jonathan
On 03/26/2012 10:29 AM, Miroslav Suchy wrote:
On 25.3.2012 01:39, Jonathan Hoser wrote:
and again encountered the issue I suggested a patch for.
This time, I applied the suggested variant
"Select label from [...]" and it is working all the same.
It is triggered on a rhn_register call from a client.
Please find the corresponding patch attached.
Sorry for joining this thread so late, but you said;
> Added 'as' to the SQL command, since PostgreSQL 9.x
> (possibly also 8.x) stumbles over it
What do you mean "stumbles"? Can you point me to some error message?
I installed pg 9.1 to test it and I did:
psql (9.1.3)
Type "help" for help.
postgres=# create table test (id int);
CREATE TABLE
postgres=# select id from test;
id
----
(0 rows)
postgres=# select id from test t;
id
----
(0 rows)
postgres=# select t.id from test t;
id
----
(0 rows)
postgres=# select t.id id from test t;
id
----
(0 rows)
postgres=# select t.id as id from test t;
id
----
(0 rows)
And I see no errors from PostgreSQL server in all cases.
Mirek
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
