Hi Karthik,
I also see a (different) failure on the Mac when running the
'contrib/storage-jdbc' test:
[ERROR] Error starting the server for database 'drill_derby_test'.
However this test runs cleanly on Linux, so it has to do with my Mac
environment. The same failures show on the older 1.14 as well.
To verify that yours is an environment issue too, try building 1.14 (see
[1]) and then run the same test there:
/mvn integration-test failsafe:integration-test -pl contrib/storage-jdbc
/
That 1.14 should have similar failures. (The above form of mvn is needed
as those tests are disabled in 1.14)
//
Thanks,
Boaz
[1] http://home.apache.org/~boaz/drill/releases/1.14.0/rc3/
On 12/27/18 1:46 PM, Karthikeyan Manivannan wrote:
Hi,
I am seeing a connection failure in a drill-jdbc-storage test on my Mac
with 1.15 rc2 . Is this because of some config issue on my Mac?
"[DEBUG] Configuring mojo org.codehaus.mojo:sql-maven-plugin:1.5:execute
from plugin realm ClassRealm[plugin>org.codehaus.mojo:sql-maven-plugin:1.5,
parent: sun.misc.Launcher$AppClassLoader@42a57993]
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.5:execute'
with basic configurator -->
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = com.mysql.cj.jdbc.Driver
[DEBUG] (f) enableAnonymousPassword = false
[DEBUG] (f) enableFiltering = false
[DEBUG] (s) encoding = UTF-8
[DEBUG] (s) escapeProcessing = true
[DEBUG] (s) basedir =
/Users/karthik/test/drill/release/1.15/apache-drill-1.15.0-src/contrib/storage-jdbc/src/test/resources
[DEBUG] (s) includes = [mysql-test-data.sql]
[DEBUG] (f) fileset = org.codehaus.mojo.sql.Fileset@51e1e058
[DEBUG] (f) forceMojoExecution = false
[DEBUG] (s) keepFormat = false
[DEBUG] (f) mavenSession =
org.apache.maven.execution.MavenSession@2af46afd
[DEBUG] (s) onError = abort
[DEBUG] (s) orderFile = ascending
[DEBUG] (f) outputDelimiter = ,
[DEBUG] (s) password = root
[DEBUG] (s) printResultSet = false
[DEBUG] (f) project = MavenProject:
org.apache.drill.contrib:drill-jdbc-storage:1.15.0 @
/Users/karthik/test/drill/release/1.15/apache-drill-1.15.0-src/contrib/storage-jdbc/pom.xml
[DEBUG] (f) settings = org.apache.maven.execution.SettingsAdapter@23e0c200
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) url = jdbc:mysql://localhost:58278/drill_mysql_test
[DEBUG] (s) username = root
[DEBUG] -- end configuration --
[DEBUG] connecting to jdbc:mysql://localhost:58278/drill_mysql_test
[INFO]
------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] contrib/jdbc-storage-plugin ........................ FAILURE [01:00
min]
[INFO] contrib/hive-storage-plugin/Parent Pom ............. SKIPPED
[INFO] contrib/hive-storage-plugin/hive-exec-shaded ....... SKIPPED
[INFO] contrib/mapr-format-plugin ......................... SKIPPED
[INFO] contrib/hive-storage-plugin/core ................... SKIPPED
[INFO] contrib/kafka-storage-plugin ....................... SKIPPED
[INFO] contrib/drill-udfs ................................. SKIPPED
[INFO] Packaging and Distribution Assembly ................ SKIPPED
[INFO]
------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 01:01 min
[INFO] Finished at: 2018-12-27T13:18:50-08:00
[INFO] Final Memory: 303M/964M
[INFO]
------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.codehaus.mojo:sql-maven-plugin:1.5:execute (create-tables) on project
drill-jdbc-storage: Communications link failure
[ERROR]
[ERROR] The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server. Connection
refused (Connection refused)
[ERROR] -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.codehaus.mojo:sql-maven-plugin:1.5:execute (create-tables) on
project drill-jdbc-storage: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The
driver has not received any packets from the server.
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at
org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
Caused by: org.apache.maven.plugin.MojoExecutionException: Communications
link failure
The last packet sent successfully to the server was 0 milliseconds ago. The
driver has not received any packets from the server.
at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:618)
at
org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
... 20 more
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException:
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The
driver has not received any packets from the server.
at
com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at org.codehaus.mojo.sql.SqlExecMojo.getConnection(SqlExecMojo.java:899)
at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:612)
... 22 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException:
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The
driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at
com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at
com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
... 27 more
Caused by: java.net.ConnectException: Connection refused (Connection
refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at
com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
... 30 more
[ERROR]
[ERROR]
[ERROR] For more information about the errors and possible solutions,
please read the following articles:
[ERROR] [Help 1]
https://urldefense.proofpoint.com/v2/url?u=http-3A__cwiki.apache.org_confluence_display_MAVEN_MojoExecutionException&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=SukM6YsFc-bD_55zg6TDdmTHQws00LRa3vk5coBK9GU&s=SwXgo4eVbko5dSXEqCfELJah-x9XHgk7Lmzi8XbFFv0&e=
[INFO] #stop(58278): in 493.58µs
[karthik@km-mbp:~/test/drill/release/1.15/apache-drill-1.15.0-src]"
On Thu, Dec 27, 2018 at 12:58 PM Sorabh Hamirwasia <shamirwa...@mapr.com>
wrote:
- Downloaded src tarball from [3] and built on linux.
- Built the cpp client on linux from source.
- Tested Kerberos and Plain mechanism using querysubmitter and sqlline.
- Verified Unnest/Lateral is enabled by default.
** The planner options documentation needs to be updated to reflect that
feature is enabled by default post 1.15. On WebUI it says below:
Enables lateral join functionality. Default is false. (Drill 1.14+)
- Executed couple of queries related to Unnest/Lateral.
LGTM +1
Thanks,
Sorabh
On Thu, Dec 27, 2018 at 11:12 AM Aman Sinha <amansi...@apache.org> wrote:
- Downloaded source from [3] onto my Linux VM, built and ran unit
tests. I
had to run some test suites individually but got a clean run.
- Verified extraneous directory issue (DRILL-6916) is resolved
- Built the source using MapR profile and ran the secondary indexing
tests
within mapr format plugin
- Downloaded binary tar ball from [3] on my Mac. Verified checksum of
the
file using shasum -a 512 *file *and comparing with the one on [3]
- Verified Vitalii's signature through the following command: gpg
--verify
Downloads/apache-drill-1.15.0.tar.gz.asc apache-drill-1.15.0.tar.gz
- Ran Drill in embedded mode and ran a few TPC-H queries. Checked query
profiles through Web UI
LGTM. +1
Aman
On Thu, Dec 27, 2018 at 6:17 AM Denys Ordynskiy <denysor...@gmail.com>
wrote:
- downloaded source code, successfully built Drill with mapr profile;
- run Drill in distributed mode on Ubuntu on JDK8;
- connected from Drill Explorer, explored data on S3 and MapRFS
storage;
- submitted some tests for Drill Web UI and Drill Rest API.
+1
On Wed, Dec 26, 2018 at 8:40 PM Arina Ielchiieva <ar...@apache.org>
wrote:
Build from source on Linux, started in embedded mode, ran random
queries.
Downloaded tarball on Windows, started Drill in embedded mode, run
random
queries.
Check Web UI: Profiles, Options, Plugins sections.
Additionally checked:
- information_schema files table;
- new SqlLine version;
- JDBC using Squirrel;
- ODBC using Drill Explorer;
- return result set option.
+1 (binding)
Kind regards,
Arina
On Wed, Dec 26, 2018 at 8:32 PM Volodymyr Vysotskyi <
volody...@apache.org>
wrote:
- Downloaded built tar, checked signatures and hashes for built and
source
tars
and for jars;
- run Drill in embedded mode on both Ubuntu and Windows on JDK8 and
JDK11;
- created views, submitted random TPCH queries from UI and SqlLine,
checked
that profiles are displayed correctly;
- downloaded source tar, ran unit tests and all tests are passed;
- built with mapr profile, started in distributed mode, submitted
several
tests for hive tables, checked logs, no errors are found;
- connected from SQuirrel, ran several queries, tested
exec.query.return_result_set_for_ddl
option;
- checked metadata correctness for decimal results;
- ran several queries from a Java application;
- built native client and submitted several queries.
+1 (binding)
Kind regards,
Volodymyr Vysotskyi
On Mon, Dec 24, 2018 at 9:27 PM Vitalii Diravka <
vita...@apache.org>
wrote:
Hi all,
I'd like to propose the second release candidate (rc2) of Apache
Drill,
version 1.15.0.
Changes since the previous release candidate: fixed the
show-stoppers:
DRILL-6919: Error: cannot find symbol in class ServerSocketUtil
DRILL-6920: Fix TestClient.testBasics() yarn test failure
DRILL-6922: QUERY-level options are shown on Profiles tab
DRILL-6925: Unable to generate Protobuf
The release candidate covers a total of 205 resolved JIRAs [1],
[2].
Thanks to everyone who contributed to this release.
The tarball artifacts are hosted at [3] and the maven artifacts
are
hosted
at [4].
This release candidate is based on commit
8743e8f1e8d5bca4d67c94d07a8560ad356ff2b6 located at [5].
Please download and try out the release.
The vote ends at 7:00am UTC (11:00am PDT, 9:00pm EET, 12:30am
(next
day)
IST), Dec
28, 2018. It is one day longer, since 12/25/2018 is a holiday.
[ ] +1
[ ] +0
[ ] -1
Here's my vote: +1
[1]
https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_projects_DRILL_versions_12343317&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jSLza1QwLz1yA4nyb23RtysEylqY9SvP1oFGBR9nGTA&s=gcHoszMudlnuQSRJiyZhR_v_SCE5dyNtqzT58Orp-JM&e=
[2]
https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_secure_ReleaseNote.jspa-3Fversion-3D12343317-26styleName-3D-26projectId-3D12313820&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jSLza1QwLz1yA4nyb23RtysEylqY9SvP1oFGBR9nGTA&s=jjxgi7a25TxsEJ-rPXHvKtdLJNjXOOfMBXM9wgxaPK4&e=
[3]
https://urldefense.proofpoint.com/v2/url?u=http-3A__home.apache.org_-7Evitalii_drill_releases_1.15.0_rc2_&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jSLza1QwLz1yA4nyb23RtysEylqY9SvP1oFGBR9nGTA&s=vsxp7B_OM5cLIIdgaUuJFNLLAWzj09FpzqviES_3jPU&e=
[4]
https://urldefense.proofpoint.com/v2/url?u=https-3A__repository.apache.org_content_repositories_orgapachedrill-2D1062_&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jSLza1QwLz1yA4nyb23RtysEylqY9SvP1oFGBR9nGTA&s=x8jx8jUWFU602gvWKfwX-bLj_EWzeCI5dzYzmOxmi0Q&e=
[5]
https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_vdiravka_drill_commits_drill-2D1.15.0&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jSLza1QwLz1yA4nyb23RtysEylqY9SvP1oFGBR9nGTA&s=X1O39VRAQUQBH4ylkb_fX8XBB_LNfcb8GNJ3bio0knQ&e=
Kind regards
Vitalii
