Bug 1056961
| Summary: | Could not connect to DB via proxy port for some scalable apps due to the begin_uid changed on INT/STG after migration | ||
|---|---|---|---|
| Product: | OpenShift Online | Reporter: | XiuJuan Wang <xiuwang> |
| Component: | Containers | Assignee: | Jhon Honce <jhonce> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | libra bugs <libra-bugs> |
| Severity: | high | Docs Contact: | |
| Priority: | medium | ||
| Version: | 2.x | CC: | bmeng, dmace, dmcphers, mpatel, xiuwang |
| Target Milestone: | --- | Keywords: | Reopened |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-02-26 19:10:09 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: | |||
|
Description
XiuJuan Wang
2014-01-23 09:17:48 UTC
XiuJuan Wang: While I'm trying to get the correct devenv to run to reproduce this issue, in meanwhile could you please try to run: \conninfo in the psql command. That should print out details about the current database connection (hostname/user/etc). I wonder if they are different than '52ce07426cec0e946700082e-migrate.int.rhcloud.com'. II'm not able to reproduce this issue on the devenv_4265, so this might be migration issue. QE please note that you might hit this issue for existing apps on INT, if a newer app has a uid greater than an older app by 500. We don't intend to fix that on INT, so we are closing the bug. Hi Mrunal Patel, DB on my newer app works well after INT upgrade. The DB UID 5639 , is greater 500 than that broken app. So will ingore this issue. Thanks! ps -ef UID PID PPID C STIME TTY TIME CMD 5639 270895 270879 0 03:58 ? 00:00:00 sshd: 52e0b35903ef6410c500026e@pts/4 5639 270902 270895 1 03:58 pts/4 00:00:00 /bin/bash --init-file /usr/bin/rhcsh -i 5639 271748 270902 0 03:58 pts/4 00:00:00 ps -ef 5639 502813 1 0 Jan23 ? 00:00:00 /opt/rh/postgresql92/root/usr/bin/postgres 5639 502844 502813 0 Jan23 ? 00:00:00 postgres: logger process 5639 502858 502813 0 Jan23 ? 00:00:00 postgres: checkpointer process 5639 502859 502813 0 Jan23 ? 00:00:00 postgres: writer process 5639 502860 502813 0 Jan23 ? 00:00:00 postgres: wal writer process The issue can be reproduced on current STG(devenv-stage_655) as well. May be regression issue from the fix of this bug https://bugzilla.redhat.com/show_bug.cgi?id=1051015 Please make sure this will not affect PROD. Head gear: [cpython27ssmin2gearsjkns-cstgmigrate.stg.rhcloud.com 52e0af5d2587c8d8e900033f]\> psql psql: could not connect to server: Connection refused Is the server running on host "52e0af5d2587c8d8e9000340-cstgmigrate.stg.rhcloud.com" (10.34.7.149) and accepting TCP/IP connections on port 40301? DB gear: [52e0af5d2587c8d8e9000340-cstgmigrate.stg.rhcloud.com 52e0af5d2587c8d8e9000340]\> psql psql (9.2.4) Type "help" for help. cpython27ssmin2gearsjkns=# The app was created on Created: Jan 23 2:20 PM UID for the head gear: [cpython27ssmin2gearsjkns-cstgmigrate.stg.rhcloud.com 52e0af5d2587c8d8e900033f]\> id -u 6122 UID for the DB gear: [52e0af5d2587c8d8e9000340-cstgmigrate.stg.rhcloud.com 52e0af5d2587c8d8e9000340]\> id -u 1454 Tested on devenv, upgrade from devenv-stage_660 to latest stage branch (devenv-stage_667). Create scalable app with db added before upgrade, occupy the UIDs between 1004 and 1499 via useradd. Create new apps after upgrade and migration, which used the UID 1500, 1501,1502,1503 Check the old app, all the dbs can be connected. Move the bug to verified. Reproduce on INT(devenv_4369) My older scaleble app perldbjks's dbs can be not connected (xiuwang+m:redhat): Head gear's UID is 4703 PSQL gear UID is 2110 Mysql gear UID is 2713 Mongo Gear UID is 2407 New create apps pys UID is 4603,perl UID is 5374,ruby UID is 5774. My issue was affected by bug 1064219. Sorry for mistake it. Accordding to comment 13, move this bug to Verified. |