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

NetApp_Insight_2020.png 

OnCommand Insight Data Warehouse Extract 、 Transform 、および Load ( ETL )は、 MySQL データベース内のテーブル全体が原因で失敗します

Views:
6
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