Uploaded image for project: 'Airavata'
  1. Airavata
  2. AIRAVATA-3280

Registering data product fails: Data too long for column 'FILE_PATH'

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Registry API
    • Labels:
      None

      Description

      Stacktrace:

      2019-11-28 12:00:24,139 [pool-9-thread-7625] ERROR o.a.t.server.TThreadPoolServer  - Error occurred during processing o
      f message.
      org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.  See the nested exceptions for 
      details on the errors that occurred.
              at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:595)
              at org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:119)
              at org.apache.airavata.registry.core.repositories.replicacatalog.DataProductRepository.saveDataProduct(DataProd
      uctRepository.java:96)
              at org.apache.airavata.registry.core.repositories.replicacatalog.DataProductRepository.saveDataProductModelData
      (DataProductRepository.java:47)
              at org.apache.airavata.registry.core.repositories.replicacatalog.DataProductRepository.registerDataProduct(Data
      ProductRepository.java:102)
              at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.registerDataProduct(RegistryServerHan
      dler.java:2611)
              at org.apache.airavata.registry.api.RegistryService$Processor$registerDataProduct.getResult(RegistryService.jav
      a:19183)
              at org.apache.airavata.registry.api.RegistryService$Processor$registerDataProduct.getResult(RegistryService.jav
      a:19167)
              at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
              at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
              at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested e
      xceptions for details on the errors that occurred.
              at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2374)
              at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2211)
              at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
              at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
              at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
              at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
              at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
              at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
              ... 13 common frames omitted
      Caused by: org.apache.openjpa.persistence.PersistenceException: (conn:539302) Data too long for column 'FILE_PATH' at r
      ow 1 {prepstmnt 631847540 
      INSERT INTO DATA_REPLICA_LOCATION (REPLICA_ID, CREATION_TIME, 
              FILE_PATH, LAST_MODIFIED_TIME, PRODUCT_URI, 
              REPLICA_DESCRIPTION, REPLICA_LOCATION_CATEGORY, REPLICA_NAME, 
              REPLICA_PERSISTENT_TYPE, STORAGE_RESOURCE_ID, VALID_UNTIL_TIME) 
          VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
      [params=(String) 82623ba1-e8d7-499c-9d81-fd1f9499f1f7, (Timestamp) 2019-11-28 12:00:24.118, (String) file://gf4.ucs.ind
      iana.edu:/var/www/portals/gateway-user-data/amp/sp..., (Timestamp) 2019-11-28 12:00:24.118, (String) airavata-dp://0deb
      792a-d0d9-41fd-b0b3-a47f1f9bcb27, (null) null, (String) GATEWAY_DATA_STORE, (String) target.scatci.triplet.App.out gate
      way data store copy, (String) TRANSIENT, (String) gf4.ucs.indiana.edu_61552681-96f0-462a-a36c-a62a010bffc6, (null) null
      ]} [code=1406, state=22001]
              at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003)
              at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
              at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
              at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
              at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java
      :144)
              at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatement
      ManagerImpl.java:79)
              at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:
      100)
              at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
              at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
              at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
              at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59
      )
              at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
              at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
              at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
              at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
              ... 20 common frames omitted
      

        Attachments

          Activity

            People

            • Assignee:
              marcuschristie Marcus Christie
              Reporter:
              marcuschristie Marcus Christie
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: