Mattermost, MariaDB, InnoDB

TheGasolineWillBeOurs · 2017-11-09 19:55:00

Hello everyone

I'm trying to get Mattermost with MariaDB to run. I installed MariaDB and - following the Wiki - I want to run

mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

, which returns

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2017-11-09 20:19:36 140457440636864 [Note] /usr/sbin/mysqld (mysqld 10.1.28-MariaDB) starting as process 19698 ...
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: The InnoDB memory heap is disabled
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Using Linux native AIO
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Using SSE crc32 instructions
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Completed initialization of buffer pool
2017-11-09 20:19:36 140457440636864 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: A downgrade from MariaDB 10.2.2 or later is not supported.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
2017-11-09 20:19:36 140457440636864 [ERROR] Plugin 'InnoDB' init function returned error.
2017-11-09 20:19:36 140457440636864 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-11-09 20:19:36 140457440636864 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-11-09 20:19:36 140457440636864 [ERROR] Aborting


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

There are several things ongoing here. It's not clear to me what I should pay the most attention to. Googling for "No valid checkpoint found", gives plenty of hits and suggestions, but none that brought me any further so far. "InnoDB: A downgrade from MariaDB 10.2.2 or later is not supported." is an interesting one. Why downgrade? Does it mean my MariaDB version (mysql Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1) is too old?

At this point though, I rather believe to be barking up the wrong tree. Likely I just have missed a step to set Mattermost. Any help is much appreciated.

cfr · 2017-11-10 00:46:44

TheGasolineWillBeOurs wrote:

InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html

??

TheGasolineWillBeOurs · 2017-11-14 09:59:40

I'm not sure what "??" means, but maybe you want to ask, if I did what's suggested on this website. I did, at least I tried. I tried to locate any files called "ibdata", "ib_logfile", ".frm" or ".ibd", but didn't find any files.

Arch Linux

#1 2017-11-09 19:55:00

Mattermost, MariaDB, InnoDB

#2 2017-11-10 00:46:44

Re: Mattermost, MariaDB, InnoDB

#3 2017-11-14 09:59:40

Re: Mattermost, MariaDB, InnoDB

Board footer