0k
/
0k-charms
6
3
Fork 2
Code Issues 11 Pull Requests 6 Releases Wiki Activity
Labels Milestones
New Issue

[postgresql] timeout with large `compose.yml` #9

Open
opened 4 years ago by njeudy · 1 comments
njeudy commented 4 years ago 
pwd: /var/lib/compose/root/myc-deploy
 code:
  | _run_service_relation "postgres-database" "odoo_v14" "postgres" "$relation_config"
 output (1):
  ! Running postgres-database relation-joined script for target postgres (charm postgres)
  ! postgres/postgres-database (joined) @> Error in wrapped command:
  ! postgres/postgres-database (joined) @>  pwd: /srv/charm-store/postgres
  ! postgres/postgres-database (joined) @>  code:
  ! postgres/postgres-database (joined) @>   | /bin/bash /dev/fd/60 
  ! postgres/postgres-database (joined) @>  output (1):
  ! postgres/postgres-database (joined) @>   ! Database is not locked.
  ! postgres/postgres-database (joined) @>   ! docker network create db_postgres_7
  ! postgres/postgres-database (joined) @>   ! docker run -d --name db_postgres_7 --network db_postgres_7 -v /srv/datastore/data/postgres/var/lib/postgresql/data:/var/lib/postgresql/data myc_postgres
  ! postgres/postgres-database (joined) @>   ! Found docker 32b91e80959c5b5be15a5e69fd3257052b1453e3baa8a96f50d45012e0e59d23 network and IP: db_postgres_7:172.20.0.2
  ! postgres/postgres-database (joined) @>   ! Trying to connect to 172.20.0.2:5432
  ! postgres/postgres-database (joined) @>   ! docker run --rm -i --network db_postgres_7 docker.0k.io/bash
  ! postgres/postgres-database (joined) @>   ! II Host/Port 172.20.0.2:5432 checked open.
  ! postgres/postgres-database (joined) @>   ! Got 'database system is starting up' error.
  ! postgres/postgres-database (joined) @>   ! Got 'database system is starting up' error.
  ! postgres/postgres-database (joined) @>   ! Got 'database system is starting up' error.
  ! postgres/postgres-database (joined) @>   ! Got 'database system is starting up' error.
  ! postgres/postgres-database (joined) @>   ! Error: db connection error: Could not connect to db on 172.20.0.2 container's IP. (IP up, TCP ports is(are) open, sql answer after 30s)
  ! postgres/postgres-database (joined) @>   ! Error: Db not found (errlvl: 1). Tail of docker logs follows:
  ! postgres/postgres-database (joined) @>   !   | 2021-01-08 15:07:46.735 UTC [22] LOG:  incomplete startup packet
  ! postgres/postgres-database (joined) @>   !   | 2021-01-08 15:07:53.959 UTC [23] FATAL:  the database system is starting up
  ! postgres/postgres-database (joined) @>   !   | 2021-01-08 15:08:02.263 UTC [24] FATAL:  the database system is starting up
  ! postgres/postgres-database (joined) @>   !   | 2021-01-08 15:08:09.953 UTC [25] FATAL:  the database system is starting up
  ! postgres/postgres-database (joined) @>   !   | 2021-01-08 15:08:18.073 UTC [26] FATAL:  the database system is starting up
  ! postgres/postgres-database (joined) @>   ! Removing container db_postgres_7postgres/postgres-database (joined) @> Error: postgres script '/srv/charm-store/postgres/hooks/postgres_database-relation-joined' failed with errorlevel '1'.
  ! 
  ! postgres/postgres-database (joined) @>   | 32b91e80959c5b5be15a5e69fd3257052b1453e3baa8a96f50d45012e0e59d23
  ! postgres/postgres-database (joined) @>   | db_postgres_7
  ! postgres/postgres-database (joined) @>   | db_postgres_7
  ! Error: Relation postgres-database on postgres failed to run properly.
``` pwd: /var/lib/compose/root/myc-deploy code: | _run_service_relation "postgres-database" "odoo_v14" "postgres" "$relation_config" output (1): ! Running postgres-database relation-joined script for target postgres (charm postgres) ! postgres/postgres-database (joined) @> Error in wrapped command: ! postgres/postgres-database (joined) @> pwd: /srv/charm-store/postgres ! postgres/postgres-database (joined) @> code: ! postgres/postgres-database (joined) @> | /bin/bash /dev/fd/60 ! postgres/postgres-database (joined) @> output (1): ! postgres/postgres-database (joined) @> ! Database is not locked. ! postgres/postgres-database (joined) @> ! docker network create db_postgres_7 ! postgres/postgres-database (joined) @> ! docker run -d --name db_postgres_7 --network db_postgres_7 -v /srv/datastore/data/postgres/var/lib/postgresql/data:/var/lib/postgresql/data myc_postgres ! postgres/postgres-database (joined) @> ! Found docker 32b91e80959c5b5be15a5e69fd3257052b1453e3baa8a96f50d45012e0e59d23 network and IP: db_postgres_7:172.20.0.2 ! postgres/postgres-database (joined) @> ! Trying to connect to 172.20.0.2:5432 ! postgres/postgres-database (joined) @> ! docker run --rm -i --network db_postgres_7 docker.0k.io/bash ! postgres/postgres-database (joined) @> ! II Host/Port 172.20.0.2:5432 checked open. ! postgres/postgres-database (joined) @> ! Got 'database system is starting up' error. ! postgres/postgres-database (joined) @> ! Got 'database system is starting up' error. ! postgres/postgres-database (joined) @> ! Got 'database system is starting up' error. ! postgres/postgres-database (joined) @> ! Got 'database system is starting up' error. ! postgres/postgres-database (joined) @> ! Error: db connection error: Could not connect to db on 172.20.0.2 container's IP. (IP up, TCP ports is(are) open, sql answer after 30s) ! postgres/postgres-database (joined) @> ! Error: Db not found (errlvl: 1). Tail of docker logs follows: ! postgres/postgres-database (joined) @> ! | 2021-01-08 15:07:46.735 UTC [22] LOG: incomplete startup packet ! postgres/postgres-database (joined) @> ! | 2021-01-08 15:07:53.959 UTC [23] FATAL: the database system is starting up ! postgres/postgres-database (joined) @> ! | 2021-01-08 15:08:02.263 UTC [24] FATAL: the database system is starting up ! postgres/postgres-database (joined) @> ! | 2021-01-08 15:08:09.953 UTC [25] FATAL: the database system is starting up ! postgres/postgres-database (joined) @> ! | 2021-01-08 15:08:18.073 UTC [26] FATAL: the database system is starting up ! postgres/postgres-database (joined) @> ! Removing container db_postgres_7postgres/postgres-database (joined) @> Error: postgres script '/srv/charm-store/postgres/hooks/postgres_database-relation-joined' failed with errorlevel '1'. ! ! postgres/postgres-database (joined) @> | 32b91e80959c5b5be15a5e69fd3257052b1453e3baa8a96f50d45012e0e59d23 ! postgres/postgres-database (joined) @> | db_postgres_7 ! postgres/postgres-database (joined) @> | db_postgres_7 ! Error: Relation postgres-database on postgres failed to run properly. ```
njeudy commented 4 years ago
Poster

After a compose down, I have this error linked to timeout from postgresql charm.
There are many database on this postgres instance.

After a compose down, I have this error linked to timeout from postgresql charm. There are many database on this postgres instance.
vlab changed title from [postgresql] timeout sur les gros compose :) to [postgresql] timeout with large `compose.yml` 4 years ago
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
0k/dev/master
backup
bgallet/mattermost
bgallet/nextcloud
boris/smtp-extern
charm-codimd-new
cups_service_alpha
dev
dev1
dhcp
element
etherpad-upd
framadate
get-version
lokavaluto/dev/master
master
matomo
new-mailhog-charms
new-monujo-options
nj-collabra-office
nj-keycloak-17.0
nj-organice-charm
nj-vaulwarden-migrate
ntfy-install
odoo_fix_webhook_url
postgres
test
upd-docker
update-latest-synapse
wip
Labels
Apply labels
Clear labels
bug
Something is not working duplicate
This issue or pull request already exists enhancement
New feature help wanted
Need some help invalid
Something is wrong question
More information is needed win wontfix
This won't be fixed
No Label bug duplicate enhancement help wanted invalid question win wontfix
Milestone
Set milestone
Clear milestone
No items
No Milestone
Assignees
Assign users
Clear assignees
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview
Loading…
Cancel
Save
There is no content yet.
Delete Branch '%!s(MISSING)'

Deleting a branch is permanent. It CANNOT be undone. Continue?

No
Yes