論壇首頁 綜合技術論壇

【sqoop2 error】 ERROR 42Y07 Schema SQOOP does not exist

瀏覽 157 次
精華帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隱藏帖 (0)
作者 正文
   發表時間:2019-06-05  

問題:

2019-06-01 09:48:22,376 INFO  [org.apache.sqoop.audit.AuditLoggerManager.initializeLoggers(AuditLoggerManager.java:121)] Audit Logger has been initialized: default
2019-06-01 09:48:22,377 INFO  [org.apache.sqoop.audit.AuditLoggerManager.initialize(AuditLoggerManager.java:79)] Audit logger manager initialized: OK
2019-06-01 09:48:22,378 INFO  [org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:91)] Setting system properties: {derby.stream.error.file=/home/zkkafka/sqoop2/logs/derbyrepo.log}
2019-06-01 09:48:22,384 INFO  [org.apache.sqoop.repository.JdbcRepositoryContext.<init>(JdbcRepositoryContext.java:156)] [repo-ctx] handler=org.apache.sqoop.repository.derby.DerbyRepositoryHandler, conn-url=jdbc:derby:/home/zkkafka/sqoop2/basedir/repository/SQOOP;create=true, driver=org.apache.derby.jdbc.EmbeddedDriver, user=sa, password=*****, jdbc-props={}, tx-isolation=READ_COMMITTED, max-conn=10
2019-06-01 09:48:22,750 INFO  [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.initialize(DerbyRepositoryHandler.java:99)] DerbyRepositoryHandler initialized.
2019-06-01 09:48:22,753 INFO  [org.apache.sqoop.repository.JdbcRepositoryProvider.initializeRepositoryHandler(JdbcRepositoryProvider.java:160)] JdbcRepositoryProvider initialized
2019-06-01 09:48:22,753 INFO  [org.apache.sqoop.repository.JdbcRepositoryProvider.initialize(JdbcRepositoryProvider.java:67)] JdbcRepository initialized.
2019-06-01 09:48:22,753 INFO  [org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:127)] Creating or updating respository at bootup
2019-06-01 09:48:26,785 INFO  [org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:131)] Creating repository schema objects
2019-06-01 09:48:27,149 INFO  [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:191)] Can't fetch repository structure version.
org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
	at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
	at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:177)
	at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.createOrUpgradeRepository(DerbyRepositoryHandler.java:201)
	at org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:132)
	at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:91)
	at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:62)
	at org.apache.sqoop.repository.JdbcRepository.createOrUpgradeRepository(JdbcRepository.java:128)
	at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:128)
	at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:82)
	at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:60)
	at org.apache.sqoop.server.SqoopJettyServer.<init>(SqoopJettyServer.java:67)
	at org.apache.sqoop.server.SqoopJettyServer.main(SqoopJettyServer.java:177)
Caused by: java.sql.SQLSyntaxErrorException: Schema 'SQOOP' does not exist
	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.EmbedPreparedStatement.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
	at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
	at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
	at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
	... 13 more
Caused by: java.sql.SQLException: Schema 'SQOOP' does not exist
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	... 29 more
Caused by: ERROR 42Y07: Schema 'SQOOP' does not exist
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
	at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
	at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
	at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
	... 23 more
2019-06-01 09:48:27,165 INFO  [org.apache.sqoop.repository.common.CommonRepositoryHandler.runQuery(CommonRepositoryHandler.java:2682)] QUERY(CREATE SCHEMA "SQOOP") Update count: 0
2019-06-01 09:48:27,276 INFO  [org.apache.sqoop.repository.common.CommonRepositoryHandler.runQuery(CommonRepositoryHandler.java:2682)] QUERY(CREATE TABLE "SQOOP"."SQ_CONNECTOR" ("SQC_ID" BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY, "SQC_NAME" VARCHAR(64), "SQC_CLASS" VARCHAR(255), "SQC_VERSION" VARCHAR(64) )) Update count: 0
2019-06-01 09:48:27,403 INFO  [org.apache.sqoop.repository.common.CommonRepositoryHandler.runQuery(CommonRepositoryHandler.java:2682)] QUERY(CREATE TABLE "SQOOP"."SQ_FORM" ("SQF_ID" BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY, "SQF_CONNECTOR" BIGINT, "SQF_OPERATION" VARCHAR(32), "SQF_NAME" VARCHAR(64), "SQF_TYPE" VARCHAR(32), "SQF_INDEX" SMALLINT, CONSTRAINT "SQOOP"."FK_SQF_SQC" FOREIGN KEY (

?

?

sqoop2 創建的derby第一次鏈接是沒有數據庫 SQOOP的,然后自動創建 SQOOP數據庫,并賦值元數據

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

論壇首頁 綜合技術版

跳轉論壇:
Global site tag (gtag.js) - Google Analytics 真人娱乐官方网站 环江| 军事| 康平县| 自贡市| 铁力市| 长宁区| 三穗县| 潼关县| 温州市| 曲水县| 宜兴市| 万源市| 荔波县| 平定县| 贵南县| 青岛市| 合阳县| 钦州市| 陆河县| 诸暨市| 申扎县| 石柱| 雅安市| 福海县| 信丰县| 合肥市| 商水县| 高青县| 信宜市| 通道| 库伦旗| 东阳市| 宜君县| 金沙县| 封丘县| 宁武县| 凤凰县| 德惠市| 洛阳市| 云梦县| 扎鲁特旗| 寻乌县| 寿阳县| 和硕县| 马关县| 榆社县| 盐津县| 石首市| 阳西县| 长子县| 平原县| 夹江县| 淮安市| 巧家县| 丁青县| 凤城市| 安陆市| 乌兰浩特市| 金沙县| 霍林郭勒市| 环江| 洛南县| 上思县| 西平县| 绥阳县| 巴青县| 华阴市| 界首市| 鱼台县| 安仁县| 内黄县| 中西区| 陈巴尔虎旗| 沁源县| 怀来县| 太康县| 馆陶县| 广平县| 新野县| 黑龙江省| 余姚市| 汝阳县| 莱阳市| 托克托县| 古丈县| 蒲城县| 外汇| 台湾省| 肥西县| 黄浦区| 南澳县| 苗栗县| 沽源县| 台江县| 锡林浩特市| 林甸县| 九寨沟县| 海丰县| 武夷山市| 维西| 衡水市| 汉沽区| 江西省| 瑞安市| 玉屏| 兴山县| 儋州市| 黄陵县| 西峡县| 瑞金市| 桓仁| 元氏县| 五台县| 河北省| 朝阳市| 阿尔山市| 浦江县| 富源县| 株洲县| 玉环县| 镇沅| 武平县| 营山县| 分宜县| 宜兰市| 井冈山市| 大荔县| 鸡西市| 兰西县| 临朐县| 淅川县| 留坝县| 康平县| 商南县| 那曲县| 油尖旺区| 宁河县|