Bug 1170052
| Summary: | syntax error during upgrade: syntax error at or near ")" at character 235 in "SELECT rhn_install_org_satellites(ORG.id, RSC.recid, '1')... FROM web_customer ..." | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Jan Hutař <jhutar> |
| Component: | Upgrades | Assignee: | Tomáš Kašpárek <tkasparek> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jan Hutař <jhutar> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 570 | CC: | cperry |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | spacewalk-utils-2.3.2-10-sat | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-01-13 10:26:34 UTC | Type: | Bug |
| 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: | 1128174 | ||
rhn_sat_cluster - looks monitoring related After quick look at the sources it looks like this happened during spacewalk-hostname-rename With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is being moved to a Closed Current Release state. The Satellite 5.7 GA Errata: - https://rhn.redhat.com/errata/RHSA-2015-0033.html Satellite 5.7 Release Notes: - https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html Satellite Customer Portal Blog announcement for release: - https://access.redhat.com/blogs/1169563/posts/1315743 Cliff NOTE: This bug has not been re-verified (moved to RELEASE_PENDING) prior to release. We assume that the bug has indeed been fixed and not regressed since we initially verified it. Please re-open in the future if needed. |
Description of problem: I can see syntax error in PostgreSQL log during upgrade (5.3.0@EmbOracle -> 5.7.0@ExtPostgreSQL) Version-Release number of selected component (if applicable): Satellite-5.7.0-RHEL6-re20141128.0 rhn-upgrade-5.7.0.8-1.el6sat.noarch How reproducible: 2 of 2 attempts Steps to Reproduce: 1. I do not know which of upgrade step caused this :-( (will pay more attention next time) Actual results: [...] NOTICE: table "public.qrtz_locks" was reindexed WARNING: there is no transaction in progress WARNING: there is no transaction in progress WARNING: there is no transaction in progress WARNING: there is no transaction in progress ERROR: syntax error at or near ")" at character 235 STATEMENT: SELECT rhn_install_org_satellites(ORG.id, RSC.recid, '1'), ORG.id as FIRST, RSC.recid as SECOND, '1' as THIRD FROM web_customer ORG INNER JOIN rhn_sat_cluster RSC ON ORG.id = RSC.customer_id); WARNING: there is no transaction in progress WARNING: there is no transaction in progress LOG: unexpected EOF on client connection with an open transaction [...] Expected results: No errors in PostgreSQL log and all the utilities returning non-0 exit code in case of an error