So after upgrading MariaDB 10.1.29 - 10.1.30 it won't start again.
Rolling back to 10.1.29 and it works...
Any suggestions?
Rolling back to 10.1.29 and it works...
Any suggestions?
Code:
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Updating database digests format: 100%
Checking for upgrades (14 candidates): 100%
Processing candidates (14 candidates): 100%
Checking integrity... done (0 conflicting)
The following 1 package(s) will be affected (of 0 checked):
Installed packages to be UPGRADED:
mariadb101-server: 10.1.29 -> 10.1.30
Number of packages to be upgraded: 1
The process will require 2 MiB more space.
Proceed with this action? [y/N]: y
[www] [1/1] Upgrading mariadb101-server from 10.1.29 to 10.1.30...
===> Creating groups.
Using existing group 'mysql'.
===> Creating users
Using existing user 'mysql'.
[www] [1/1] Extracting mariadb101-server-10.1.30: 100%
Message from mariadb101-server-10.1.30:
************************************************************************
Remember to run mysql_upgrade (with the optional --datadir=<dbdir> flag)
the first time you start the MySQL server after an upgrade from an
earlier version.
MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for
my.cnf. Please move existing my.cnf files from those paths to
/usr/local/etc and /usr/local/etc/mysql.
This port does NOT include the mytop perl script, this is included in
the MariaDB tarball but the most recent version can be found in the
databases/mytop port
************************************************************************
vulnxml file up-to-date
0 problem(s) in the installed packages found.
root@www:~ # service mysql-server restart
Stopping mysql.
Waiting for PIDS: 1321.
Starting mysql.
root@www:~ # cd /var/cache/pkg/
root@www:/var/cache/pkg # service mysql-server restart
root@www:/var/cache/pkg # pkg remove mariadb101-server
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 1 packages (of 0 packages in the universe):
Installed packages to be REMOVED:
mariadb101-server-10.1.30
Number of packages to be removed: 1
The operation will free 189 MiB.
Proceed with deinstalling packages? [y/N]: y
[www] [1/1] Deinstalling mariadb101-server-10.1.30...
[www] [1/1] Deleting files for mariadb101-server-10.1.30: 100%
==> You should manually remove the "mysql" user.
==> You should manually remove the "mysql" group
root@www:/var/cache/pkg # service mysql-server restart
root@www:/var/cache/pkg # pkg add mariadb101-server-10.1.29.txz
[www] Installing mariadb101-server-10.1.29...
===> Creating groups.
Using existing group 'mysql'.
===> Creating users
Using existing user 'mysql'.
[www] Extracting mariadb101-server-10.1.29: 100%
Message from mariadb101-server-10.1.29:
************************************************************************
Remember to run mysql_upgrade (with the optional --datadir=<dbdir> flag)
the first time you start the MySQL server after an upgrade from an
earlier version.
MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for
my.cnf. Please move existing my.cnf files from those paths to
/usr/local/etc and /usr/local/etc/mysql.
This port does NOT include the mytop perl script, this is included in
the MariaDB tarball but the most recent version can be found in the
databases/mytop port
************************************************************************
root@www:/var/cache/pkg # service mysql-server restart
mysql not running? (check /var/db/mysql/www.pid).
Starting mysql.
Code:
root@www:/var/cache/pkg # mysql_upgrade -u root -p
Enter password:
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 '/tmp/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
root@www:/var/cache/pkg # tail /var/db/mysql/www.err
171228 19:39:29 mysqld_safe mysqld from pid file /var/db/mysql/www.pid ended
171228 19:39:29 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2017-12-28 19:39:29 34422743040 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-12-28 19:39:29 34422743040 [Note] /usr/local/libexec/mysqld (mysqld 10.1.30-MariaDB) starting as process 3051 ...
/usr/local/libexec/mysqld: Undefined symbol "fdatasync"
171228 19:39:29 mysqld_safe mysqld from pid file /var/db/mysql/www.pid ended