OnCommand Insight Data Warehouse 提取、转换和加载 (ETL) 失败，原因是 MySQL 数据库中的表已满

OnCommand Insight Data Warehouse （ DWH ） 7.3.x

OnCommand Insight (OCI) 7.3.x

对 DWH 或 OCI MySQL 数据库的查询失败、并显示一条消息指出临时表已满。查询可以在 ETL 期间或报告生成期间直接运行。

以下是 DWH.log 中的这些错误示例：

2018-11-23 01:47:48,024 INFO [Thread-277 (ActiveMQ-client-global-threads)]

CustomScriptRunnerBean (CustomScriptRunnerBean.java:56) -

E:\Program Files\SANscreen\wildfly\bin\service\amd64>rem

****************************************************

2018-11-23 01:47:48,040 ERROR [Thread-277 (ActiveMQ-client-global-threads)]

CustomScriptRunnerBean (CustomScriptRunnerBean.java:58) - 'name' is not recognized as an internal

or external command,

operable program or batch file.

mysql: [Warning] Using a password on the command line interface can be insecure

ERROR 1114 (HY000) at line 3878: The table 'E:\Program

Files\SANscreen\mysql\tmp\#sql5a8_329_61' is full

Knowledgebase

2019-01-09 02:24:32,743 ERROR [Thread-847 (ActiveMQ-client-global-threads)] JobDispatcherBean

(JobDispatcherBean.java:106) - InventoryJob{name='Inventory: connector 'xxxxxx', 'Jan 9, 2019 2:00

AM'', id=15899, connectorId=7, targetTime=1547020800006, current=true} failed

Caused by: com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Extracting

performance into Table{name='vmdk_performance'} failed (using Context{connector=xxxxxx})

Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: INSERT IGNORE

INTO dwh_inventory_staging.tmp_vmdk_performance VALUES

Caused by: java.sql.SQLException: The table 'tmp_vmdk_performance' is full

.err 中的此错误的示例为：

2 018-11-23T01:22:17.371221-08:00 809 [ERROR] MySQL: The table 'E:\Program

Files\SANscreen\mysql\tmp\#sql5a8_329_61' is full