🐛 Bug Report: When i try to start appwrite in docket. Error in Starting MariaDB

[anandsubbu007]

👟 Reproduction steps

👍 Expected behavior

2022-03-24  4:30:03 0 [Note] mysqld (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 1 ...

2022-03-24  4:30:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2022-03-24  4:30:03 0 [Note] InnoDB: Number of transaction pools: 1

2022-03-24  4:30:03 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2022-03-24  4:30:03 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)

2022-03-24  4:30:03 0 [Note] InnoDB: Using Linux native AIO

2022-03-24  4:30:03 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-03-24  4:30:03 0 [Note] InnoDB: Completed initialization of buffer pool

2022-03-24  4:30:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11005585,19628422

2022-03-24  4:30:04 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 175

2022-03-24  4:30:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption

2022-03-24  4:30:04 0 [Note] InnoDB: Starting shutdown...

2022-03-24  4:30:04 0 [ERROR] Plugin 'InnoDB' init function returned error.

2022-03-24  4:30:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2022-03-24  4:30:04 0 [Note] Plugin 'FEEDBACK' is disabled.

2022-03-24  4:30:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB

2022-03-24  4:30:04 0 [ERROR] Aborting

👎 Actual Behavior

🎲 Appwrite version

Version 0.13.x

💻 Operating system

Windows

🧱 Your Environment

Windows 10
Using Docker

👀 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

[eldadfux]

Seems similar to this issue: MariaDB/mariadb-docker#267 (comment)
I would also try to delete the container and recreate it.

[anandsubbu007]

After remove & reinstall appwrite no issue found

[anandsubbu007]

[Note] InnoDB: Using Linux native AIO

2022-04-02 10:25:27 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-04-02 10:25:27 0 [Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: Starting crash recovery from checkpoint LSN=203245363,211323491

2022-04-02 10:25:28 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 687

2022-04-02 10:25:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption

2022-04-02 10:25:28 0 [Note] InnoDB: Starting shutdown...

again this is happening...

where can i find this File

rm /var/lib/mysql/ib_logfile0
in Windows

[AsierraDEV]

[Note] InnoDB: Using Linux native AIO

2022-04-02 10:25:27 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-04-02 10:25:27 0 [Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: Starting crash recovery from checkpoint LSN=203245363,211323491

2022-04-02 10:25:28 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 687

2022-04-02 10:25:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption

2022-04-02 10:25:28 0 [Note] InnoDB: Starting shutdown...

again this is happening...

where can i find this File

rm /var/lib/mysql/ib_logfile0
in Windows

If you are using WSL2, try this path

\\wsl$\docker-desktop-data\version-pack-data\community\docker\volumes

[MooseSaeed]

I'm facing the same issue and nothing at all seems to work. I uninstalled docker completely and reinstalled it again. I also remove appwrite and reinstalled it. nothing works. Any suggestions?

[v3ss0n]

its seems to be latest MariaDB bug corrupting InnoDB table. I have this problem too and cannot delete container because data in it

[cybr-dev]

I face the same problem

[stnguyen90]

Can this be closed since there's more info in #3157?

[grooverdan]

For those using WSL - watch out for microsoft/WSL#8443.