配置都正确,但是启动后会出现table[null.product_info] is not found报错,应该是无法找到对应的数据库db名称。
以下是报错内容:
019-02-18 19:33:33.520 [main] INFO com.taobao.yugong.YugongApp - ## start the YuGong.
2019-02-18 19:33:33.618 [main] INFO com.taobao.yugong.controller.YuGongController - check source database connection ...
2019-02-18 19:33:33.636 [main] INFO com.taobao.yugong.controller.YuGongController - check source database is ok
2019-02-18 19:33:33.637 [main] INFO com.taobao.yugong.controller.YuGongController - check target database connection ...
2019-02-18 19:33:33.664 [main] INFO com.taobao.yugong.controller.YuGongController - check target database is ok
2019-02-18 19:33:33.664 [main] INFO com.taobao.yugong.controller.YuGongController - check source tables read privileges ...
2019-02-18 19:33:33.739 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
2019-02-18 19:33:34.608 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
2019-02-18 19:33:36.035 [main] INFO com.taobao.yugong.controller.YuGongController - check source tables is ok.
2019-02-18 19:33:36.120 [main] INFO com.taobao.yugong.controller.YuGongController - ## prepare start tables[1] with concurrent[6]
2019-02-18 19:33:36.273 [main] INFO com.taobao.yugong.extractor.FullContinueExtractor - Honey.Mob.UAT.Product_Info start postion:-9215209262513389569
2019-02-18 19:33:36.332 [main] INFO com.taobao.yugong.controller.YuGongInstance - table[Honey.Mob.UAT.Product_Info] start successful. extractor:com.taobao.yugong.extractor.sqlserver.SqlServerFullRecordExtractor , applier:com.taobao.yugong.applier.MultiThreadFullRecordApplier, translator:[NameStyleDataTranslator(schemaTo=test_mysql, tableTo=null, columnCaseFormatFrom=UPPER_CAMEL, columnCaseFormatTo=LOWER_UNDERSCORE, tableCaseFormatFrom=UPPER_CAMEL, tableCaseFormatTo=LOWER_UNDERSCORE), NameStyleDataTranslator(schemaTo=null, tableTo=product_info, columnCaseFormatFrom=null, columnCaseFormatTo=null, tableCaseFormatFrom=null, tableCaseFormatTo=null), CompositeIndexesDataTranslator(compositeIndexes=[product_code, version_id]), com.taobao.yugong.translator.ColumnFixDataTranslator@3ee37e5a]
2019-02-18 19:33:36.332 [YuGongInstance-Honey.Mob.UAT.Product_Info] INFO com.taobao.yugong.controller.YuGongInstance - table[Honey.Mob.UAT.Product_Info] is start
2019-02-18 19:33:36.332 [main] INFO com.taobao.yugong.YugongApp - ## the YuGong is running now ......
2019-02-18 19:33:36.347 [main] INFO com.taobao.yugong.YugongApp -
[YuGong Version Info]
[version ]Unknown
[hexVeision]Unknown
[date ]Unknown
[branch ]Unknown
[url ]Unknown
2019-02-18 19:33:38.535 [YuGongInstance-Honey.Mob.UAT.Product_Info] ERROR com.taobao.yugong.controller.YuGongInstance - retry 1 ,something error happened. caused by java.lang.RuntimeException: java.util.concurrent.ExecutionException: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at com.taobao.yugong.common.utils.thread.ExecutorTemplate.waitForResult(ExecutorTemplate.java:79)
at com.taobao.yugong.applier.MultiThreadFullRecordApplier.apply(MultiThreadFullRecordApplier.java:103)
at com.taobao.yugong.controller.YuGongInstance$1.processTable(YuGongInstance.java:271)
at com.taobao.yugong.controller.YuGongInstance$1.run(YuGongInstance.java:201)
at java.lang.Thread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at com.taobao.yugong.common.utils.thread.ExecutorTemplate.waitForResult(ExecutorTemplate.java:77)
... 4 more
Caused by: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at com.taobao.yugong.common.db.meta.TableMetaGenerator.lambda$getTableMeta$0(TableMetaGenerator.java:83)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342)
at com.taobao.yugong.common.db.meta.TableMetaGenerator.getTableMeta(TableMetaGenerator.java:50)
at com.taobao.yugong.applier.FullRecordApplier.getSqlUnit(FullRecordApplier.java:391)
at com.taobao.yugong.applier.FullRecordApplier.doApply(FullRecordApplier.java:82)
at com.taobao.yugong.applier.MultiThreadFullRecordApplier$1.run(MultiThreadFullRecordApplier.java:93)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
... 1 more
2019-02-18 19:33:38.536 [YuGongInstance-Honey.Mob.UAT.Product_Info] ERROR com.taobao.yugong.common.alarm.LogAlarmService - Alarm:java.lang.RuntimeException: java.util.concurrent.ExecutionException: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at com.taobao.yugong.common.utils.thread.ExecutorTemplate.waitForResult(ExecutorTemplate.java:79)
at com.taobao.yugong.applier.MultiThreadFullRecordApplier.apply(MultiThreadFullRecordApplier.java:103)
at com.taobao.yugong.controller.YuGongInstance$1.processTable(YuGongInstance.java:271)
at com.taobao.yugong.controller.YuGongInstance$1.run(YuGongInstance.java:201)
at java.lang.Thread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at com.taobao.yugong.common.utils.thread.ExecutorTemplate.waitForResult(ExecutorTemplate.java:77)
... 4 more
Caused by: com.taobao.yugong.exception.YuGongException: table[null.product_info] is not found
at com.taobao.yugong.common.db.meta.TableMetaGenerator.lambda$getTableMeta$0(TableMetaGenerator.java:83)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342)
at com.taobao.yugong.common.db.meta.TableMetaGenerator.getTableMeta(TableMetaGenerator.java:50)
at com.taobao.yugong.applier.FullRecordApplier.getSqlUnit(FullRecordApplier.java:391)
at com.taobao.yugong.applier.FullRecordApplier.doApply(FullRecordApplier.java:82)
at com.taobao.yugong.applier.MultiThreadFullRecordApplier$1.run(MultiThreadFullRecordApplier.java:93)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
... 1 more
, Receiver:
5条答案
按热度按时间ozxc1zmp1#
mysql中的表要先建,供参考。
iq3niunx2#
正解
dxpyg8gm3#
咋找不到目标库表创建的代码?
idv4meu84#
目标库需要自行手工创建。…
On Mon, May 20, 2019 at 9:20 AM hulu73***@***.***> wrote: 咋找不到目标库表创建的代码? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#102?email_source=notifications&email_token=AABXR2STMHNFZN7Y6ZEZ6ZLPWH4FHA5CNFSM4GYCXBM2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVXPIPY#issuecomment-493810751>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABXR2UEARKZXJAUC7VDCUTPWH4FHANCNFSM4GYCXBMQ> .
-- -- alswl
vs3odd8k5#
我这边建了目标库,但是还是报错null.tablename