View Single Post
  #1   (View Single Post)  
Old 7th October 2020
PingPing's Avatar
PingPing PingPing is offline
Real Name: Hammond
Port Guard
 
Join Date: Jan 2015
Location: United Kingdom
Posts: 14
Default MariaDB install failing

I'm trying to install MariaDB on my Raspberry Pi 3 Model B which is running OpenBSD 6.7 (ie. aarch64).

I've set out the error message below, but I've never used MariaDB (or MySQL) before so I'm pretty clueless as to what is going on and how (if?) the problem, reported below, can be fixed.

I've successfully installed MariaDB on an i386 machine I have running 6.7, but it seems the above aarch64 port doesn't like me.

Any help is appreciated.
Cheers

Code:
# /usr/local/bin/mysql_install_db --verbose      
Installing MariaDB/MySQL system tables in '/var/mysql' ...
2020-10-05  2:48:14 0 [Note] /usr/local/libexec/mysqld (mysqld 10.4.13-MariaDB) starting as process 85450 ...
2020-10-05  2:48:15 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-10-05  2:48:15 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-05  2:48:15 0 [Note] InnoDB: Uses event mutexes
2020-10-05  2:48:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-10-05  2:48:15 0 [Note] InnoDB: Number of pools: 1
2020-10-05  2:48:15 0 [Note] InnoDB: Using generic crc32 instructions
2020-10-05  2:48:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-05  2:48:15 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-05  2:48:15 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-05  2:48:25 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2020-10-05  2:48:25 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2020-10-05  2:48:38 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
Illegal instruction 

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

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

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

You can also try to start the mysqld daemon with:

    shell> /usr/local/libexec/mysqld --skip-grant-tables --general-log &

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

    shell> /usr/local/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/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
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

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