Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9495

Data loading fails on mysql

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not A Problem
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: datamodel
    • Labels:
      None

      Description

      OFBiz fails to data on mysql,

      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
      

      While data load I am getting following error

      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)
      

        Attachments

        1. error.log
          13 kB
          Deepak Dixit

          Activity

            People

            • Assignee:
              deepak Deepak Dixit
              Reporter:
              deepak Deepak Dixit
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: