[MDEV-21394] Can't start service Created: 2019-12-25  Updated: 2019-12-25  Resolved: 2019-12-25

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Nacer Heithem Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

2019-12-25 14:01:26 4064 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-12-25 14:01:26 139695023744832 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.30-MariaDB) starting as process 4212 ...
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: The InnoDB memory heap is disabled
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Using SSE crc32 instructions
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Initializing buffer pool, size = 160.0M
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Completed initialization of buffer pool
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Highest supported file format is Barracuda.
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: The log sequence number 23102609048 in ibdata file do not match the log sequence number 23102609058 in the ib_logfiles!
2019-12-25 14:01:26 139695023744832 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-12-25 14:01:27 139695023744832 [Note] InnoDB: 128 rollback segment(s) are active.
2019-12-25 14:01:27 139695023744832 [Note] InnoDB: Waiting for purge to start
2019-12-25 14:01:27 139695023744832 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 23102609058
2019-12-25 14:01:27 139694205560576 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-12-25 14:01:27 139695023744832 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-25 14:01:27 139695023744832 [Note] Recovering after a crash using tc.log
2019-12-25 14:01:27 139695023744832 [Note] Starting crash recovery...
2019-12-25 14:01:27 139695023744832 [Note] Crash recovery finished.
2019-12-25 14:01:27 139695023744832 [Note] Server socket created on IP: '::'.
2019-12-25 14:01:27 139695023744832 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
2019-12-25 14:01:27 4064 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/ns3075995.pid ended

 Comments   
Comment by Elena Stepanova [ 2019-12-25 ]

The error appears to be self-explanatory:

Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist

Does it exist? What does ls -l /opt/lampp/var/mysql /opt/lampp/var/mysql/mysql say?

Comment by Nacer Heithem [ 2019-12-25 ]

This is what gives this command
ls -l /opt/lampp/var/mysql /opt/lampp/var/mysql/mysql

/opt/lampp/var/mysql:
total 111284
drwxrwxr-x 2 mysql mysql 4096 Dec 22 14:35 ways
-rwxrwxr-x 1 mysql mysql 16384 Dec 24 23:18 aria_log.00000001
-rwxrwxr-x 1 mysql mysql 52 Dec 24 23:18 aria_log_control
-rwxrwxr-x 1 mysql mysql 1248 Dec 22 20:34 ib_buffer_pool
-rwxrwxr-x 1 mysql mysql 77594624 Dec 25 14:01 ibdata1
-rwxrwxr-x 1 mysql mysql 5242880 Dec 25 14:01 ib_logfile0
-rwxrwxr-x 1 mysql mysql 5242880 Dec 22 20:31 ib_logfile1
-rwxrwxr-x 1 mysql mysql 0 Nov 24 2015 multi-master.info
drwxrwxr-x 2 mysql mysql 4096 Dec 22 14:44 mysql
-rwxrwxr-x 1 mysql mysql 68095 Dec 25 14:01 ns3075995.err
-rwxrwxr-x 1 mysql mysql 25639628 Dec 22 18:00 ns3075995-org.err
drwxrwxr-x 2 mysql mysql 4096 Oct 18 2018 performance_schema
drwxrwxr-x 2 mysql mysql 12288 Dec 22 14:43 phpmyadmin
drwxrwxr-x 2 mysql mysql 12288 Dec 22 14:43 pways
drwxrwxr-x 2 mysql mysql 16384 Dec 22 14:43 revtrack
drwxrwxr-x 2 mysql mysql 36864 Oct 22 15:04 shways
rw-rw--- 1 mysql mysql 24576 Dec 25 14:01 tc.log
drwxrwxr-x 2 mysql mysql 4096 Oct 18 2018 test
drwxrwxr-x 2 mysql mysql 4096 Dec 22 14:25 testing
drwxrwxr-x 2 mysql mysql 4096 Dec 22 14:18 trackpos

/opt/lampp/var/mysql/mysql:
total 600
-rwxrwxr-x 1 mysql mysql 2812 Dec 22 14:43 columns_priv.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:43 columns_priv.MYD
-rwxrwxr-x 1 mysql mysql 4096 Dec 22 14:43 columns_priv.MYI
-rwxrwxr-x 1 mysql mysql 4539 Dec 22 14:34 column_stats.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:34 column_stats.MYD
-rwxrwxr-x 1 mysql mysql 4096 Dec 22 14:34 column_stats.MYI
-rwxrwxr-x 1 mysql mysql 5028 Dec 22 14:35 event.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:35 event.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:35 event.MYI
-rwxrwxr-x 1 mysql mysql 35 Dec 22 14:41 general_log.CSM
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:29 general_log.CSV
-rwxrwxr-x 1 mysql mysql 666 Dec 22 14:29 general_log.frm
-rwxrwxr-x 1 mysql mysql 1638 Nov 24 2015 help_keyword.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:26 help_keyword.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:26 help_keyword.MYI
-rwxrwxr-x 1 mysql mysql 5709 Dec 22 14:35 host.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:35 host.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:35 host.MYI
-rwxrwxr-x 1 mysql mysql 1629 Nov 24 2015 index_stats.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:26 index_stats.MYD
-rwxrwxr-x 1 mysql mysql 4096 Dec 22 14:26 index_stats.MYI
-rwxrwxr-x 1 mysql mysql 1890 Dec 22 14:35 innodb_index_stats.frm
-rwxrwxr-x 1 mysql mysql 491520 Dec 22 14:35 innodb_index_stats.ibd
-rwxrwxr-x 1 mysql mysql 2007 Dec 22 14:34 plugin.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:34 plugin.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:34 plugin.MYI
-rwxrwxr-x 1 mysql mysql 2703 Nov 24 2015 servers.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:18 servers.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:18 servers.MYI
-rwxrwxr-x 1 mysql mysql 1374 Nov 24 2015 table_stats.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:35 table_stats.MYD
-rwxrwxr-x 1 mysql mysql 2048 Dec 22 14:35 table_stats.MYI
-rwxrwxr-x 1 mysql mysql 1146 Nov 24 2015 time_zone_name.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:31 time_zone_name.MYD
-rwxrwxr-x 1 mysql mysql 1024 Dec 22 14:31 time_zone_name.MYI
-rwxrwxr-x 1 mysql mysql 11203 Dec 22 14:44 user.frm
-rwxrwxr-x 1 mysql mysql 0 Dec 22 14:44 user.MYD
-rwxrwxr-x 1 mysql mysql 2048 Dec 22 14:44 user.MYI

Comment by Elena Stepanova [ 2019-12-25 ]

So you indeed don't have mysql.db and some other system tables. Wherever this datadir came from, it's not valid 10.1 (or any other version that I would recognize).

Generated at Thu Feb 08 09:06:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.