[
https://issues.apache.org/jira/browse/SQOOP-2415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ryan Wieber updated SQOOP-2415:
-------------------------------
Description:
Using the "--relaxed-isolation" option does not appear to setting the TX
isolation level correctly for SQLite databases. Error states that isolation
level as not been set to "TRANSACTION_READ_UNCOMMITTED".
{noformat}
# sqoop import-all-tables --driver org.sqlite.JDBC --connect
jdbc:sqlite:/tmp/testsol_20150526153854.db --m 1 --warehouse-dir /data/landing
--relaxed-isolation --verbose
Warning:
/opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/06/16 10:47:29 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2
15/06/16 10:47:29 DEBUG tool.BaseSqoopTool: Enabled debug logging.
15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
org.apache.sqoop.manager.oracle.OraOopManagerFactory
15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
15/06/16 10:47:29 WARN sqoop.ConnFactory: Parameter --driver is set to an
explicit driver however appropriate connection manager is not being set (via
--connection-manager). Sqoop is going to fall back to
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
connection manager should be used next time.
15/06/16 10:47:29 INFO manager.SqlManager: Using default fetchSize of 1000
15/06/16 10:47:29 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
15/06/16 10:47:30 ERROR manager.SqlManager: Error reading database metadata:
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
at
org.sqlite.jdbc3.JDBC3Connection.setTransactionIsolation(JDBC3Connection.java:77)
at
org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:886)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:520)
at
org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:95)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Could not retrieve tables list from server
15/06/16 10:47:30 ERROR tool.ImportAllTablesTool: manager.listTables() returned
null
{noformat}
was:
Using the "--relaxed-isolation" option does not appear to setting the TX
isolation level correctly for SQLite databases. Error states that isolation
level as not been set to "TRANSACTION_READ_UNCOMMITTED".
# sqoop import-all-tables --driver org.sqlite.JDBC --connect
jdbc:sqlite:/tmp/testsol_20150526153854.db --m 1 --warehouse-dir /data/landing
--relaxed-isolation --verbose
Warning:
/opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/06/16 10:47:29 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2
15/06/16 10:47:29 DEBUG tool.BaseSqoopTool: Enabled debug logging.
15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
org.apache.sqoop.manager.oracle.OraOopManagerFactory
15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
15/06/16 10:47:29 WARN sqoop.ConnFactory: Parameter --driver is set to an
explicit driver however appropriate connection manager is not being set (via
--connection-manager). Sqoop is going to fall back to
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
connection manager should be used next time.
15/06/16 10:47:29 INFO manager.SqlManager: Using default fetchSize of 1000
15/06/16 10:47:29 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
15/06/16 10:47:30 ERROR manager.SqlManager: Error reading database metadata:
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
at
org.sqlite.jdbc3.JDBC3Connection.setTransactionIsolation(JDBC3Connection.java:77)
at
org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:886)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:520)
at
org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:95)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Could not retrieve tables list from server
15/06/16 10:47:30 ERROR tool.ImportAllTablesTool: manager.listTables() returned
null
> Setting "relaxed-isolation" for SQLite does not appear to work properly
> -----------------------------------------------------------------------
>
> Key: SQOOP-2415
> URL: https://issues.apache.org/jira/browse/SQOOP-2415
> Project: Sqoop
> Issue Type: Bug
> Components: sqoop2-client
> Affects Versions: 1.4.5
> Reporter: Ryan Wieber
> Priority: Minor
>
> Using the "--relaxed-isolation" option does not appear to setting the TX
> isolation level correctly for SQLite databases. Error states that isolation
> level as not been set to "TRANSACTION_READ_UNCOMMITTED".
> {noformat}
> # sqoop import-all-tables --driver org.sqlite.JDBC --connect
> jdbc:sqlite:/tmp/testsol_20150526153854.db --m 1 --warehouse-dir
> /data/landing --relaxed-isolation --verbose
> Warning:
> /opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/bin/../lib/sqoop/../accumulo
> does not exist! Accumulo imports will fail.
> Please set $ACCUMULO_HOME to the root of your Accumulo installation.
> 15/06/16 10:47:29 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2
> 15/06/16 10:47:29 DEBUG tool.BaseSqoopTool: Enabled debug logging.
> 15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
> org.apache.sqoop.manager.oracle.OraOopManagerFactory
> 15/06/16 10:47:29 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 15/06/16 10:47:29 WARN sqoop.ConnFactory: Parameter --driver is set to an
> explicit driver however appropriate connection manager is not being set (via
> --connection-manager). Sqoop is going to fall back to
> org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
> connection manager should be used next time.
> 15/06/16 10:47:29 INFO manager.SqlManager: Using default fetchSize of 1000
> 15/06/16 10:47:29 DEBUG manager.SqlManager: No connection paramenters
> specified. Using regular API for making connection.
> 15/06/16 10:47:30 ERROR manager.SqlManager: Error reading database metadata:
> java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
> TRANSACTION_READ_UNCOMMITTED.
> java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
> TRANSACTION_READ_UNCOMMITTED.
> at
> org.sqlite.jdbc3.JDBC3Connection.setTransactionIsolation(JDBC3Connection.java:77)
> at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:886)
> at
> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
> at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:520)
> at
> org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:95)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
> Could not retrieve tables list from server
> 15/06/16 10:47:30 ERROR tool.ImportAllTablesTool: manager.listTables()
> returned null
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
