Can't startup Kinsta after interrupted upgrade

Hi,
I’m locked out of DevKinsta, after a probably failed update yesterday. Stopping all services in terminal (Mac) won’t help. I urgently need access to maria db but it fails to start up also repo is greyed out. PANIC!

Here are some logs
2022-09-23 08:22:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 08:22:57+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2022-09-23 08:22:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 08:23:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 08:23:58+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2022-09-23 08:23:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 08:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 08:25:00+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2022-09-23 08:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-09-23 8:23:59 0 [Note] InnoDB: Starting shutdown…
2022-09-23 8:23:59 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2022-09-23 8:23:59 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2022-09-23 8:23:59 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2022-09-23 8:23:59 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-23 8:23:59 0 [ERROR] Aborting
2022-09-23 8:25:00 0 [Note] mysqld (mysqld 10.5.5-MariaDB-1:10.5.5+maria~focal) starting as process 1 …
2022-09-23 8:25:00 0 [Note] InnoDB: Using Linux native AIO
2022-09-23 8:25:00 0 [Note] InnoDB: Uses event mutexes
2022-09-23 8:25:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 8:25:00 0 [Note] InnoDB: Number of pools: 1
2022-09-23 8:25:00 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2022-09-23 8:25:00 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-09-23 8:25:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-09-23 8:25:00 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 8:25:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-09-23 8:25:00 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 587095623 between the checkpoint 587095623 and the end 587095552.
2022-09-23 8:25:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-09-23 8:25:00 0 [Note] InnoDB: Starting shutdown…
2022-09-23 8:25:01 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2022-09-23 8:25:01 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2022-09-23 8:25:01 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2022-09-23 8:25:01 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-23 8:25:01 0 [ERROR] Aborting

Hi @Johannes, thanks for reaching out. Was this after a failed update of DevKinsta? Are you able to use Time Machine to restore Docker? I’m not sure if you have that configured in your Docker settings.

Assuming the issue is similar to this: linux - mysqld fails to start due to InnoDB - Server Fault then the solution listed there and here might fix the issue.

I can’t reproduce this error so all I can do is provide ideas. My best guess is that you will need to make this change in the devkinsta_db_data Volume. These instructions for Mac might help: Getting path and accessing persistent volumes in Docker for Mac ⚡ | TimOnWeb

On Windows, I can reach the directory with the logfiles by navigating here:
\\wsl$\docker-desktop-data\data\docker\volumes\devkinsta_db_data\_data

The Mac path should be somewhat similar. The solution should be renaming or deleting the ib_logfile file. I recommend making a backup of it if deleting.

Thanks Kevin, I think I’ll start off with the database recovery (delete log) before I’ll go on and try to restore docker through time macjine. I’ll let you know where it led to.

Thank you!

1 Like