stonedb icon indicating copy to clipboard operation
stonedb copied to clipboard

question: mysqld start failed when first executing install

Open hustjieke opened this issue 2 years ago • 2 comments

Describe the problem

When execute install.sh, got invalid user: mysql:

220621 01:39:39 mysqld_safe Logging to '/stonedb56/install/log/mysqld.log'.
chown: invalid user: ‘mysql’
220621 01:39:40 mysqld_safe Starting mysqld daemon with databases from /stonedb56/install/data
220621 01:39:40 mysqld_safe mysqld from pid file /stonedb56/install/data/mysqld.pid ended

mysqld log:

2022-06-21 01:39:40 0 [Note] /stonedb56/install//bin/mysqld (mysqld 5.6.24-StoneDB-debug-log) starting as process 207860 ...
2022-06-21 01:39:40 207860 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2022-06-21 01:39:40 207860 [ERROR] Aborting

Expected behavior

How To Reproduce

Do install.sh after first build stonedb.

Environment

  • OS: ubuntu 20.04

Additional context

hustjieke avatar Jun 21 '22 01:06 hustjieke

In MySQL docs: https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

$> groupadd mysql
$> useradd -r -g mysql -s /bin/false mysql

hustjieke avatar Jun 21 '22 03:06 hustjieke

After useradd mysql, exeute install.sh again, mysqld start successfully, but got error log in mysqld.log and stonedb.log:

2022-06-21 03:10:40 213294 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2022-06-21 03:10:40 213294 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2022-06-21 03:10:40 213294 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2022-06-21 03:10:40 213294 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure

hustjieke avatar Jun 21 '22 03:06 hustjieke