It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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>
args.func(args)
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
subprocess.check_output(cmd)
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

0 votes

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
TAGS
Community showcase
Published in Hipchat

Hipchat Cloud and Stride have reached End of Life (updated)

All good things come to an end - thanks to all our customers and partners who have been along the Hipchat and Stride journey with us.  As of Feb 15th 2019, Hipchat Cloud and Stride have reached ...

35,198 views 9 8
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you