clonedb.log 4.3 KB

1234567891011121314151617181920212223242526272829303132
  1. 2020-05-20 13:54:37,153 - INFO - Start db cloning utility...
  2. 2020-05-20 13:54:37,153 - DEBUG - Settings: {'servers': {'docker': {'host': 'localhost', 'description': 'Docker mariaDb', 'mysql': {'port': 3306, 'username': 'root', 'password': 'mysql660'}}, 'localhost': {'host': 'localhost', 'description': 'Local Mysql', 'mysql': {'port': 3305, 'username': 'root', 'password': 'mysql660'}}, 'preprod': {'host': 'preprod.2iopenservice.com', 'description': 'Preprod', 'mysql': {'port': 3306, 'username': 'dbcloner', 'password': 'wWZ4hYcrmHLW2mUK'}, 'ssh': {'key_file': '~/.ssh/id_rsa_exploitation', 'port': 22, 'user': 'exploitation'}}, 'prod-back': {'host': 'prod-back.2iopenservice.com', 'description': 'Prod-Back', 'mysql': {'port': 3306, 'username': 'dbcloner', 'password': 'wWZ4hYcrmHLW2mUK'}, 'ssh': {'key_file': '~/.ssh/id_rsa_exploitation', 'port': 22, 'user': 'exploitation'}}, 'prod-front': {'host': 'prod-front.2iopenservice.com', 'description': 'Prod-Front', 'mysql': {'port': 3306, 'username': 'dbcloner', 'password': 'wWZ4hYcrmHLW2mUK'}, 'ssh': {'key_file': '~/.ssh/id_rsa_exploitation', 'port': 22, 'user': 'exploitation'}}}, 'operations': {'crm': {'dbname': 'crm', 'from_server': 'preprod', 'to_server': 'docker', 'is_default': True, 'ignore_tables': [], 'ignore_views': [], 'structure_only': [], 'compress': True}, 'adminassos': {'dbname': 'adminassos', 'from_server': 'preprod', 'to_server': 'docker'}, 'openassos': {'dbname': 'openassos', 'from_server': 'preprod', 'to_server': 'docker', 'is_default': True, 'ignore_tables': ['Access', 'matomo.*', 'user_piwik.*', 'zzz_.*', 'tt_content_save', 'tt_content_v59'], 'structure_only': ['cf_cache_.*', 'sys_log']}, 'opentalent': {'dbname': 'opentalent', 'from_server': 'preprod', 'to_server': 'docker', 'structure_only': [], 'ignore_tables': ['Audit_.*'], 'ignore_views': ['view_audit']}, 'metabase': {'dbname': 'metabase', 'from_server': 'preprod', 'to_server': 'docker'}}}
  3. 2020-05-20 13:54:37,153 - DEBUG - Arguments: {'--help': False, '--version': False, '--yes': True, '-v': False, '<dbname>': 'crm'}
  4. 2020-05-20 13:54:37,155 - INFO - *** Cloning crm ***
  5. 2020-05-20 13:54:37,155 - INFO - > From Preprod (preprod.2iopenservice.com:3306 as dbcloner)
  6. 2020-05-20 13:54:37,155 - INFO - > To Docker mariaDb (localhost:3306 as root)
  7. 2020-05-20 13:54:37,895 - DEBUG - Connected to Preprod (preprod.2iopenservice.com:3306 as dbcloner)
  8. 2020-05-20 13:54:37,897 - DEBUG - Connected to Docker mariaDb (localhost:3306 as root)
  9. 2020-05-20 13:54:38,001 - INFO - (Re)create the database
  10. 2020-05-20 13:54:38,004 - INFO - Cloning structure for 16 tables (on 16)...
  11. 2020-05-20 13:54:38,005 - DEBUG - >>> Dump command: mysqldump --single-transaction -u dbcloner --password=wWZ4hYcrmHLW2mUK --skip-add-drop-table --skip-add-locks --skip-comments --compress --verbose --host 127.0.0.1 --port 6000 --single-transaction --no-data --routines crm cm_action cm_action_com cm_action_histo cm_asso cm_asso_trader cm_bank cm_contact cm_invoice cm_miscellaneous cm_miscellaneous_com cm_pes_assos_config cm_plugin_assos cm_plugins cm_product cm_product_net cm_trader
  12. 2020-05-20 13:54:38,005 - DEBUG - >>> Piped into: mysql -h localhost -P 3306 -u root --password=mysql660 --max-allowed-packet=1073741824 --reconnect --quick -D crm --compress
  13. 2020-05-20 13:54:39,663 - DEBUG - ... cm_action
  14. 2020-05-20 13:54:40,335 - DEBUG - ... cm_action_com
  15. 2020-05-20 13:54:41,006 - DEBUG - ... cm_action_histo
  16. 2020-05-20 13:54:41,672 - DEBUG - ... cm_asso
  17. 2020-05-20 13:54:42,340 - DEBUG - ... cm_asso_trader
  18. 2020-05-20 13:54:43,013 - DEBUG - ... cm_bank
  19. 2020-05-20 13:54:43,687 - DEBUG - ... cm_contact
  20. 2020-05-20 13:54:44,360 - DEBUG - ... cm_invoice
  21. 2020-05-20 13:54:45,122 - DEBUG - ... cm_miscellaneous
  22. 2020-05-20 13:54:45,970 - DEBUG - ... cm_miscellaneous_com
  23. 2020-05-20 13:54:46,662 - DEBUG - ... cm_pes_assos_config
  24. 2020-05-20 13:54:47,347 - DEBUG - ... cm_plugin_assos
  25. 2020-05-20 13:54:48,033 - DEBUG - ... cm_plugins
  26. 2020-05-20 13:54:48,746 - DEBUG - ... cm_product
  27. 2020-05-20 13:54:49,427 - DEBUG - ... cm_product_net
  28. 2020-05-20 13:54:50,110 - DEBUG - ... cm_trader
  29. 2020-05-20 13:54:51,173 - ERROR - Execution failed:
  30. 2020-05-20 13:54:51,174 - ERROR - <!> An error happened while cloning the 'crm' database
  31. 2020-05-20 13:54:51,234 - DEBUG - Preprod (preprod.2iopenservice.com:3306 as dbcloner) - connection closed
  32. 2020-05-20 13:54:51,235 - DEBUG - Docker mariaDb (localhost:3306 as root) - connection closed