Hi Bhakti, This looks very similar to the database connection error a couple of us faced few weeks ago. Without the full stacktrace I can’t say for sure, but you can try the fix mentioned in this mail: https://markmail.org/message/oojdzfmczss2gepr?q=Airavata+database+connection+error+while+starting
Regards, Vivek. From: "Narvekar, Bhakti Sunil" <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Wednesday, May 13, 2020 at 11:52 AM To: "[email protected]" <[email protected]> Subject: RE: [External] Re: Airavata database connection issue Hi Aarushi, The services are up and running. I have attached the screenshots for the same. The localhost:13306 is reachable but localhost:3306 is not. I have attached the result of the telnet for both the ports 3306 and 13306. Also, I have MySQL server installed on my local machine, would that be an issue. Thanks & Regards, Bhakti Narvekar From: Bisht, Aarushi<mailto:[email protected]> Sent: Wednesday, May 13, 2020 4:15 AM To: [email protected]<mailto:[email protected]> Subject: RE: [External] Re: Airavata database connection issue Hi Bhakti, From the logs it seems you are not able to connect to database on localhost: 13306. Make sure db container is up and running. Try using nc or some other command to make sure that you are able to connect to this port. - Aarushi Bisht On May 13, 2020 12:05 AM, "Narvekar, Bhakti Sunil" <[email protected]> wrote: Hi Akhil, Yes, I tried deleting the ide-integration/resources/database_data folder, stopping all the services, and restarting them again. But I'm still facing this issue. Regards, Bhakti From: akhil nagulavancha<mailto:[email protected]> Sent: Tuesday, May 12, 2020 9:43 PM To: [email protected]<mailto:[email protected]> Subject: [External] Re: Airavata database connection issue This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. Hi Bhakti , Did you try the note mentioned in start airavata server step of cwiki ? It has helped me to solve a similar database related error. Regards Akhil On Tue, May 12, 2020 at 8:41 PM Narvekar, Bhakti Sunil <[email protected]<mailto:[email protected]>> wrote: Hi, On starting APIServerStarter, I ran into an exception - SQLNonTransientConnectionException. I have attached the StackTrace and database logs. Could anyone please help me with this issue. Thanks & Regards, Bhakti Narvekar
