Solvedawx Web Service not working due to missing instance for the host

ISSUE TYPE
  • Bug Report
COMPONENT NAME
  • UI
SUMMARY

After installation of AWX on a new server and migrating the date from an old AWX version to the newest. The Migration process fails with Creating a new Project. I have tried to connect the new project manually but I'm getting an error on the UI. "Failed to create new project. POST returned status: 500 A server error has occurred." This is a new installation on a completely different server than the older version.

ENVIRONMENT
  • AWX version: 2.0.1
  • AWX install method: docker on linux
  • Ansible version: 2.7.0
  • Operating System: CentOS Linux release 7.5.1804 (Core)
  • Web Browser: Google Chrome
STEPS TO REPRODUCE

Create new project on the UI and fill in all the necessary information then click Add.

EXPECTED RESULTS

Create a new project with a connection to a GITLAB Server.

ACTUAL RESULTS

"Failed to create new project. POST returned status: 500 A server error has occurred."

29 Answers

✔️Accepted Answer

I found the root cause of the problem lies between the file awx/installer/roles/image_build/files/launch_awx_task.sh and the template /installer/roles/kubernetes/templates/deployment.yml.j2 used for the kubernetes installation.

When the launcher is called, it checks if the variable $AWX_SKIP_MIGRATION is empty to perform the schema migration

if [ -z "$AWX_SKIP_MIGRATIONS" ]; then
awx-manage migrate --noinput
fi
however the value of $AWX_SKIP_MIGRATION is set to 1 in the kubernetes installer
env:
- name: AWX_SKIP_MIGRATIONS
value: "1"

so as the database is not migrated, the state of the schema seems inconsistent hence the following database related commands in the file launch_awx_task.sh are failing

awx-manage provision_instance --hostname=$(hostname)
awx-manage register_queue --queuename=tower --instance_percent=100

the value 1 for $AWX_SKIP_MIGRATION was set in commit 2b9954c. Setting this value to 0 fixes the problem for me.

Perhaps that should be reviewed by someone who has more knowledge than I do on that.

Hope this helps.

Related Issues:

15
awx Error with pip-docker (3.0.1): "Error connecting: load_config() got an unexpected keyword argument 'config_dict'"
For me even installing docker 3.1.3 resulted in errors What I had to do was: And the error stopped. ...
14
awx Playbook fails when ssh host key changes
Giant pain in Ansible Tower Anytime an IP is recycled we've got manually clear it from the known_hos...
12
awx Provide custom CA certificate or skip-verify option for LDAP auth
I'm just passing following env var to awxweb container: env: LDAPTLS_REQCERT: never ...
3
awx Web Service not working due to missing instance for the host
I found the root cause of the problem lies between the file awx/installer/roles/image_build/files/la...
143
ansible module_stdout: "/bin/sh: 1: /usr/bin/python: not found\r\n",
Just use ansible_python_interpreter=/usr/bin/python3 in ur inventory file ansible -m ping -u ubuntu ...
88
ansible error in cryptography setup command: Invalid environment marker: python_version < '3'
I had the same problem in Debian Jessie This is what I did to get it working for me: After this I wa...
88
ansible OSX crash complaining of operation in progress in another thread when fork() was called
This is apparently due to some new security changes made in High Sierra that are breaking lots of Py...
82
drupal vm Composer install fails without proper swap
or you can create a swap file sudo fallocate -l 2G /swapfile sudo chmod 600 /swapfile sudo mkswap /s...
77
kubespray After the certificate expires how use kubespray to renew certificate
@kerOssinas you are right the upgrade-cluster.yml of Kubespray will also rotate the certificates ...
72
ansible Failed to connect to the host via ssh: Permission denied (publickey,password)
Good It's a bit hard to debug when you specify all in your command I have this error I use Debian St...
71
ansible Describe how to use "postgresql_user" properly with ansible >= 2.1.0.0
I managed to get this temporarily working with pipelining per task and becoming postgres user: Hopef...
54
ansible ansible unable to find boto: boto required for this module
@stevenscg still working me with this in my inventory file: Let me know if that does anything for yo...
43
ansible why is ansible's default output not more human readable... stilll?
Ansible 2.4+ has built-in support for human-readable results: Temporarily by setting ANSIBLE_STDOUT_...
37
ansible Reboot and Wait for
An update of the docs and/or the support article to use the preferred full YAML format for tasks wou...
37
ansible ERROR! Timeout (12s) waiting for privilege escalation prompt:
Just as a note I switched the connection over to paramiko and the issue went away and the playbook r...
33
ansible Failed to import docker-py for docker_container module
docker-py is just the name of the project It installs a python package named docker ...
32
ansible json_query filter fails when using the functions "contains", "starts_with", others
The problem is related to the fact that Ansible uses own types for strings: AnsibleUnicode and Ansib...
32
kubespray Current install documentation is incorrect and does not work due to inventory script changes
@elfiii good luck. The install/usage documentation here: https://github.com/kubernetes-sigs/kubespra...
31
ansible feature: controlling ignore-errors output
From a UX perspective it seems reasonable to give visual distinction between explicitly ignored erro...
31
ansible elasticsearch Permissions on elasticsearch.keystore prevent Elasticsearch from starting
This entire problem is being caused by an incorrect mixing of static read-only configuration (elasti...
30
ansible Support specifying collections in git repositories in requirements.yml
This has become much more frustrating lately SUMMARY When I develop collections I like to store them...
29
ansible SSH works, but ansible throws unreachable error
This happende all of a sudden when I upgraded Ansible ISSUE TYPE Bug Report ANSIBLE VERSION CONFIGUR...
29
ansible Ansible evaluates with_items for tasks in blocks skipped by the block when condition
For anyone who finds this in future the way to have this work without the warning is to use with_ite...
29
ansible "template error while templating string: Missing end of comment tag" error
EDIT: When unsafe characters are defined in vars follow @inossidabile's recommendation to use !unsaf...
29
drupal vm Failing to install Drupal on macOS High Sierra - NFS filesystem issues
@ajhoddinott OMG That works thank you! For explicit instructions on Mac OS High Sierra open the app ...
28
kubespray etcd cluster is unavailable or misconfigured: connection refused
Run on master nodes: Run no all nodes: btw SELinux is working fine i did not had to do any adjustmen...
24
ansible ansible-galaxy should download dependencies in meta/main.yml
I heavily work with dependencies and meta/main.yml and it would be great to spare the necessity to m...
24
ansible Add an option lock_wait to the apt module
This should integrate with systemd ISSUE TYPE Feature Idea This is a copy of the issue on the old re...
23
ansible Windows 10/WSL: Ansible cannot read ansible.cfg from NTFS mounts
I think I found a solution for 2.6.1 and so on.. SUMMARY Ansible 2.6.1 added #42070 which makes Ansi...
22
kubespray Unable to add new master/etcd node to cluster
You should be able to In the past we managed to replace all nodes in the cluster: master etcd and wo...
21
ansible lint Re-evaluate E0010 - Package installs should not use latest
The official Ansible yum module docs prominently recommend using state=latest with name=* to update ...
20
ansible Anisble does not allow handling of "host unreachable" errors
Does anyone else agree we need to revisit how we are handling unreachable errors? We have a use case...
20
ansible delegate_to not propagated to include_role
I would say this is a huge issue If Ansible would have raised an error for combination of delegate_t...
18
ansible shared connection closed
Same for me on macOS: ISSUE TYPE Bug Report COMPONENT NAME Script module ANSIBLE VERSION CONFIGURATI...
17
openshift ansible Could not resolve host: github.com; Unknown error
Any updates on this? I have the exact same issue on an oc cluster up on CentOS 7 ...
17
algo Windows WSL: "Ansible is being run in a world writable directory"
Try to correct the problem by running the following while in the algo directory: ...
16
ansible Handle omit value in task attributes (like environment or become_user)
I too am interested in something similar to this In my use case we use the same playbook for multipl...
15
ansible FAILED! => {"msg": "Timeout (12s) waiting for privilege escalation prompt: "}
This happened to me after my internet connect dropped while running a playbook I fixed it by running...
15
openshift ansible No package matching 'origin-docker-excluder-3.10**' found available, installed or updated
Currently with that running openshift-ansible from master for all-on-one setup works internal reprod...
14
ansible apt_key module ignores the proxy environment
I'm using this as a workaround: ISSUE TYPE Bug Report COMPONENT NAME apt_key ANSIBLE VERSION SUMMARY...
13
molecule master: pip install -e . fails with TypeError: expected str, bytes or os.PathLike object, not NoneType
upgrade your pip via curl https://bootstrap.pypa.io/get-pip.py | python - I had same problem and I w...
13
ansible Failure in apt. "Please install python-apt", but it is installed
I ran into this issue using the local connection mode -c local using ansible from a virtualenv ...
13
ceph ansible ceph luminous with bluestore add osd failed
The problem here is that your old OSD auth details are with mon If you remove the OSD entry and its ...
13
drupal vm 503 Service Unavailable
@TheNugg Even I was facing the same issue I was not able access Drupal website it was throwing 503 e...
13
algo DigitalOcean: Error creating tags
Here's a patch file you can use to get going again Save the following patch to your algo directory i...
12
chrome aws lambda [BUG] Failed to launch chrome
I got this to work by only using await chromium.executablePath in prod as I know this issue has been...
12
molecule Make Ansible default verifier
I see some value in having a tool that is NOT Ansible to verify something that was modified by Ansib...
12
ansible [mac os x] ansible-galaxy: "unexpected Exception: name must be a byte string" when installing from requirements file
Upgrading urllib3 solved this problem for me: sudo pip install --upgrade urllib3 ...
12
ansible Support apt-mark hold
Full working example for reference from Ubuntu 16.04 and docker: From @scottnonnenberg on September ...
12
ansible Single Vault Encrypted value not decrypted in jinja2 pipeline
It still not work for password_hash It need to add string before using password_hash ...