Pipeline failed when starting Tests with MySQL error, just started today

Drew Schulz

I've been running pipelines for a couple of weeks with no issues, then today I get this error when my tests start:

<span>Creating test database for alias 'default'...<br></span><span>Traceback (most recent call last):</span><span> <br>  File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection</span><span> <br>    self.connect()</span><span> <br>  File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py", line 194, in connect</span><span> <br>    self.connection = self.get_new_connection(conn_params)</span><span> <br>  File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 236, in get_new_connection</span><span> <br>    return Database.connect(**conn_params)</span><span> <br>  File "/usr/local/lib/python3.6/site-packages/MySQLdb/__init__.py", line 86, in Connect</span><span> <br>    return Connection(*args, **kwargs)</span><span> <br>  File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 204, in __init__</span><span> <br>    super(Connection, self).__init__(*args, **kwargs2)</span><span>_mysql_exceptions.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory")<br><br></span><span>The above exception was the direct cause of the following exception:</span><span>+ python <a href="http://manage.py/" target="_blank" rel="nofollow noopener noreferrer">manage.py</a> test<br></span>

 my pipeline spec looks like this:

image: python:3.6.4

pipelines:
  default:
    - step:
        script:
          - echo "Placeholder..."
  branches:
    develop:
      - step:
          name: Deploy to Staging
          caches:
            - pip
          deployment: staging
          script:
            - echo "Building out PIP installation..."
            - pip install -r requirements.txt
            - pip install awsebcli --upgrade
            - echo "Develop branch testing run..."
            - python manage.py test
            - eb init <name> -r us-west-2 -p python-3.6
            - eb deploy <name>
          services:
            - mysql
definitions:
  services:
    mysql:
      image: mysql
      environment:
        MYSQL_DATABASE: 'casa'
        MYSQL_ROOT_PASSWORD: 'let_me_in'

Nothing changed on the pipeline setup, but the MySQL connection seems to fail now 

Jason Gloudon

We had to update our pipeline to use mysql 5.7 since the mysql docker image is now mysql 8, which is setup to require this client plugin.

mysql:
image: mysql:5.7