Problem after upgrade to E0506P03

[Ricou69]

Hi,

After upgrading to E0506P03, my IMC can't start. I have 2 process which stay in "Starting" status : imcnetresdm.exe and imcvnmdm.exe.

Have you any solutions ?

[mschreiner]

Hello,

what Operating System and database do you use? (can be checked in the Enviroment Tab of the iDMA)

there is a problem with mysql 5.5 or lower

could you please attach the logfiles: $IMC/server/conf/log/imcnetresdm and imcvnmdm?

[Ricou69]

OS : Windows Servers 2012 R2

Db : MySQL 5.5.37

Here the two log :

- imcnetresdm (Network resource management) :

2017-12-15 08:31:42.312 [ERROR (1317)] [THREAD(4852)] [CQvDBConnADP::executeSQL] Execute "update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )" failed, errorMsg:Query execution was interrupted
2017-12-15 08:31:44.458 [ERROR (0)] [THREAD(4852)] [CDevMgr::checkRouteLinkFromPPPLink] qvdm::executeSQL error, and SQL is: update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )
2017-12-15 08:31:45.464 [WARNING (2003)] [THREAD(4852)] [CQvDBSelectorADP::reader] Execute "show fields from tbl_symbol" failed, errorMsg:Can't connect to MySQL server on '127.0.0.1' (10061)
2017-12-15 08:31:45.464 [ERROR (4)] [THREAD(4852)] [iMCKeyGenerator::getFirstColName()] read data from base error!
2017-12-15 08:31:45.464 [ERROR (4)] [THREAD(4852)] [iMCKeyGenerator::init()] Failed to call getFirstColName()
2017-12-15 08:31:45.464 [ERROR (4)] [THREAD(4852)] [iMCKeyGenerator::instance()] Failed to create key generator, table_name = tbl_symbol, db_type = 0
2017-12-15 08:31:45.464 [INFO (0)] [THREAD(4852)] exitAppError: serious error, exit...
2017-12-15 08:32:21.230 [INFO (0)] [THREAD(1948)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 08:32:21.690 [INFO (0)] [THREAD(1948)] [CQvApplication::start]  call globalInit().
2017-12-15 08:32:21.690 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 08:32:21.690 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 08:32:28.704 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 08:32:28.704 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 08:32:28.704 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 08:32:28.718 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 08:32:28.733 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 08:32:28.733 [INFO (0)] [THREAD(1948)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 08:32:28.733 [INFO (0)] [THREAD(1948)] [qvdm::setLogLevelFromDB] success, ProcID is 1, log level is 2
2017-12-15 08:32:28.733 [INFO (0)] [THREAD(1948)] [CQvApplication::globalInit]  finished.
2017-12-15 08:32:28.733 [INFO (0)] [THREAD(1948)] [CQvApplication::start]  call init().
2017-12-15 08:32:29.036 [ERROR (2003)] [THREAD(1948)] [CDevMgr::reSetDevRole] executeSQL() error.
2017-12-15 08:32:29.036 [ERROR (0)] [THREAD(1948)] [QvResourceApp::init] CDevMgr::reSetDevRole error.
2017-12-15 08:32:29.036 [ERROR (2003)] [THREAD(1948)] [CDevMgr::reSetTblDevUpServerField] executeSQL() error.
2017-12-15 08:32:29.036 [ERROR (0)] [THREAD(1948)] [QvResourceApp::init] CDevMgr::reSetTblDevUpServerField error.
2017-12-15 08:32:29.613 [INFO (0)] [THREAD(1948)] [CSymbolMgr::checkIntegrationTopo] no data, this is OK.
2017-12-15 08:32:29.613 [INFO (0)] [THREAD(1948)] [CDevMgr::reSetSmtpEncryptValue] No need to encrypt.
2017-12-15 08:42:28.275 [ERROR (1317)] [THREAD(1948)] [CQvDBConnADP::executeSQL] Execute "update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )" failed, errorMsg:Query execution was interrupted
2017-12-15 08:42:28.275 [ERROR (0)] [THREAD(1948)] [CDevMgr::checkRouteLinkFromPPPLink] qvdm::executeSQL error, and SQL is: update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )
2017-12-15 08:42:29.629 [WARNING (2003)] [THREAD(1948)] [CQvDBSelectorADP::reader] Execute "show fields from tbl_symbol" failed, errorMsg:Can't connect to MySQL server on '127.0.0.1' (10061)
2017-12-15 08:42:29.629 [ERROR (4)] [THREAD(1948)] [iMCKeyGenerator::getFirstColName()] read data from base error!
2017-12-15 08:42:29.629 [ERROR (4)] [THREAD(1948)] [iMCKeyGenerator::init()] Failed to call getFirstColName()
2017-12-15 08:42:29.629 [ERROR (4)] [THREAD(1948)] [iMCKeyGenerator::instance()] Failed to create key generator, table_name = tbl_symbol, db_type = 0
2017-12-15 08:42:29.629 [INFO (0)] [THREAD(1948)] exitAppError: serious error, exit...
2017-12-15 08:43:39.041 [INFO (0)] [THREAD(4116)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 08:43:39.181 [INFO (0)] [THREAD(4116)] [CQvApplication::start]  call globalInit().
2017-12-15 08:43:39.181 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 08:43:39.181 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [qvdm::setLogLevelFromDB] success, ProcID is 1, log level is 2
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::globalInit]  finished.
2017-12-15 08:43:40.197 [INFO (0)] [THREAD(4116)] [CQvApplication::start]  call init().
2017-12-15 08:43:41.806 [ERROR (2003)] [THREAD(4116)] [CDevMgr::reSetDevRole] executeSQL() error.
2017-12-15 08:43:41.806 [ERROR (0)] [THREAD(4116)] [QvResourceApp::init] CDevMgr::reSetDevRole error.
2017-12-15 08:43:41.806 [ERROR (2003)] [THREAD(4116)] [CDevMgr::reSetTblDevUpServerField] executeSQL() error.
2017-12-15 08:43:41.806 [ERROR (0)] [THREAD(4116)] [QvResourceApp::init] CDevMgr::reSetTblDevUpServerField error.
2017-12-15 08:43:42.025 [INFO (0)] [THREAD(4116)] [CSymbolMgr::checkIntegrationTopo] no data, this is OK.
2017-12-15 08:43:42.087 [INFO (0)] [THREAD(4116)] [CDevMgr::reSetSmtpEncryptValue] No need to encrypt.
2017-12-15 09:03:19.013 [INFO (0)] [THREAD(3492)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 09:03:19.587 [INFO (0)] [THREAD(3492)] [CQvApplication::start]  call globalInit().
2017-12-15 09:03:19.587 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 09:03:19.587 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 09:03:19.728 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 09:03:19.728 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 09:03:19.731 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 09:03:19.732 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 09:03:19.734 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 09:03:19.734 [INFO (0)] [THREAD(3492)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 09:03:19.734 [INFO (0)] [THREAD(3492)] [qvdm::setLogLevelFromDB] success, ProcID is 1, log level is 2
2017-12-15 09:03:19.735 [INFO (0)] [THREAD(3492)] [CQvApplication::globalInit]  finished.
2017-12-15 09:03:19.735 [INFO (0)] [THREAD(3492)] [CQvApplication::start]  call init().
2017-12-15 09:03:20.089 [ERROR (2003)] [THREAD(3492)] [CDevMgr::reSetDevRole] executeSQL() error.
2017-12-15 09:03:20.089 [ERROR (0)] [THREAD(3492)] [QvResourceApp::init] CDevMgr::reSetDevRole error.
2017-12-15 09:03:20.091 [ERROR (2003)] [THREAD(3492)] [CDevMgr::reSetTblDevUpServerField] executeSQL() error.
2017-12-15 09:03:20.091 [ERROR (0)] [THREAD(3492)] [QvResourceApp::init] CDevMgr::reSetTblDevUpServerField error.
2017-12-15 09:03:20.181 [INFO (0)] [THREAD(3492)] [CSymbolMgr::checkIntegrationTopo] no data, this is OK.
2017-12-15 09:03:20.184 [INFO (0)] [THREAD(3492)] [CDevMgr::reSetSmtpEncryptValue] No need to encrypt.
2017-12-15 09:04:11.021 [ERROR (1205)] [THREAD(3492)] [CQvDBConnADP::executeSQL] Execute "update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )" failed, errorMsg:Lock wait timeout exceeded; try restarting transaction
2017-12-15 09:04:11.022 [ERROR (0)] [THREAD(3492)] [CDevMgr::checkRouteLinkFromPPPLink] qvdm::executeSQL error, and SQL is: update tbl_link set link_type = 9 where link_id in ( select distinct t.link_id from (select tmp.* from tbl_link tmp)t  inner join(  select distinct t1.symbol_id,t1.phy_id from tbl_symbol t1  inner join tbl_ipaddress_info ip1  on t1.phy_id = ip1.dev_id  inner join tbl_if_info if1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex and ip1.net_mask != '255.255.255.252'  )t1_symbol_id  on  t1_symbol_id.symbol_id = t.left_symbol_id   inner join (  select  distinct if1.ifdesc,if1.ifindex,if1.dev_id from tbl_if_info if1  inner join tbl_ipaddress_info ip1  on ip1.dev_id = if1.dev_id and ip1.ifindex = if1.ifindex  inner join tbl_symbol t1  on t1.phy_id = ip1.dev_id  where  if1.iftype != 23 and if1.iftype != 39 and ip1.net_mask != '255.255.255.252'  )if_1_ifdesc  on  t.left_if_desc=if_1_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip1  on  t1_symbol_id.phy_id=ip1.dev_id  and if_1_ifdesc.dev_id=ip1.dev_id and if_1_ifdesc.ifindex=ip1.ifindex and ip1.net_mask != '255.255.255.252'   inner join (  select distinct t2.symbol_id,t2.phy_id from tbl_symbol t2  inner join tbl_ipaddress_info ip2  on t2.phy_id = ip2.dev_id  inner join tbl_if_info if2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex and ip2.net_mask != '255.255.255.252'  )t2_symbol_id  on  t2_symbol_id.symbol_id = t.right_symbol_id   inner join (  select distinct if2.ifdesc,if2.ifindex,if2.dev_id from tbl_if_info if2  inner join tbl_ipaddress_info ip2  on ip2.dev_id = if2.dev_id and ip2.ifindex = if2.ifindex  inner join tbl_symbol t2  on t2.phy_id = ip2.dev_id  where  if2.iftype != 23 and if2.iftype != 39 and ip2.net_mask != '255.255.255.252'  )if_2_ifdesc  on  t.right_if_desc=if_2_ifdesc.ifdesc   inner join  tbl_ipaddress_info ip2  on  t2_symbol_id.phy_id  =ip2.dev_id  and if_2_ifdesc.dev_id=ip2.dev_id and if_2_ifdesc.ifindex=ip2.ifindex and ip2.net_mask != '255.255.255.252'   and t.link_type = 0 and t.flag_by_user_in_overall != 2 )
2017-12-15 09:04:15.447 [WARNING (0)] [THREAD(3492)] [CQvDBConnADP::executeSQL] Execute "update tbl_snmppara_template set template_type = 1 where snmp_version != 3 and template_type = 0 and snmp_id in (select snmp_id from tbl_dev_accesspara)", Wrong TransCount =0
2017-12-15 09:04:15.745 [WARNING (0)] [THREAD(3492)] [CQvDBConnADP::executeSQL] Execute "update tbl_sshpara_template set ssh_template_type = 1 where  ssh_template_type = 0 and ssh_id in (select ssh_id from tbl_dev_accesspara)", Wrong TransCount =0
2017-12-15 09:04:16.035 [WARNING (0)] [THREAD(3492)] [CQvDBConnADP::executeSQL] Execute "update tbl_telnetpara_template set template_type = 1 where  template_type = 0 and telnet_id in (select telnet_id from tbl_dev_accesspara)", Wrong TransCount =0
2017-12-15 09:04:32.643 [ERROR (1317)] [THREAD(3492)] [CQvDBConnADP::executeSQL] Execute "update tbl_if_info set ifAlarmStatus = 4" failed, errorMsg:Query execution was interrupted
2017-12-15 09:04:32.646 [ERROR (0)] [THREAD(3492)] in CDevMgr::initLinkFault ,update if status db error ! SQL = update tbl_if_info set ifAlarmStatus = 4
2017-12-15 09:04:32.648 [FATAL (2002)] [THREAD(3492)] [QvResourceApp::init] CDevMgr::initLinkFault() error, and application exit!
2017-12-15 09:05:12.784 [INFO (0)] [THREAD(4092)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 09:05:13.066 [INFO (0)] [THREAD(4092)] [CQvApplication::start]  call globalInit().
2017-12-15 09:05:13.066 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 09:05:13.066 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [qvdm::setLogLevelFromDB] success, ProcID is 1, log level is 2
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::globalInit]  finished.
2017-12-15 09:05:13.269 [INFO (0)] [THREAD(4092)] [CQvApplication::start]  call init().
2017-12-15 09:05:14.473 [ERROR (2003)] [THREAD(4092)] [CDevMgr::reSetDevRole] executeSQL() error.
2017-12-15 09:05:14.473 [ERROR (0)] [THREAD(4092)] [QvResourceApp::init] CDevMgr::reSetDevRole error.
2017-12-15 09:05:14.489 [ERROR (2003)] [THREAD(4092)] [CDevMgr::reSetTblDevUpServerField] executeSQL() error.
2017-12-15 09:05:14.489 [ERROR (0)] [THREAD(4092)] [QvResourceApp::init] CDevMgr::reSetTblDevUpServerField error.
2017-12-15 09:05:14.583 [INFO (0)] [THREAD(4092)] [CSymbolMgr::checkIntegrationTopo] no data, this is OK.
2017-12-15 09:05:14.583 [INFO (0)] [THREAD(4092)] [CDevMgr::reSetSmtpEncryptValue] No need to encrypt.

[Ricou69]

And  imcvnmdm (Virtual network management) :

2017-12-15 08:32:27.261 [INFO (0)] [THREAD(4832)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 08:32:27.535 [ERROR (-100)] [THREAD(4832)] [qvdm::getComponentAddress] Can't get DB information for iMC-CSM.
2017-12-15 08:32:27.535 [ERROR (-100)] [THREAD(4832)] [qvdm::getComponentAddress] Can't get DB information for iMC-CRM.
2017-12-15 08:32:27.535 [ERROR (-100)] [THREAD(4832)] [qvdm::getComponentAddress] Can't get DB information for iMC-RAM.
2017-12-15 08:32:27.535 [ERROR (-100)] [THREAD(4832)] [qvdm::getComponentAddress] Can't get DB information for openstack-nova.
2017-12-15 08:32:27.535 [ERROR (-100)] [THREAD(4832)] [qvdm::getComponentAddress] Can't get DB information for openstack-cinder.
2017-12-15 08:32:27.535 [INFO (0)] [THREAD(4832)] [CQvApplication::start]  call globalInit().
2017-12-15 08:32:27.535 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 08:32:27.535 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 08:32:35.999 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 08:32:35.999 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 08:32:36.100 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 08:32:36.143 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] [qvdm::setLogLevelFromDB] success, ProcID is 58, log level is 2
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] [CQvApplication::globalInit]  finished.
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] [CQvApplication::start]  call init().
2017-12-15 08:32:36.216 [INFO (0)] [THREAD(4832)] CVnmMainApp::waitProcStart waiting for the process starting, procID: 1
2017-12-15 08:43:40.384 [INFO (0)] [THREAD(4364)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 08:43:41.056 [ERROR (-100)] [THREAD(4364)] [qvdm::getComponentAddress] Can't get DB information for iMC-CSM.
2017-12-15 08:43:41.056 [ERROR (-100)] [THREAD(4364)] [qvdm::getComponentAddress] Can't get DB information for iMC-CRM.
2017-12-15 08:43:41.056 [ERROR (-100)] [THREAD(4364)] [qvdm::getComponentAddress] Can't get DB information for iMC-RAM.
2017-12-15 08:43:41.056 [ERROR (-100)] [THREAD(4364)] [qvdm::getComponentAddress] Can't get DB information for openstack-nova.
2017-12-15 08:43:41.072 [ERROR (-100)] [THREAD(4364)] [qvdm::getComponentAddress] Can't get DB information for openstack-cinder.
2017-12-15 08:43:41.087 [INFO (0)] [THREAD(4364)] [CQvApplication::start]  call globalInit().
2017-12-15 08:43:41.087 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 08:43:41.087 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 08:43:42.744 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 08:43:42.744 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 08:43:42.791 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 08:43:42.791 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] [qvdm::setLogLevelFromDB] success, ProcID is 58, log level is 2
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] [CQvApplication::globalInit]  finished.
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] [CQvApplication::start]  call init().
2017-12-15 08:43:42.806 [INFO (0)] [THREAD(4364)] CVnmMainApp::waitProcStart waiting for the process starting, procID: 1
2017-12-15 09:03:33.138 [INFO (0)] [THREAD(8604)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 09:03:33.830 [ERROR (-100)] [THREAD(8604)] [qvdm::getComponentAddress] Can't get DB information for iMC-CSM.
2017-12-15 09:03:33.830 [ERROR (-100)] [THREAD(8604)] [qvdm::getComponentAddress] Can't get DB information for iMC-CRM.
2017-12-15 09:03:33.831 [ERROR (-100)] [THREAD(8604)] [qvdm::getComponentAddress] Can't get DB information for iMC-RAM.
2017-12-15 09:03:33.831 [ERROR (-100)] [THREAD(8604)] [qvdm::getComponentAddress] Can't get DB information for openstack-nova.
2017-12-15 09:03:33.832 [ERROR (-100)] [THREAD(8604)] [qvdm::getComponentAddress] Can't get DB information for openstack-cinder.
2017-12-15 09:03:33.832 [INFO (0)] [THREAD(8604)] [CQvApplication::start]  call globalInit().
2017-12-15 09:03:33.832 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 09:03:33.832 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 09:03:34.050 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 09:03:34.050 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 09:03:34.052 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 09:03:34.054 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 09:03:34.055 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 09:03:34.056 [INFO (0)] [THREAD(8604)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 09:03:34.056 [INFO (0)] [THREAD(8604)] [qvdm::setLogLevelFromDB] success, ProcID is 58, log level is 2
2017-12-15 09:03:34.056 [INFO (0)] [THREAD(8604)] [CQvApplication::globalInit]  finished.
2017-12-15 09:03:34.056 [INFO (0)] [THREAD(8604)] [CQvApplication::start]  call init().
2017-12-15 09:03:34.056 [INFO (0)] [THREAD(8604)] CVnmMainApp::waitProcStart waiting for the process starting, procID: 1
2017-12-15 09:04:00.740 [INFO (0)] [THREAD(1632)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 09:04:01.505 [ERROR (-100)] [THREAD(1632)] [qvdm::getComponentAddress] Can't get DB information for iMC-CSM.
2017-12-15 09:04:01.506 [ERROR (-100)] [THREAD(1632)] [qvdm::getComponentAddress] Can't get DB information for iMC-CRM.
2017-12-15 09:04:01.507 [ERROR (-100)] [THREAD(1632)] [qvdm::getComponentAddress] Can't get DB information for iMC-RAM.
2017-12-15 09:04:01.508 [ERROR (-100)] [THREAD(1632)] [qvdm::getComponentAddress] Can't get DB information for openstack-nova.
2017-12-15 09:04:01.509 [ERROR (-100)] [THREAD(1632)] [qvdm::getComponentAddress] Can't get DB information for openstack-cinder.
2017-12-15 09:04:01.509 [INFO (0)] [THREAD(1632)] [CQvApplication::start]  call globalInit().
2017-12-15 09:04:01.509 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 09:04:01.509 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 09:04:01.692 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 09:04:01.693 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 09:04:01.693 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 09:04:01.694 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 09:04:01.696 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 09:04:01.697 [INFO (0)] [THREAD(1632)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 09:04:01.697 [INFO (0)] [THREAD(1632)] [qvdm::setLogLevelFromDB] success, ProcID is 58, log level is 2
2017-12-15 09:04:01.697 [INFO (0)] [THREAD(1632)] [CQvApplication::globalInit]  finished.
2017-12-15 09:04:01.697 [INFO (0)] [THREAD(1632)] [CQvApplication::start]  call init().
2017-12-15 09:04:01.697 [INFO (0)] [THREAD(1632)] CVnmMainApp::waitProcStart waiting for the process starting, procID: 1
2017-12-15 09:05:15.553 [INFO (0)] [THREAD(4592)] [qvdm::QvGetLogFileSize] get file size from qvdm.conf: 50
2017-12-15 09:05:16.397 [ERROR (-100)] [THREAD(4592)] [qvdm::getComponentAddress] Can't get DB information for iMC-CSM.
2017-12-15 09:05:16.397 [ERROR (-100)] [THREAD(4592)] [qvdm::getComponentAddress] Can't get DB information for iMC-CRM.
2017-12-15 09:05:16.397 [ERROR (-100)] [THREAD(4592)] [qvdm::getComponentAddress] Can't get DB information for iMC-RAM.
2017-12-15 09:05:16.397 [ERROR (-100)] [THREAD(4592)] [qvdm::getComponentAddress] Can't get DB information for openstack-nova.
2017-12-15 09:05:16.397 [ERROR (-100)] [THREAD(4592)] [qvdm::getComponentAddress] Can't get DB information for openstack-cinder.
2017-12-15 09:05:16.397 [INFO (0)] [THREAD(4592)] [CQvApplication::start]  call globalInit().
2017-12-15 09:05:16.397 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit] CImfAppMgr::instance() begin.
2017-12-15 09:05:16.397 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit] initAppMgr begin.
2017-12-15 09:05:22.262 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit] QvGetResPath begin.
2017-12-15 09:05:22.262 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit] initResMgr begin.
2017-12-15 09:05:22.278 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit]  CQvSnmpEnv::poInstance.
2017-12-15 09:05:22.278 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit]  CSysGlobalVar::instance().
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit]  CQvSysTaskMgr::addTaskMgr.
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] [qvdm::setLogLevelFromDB]set log level to :2
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] [qvdm::setLogLevelFromDB] success, ProcID is 58, log level is 2
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] [CQvApplication::globalInit]  finished.
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] [CQvApplication::start]  call init().
2017-12-15 09:05:23.561 [INFO (0)] [THREAD(4592)] CVnmMainApp::waitProcStart waiting for the process starting, procID: 1

[mschreiner]

the best (and maybe the only solution) would be to update the mysql to 5.6

[Ricou69]

How can i upgrade to MySQL 5.6 ?

[NeilR]

I had the same problems after upgrading - there is a sql query running that never finishes (at least in the hours I waited).

I tried upgrading to MySql 5.6 before upgrading IMC but I couldn't get it to work. The IMC upgrade wouldn't run. Some security issue. Tried exporting and then reapplying the credentials - no luck. Never got any further with the 5.6 upgrade process.

You can kill the query and the processes will start, but next reboot it will run again.

I just opened a case with HPE.  The response was that this patch has enough issues that unless you actually need a fix, you are better off to wait for the next one due out early next year - I got the impression January, but I wasn't given a date.

Hopefully you can revert. If you don't desparately need P03 then don't even bother. 

[Ricou69]

Yes,

I had to restore my VM before the upgrade to come back to the 7.3 version then i restored the database at the anterior date (if not IMC doens't work).

I will wait to the new patch.