dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.45k stars 548 forks source link

Disable some functionality #1516

Open T72B opened 1 year ago

T72B commented 1 year ago

Hey, team. I try to migrate data from MySQL to PostgreSQL and meet some errors. In some cases, pgloader is turned on in debugger:

Welcome to LDB, a low-level debugger for the Lisp runtime environment. ldb>

Sometimes I see a running pgloader process, but no transactions run, for example, "Heap exhausted" error:

2023-07-27T18:53:51.790300Z ERROR Error while formatting a row from "testdb.sumlogs": debugger invoked on a SB-KERNEL::HEAP-EXHAUSTED-ERROR in thread

<THREAD "lparallel" RUNNING {10054E82A3}>:

Heap exhausted (no more space for allocation). 262144 bytes available, 262160 requested.

2023-07-27T18:53:51.790678Z ERROR A SB-KERNEL::HEAP-EXHAUSTED-ERROR condition without bindings for heap statistics. (If you did not expect to see this message, please report it. PROCEED WITH CAUTION.

The current thread is not at the foreground, SB-THREAD:RELEASE-FOREGROUND has to be called in #<SB-THREAD:THREAD "main thread" RUNNING {10054E8403}> for this thread to enter the debugger. 2023-07-27T18:53:51.795812Z ERROR The value NIL is not of type NUMBER 2023-07-27T18:53:51.798689Z WARNING PostgreSQL warning: there is no transaction in progress

I need to use Ctrl+C to stop pgloader or kill a process.

Is it possible to disable the debugger and the waiting process? In the end, I'd like to get pgloader that exits during any error and returns an error code or status.