OJS upgrade to 3.5 index for event_log is corrupt

Software Support
,
1

Describe the issue or problem
During upgrade the last failure is now with the event_log.

Steps I took leading up to the issue
I have run the upgrade several times. I have a “clean” dump to start from. We are on OJS 3.3.0.15 and are upgrading to 3.5. Previous upgrade problems were for example journal contactName + contactEmail missing from some journals, and also that I tried to start upgradeing again without resetting the database to a clean dump. It takes about 12 hours to restore the dump.

Additional information
The last upgrade came a long way, but stopped with:

2026-02-16 00:14:39 [migration: APP\migration\upgrade\v3_4_0\I8933_EventLogLocalized]
2026-02-16 00:15:07 [revert migration: PKP\migration\upgrade\v3_4_0\I9039_DropDeprecatedFields]
2026-02-16 00:15:07 [downgrade for “PKP\migration\upgrade\v3_4_0\I9039_DropDeprecatedFields” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 1034 Index for table ‘event_log’ is corrupt; try to repair it (Connection: mysql, SQL: alter table event_log add constraint event_log_user_id_foreign foreign key (user_id) references users (user_id) on delete cascade)

Any tips to what I can try before starting a new upgrade?

2

Hi @mirkh,

This is a MySQL/MariaDB problem; it’s likely that your index is corrupted before you try to run the upgrade. You might find good advice on e.g. StackOverflow; at a guess, if you drop, recreate, and reload your database from backup, then the corrupted index will be fixed at the same time.

Thanks,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher, yes, sorry I seem to have ignored it was DB related. It seems the error is different at each try. Last try the DB was unavailable and the upgrade crashed. Any tips about settings to increase number of retries or similar?

4

Hi @mirkh,

Hmm, this isn’t something I’ve seen before; I’d be tempted to check your MySQL log to see if something unusual is showing up there (resource constraints, time limits, data errors, etc). If nothing shows up there, and you’re still encountering problems with it every time you try to upgrade, I’d be tempted to download a local copy of the installation, upgrade it there, then upload the results to the server.

Regards,
Alec Smecher
Public Knowledge Project Team