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?
- I have read the Code of Conduct
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 2
- Comments: 26 (13 by maintainers)
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.