[Spacewalk-list] "function lookup_evr(integer, unknown, unknown) does not exist" during package verification

[Jan Pazdziora]

On Sun, Jun 03, 2012 at 05:00:04PM -0700, Daniel Dreier wrote:
> I'm running into a problem during package verification on my spacewalk
> server. I suspect that this is an oracle-postgresql issue, but will

[...]

> [Sun Jun 03 14:46:06 2012] [error]
> self._real_cursor.executemany(self.sql, all_kwargs)
> [Sun Jun 03 14:46:06 2012] [error] SQLStatementPrepareError:
> ("function lookup_evr(integer, unknown, unknown) does not exist\\nLINE
> 15:       lookup_evr(1, E'5.5', E'37.el6_2.1'),\\n
> ^\\nHINT:  No function matches the given name and argument types. You
> might need to add explicit type casts.\\n", 0, '\\ninsert into
> rhnServerActionVerifyResult (\\n    server_id, action_id,\\n
> package_name_id,\\n    package_evr_id,\\n    package_arch_id,\\n
> package_capability_id,\\n    attribute, size_differs, mode_differs,
> checksum_differs,\\n    devnum_differs, readlink_differs,
> uid_differs,\\n    gid_differs, mtime_differs\\n)\\nvalues (\\n
> %(server_id)s, %(action_id)s,\\n
> lookup_package_name(%(package_name)s),\\n      lookup_evr(%(epoch)s,
> %(version)s, %(release)s),\\n      lookup_package_arch(%(arch)s),\\n
>    lookup_package_capability(%(filename)s),\\n      %(attrib)s,
> %(test_S)s, %(test_M)s, %(test_5)s,\\n      %(test_D)s, %(test_L)s,
> %(test_U)s,\\n      %(test_G)s, %(test_T)s\\n)\\n')
> [Sun Jun 03 14:46:06 2012] [error]

This was fixed in Spacewalk master, you can patch your Spacewalk
installation with

http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=25739d6af9258404ab314dcb36b5cfb1eb31ba96

Yours,

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat