failed to migrate 2022-11-15-1-correct-hit-stats about goatcounter HOT 7 CLOSED

I can't really reproduce the failing 2022-11-15-1-correct-hit-stats migration; this always works for me, no matter what I try. "Killed" is a rather odd message 🤔 Maybe the system is killing the migration for some reason?

The error you get in the UI is not related to that though; in f9bd099 I removed all "2.0 migrations" and it seems I also accidentally removed a 2.1 migration with that (2021-03-29-1-widgets).

Running migrations from 2.2 and then 2.4 seems to work.

from goatcounter.

Looks like our replies crossed.

I downgraded to v2.3.0, reset my db folder from the backup (google drive link), ran the migrations and now it works!

2.3.0 should be fine too; this should fix the "v2.4.0 and v2.4.1 don't serve a homepage on my database with error interface {} is nil, not a string." problem.

As for the other: maybe check the shell limits? OOM killer? dmesg? That's where I would start anyway; the message "Killed" makes me suspect it's something outside of GoatCounter killing it (also: check the return code: $?).

Or I can send you a fixed database if you want, since it works on my system.

from goatcounter.

This one should work for 2.4.1 (only tested public dashboard, not logging in): https://user.fm/files/v2-d47d3be3ceaf18d3f38fbaba7abaac66/goatcounter.sqlite3.gz

Make sure you remove or move the -shm and -wal files belonging to the old database.

from goatcounter.

I downgraded to v2.4.0 (to avoid the failing migration introduced in v2.4.1), reset my db folder from the backup (google drive link), ran the migrations and it still fails with "16r5jg1" and "interface {} is nil, not a string".

Was this fixed by 5cbc382, but not included in a release? I ran into #526 and I am trying to update :)

from goatcounter.

I downgraded to v2.3.0, reset my db folder from the backup (google drive link), ran the migrations and now it works! https://stats.plutojl.org/

So I suppose my issue is:

• The 2022-11-15-1-correct-hit-stats migration does not work (on my database, see gdrive link).
• v2.4.0 and v2.4.1 don't serve a homepage on my database with error interface {} is nil, not a string.

from goatcounter.

Oooh a fixed database would be awesome! Since this is a one-time thing I am just happy to get it running :)

It might be memory-related, I was running the migrations on the server that I use for goatcounter, which only has 1GB ram.

from goatcounter.

It works, awesome, thanks!

from goatcounter.