VMware Communities
darantasia
Contributor
Contributor

ovftools and database problem

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

0 Kudos
0 Replies