<YYYY-MM-DD>T<time> UTC 54fb95c7.64e8 0 VCDB postgres STATEMENT: select count(*) from VPX_STAT_hist1_1;</time><YYYY-MM-DD>T<time></time> UTC 54fb58ff.36f5 0 VCDB vc LOG: duration: 17195501.642 ms statement: DO$$DECLARE r RECORD;DECLARE sql_stmt VARCHAR;BEGINFOR r IN SELECT table_nameFROM information_schema.tablesWHERE UPPER(table_name) LIKE 'VPX_HIST_STAT%'AND table_type = 'BASE TABLE'LOOPsql_stmt = 'INSERT INTO ' || r.table_name || ' SELECT INSERTED.COUNTER_ID,HS.TIME_ID,';sql_stmt = sql_stmt || 'SUM(STAT_VAL) ';sql_stmt = sql_stmt || ' FROM ' || r.table_name || ' HS';sql_stmt = sql_stmt || ' INNER JOIN VPX_STAT_COUNTER SC ON HS.COUNTER_ID = SC.COUNTER_ID ';sql_stmt = sql_stmt || ' INNER JOIN VPX_DEVICE D ON SC.DEVICE_ID=D.DEVICE_ID ';sql_stmt = sql_stmt || ' INNER JOIN VPX_OBJECT_HIERARCHY H ON SC.ENTITY_ID = H.STAT_ENTITY_ID ';sql_stmt = sql_stmt || ' INNER JOIN (SELECT SC.ENTITY_ID, SC.COUNTER_ID, ';sql_stmt = sql_stmt || ' CASE WHEN SD49.NAME=''swapused'' AND SD49.GROUP_NAME=''mem'' AND SD49.ROLLUP_TYPE=0 ';sql_stmt = sql_stmt || ' THEN (SELECT ID FROM VPX_STAT_DEF WHERE NAME=''swapped'' AND GROUP_NAME=''mem'' AND ROLLUP_TYPE=0) ';sql_stmt = sql_stmt || ' ELSE SC.STAT_ID END MODSTAT_ID, NC.AGGR_TO, NC.AGGR_TYPE ';sql_stmt = sql_stmt || ' FROM VPX_STAT_ID T ';sql_stmt = sql_stmt || ' INNER JOIN VPX_STAT_COUNTER SC ON SC.ENTITY_ID=T.ID ';sql_stmt = sql_stmt || ' INNER JOIN VPX_NEW_COUNTERS NC ON NC.COUNTER_ID = SC.STAT_ID ';sql_stmt = sql_stmt || ' INNER JOIN VPX_STAT_DEF SD49 ON SD49.ID = SC.STAT_ID) INSERTED ';sql_stmt = sql_stmt || ' ON H.PARENT_STAT_ENTITY_ID=INSERTED.ENTITY_ID AND INSERTED.MODSTAT_ID=SC.STAT_ID ';sql_stmt = sql_stmt || ' AND (INSERTED.AGGR_TYPE=H.ENTITY_TYPE OR H.ENTITY_TYPE=''R'' ) ';sql_stmt = sql_stmt || ' AND (H.ENTITY_TYPE=INSERTED.AGGR_TO OR (INSERTED.AGGR_TO=''C'' AND H.ENTITY_TYPE IN (''V'',''H''))) ';sql_stmt = sql_stmt || ' WHERE D.DEVICE_NAME='''' OR D.DEVICE_NAME='' ''';sql_stmt = sql_stmt || ' GROUP BY HS.TIME_ID,SC.STAT_ID,INSERTED.COUNTER_ID; ';EXECUTE sql_stmt;END LOOP;EXCEPTION WHEN OTHERS THENNULL;END$$;
<YYYY-MM-DD>T<time></time> Section for VMware VirtualCenter, pid=5226, version=6.0.0, build=2559267, option=Release
<YYYY-MM-DD>T<time></time> verbose dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Dumping early logs:
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Logging uses fast path: true
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] The bora/lib logs WILL be handled by VmaCore
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Initialized channel manager
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Current working directory: /usr/lib/vmware-vpx/dbupgrade
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E55F700] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F49467F5700] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F49467B4700] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=ThreadPool] Thread pool on asio: Min Io, Max Io, Min Task, Max Task, Max Concurency: 2, 200, 2, 90, 2147483647
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F4946773700] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Syscommand enabled: true
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] ReaperManager Initialized
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Log path: /var/log/vmware/vpxd
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Initializing SSL
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] Vmacore::InitSSL: handshakeTimeoutUs = 20000000
<YYYY-MM-DD>T<time></time> info dbuhelper[7F49460E9700] [Originator@6876 sub=ThreadPool] Thread enlisted
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=vpxdVdb] Registry Item DB 5 value is ''
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=vpxdVdb] [VpxdVdb] Converted munged password in registry
<YYYY-MM-DD>T<time></time> warning dbuhelper[7F494E5687A0] [Originator@6876 sub=vpxCommon] [VpxConfig] Invalid specified value property: vpxd.memChecker.memStopInMB
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=vpxdVdb] Setting VDB delay statements queue size to 1000 transactions for 1 GB RAM dedicated to vpxd.
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=Default] [VdbSchemaLoader::LookupSchemaFromDB] Loaded schema and index information from DB
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=dbuHelper] [DbuHelper] Upgrading the VM clobs....
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=dbuHelper] [DbuHelper] Done upgrading the VM clobs.
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=dbuHelper] [DbuHelper] Upgrading the datastore clobs.
<YYYY-MM-DD>T<time></time> info dbuhelper[7F494E5687A0] [Originator@6876 sub=dbuHelper] [DbuHelper] Done upgrading the Datstore clobs.