Hi Bhakti, I have had issues with the mysql server started by docker-compose and it appears that the docker image got corrupted somehow. I was able to fix it by deleting and redownloading the image which I did by doing
docker-composer down docker-compose rm docker system prune --all Thanks, Marcus > On May 15, 2020, at 7:02 PM, Narvekar, Bhakti Sunil <[email protected]> wrote: > > Hi Professor, > > Thank you for the response. > I did search on StackOverFlow and other websites and tried changing the > version of MariaDB in pom.xml but doing this did not resolve the issue. > I will try connecting the database container externally. > > Thanks. > > Sincerely, > Bhakti > > From: Suresh Marru <mailto:[email protected]> > Sent: Friday, May 15, 2020 4:32 PM > To: Airavata Dev <mailto:[email protected]> > Subject: Re: [External] Airavata database connection issue > > Hi Bhakti, > > Looks like your issues are generic port and database. May be you should > search for issues on stack overflow and places like that. The error message > is clear, the service externally is unable to connect to the database. So you > may want to ignore airavata for a while and try to connect to the database > container (externally) and verify before you switch back to bring up airavata > services. > > Suresh > >> On May 14, 2020, at 11:49 PM, Narvekar, Bhakti Sunil <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi, >> >> I’m still not able to resolve this issue. It would be great if someone can >> help me out. >> >> Thanks. >> >> Sincerely, >> Bhakti >> >> From: Narvekar, Bhakti Sunil <mailto:[email protected]> >> Sent: Wednesday, May 13, 2020 4:14 PM >> To: [email protected] <mailto:[email protected]> >> Subject: RE: [External] Re: Airavata database connection issue >> >> Hi Aarushi, >> >> I tried stopping the local MySQL instance and also I tried uninstalling the >> instance as well but I’m still facing the same issue. All the containers are >> up but now I’m not able to access localhost:13306 as well. >> >> I have attached the StackTrace and logs for MySQL. >> >> Thanks, >> Bhakti >> >> From: Bisht, Aarushi <mailto:[email protected]> >> Sent: Wednesday, May 13, 2020 3:45 PM >> To: [email protected] <mailto:[email protected]> >> Subject: RE: [External] Re: Airavata database connection issue >> >> Hi Bhakti, >> >> Since you have a local mysql instance running that is why you are able to >> connect to localhost 13306. Can you try to stop the mysql instance running >> locally and only start the docker containers. If the container has >> successfully started mysql should be available on localhost:3306. You can >> see all the running containers using docker-compose ps. >> >> Thanks, >> Aarushi Bisht >> >> On May 13, 2020 1:03 PM, "Narvekar, Bhakti Sunil" <[email protected] >> <mailto:[email protected]>> wrote: >> Hi Vivek, >> >> I feel this is a different issue. I have attached the StackTrace as well. >> Please let me know if you think it is similar. >> >> Thanks, >> Bhakti >> >> From: Bandaru, Vivek Shresta <mailto:[email protected]> >> Sent: Wednesday, May 13, 2020 12:04 PM >> To: [email protected] <mailto:[email protected]> >> Subject: Re: [External] Re: Airavata database connection issue >> >> 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 >> >> <https://markmail.org/message/oojdzfmczss2gepr?q=Airavata+database+connection+error+while+starting> >> >> Regards, >> Vivek. >> >> From: "Narvekar, Bhakti Sunil" <[email protected] <mailto:[email protected]>> >> Reply-To: "[email protected] <mailto:[email protected]>" >> <[email protected] <mailto:[email protected]>> >> Date: Wednesday, May 13, 2020 at 11:52 AM >> To: "[email protected] <mailto:[email protected]>" >> <[email protected] <mailto:[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] >> <mailto:[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 >>
smime.p7s
Description: S/MIME cryptographic signature
