SRM：import-properties 工作有下列錯誤：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException：通訊連結故障

Summary: 如果導入通道任務由於 apg 資料庫負載過重而在套接字超時時持續失敗，則可以增加 socketTimeout。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

匯入屬性工作在與 apg 資料庫的連線時出現以下錯誤： 
160627 07:07:57 : com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
160627 07:07:57 :
160627 07:07:57 : The last packet successfully received from the server was 180,025 milliseconds ago. The last packet sent successfully to the server was 180,025 milliseconds ago.

異常的原因是：
aused by： java.net.SocketTimeoutException：讀取逾時

在此特定情況下，APG/Web-Servers/Tomcat/Default/conf/server.xml 中為每個資料庫設定的 socketTimeout 設定為 180000 毫秒。

Cause

socketTimeout 將用於導入屬性任務中，以等待從data_property表中提取數據。如果由於當時資料庫負載過重而超過此時間，則任務將失敗。

Resolution

我們可以將 APG/Web-Servers/Tomcat/Default/conf/server.xml 檔案中的 socketTimeout 設定增加為例如 5 分鐘 （300000 毫秒），如下所示： 
<!-- Defines the connection to the APG timeseries database for MySQL. -->
	<Resource name="jdbc/APG-DB" auth="Container" type="javax.sql.DataSource" maxActive="20" maxIdle="20" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true" validationQueryTimeout="5" timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" maxWait="30000" username="apg" password="watch4net" driverClassName="com.mysql.jdbc.Driver" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" url="jdbc:mysql://<db hostname>:53306/apg?autoReconnect=true&socketTimeout=300000"/>
 

Affected Products

SRM
Article Properties
Article Number: 000059197
Article Type: Solution
Last Modified: 29 Jul 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.