Hi all, still trying to get to the point where I can run jobs from my
local install. Using SSH, I can now successfully submit jobs, however
every submission throws the error below. I double-checked, and my
airavata user in MySQL has been granted all permissions on
app_catalog.*, and the storage resource that I specified for my gateway
exists in the app_catalog.STORAGE_RESOURCE table.
I've tried resetting the permissions on the table and creating a new
storage resource, but neither of those solved the issue. I've also
attached the config for my storage resource and gateway preferences, as
well.
Any suggestions?
Best,
Jeff K.
2016-05-17 15:58:04,061 [pool-15-thread-12] ERROR
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl -
Error while retrieving storage resource...
javax.persistence.NoResultException: Query "SELECT p FROM
StorageResource p WHERE p.storageResourceId =:param0" selected no
result, but expected unique result.
at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332)
at
org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111)
at
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121)
at
org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:120)
at org.apache.airavata.gfac.impl.GFacWorker.<init>(GFacWorker.java:75)
at
org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161)
at
org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:273)
at
org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187)
at
com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144)
at
com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99)
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:745)
2016-05-17 15:58:04,061 [pool-15-thread-12] ERROR
org.apache.airavata.gfac.core.GFacException - App catalog access exception
org.apache.airavata.registry.cpi.AppCatalogException:
javax.persistence.NoResultException: Query "SELECT p FROM
StorageResource p WHERE p.storageResourceId =:param0" selected no
result, but expected unique result.
at
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:125)
at
org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:120)
at org.apache.airavata.gfac.impl.GFacWorker.<init>(GFacWorker.java:75)
at
org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161)
at
org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:273)
at
org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187)
at
com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144)
at
com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99)
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:745)
Caused by: javax.persistence.NoResultException: Query "SELECT p FROM
StorageResource p WHERE p.storageResourceId =:param0" selected no
result, but expected unique result.
at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332)
at
org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111)
at
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121)
... 10 more
2016-05-17 15:58:04,061 [pool-15-thread-12] ERROR
org.apache.airavata.gfac.server.GfacServerHandler - Failed to submit
process
org.apache.airavata.gfac.core.GFacException: App catalog access exception
at
org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:208)
at org.apache.airavata.gfac.impl.GFacWorker.<init>(GFacWorker.java:75)
at
org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161)
at
org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:273)
at
org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187)
at
com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144)
at
com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99)
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:745)
Caused by: org.apache.airavata.registry.cpi.AppCatalogException:
javax.persistence.NoResultException: Query "SELECT p FROM
StorageResource p WHERE p.storageResourceId =:param0" selected no
result, but expected unique result.
at
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:125)
at
org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:120)
... 9 more
Caused by: javax.persistence.NoResultException: Query "SELECT p FROM
StorageResource p WHERE p.storageResourceId =:param0" selected no
result, but expected unique result.
at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332)
at
org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111)
at
org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121)
... 10 more
