appwrite: πŸ› Bug Report: Innodb and mariadb issue

πŸ‘Ÿ Reproduction steps

Appwrite was working perfectly fine yesterday but today I’m trying to start appwrite with docker but it’s not starting.

When I access appwrite with docker I can see appwrite-mariadb keeps on restarting, so I checked the logs and this is what i found.

2022-04-27 11:36:10 0 [Note] mysqld (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 1 ...

2022-04-27 11:36:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2022-04-27 11:36:10 0 [Note] InnoDB: Number of transaction pools: 1

2022-04-27 11:36:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2022-04-27 11:36:10 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)

2022-04-27 11:36:11 0 [Note] InnoDB: Using Linux native AIO

2022-04-27 11:36:11 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-04-27 11:36:11 0 [Note] InnoDB: Completed initialization of buffer pool

2022-04-27 11:36:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=48808232,51837609

2022-04-27 11:36:11 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 322

2022-04-27 11:36:11 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption

2022-04-27 11:36:11 0 [Note] InnoDB: Starting shutdown...

2022-04-27 11:36:11 0 [ERROR] Plugin 'InnoDB' init function returned error.

2022-04-27 11:36:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2022-04-27 11:36:11 0 [Note] Plugin 'FEEDBACK' is disabled.

2022-04-27 11:36:11 0 [ERROR] Unknown/unsupported storage engine: InnoDB

2022-04-27 11:36:11 0 [ERROR] Aborting

πŸ‘ Expected behavior

appwrite should work normally and I should be able to open the console.

πŸ‘Ž Actual Behavior

Appwrite won’t start and the console is giving me β€˜bad gateway’ response due to that.

mariadb keeps on restarting and i think that’s what causing Appwrite to fail to start.

🎲 Appwrite version

Version 0.13.x

πŸ’» Operating system

Windows

🧱 Your Environment

I’m working with appwrite web SDK installed on windows 10 with docker in a Vue app

πŸ‘€ Have you spent some time to check if this issue has been raised before?

  • I checked and didn’t find similar issue

🏒 Have you read the Code of Conduct?

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Reactions: 2
  • Comments: 26 (13 by maintainers)

Most upvoted comments

Happy to help.

I’d rather an answer be available, compared to an open issue that is outside relm of fixing, where users are left guess on the cause and solution.

Please do copy across to mariadb-docker or JIRA any MariaDB issues that you can’t resolve.

Thank you!

apparently it has something to do with the computer shutting down abruptly. when you turn it back on bingo! you come across this error.