Hipchat Datacenter deployment sql cwd_application Edited

I deployed the latest Hipchat Datacenter OVA (3.0.1) followed every step.

Got errors from the beginning, even though the selfcheck comes back ok.

root@twhc:/hipchat/config# hipchat datacenter restart
Updating system configuration, this may take a few minutes...
Traceback (most recent call last):
File "/opt/atlassian/hipchat/sbin/_datacenter.py", line 314, in <module>
File "/opt/atlassian/hipchat/sbin/_datacenter.py", line 290, in restart
if not restarter.apply_configs_and_restart():
File "/opt/atlassian/hipchat/sbin/_datacenter.py", line 177, in apply_configs_and_restart
if chef_solo.run():
File "/opt/atlassian/hipchat/sbin/_hcutils.py", line 113, in run
File "/usr/lib/python2.7/subprocess.py", line 573, in check_output
raise CalledProcessError(retcode, cmd, output=output)
subprocess.CalledProcessError: Command '['sudo', '/opt/atlassian/hipchat/sbin/cs']' returned non-zero exit status 1

root@twhc:/hipchat/config# hipchat datacenter selfcheck
Redis Validation
- Connection - ✓
- Authentication - ✓
- Write - ✓

Database Validation
- Connection - ✓
- Authentication - ✓
- Max Connection - ✓
- Table - ✓

Nfs Validation
- Connection - ✓

Share Validation for root user
- Write - ✓
- Read - ✓
- Delete - ✓

Share Validation for root user
- Write - ✓
- Read - ✓
- Delete - ✓

Hostname Validation
- Hostname - ✓

I'm still getting "sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "cwd_application" does not exist" 

I've looked at https://jira.atlassian.com/browse/HCPUB-3268

but in the new OVA, hipchat-crowd-schema.sh doesn't exist, and on the old OVA the workaround doesn't work.  



1 answer

Hi, Chuck.

Thanks for reaching out to Atlassian Community.

Although we can have an idea of the issue you are experiencing based on the output you provided, we can not, at this point, determine what is the exact root cause of this issue. We suggest you to ensure the deployment was performed according to the following documentation:

Deploy HipChat DataCenter
Deployment Options and Sizing Guideline

Also, based on past cases, we highly recommend you to review your configuration.json file to make sure you have the settings correctly listed there.
You can find more information here on how to generate this file.

If you ensured that your settings are correct and that the deployment was made in accordance with the instructions above, I recommend you to raise a support ticket so we will be able to request relevant logs and provide the guidance you need.

Please find instructions on how to raise a support ticket here. We will be more than happy to assist you!

Best regards,

Allan Oliveira
Atlassian Support.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 14, 2018 in Hipchat Cloud

Hipchat Cloud and Stride End of Life: Just over 90 days away

Earlier this year we made the difficult decision to discontinue our team messaging tools, Stride and Hipchat. The end of life date for Stride and Hipchat Cloud is quickly approaching - February 15, 2...

498 views 0 2
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you