Presto 0.265 build crash: Dependency problems found

[d9k]

> ./mvnw clean install
. . . . .
TestMySqlFunctionNamespaceManager.setup:99 » IO mysqld exited with value 1
. . . . .

> ./mvnw clean install -DskipTests -Dmaven.test.skip=true
. . . . .
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-dependency-plugin:3.1.1:analyze-only (default) on project presto-cli:
 Dependency problems found -> [Help 1]

software info:

> uname -a
Linux 4.15.0-162-generic #170-Ubuntu SMP Mon Oct 18 11:38:05 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

> cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=18.04
DISTRIB_CODENAME=bionic
DISTRIB_DESCRIPTION="Ubuntu 18.04.6 LTS"

> java -version
openjdk version "1.8.0_292"
OpenJDK Runtime Environment (build 1.8.0_292-8u292-b10-0ubuntu1~18.04-b10)
OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)

> mvn --version
Apache Maven 3.6.0
Maven home: /usr/share/maven
Java version: 1.8.0_292, vendor: Private Build, runtime: /usr/lib/jvm/java-8-openjdk-amd64/jre
Default locale: en, platform encoding: UTF-8
OS name: "linux", version: "4.15.0-162-generic", arch: "amd64", family: "unix"

[d9k]

> ./mvnw --errors --debug clean install

the end of the log:
https://gist.github.com/d9k/366a4fdc2b67b2cf9172bd9741ccb830#file-presto-0-265-build-fail-log-txt

> mysqld --version
mysqld  Ver 5.7.36-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

> service mysql status
. . . . .
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Thu 2021-12-02 21:11:52 UTC; 40min ago
. . . . .

> ll /tmp/testing*
ls: cannot access '/tmp/testing*': No such file or directory

[d9k]

> ./mvnw clean install --errors --debug -DskipTests -Dmaven.test.skip=true

the end of the log:
https://gist.github.com/d9k/366a4fdc2b67b2cf9172bd9741ccb830#file-presto-0-265-build-skip-tests-fail-log-txt

[d9k]

Maybe the first error happens because running the build under root...

Never run the MySQL server as the Unix root user. This is extremely dangerous, because any user with the FILE privilege is able to cause the server to create files as root (for example, ~root/.bashrc). To prevent this, mysqld refuses to run as root unless that is specified explicitly using the --user=root option.

https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/security-against-attack.html

[d9k]

Created a user, ran ./mvnw clean install under it, the same error

[ERROR] Failures: 
[ERROR]   TestMySqlFunctionNamespaceManager.setup:99 » IO mysqld exited with value 1, ch...

[rongrong]

The test is self contained and will create a testing mysql server for test purpose. It does not require pre-existing mysql database running. I'm guessing you are seeing error because there's already a mysqld running? I cannot reproduce the error and I don't have mysql running locally at all.

[d9k]

The test is self contained and will create a testing mysql server for test purpose. It does not require pre-existing mysql database running. I'm guessing you are seeing error because there's already a mysqld running? I cannot reproduce the error and I don't have mysql running locally at all.

Why am I getting dependency errors when I skip tests ( ./mvnw clean install -DskipTests -Dmaven.test.skip=true)?

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-dependency-plugin:3.1.1:analyze-only (default) on project presto-cli:
 Dependency problems found

More detailed log is here:
https://gist.github.com/d9k/366a4fdc2b67b2cf9172bd9741ccb830#file-presto-0-265-build-skip-tests-fail-log-txt