Categories
Database Development

MariaDB crashed: Unknown/unsupported storage engine: InnoDB

I’ve a Debian GNU/Linux 9 (4GB, 2 CPUs) on Digitalocean. Tonight (I’ve done nothing) my DB (mariaDB) crashed with this errors. I ran a wordpress with InnoDB and myISAM tables:

2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: The InnoDB memory heap is disabled
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Using Linux native AIO
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Using SSE crc32 instructions
2020-10-17  0:51:18 140430430813568 [Note] InnoDB: Initializing buffer pool, size = 500.0M
InnoDB: mmap(549126144 bytes) failed; errno 12
2020-10-17  0:51:18 140430430813568 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-10-17  0:51:18 140430430813568 [ERROR] Plugin 'InnoDB' init function returned error.
2020-10-17  0:51:18 140430430813568 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-10-17  0:51:18 140430430813568 [Note] Plugin 'FEEDBACK' is disabled.
2020-10-17  0:51:18 140430430813568 [ERROR] **Unknown/unsupported storage engine: InnoDB**
2020-10-17  0:51:18 140430430813568 [ERROR] Aborting


My DB conf:

#
# * Fine Tuning
#
key_buffer_size         = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam_recover_options  = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10

innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 500M
max_heap_table_size     = 25M
tmp_table_size          = 25M
#log_slow_queries        = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

#
# * Query Cache Configuration
#
query_cache_limit       = 2M
query_cache_size        = 50M
...

I would be happy if you could help me out!!

Thanks a lot
M

Leave a Reply

Your email address will not be published. Required fields are marked *