Bug 1010846
| Summary: | Can not reload postgresql-8.4 after stopping DB cartridge with non-scablable app | ||
|---|---|---|---|
| Product: | OpenShift Container Platform | Reporter: | Ma xiaoqiang <xiama> |
| Component: | Containers | Assignee: | Miciah Dashiel Butler Masters <mmasters> |
| Status: | CLOSED ERRATA | QA Contact: | libra bugs <libra-bugs> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 1.2.0 | CC: | baulakh, bleanhar, hasari, libra-onpremise-devel, mpatel, wsun, xiama, xtian, yadu |
| Target Milestone: | --- | Flags: | xiama:
needinfo+
|
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | openshift-origin-cartridge-postgresql-0.2.8-1 | Doc Type: | Bug Fix |
| Doc Text: |
Due to a bug in the PostgreSQL cartridge, non-scaled PostgreSQL databases would not reload after the cartridge was stopped and restarted. This has been fixed and the PostgreSQL databases now reload correctly after a cartridge restart.
|
Story Points: | --- |
| Clone Of: | 981528 | Environment: | |
| Last Closed: | 2013-10-16 15:39:24 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: | 981528, 981780 | ||
| Bug Blocks: | 980739 | ||
|
Description
Ma xiaoqiang
2013-09-23 07:52:57 UTC
Can you check again that the bug exists on OSE 1.2? I cannot reproduce the problem:
[root@broker ~]# rhc app create testapp2 ruby-1.9 postgresql -s --no-git
Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql'
Your authorization token has expired. Please sign in now to continue.
Password: ********
Application Options
-------------------
Namespace: ose
Cartridges: ruby-1.9, postgresql-8.4
Gear Size: default
Scaling: yes
Creating application 'testapp2' ... done
Waiting for your DNS name to be available ... done
testapp2 @ http://testapp2-ose.example.com/ (uuid: 524d90a36892dfc384000027)
----------------------------------------------------------------------------
Created: 8:43 AM
Gears: 2 (defaults to small)
Git URL: ssh://524d90a36892dfc384000027.com/~/git/testapp2.git/
SSH: 524d90a36892dfc384000027.com
postgresql-8.4 (PostgreSQL Database 8.4)
----------------------------------------
Gears: 1 small
Connection URL: postgresql://$OPENSHIFT_POSTGRESQL_DB_HOST:$OPENSHIFT_POSTGRESQL_DB_PORT
Database Name: testapp2
Password: CkTNjUkQASpC
Username: adminghqzyt1
ruby-1.9 (Ruby 1.9)
-------------------
Scaling: x1 (minimum: 1, maximum: available) on small gears
haproxy-1.4 (OpenShift Web Balancer)
------------------------------------
Gears: Located with ruby-1.9
RESULT:
Application testapp2 was created.
PostgreSQL 8.4 database added. Please make note of these credentials:
Root User: adminghqzyt1
Root Password: CkTNjUkQASpC
Database Name: testapp2
Connection URL: postgresql://$OPENSHIFT_POSTGRESQL_DB_HOST:$OPENSHIFT_POSTGRESQL_DB_PORT
HAProxy instance is started
[root@broker ~]# rhc cartridge stop postgresql -a testapp2
Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql'
RESULT:
postgresql-8.4 stopped
[root@broker ~]# rhc cartridge reload postgresql -a testapp2
Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql'
RESULT:
postgresql-8.4 reloaded
[root@broker ~]# rhc cartridge stop postgresql -a testapp2
Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql'
RESULT:
postgresql-8.4 stopped
[root@broker ~]# rhc cartridge reload postgresql -a testapp2
Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql'
RESULT:
postgresql-8.4 reloaded
[root@broker ~]# rpm -qa |grep cartridge-postgresq
openshift-origin-cartridge-postgresql-0.2.7-1.1.el6op.noarch
[root@broker ~]#
Additionally, the reported error message does not exist in Enterprise. It was introduced in commit ee550b2e3700f9777b884c4814c337aecc4eb6db to origin-server, which has not been backported to enterprise-server, and the text 'Failed to correctly execute all parallel operations' does not appear anywhere in the Enterprise codebase (I did a git grep on the enterprise-1.2 and enterprise-1.2.z branches).
Can you bug the problem again on OSE 1.2 and provide the exact commands and output of those commands? If I could get access to a devenv where you have reproduced the bug, that would be even better.
For what it's worth, I do have a local branch with the backport of the fix from origin-server, ready to push and merge.
I have check it. We should create a non-scalable app to reproduce this problem.there is not this problem with a scalable app. 1.create an non-scalable app #rhc app create xiaom3 ruby-1.9 2.add postgresql cartridge to it #rhc cartridge add postgre -a xiaom3 3.stop the postgresql cartridge #rhc cartridge stop postgresql -a xiaom3 4.reload cartirdge #rhc cartridge reload postgresql -a xiaom3 Using postgresql-8.4 (PostgreSQL Database 8.4) for 'postgresql' Unable to complete the requested operation due to: Node execution failure (invalid exit code from node). If the problem persists please contact Red Hat support.. Reference ID: ff4c4ec4606bb77e8881d350c700ff26. check this problem on puddle:[1.2/2013-10-08.1] 1.create an non-scalable app #rhc app create xiaom3 ruby-1.9 2.add postgresql cartridge to it #rhc cartridge add postgre -a xiaom3 3.stop the postgresql cartridge #rhc cartridge stop postgresql -a xiaom3 4.reload cartirdge #rhc cartridge reload postgresql -a xiaom3 Using postgresql-8.4 (PostgreSQL Database 8.4) for 'post' Reloading postgresql-8.4 ... 'reload' is valid only when the database is running Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2013-1435.html |