Bug 991617
Summary: | Can't upgrade PostgreSQL cartridge from 8.4 to 9.2 | ||||||
---|---|---|---|---|---|---|---|
Product: | OpenShift Online | Reporter: | a00131524 | ||||
Component: | Containers | Assignee: | Fotios Lindiakos <fotios> | ||||
Status: | CLOSED NOTABUG | QA Contact: | libra bugs <libra-bugs> | ||||
Severity: | medium | Docs Contact: | |||||
Priority: | medium | ||||||
Version: | 2.x | CC: | a00131524, chunchen, ffranz, jhonce, jkeck | ||||
Target Milestone: | --- | ||||||
Target Release: | --- | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2013-08-05 21:23:19 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: | |||||||
Attachments: |
|
Description
a00131524
2013-08-03 00:12:15 UTC
1. The issue can be reproduced as below: 1) Create an app with quichstart: https://github.com/fabianofranz/tiny_tiny_rss-openshift-quickstart 2) Remove PostgreSQL 8.4 cartridge 3) Add PostgreSQL 9.2 2. But the issue can not be reproduced as below: 1) Create an app with Postgresql 8.4 rhc app create cphp00 php-5.3 postgresql-8.4 cron-1.4 2) Remove PostgreSQL 8.4 cartridge 3) Add PostgreSQL 9.2 After further investigation, this really had nothing to do with upgrading from postgres 8 to 9. This was a result of the tiny_tiny_rss quickstart running a php process in the background (outside of the normal httpd process). This was keeping the postgres socket connection open, despite the postgres cartridge being removed. If you were to force-stop the application, it would kill that php process Fabiano is changing the way the quickstart operates in order to not keep that process open. I'll ask him to document the quickstart PR here when it's submitted. The tiny_tiny_rss quickstart was updated in order to use cron instead of a daemon for feeds update: https://github.com/fabianofranz/tiny_tiny_rss-openshift-quickstart/commit/71da79302369f0319ec0fb191503a0187d0ff1c3 Please rebase your repository in order to get the latest changes. Also, please note that when removing/replacing the PostgreSQL cartridge it's important to re-run the deploy step in order to have the database recreated: 1) rm $OPENSHIFT_DATA_DIR/.schema_deployed 2) sh $OPENSHIFT_REPO_DIR/.openshift/action_hooks/post_deploy |