stonedb
stonedb copied to clipboard
question: mysqld start failed when first executing install
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
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
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