too many connections, Segmentation fault

[Thykof]

• [x] pgloader --version

pgloader version "3.6.2"
compiled with SBCL 2.0.1.debian

• [x] did you test a fresh compile from the source tree?

yes

• [x] did you search for other similar issues?

yes

• [x] how can I reproduce the bug?

I have removed credentials here.

    FROM mysql://:@.com:/bdd
    INTO postgresql://:@.com:/b

WITH include drop, create tables, create indexes

decoding table names matching ~/messed/, ~/encoding/ AS utf8

ALTER TABLE NAMES MATCHING ~/./  SET SCHEMA 'public';

• [x] pgloader output you obtain

I have removed credentials here.

2021-11-27T18:09:39.010000Z LOG pgloader version "3.6.2"
2021-11-27T18:09:39.334000Z LOG Migrating from #<MYSQL-CONNECTION mysql://@:21145/b {10084CF863}>
2021-11-27T18:09:39.334000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://@:5432/b {10084D2633}>
2021-11-27T18:09:45.506000Z ERROR Failed to connect to #<PGSQL-CONNECTION pgsql://@:5432/b {100E15A4E3}>: Database error 53300: too many connections for role ""; will try again in 0.5s
2021-11-27T18:09:45.872000Z ERROR Failed to connect to #<PGSQL-CONNECTION pgsql://@:5432/b {100E15EA63}>: Database error 53300: too many connections for role ""; will try again in 0.5s
free(): double free detected in tcache 2
Segmentation fault

The problem is only when the database respond with an error too many connections.

• [ ] data that is being loaded, if relevant
• [ ] How the data is different from what you expected, if relevant

[lunaluxie]

Hi, I know it's an old issue, but I am running into the same problem. I'm migrating to a Postgres database which has a strict limit to the number of simultaneous connections. Is there a way to limit the number of connections pgloader uses?