跳转到主内容

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

Views:
4
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

适用于

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
 
 

 

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