Hipchat Datacenter deployment sql cwd_application

[Chuck Hou]

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.  

[Allan]

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.