Silent crash when initializing a PDO connection to PostgreSQL

[tristanjahier]

Silent crash when initializing a PDO connection to PostgreSQL

[tristanjahier]

Thank you for your detailed answer @bobthecow! Unfortunately, I think that playing with process forks is a bit out of my skill set. :(

However, if I ever come to spend time on this problem again, I will open an issue or a PR on PsySH's repository.

[mfn]

Works for me:

# ./artisan tinker
Psy Shell v0.12.3 (PHP 8.3.4 — cli) by Justin Hileman
> $pdo = new PDO('pgsql:host=pgsql;port=5432;dbname=db', 'user', 'pass');
= PDO {#8460
    inTransaction: false,
    attributes: {
      CASE: NATURAL,
      ERRMODE: EXCEPTION,
      PERSISTENT: false,
      DRIVER_NAME: "pgsql",
      SERVER_INFO: "PID: 226; Client Encoding: UTF8; Is Superuser: on; Session Authorization: db; Date Style: ISO, MDY",
      ORACLE_NULLS: NATURAL,
      CLIENT_VERSION: "13.14",
      SERVER_VERSION: "16.2 (Debian 16.2-1.pgdg120+2)",
      STATEMENT_CLASS: [
        "PDOStatement",
      ],
      EMULATE_PREPARES: false,
      CONNECTION_STATUS: "Connection OK; waiting to send.",
      STRINGIFY_FETCHES: false,
      DEFAULT_FETCH_MODE: BOTH,
    },
  }

pgsql 16 in a docker container, not homebrew

[driesvints]

Thanks @mfn

[bobthecow]

@tristanjahier if you run tinker with the -vvv flag do you get more information?

[tristanjahier]

@tristanjahier if you run tinker with the -vvv flag do you get more information?

I get this output in gray:

return $pdo = new PDO('pgsql:host=127.0.0.1;port=5432;dbname=toto', 'myusername', 'mypassword');

and nothing else.

If the PostgreSQL server is offline, I simply get a normal error when constructing the PDO instance:

PDOException SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?

[bobthecow]

if you disable process forking (i.e. add 'usePcntl' => false to your PsySH config) does it work?

[tristanjahier]

Turning this feature off makes things work again. 🙂👍🏻 Thank you a lot!

I had no problem on my previous computer (with the same PsySH config). The PCNTL extension is enabled. What does it tell? Do I miss a library?

[bobthecow]

you have reached a fork in the road. you can dig in, to figure out why it's failing, or you can take the win and walk away :P

if it works with process forking off, and doesn't work with it on, it's probably not a missing library. in the past issues like this have been due to bugs in php extensions, linked libraries, or PHP bindings to libraries.

the next step is probably to come up with the smallest piece of code that can reproduce it. i'd guess it's probably something like:

1. open a Postgres PDO connection
2. fork
3. (maybe) use your connection to make a query?