Bug 666939 - spacewalk-repo-sync fails with column "sysdate" does not exist
Summary: spacewalk-repo-sync fails with column "sysdate" does not exist
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: spacewalk-backend
Version: rawhide
Hardware: x86_64
OS: Linux
low
medium
Target Milestone: ---
Assignee: Miroslav Suchý
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks: space13
TreeView+ depends on / blocked
 
Reported: 2011-01-03 19:03 UTC by Jim Kinney
Modified: 2011-02-08 08:40 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-08 08:40:59 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Jim Kinney 2011-01-03 19:03:47 UTC
Description of problem:
spacewalk-repo-sync fails with "column "sysdate" does not exist


Version-Release number of selected component (if applicable):
spacewalk-backend-tools-1.3.36-1.fc14.noarch

How reproducible:


Steps to Reproduce:
1. run spacewalk-repo-sync
2.
3.
  
Actual results:
Traceback (most recent call last):
  File "/usr/bin/spacewalk-repo-sync", line 69, in <module>
    sys.exit(abs(main() or 0))
  File "/usr/bin/spacewalk-repo-sync", line 63, in main
    sync.main()
  File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 104, in main
    taskomatic.add_to_erratacache_queue(self.channel_label)
  File "/usr/lib/python2.7/site-packages/spacewalk/server/taskomatic.py", line 79, in add_to_erratacache_queue
    h.execute(label=channel, priority=priority)
  File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 263, in _execute_wrapper
    raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('column "sysdate" does not exist\nLINE 8:                   sysdate\n                          ^\n', 0, "\n    insert into rhnTaskQueue\n           (org_id, task_name, task_data, priority, earliest)\n           select coalesce(c.org_id, 1),\n                  'update_errata_cache_by_channel',\n                  c.id,\n                  %(priority)s,\n                  sysdate\n             from rhnChannel c\n            where c.label = %(label)s\n    ")

Expected results:
"Successfully updated"

Additional info:

Comment 1 Miroslav Suchý 2011-01-04 10:29:22 UTC
Fixed in git commit 9cd810fab81b61aa3c69d67825d7d2c66865e93d

Comment 2 Tomas Lestach 2011-02-03 12:21:15 UTC
Moving ON_QA ...

Comment 3 Tomas Lestach 2011-02-08 08:40:59 UTC
This bug has been fixed in Spacewalk 1.3.


Note You need to log in before you can comment on or make changes to this bug.