[DRILL-7627] Update MySql version for JdbcStoragePlugin tests and cache ~/.embedmysql

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Arina Ielchiieva
• Reviewer: Vova Vysotskyi
• Created: 06/Mar/20 13:04
• Updated: 10/Mar/20 18:47
• Resolved: 10/Mar/20 18:47

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.

Issue Links

• links to: GitHub Pull Request #2014