Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7627

Update MySql version for JdbcStoragePlugin tests and cache ~/.embedmysql

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.18.0
    • Component/s: None
    • Labels:

      Description

      When running tests on clean env (or when ~/.embedmysql is cleaned), currently there are issues when downloading MySQL version v5_6_21, download hangs and JdbcStoragePlugin tests fail with timeout.

      Download Version 5.6.21:Linux:B64 START
      Download Version 5.6.21:Linux:B64 DownloadSize: 311516309
      Download Version 5.6.21:Linux:B64 0%
      Download Version 5.6.21:Linux:B64 5%
      Download Version 5.6.21:Linux:B64 10%
      Download Version 5.6.21:Linux:B64 15%
      Download Version 5.6.21:Linux:B64 20%
      Download Version 5.6.21:Linux:B64 25%
      Download Version 5.6.21:Linux:B64 30%
      Download Version 5.6.21:Linux:B64 35%
      Download Version 5.6.21:Linux:B64 40%
      Download Version 5.6.21:Linux:B64 45%
      Download Version 5.6.21:Linux:B64 50%
      Download Version 5.6.21:Linux:B64 55%
      Download Version 5.6.21:Linux:B64 60%
      TestJdbcPluginWithMySQLIT.initMysql:70 ยป Distribution java.net.SocketTimeoutEx.
      

      Workaround is manually to download MySQL:

      mkdir -p ~/.embedmysql/MySQL-5.6
      wget -P ~/Downloads http://mirror.cogentco.com/pub/mysql/MySQL-5.6/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
      cp ~/Downloads/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz ~/.embedmysql/MySQL-5.6/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
      

      Upgrading to the latest available MySQL version (5_7_27) fixes this issue.

      Also it would be nice to cache ~/.embedmysql folder during GitHub Actions CI run to spare time spent on downloading and unpacking.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                arina Arina Ielchiieva
                Reviewer:
                Vova Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: