Trying to install Jira and Confluence on GCP -- HTTP 500 Error

Question

Hi everybody,

I am trying to deploy Jira and Confluence on two separate GCP VM instances according to these articles:

https://cloud.google.com/solutions/deploying-jira-on-gcp

https://cloud.google.com/solutions/deploying-confluence-on-gcp

I have gotten the instances up and running to the point where I can see the setup wizard running on our own domain. However, I get to the step where we need to connect to the database and I get a HTTP Status 500 error after the software tries to setup the database. This happens every time (I have tried this starting from scratch about 3 or 4 times) and it is getting very frustrating. I have also tried doing the 'Trial Setup' where a temporary database is created and it still throws the same error while trying to create the database (which seems odd -- as this should be completely unrelated to trying to connect it to the GCP SQL database). I feel that I have followed the instructions as closely as possible, so if anybody could provide some insight as to how this database connection is causing things to fail please let me know. Thanks!

PD Sheehan · Answer

Regarding my earlier comment about the CLB ... I found the cause of my CLB performance.

In my various configuration meandering in the GCP console, I ended up with a CLB backend with 2 ports (comma separated): 80, 8080.

But the actual server was only listening to 80.

When the Google Front End (GFE) would try to connect (randomly presumably) to port 8080, it would fail after 4.5 seconds (the default GFE timeout ... not configurable). Then it would re-try (again random port). If it hit 80, all it good... but I've just experienced a 4.5 seconds latency. If it hit 8080 again, it would fail the second attempt (and no more retries) for a total of 9seconds wait before showing a 502 error.

My installation seems much more stable now and we can start some performance testing.

Here are a couple of links that clued me in:

https://superuser.com/questions/1451460/google-cloud-http-load-balancer-slow-performance-or-502-failed-to-connect-to-ba

https://groups.google.com/d/msg/gce-discussion/7ETsl0YH1iQ/TIbUvrJ0AAAJ

PD Sheehan · Answer

I've had the same issues with the Cloud Load Balancer.

I only got through the setup wizard when going directly against the compute engine instance and bypassing the CLB.

After that, you can enable the CLB and connect through that with relative success.

But it does cause me to worry about the inherent stability of the CLB and the appropriateness of using it for Atlassian apps. I get occasional health check failure where the backend can't be picked up. But I usually get the expected page after a refresh.

I'd love to hear if anyone else has attempted this.

So far, we only have a test instance (jira, confluence, bamboo, fisheye, bitbucket), but our IT infrastructure guys really want us to move the whole Atlassian suite to GCP.

Raul Pelaez _QUABU SOLUTIONS_ · Answer

Finally if you install the services without using the Google Cloud load balancer the process works fine. I have tried with Jira 8.2 and Confluence 6.15 and now is ok!

That's the trick!