Raspberry Pi - MySQL Could Not Be Started

2 posts / 0 new
Last post
W7SOE
Raspberry Pi - MySQL Could Not Be Started

I installed CQRLOG on a freshly updated raspi. I get the MySQL error on startup. Here is the error log:

2021-01-08 14:13:50 1996128048 [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.

2021-01-08 14:13:50 1996128048 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-01-08 14:13:50 1996128048 [Note] InnoDB: The InnoDB memory heap is disabled
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-01-08 14:13:50 1996128048 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Compressed tables use zlib 1.2.8
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Using Linux native AIO
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Using generic crc32 instructions
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Completed initialization of buffer pool
2021-01-08 14:13:50 1996128048 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2021-01-08 14:13:50 1996128048 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2021-01-08 14:13:53 1996128048 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2021-01-08 14:14:04 1996128048 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2021-01-08 14:14:12 1996128048 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-01-08 14:14:12 1996128048 [Warning] InnoDB: New log files created, LSN=45780
2021-01-08 14:14:12 1996128048 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-01-08 14:14:13 1996128048 [Note] InnoDB: Doublewrite buffer created
2021-01-08 14:14:14 1996128048 [Note] InnoDB: 128 rollback segment(s) are active.
2021-01-08 14:14:14 1996128048 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-01-08 14:14:14 1996128048 [Note] InnoDB: Foreign key constraint system tables created
2021-01-08 14:14:14 1996128048 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-01-08 14:14:14 1996128048 [Note] InnoDB: Tablespace and datafile system tables created.
2021-01-08 14:14:14 1996128048 [Note] InnoDB: Waiting for purge to start
2021-01-08 14:14:14 1996128048 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 0
2021-01-08 14:14:15 1371534144 [Note] InnoDB: Dumping buffer pool(s) not yet started
2021-01-08 14:14:15 1996128048 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-08 14:14:15 1996128048 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-01-08 14:14:15 1996128048 [Note] Server socket created on IP: '::'.
2021-01-08 14:14:15 1996128048 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2021-01-08 14:14:15 1971315520 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2021-01-08 14:14:15 1996128048 [Note] Reading of all Master_info entries succeeded
2021-01-08 14:14:15 1996128048 [Note] Added new Master_info '' to hash table
2021-01-08 14:14:15 1996128048 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.47-MariaDB-0+deb9u1' socket: '/home/pi/.config/cqrlog/database/sock' port: 64000 Raspbian 9.11

I appreciate any help.

Thanks
Rich

oh1kh
Raspberry Pi - MySQL Could Not Be Started

Hi Rich!

I do not see any special there.
If you start cqrlog from console with

cqrlog debug=1 > /tmp/debug.txt

What can be found from file /tmp/debug.txt when cqrlog stops?

--
Saku
OH1KH