Author Topic: mysql error  (Read 783 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
mysql error
« on: May 06, 2020, 07:37:15 PM »

May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 7f26b8d75900  InnoDB: Operating system error number 1 in a file operation.
May  6 19:28:40 server mysqld: InnoDB: Error number 1 means 'Operation not permitted'.
May  6 19:28:40 server mysqld: InnoDB: Some operating system error numbers are described at
May  6 19:28:40 server mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] InnoDB: Can't open './ibdata1'
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] Plugin 'InnoDB' init function returned error.
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [Note] Plugin 'FEEDBACK' is disabled.
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] Unknown/unsupported storage engine: InnoDB
May  6 19:28:40 server mysqld: 2020-05-06 19:28:40 139804286605568 [ERROR] Aborting
May  6 19:28:40 server systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE
May  6 19:28:40 server systemd: Failed to start MariaDB 10.1.44 database server.
May  6 19:28:40 server systemd: Unit mariadb.service entered failed state.
May  6 19:28:40 server systemd: mariadb.service failed.
May  6 19:28:42 server kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:50:56:b5:fa:54:08:00 SRC=80.211.41.53 DST=80.211.41.255 LEN=72 TOS=0x00 PREC=0x00 TTL=64 ID=4990 DF PROTO=UDP SPT=57621 DPT=57621 LEN=52

Offline
***
Re: mysql error
« Reply #1 on: May 06, 2020, 09:32:46 PM »
Possible that mariadb failed to completely shut down an old instance.
try:

systemctl stop mysqld
ps aux | grep mysql
kill (any PID's that appear)
systemctl start mysqld

Google Hangouts:  rcschaff82@gmail.com

Offline
*****
Re: mysql error
« Reply #2 on: May 07, 2020, 10:43:47 AM »
seems mysql crashed what task done before ?