MariaDB 5.5.60 update to 5.5.61 issue

staff_nowa

Verified User
Joined
Mar 10, 2018
Messages
122
Location
Vilnius
I run ./build mariadb and received error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/data/mysql.sock' (2)
mv: ‘mariadb-5.5.61-linux-glibc_214-x86_64.tar.gz’ and ‘/usr/local/mariadb-5.5.61-linux-glibc_214-x86_64.tar.gz’ are the same file

And now cannot return to the same version

180917 10:05:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
180917 10:05:01 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.60-MariaDB) starting as process 26873 ...
180917 10:05:01 InnoDB: The InnoDB memory heap is disabled
180917 10:05:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180917 10:05:01 InnoDB: Compressed tables use zlib 1.2.3
180917 10:05:01 InnoDB: Using Linux native AIO
180917 10:05:01 InnoDB: Initializing buffer pool, size = 128.0M
180917 10:05:01 InnoDB: Completed initialization of buffer pool
180917 10:05:01 InnoDB: highest supported file format is Barracuda.
180917 10:05:01 InnoDB: Waiting for the background threads to start
180917 10:05:02 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 11513921
180917 10:05:02 [Note] Plugin 'FEEDBACK' is disabled.
180917 10:05:02 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180917 10:05:02 [Note] Server socket created on IP: '0.0.0.0'.
180917 10:05:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
180917 10:05:02 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended
180917 10:05:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
180917 10:05:06 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.60-MariaDB) starting as process 27235 ...
180917 10:05:06 InnoDB: The InnoDB memory heap is disabled
180917 10:05:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180917 10:05:06 InnoDB: Compressed tables use zlib 1.2.3
180917 10:05:06 InnoDB: Using Linux native AIO
180917 10:05:06 InnoDB: Initializing buffer pool, size = 128.0M
180917 10:05:06 InnoDB: Completed initialization of buffer pool
180917 10:05:06 InnoDB: highest supported file format is Barracuda.
180917 10:05:06 InnoDB: Waiting for the background threads to start
180917 10:05:07 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 11513921
180917 10:05:07 [Note] Plugin 'FEEDBACK' is disabled.
180917 10:05:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180917 10:05:07 [Note] Server socket created on IP: '0.0.0.0'.
180917 10:05:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
180917 10:05:07 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended

my.cnf
[mysqld]
local-infile=0
innodb_file_per_table

[client]
socket=/usr/local/mysql/data/mysql.sock

How possible solve issue now :(
 
Hello,

It's a Debian related issue.

Change/add datadir= in /etc/my.cnf from /home/mysql/ and move databases to /var/lib/mysql/:


Code:
datadir                        = /var/lib/mysql/

and MariaDB 10.0.36 should start fine.

If you don't know how to do it, contact me for a paid service.
 
Issue still have

FATAL ERROR: Upgrade failed
Restarting MySQL.
180917 11:00:14 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180917 11:00:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180917 11:00:14 [Note] InnoDB: The InnoDB memory heap is disabled
180917 11:00:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180917 11:00:14 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180917 11:00:14 [Note] InnoDB: Compressed tables use zlib 1.2.3
180917 11:00:14 [Note] InnoDB: Using Linux native AIO
180917 11:00:14 [Note] InnoDB: Using CPU crc32 instructions
180917 11:00:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180917 11:00:14 [Note] InnoDB: Completed initialization of buffer pool
180917 11:00:14 [Note] InnoDB: Highest supported file format is Barracuda.
180917 11:00:14 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49463
180917 11:00:14 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180917 11:00:14 [Note] InnoDB: Starting final batch to recover 11 pages from redo log
180917 11:00:15 [Note] InnoDB: 128 rollback segment(s) are active.
180917 11:00:15 [Note] InnoDB: Waiting for purge to start
180917 11:00:15 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1600607
180917 11:00:15 [Note] Plugin 'FEEDBACK' is disabled.
180917 11:00:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180917 11:00:15 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
180917 11:00:15 [Note] Server socket created on IP: '::'.
180917 11:00:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
180917 11:00:15 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended
180917 11:00:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
180917 11:00:19 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.0.36-MariaDB) starting as process 18022 ...
180917 11:00:19 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180917 11:00:19 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180917 11:00:19 [Note] InnoDB: The InnoDB memory heap is disabled
180917 11:00:19 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180917 11:00:19 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180917 11:00:19 [Note] InnoDB: Compressed tables use zlib 1.2.3
180917 11:00:19 [Note] InnoDB: Using Linux native AIO
180917 11:00:19 [Note] InnoDB: Using CPU crc32 instructions
180917 11:00:19 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180917 11:00:19 [Note] InnoDB: Completed initialization of buffer pool
180917 11:00:19 [Note] InnoDB: Highest supported file format is Barracuda.
180917 11:00:19 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49463
180917 11:00:19 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180917 11:00:19 [Note] InnoDB: Starting final batch to recover 11 pages from redo log
180917 11:00:20 [Note] InnoDB: 128 rollback segment(s) are active.
180917 11:00:20 [Note] InnoDB: Waiting for purge to start
180917 11:00:20 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1600607
180917 11:00:20 [Note] Plugin 'FEEDBACK' is disabled.
180917 11:00:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180917 11:00:20 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
180917 11:00:20 [Note] Server socket created on IP: '::'.
180917 11:00:20 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
180917 11:00:20 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended
 
180917 11:00:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
 
Service temporary started and kill again.
Issue solved copy mysql tables from another working server.

Thank you for your help
 
Maybe you have some recommendations for issue on Debian? Do you upgrade your servers with Debian? :)
 
I checked another my server

mysql_backup_gzip=no
mysql_backup_dir=/usr/local/directadmin/custombuild/mysql_backups
dovecot=yes
dovecot_conf=yes
pigeonhole=no
exim=no
eximconf=no
eximconf_release=4.5
blockcracking=no
easy_spam_fighter=no
phpmyadmin=yes
phpmyadmin_ver=4
squirrelmail=no
roundcube=yes
webapps_inbox_prefix=yes
awstats=no
webalizer=yes
autoconf=yes
automake=yes
libtool=yes
curl=yes
new_pcre=no
autover=no
clean_old_tarballs=yes
clean_old_webapps=yes
cleanapache=yes
custombuild=2.0
cron=no
cron_frequency=weekly
[email protected]
notifications=yes
da_autoupdate=no
updates=no
webapps_updates=yes
php_ini=no
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
spamd=
 
Last edited:
@zEitEr,

Is this problem only a problem if you didn't have a custom /home partition? (so /home is on /)
 
It should not really matter whether or not /home is mounted as a separate partition.
 
It should not really matter whether or not /home is mounted as a separate partition.

Thank you! The strange thing is that we have no problems with all MariaDB versions and /home/mysql. So there must be a logical explanation that you have problems and we do not. We use Debian 8 Jessie and Debian 9 Stretch. This should be another problem, but what :D
 
Hello zEitEr,

We have a normal /home/mysql directory and the permissions 711 for /home. (755 for /home/mysql)
 
Back
Top