Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TASK [edx_django_service : migrate database] ****************************************************************************************************
- task path: /root/configuration/playbooks/roles/edx_django_service/tasks/main.yml:114
- Using module file /root/ansible/local/lib/python2.7/site-packages/ansible/modules/commands/command.py
- <localhost> ESTABLISH LOCAL CONNECTION FOR USER: root
- <localhost> EXEC /bin/sh -c 'echo ~root && sleep 0'
- <localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /var/tmp/ansible-tmp-1564648522.22-229505844115071 `" && echo ansible-tmp-1564648522. 22-229505844115071="` echo /var/tmp/ansible-tmp-1564648522.22-229505844115071 `" ) && sleep 0'
- <localhost> PUT /root/.ansible/tmp/ansible-local-7207f9uwCC/tmpM8uF9U TO /var/tmp/ansible-tmp-1564648522.22-229505844115071/command.py
- <localhost> EXEC /bin/sh -c 'setfacl -m u:analytics_api:r-x /var/tmp/ansible-tmp-1564648522.22-229505844115071/ /var/tmp/ansible-tmp-1564648522.2 2-229505844115071/command.py && sleep 0'
- <localhost> EXEC /bin/sh -c 'sudo -H -S -n -u analytics_api /bin/sh -c '"'"'echo BECOME-SUCCESS-jovlftbaigbxbajbhkrewajsblphzrdo; DB_MIGRATION_PA SS=password PATH=/edx/app/analytics_api/nodeenvs/analytics_api/bin:/edx/app/analytics_api/venvs/analytics_api/bin:/root/ansible/bin:/usr/local/sb in:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin ANALYTICS_API_CFG=/edx/etc/analytics_api.yml DJANGO_SETTING S_MODULE=analyticsdataserver.settings.production DB_MIGRATION_USER=migrate /usr/bin/python /var/tmp/ansible-tmp-1564648522.22-229505844115071/com mand.py'"'"' && sleep 0'
- <localhost> EXEC /bin/sh -c 'rm -f -r /var/tmp/ansible-tmp-1564648522.22-229505844115071/ > /dev/null 2>&1 && sleep 0'
- fatal: [localhost]: FAILED! => {
- "changed": true,
- "cmd": [
- "make",
- "migrate"
- ],
- "delta": "0:00:30.733791",
- "end": "2019-08-01 08:35:53.056853",
- "invocation": {
- "module_args": {
- "_raw_params": "make migrate",
- "_uses_shell": false,
- "chdir": "/edx/app/analytics_api/analytics_api",
- "creates": null,
- "executable": null,
- "removes": null,
- "stdin": null,
- "warn": true
- }
- },
- "msg": "non-zero return code",
- "rc": 2,
- "start": "2019-08-01 08:35:22.323062",
- "stderr": "Traceback (most recent call last):\n File \"./manage.py\", line 10, in <module>\n execute_from_command_line(sys.argv)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 364, in execute_from_command_line\n utility.execute()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 356, in execute\n self.fetch_command(subcommand).run_from_argv(self.argv)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 283, in run_from_argv\n self.execute(*args, **cmd_options)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 327, in execute\n self.check()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 359, in check\n include_deployment_checks=include_deployment_checks,\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py\", line 61, in _run_checks\n issues = run_checks(tags=[Tags.database])\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/checks/registry.py\", line 81, in run_checks\n new_errors = check(app_configs=app_configs)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/checks/database.py\", line 10, in check_database_backends\n issues.extend(conn.validation.check(**kwargs))\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 9, in check\n issues.extend(self._check_sql_mode(**kwargs))\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 13, in _check_sql_mode\n with self.connection.cursor() as cursor:\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 254, in cursor\n return self._cursor()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 229, in _cursor\n self.ensure_connection()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 213, in ensure_connection\n self.connect()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/utils.py\", line 94, in __exit__\n six.reraise(dj_exc_type, dj_exc_value, traceback)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 213, in ensure_connection\n self.connect()\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 189, in connect\n self.connection = self.get_new_connection(conn_params)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 274, in get_new_connection\n conn = Database.connect(**conn_params)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/__init__.py\", line 81, in Connect\n return Connection(*args, **kwargs)\n File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 193, in __init__\n super(Connection, self).__init__(*args, **kwargs2)\ndjango.db.utils.OperationalError: (1045, \"Access denied for user 'migrate'@'localhost' (using password: YES)\")\nmake: *** [migrate] Error 1",
- "stderr_lines": [
- "Traceback (most recent call last):",
- " File \"./manage.py\", line 10, in <module>",
- " execute_from_command_line(sys.argv)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 364, in execute_from_command_line",
- " utility.execute()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 356, in execute",
- " self.fetch_command(subcommand).run_from_argv(self.argv)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 283, in run_from_argv",
- " self.execute(*args, **cmd_options)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 327, in execute",
- " self.check()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 359, in check",
- " include_deployment_checks=include_deployment_checks,",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py\", line 61, in _run_checks",
- " issues = run_checks(tags=[Tags.database])",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/checks/registry.py\", line 81, in run_checks",
- " new_errors = check(app_configs=app_configs)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/checks/database.py\", line 10, in check_database_backends",
- " issues.extend(conn.validation.check(**kwargs))",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 9, in check",
- " issues.extend(self._check_sql_mode(**kwargs))",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 13, in _check_sql_mode",
- " with self.connection.cursor() as cursor:",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 254, in cursor",
- " return self._cursor()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 229, in _cursor",
- " self.ensure_connection()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 213, in ensure_connection",
- " self.connect()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/utils.py\", line 94, in __exit__",
- " six.reraise(dj_exc_type, dj_exc_value, traceback)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 213, in ensure_connection",
- " self.connect()",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 189, in connect",
- " self.connection = self.get_new_connection(conn_params)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 274, in get_new_connection",
- " conn = Database.connect(**conn_params)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/__init__.py\", line 81, in Connect",
- " return Connection(*args, **kwargs)",
- " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 193, in __init__",
- " super(Connection, self).__init__(*args, **kwargs2)",
- "django.db.utils.OperationalError: (1045, \"Access denied for user 'migrate'@'localhost' (using password: YES)\")",
- "make: *** [migrate] Error 1"
- ],
- "stdout": "./manage.py migrate --noinput --run-syncdb --database=default\nMakefile:83: recipe for target 'migrate' failed",
- "stdout_lines": [
- "./manage.py migrate --noinput --run-syncdb --database=default",
- "Makefile:83: recipe for target 'migrate' failed"
- ]
- }
- NO MORE HOSTS LEFT ******************************************************************************************************************************
- to retry, use: --limit @/root/configuration/playbooks/analytics_single.retry
- PLAY RECAP **************************************************************************************************************************************
- localhost : ok=106 changed=26 unreachable=0 failed=1
- INFO:ansible.plugins.callback.task_timing: Install aws python packages --------------------------------------------------- 122.44s
- INFO:ansible.plugins.callback.task_timing: Install system packages -------------------------------------------------------- 52.40s
- INFO:ansible.plugins.callback.task_timing: Install supervisor in its venv [1] --------------------------------------------- 42.75s
- INFO:ansible.plugins.callback.task_timing: Update apt-get ----------------------------------------------------------------- 36.48s
- INFO:ansible.plugins.callback.task_timing: Gather ec2 facts for use in other roles ---------------------------------------- 35.70s
- INFO:ansible.plugins.callback.task_timing: Install supervisor in its venv [0] --------------------------------------------- 31.48s
- INFO:ansible.plugins.callback.task_timing: migrate database --------------------------------------------------------------- 31.17s
- INFO:ansible.plugins.callback.task_timing: Wait until cloud-init has finished running ------------------------------------- 26.35s
- INFO:ansible.plugins.callback.task_timing: Set the MTU to 1500 permanently ------------------------------------------------ 23.59s
- INFO:ansible.plugins.callback.task_timing: Update supervisor configuration ------------------------------------------------ 20.93s
- INFO:ansible.plugins.callback.task_timing:
- Playbook Deploy all analytics services to a single node finished: 2019-08-01 08:35:53.314951, 265 total tasks. 0:09:45.940376 elapsed.
- (ansible) root@ip-172-31-7-114:~/configuration/playbooks#
Add Comment
Please, Sign In to add comment