Bug 666939
| Summary: | spacewalk-repo-sync fails with column "sysdate" does not exist | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Jim Kinney <jim.kinney> |
| Component: | spacewalk-backend | Assignee: | Miroslav Suchý <msuchy> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | rawhide | CC: | msuchy |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-02-08 08:40:59 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 653453 | ||
Fixed in git commit 9cd810fab81b61aa3c69d67825d7d2c66865e93d Moving ON_QA ... This bug has been fixed in Spacewalk 1.3. |
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: