Hi,
I successfully deployed pgAdmin web on our SAP BTP Cloud Foundry and can access
pgAdmin and logon.
I can create users and servers but when the app restarts, all entries are lost.
I’m assuming it’s using SQLite which would not be persistent in the Cloud
Foundry.
I did bind web-pgadmin to a PostgreSQL, Hyperscaler Option database.
I added the user-provided variable to PGADMIN_CONFIG_CONFIG_DATABASE_URI with:
postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx
I restarted the pgadmin-web app and it crashed.
Please find attached the application start log. I changed some of the text with
“xxx” for security.
For the deployment, I used a docker image:
applications:
- name: pgadmin-web
docker:
image: dpage/pgadmin4:2024-10-19-2
instances: 1
memory: 1G
disk_quota: 1G
health-check-type: process
env:
PGADMIN_DEFAULT_EMAIL: <email address>
PGADMIN_DEFAULT_PASSWORD: <new password>
PGADMIN_LISTEN_ADDRESS: 0.0.0.0
Thank you
Moelaj
2024-11-05T13:05:33.386+0000 [API/6] STDOUT Updated app with guid
24c881e1-70f1-4c36-874c-641f1255ab38 ({"environment_variables"=>"[PRIVATE DATA
HIDDEN]"})
2024-11-05T13:05:53.007+0000 [API/1] STDOUT Creating revision for app with guid
24c881e1-70f1-4c36-874c-641f1255ab38
2024-11-05T13:05:53.071+0000 [CELL/0] STDOUT Cell
dc116d00-d79a-4638-a5b9-715e8aa19cf8 stopping instance
9abac342-67c1-47c2-4bf0-bfd5
2024-11-05T13:05:53.157+0000 [API/1] STDOUT Restarted app with guid
24c881e1-70f1-4c36-874c-641f1255ab38
2024-11-05T13:05:53.208+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 creating container for instance
13c48748-1d09-435a-7250-b0f1
2024-11-05T13:05:58.358+0000 [APP/PROC/WEB/0] STDERR [2024-11-05 13:05:58
+0000] [7] [INFO] Handling signal: term
2024-11-05T13:05:58.897+0000 [APP/PROC/WEB/0] STDERR [2024-11-05 13:05:58
+0000] [273] [INFO] Worker exiting (pid: 273)
2024-11-05T13:05:59.660+0000 [APP/PROC/WEB/0] STDERR [2024-11-05 13:05:59
+0000] [7] [INFO] Shutting down: Master
2024-11-05T13:05:59.699+0000 [APP/PROC/WEB/0] STDOUT Exit status 0
2024-11-05T13:05:59.711+0000 [CELL/0] STDOUT Cell
dc116d00-d79a-4638-a5b9-715e8aa19cf8 destroying container for instance
9abac342-67c1-47c2-4bf0-bfd5
2024-11-05T13:05:59.818+0000 [PROXY/0] STDOUT Exit status 137
2024-11-05T13:06:01.009+0000 [CELL/0] STDOUT Cell
dc116d00-d79a-4638-a5b9-715e8aa19cf8 successfully destroyed container for
instance 9abac342-67c1-47c2-4bf0-bfd5
2024-11-05T13:06:02.766+0000 [CELL/0] STDOUT Security group rules were updated
2024-11-05T13:06:02.822+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 successfully created container for
instance 13c48748-1d09-435a-7250-b0f1
2024-11-05T13:06:03.356+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1
2024-11-05T13:06:03.356+0000 [APP/PROC/WEB/0] STDERR from
check_external_config_db import check_external_config_db; val =
check_external_config_db(postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx);
print(val)
2024-11-05T13:06:03.356+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:03.356+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:03.375+0000 [API/7] STDOUT Process became ready with guid
24c881e1-70f1-4c36-874c-641f1255ab38 payload:
{"instance"=>"13c48748-1d09-435a-7250-b0f1", "index"=>0,
"cell_id"=>"160906dd-6149-4a92-82a9-b85b52f60865", "ready"=>true,
"version"=>"9118506d-b996-4f8d-8750-98d72c67ad3f"}
2024-11-05T13:06:03.598+0000 [APP/PROC/WEB/0] STDERR postfix/postlog: starting
the Postfix mail system
2024-11-05T13:06:08.112+0000 [APP/PROC/WEB/0] STDERR Traceback (most recent
call last):
2024-11-05T13:06:08.112+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1,
in <module>
2024-11-05T13:06:08.112+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config.py", line 951, in <module>
2024-11-05T13:06:08.112+0000 [APP/PROC/WEB/0] STDERR from
pgadmin.evaluate_config import evaluate_and_patch_config
2024-11-05T13:06:08.112+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/pgadmin/evaluate_config.py", line 50, in <module>
2024-11-05T13:06:08.113+0000 [APP/PROC/WEB/0] STDERR import config_distro
2024-11-05T13:06:08.113+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config_distro.py", line 13
2024-11-05T13:06:08.113+0000 [APP/PROC/WEB/0] STDERR CONFIG_DATABASE_URI =
postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx
2024-11-05T13:06:08.113+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:08.113+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:08.949+0000 [APP/PROC/WEB/0] STDERR usage: gunicorn [OPTIONS]
[APP_MODULE]
2024-11-05T13:06:08.949+0000 [APP/PROC/WEB/0] STDERR gunicorn: error: argument
-t/--timeout: invalid int value: ''
2024-11-05T13:06:08.972+0000 [APP/PROC/WEB/0] STDOUT Exit status 2
2024-11-05T13:06:14.236+0000 [API/3] STDOUT Process has crashed with type: "web"
2024-11-05T13:06:14.236+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 stopping instance
13c48748-1d09-435a-7250-b0f1
2024-11-05T13:06:14.236+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 destroying container for instance
13c48748-1d09-435a-7250-b0f1
2024-11-05T13:06:14.247+0000 [API/3] STDOUT App instance exited with guid
24c881e1-70f1-4c36-874c-641f1255ab38 payload:
{"instance"=>"13c48748-1d09-435a-7250-b0f1", "index"=>0,
"cell_id"=>"160906dd-6149-4a92-82a9-b85b52f60865", "reason"=>"CRASHED",
"exit_description"=>"APP/PROC/WEB: Exited with status 2", "crash_count"=>1,
"crash_timestamp"=>1730811974217696188,
"version"=>"9118506d-b996-4f8d-8750-98d72c67ad3f"}
2024-11-05T13:06:14.278+0000 [CELL/0] STDOUT Cell
94d64bda-edc0-47e4-93e3-17ee64c920e3 creating container for instance
a6cd6b7a-14a6-4bc9-44d6-93b0
2024-11-05T13:06:15.196+0000 [PROXY/0] STDOUT Exit status 137
2024-11-05T13:06:15.882+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 successfully destroyed container for
instance 13c48748-1d09-435a-7250-b0f1
2024-11-05T13:06:23.545+0000 [CELL/0] STDOUT Security group rules were updated
2024-11-05T13:06:23.591+0000 [CELL/0] STDOUT Cell
94d64bda-edc0-47e4-93e3-17ee64c920e3 successfully created container for
instance a6cd6b7a-14a6-4bc9-44d6-93b0
2024-11-05T13:06:23.887+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1
2024-11-05T13:06:23.887+0000 [APP/PROC/WEB/0] STDERR from
check_external_config_db import check_external_config_db; val =
check_external_config_db(postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx);
print(val)
2024-11-05T13:06:23.887+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:23.887+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:24.128+0000 [APP/PROC/WEB/0] STDERR postfix/postlog: starting
the Postfix mail system
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR Traceback (most recent
call last):
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1,
in <module>
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config.py", line 951, in <module>
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR from
pgadmin.evaluate_config import evaluate_and_patch_config
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/pgadmin/evaluate_config.py", line 50, in <module>
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR import config_distro
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config_distro.py", line 13
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR CONFIG_DATABASE_URI =
postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:28.615+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:29.444+0000 [APP/PROC/WEB/0] STDERR usage: gunicorn [OPTIONS]
[APP_MODULE]
2024-11-05T13:06:29.444+0000 [APP/PROC/WEB/0] STDERR gunicorn: error: argument
-t/--timeout: invalid int value: ''
2024-11-05T13:06:29.470+0000 [APP/PROC/WEB/0] STDOUT Exit status 2
2024-11-05T13:06:34.753+0000 [CELL/0] STDOUT Cell
94d64bda-edc0-47e4-93e3-17ee64c920e3 stopping instance
a6cd6b7a-14a6-4bc9-44d6-93b0
2024-11-05T13:06:34.753+0000 [CELL/0] STDOUT Cell
94d64bda-edc0-47e4-93e3-17ee64c920e3 destroying container for instance
a6cd6b7a-14a6-4bc9-44d6-93b0
2024-11-05T13:06:34.760+0000 [API/14] STDOUT Process has crashed with type:
"web"
2024-11-05T13:06:34.780+0000 [API/14] STDOUT App instance exited with guid
24c881e1-70f1-4c36-874c-641f1255ab38 payload:
{"instance"=>"a6cd6b7a-14a6-4bc9-44d6-93b0", "index"=>0,
"cell_id"=>"94d64bda-edc0-47e4-93e3-17ee64c920e3", "reason"=>"CRASHED",
"exit_description"=>"APP/PROC/WEB: Exited with status 2", "crash_count"=>2,
"crash_timestamp"=>1730811994733846876,
"version"=>"9118506d-b996-4f8d-8750-98d72c67ad3f"}
2024-11-05T13:06:34.792+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 creating container for instance
c1c18b72-9381-4e86-5640-9bfe
2024-11-05T13:06:35.636+0000 [CELL/0] STDOUT Security group rules were updated
2024-11-05T13:06:35.700+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 successfully created container for
instance c1c18b72-9381-4e86-5640-9bfe
2024-11-05T13:06:35.809+0000 [PROXY/0] STDOUT Exit status 137
2024-11-05T13:06:36.078+0000 [CELL/0] STDOUT Cell
94d64bda-edc0-47e4-93e3-17ee64c920e3 successfully destroyed container for
instance a6cd6b7a-14a6-4bc9-44d6-93b0
2024-11-05T13:06:36.355+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1
2024-11-05T13:06:36.355+0000 [APP/PROC/WEB/0] STDERR from
check_external_config_db import check_external_config_db; val =
check_external_config_db(postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx);
print(val)
2024-11-05T13:06:36.355+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:36.355+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:36.591+0000 [APP/PROC/WEB/0] STDERR postfix/postlog: starting
the Postfix mail system
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR Traceback (most recent
call last):
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR File "<string>", line 1,
in <module>
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config.py", line 951, in <module>
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR from
pgadmin.evaluate_config import evaluate_and_patch_config
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/pgadmin/evaluate_config.py", line 50, in <module>
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR import config_distro
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR File
"/pgadmin4/config_distro.py", line 13
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR CONFIG_DATABASE_URI =
postgres://xxxxxxxxxxxxx:ff855340a50467bb21eb...@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR ^
2024-11-05T13:06:41.139+0000 [APP/PROC/WEB/0] STDERR SyntaxError: invalid
decimal literal
2024-11-05T13:06:42.014+0000 [APP/PROC/WEB/0] STDERR usage: gunicorn [OPTIONS]
[APP_MODULE]
2024-11-05T13:06:42.014+0000 [APP/PROC/WEB/0] STDERR gunicorn: error: argument
-t/--timeout: invalid int value: ''
2024-11-05T13:06:42.039+0000 [APP/PROC/WEB/0] STDOUT Exit status 2
2024-11-05T13:06:47.474+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 stopping instance
c1c18b72-9381-4e86-5640-9bfe
2024-11-05T13:06:47.474+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 destroying container for instance
c1c18b72-9381-4e86-5640-9bfe
2024-11-05T13:06:47.487+0000 [API/4] STDOUT Process has crashed with type: "web"
2024-11-05T13:06:47.500+0000 [API/4] STDOUT App instance exited with guid
24c881e1-70f1-4c36-874c-641f1255ab38 payload:
{"instance"=>"c1c18b72-9381-4e86-5640-9bfe", "index"=>0,
"cell_id"=>"160906dd-6149-4a92-82a9-b85b52f60865", "reason"=>"CRASHED",
"exit_description"=>"APP/PROC/WEB: Exited with status 2", "crash_count"=>3,
"crash_timestamp"=>1730812007468799613,
"version"=>"9118506d-b996-4f8d-8750-98d72c67ad3f"}
2024-11-05T13:06:47.584+0000 [PROXY/0] STDOUT Exit status 137
2024-11-05T13:06:48.739+0000 [CELL/0] STDOUT Cell
160906dd-6149-4a92-82a9-b85b52f60865 successfully destroyed container for
instance c1c18b72-9381-4e86-5640-9bfe
