Mysql error after Debian update

  • READ ME AND USE THIS TEMPLATE IF YOU WANT TO GET HELP ! You may ask your question in english or french, whichever is easiest for you… But please use one of the templates provided below :wink:

:uk:/:us: Message template (english)

The “support” category is meant to ask for help or troubleshooting related to installing or using YunoHost or its applications. It is not to ask assistance on general system administration, network administration or special use cases that goes beyond the scope of the project. If you wish to discuss more advanced use case, please post in the “Advanced Use Case” category.

My YunoHost server

Hello! I’m having problems with my Lenovo ThinkCentre. I ran an update this morning and I’m now having issues with mysql and postgresql neither will run, even after restarting the service and rebooting.

My Yunohost is the most unto date version 11.2.10.3 I am able to ssh and access via the web page.

I updated the Debian updates when I checked the system this morning, an hour or so later Mastodon and Peertube went down.

Here are some error messages


-- Journal begins at Sat 2024-03-23 09:16:20 GMT, ends at Sat 2024-03-23 15:26:25 GMT. --
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Uses event mutexes
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Number of pools: 1
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Using Linux native AIO
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Completed initialization of buffer pool
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: 128 rollback segments are active.
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: FTS optimize thread exiting.
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Starting shutdown...
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [Note] Plugin 'FEEDBACK' is disabled.
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Mar 23 15:18:28 mariadbd[7301]: 2024-03-23 15:18:28 0 [ERROR] Aborting
Mar 23 15:18:28 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 23 15:18:28 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 23 15:18:28 systemd[1]: Failed to start MariaDB 10.5.23 database server.
Mar 23 15:26:11 systemd[1]: Starting MariaDB 10.5.23 database server...
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] Starting MariaDB 10.5.23-MariaDB-0+deb11u1 source revision 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb as process 11128
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Uses event mutexes
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Number of pools: 1
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Using Linux native AIO
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Completed initialization of buffer pool
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: 128 rollback segments are active.
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: FTS optimize thread exiting.
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Starting shutdown...
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [Note] Plugin 'FEEDBACK' is disabled.
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Mar 23 15:26:11 mariadbd[11128]: 2024-03-23 15:26:11 0 [ERROR] Aborting
Mar 23 15:26:11 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 23 15:26:11 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 23 15:26:11 systemd[1]: Failed to start MariaDB 10.5.23 database server.

Can you check that your system still does have a reasonable amount of available free space ?

1 Like

Ah thanks, I didn’t realise that Nextcloud files weren’t fully deleting!

Many thanks

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.