[
https://issues.apache.org/jira/browse/OFBIZ-9495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deepak Dixit updated OFBIZ-9495:
--------------------------------
Attachment: (was: error.log)
> Data loading fails on mysql
> ---------------------------
>
> Key: OFBIZ-9495
> URL: https://issues.apache.org/jira/browse/OFBIZ-9495
> Project: OFBiz
> Issue Type: Bug
> Components: datamodel
> Affects Versions: Trunk
> Reporter: Deepak Dixit
> Priority: Critical
>
> OFBiz fails to data on mysql,
> {code}
> Database Product Version is 5.7.17
> 2017-07-18 12:09:10,932 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver Name is MySQL Connector Java
> 2017-07-18 12:09:10,932 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver Version is mysql-connector-java-5.1.42 ( Revision:
> 1f61b0b0270d9844b006572ba4e77f19c0f230d4 )
> 2017-07-18 12:09:10,932 |OFBiz-batch-3 |DatabaseUtil
> |I| Database Driver JDBC Version is 4.0
> {code}
> While data load I am getting following error
> {code}
> 2017-07-18 12:09:27,241 |main |EntitySaxReader
> |I| Beginning import from URL:
> file:/Users/deepakdixit/sandbox/plain_ofbiz/applications/product/data/ShipmentTypeData.xml
> 2017-07-18 12:09:27,246 |main |EntitySaxReader
> |I| Transaction Timeout set to 2 hours (7200 seconds)
> 2017-07-18 12:09:32,413 |main |GenericDelegator
> |E| Failure in create operation for entity [EntityKeyStore]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:EntityKeyStore][createdStamp,2017-07-18
> 12:09:28.329(java.sql.Timestamp)][createdTxStamp,2017-07-18
> 12:09:28.329(java.sql.Timestamp)][keyName,QZAFo/7OYuq2EyTBzptUBpNeYjRWl95o5yIlp6l6Iq+tcIGYlNTvVsxmAL2c846rXzxN5QvOj9k++UqHsKfRtQ==(java.lang.String)][keyText,SKFUzweki0O4s3XAVUHilg==(java.lang.String)][lastUpdatedStamp,2017-07-18
> 12:09:28.329(java.sql.Timestamp)][lastUpdatedTxStamp,2017-07-18
> 12:09:28.329(java.sql.Timestamp)] (Unable to establish a connection with the
> database. (Unable to acquire a new connection from the pool)). Rolling back
> transaction.
> java.io.EOFException: Can not read response from server. Expected to read 4
> bytes, read 0 bytes before connection was unexpectedly lost.
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011)
> at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:567)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
