You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Bandaru, Vivek Shresta" <vi...@iu.edu> on 2020/03/28 18:15:43 UTC
Re: [External] Re: Issues with Airavata project setup
Hi Aarushi,
Thanks for the prompt response.
I did follow the steps you’ve mentioned but now I’m getting a new error which is also related to databases.
Stacktrace:
Exception in thread "main" java.lang.RuntimeException: Failed to post-initialize the expcatalog database
at org.apache.airavata.registry.core.utils.ExpCatalogDBInitConfig.postInit(ExpCatalogDBInitConfig.java:81)
at org.apache.airavata.common.utils.DBInitializer.initializeDB(DBInitializer.java:46)
at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:69)
at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:151)
at org.apache.airavata.ide.integration.APIServerStarter.main(APIServerStarter.java:23)
Caused by: java.lang.RuntimeException: Failed to get EntityManager
at org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:114)
at org.apache.airavata.registry.core.repositories.AbstractRepository.get(AbstractRepository.java:67)
at org.apache.airavata.registry.core.repositories.AbstractRepository.isExists(AbstractRepository.java:105)
at org.apache.airavata.registry.core.repositories.expcatalog.GatewayRepository.isGatewayExist(GatewayRepository.java:99)
at org.apache.airavata.registry.core.utils.ExpCatalogDBInitConfig.postInit(ExpCatalogDBInitConfig.java:62)
... 4 more
Please find the full stacktrace attached.
I tried checking the contents by establishing connection through the MySQL client.
[A screenshot of a computer screen Description automatically generated]
When I try querying the databases, all I got is the meta-data holder, information_schema database. Seems like the databases are not correctly initialized.
What else can I do to rectify this issue?
Regards,
Vivek.
From: "Bisht, Aarushi" <ab...@iu.edu>
Reply-To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Date: Saturday, March 28, 2020 at 1:35 PM
To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Subject: [External] Re: Issues with Airavata project setup
This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
Hi Vivek,
It seems that that databases have not been correctly initialized. Can you try making all the services down. Then in the ide-integration/resources folder, try deleting database_data folder and again restart the docker services. If you are trying to login into the database, you can find the credentials in docker-compose.yml file.
Regarding issue 2, I can also see the missing maven plugin in my local setup but it does not cause any issue with the airavata server startup.
-Aarushi Bisht
________________________________
From: Bandaru, Vivek Shresta <vi...@iu.edu>
Sent: Saturday, March 28, 2020 1:15 PM
To: dev@airavata.apache.org
Subject: [External] Issues with Airavata project setup
This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
Thank you Shivam for your help till now.
I’m still facing few issues with starting my APIServerStarter.java and any help in resolving these issues is very much appreciated.
ISSUE 1:
I’m getting the following SQL exception when the APIServerStarter.java program runs.
[A screenshot of a cell phone Description automatically generated]
My docker containers are up and running. What might be the issue?
[cid:image003.png@01D6050B.59CE4DC0]
What did I try to debug the issue:
I tried connecting my MySQL client to localhost:13306 and localhost:3306 to check if MySQL database is reachable or not. It’s asking for the username and password when I try to establish a connection.
I tried doing some basic static code analysis by looking in the code to see if the username and password is mentioned anywhere, but got stuck at ‘org.apache.airavata.common.utils.ServerSettings#getCredentialStoreDBUser’. Looks like the username and password are given as arguments to the application for establishing a DB connection.
How do I debug this issue and get it resolved?
ISSUE 2:
Though I’m able to execute my APIServerStarter.java, I still see maven dependency errors.
I did check my .m2(where maven dependencies are downloaded) folder for maven-jar-plugins jar and it is present as expected. Is this an Intellij issue?
Is this issue anyway related to ISSUE 1?
[A screenshot of a computer Description automatically generated]
I’m open to jump into a quick call with any Airavata developer to get these issues resolved.
Regards,
Vivek.
Re: [External] Re: Issues with Airavata project setup
Posted by "Bisht, Aarushi" <ab...@iu.edu>.
Hi Vivek,
Yes, the database is not being initialized. I am attaching a screenshot of the database_data folder in my development environment which shows the databases that should be initialized once the mysql container is up. I can't think of a reason which might cause failure of initialization. Make sure you are using develop branch and have all scripts in database_scripts folder.
Also see the logs of db container to check if you are getting any error there.
Thanks,
Aarushi Bisht
________________________________
From: Bandaru, Vivek Shresta <vi...@iu.edu>
Sent: Saturday, March 28, 2020 2:15 PM
To: dev@airavata.apache.org
Subject: Re: [External] Re: Issues with Airavata project setup
Hi Aarushi,
Thanks for the prompt response.
I did follow the steps you’ve mentioned but now I’m getting a new error which is also related to databases.
Stacktrace:
Exception in thread "main" java.lang.RuntimeException: Failed to post-initialize the expcatalog database
at org.apache.airavata.registry.core.utils.ExpCatalogDBInitConfig.postInit(ExpCatalogDBInitConfig.java:81)
at org.apache.airavata.common.utils.DBInitializer.initializeDB(DBInitializer.java:46)
at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:69)
at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:151)
at org.apache.airavata.ide.integration.APIServerStarter.main(APIServerStarter.java:23)
Caused by: java.lang.RuntimeException: Failed to get EntityManager
at org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:114)
at org.apache.airavata.registry.core.repositories.AbstractRepository.get(AbstractRepository.java:67)
at org.apache.airavata.registry.core.repositories.AbstractRepository.isExists(AbstractRepository.java:105)
at org.apache.airavata.registry.core.repositories.expcatalog.GatewayRepository.isGatewayExist(GatewayRepository.java:99)
at org.apache.airavata.registry.core.utils.ExpCatalogDBInitConfig.postInit(ExpCatalogDBInitConfig.java:62)
... 4 more
Please find the full stacktrace attached.
I tried checking the contents by establishing connection through the MySQL client.
[A screenshot of a computer screen Description automatically generated]
When I try querying the databases, all I got is the meta-data holder, information_schema database. Seems like the databases are not correctly initialized.
What else can I do to rectify this issue?
Regards,
Vivek.
From: "Bisht, Aarushi" <ab...@iu.edu>
Reply-To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Date: Saturday, March 28, 2020 at 1:35 PM
To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Subject: [External] Re: Issues with Airavata project setup
This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
Hi Vivek,
It seems that that databases have not been correctly initialized. Can you try making all the services down. Then in the ide-integration/resources folder, try deleting database_data folder and again restart the docker services. If you are trying to login into the database, you can find the credentials in docker-compose.yml file.
Regarding issue 2, I can also see the missing maven plugin in my local setup but it does not cause any issue with the airavata server startup.
-Aarushi Bisht
________________________________
From: Bandaru, Vivek Shresta <vi...@iu.edu>
Sent: Saturday, March 28, 2020 1:15 PM
To: dev@airavata.apache.org
Subject: [External] Issues with Airavata project setup
This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
Thank you Shivam for your help till now.
I’m still facing few issues with starting my APIServerStarter.java and any help in resolving these issues is very much appreciated.
ISSUE 1:
I’m getting the following SQL exception when the APIServerStarter.java program runs.
[A screenshot of a cell phone Description automatically generated]
My docker containers are up and running. What might be the issue?
[cid:image003.png@01D6050B.59CE4DC0]
What did I try to debug the issue:
I tried connecting my MySQL client to localhost:13306 and localhost:3306 to check if MySQL database is reachable or not. It’s asking for the username and password when I try to establish a connection.
I tried doing some basic static code analysis by looking in the code to see if the username and password is mentioned anywhere, but got stuck at ‘org.apache.airavata.common.utils.ServerSettings#getCredentialStoreDBUser’. Looks like the username and password are given as arguments to the application for establishing a DB connection.
How do I debug this issue and get it resolved?
ISSUE 2:
Though I’m able to execute my APIServerStarter.java, I still see maven dependency errors.
I did check my .m2(where maven dependencies are downloaded) folder for maven-jar-plugins jar and it is present as expected. Is this an Intellij issue?
Is this issue anyway related to ISSUE 1?
[A screenshot of a computer Description automatically generated]
I’m open to jump into a quick call with any Airavata developer to get these issues resolved.
Regards,
Vivek.