メインコンテンツまでスキップ

NetApp_Insight_2020.png 

テーブルパーティションがないため、 Unified Manager へのパフォーマンスデータの移行に失敗します

Views:
6
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager
Specialty:
om
Last Updated:

のしんだ

に適用されます

  • OnCommand Unified Manager 7.2
  • OnCommand Performance Manager 7.1

問題

ドキュメントに従って移行手順を開始すると、エラーメッセージは表示されずに失敗します。

 

  • OnCommand Unified Manager の移行ログファイルには、次のエラーがあります。

PARTITION null VALUES LESS THAN (0) ): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null INTO ( PARTITION p0 VALUES LESS THAN (-2678400000),
PARTITION p1 VALUES LE' at line 1
2017-06-28 08:32:23,717 ERROR [main] c.n.d.u.m.i.PerformanceTableMigrationService (PerformanceTableMigrationService.java:109) - Migrating data from sample_qos_volume_workload table(s) Failed. org.mariadb.jdbc.internal.common.QueryException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null INTO ( PARTITION p0 VALUES LESS THAN (-2678400000),

PARTITION null VALUES LESS THAN (0) ): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null INTO ( PARTITION p0 VALUES LESS THAN (-2678400000),
PARTITION p1 VALUES LE' at line 1
2017-06-28 09:19:50,577 ERROR [main] c.n.d.u.m.i.PerformanceTableMigrationService (PerformanceTableMigrationService.java:109) - Migrating data from sample_qos_workload_detail table(s) Failed. org.mariadb.jdbc.internal.common.QueryExceptio
2017-06-28 09:30:47,862 INFO [main] c.n.d.u.m.i.MigrationStatusService (MigrationStatusService.java:327) - There is no cluster in scheduled status. Not starting the migration process.

 

  • 上記以外にも、 JBoss サーバログファイルに次のメッセージ * が表示されることがあります。
     

2017-06-29 00:08:17,435 WARN [org.mariadb.jdbc.internal.mysql.MySQLProtocol] (EJB default - 30) Could not execute query sql : 'INSERT INTO netapp_performance.sample_volume_7599 (objid, time, empty, avgLatency,
cifsOtherLatency, cifsOtherOps, cifsReadData, cifsReadLatency, cifsReadOps, cifsWriteData, cifsWriteLatency, cifsWriteOps, fcpOtherLatency, fcpOtherOps, fcpReadData, fcpReadLatency, fcpReadOps, fcpWriteData,
fcpWriteLatency, fcpWriteOps, iscsiOtherLatency, iscsiOtherOps, iscsiReadData, iscsiReadLatency, iscsiReadOps, iscsiWriteData, iscsiWriteLatency, iscsiWriteOps, nfsOtherLatency, nfsOtherOps, nfsReadData,
nfsReadLatency, nfsReadOps, nfsWriteData, nfsWriteLatency, nfsWriteOps, otherLatency, otherOps, readData, readLatency, readOps, sanOtherLatency, sanOtherOps, sanReadData, sanReadLatency, sanReadOps, sanWriteData,
sanWriteLatency, sanWriteOps, totalOps, writeData, writeLatency, writeOps, OpmVolNfsOps, OpmVolCifsOps, OpmVolIscsiOps, OpmVolFcpOps) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', parameters : [7630,1498691075712,0,23.847457885742188,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0. 0 ,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,23.847457885742188,0.1966666728258133,0.0,0.0,0.0,NULL,NULL,0.0,NULL,NULL,0.0,NULL,NULL,0.19666 66728258133,0.0,0.0,0.
0,0.0,0.0,0.0,0.0]: Table has no partition for value 1498691075712

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support