You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by saurav kumar jha <im...@gmail.com> on 2023/07/13 06:25:44 UTC
Error while running Airavata locally
Hi Marcus,
I am getting this error while running airavata locally when an api call for
experiment statistics is made ,
*Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist*
Here is the full stack trace,
*124 [TThreadPoolServer WorkerProcess-0] ERROR
org.apache.airavata.registry.core.repositories.AbstractRepository {} -
Failed to execute transaction*
*org.apache.openjpa.persistence.ArgumentException: Failed to execute query
"SELECT count(ES.experimentId) FROM ExperimentSummaryEntity ES WHERE
ES.gatewayId = :gatewayId AND ES.creationTime BETWEEN :fromDate AND
:toDate". Check the query syntax for correctness. See nested exception for
details.*
* at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:921)
~[openjpa-3.1.0.jar:3.1.0]*
* at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.lambda$getExperimentStatisticsCountForState$0(ExperimentSummaryRepository.java:362)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:141)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getExperimentStatisticsCountForState(ExperimentSummaryRepository.java:356)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getAccessibleExperimentStatistics(ExperimentSummaryRepository.java:280)
~[classes/:?]*
* at
org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getExperimentStatistics(RegistryServerHandler.java:433)
~[classes/:?]*
* at
org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:17739)
~[classes/:?]*
* at
org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:1)
~[classes/:?]*
* at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:40)
~[libthrift-0.18.1.jar:0.18.1]*
* at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:40)
~[libthrift-0.18.1.jar:0.18.1]*
* at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:257)
~[libthrift-0.18.1.jar:0.18.1]*
* at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
~[?:?]*
* at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
~[?:?]*
* at java.lang.Thread.run(Thread.java:829) ~[?:?]*
*Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:268)
Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist {prepstmnt
900574728 *
Can you please help me in getting it resolved?
Thanks & Regards,
Saurav Kumar Jha
Re: Error while running Airavata locally
Posted by saurav kumar jha <im...@gmail.com>.
Thanks Marcus for the help.
I forgot to update you about this.
Running the script you mentioned manually created the view with uppercase
(EXPERIMENT_SUMMARY) and then error was fixed.
By default the view was getting created but it was in lowercase
(experiment_summary) .
Thanks & Regards,
Saurav Kumar Jha
On Tue, Jul 18, 2023 at 12:54 AM Christie, Marcus Aaron <ma...@iu.edu>
wrote:
> Hi Saurav,
>
>
>
> I suspect that the database didn’t get initialized correctly, but then you
> said you only get this for experiment statistics api calls.
>
>
>
> The error is a little misleading, experiment_catalog.EXPERIMENT_SUMMARY is
> a view, not an actual table.
>
>
>
> You can try creating it manually with this script:
> https://github.com/apache/airavata/blob/master/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql#L232-L238
>
>
>
> Thanks,
>
>
>
> Marcus
>
>
>
> *From: *saurav kumar jha <im...@gmail.com>
> *Date: *Thursday, July 13, 2023 at 2:26 AM
> *To: *Christie, Marcus Aaron <ma...@iu.edu>
> *Cc: *dev@airavata.apache.org <de...@airavata.apache.org>
> *Subject: *Error while running Airavata locally
>
> Hi Marcus,
>
>
>
> I am getting this error while running airavata locally when an api call
> for experiment statistics is made ,
>
> *Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist*
>
> Here is the full stack trace,
>
>
>
> *124 [TThreadPoolServer WorkerProcess-0] ERROR
> org.apache.airavata.registry.core.repositories.AbstractRepository {} -
> Failed to execute transaction*
>
> *org.apache.openjpa.persistence.ArgumentException: Failed to execute query
> "SELECT count(ES.experimentId) FROM ExperimentSummaryEntity ES WHERE
> ES.gatewayId = :gatewayId AND ES.creationTime BETWEEN :fromDate AND
> :toDate". Check the query syntax for correctness. See nested exception for
> details.*
>
> * at
> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:921)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343)
> ~[openjpa-3.1.0.jar:3.1.0]*
>
> * at
> org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.lambda$getExperimentStatisticsCountForState$0(ExperimentSummaryRepository.java:362)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:141)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getExperimentStatisticsCountForState(ExperimentSummaryRepository.java:356)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getAccessibleExperimentStatistics(ExperimentSummaryRepository.java:280)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getExperimentStatistics(RegistryServerHandler.java:433)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:17739)
> ~[classes/:?]*
>
> * at
> org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:1)
> ~[classes/:?]*
>
> * at
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:40)
> ~[libthrift-0.18.1.jar:0.18.1]*
>
> * at
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:40)
> ~[libthrift-0.18.1.jar:0.18.1]*
>
> * at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:257)
> ~[libthrift-0.18.1.jar:0.18.1]*
>
> * at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> ~[?:?]*
>
> * at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> ~[?:?]*
>
> * at java.lang.Thread.run(Thread.java:829) ~[?:?]*
>
> *Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:268)
> Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist {prepstmnt
> 900574728 *
>
>
>
> Can you please help me in getting it resolved?
>
> Thanks & Regards,
>
> Saurav Kumar Jha
>
Re: Error while running Airavata locally
Posted by "Christie, Marcus Aaron" <ma...@iu.edu>.
Hi Saurav,
I suspect that the database didn’t get initialized correctly, but then you said you only get this for experiment statistics api calls.
The error is a little misleading, experiment_catalog.EXPERIMENT_SUMMARY is a view, not an actual table.
You can try creating it manually with this script: https://github.com/apache/airavata/blob/master/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql#L232-L238 <https://github.com/apache/airavata/blob/master/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql#L232-L238>
Thanks,
Marcus
From: saurav kumar jha <im...@gmail.com>
Date: Thursday, July 13, 2023 at 2:26 AM
To: Christie, Marcus Aaron <ma...@iu.edu>
Cc: dev@airavata.apache.org <de...@airavata.apache.org>
Subject: Error while running Airavata locally
Hi Marcus,
I am getting this error while running airavata locally when an api call for experiment statistics is made ,
Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist
Here is the full stack trace,
124 [TThreadPoolServer WorkerProcess-0] ERROR org.apache.airavata.registry.core.repositories.AbstractRepository {} - Failed to execute transaction
org.apache.openjpa.persistence.ArgumentException: Failed to execute query "SELECT count(ES.experimentId) FROM ExperimentSummaryEntity ES WHERE ES.gatewayId = :gatewayId AND ES.creationTime BETWEEN :fromDate AND :toDate". Check the query syntax for correctness. See nested exception for details.
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:921) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343) ~[openjpa-3.1.0.jar:3.1.0]
at org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.lambda$getExperimentStatisticsCountForState$0(ExperimentSummaryRepository.java:362) ~[classes/:?]
at org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:141) ~[classes/:?]
at org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getExperimentStatisticsCountForState(ExperimentSummaryRepository.java:356) ~[classes/:?]
at org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getAccessibleExperimentStatistics(ExperimentSummaryRepository.java:280) ~[classes/:?]
at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getExperimentStatistics(RegistryServerHandler.java:433) ~[classes/:?]
at org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:17739) ~[classes/:?]
at org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:1) ~[classes/:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:40) ~[libthrift-0.18.1.jar:0.18.1]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:40) ~[libthrift-0.18.1.jar:0.18.1]
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:257) ~[libthrift-0.18.1.jar:0.18.1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:268) Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist {prepstmnt 900574728
Can you please help me in getting it resolved?
Thanks & Regards,
Saurav Kumar Jha