postgresql not crushing after increasing volume
chemiadel
HOBBYOP

2 years ago

after increasing the volume and successfully deploy, i'm receiving this error when trying to connect

2024-09-14 02:16:17.932 UTC [5] LOG:  starting PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

2024-09-14 02:16:17.932 UTC [5] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2024-09-14 02:16:17.932 UTC [5] LOG:  listening on IPv6 address "::", port 5432

2024-09-14 02:16:17.937 UTC [5] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2024-09-14 02:16:17.944 UTC [28] LOG:  database system was interrupted; last known up at 2024-09-14 02:00:14 UTC

2024-09-14 02:16:17.990 UTC [28] LOG:  database system was not properly shut down; automatic recovery in progress

2024-09-14 02:16:17.993 UTC [28] LOG:  redo starts at 0/1418EAE0

2024-09-14 02:16:17.993 UTC [28] LOG:  invalid record length at 0/1418EB18: expected at least 24, got 0

2024-09-14 02:16:17.993 UTC [28] LOG:  redo done at 0/1418EAE0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s

project/694a1186-3c22-49fe-a25d-eacbfc6592d8

volume/ea87f0aa-352a-4443-84e4-cb208a52dc40

service/cadb89f1-9ce8-4d98-93bf-f53d2018a1eb

20 Replies

2 years ago

what error? there are no errors there


chemiadel
HOBBYOP

2 years ago

updated


2 years ago

nothing there is an error


chemiadel
HOBBYOP

2 years ago

1284341031969624000


2 years ago

thats nothing to worry about


chemiadel
HOBBYOP

2 years ago

i can't connect to it via my app


2 years ago

please provide the error you get


chemiadel
HOBBYOP

2 years ago

1284341236978684000


2 years ago

please provide an actual error


chemiadel
HOBBYOP

2 years ago

database system was not properly shut down; automatic recovery in progress

isn't an error?


2 years ago

it is not


chemiadel
HOBBYOP

2 years ago

okay thanks


2 years ago

i need the error your app is printing


chemiadel
HOBBYOP

2 years ago

if it's a log when database starts then the problem is my app not db

thanks


chemiadel
HOBBYOP

2 years ago

@Brody bro i can't connect it via node-postgresql

error: Unable to connect to the database. Retrying (2)… {"context":"TypeOrmModule","ms":"+3s","stack":["Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string\n at Object.continueSession

it was working fine before rising its volume…..


2 years ago

you are likely using the postgres client incorrectly, please reference its docs for syntax


chemiadel
HOBBYOP

2 years ago

it's the same settings bro, i'm connecting string connection without issue in dbeaver and pgadmin.

but not working with typeorm or node-pg


chemiadel
HOBBYOP

2 years ago

problem sovled, thanks


2 years ago

what was the issue?


chemiadel
HOBBYOP

2 years ago

i was using vpn


Loading...