search

microsoft / oxa-tools

Open edX on Azure Tools
MIT License
36 stars 103 forks source link

EdX Database (Mysql) Setup Failed #414

Closed basurero0 closed 5 years ago

basurero0 commented 5 years ago

Hi, I tried to install the ficus version acording to the guide but the process fails in:

TASK [rbenv : install rake gem] **** changed: [localhost]

TASK [rbenv : update rubygems] ***** fatal: [localhost]: FAILED! => {"changed": true, "cmd": "gem install rubygems-update && update_rubygems", "delta": "0:00:01.723812", "end": "2018-12-21 10:21:08.833622", "failed": true, "rc": 1, "start": "2018-12-21 10:21:07.109810", "stderr": "ERROR: Error installing rubygems-update:\n\trubygems-update requires Ruby version >= 2.3.0.", "stdout": "", "stdout_lines": [], "warnings": []} to retry, use: --limit @/oxa/configuration/playbooks/edx_sandbox.retry

PLAY RECAP ***** localhost : ok=196 changed=145 unreachable=0 failed=1

INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: migrate [0] ------------------------------------------------------------------- 1266.77s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install python requirements [0] ----------------------------------------------- 794.25s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install ruby 1.9.3-p551 ------------------------------------------------------- 296.79s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: code sandbox | Install sandbox requirements into sandbox venv [0] ------------- 160.06s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install python requirements [1] ------------------------------------------------ 87.01s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install application requirements [1] ------------------------------------------- 86.82s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: checkout edx-platform repo into /edx/app/edxapp/edx-platform [0] --------------- 84.03s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: Install system packages -------------------------------------------------------- 73.53s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install python extra requirements [0] ------------------------------------------ 60.43s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: install python extra requirements [1] ------------------------------------------ 49.80s INFO:/oxa/configuration/playbooks/callback_plugins/task_timing: Playbook Configure instance(s) finished: 2018-12-21 18:21:08.861741, 407 total tasks. 0:56:26.936029 elapsed.

  • exit_on_error 'Execution of edX MySQL migrations failed' 1 'OXA Bootstrap - edx2gtbr - EdX Database (Mysql) Setup Failed' xxxx@xxxx.xxx /var/log/bootstrap.log /var/log/bootstrap.csx.log
  • [[ 2 -ne 0 ]]
  • log 'Execution of edX MySQL migrations failed' 1
  • [[ ! -z '' ]] ++ date '+%D %T'
  • TIMESTAMP='12/21/18 10:21:09'
  • LOG_MESSAGE='12/21/18 10:21:09 :: Execution of edX MySQL migrations failed'
  • [[ ! -z 1 ]]
  • LOG_MESSAGE='12/21/18 10:21:09 :: [ERROR] Execution of edX MySQL migrations failed'
  • echo 12/21/18 10:21:09 :: '[ERROR]' Execution of edX MySQL migrations failed

And only emails arrive with:

What could be the error?

Abel-Liu commented 5 years ago

Me too. Anyone konw how to fix it? Maybe update Ruby in some scripts?

Abel-Liu commented 5 years ago

I have installed successfully by change gem version in edx-configuration repository.

See https://github.com/Microsoft/edx-configuration/pull/405/files

eltoncarr commented 5 years ago

We are preparing the change and will propagate across our branches. Please keep track of that PR.

RepoCloudSwyft commented 5 years ago

Hi same error here.Please help. Error message below: exit_on_error 'Execution of edX MySQL migrations failed' 1 'OXA Bootstrap - mylaast - EdX Database (Mysql) Setup Failed' xxx@xxx.com /var/log/bootstrap.log /var/log/bootstrap.csx.log

Please help us on how to fix it.thanks

microdevil commented 5 years ago

bootstrap.csx.log bootstrap (1).log

Hi

Have this problem solved ?

I got same problem

Thanks

RepoCloudSwyft commented 5 years ago

Hi,

We still fixing it right now. Since last night still getting this error msg 06/19/19 04:00:27 :: Backing up 'mysql' database to local file system /datadisks/disk1/var/tmp ~ 06/19/19 04:00:27 :: ADDING oxamysqlbackupuser user to mysql db mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1470 (HY000) at line 1: String 'oxamysqlbackupuser' is too long for user name (should be no longer than 16) mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table django_comment_client_role_users at row: 0 06/19/19 04:00:31 :: [ERROR] Unable to backup mysql!

Any idea,how to fix? Really need to solve.

microdevil commented 5 years ago

Hi

I have fixed this issue by changing pymongo version of edx-platform from 2.9.1 to 3.2. To change this version, i have to fork the source code to my organization's repository.

You can see my updated here.

https://github.com/ontoio/edx-platform/tree/oxa/master.fic

Thanks

RepoCloudSwyft commented 4 years ago

Hi @microdevil

I try to change pymongo version as you said, however, we received error message mysqldump: Got error: 2003: Can't connect to MySQL server on '10.0.0.16' (111) when trying to connect 09/17/19 20:00:29 :: [ERROR] Unable to backup mysql!

Can you help us how to fix it? Thanks