MariaDB 10.1

Matt · Nov 20, 2015

eva2000

Just tried the upgrade via Centminmod again on this server

Code:

Loaded plugins: fastestmirror, priorities
Cleaning repos: base elasticsearch-2.x epel extras mariadb rpmforge updates
Cleaning up everything
Cleaning up list of fastest mirrors
rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB

*************************************************
MariaDB 10.1.x check available packages
yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
*************************************************

Installed Packages
MariaDB-client.x86_64               10.0.22-1.el7.centos                @mariadb
MariaDB-common.x86_64               10.0.22-1.el7.centos                @mariadb
MariaDB-compat.x86_64               10.0.22-1.el7.centos                @mariadb
MariaDB-devel.x86_64                10.0.22-1.el7.centos                @mariadb
MariaDB-shared.x86_64               10.0.22-1.el7.centos                @mariadb
Available Packages
MariaDB-client.x86_64               10.1.8-1.el7.centos                 mariadb
MariaDB-common.x86_64               10.1.8-1.el7.centos                 mariadb
MariaDB-compat.x86_64               10.1.8-1.el7.centos                 mariadb
MariaDB-devel.x86_64                10.1.8-1.el7.centos                 mariadb
MariaDB-server.x86_64               10.1.8-1.el7.centos                 mariadb
MariaDB-shared.x86_64               10.1.8-1.el7.centos                 mariadb
mariadb-devel.x86_64                1:5.5.44-1.el7_1                    updates
mariadb-server.x86_64               1:5.5.44-1.el7_1                    updates

real    0m16.760s
user    0m3.296s
sys     0m0.292s

*************************************************
MariaDB 10.1.x YUM install...
yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
*************************************************

Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* base: mirror0.babylon.network
* epel: mirror0.babylon.network
* extras: mirror0.babylon.network
* rpmforge: mirrors.ircam.fr
* updates: mirror0.babylon.network
185 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.22-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.1.8-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.0.22-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.1.8-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.0.22-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.1.8-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.0.22-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.1.8-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.1.8-1.el7.centos will be installed
---> Package MariaDB-shared.x86_64 0:10.0.22-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.1.8-1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package             Arch        Version                     Repository    Size
================================================================================
Installing:
MariaDB-server      x86_64      10.1.8-1.el7.centos         mariadb       98 M
Updating:
MariaDB-client      x86_64      10.1.8-1.el7.centos         mariadb       38 M
MariaDB-common      x86_64      10.1.8-1.el7.centos         mariadb       43 k
MariaDB-compat      x86_64      10.1.8-1.el7.centos         mariadb      1.4 M
MariaDB-devel       x86_64      10.1.8-1.el7.centos         mariadb      6.5 M
MariaDB-shared      x86_64      10.1.8-1.el7.centos         mariadb      1.3 M

Transaction Summary
================================================================================
Install  1 Package
Upgrade  5 Packages

Total download size: 146 M
Downloading packages:
No Presto metadata available for mariadb
--------------------------------------------------------------------------------
Total                                              3.4 MB/s | 146 MB  00:43    
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Updating   : MariaDB-common-10.1.8-1.el7.centos.x86_64                   1/11
  Updating   : MariaDB-client-10.1.8-1.el7.centos.x86_64                   2/11
  Installing : MariaDB-server-10.1.8-1.el7.centos.x86_64                   3/11
  Updating   : MariaDB-devel-10.1.8-1.el7.centos.x86_64                    4/11
  Updating   : MariaDB-shared-10.1.8-1.el7.centos.x86_64                   5/11
  Updating   : MariaDB-compat-10.1.8-1.el7.centos.x86_64                   6/11
  Cleanup    : MariaDB-devel-10.0.22-1.el7.centos.x86_64                   7/11
  Cleanup    : MariaDB-compat-10.0.22-1.el7.centos.x86_64                  8/11
  Cleanup    : MariaDB-shared-10.0.22-1.el7.centos.x86_64                  9/11
  Cleanup    : MariaDB-client-10.0.22-1.el7.centos.x86_64                 10/11
  Cleanup    : MariaDB-common-10.0.22-1.el7.centos.x86_64                 11/11
  Verifying  : MariaDB-client-10.1.8-1.el7.centos.x86_64                   1/11
  Verifying  : MariaDB-devel-10.1.8-1.el7.centos.x86_64                    2/11
  Verifying  : MariaDB-server-10.1.8-1.el7.centos.x86_64                   3/11
  Verifying  : MariaDB-shared-10.1.8-1.el7.centos.x86_64                   4/11
  Verifying  : MariaDB-compat-10.1.8-1.el7.centos.x86_64                   5/11
  Verifying  : MariaDB-common-10.1.8-1.el7.centos.x86_64                   6/11
  Verifying  : MariaDB-client-10.0.22-1.el7.centos.x86_64                  7/11
  Verifying  : MariaDB-shared-10.0.22-1.el7.centos.x86_64                  8/11
  Verifying  : MariaDB-common-10.0.22-1.el7.centos.x86_64                  9/11
  Verifying  : MariaDB-compat-10.0.22-1.el7.centos.x86_64                 10/11
  Verifying  : MariaDB-devel-10.0.22-1.el7.centos.x86_64                  11/11

Installed:
  MariaDB-server.x86_64 0:10.1.8-1.el7.centos                                  

Updated:
  MariaDB-client.x86_64 0:10.1.8-1.el7.centos                                  
  MariaDB-common.x86_64 0:10.1.8-1.el7.centos                                  
  MariaDB-compat.x86_64 0:10.1.8-1.el7.centos                                  
  MariaDB-devel.x86_64 0:10.1.8-1.el7.centos                                   
  MariaDB-shared.x86_64 0:10.1.8-1.el7.centos                                  

Complete!

real    1m5.029s
user    0m20.668s
sys     0m1.060s

*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.1.x my.cnf compatibility
*************************************************

systemctl start mysql.service
systemctl restart mysql.service

total 590M
-rw-rw---- 1 mysql mysql    0 Oct 31 17:59 multi-master.info
drwx--x--x 2 mysql mysql 4.0K Oct 31 17:59 mysql
drwx------ 2 mysql mysql 4.0K Oct 31 17:59 performance_schema
-rw-r--r-- 1 mysql mysql   15 Oct 31 17:59 mysql_upgrade_info
-rw-r----- 1 mysql mysql 1.8K Oct 31 17:59 host.mattwservices.uk.err
-rw-rw---- 1 mysql mysql 1.2M Nov 12 05:15 ib_buffer_pool
-rw-rw---- 1 mysql mysql 128M Nov 17 04:24 ib_logfile1.bak
drwx------ 2 mysql mysql  32K Nov 20 05:25 mattwser_xenforo
-rw-rw---- 1 mysql mysql   52 Nov 20 06:00 aria_log_control
-rw-rw---- 1 mysql mysql  16K Nov 20 06:00 aria_log.00000001
-rw-rw---- 1 mysql mysql 128M Nov 20 06:00 ib_logfile0.bak
-rw-rw---- 1 mysql mysql 128M Nov 20 06:01 ib_logfile1
-rw-rw---- 1 mysql mysql  24K Nov 20 06:01 tc.log
srwxrwxrwx 1 mysql mysql    0 Nov 20 06:01 mysql.sock
-rw-rw---- 1 mysql mysql 128M Nov 20 06:01 ib_logfile0
-rw-rw---- 1 mysql mysql  76M Nov 20 06:01 ibdata1
-rw-rw---- 1 mysql mysql    6 Nov 20 06:01 host.pid
mysql_upgrade --verbose
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
FATAL ERROR: Upgrade failed
------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
mysql -e "INSTALL SONAME 'query_cache_info';"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
mysql -e "INSTALL SONAME 'query_response_time';"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
mysql -t -e "SELECT * FROM mysql.plugin;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
mysql -t -e "SHOW PLUGINS;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
mysql -t -e "SHOW ENGINES;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
systemctl restart mysql.service
systemctl enable mariadb.service


------------------------------------------------
MariaDB 10.1.x Upgrade completed
------------------------------------------------

Error log

Code:

2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Memory barrier is not used
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Using Linux native AIO
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Using CPU crc32 instructions
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Initializing buffer pool, size = 6.0G
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Completed initialization of buffer pool
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: The log sequence numbers 5203133452 and 5203133452 in ibdata files do not match the log sequence number 5203133462 in the ib_logfiles!
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Database was not shutdown normally!
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Starting crash recovery.
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: Restoring possible half-written data pages
2015-11-20  6:26:50 115969340188800 [Note] InnoDB: from the doublewrite buffer...
2015-11-20  6:26:51 115969340188800 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-20  6:26:51 115969340188800 [Note] InnoDB: Waiting for purge to start
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
2015-11-20 06:26:51 69777f9ed700  InnoDB: Error: trying to access tablespace 1952800624 page no. 1752326515,
InnoDB: but the tablespace does not exist or is just being dropped.
InnoDB: Error: Unable to read tablespace 1952800624 page no 1752326515 into the buffer pool after 100 attempts
InnoDB: The most probable cause of this error may be that the table has been corrupted.
InnoDB: You can try to fix this problem by using innodb_force_recovery.
InnoDB: Please see reference manual for more details.
InnoDB: Aborting...
2015-11-20 06:26:51 69777f9ed700  InnoDB: Assertion failure in thread 115961963140864 in file buf0buf.cc line 2962
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
151120  6:26:51 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.1.8-MariaDB
key_buffer_size=33554432
read_buffer_size=65536
max_used_connections=0
max_threads=302
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 96898 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48000
2015-11-20  6:26:51 115969340188800 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 5203133462
2015-11-20  6:26:51 115961936602880 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-20  6:26:51 115969340188800 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-20  6:26:51 115969340188800 [Note] Recovering after a crash using tc.log
2015-11-20  6:26:51 115969340188800 [Note] Starting crash recovery...
2015-11-20  6:26:51 115969340188800 [Note] Crash recovery finished.
2015-11-20  6:26:51 115969340188800 [Note] Server socket created on IP: '127.0.0.1'.
2015-11-20  6:26:51 115969340188800 [Note] Event Scheduler: Loaded 0 events
2015-11-20 06:26:51 6979374b3700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
2015-11-20 06:26:51 6979374b3700 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2015-11-20  6:26:51 115969340188800 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.8-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
mysys/stacktrace.c:247(my_print_stacktrace)[0xf8f5659f8be]
sql/signal_handler.cc:160(handle_fatal_signal)[0xf8f560cfd0d]
/lib64/libpthread.so.0(+0xf130)[0x697937127130]
/lib64/libc.so.6(gsignal+0x37)[0x69793527f5d7]
/lib64/libc.so.6(abort+0x148)[0x697935280cc8]
include/buf0buf.ic:208(buf_page_get_state)[0xf8f56399750]
btr/btr0cur.cc:5437(btr_free_externally_stored_field(dict_index_t*, unsigned char*, unsigned char const*, unsigned long const*, page_zip_des_t*, unsigned long, trx_rb_ctx, mtr_t*))[0xf8f5637f71a]
row/row0purge.cc:712(row_purge_upd_exist_or_extern_func)[0xf8f5630a879]
row/row0purge.cc:869(row_purge_record_func)[0xf8f5630b4f8]
que/que0que.cc:1089(que_thr_step)[0xf8f562d2707]
trx/trx0purge.cc:1254(trx_purge(unsigned long, unsigned long, bool))[0xf8f56338d4e]
srv/srv0srv.cc:3432(srv_do_purge)[0xf8f56326c9f]
/lib64/libpthread.so.0(+0x7df5)[0x69793711fdf5]
/lib64/libc.so.6(clone+0x6d)[0x6979353401ad]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Had to manually roll back to 10.0.22

Matt · Nov 20, 2015

Code:

MariaDB [mysql]> SHOW CREATE TABLE innodb_table_stats\G
*************************** 1. row ***************************
       Table: innodb_table_stats
Create Table: CREATE TABLE `innodb_table_stats` (
  `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `n_rows` bigint(20) unsigned NOT NULL,
  `clustered_index_size` bigint(20) unsigned NOT NULL,
  `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0
1 row in set (0.00 sec)

eva2000 · Nov 20, 2015

I'd probably wait till MariaDB 10.1.9 release which is coming soon https://mariadb.atlassian.net/secure/Dashboard.jspa as there's been a few reported upgrade issues not that i have experienced any.

Centmin Mod 123.09beta01 is only branch with MariaDB 10.1.x upgrade menu just for beta testing as I don't plan to really offer it until 4-6 releases later once I see bugs like this sorted out 😃

if you read 10.1.9 bug fix list you will understand not to be in such a hurry to update to 10.1 series as yet https://mariadb.atlassian.net/issues/?filter=21201 😃

Matt · Nov 20, 2015

I just wanted to give it another go to see if it was the old VPS causing the issue. I've had MariaDB 10.1.8 working fine from a fresh install, so it looks like it's related to the upgrade process.

eva2000 · Nov 21, 2015

Yeah there's a few reports of upgrade issues from 10.0 to 10.1.8 right now that look to be marked fixed in 10.1.9 so fingers crossed 😃

For MariaDB i always check Jira bug tracker to see when it's ideal to update and 10.1.8 wasn't looking that good for me 😀

MariaDB 10.1

Matt

Matt

eva2000

Matt

eva2000

Shared Hosting

VPS Hosting

Server Management