Import Properties fails with suggestion "Consider raising value of 'net_write_timeout' on the server."

Products

• VMware Smart Assurance

Issue/Introduction

Import properties fails with below error:

SEVERE: Import failed !
250425 06:19:22 : com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Application was streaming results when the connection failed. Consider raising value of 'net_write_timeout' on the server.
250425 06:19:22 :   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

.

.

250425 06:19:22 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@799f10e1...
250425 06:19:24 : Execute method (main) exited with a failure error code of 1
250425 06:19:24 : Task import-properties-Default failed with status 1.

Environment

Watch4net/MnR - 7.x

Resolution

Login to Mysql client and collect output of show global variables where Variable_name='net_write_timeout'; where default value of net_write_timeout in MnR 7.x is 60s.

This value can be increased in 2 ways:

• In Mysql directly as set net_write_timeout=<Required Value>

Example: set net_write_timeout=600

NOTE: This value is determined based on how big the DB is for which import properties is failing. 

• In my.cnf file available in  <APG_BASE>/Databases/MySQL/Default/ under mysqld, see image:

This change needs mysql and tomcat restart for changes to take effect.

Additional Information

Additionally, resource link for failed DB could be checked and add netTimeoutForStreamingResults.

Resource link can be checked from <APG_BASE>/bin and run ./manage-resources.sh get <DB>

Example: ./manage-resources.sh get dba/APG-DB

Identify the URL, add netTimeoutForStreamingResults and update the resource link.

Example: "url": "jdbc:mysql://localhost:53306/apg?autoReconnect=true&connectTimeout=20000&maxReconnects=2&useSSL=false&netTimeoutForStreamingResults=600"

 

Refer to KBs for few common cause in import properties Task failure in MnR:

Import Properties Task Fail (Errno: 28 - No space left on device)

Import properties task failed on Frontend