Mariadb driver broken pipe Should I need to change the mariadb driver with mysql driver
2018-02-09 15:03:24,528 [e2 - 2581d742-ce1f-507f-2fdf-56b660c22a00:frag:2:0] INFO c.d.exec.store.jdbc.JdbcRecordReader - User Error Occurred [ErrorId: 0e683a61-1e65-435d-8b5e-91e503c9dbe1]
com.dremio.common.exceptions.UserException: The JDBC storage plugin failed while trying setup the SQL query.
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:648) ~[dremio-common-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:214) [dremio-extra-plugin-jdbc-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.exec.store.CoercionReader.setup(CoercionReader.java:109) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:188) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:184) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_102]
at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0_102]
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1807) [hadoop-common-2.8.0.jar:na]
at com.dremio.sabot.op.scan.ScanOperator.setupReaderAsCorrectUser(ScanOperator.java:184) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.op.scan.ScanOperator.setupReader(ScanOperator.java:176) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.op.scan.ScanOperator.setup(ScanOperator.java:157) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.SmartOp$SmartProducer.setup(SmartOp.java:552) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer(Pipe.java:79) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer(Pipe.java:63) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.SmartOp$SmartProducer.accept(SmartOp.java:522) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.driver.Pipeline.setup(Pipeline.java:58) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.exec.fragment.FragmentExecutor.setupExecution(FragmentExecutor.java:331) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.exec.fragment.FragmentExecutor.run(FragmentExecutor.java:227) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.exec.fragment.FragmentExecutor.access$800(FragmentExecutor.java:83) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run(FragmentExecutor.java:577) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.task.AsyncTaskWrapper.run(AsyncTaskWrapper.java:92) [dremio-sabot-kernel-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
at com.dremio.sabot.task.slicing.SlicingThread.run(SlicingThread.java:71) [dremio-extra-sabot-scheduler-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
Caused by: java.sql.SQLNonTransientConnectionException: (conn:675890728) Could not send query: Broken pipe
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:247) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:322) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:492) ~[mariadb-java-client-1.6.2.jar:na]
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:171) [dremio-extra-plugin-jdbc-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
… 21 common frames omitted
Caused by: java.sql.SQLException: Could not send query: Broken pipe
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:1472) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:169) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:316) ~[mariadb-java-client-1.6.2.jar:na]
… 23 common frames omitted
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_102]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) ~[na:1.8.0_102]
at java.net.SocketOutputStream.write(SocketOutputStream.java:153) ~[na:1.8.0_102]
at org.mariadb.jdbc.internal.io.output.StandardPacketOutputStream.flushBuffer(StandardPacketOutputStream.java:103) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream.flush(AbstractPacketOutputStream.java:157) ~[mariadb-java-client-1.6.2.jar:na]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:163) ~[mariadb-java-client-1.6.2.jar:na]
… 24 common frames omitted
2018-02-09 15:03:24,540 [FABRIC-rpc-event-queue] INFO c.d.exec.work.foreman.QueryManager - Fragment 2581d742-ce1f-507f-2fdf-56b660c22a00:2:0 failed, cancelling remaining fragments.
2018-02-09 15:03:24,544 [FABRIC-rpc-event-queue] INFO query.logger - {“queryId”:“2581d742-ce1f-507f-2fdf-56b660c22a00”,“schema”:"",“queryText”:"select a.*\nfrom nrhl_ds_dsrc_dbms_mysql_prod_01_ecom.test.test_table_01 a \n join nrhl_ds_dsrc_dbms_mysql_prod_01_dmart.test.test_table_01 b on a.item_id = b.item_id ",“start”:1518217404335,“finish”:1518217404542,“outcome”:“FAILED”,“username”:“admin”,“commandDescription”:“execute; query”}
2018-02-09 15:03:24,556 [e0 - 2581d742-ce1f-507f-2fdf-56b660c22a00:frag:1:0] INFO c.d.s.e.f.FragmentStatusReporter - 2581d742-ce1f-507f-2fdf-56b660c22a00:1:0: State to report: CANCELLED
2018-02-09 15:03:24,557 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived post query termination, dropping. Fragment [1:0] reported a state of CANCELLED.
2018-02-09 15:03:24,566 [e0 - 2581d742-ce1f-507f-2fdf-56b660c22a00:frag:0:0] INFO c.d.s.e.f.FragmentStatusReporter - 2581d742-ce1f-507f-2fdf-56b660c22a00:0:0: State to report: CANCELLED