sqoop2-tool verify
Sqoop home directory: /home/hadoop/sqoop-1.99.6
Setting SQOOP_HTTP_PORT: 12000
Setting SQOOP_ADMIN_PORT: 12001
Using CATALINA_OPTS:
Adding to CATALINA_OPTS: -Dsqoop.http.port=12000 -Dsqoop.admin.port=12001
Sqoop tool executor:
Version: 1.99.6
Revision: 07244c3915975f26f03d9e1edf09ab7d06619bb8
Compiled on Wed Apr 29 10:40:43 CST 2015 by root
Running tool: class org.apache.sqoop.tools.tool.VerifyTool
2016-08-17 23:06:16,985 INFO [main] core.SqoopServer (SqoopServer.java:initialize(51)) - Booting up Sqoop server
2016-08-17 23:06:17,001 INFO [main] core.PropertiesConfigurationProvider (PropertiesConfigurationProvider.java:initialize(98)) - Starting config file poller thread
log4j: Parsing for [root] with value=[WARN, file].
log4j: Level token is [WARN].
log4j: Category root set to WARN
log4j: Parsing appender named "file".
log4j: Parsing layout options for "file".
log4j: Setting property [conversionPattern] to [%d{ISO8601} %-5p %c{2} [%l] %m%n].
log4j: End of parsing for "file".
log4j: Setting property [file] to [/tmp/sqoop_logs/sqoop.log].
log4j: Setting property [maxBackupIndex] to [5].
log4j: Setting property [maxFileSize] to [25MB].
log4j: setFile called: /tmp/sqoop_logs/sqoop.log, true
log4j: setFile ended
log4j: Parsed "file" options.
log4j: Parsing for [org.apache.sqoop] with value=[DEBUG].
log4j: Level token is [DEBUG].
log4j: Category org.apache.sqoop set to DEBUG
log4j: Handling log4j.additivity.org.apache.sqoop=[null]
log4j: Parsing for [org.apache.derby] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category org.apache.derby set to INFO
log4j: Handling log4j.additivity.org.apache.derby=[null]
log4j: Finished configuring.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hadoop/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/hive-2.1.0/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
log4j: Could not find root logger information. Is this OK?
log4j: Parsing for [default] with value=[INFO,defaultAppender].
log4j: Level token is [INFO].
log4j: Category default set to INFO
log4j: Parsing appender named "defaultAppender".
log4j: Parsing layout options for "defaultAppender".
log4j: Setting property [conversionPattern] to [%d %-5p %c: %m%n].
log4j: End of parsing for "defaultAppender".
log4j: Setting property [file] to [/tmp/sqoop_logs/default.audit].
log4j: setFile called: /tmp/sqoop_logs/default.audit, true
log4j: setFile ended
log4j: Parsed "defaultAppender" options.
log4j: Handling log4j.additivity.default=[null]
log4j: Finished configuring.
Exception in thread "PurgeThread" org.apache.sqoop.common.SqoopException: JDBCREPO_0009:Failed to finalize transaction
at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:115)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:111)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:112)
... 4 more
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
Verification was successful.
Tool class org.apache.sqoop.tools.tool.VerifyTool has finished correctly.
sqoop.log:
2016-08-17 23:06:17,616 WARN util.NativeCodeLoader [org.apache.hadoop.util.NativeCodeLoader.<clinit>(NativeCodeLoader.java:62)] Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
2016-08-17 23:06:17,773 INFO authentication.SimpleAuthenticationHandler [org.apache.sqoop.security.authentication.SimpleAuthenticationHandler.secureLogin(SimpleAuthenticationHandler.java:40)] Using simple/pseudo authentication, principal [hadoop]
2016-08-17 23:06:17,773 INFO security.AuthenticationManager [org.apache.sqoop.security.AuthenticationManager.initialize(AuthenticationManager.java:102)] Authentication loaded.
2016-08-17 23:06:17,785 INFO security.AuthorizationManager [org.apache.sqoop.security.AuthorizationManager.initialize(AuthorizationManager.java:117)] Authorization loaded.
2016-08-17 23:06:17,786 INFO audit.AuditLoggerManager [org.apache.sqoop.audit.AuditLoggerManager.initialize(AuditLoggerManager.java:80)] Begin audit logger manager initialization
2016-08-17 23:06:17,789 WARN audit.FileAuditLogger [org.apache.sqoop.audit.FileAuditLogger.initialize(FileAuditLogger.java:68)] appender: log4j.appender.defaultAppender
2016-08-17 23:06:17,791 INFO audit.AuditLoggerManager [org.apache.sqoop.audit.AuditLoggerManager.initializeLoggers(AuditLoggerManager.java:127)] Audit Logger has been initialized: default
2016-08-17 23:06:17,792 INFO audit.AuditLoggerManager [org.apache.sqoop.audit.AuditLoggerManager.initialize(AuditLoggerManager.java:86)] Audit logger manager initialized: OK
2016-08-17 23:06:17,795 INFO repository.RepositoryManager [org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:86)] Setting system properties: {derby.stream.error.file=/tmp/sqoop_logs/derbyrepo.log}
2016-08-17 23:06:17,811 INFO repository.JdbcRepositoryContext [org.apache.sqoop.repository.JdbcRepositoryContext.<init>(JdbcRepositoryContext.java:154)] [repo-ctx] handler=org.apache.sqoop.repository.derby.DerbyRepositoryHandler, conn-url=jdbc:derby:/home/hadoop/sqoop-1.99.6/repository/db;create=true, driver=org.apache.derby.jdbc.EmbeddedDriver, user=sa, password=*****, jdbc-props={}, tx-isolation=READ_COMMITTED, max-conn=10
2016-08-17 23:06:18,333 INFO derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.initialize(DerbyRepositoryHandler.java:96)] DerbyRepositoryHandler initialized.
2016-08-17 23:06:18,342 INFO repository.JdbcRepositoryProvider [org.apache.sqoop.repository.JdbcRepositoryProvider.initializeRepositoryHandler(JdbcRepositoryProvider.java:160)] JdbcRepositoryProvider initialized
2016-08-17 23:06:18,342 INFO repository.JdbcRepositoryProvider [org.apache.sqoop.repository.JdbcRepositoryProvider.initialize(JdbcRepositoryProvider.java:67)] JdbcRepository initialized.
2016-08-17 23:06:18,343 INFO repository.RepositoryManager [org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:122)] Creating or updating respository at bootup
2016-08-17 23:06:19,153 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 1, rollback: false
2016-08-17 23:06:19,153 INFO repository.JdbcRepository [org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:132)] Creating repository schema objects
2016-08-17 23:06:19,641 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:161)] Detecting existing version of repository
2016-08-17 23:06:19,644 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTION
2016-08-17 23:06:19,645 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTOR
2016-08-17 23:06:19,645 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTION_INPUT
2016-08-17 23:06:19,645 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_FORM
2016-08-17 23:06:19,666 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 1, rollback: false
2016-08-17 23:06:19,667 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 0, rollback: false
2016-08-17 23:06:19,667 INFO repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:111)] Attempting transaction commit
2016-08-17 23:06:19,670 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 1, rollback: false
2016-08-17 23:06:19,696 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:161)] Detecting existing version of repository
2016-08-17 23:06:19,697 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTION
2016-08-17 23:06:19,697 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTOR
2016-08-17 23:06:19,697 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_CONNECTION_INPUT
2016-08-17 23:06:19,697 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:166)] Missing table SQ_FORM
2016-08-17 23:06:19,699 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 1, rollback: false
2016-08-17 23:06:19,699 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 0, rollback: false
2016-08-17 23:06:19,700 INFO repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:111)] Attempting transaction commit
2016-08-17 23:06:19,701 INFO repository.RepositoryManager [org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:134)] Repository Manager initialized: OK
2016-08-17 23:06:19,714 INFO connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.initialize(ConnectorManager.java:172)] Connector config urls: [jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-kafka-1.99.6.jar!/sqoopconnector.properties, jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-generic-jdbc-1.99.6.jar!/sqoopconnector.properties, jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-hdfs-1.99.6.jar!/sqoopconnector.properties, jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-kite-1.99.6.jar!/sqoopconnector.properties]
2016-08-17 23:06:19,718 DEBUG connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:58)] Connector configuration: {org.apache.sqoop.connector.class=org.apache.sqoop.connector.kafka.KafkaConnector, org.apache.sqoop.connector.name=kafka-connector}
2016-08-17 23:06:19,859 INFO connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:108)] Connector [org.apache.sqoop.connector.kafka.KafkaConnector] initialized.
2016-08-17 23:06:19,860 DEBUG connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:58)] Connector configuration: {org.apache.sqoop.connector.class=org.apache.sqoop.connector.jdbc.GenericJdbcConnector, org.apache.sqoop.connector.name=generic-jdbc-connector}
2016-08-17 23:06:19,897 INFO connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:108)] Connector [org.apache.sqoop.connector.jdbc.GenericJdbcConnector] initialized.
2016-08-17 23:06:19,898 DEBUG connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:58)] Connector configuration: {org.apache.sqoop.connector.class=org.apache.sqoop.connector.hdfs.HdfsConnector, org.apache.sqoop.connector.name=hdfs-connector}
2016-08-17 23:06:19,963 INFO connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:108)] Connector [org.apache.sqoop.connector.hdfs.HdfsConnector] initialized.
2016-08-17 23:06:19,964 DEBUG connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:58)] Connector configuration: {org.apache.sqoop.connector.class=org.apache.sqoop.connector.kite.KiteConnector, org.apache.sqoop.connector.name=kite-connector}
2016-08-17 23:06:20,011 INFO connector.ConnectorHandler [org.apache.sqoop.connector.ConnectorHandler.<init>(ConnectorHandler.java:108)] Connector [org.apache.sqoop.connector.kite.KiteConnector] initialized.
2016-08-17 23:06:20,012 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 1, rollback: false
2016-08-17 23:06:20,014 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 2, rollback: false
2016-08-17 23:06:20,014 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:98)] Looking up connector: generic-jdbc-connector
2016-08-17 23:06:20,226 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:112)] Looking up connector: generic-jdbc-connector, found: null
2016-08-17 23:06:20,227 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 2, rollback: false
2016-08-17 23:06:20,228 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 1, rollback: false
2016-08-17 23:06:20,229 DEBUG connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.registerConnectors(ConnectorManager.java:224)] Registered connector: connector-generic-jdbc-connector:1:org.apache.sqoop.connector.jdbc.GenericJdbcConnector, Link: Configs: config-linkConfig:1:[input-linkConfig.jdbcDriver:1:STRING:false:ANY::128, input-linkConfig.connectionString:2:STRING:false:ANY::128, input-linkConfig.username:3:STRING:false:ANY::40, input-linkConfig.password:4:STRING:true:ANY::40, input-linkConfig.jdbcProperties:5:MAP:false:ANY:]Type: LINK, From: Configs: config-fromJobConfig:2:[input-fromJobConfig.schemaName:6:STRING:false:ANY::50, input-fromJobConfig.tableName:7:STRING:false:ANY::50, input-fromJobConfig.sql:8:STRING:false:ANY::2000, input-fromJobConfig.columns:9:STRING:false:ANY::50, input-fromJobConfig.partitionColumn:10:STRING:false:ANY::50, input-fromJobConfig.allowNullValueInPartitionColumn:11:BOOLEAN:false:ANY:, input-fromJobConfig.boundaryQuery:12:STRING:false:ANY::50]config-incrementalRead:3:[input-incrementalRead.checkColumn:13:STRING:false:ANY::50, input-incrementalRead.lastValue:14:STRING:false:ANY::-1]Type: JOB, To: Configs: config-toJobConfig:4:[input-toJobConfig.schemaName:15:STRING:false:ANY::50, input-toJobConfig.tableName:16:STRING:false:ANY::2000, input-toJobConfig.sql:17:STRING:false:ANY::50, input-toJobConfig.columns:18:STRING:false:ANY::50, input-toJobConfig.stageTableName:19:STRING:false:ANY::2000, input-toJobConfig.shouldClearStageTable:20:BOOLEAN:false:ANY:]Type: JOB
2016-08-17 23:06:20,229 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 2, rollback: false
2016-08-17 23:06:20,230 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:98)] Looking up connector: kite-connector
2016-08-17 23:06:20,246 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:112)] Looking up connector: kite-connector, found: null
2016-08-17 23:06:20,247 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 2, rollback: false
2016-08-17 23:06:20,247 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 1, rollback: false
2016-08-17 23:06:20,248 DEBUG connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.registerConnectors(ConnectorManager.java:224)] Registered connector: connector-kite-connector:2:org.apache.sqoop.connector.kite.KiteConnector, Link: Configs: config-linkConfig:5:[input-linkConfig.authority:21:STRING:false:ANY::255]Type: LINK, From: Configs: config-fromJobConfig:6:[input-fromJobConfig.uri:22:STRING:false:ANY::255]Type: JOB, To: Configs: config-toJobConfig:7:[input-toJobConfig.uri:23:STRING:false:ANY::255, input-toJobConfig.fileFormat:24:ENUM:false:ANY::CSV,AVRO,PARQUET]Type: JOB
2016-08-17 23:06:20,248 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 2, rollback: false
2016-08-17 23:06:20,248 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:98)] Looking up connector: hdfs-connector
2016-08-17 23:06:20,268 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:112)] Looking up connector: hdfs-connector, found: null
2016-08-17 23:06:20,268 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 2, rollback: false
2016-08-17 23:06:20,269 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 1, rollback: false
2016-08-17 23:06:20,269 DEBUG connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.registerConnectors(ConnectorManager.java:224)] Registered connector: connector-hdfs-connector:3:org.apache.sqoop.connector.hdfs.HdfsConnector, Link: Configs: config-linkConfig:8:[input-linkConfig.uri:25:STRING:false:ANY::255, input-linkConfig.confDir:26:STRING:false:ANY::255]Type: LINK, From: Configs: config-fromJobConfig:9:[input-fromJobConfig.inputDirectory:27:STRING:false:ANY::255, input-fromJobConfig.overrideNullValue:28:BOOLEAN:false:ANY:, input-fromJobConfig.nullValue:29:STRING:false:ANY::255]Type: JOB, To: Configs: config-toJobConfig:10:[input-toJobConfig.overrideNullValue:30:BOOLEAN:false:ANY:, input-toJobConfig.nullValue:31:STRING:false:ANY::255, input-toJobConfig.outputFormat:32:ENUM:false:ANY::TEXT_FILE,SEQUENCE_FILE, input-toJobConfig.compression:33:ENUM:false:ANY::NONE,DEFAULT,DEFLATE,GZIP,BZIP2,LZO,LZ4,SNAPPY,CUSTOM, input-toJobConfig.customCompression:34:STRING:false:ANY::255, input-toJobConfig.outputDirectory:35:STRING:false:ANY::255, input-toJobConfig.appendMode:36:BOOLEAN:false:ANY:]Type: JOB
2016-08-17 23:06:20,270 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 2, rollback: false
2016-08-17 23:06:20,270 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:98)] Looking up connector: kafka-connector
2016-08-17 23:06:20,279 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findConnector(CommonRepositoryHandler.java:112)] Looking up connector: kafka-connector, found: null
2016-08-17 23:06:20,280 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 2, rollback: false
2016-08-17 23:06:20,280 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 1, rollback: false
2016-08-17 23:06:20,281 DEBUG connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.registerConnectors(ConnectorManager.java:224)] Registered connector: connector-kafka-connector:4:org.apache.sqoop.connector.kafka.KafkaConnector, Link: Configs: config-linkConfig:11:[input-linkConfig.brokerList:37:STRING:false:ANY::1024, input-linkConfig.zookeeperConnect:38:STRING:false:ANY::255]Type: LINK, To: Configs: config-toJobConfig:12:[input-toJobConfig.topic:39:STRING:false:ANY::255]Type: JOB
2016-08-17 23:06:20,282 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 1, rollback: false
2016-08-17 23:06:20,282 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 0, rollback: false
2016-08-17 23:06:20,282 INFO repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:111)] Attempting transaction commit
2016-08-17 23:06:20,283 INFO connector.ConnectorManager [org.apache.sqoop.connector.ConnectorManager.initialize(ConnectorManager.java:194)] Connectors loaded: {generic-jdbc-connector={generic-jdbc-connector:org.apache.sqoop.connector.jdbc.GenericJdbcConnector:jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-generic-jdbc-1.99.6.jar!/sqoopconnector.properties}, kite-connector={kite-connector:org.apache.sqoop.connector.kite.KiteConnector:jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-kite-1.99.6.jar!/sqoopconnector.properties}, hdfs-connector={hdfs-connector:org.apache.sqoop.connector.hdfs.HdfsConnector:jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-hdfs-1.99.6.jar!/sqoopconnector.properties}, kafka-connector={kafka-connector:org.apache.sqoop.connector.kafka.KafkaConnector:jar:file:/home/hadoop/sqoop-1.99.6/server/webapps/sqoop/WEB-INF/lib/sqoop-connector-kafka-1.99.6.jar!/sqoopconnector.properties}}
2016-08-17 23:06:20,303 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 1, rollback: false
2016-08-17 23:06:20,304 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findDriver(CommonRepositoryHandler.java:304)] Looking up Driver and config
2016-08-17 23:06:20,308 DEBUG common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.findDriver(CommonRepositoryHandler.java:357)] Looked up Driver and config
2016-08-17 23:06:20,309 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:84)] Tx count-commit: 1, rollback: false
2016-08-17 23:06:20,309 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 0, rollback: false
2016-08-17 23:06:20,309 INFO repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:111)] Attempting transaction commit
2016-08-17 23:06:20,310 INFO driver.Driver [org.apache.sqoop.driver.Driver.initialize(Driver.java:134)] Driver initialized: OK
2016-08-17 23:06:20,324 INFO mapreduce.MapreduceSubmissionEngine [org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.initialize(MapreduceSubmissionEngine.java:83)] Initializing Map-reduce Submission Engine
2016-08-17 23:06:20,791 INFO mapreduce.MapreduceSubmissionEngine [org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.initialize(MapreduceSubmissionEngine.java:127)] Detected MapReduce local mode, some methods might not work correctly.
2016-08-17 23:06:20,802 INFO driver.JobManager [org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:654)] Starting submission manager purge thread
2016-08-17 23:06:20,802 INFO driver.JobManager [org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:658)] Purging old submissions
2016-08-17 23:06:20,804 INFO driver.JobManager [org.apache.sqoop.driver.JobManager.initialize(JobManager.java:270)] Submission manager initialized: OK
2016-08-17 23:06:20,804 INFO core.SqoopServer [org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:60)] Sqoop server has successfully boot up
2016-08-17 23:06:20,804 INFO core.SqoopServer [org.apache.sqoop.core.SqoopServer.destroy(SqoopServer.java:37)] Shutting down Sqoop server
2016-08-17 23:06:20,805 INFO driver.JobManager [org.apache.sqoop.driver.JobManager$UpdateThread.run(JobManager.java:678)] Starting submission manager update thread
2016-08-17 23:06:20,806 INFO driver.JobManager [org.apache.sqoop.driver.JobManager$UpdateThread.run(JobManager.java:699)] Ending submission manager update thread
2016-08-17 23:06:20,811 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:73)] Tx count-begin: 1, rollback: false
2016-08-17 23:06:20,926 ERROR common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.logException(CommonRepositoryHandler.java:2549)] Exception in repository operation
java.sql.SQLNonTransientConnectionException: Connection closed by unknown interrupt.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.sqoop.repository.common.CommonRepositoryHandler.purgeSubmissions(CommonRepositoryHandler.java:1055)
at org.apache.sqoop.repository.JdbcRepository$26.doIt(JdbcRepository.java:594)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:92)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
Caused by: java.sql.SQLException: Connection closed by unknown interrupt.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 19 more
Caused by: ERROR 08000: Connection closed by unknown interrupt.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.util.InterruptStatus.setInterrupted(Unknown Source)
at org.apache.derby.iapi.util.InterruptStatus.throwIf(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.checkCancellationFlag(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 13 more
2016-08-17 23:06:20,930 ERROR common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.logException(CommonRepositoryHandler.java:2550)] Using database Derby
2016-08-17 23:06:20,930 ERROR common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.logException(CommonRepositoryHandler.java:2551)] Associated objects: 1
2016-08-17 23:06:20,930 ERROR common.CommonRepositoryHandler [org.apache.sqoop.repository.common.CommonRepositoryHandler.logException(CommonRepositoryHandler.java:2553)] Date: Tue Aug 16 23:06:20 CST 2016
2016-08-17 23:06:20,934 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:103)] Tx count-close: 0, rollback: false
2016-08-17 23:06:20,934 INFO repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:111)] Attempting transaction commit
2016-08-17 23:06:20,943 ERROR repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:137)] Error while retrieving warnigns: 40000
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.getWarnings(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.getWarnings(DelegatingConnection.java:359)
at org.apache.commons.dbcp.DelegatingConnection.getWarnings(DelegatingConnection.java:359)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getWarnings(PoolingDataSource.java:260)
at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:120)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:111)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 14 more
2016-08-17 23:06:20,946 ERROR repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:145)] Unable to close connection: 0
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:143)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:111)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
2016-08-17 23:06:20,949 INFO mapreduce.MapreduceSubmissionEngine [org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.destroy(MapreduceSubmissionEngine.java:137)] Destroying Mapreduce Submission Engine
2016-08-17 23:06:20,950 DEBUG derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.shutdown(DerbyRepositoryHandler.java:118)] Attempting to shutdown embedded Derby using URL: jdbc:derby:/home/hadoop/sqoop-1.99.6/repository/db;shutdown=true
2016-08-17 23:06:21,086 INFO derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.shutdown(DerbyRepositoryHandler.java:129)] Embedded Derby shutdown raised SQL STATE 45000 as expected.
2016-08-17 23:06:21,086 INFO repository.JdbcRepositoryProvider [org.apache.sqoop.repository.JdbcRepositoryProvider.destroy(JdbcRepositoryProvider.java:82)] Deregistering JDBC driver
2016-08-17 23:06:21,087 INFO core.PropertiesConfigurationProvider [org.apache.sqoop.core.PropertiesConfigurationProvider.destroy(PropertiesConfigurationProvider.java:75)] Shutting down configuration poller thread
2016-08-17 23:06:21,088 INFO core.SqoopServer [org.apache.sqoop.core.SqoopServer.destroy(SqoopServer.java:46)] Sqoop server has been correctly terminated
derby.log:
tail: derbyrepo.log: file truncated
----------------------------------------------------------------
Wed Aug 17 23:06:18 CST 2016:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.10.2.0 - (1582446): instance a816c00e-0156-9909-e72f-00000361f6f0
on database directory /home/hadoop/sqoop-1.99.6/repository/db with class loader org.apache.catalina.loader.StandardClassLoader@68de145
Loaded from file:/home/hadoop/hive-2.1.0/lib/derby-10.10.2.0.jar
java.vendor=Oracle Corporation
java.runtime.version=1.8.0_101-b13
user.dir=/home/hadoop
os.name=Linux
os.arch=amd64
os.version=2.6.32-358.el6.x86_64
derby.system.home=null
derby.stream.error.file=/tmp/sqoop_logs/derbyrepo.log
Database Class Loader started - derby.database.classpath=''
Wed Aug 17 23:06:20 CST 2016 Thread[PurgeThread,5,main] (XID = 1318), (SESSIONID = 1), (DATABASE = /home/hadoop/sqoop-1.99.6/repository/db), (DRDAID = null), Cleanup action starting
Wed Aug 17 23:06:20 CST 2016 Thread[PurgeThread,5,main] (XID = 1318), (SESSIONID = 1), (DATABASE = /home/hadoop/sqoop-1.99.6/repository/db), (DRDAID = null), Failed Statement is: DELETE FROM "SQOOP"."SQ_SUBMISSION" WHERE "SQS_UPDATE_DATE" < ? with 1 parameters begin parameter #1: 2016-08-16 23:06:20.808 :end parameter
ERROR 08000: Connection closed by unknown interrupt.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.util.InterruptStatus.setInterrupted(Unknown Source)
at org.apache.derby.iapi.util.InterruptStatus.throwIf(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.checkCancellationFlag(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.sqoop.repository.common.CommonRepositoryHandler.purgeSubmissions(CommonRepositoryHandler.java:1055)
at org.apache.sqoop.repository.JdbcRepository$26.doIt(JdbcRepository.java:594)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:92)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
---------------
Stack traces for all live threads:
Thread name=derby.rawStoreDaemon id=15 priority=5 state=TIMED_WAITING isdaemon=true
java.lang.Object.wait(Native Method)
org.apache.derby.impl.services.daemon.BasicDaemon.rest(Unknown Source)
org.apache.derby.impl.services.daemon.BasicDaemon.run(Unknown Source)
java.lang.Thread.run(Thread.java:745)
Thread name=process reaper id=11 priority=10 state=TIMED_WAITING isdaemon=true
sun.misc.Unsafe.park(Native Method)
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)
Thread name=Signal Dispatcher id=4 priority=9 state=RUNNABLE isdaemon=true
Thread name=Abandoned connection cleanup thread id=13 priority=5 state=TIMED_WAITING isdaemon=true
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:43)
Thread name=PurgeThread id=17 priority=5 state=RUNNABLE isdaemon=false
java.lang.Thread.dumpThreads(Native Method)
java.lang.Thread.getAllStackTraces(Thread.java:1603)
org.apache.derby.iapi.error.ThreadDump.getStackDumpString(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.apache.derby.iapi.error.ExceptionUtil$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
org.apache.derby.iapi.error.ExceptionUtil.dumpThreads(Unknown Source)
org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.sqoop.repository.common.CommonRepositoryHandler.purgeSubmissions(CommonRepositoryHandler.java:1055)
org.apache.sqoop.repository.JdbcRepository$26.doIt(JdbcRepository.java:594)
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:92)
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
Thread name=Reference Handler id=2 priority=10 state=WAITING isdaemon=true
java.lang.Object.wait(Native Method)
java.lang.Object.wait(Object.java:502)
java.lang.ref.Reference.tryHandlePending(Reference.java:191)
java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153)
Thread name=Timer-0 id=14 priority=5 state=WAITING isdaemon=true
java.lang.Object.wait(Native Method)
java.lang.Object.wait(Object.java:502)
java.util.TimerThread.mainLoop(Timer.java:526)
java.util.TimerThread.run(Timer.java:505)
Thread name=sqoop-config-file-poller id=10 priority=5 state=TIMED_WAITING isdaemon=true
java.lang.Thread.sleep(Native Method)
org.apache.sqoop.core.PropertiesConfigurationProvider$ConfigFilePoller.run(PropertiesConfigurationProvider.java:188)
Thread name=Finalizer id=3 priority=8 state=WAITING isdaemon=true
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)
java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:209)
Thread name=main id=1 priority=5 state=WAITING isdaemon=false
java.lang.Object.wait(Native Method)
java.lang.Thread.join(Thread.java:1245)
java.lang.Thread.join(Thread.java:1319)
org.apache.sqoop.driver.JobManager.destroy(JobManager.java:184)
org.apache.sqoop.core.SqoopServer.destroy(SqoopServer.java:38)
org.apache.sqoop.tools.tool.VerifyTool.runTool(VerifyTool.java:37)
org.apache.sqoop.tools.ToolRunner.main(ToolRunner.java:75)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.apache.sqoop.tomcat.TomcatToolRunner.main(TomcatToolRunner.java:77)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.apache.catalina.startup.Tool.main(Tool.java:225)
---------------
Cleanup action completed
----------------------------------------------------------------
Wed Aug 17 23:06:20 CST 2016:
Shutting down instance a816c00e-0156-9909-e72f-00000361f6f0 on database directory /home/hadoop/sqoop-1.99.6/repository/db with class loader org.apache.catalina.loader.StandardClassLoader@68de145
|