[ https://issues.apache.org/jira/browse/FLINK-24112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17408209#comment-17408209 ]
Matthias edited comment on FLINK-24112 at 9/1/21, 2:50 PM: ----------------------------------------------------------- The workaround from the [MariaDB4J #48 issue|https://github.com/vorburger/MariaDB4j/issues/48] with creating symlinks didn't work. I guess, the two versions of the crypto library are not compatible: {code} dyld: lazy symbol binding failed: Symbol not found: _SSLeay_version Referenced from: /private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/mysqld Expected in: /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib {code} was (Author: mapohl): The workaround from the MariaDB4J #48 issue with creating symlinks didn't work. I guess, the two versions of the crypto library are not compatible: {code} dyld: lazy symbol binding failed: Symbol not found: _SSLeay_version Referenced from: /private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/mysqld Expected in: /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib {code} > Embedded MariaDB cannot be instantiated on MacOS > ------------------------------------------------ > > Key: FLINK-24112 > URL: https://issues.apache.org/jira/browse/FLINK-24112 > Project: Flink > Issue Type: Bug > Components: Connectors / JDBC > Affects Versions: 1.14.0 > Reporter: Matthias > Priority: Major > Labels: test-stability > > {{UnsignedTypeConversionITCase}} fails when executing it locally on MacOS. It > fails to start the embedded MariaDB instance. This issue seems to be > MacOS-related and is caused by MariaDB4j (see related [Issue > #48|https://github.com/vorburger/MariaDB4j/issues/48]). > {code} > org.apache.commons.exec.ExecuteException: Process exited with an error: 1 > (Exit value: 1) > at > org.apache.commons.exec.DefaultExecutor.executeInternal(DefaultExecutor.java:404) > ~[commons-exec-1.3.jar:1.3] > at > org.apache.commons.exec.DefaultExecutor.access$200(DefaultExecutor.java:48) > ~[commons-exec-1.3.jar:1.3] > at > org.apache.commons.exec.DefaultExecutor$1.run(DefaultExecutor.java:200) > [commons-exec-1.3.jar:1.3] > at java.lang.Thread.run(Thread.java:748) [?:1.8.0_265] > 3472 [main] ERROR ch.vorburger.exec.ManagedProcess [] - Program > [/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/mysql_install_db, > > --datadir=/private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/data/56651, > > --basedir=/private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base, > --no-defaults, --force, --skip-name-resolve] (in working directory > /var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base) failed > 3473 [main] WARN > org.apache.flink.connector.jdbc.table.UnsignedTypeConversionITCase [] - > Initialize DB failed. > ch.vorburger.exec.ManagedProcessException: An error occurred while installing > the database > at ch.vorburger.mariadb4j.DB.install(DB.java:134) > ~[mariaDB4j-core-2.4.0.jar:?] > at ch.vorburger.mariadb4j.DB.newEmbeddedDB(DB.java:81) > ~[mariaDB4j-core-2.4.0.jar:?] > at > org.apache.flink.connector.jdbc.table.UnsignedTypeConversionITCase.prepareMariaDB(UnsignedTypeConversionITCase.java:80) > [test-classes/:?] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > ~[?:1.8.0_265] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_265] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_265] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_265] > at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) > [junit-4.13.2.jar:4.13.2] > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > [junit-4.13.2.jar:4.13.2] > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) > [junit-4.13.2.jar:4.13.2] > at > org.junit.internal.runners.statements.RunBefores.invokeMethod(RunBefores.java:33) > [junit-4.13.2.jar:4.13.2] > at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) > [junit-4.13.2.jar:4.13.2] > at > org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54) > [junit-4.13.2.jar:4.13.2] > at > org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54) > [junit-4.13.2.jar:4.13.2] > at org.junit.rules.RunRules.evaluate(RunRules.java:20) > [junit-4.13.2.jar:4.13.2] > at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) > [junit-4.13.2.jar:4.13.2] > at org.junit.runners.ParentRunner.run(ParentRunner.java:413) > [junit-4.13.2.jar:4.13.2] > at org.junit.runner.JUnitCore.run(JUnitCore.java:137) > [junit-4.13.2.jar:4.13.2] > at > com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) > [junit-rt.jar:?] > at > com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33) > [junit-rt.jar:?] > at > com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:221) > [junit-rt.jar:?] > at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54) > [junit-rt.jar:?] > Caused by: ch.vorburger.exec.ManagedProcessException: Program > [/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/mysql_install_db, > > --datadir=/private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/data/56651, > > --basedir=/private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base, > --no-defaults, --force, --skip-name-resolve] (in working directory > /var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base) failed, > exitValue=1, last 100 lines of console: > dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib > Referenced from: > /private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/my_print_defaults > Reason: image not found > Installing MariaDB/MySQL system tables in > '/private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/data/56651' > ... > dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib > Referenced from: > /private/var/folders/bd/6xl5m4z90j9438dv5bxg2n180000gn/T/MariaDB4j/base/bin/mysqld > Reason: image not found > {code} > I have MacOS BigSur (11.5.2) and openssl 1.1.1l installed on my system: > {code} > $ brew info openssl > openssl@1.1: stable 1.1.1l (bottled) [keg-only] > Cryptography and SSL/TLS Toolkit > https://openssl.org/ > /usr/local/Cellar/openssl@1.1/1.1.1k (8,071 files, 18.5MB) > Poured from bottle on 2021-05-11 at 08:41:15 > From: > https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/open...@1.1.rb > License: OpenSSL > ==> Caveats > A CA file has been bootstrapped using certificates from the system > keychain. To add additional certificates, place .pem files in > /usr/local/etc/openssl@1.1/certs > and run > /usr/local/opt/openssl@1.1/bin/c_rehash > openssl@1.1 is keg-only, which means it was not symlinked into /usr/local, > because macOS provides LibreSSL. > ==> Analytics > install: 680,049 (30 days), 1,793,230 (90 days), 8,766,780 (365 days) > install-on-request: 52,907 (30 days), 132,533 (90 days), 1,021,745 (365 days) > build-error: 0 (30 days) > {code} > The requested file {{/usr/local/opt/openssl/lib/libssl.1.0.0.dylib}} isn't > available on my system. Instead, > {{/usr/local/opt/openssl/lib/libssl.1.1.dylib}} is present. -- This message was sent by Atlassian Jira (v8.3.4#803005)