Git Product home page Git Product logo

Comments (6)

hakamine avatar hakamine commented on August 28, 2024

@jraddaoui the ansible-percona travis test for trusty passed with the default of 5.6 so this is unexpected 😞. Anything helpful in the error logs?
According to percona lifecycle doc only subscribers get security updates/bug fixes for 5.5 (so having 5.6 working on trusty would be a good thing).

from deploy-pub.

jraddaoui avatar jraddaoui commented on August 28, 2024

Hi @hakamine ,

In atom-trusty, using Percona 5.6, when the "Purge database" task is reached, MySQL is down:

TASK [artefactual.atom : Purge database] ***************************************
fatal: [atom-local]: FAILED! => {"changed": true, "cmd": ["php", "symfony", "tools:purge", "--no-confirmation", "[email protected]", "--username=demo", "--password=demo", "--title=AtoM", "--description=Access to Memory", "--url=http://undefined"], "delta": "0:00:02.138478", "end": "2018-05-10 19:02:17.061185", "msg": "non-zero return code", "rc": 1, "start": "2018-05-10 19:02:14.922707", "stderr": "\n                                                                                                                      \n  Unable to open PDO connection [wrapped: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)]  \n                                                                                                                      ", "stderr_lines": ["", "                                                                                                                      ", "  Unable to open PDO connection [wrapped: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)]  ", "                                                                                                                      "], "stdout": "", "stdout_lines": []}

Here's /var/log/mysql/error.log after that fail, which looks to be a normal shutdown ...

https://gist.github.com/jraddaoui/89543b2d7901e5e72987628cc3cbaaed

from deploy-pub.

jraddaoui avatar jraddaoui commented on August 28, 2024

And sudo service mysql start does not bring it up and does not add anything to that log.

from deploy-pub.

hakamine avatar hakamine commented on August 28, 2024

@jraddaoui It looks like the problem is not with percona 5.6 but with the playbook running the role ansible-percona-client that installs a 5.5 client, just right after the ansible-percona role installs the 5.6 server. The ansible-percona-client is not required (the ansible-percona role with install both server and client). I created PR #78 with a fix.

from deploy-pub.

jraddaoui avatar jraddaoui commented on August 28, 2024

That's a lot better, thanks @hakamine!

from deploy-pub.

jraddaoui avatar jraddaoui commented on August 28, 2024

I've tested in both Vagrant boxes and merged.

from deploy-pub.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.