Bug 1170052 - 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 ..."
Summary: syntax error during upgrade: syntax error at or near ")" at character 235 in ...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Jan Hutař
URL:
Whiteboard:
Depends On:
Blocks: sat570-upgrades
TreeView+ depends on / blocked
 
Reported: 2014-12-03 06:55 UTC by Jan Hutař
Modified: 2015-01-13 10:26 UTC (History)
1 user (show)

Fixed In Version: spacewalk-utils-2.3.2-10-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-01-13 10:26:34 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2014-12-03 06:55:57 UTC
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

Comment 1 Clifford Perry 2014-12-03 10:16:17 UTC
rhn_sat_cluster - looks monitoring related

Comment 2 Tomáš Kašpárek 2014-12-03 10:57:28 UTC
After quick look at the sources it looks like this happened during spacewalk-hostname-rename

Comment 7 Clifford Perry 2015-01-13 10:26:34 UTC
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.


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