[
https://issues.apache.org/jira/browse/DRILL-7627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7627:
------------------------------------
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.
{noformat}
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.
{noformat}
Workaround is manually to download MySQL:
{noformat}
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
{noformat}
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.
was:
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.
{noformat}
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.
{noformat}
Workaround is manually to download MySQL:
{noformat}
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
{noformat}
Upgrading to the latest available MySQL version (5_7_19) 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.
> Update MySql version in JdbcStoragePlugin tests and cache ~/.embedmysql
> ------------------------------------------------------------------------
>
> Key: DRILL-7627
> URL: https://issues.apache.org/jira/browse/DRILL-7627
> Project: Apache Drill
> Issue Type: Task
> Affects Versions: 1.17.0
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
> Priority: Major
> Fix For: 1.18.0
>
>
> 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.
> {noformat}
> 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.
> {noformat}
> Workaround is manually to download MySQL:
> {noformat}
> 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
> {noformat}
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
