Skip to content

Instantly share code, notes, and snippets.

/MariaDB 10.1.x Upgrade Log Secret

Created December 17, 2016 07:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/c3bc4955c3a0a5b6c1c2de6e45d62d7a to your computer and use it in GitHub Desktop.
Save anonymous/c3bc4955c3a0a5b6c1c2de6e45d62d7a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MariaDB 10.1.x Upgrade Log
-------------------------------------------------------------------------------
This script's MariaDB 10.1.x upgrade process is still in beta testing stages.
So please test on a test server and not a live production server. But if you use
on live server or if MySQL databases already exist, please back them up before
running this upgrade script via mysqldump - instructions at:
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
###################################################################
### IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE ###
### OR RISK DATA LOSS DUE TO MARIADB 10.1 Changes ###
###################################################################
For each DATABASENAME backup via mysqldump i.e.
mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
------------------------------------------------------------------------
Have you backed up your databases ? [y/n] y
MariaDB 10.1.x https://mariadb.com/kb/en/mariadb/what-is-mariadb-101/
!! Note !!
upgrade process can take more >5 minutes.. you may want to shutdown
nginx server to not show mysql errors to visitors on your site or
put site(s) into maintenance mode before proceeding with mysql upgrade
Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] y
checking mysql root password works in /root/.my.cnf
mysqladmin ver
mysqladmin Ver 9.1 Distrib 10.0.28-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Server version 10.0.28-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 8 hours 32 min 56 sec
Threads: 1 Questions: 4639 Slow queries: 2 Opens: 380 Flush tables: 1 Open tables: 443 Queries per second avg: 0.150
____ _
| _ \ _ __ ___ _ __ __ _ _ __ (_) _ __ __ _
| |_) || '__|/ _ \| '_ \ / _` || '__|| || '_ \ / _` |
| __/ | | | __/| |_) || (_| || | | || | | || (_| |
|_| |_| \___|| .__/ \__,_||_| |_||_| |_| \__, |
|_| |___/
____ _ _ _ _____
/ ___| | |__ _ _ | |_ __| | ___ __ __ _ __ | ___|___ _ __
\___ \ | '_ \ | | | || __|/ _` | / _ \\ \ /\ / /| '_ \ | |_ / _ \ | '__|
___) || | | || |_| || |_| (_| || (_) |\ V V / | | | | | _|| (_) || |
|____/ |_| |_| \__,_| \__|\__,_| \___/ \_/\_/ |_| |_| |_| \___/ |_|
_ _ _
| | | | _ __ __ _ _ __ __ _ __| | ___
| | | || '_ \ / _` || '__|/ _` | / _` | / _ \
| |_| || |_) || (_| || | | (_| || (_| || __/
\___/ | .__/ \__, ||_| \__,_| \__,_| \___|
|_| |___/
continuing upgrade in ~300 seconds...
...
..... continue in 300s
....... continue in 280s
......... continue in 260s
........... continue in 240s
............. continue in 220s
............... continue in 200s
................. continue in 180s
.................. continue in 160s
.................... continue in 140s
...................... continue in 120s
........................ continue in 80s
.......................... continue in 60s
............................ continue in 40s
.............................. continue in 20s
shut down existing MariaDB server for upgrade..
Shutting down MySQL.. SUCCESS!
total 334M
drwxr-xr-x 7 mysql mysql 4.0K Dec 17 04:05 .
drwxr-xr-x 33 root root 4.0K Dec 12 18:00 ..
-rw-rw---- 1 mysql mysql 16K Dec 17 04:05 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Dec 17 04:05 aria_log_control
-rw-rw---- 1 mysql mysql 14K Dec 16 19:27 ib_buffer_pool
-rw-rw---- 1 mysql mysql 76M Dec 17 04:05 ibdata1
-rw-rw---- 1 mysql mysql 128M Dec 17 04:05 ib_logfile0
-rw-rw---- 1 mysql mysql 128K Sep 6 02:14 ib_logfile0.gz
-rw-rw---- 1 mysql mysql 128M Dec 17 04:05 ib_logfile1
-rw-rw---- 1 mysql mysql 128K Sep 6 02:14 ib_logfile1.gz
-rw-r----- 1 mysql root 1.9K Sep 6 02:14 li419-234.members.linode.com.err
-rw-rw---- 1 mysql mysql 0 Sep 6 02:14 multi-master.info
drwx--x--x 2 mysql mysql 4.0K Sep 6 02:14 mysql
-rw-r--r-- 1 root root 15 Sep 6 02:14 mysql_upgrade_info
drwx------ 2 mysql mysql 4.0K Sep 6 02:14 performance_schema
drwx------ 2 mysql mysql 100K Dec 4 20:38 prosper202
-rw-r--r-- 1 root root 309K Dec 17 03:50 prosper202_backup.sql
drwx------ 2 mysql mysql 4.0K Dec 14 04:21 pt_wrdp
-rw-r--r-- 1 root root 123K Dec 17 03:57 pt_wrdp_backup.sql
drwx------ 2 mysql mysql 4.0K Sep 21 21:40 wrdp
-rw-r--r-- 1 root root 563K Dec 17 03:58 wrdp_backup.sql
__ __ _ ____ ____ _ ___ _
| \/ | __ _ _ __ (_) __ _ | _ \ | __ ) / | / _ \ / | __ __
| |\/| | / _` || '__|| | / _` || | | || _ \ | || | | | | | \ \/ /
| | | || (_| || | | || (_| || |_| || |_) | | || |_| |_ | | _ > <
|_| |_| \__,_||_| |_| \__,_||____/ |____/ |_| \___/(_)|_|(_)/_/\_\
____ ____ _
| _ \ ___ _ __ ___ / ___| ___ | |_ _ _ _ __
| |_) |/ _ \| '_ \ / _ \ \___ \ / _ \| __|| | | || '_ \
| _ <| __/| |_) || (_) | ___) || __/| |_ | |_| || |_) |
|_| \_\\___|| .__/ \___/ |____/ \___| \__| \__,_|| .__/
|_| |_|
*************************************************
MariaDB 10.1.x Repo setup...
(B*************************************************
Loaded plugins: fastestmirror, priorities
Cleaning repos: base epel extras mariadb newrelic rpmforge updates varnish-4.1
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
(Byum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel
(B*************************************************
Installed Packages
MariaDB-client.x86_64 10.0.28-1.el7.centos @mariadb
MariaDB-common.x86_64 10.0.28-1.el7.centos @mariadb
MariaDB-compat.x86_64 10.0.28-1.el7.centos @mariadb
MariaDB-devel.x86_64 10.0.28-1.el7.centos @mariadb
MariaDB-shared.x86_64 10.0.28-1.el7.centos @mariadb
Available Packages
MariaDB-client.x86_64 10.1.20-1.el7.centos mariadb
MariaDB-common.x86_64 10.1.20-1.el7.centos mariadb
MariaDB-compat.x86_64 10.1.20-1.el7.centos mariadb
MariaDB-devel.x86_64 10.1.20-1.el7.centos mariadb
MariaDB-server.x86_64 10.1.20-1.el7.centos mariadb
MariaDB-shared.x86_64 10.1.20-1.el7.centos mariadb
mariadb-devel.x86_64 1:5.5.52-1.el7 base
mariadb-server.x86_64 1:5.5.52-1.el7 base
real 0m11.509s
user 0m3.757s
sys 0m0.497s
__ __ _ ____ ____ _ ___ _
| \/ | __ _ _ __ (_) __ _ | _ \ | __ ) / | / _ \ / | __ __
| |\/| | / _` || '__|| | / _` || | | || _ \ | || | | | | | \ \/ /
| | | || (_| || | | || (_| || |_| || |_) | | || |_| |_ | | _ > <
|_| |_| \__,_||_| |_| \__,_||____/ |____/ |_| \___/(_)|_|(_)/_/\_\
___ _ _ _
|_ _| _ __ ___ | |_ __ _ | || |
| | | '_ \ / __|| __|/ _` || || |
| | | | | |\__ \| |_| (_| || || |
|___||_| |_||___/ \__|\__,_||_||_|
*************************************************
MariaDB 10.1.x YUM install...
(Byum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel
(B*************************************************
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* base: mirrors.linode.com
* extras: mirrors.linode.com
* rpmforge: mirror.lstn.net
* updates: mirrors.linode.com
17 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.28-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.0.28-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.0.28-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.0.28-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.1.20-1.el7.centos will be installed
--> Processing Dependency: galera for package: MariaDB-server-10.1.20-1.el7.centos.x86_64
---> Package MariaDB-shared.x86_64 0:10.0.28-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.1.20-1.el7.centos will be an update
--> Running transaction check
---> Package galera.x86_64 0:25.3.19-1.rhel7.el7.centos will be installed
--> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: galera-25.3.19-1.rhel7.el7.centos.x86_64
--> Running transaction check
---> Package boost-program-options.x86_64 0:1.53.0-26.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
MariaDB-server x86_64 10.1.20-1.el7.centos mariadb 100 M
Updating:
MariaDB-client x86_64 10.1.20-1.el7.centos mariadb 39 M
MariaDB-common x86_64 10.1.20-1.el7.centos mariadb 43 k
MariaDB-compat x86_64 10.1.20-1.el7.centos mariadb 1.4 M
MariaDB-devel x86_64 10.1.20-1.el7.centos mariadb 6.6 M
MariaDB-shared x86_64 10.1.20-1.el7.centos mariadb 1.3 M
Installing for dependencies:
boost-program-options x86_64 1.53.0-26.el7 base 156 k
galera x86_64 25.3.19-1.rhel7.el7.centos mariadb 8.0 M
Transaction Summary
================================================================================
Install 1 Package (+2 Dependent packages)
Upgrade 5 Packages
Total download size: 157 M
Downloading packages:
No Presto metadata available for mariadb
--------------------------------------------------------------------------------
Total 18 MB/s | 157 MB 00:08
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
varnish-release-4.1-2.el7.noarch is a duplicate with varnish-release-3.0-1.el6.noarch
Updating : MariaDB-common-10.1.20-1.el7.centos.x86_64 1/13
Updating : MariaDB-client-10.1.20-1.el7.centos.x86_64 2/13
Installing : boost-program-options-1.53.0-26.el7.x86_64 3/13
Installing : galera-25.3.19-1.rhel7.el7.centos.x86_64 4/13
Installing : MariaDB-server-10.1.20-1.el7.centos.x86_64 5/13
Updating : MariaDB-shared-10.1.20-1.el7.centos.x86_64 6/13
Updating : MariaDB-devel-10.1.20-1.el7.centos.x86_64 7/13
Updating : MariaDB-compat-10.1.20-1.el7.centos.x86_64 8/13
Cleanup : MariaDB-devel-10.0.28-1.el7.centos.x86_64 9/13
Cleanup : MariaDB-client-10.0.28-1.el7.centos.x86_64 10/13
Cleanup : MariaDB-compat-10.0.28-1.el7.centos.x86_64 11/13
Cleanup : MariaDB-shared-10.0.28-1.el7.centos.x86_64 12/13
Cleanup : MariaDB-common-10.0.28-1.el7.centos.x86_64 13/13
Verifying : MariaDB-shared-10.1.20-1.el7.centos.x86_64 1/13
Verifying : MariaDB-server-10.1.20-1.el7.centos.x86_64 2/13
Verifying : MariaDB-common-10.1.20-1.el7.centos.x86_64 3/13
Verifying : galera-25.3.19-1.rhel7.el7.centos.x86_64 4/13
Verifying : boost-program-options-1.53.0-26.el7.x86_64 5/13
Verifying : MariaDB-devel-10.1.20-1.el7.centos.x86_64 6/13
Verifying : MariaDB-compat-10.1.20-1.el7.centos.x86_64 7/13
Verifying : MariaDB-client-10.1.20-1.el7.centos.x86_64 8/13
Verifying : MariaDB-common-10.0.28-1.el7.centos.x86_64 9/13
Verifying : MariaDB-devel-10.0.28-1.el7.centos.x86_64 10/13
Verifying : MariaDB-compat-10.0.28-1.el7.centos.x86_64 11/13
Verifying : MariaDB-shared-10.0.28-1.el7.centos.x86_64 12/13
Verifying : MariaDB-client-10.0.28-1.el7.centos.x86_64 13/13
Installed:
MariaDB-server.x86_64 0:10.1.20-1.el7.centos
Dependency Installed:
boost-program-options.x86_64 0:1.53.0-26.el7
galera.x86_64 0:25.3.19-1.rhel7.el7.centos
Updated:
MariaDB-client.x86_64 0:10.1.20-1.el7.centos
MariaDB-common.x86_64 0:10.1.20-1.el7.centos
MariaDB-compat.x86_64 0:10.1.20-1.el7.centos
MariaDB-devel.x86_64 0:10.1.20-1.el7.centos
MariaDB-shared.x86_64 0:10.1.20-1.el7.centos
Complete!
real 0m50.627s
user 0m38.270s
sys 0m3.793s
*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
(B for MariaDB 10.1.x my.cnf compatibility
(B*************************************************
__ __ _ ____ ____ _ ___ _
| \/ | __ _ _ __ (_) __ _ | _ \ | __ ) / | / _ \ / | __ __
| |\/| | / _` || '__|| | / _` || | | || _ \ | || | | | | | \ \/ /
| | | || (_| || | | || (_| || |_| || |_) | | || |_| |_ | | _ > <
|_| |_| \__,_||_| |_| \__,_||____/ |____/ |_| \___/(_)|_|(_)/_/\_\
__ _ __ __
/ /___ | |_ ___ / /_ __ ___ _ _ ___ _ __ / _|
/ // _ \| __|/ __| / /| '_ ` _ \ | | | | / __|| '_ \ | |_
/ /| __/| |_| (__ / / | | | | | || |_| | _| (__ | | | || _|
/_/ \___| \__|\___|/_/ |_| |_| |_| \__, |(_)\___||_| |_||_|
|___/
_ _ _ _ _
/ \ __| | (_) _ _ ___ | |_ _ __ ___ ___ _ __ | |_ ___
/ _ \ / _` | | || | | |/ __|| __|| '_ ` _ \ / _ \| '_ \ | __|/ __|
/ ___ \| (_| | | || |_| |\__ \| |_ | | | | | || __/| | | || |_ \__ \
/_/ \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
|__/
systemctl start mysql.service
systemctl restart mysql.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
## !! mysql failed to start properly !! ##
journalctl -xn
-- Logs begin at Tue 2016-12-13 18:55:31 UTC, end at Sat 2016-12-17 04:06:40 UTC. --
Dec 17 04:06:37 atlas kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:91:bb:4d:65:84:78:ac:0d:97:c1:08:00 SRC=109.162.70.72 DST=45.79.1.135 LEN=40 TOS=0x08 PREC=0x20 TTL=238 ID=3364 PROTO=TCP SPT=57921 DPT=23 WINDOW=45595 RES=0x00 SYN URGP=0
Dec 17 04:06:40 atlas polkitd[3188]: Registered Authentication Agent for unix-process:2129:29227070 (system bus name :1.1353 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8)
Dec 17 04:06:40 atlas systemd[1]: Stopping MariaDB database server...
-- Subject: Unit mariadb.service has begun shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun shutting down.
Dec 17 04:06:40 atlas systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Dec 17 04:06:40 atlas mysqld[2366]: 2016-12-17 4:06:40 139653703325952 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 2366 ...
Dec 17 04:06:40 atlas systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Dec 17 04:06:40 atlas systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dec 17 04:06:40 atlas systemd[1]: Unit mariadb.service entered failed state.
Dec 17 04:06:40 atlas systemd[1]: mariadb.service failed.
Dec 17 04:06:40 atlas polkitd[3188]: Unregistered Authentication Agent for unix-process:2129:29227070 (system bus name :1.1353, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
tail -50 /var/log/mysqld.log
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_usermeta'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Tablespace open failed for '"wp96797461db_9809"."31418_usermeta"', ignored.
2016-12-16 19:27:12 7f8fb03ec8c0 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_users'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Tablespace open failed for '"wp96797461db_9809"."31418_users"', ignored.
161216 19:27:12 [Note] InnoDB: 128 rollback segment(s) are active.
161216 19:27:12 [Note] InnoDB: Waiting for purge to start
161216 19:27:12 [ERROR] InnoDB: Failed to find tablespace for table '"wp96797461db_9809"."31418_options"' in the cache. Attempting to load the tablespace with space id 6254.
2016-12-16 19:27:12 7f8f9effb700 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_options'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Failed to find tablespace for table '"wp96797461db_9809"."31418_posts"' in the cache. Attempting to load the tablespace with space id 6256.
2016-12-16 19:27:12 7f8f9effb700 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_posts'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 163586009
2016-12-16 19:27:12 7f8f9d7f8700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
161216 19:27:13 [Note] Plugin 'FEEDBACK' is disabled.
161216 19:27:13 [Note] Server socket created on IP: '::'.
161216 19:27:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.28-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2016-12-16 19:27:15 7f8f9d7f8700 InnoDB: Buffer pool(s) load completed at 161216 19:27:15
161217 4:05:18 [Note] /usr/sbin/mysqld: Normal shutdown
161217 4:05:18 [Note] Event Scheduler: Purging the queue. 0 events
161217 4:05:18 [Note] InnoDB: FTS optimize thread exiting.
161217 4:05:18 [Note] InnoDB: Starting shutdown...
161217 4:05:19 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
161217 4:05:19 [Note] InnoDB: Shutdown completed; log sequence number 163598970
161217 4:05:19 [Note] /usr/sbin/mysqld: Shutdown complete
161217 04:05:19 mysqld_safe mysqld from pid file /var/lib/mysql/atlas.pid ended
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: The InnoDB memory heap is disabled
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: Using Linux native AIO
2016-12-17 4:06:40 139653703325952 [Note] InnoDB: Using SSE crc32 instructions
2016-12-17 4:06:40 139653703325952 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ibfvVPMG' (Errcode: 13 "Permission denied")
2016-12-17 04:06:40 7f03a960d900 InnoDB: Error: unable to create temporary file; errno: 13
2016-12-17 4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' init function returned error.
2016-12-17 4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-12-17 4:06:40 139653703325952 [Note] Plugin 'FEEDBACK' is disabled.
2016-12-17 4:06:40 139653703325952 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-12-17 4:06:40 139653703325952 [ERROR] Aborting
possible errors / warnings
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_usermeta'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Tablespace open failed for '"wp96797461db_9809"."31418_usermeta"', ignored.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_users'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Tablespace open failed for '"wp96797461db_9809"."31418_users"', ignored.
161216 19:27:12 [ERROR] InnoDB: Failed to find tablespace for table '"wp96797461db_9809"."31418_options"' in the cache. Attempting to load the tablespace with space id 6254.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_options'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
161216 19:27:12 [ERROR] InnoDB: Failed to find tablespace for table '"wp96797461db_9809"."31418_posts"' in the cache. Attempting to load the tablespace with space id 6256.
161216 19:27:12 [ERROR] InnoDB: Could not find a valid tablespace file for 'wp96797461db_9809/31418_posts'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-12-17 4:06:40 139653703325952 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ibfvVPMG' (Errcode: 13 "Permission denied")
2016-12-17 4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' init function returned error.
2016-12-17 4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-12-17 4:06:40 139653703325952 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-12-17 4:06:40 139653703325952 [ERROR] Aborting
possible unknown or incompatible /etc/my.cnf set options below
maybe need to comment out or remove these in /etc/my.cnf
attempting auto commenting out of invalid options
systemctl restart mysql.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
total 334M
-rw-rw---- 1 mysql mysql 0 Sep 6 02:14 multi-master.info
drwx--x--x 2 mysql mysql 4.0K Sep 6 02:14 mysql
drwx------ 2 mysql mysql 4.0K Sep 6 02:14 performance_schema
-rw-r--r-- 1 mysql mysql 15 Sep 6 02:14 mysql_upgrade_info
-rw-r----- 1 mysql mysql 1.9K Sep 6 02:14 li419-234.members.linode.com.err
drwx------ 2 mysql mysql 4.0K Sep 21 21:40 wrdp
drwx------ 2 mysql mysql 100K Dec 4 20:38 prosper202
drwx------ 2 mysql mysql 4.0K Dec 14 04:21 pt_wrdp
-rw-rw---- 1 mysql mysql 14K Dec 16 19:27 ib_buffer_pool
-rw-r--r-- 1 mysql mysql 309K Dec 17 03:50 prosper202_backup.sql
-rw-r--r-- 1 mysql mysql 123K Dec 17 03:57 pt_wrdp_backup.sql
-rw-r--r-- 1 mysql mysql 563K Dec 17 03:58 wrdp_backup.sql
-rw-rw---- 1 mysql mysql 128M Dec 17 04:05 ib_logfile1.bak
-rw-rw---- 1 mysql mysql 128M Dec 17 04:05 ib_logfile0.bak
-rw-rw---- 1 mysql mysql 76M Dec 17 04:05 ibdata1
-rw-rw---- 1 mysql mysql 52 Dec 17 04:06 aria_log_control
-rw-rw---- 1 mysql mysql 16K Dec 17 04:06 aria_log.00000001
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' (2 "No such file or directory")
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' (2 "No such file or directory")
mysql -e "INSTALL SONAME 'query_cache_info';"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
mysql -e "INSTALL SONAME 'query_response_time';"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
mysql -t -e "SELECT * FROM mysql.plugin;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
mysql -t -e "SHOW PLUGINS;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
mysql -t -e "SHOW ENGINES;"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
systemctl restart mysql.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
systemctl enable mariadb.service
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
------------------------------------------------
MariaDB 10.1.x Upgrade completed
------------------------------------------------
__ __ _ ____ ____ _ ___ _
| \/ | __ _ _ __ (_) __ _ | _ \ | __ ) / | / _ \ / | __ __
| |\/| | / _` || '__|| | / _` || | | || _ \ | || | | | | | \ \/ /
| | | || (_| || | | || (_| || |_| || |_) | | || |_| |_ | | _ > <
|_| |_| \__,_||_| |_| \__,_||____/ |____/ |_| \___/(_)|_|(_)/_/\_\
_ _ _ _
| | | | _ __ __ _ _ __ __ _ __| | ___ __| |
| | | || '_ \ / _` || '__|/ _` | / _` | / _ \ / _` |
| |_| || |_) || (_| || | | (_| || (_| || __/| (_| |
\___/ | .__/ \__, ||_| \__,_| \__,_| \___| \__,_|
|_| |___/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment