yepyae

Edx Analytics insight error

Aug 1st, 2019
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.74 KB | None | 0 0
  1. TASK [edx_django_service : migrate database] ****************************************************************************************************
  2. task path: /root/configuration/playbooks/roles/edx_django_service/tasks/main.yml:114
  3. Using module file /root/ansible/local/lib/python2.7/site-packages/ansible/modules/commands/command.py
  4. <localhost> ESTABLISH LOCAL CONNECTION FOR USER: root
  5. <localhost> EXEC /bin/sh -c 'echo ~root && sleep 0'
  6. <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'
  7. <localhost> PUT /root/.ansible/tmp/ansible-local-7207f9uwCC/tmpM8uF9U TO /var/tmp/ansible-tmp-1564648522.22-229505844115071/command.py
  8. <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'
  9. <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'
  10. <localhost> EXEC /bin/sh -c 'rm -f -r /var/tmp/ansible-tmp-1564648522.22-229505844115071/ > /dev/null 2>&1 && sleep 0'
  11. fatal: [localhost]: FAILED! => {
  12. "changed": true,
  13. "cmd": [
  14. "make",
  15. "migrate"
  16. ],
  17. "delta": "0:00:30.733791",
  18. "end": "2019-08-01 08:35:53.056853",
  19. "invocation": {
  20. "module_args": {
  21. "_raw_params": "make migrate",
  22. "_uses_shell": false,
  23. "chdir": "/edx/app/analytics_api/analytics_api",
  24. "creates": null,
  25. "executable": null,
  26. "removes": null,
  27. "stdin": null,
  28. "warn": true
  29. }
  30. },
  31. "msg": "non-zero return code",
  32. "rc": 2,
  33. "start": "2019-08-01 08:35:22.323062",
  34. "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",
  35. "stderr_lines": [
  36. "Traceback (most recent call last):",
  37. " File \"./manage.py\", line 10, in <module>",
  38. " execute_from_command_line(sys.argv)",
  39. " 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",
  40. " utility.execute()",
  41. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 356, in execute",
  42. " self.fetch_command(subcommand).run_from_argv(self.argv)",
  43. " 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",
  44. " self.execute(*args, **cmd_options)",
  45. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 327, in execute",
  46. " self.check()",
  47. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/management/base.py\", line 359, in check",
  48. " include_deployment_checks=include_deployment_checks,",
  49. " 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",
  50. " issues = run_checks(tags=[Tags.database])",
  51. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/core/checks/registry.py\", line 81, in run_checks",
  52. " new_errors = check(app_configs=app_configs)",
  53. " 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",
  54. " issues.extend(conn.validation.check(**kwargs))",
  55. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 9, in check",
  56. " issues.extend(self._check_sql_mode(**kwargs))",
  57. " 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",
  58. " with self.connection.cursor() as cursor:",
  59. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 254, in cursor",
  60. " return self._cursor()",
  61. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 229, in _cursor",
  62. " self.ensure_connection()",
  63. " 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",
  64. " self.connect()",
  65. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/utils.py\", line 94, in __exit__",
  66. " six.reraise(dj_exc_type, dj_exc_value, traceback)",
  67. " 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",
  68. " self.connect()",
  69. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 189, in connect",
  70. " self.connection = self.get_new_connection(conn_params)",
  71. " 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",
  72. " conn = Database.connect(**conn_params)",
  73. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/__init__.py\", line 81, in Connect",
  74. " return Connection(*args, **kwargs)",
  75. " File \"/edx/app/analytics_api/venvs/analytics_api/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 193, in __init__",
  76. " super(Connection, self).__init__(*args, **kwargs2)",
  77. "django.db.utils.OperationalError: (1045, \"Access denied for user 'migrate'@'localhost' (using password: YES)\")",
  78. "make: *** [migrate] Error 1"
  79. ],
  80. "stdout": "./manage.py migrate --noinput --run-syncdb --database=default\nMakefile:83: recipe for target 'migrate' failed",
  81. "stdout_lines": [
  82. "./manage.py migrate --noinput --run-syncdb --database=default",
  83. "Makefile:83: recipe for target 'migrate' failed"
  84. ]
  85. }
  86.  
  87. NO MORE HOSTS LEFT ******************************************************************************************************************************
  88. to retry, use: --limit @/root/configuration/playbooks/analytics_single.retry
  89.  
  90. PLAY RECAP **************************************************************************************************************************************
  91. localhost : ok=106 changed=26 unreachable=0 failed=1
  92.  
  93. INFO:ansible.plugins.callback.task_timing: Install aws python packages --------------------------------------------------- 122.44s
  94. INFO:ansible.plugins.callback.task_timing: Install system packages -------------------------------------------------------- 52.40s
  95. INFO:ansible.plugins.callback.task_timing: Install supervisor in its venv [1] --------------------------------------------- 42.75s
  96. INFO:ansible.plugins.callback.task_timing: Update apt-get ----------------------------------------------------------------- 36.48s
  97. INFO:ansible.plugins.callback.task_timing: Gather ec2 facts for use in other roles ---------------------------------------- 35.70s
  98. INFO:ansible.plugins.callback.task_timing: Install supervisor in its venv [0] --------------------------------------------- 31.48s
  99. INFO:ansible.plugins.callback.task_timing: migrate database --------------------------------------------------------------- 31.17s
  100. INFO:ansible.plugins.callback.task_timing: Wait until cloud-init has finished running ------------------------------------- 26.35s
  101. INFO:ansible.plugins.callback.task_timing: Set the MTU to 1500 permanently ------------------------------------------------ 23.59s
  102. INFO:ansible.plugins.callback.task_timing: Update supervisor configuration ------------------------------------------------ 20.93s
  103. INFO:ansible.plugins.callback.task_timing:
  104. 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.
  105.  
  106. (ansible) root@ip-172-31-7-114:~/configuration/playbooks#
Add Comment
Please, Sign In to add comment