Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Impossible to run when I use PGPool #1327

Open
TheDevilDan opened this issue May 6, 2024 · 0 comments
Open

Impossible to run when I use PGPool #1327

TheDevilDan opened this issue May 6, 2024 · 0 comments

Comments

@TheDevilDan
Copy link

Hi,

When I connect martin to a postgres directly (in kubernetes, in pods) it is OK but, when i connect to a pgpool2 service, it is not working, i don't know why, i try all options but nothing works :'(

Here logs of martin :

[2024-05-06T12:28:31Z INFO  martin] Starting Martin v0.13.0
[2024-05-06T12:28:31Z INFO  martin] Using /files/martin.config
[2024-05-06T12:28:31Z INFO  martin::config] Initializing main cache with maximum size 8589934592B
[2024-05-06T12:28:31Z INFO  martin::pg::pool] Connecting with SSL support: Config { user: Some("myuser"), password: Some(_), dbname: Some("mydb"), options: None, application_name: None, ssl_mode: Prefer, host: [Tcp("postgres-service")], hostaddr: [], port: [5432], connect_timeout: None, tcp_user_timeout: None, keepalives: true, keepalives_idle: 7200s, keepalives_interval: None, keepalives_retries: None, target_session_attrs: Any, channel_binding: Prefer }
[2024-05-06T12:28:31Z INFO  martin::pg::pool] Connecting with SSL support: Config { user: Some("myuser2"), password: Some(_), dbname: Some("mydb2"), options: None, application_name: None, ssl_mode: Prefer, host: [Tcp("postgres-service")], hostaddr: [], port: [5432], connect_timeout: None, tcp_user_timeout: None, keepalives: true, keepalives_idle: 7200s, keepalives_interval: None, keepalives_retries: None, target_session_attrs: Any, channel_binding: Prefer }
[2024-05-06T12:28:31Z ERROR martin] Unable to get a Postgres connection from the pool mydb: Error occurred while creating a new object: unexpected message from server

and log from pgpool2 :

2024-05-06 14:35:15.596: [unknown] pid 1073: LOG:  pool_ssl: "SSL_read": "unexpected eof while reading"
2024-05-06 14:35:15.597: child pid 1133: WARNING:  ssl read: error: 5
2024-05-06 14:35:15.597: child pid 1133: ERROR:  unable to read data from frontend
2024-05-06 14:35:15.597: child pid 1133: DETAIL:  socket read failed with error "No error information"
2024-05-06 14:35:15.597: [unknown] pid 1073: ERROR:  unable to read data from frontend
2024-05-06 14:35:15.597: [unknown] pid 1073: DETAIL:  socket read failed with error "No error information"
2024-05-06 14:35:17.330: [unknown] pid 1073: LOG:  pool_ssl: "SSL_read": "unexpected eof while reading"
2024-05-06 14:35:17.331: [unknown] pid 1073: ERROR:  unable to read data from frontend
2024-05-06 14:35:17.331: [unknown] pid 1073: DETAIL:  socket read failed with error "No error information"
2024-05-06 14:35:17.333: child pid 1106: LOG:  pool_ssl: "SSL_read": "unexpected eof while reading"
2024-05-06 14:35:17.334: child pid 1106: ERROR:  unable to read data from frontend
2024-05-06 14:35:17.334: child pid 1106: DETAIL:  socket read failed with error "No error information"

Do you have the same problem with PGPool2 ? I forget something ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant