[
https://issues.apache.org/jira/browse/SQOOP-3486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
freezhan updated SQOOP-3486:
----------------------------
Affects Version/s: (was: 1.99.7)
1.4.7
> Sqoop import MySQL data by ipv6 error
> -------------------------------------
>
> Key: SQOOP-3486
> URL: https://issues.apache.org/jira/browse/SQOOP-3486
> Project: Sqoop
> Issue Type: Bug
> Components: sqoop2-server
> Affects Versions: 1.4.7
> Reporter: freezhan
> Priority: Major
>
> [root@test01 /]# sqoop list-tables --username root --password root --connect
> jdbc:mysql://[::1]:3306/test[root@test01 /]# sqoop list-tables --username
> root --password root --connect jdbc:mysql://[::1]:3306/testWarning:
> /usr/local/sqoop/../hbase does not exist! HBase imports will fail.Please set
> $HBASE_HOME to the root of your HBase installation.Warning:
> /usr/local/sqoop/../hcatalog does not exist! HCatalog jobs will fail.Please
> set $HCAT_HOME to the root of your HCatalog installation.Warning:
> /usr/local/sqoop/../accumulo does not exist! Accumulo imports will
> fail.Please set $ACCUMULO_HOME to the root of your Accumulo
> installation.Warning: /usr/local/sqoop/../zookeeper does not exist! Accumulo
> imports will fail.Please set $ZOOKEEPER_HOME to the root of your Zookeeper
> installation.2021-02-19 08:47:24,861 INFO sqoop.Sqoop: Running Sqoop version:
> 1.4.72021-02-19 08:47:24,889 WARN tool.BaseSqoopTool: Setting your password
> on the command-line is insecure. Consider using -P instead.2021-02-19
> 08:47:24,992 INFO manager.MySQLManager: Preparing to use a MySQL streaming
> resultset.Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new
> driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically
> registered via the SPI and manual loading of the driver class is generally
> unnecessary.2021-02-19 08:47:25,224 ERROR manager.CatalogQueryManager: Failed
> to list tablescom.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:836) at
> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at
> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
> at java.sql.DriverManager.getConnection(DriverManager.java:664) at
> java.sql.DriverManager.getConnection(DriverManager.java:247) at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) at
> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
> at
> org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102)
> at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at
> org.apache.sqoop.Sqoop.run(Sqoop.java:147) at
> org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at
> org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at
> org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at
> org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at
> org.apache.sqoop.Sqoop.main(Sqoop.java:252)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:144) at
> com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ...
> 15 moreCaused by: java.net.SocketException: Protocol family unavailable 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)
> ... 18 more2021-02-19 08:47:25,229 ERROR sqoop.Sqoop: Got exception running
> Sqoop: java.lang.RuntimeException:
> 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.java.lang.RuntimeException:
> 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
> org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:118)
> at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at
> org.apache.sqoop.Sqoop.run(Sqoop.java:147) at
> org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at
> org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at
> org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at
> org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at
> org.apache.sqoop.Sqoop.main(Sqoop.java:252)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:836) at
> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at
> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
> at java.sql.DriverManager.getConnection(DriverManager.java:664) at
> java.sql.DriverManager.getConnection(DriverManager.java:247) at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) at
> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
> at
> org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102)
> ... 7 moreCaused 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:144) at
> com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ...
> 15 moreCaused by: java.net.SocketException: Protocol family unavailable 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)
> ... 18 more
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
