石家庄物流网站建设,做网站租用数据库,网站质量需求,单一页面网站怎么做省流#xff1a;
挂载的话#xff0c;使用 /etc/fstab
放fstab里会在程序启动前加载NFS文件系统#xff0c;放rc.local里往往造成程序启动加载时找不到路径。 正文#xff1a;
在企业中#xff0c;服务器重启#xff0c;有时候会遇到mysql 启动报错 Cant change dir …省流
挂载的话使用 /etc/fstab
放fstab里会在程序启动前加载NFS文件系统放rc.local里往往造成程序启动加载时找不到路径。 正文
在企业中服务器重启有时候会遇到mysql 启动报错 Cant change dir to xxx, No such file or directory。大致意思是无法将目录换成xxx因为没有这个目录。
原因通常是配置文件配置的目录有问题或者挂载盘加载慢于mysql启动mysql的data数据放在挂载盘里
linux中配置文件是my.cnf通常路径是 /etc/my.cnf
windows中配置文件是my.ini
mysql配置文件大致内容如下
# mysql路径
basedir/sata09/data/mysql
# mysql存数据的路径
datadir/sata09/data/mysql/data
这篇文章以挂载问题导致为例。
挂载有两种rc.localfstab。
推荐使用fstab。原因如下 开机挂载mount/etc/fstab 与 /etc/rc.d/rc.local 差不多差别就是如果你有程序依赖于NFS的话还是放到fstab比较好。程序启动先加载 /etc/fastab 文件。 放fstab里会在程序启动前加载NFS文件系统放rc.local里往往造成程序启动加载时找不到路径。 我之前的挂载命令是放在 /etc/rc.local现在改成放在 /etc/fstab
mount /prd/ssd/ssd01 /ssd01
mount /prd/sata/sata01 /sata01 详细日志如下
Oct 17 02:50:32 ali5messrv1 mysqld: mysqld: Cant change dir to /sata09/data/mysql/ (Errcode: 2 - No such file or directory)
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060197Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060311Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060344Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-log) starting as process 3280 ...
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060369Z 0 [ERROR] Cant find error-message file /sata09/data/mysql/share/mysql/errmsg.sys. Check error-message file location and lc-messages-dir configuration directive.
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060943Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060950Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060990Z 0 [ERROR] failed to set datadir to /sata09/data/mysql/
Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060998Z 0 [ERROR] AbortingOct 17 02:50:32 ali5messrv1 systemd[1]: Starting MySQL Server...
Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: mysqld: Cant create directory /sata09/data/mysql/ (Errcode: 2 - No s...tory)
Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867006Z 0 [Warning] TIMESTAMP with implicit DEFAULT...ils).
Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867111Z 0 [ERROR] Cant find error-message file /s...tive.
Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867941Z 0 [ERROR] Aborting
Oct 17 02:52:03 ali5messrv1 systemd[1]: Started MySQL Server. 开机挂载mount etc/fstab与/etc/rc.d/rc.local区别-阿里云开发者社区 分割线
文章到此已结束以下是紫薯布丁 Oct 17 02:50:32 ali5messrv1 mysqld: mysqld: Cant change dir to /sata09/data/mysql/ (Errcode: 2 - No such file or directory) Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060197Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060311Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060344Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-log) starting as process 3280 ... Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060369Z 0 [ERROR] Cant find error-message file /sata09/data/mysql/share/mysql/errmsg.sys. Check error-message file location and lc-messages-dir configuration directive. Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060943Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060950Z 0 [Warning] Cant create test file /sata09/data/mysql/ali5messrv1.lower-test Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060990Z 0 [ERROR] failed to set datadir to /sata09/data/mysql/ Oct 17 02:50:32 ali5messrv1 mysqld: 2023-10-16T18:50:32.060998Z 0 [ERROR] Aborting
Oct 17 02:50:32 ali5messrv1 systemd[1]: Starting MySQL Server... Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: mysqld: Cant create directory /sata09/data/mysql/ (Errcode: 2 - No s...tory) Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867006Z 0 [Warning] TIMESTAMP with implicit DEFAULT...ils). Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867111Z 0 [ERROR] Cant find error-message file /s...tive. Oct 17 02:50:32 ali5messrv1 mysqld_pre_systemd[2476]: 2023-10-16T18:50:32.867941Z 0 [ERROR] Aborting Oct 17 02:52:03 ali5messrv1 systemd[1]: Started MySQL Server.
