Hi All, I restored the mysql database and run the onedb fsck, still the process terminate with "Error running fsck version 4.2.0" but the messages of the inconsistency is less. Appreciate the expert help on this.
Note: We are still using 4.2 because we have our own apps integrated with it. We already have plan to setup another ONE with version 4.10 -- Regards, Anandharaj MIMOS Bhd From: Anandharaj Subramaniam Sent: Monday, December 29, 2014 3:36 PM To: users@lists.opennebula.org Subject: RE: Image in used state but no VM associte with it Hi All, When I run onedb fck, got the following messages but ended with error. [oneadmin@server 101]$ onedb fsck -f -S localhost -u oneadmin -d opennebula MySQL Password: MySQL dump stored in /var/lib/one/mysql_localhost_opennebula.sql Use 'onedb restore' or restore the DB using the mysql command: mysql -u user -h server -P port db_name < backup_file Host 20 is in Cluster 101 host id list, but it should not VM 373 is using Host 20, but it does not exist VM 401 is using Host 20, but it does not exist VM 522 is using Host 20, but it does not exist VM 531 is using Host 20, but it does not exist VM 585 is using Host 20, but it does not exist VM 612 is using Host 20, but it does not exist VM 655 is using Host 20, but it does not exist VM 705 is using Host 20, but it does not exist VM 763 is using Host 20, but it does not exist VM 787 is using Host 20, but it does not exist VM 797 is using Host 20, but it does not exist VM 828 is using Host 20, but it does not exist VM 964 is using Host 20, but it does not exist VM 1065 is using Host 20, but it does not exist VM 1070 is using Host 20, but it does not exist VM 1199 is using Host 20, but it does not exist VM 1211 is using VNet 121, but it does not exist VM 1216 is using VNet 121, but it does not exist VM 1243 is using Host 20, but it does not exist VM 1250 is using Host 20, but it does not exist Host 0 RUNNING_VMS has 11 is 9 VM 105 is in Host 0 VM id list, but it should not VM 106 is in Host 0 VM id list, but it should not Host 0 CPU_USAGE has 2000 is 1400 Host 0 MEM_USAGE has 92274688 is 71303168 Host 17 RUNNING_VMS has 20 is 19 VM 533 is in Host 17 VM id list, but it should not Host 17 CPU_USAGE has 2050 is 1950 Host 17 MEM_USAGE has 102760448 is 98566144 Host 22 RUNNING_VMS has 21 is 19 VM 618 is in Host 22 VM id list, but it should not VM 620 is in Host 22 VM id list, but it should not Host 22 CPU_USAGE has 3600 is 3400 Host 22 MEM_USAGE has 125829120 is 117440512 Host 14 RUNNING_VMS has 19 is 17 VM 461 is in Host 14 VM id list, but it should not VM 632 is in Host 14 VM id list, but it should not Host 14 CPU_USAGE has 2450 is 2150 Host 14 MEM_USAGE has 90177536 is 73400320 Host 19 RUNNING_VMS has 30 is 28 VM 438 is in Host 19 VM id list, but it should not VM 630 is in Host 19 VM id list, but it should not Host 19 CPU_USAGE has 3950 is 3800 Host 19 MEM_USAGE has 174063616 is 164626432 Host 18 CPU_USAGE has 3330 is 3329 Host 23 RUNNING_VMS has 24 is 22 VM 462 is in Host 23 VM id list, but it should not VM 707 is in Host 23 VM id list, but it should not Host 23 CPU_USAGE has 3500 is 3100 Host 23 MEM_USAGE has 156237824 is 139460608 Host 31 CPU_USAGE has 4460 is 4459 Image 55 RUNNING_VMS has 1 is 0 VM 106 is in Image 55 VM id list, but it should not Image 55 has STATE USED_PERS is READY Image 195 RUNNING_VMS has 1 is 0 VM 106 is in Image 195 VM id list, but it should not Image 195 has STATE USED_PERS is READY Image 374 RUNNING_VMS has 1 is 0 VM 438 is in Image 374 VM id list, but it should not Image 374 has STATE USED_PERS is READY Image 464 RUNNING_VMS has 1 is 0 VM 533 is in Image 464 VM id list, but it should not Image 464 has STATE USED_PERS is READY Image 490 RUNNING_VMS has 1 is 0 VM 533 is in Image 490 VM id list, but it should not Image 490 has STATE USED_PERS is READY Image 1131 RUNNING_VMS has 1 is 0 VM 1247 is in Image 1131 VM id list, but it should not Image 1131 has STATE USED_PERS is READY VNet 2 has used lease 10.4.135.9 (VM 106) but it is free VNet 25 has used lease 10.1.66.6 (VM 1247) but it is free VNet 25 has used lease 10.1.66.8 (VM 858) but it is free VNet 63 has used lease 10.1.66.85 (VM 533) but it is free address family mismatch Error running fsck version 4.2.0 The database will be restored -- Regards, Anandharaj From: Anandharaj Subramaniam Sent: Monday, December 29, 2014 10:23 AM To: users@lists.opennebula.org<mailto:users@lists.opennebula.org> Subject: Image in used state but no VM associte with it Hi All, Im having an issue whereby the image in USED_PERS state but there is no VM running on it. There was some issue with ON server therefore I run MYSQL repair. After that notice this issue. I ssh into the VM and already shutdown but in ON still shows as USED_PERS. Is there anyway I can change this in MySQL? -- Regards, Anandharaj ________________________________ DISCLAIMER: This e-mail (including any attachments) is for the addressee(s) only and may be confidential, especially as regards personal data. If you are not the intended recipient, please note that any dealing, review, distribution, printing, copying or use of this e-mail is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original message (including any attachments). MIMOS Berhad is a research and development institution under the purview of the Malaysian Ministry of Science, Technology and Innovation. Opinions, conclusions and other information in this e-mail that do not relate to the official business of MIMOS Berhad and/or its subsidiaries shall be understood as neither given nor endorsed by MIMOS Berhad and/or its subsidiaries and neither MIMOS Berhad nor its subsidiaries accepts responsibility for the same. All liability arising from or in connection with computer viruses and/or corrupted e-mails is excluded to the fullest extent permitted by law.
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
