0 Replies Latest reply: Mar 20, 2013 4:42 AM by user1741129 RSS

    Cleaning VM Manager MySQL Database

    user1741129
      Hi,
      I am looking to clean a server pool completely and recreate it after some issues with heartbeating caused by a network fault caused all sorts of heartbeat / config problems. Have been working through a fix with Oracle support and have cleaned all VM servers in the pool.

      The next step as advised by support is to clean the vm database using the the ovm_upgrade.sh script:
      sh ./ovm_upgrade.sh dbuser=<user> dbpass=<passwd> dbhost=<hostname> dbport=1521 dbsid=<sid> deletedb

      This fails when i run it with message:
      "2013-03-20 09:24:34,847 ERROR Failed to connect to Database! Error: **
      java.lang.StringIndexOutOfBoundsException: String index out of range: 14137"

      The dbport number provided hints that this script is for an Oracle database which may be what is causing the error. Does anyone have any advice on cleaning the Oracle VM Manager db when using a mysql database?

      We are running Oracle VM manager 3.2.1 on Scientific Linux release 6.3 (Carbon) x86_64.

      Thanks,