Forum Stats

  • 3,769,816 Users
  • 2,253,026 Discussions
  • 7,875,216 Comments

Discussions

OVMM_MYSQL failed to start

After a sudden power outage, my ovm manager failed to come up after restarting the system. Manually starting the ovm service resulted in Error: ovmm_mysql service is not running. Starting the ovmm_mysql service showed "Starting OVMM MySQL.....The server quit without updating PI[FAILED]/u01/app/oracle/mysql/data/mysqld.pid)."

I checked the database log files and i saw

2021-08-19 12:38:27 2183 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation

2021-08-19 13:06:27 3949 [Note] Plugin 'FEDERATED' is disabled.

2021-08-19 13:06:27 3949 [Note] InnoDB: Using atomics to ref count buffer pool pages

2021-08-19 13:06:27 3949 [Note] InnoDB: The InnoDB memory heap is disabled

2021-08-19 13:06:27 3949 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2021-08-19 13:06:27 3949 [Note] InnoDB: Memory barrier is not used

2021-08-19 13:06:27 3949 [Note] InnoDB: Compressed tables use zlib 1.2.3

2021-08-19 13:06:27 3949 [Note] InnoDB: Using Linux native AIO

2021-08-19 13:06:27 3949 [Note] InnoDB: Using CPU crc32 instructions

2021-08-19 13:06:27 3949 [Note] InnoDB: Initializing buffer pool, size = 1.0G

2021-08-19 13:06:27 3949 [Note] InnoDB: Completed initialization of buffer pool

2021-08-19 13:06:27 3949 [Note] InnoDB: Highest supported file format is Barracuda.

2021-08-19 13:06:27 3949 [Note] InnoDB: Log scan progressed past the checkpoint lsn 452821518810

2021-08-19 13:06:27 3949 [Note] InnoDB: Database was not shutdown normally!

2021-08-19 13:06:27 3949 [Note] InnoDB: Starting crash recovery.

2021-08-19 13:06:27 3949 [Note] InnoDB: Reading tablespace information from the .ibd files...

2021-08-19 13:06:28 3949 [Note] InnoDB: Restoring possible half-written data pages

2021-08-19 13:06:28 3949 [Note] InnoDB: from the doublewrite buffer...

2021-08-19 13:06:31 3949 [ERROR] InnoDB: Error in system call pread(). The operating system error number is 5.

2021-08-19 13:06:31 7f182a16c720 InnoDB: Operating system error number 5 in a file operation.

InnoDB: Error number 5 means 'Input/output error'.

InnoDB: Some operating system error numbers are described at

InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html

2021-08-19 13:06:31 3949 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation



Kindly advice on what to do as no backup of the database exists.