ovftools and database problem

darantasia — Thu, 30 Mar 2023 13:18:22 GMT

Migration from VMWare to proxmox with ovftools leaves mysql database stucked at launch

Hello everyone,

i'm currently migrating from VMware to proxmox all my prod VMs with ovftools.

I have successfully migrated a lot of ubuntu VM with a mysql database. But today i'm migrating one and after the following steps :

1/ ovftool vi://root@server.esx.fr/VM-prod /mnt/pve/NFS_SHARE/template/iso/

2/ qm importovf 128 /mnt//pve/srv-echange-OS-PVE/template/iso/VM-prod/VM-prod.ovf DELL_ARRAY --format raw

at reboot after correcting the ethernet interfaces, mysql server fails :

mysql logs :

2023-03-29T09:52:59.064380Z 0 [Note] InnoDB: Uses event mutexes 2023-03-29T09:52:59.064385Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2023-03-29T09:52:59.064389Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2023-03-29T09:52:59.064397Z 0 [Note] InnoDB: Using Linux native AIO 2023-03-29T09:52:59.064607Z 0 [Note] InnoDB: Number of pools: 1 2023-03-29T09:52:59.064702Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2023-03-29T09:52:59.066061Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2023-03-29T09:52:59.073160Z 0 [Note] InnoDB: Completed initialization of buffer pool 2023-03-29T09:52:59.074864Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-03-29T09:52:59.086159Z 0 [ERROR] InnoDB: Checksum mismatch in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2023-03-29T09:52:59.086198Z 0 [Note] InnoDB: Restoring page [page id: space=0, page number=0] of datafile './ibdata1' from the doublewrite buffer. Writing 16384 bytes into file './ibdata1' 2023-03-29T09:52:59.086294Z 0 [ERROR] InnoDB: Checksum mismatch in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2023-03-29T09:52:59.086305Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2023-03-29T09:52:59.686920Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-03-29T09:52:59.686987Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-03-29T09:52:59.687013Z 0 [ERROR] Failed to initialize builtin plugins. 2023-03-29T09:52:59.687066Z 0 [ERROR] Aborting

I tried some innodb repairs without success. Do you have an idea of what is happening ? Am I doing something wrong ? What can differ from the other servers than migrated without any problems?

Thank you for your help

topic ovftools and database problem in Technical Community Resources and Help Discussions

ovftools and database problem

Migration from VMWare to proxmox with ovftools leaves mysql database stucked at launch