2.8.3 -> 3: migration failing

[fracai]

I was migrating a docker install from 2.8.3. I updated the docker tag to "v3" and missed the migration step to change permissions.
So I first saw errors like:

woodpecker-server-1 | {"level":"error","time":"2025-06-01T02:17:51Z","message":"failed to setup store: could not migrate datastore: migration cron-without-sec failed: attempt to write a readonly database: retry in 1.257729479s"}

A bit of web searching, more closely reading the migration instructions, some chmod-ing, and I tried again.

Now I'm stuck with the following error:
woodpecker-server-1 | {"level":"error","time":"2025-06-01T02:22:00Z","message":"failed to setup store: could not migrate datastore: msg: sync error '*model.Step': disk I/O error: permission denied: retry in 509.570855ms"}

The permissions of my woodpecker directory look fine to me:

drwxrwxr-x  2 1000 1000          4 May 31 22:24 ./
drwxr-xr-x 50 root root         50 May 24 20:43 ../
-rw-rw-r--  1 1000 1000 2904965120 May 31 21:51 woodpecker.sqlite
-rw-rw-r--  1 1000 1000   14340096 Aug  2  2022 woodpecker.sqlite.bak2

Anyone have any tips?
Worst case I suppose I can wipe the database and start over. Though I'd prefer not to if possible.

Thanks for your help.

[fracai]

Whelp… for better or worse I got things working.
I started viewing the database dump and mucking around.
First, I deleted all rows from log_entries, because it was inflating the database to something like 2GB.
Then I saw the steps table and decided to delete those rows.
After that, I was able to start the server without issue.
I'm sure I'm in uncharted waters here, but at least things are running.
If anything goes wrong at this point I'll probably start over from scratch, but so far everything looks OK.

[qwerty287]

Duplicate of #4760