Cannot understand migration error reasons about pgloader HOT 8 CLOSED

The start of the stacktrace seems to be missing, and the error message.

from pgloader.

Oops....

I think i found reason, it's my carelessness.

df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.7G 0 7.7G 0% /dev
tmpfs 7.7G 1.1M 7.7G 1% /dev/shm
tmpfs 7.7G 362M 7.4G 5% /run
tmpfs 7.7G 0 7.7G 0% /sys/fs/cgroup
/dev/sda1 120G 11G 109G 10% /
/dev/sda3 3.9G 881M 2.8G 24% /boot
/dev/sdb1 549G 521G 65M 100% /data
tmpfs 1.6G 0 1.6G 0% /run/user/1000

I'm sorry.

from pgloader.

The start of the stacktrace seems to be missing, and the error message.

Please explain what it might look like? I will posting more full report in future.

from pgloader.

Ah, you may notice that the lines you showed start with 8:, 9:, etc. Each of these presents a stack frame. There are 8 frames on top of those shown. The output should also usually start with a description of the error, such as »error STORAGE-CONDITION signalled. [Condition of type STORAGE-CONDITION]«.

from pgloader.

Many thanks! )

from pgloader.

Damn, another error...

Couldn't write to #<SB-SYS:FD-STREAM for "socket, peer: /var/lib/mysql/mysql.sock" {1028B0ADA3}>:
Broken pipe

Will try to use TCP instead of unix sockets

from pgloader.

Damn, another error (

From console:

`
Heap exhausted during garbage collection: 640 bytes available, 2112 requested.
Immobile Object Counts
Gen layout fdefn symbol code Boxed Cons Raw Code SmMix Mixed LgRaw LgCode LgMix Waste% Alloc Trig Dirty GCs Mem-age
1 0 0 0 0 530 4 6671 0 0 15 0 0 0 1.3 233410960 143313498 7220 1 1.3589
2 0 0 0 0 860 1 7697 0 0 6 0 0 0 1.3 276994448 10737418 8410 0 0.6591
3 0 0 0 0 764 2 6117 0 1 13 0 0 0 1.1 223513840 10737418 6460 0 0.2350
4 0 0 2 0 149 4 629 0 1 14 0 0 0 1.0 25842032 10737418 630 0 0.0000
5 48 0 0 70 394 27 1730 1 7 41 0 0 4300 2.0 208818064 219555482 1780 29 0.0000
fatal error encountered in SBCL pid 856986 tid 856998:
GC invariant lost, file "gencgc.c", line 522

Welcome to LDB, a low-level debugger for the Lisp runtime environment.
(GC in progress, oldspace=1, newspace=2)
ldb>
`

No errors in pgloader.log file.

Last records:

2023-09-16T13:40:11.026301+01:00 NOTICE COPY public.history_uint with 2318469921 rows estimated [3/4] 2023-09-16T13:40:11.035301+01:00 NOTICE COPY public.history with 747700580 rows estimated [1/4] 2023-09-16T20:21:37.475199+01:00 NOTICE COPY public.trends with 59719160 rows estimated [1/4] 2023-09-16T21:05:40.778050+01:00 NOTICE COPY public.auditlog with 19082647 rows estimated [1/4]

I don't understand what i need to do to fix it...
Console error and "ldb>" prompt give no direction how to continue migration process.

Can anybody assist to make this problem more... clear?

Thank you!

from pgloader.

Found: #962

Will try to use "with prefetch rows = 10000"

from pgloader.