[
https://issues.apache.org/jira/browse/AIRAVATA-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie updated AIRAVATA-3280:
--------------------------------------
Description:
Stacktrace:
{noformat}
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
{noformat}
was:
{noformat}
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
{noformat}
> Registering data product fails: Data too long for column 'FILE_PATH'
> --------------------------------------------------------------------
>
> Key: AIRAVATA-3280
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3280
> Project: Airavata
> Issue Type: Bug
> Components: Registry API
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> Stacktrace:
> {noformat}
> 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
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
