由于缺少表分区，向 Unified Manager 迁移性能数据失败

适用场景

• OnCommand 统一管理器 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