maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "News and Information" by stuart_zurcher_g. Please answer it at http://mariadb.com/kb/en/mariadb-10112-mysql_install_db-aborts-on-unkown-file-test/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
using Docker container with -v /data:/var/lib/mysql  \\
xtrabackup-v2 (2.4) 999:docker /data \\
chown mysql:mysql /var/lib/mysql\\

Initializing\\
{{{
2016-03-11 13:59:18 139887411787712 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 54 ...
2016-03-11 13:59:18 139887411787712 [Note] WSREP: Read nil XID from storage engines, skipping position init
2016-03-11 13:59:18 139887411787712 [Note] WSREP: wsrep_load(): loading provider library 'none'
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Memory barrier is not used
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using Linux native AIO
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using SSE crc32 instructions
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Initializing buffer pool, size = 400.0M
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Completed initialization of buffer pool
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Database physically writes the file full: wait...
2016-03-11 13:59:19 139887411787712 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-03-11 13:59:25 139887411787712 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-03-11 13:59:27 139887411787712 [Warning] InnoDB: New log files created, LSN=45883
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Doublewrite buffer created
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-11 13:59:27 139887411787712 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Foreign key constraint system tables created
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Tablespace and datafile system tables created.
2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Waiting for purge to start
2016-03-11 13:59:27 139887411787712 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 0
2016-03-11 13:59:27 139886535374592 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-03-11 13:59:27 139887411550976 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2016-03-11 13:59:31 139640839899072 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 83 ...
2016-03-11 13:59:31 139640839899072 [Note] WSREP: Read nil XID from storage engines, skipping position init
2016-03-11 13:59:31 139640839899072 [Note] WSREP: wsrep_load(): loading provider library 'none'
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Memory barrier is not used
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using Linux native AIO
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using SSE crc32 instructions
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Initializing buffer pool, size = 400.0M
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Completed initialization of buffer pool
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Waiting for purge to start
2016-03-11 13:59:31 139640839899072 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616799
2016-03-11 13:59:31 139639968990976 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-03-11 13:59:34 140650620151744 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 113 ...
2016-03-11 13:59:34 140650620151744 [Note] WSREP: Read nil XID from storage engines, skipping position init
2016-03-11 13:59:34 140650620151744 [Note] WSREP: wsrep_load(): loading provider library 'none'
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Memory barrier is not used
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using Linux native AIO
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using SSE crc32 instructions
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Initializing buffer pool, size = 400.0M
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Completed initialization of buffer pool
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Waiting for purge to start
2016-03-11 13:59:35 140650620151744 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616809
2016-03-11 13:59:35 140649751873280 [Note] InnoDB: Dumping buffer pool(s) not yet started
ERROR: 1049  Unknown database 'test'
2016-03-11 13:59:35 140650620151744 [ERROR] Aborting
}}}
\\
**my.cnf**
{{{
mysqld]
#
# * Basic Settings
#
skip-host-cache
skip-name-resolve
bind-address   			= 0.0.0.0
port					= 3306
# basedir					= /usr
datadir					= /var/lib/mysql
tmpdir					= /tmp
socket					=/var/run/mysqld/mysqld.sock
user					= mysql
lc_messages_dir			= /usr/share/mysql
lc_messages				= en_US
skip-external-locking
#
#  * Fine Tuning
#
max_connections			= 100
connect_timeout			= 5
wait_timeout			= 600
max_allowed_packet		= 16M
thread_cache_size   	= 128
sort_buffer_size		= 4M
bulk_insert_buffer_size	= 16M
tmp_table_size			= 32M
max_heap_table_size		= 32M
#
# * MyISAM
#
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched. On error, make copy and try a repair.
myisam_recover_options 	= BACKUP
key_buffer_size			= 128M
#open-files-limit		= 2000
table_open_cache		= 400
myisam_sort_buffer_size	= 512M
concurrent_insert		= 2
read_buffer_size		= 2M
read_rnd_buffer_size	= 1M

# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# we do want to know about network errors and such
log-error	=/dev/stderr
log_warnings		= 3
#
# Enable the slow query log to see queries with especially long duration
#slow_query_log[={0|1}]
slow_query_log_file		= /var/log/mysql/mariadb-slow.log
long_query_time 		= 10
expire_logs_days		= 10
max_binlog_size     	= 100M

# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
default_storage_engine	= InnoDB
innodb_log_file_size	= 48M
innodb_log_buffer_size	= 8M
innodb_file_per_table	= 1
innodb_buffer_pool_size	= 400M
innodb_open_files		= 400
innodb_io_capacity		= 400
innodb_flush_method		= O_DIRECT
innodb-doublewrite		=1

innodb-autoinc-lock-mode=2
innodb-flush-log-at-trx-commit=0
innodb_data_file_path	=ibdata1:12M:autoextend

log-bin					=ON
binlog-format			=ROW
wsrep-provider			=/usr/lib/galera/libgalera_smm.so
wsrep-sst-method		=xtrabackup-v2
wsrep_on				=ON 
query-cache-size=0
query_cache_type=0
read_buffer_size=1G
# following to be changed by docker-entrypoint.sh before mysql_install_db
wsrep-node-address=
wsrep-node-name=
wsrep-cluster-name=
wsrep-cluster-address=
wsrep-sst-auth=
wsrep-sst-donor=

# xtrabackup Configuration
[sst]
progress=1
compressor="gzip"
decompressor="gzip -dc"
rebuild=ON
compact=ON
encrypt	=0
}}}
\\
mysql_install_db --user=mysql --datadir="$DATADIR" --rpm

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-10112-mysql_install_db-aborts-on-unkown-file-test/