search

polardb / polardbx-sql

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
Apache License 2.0
1.54k stars 325 forks source link

[PXC-9001][ERR_GMS_GENERIC] failed to create default db #38

Closed cheeloosoft closed 11 months ago

cheeloosoft commented 2 years ago

2021-12-01 09:48:07.466 [main] ERROR com.alibaba.polardbx.CobarConfig - [] Failed to init cobar server. com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] failed to create default db, err is ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] No found any storage inst of metaDb. . at com.alibaba.polardbx.gms.topology.DbTopologyManager.createInternalSystemDbIfNeed(DbTopologyManager.java:223) at com.alibaba.polardbx.gms.topology.SystemDbHelper.checkOrCreateDefaultDb(SystemDbHelper.java:61) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initSystemDbIfNeed(MetaDbDataSource.java:420) at com.alibaba.polardbx.config.loader.ServerLoader.initPolarDbXComponents(ServerLoader.java:248) at com.alibaba.polardbx.config.loader.ServerLoader.load(ServerLoader.java:181) at com.alibaba.polardbx.config.loader.ServerLoader.doInit(ServerLoader.java:91) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) at com.alibaba.polardbx.CobarConfig.initCobarConfig(CobarConfig.java:68) at com.alibaba.polardbx.CobarConfig.(CobarConfig.java:61) at com.alibaba.polardbx.CobarServer.(CobarServer.java:141) at com.alibaba.polardbx.CobarServer.(CobarServer.java:95) at com.alibaba.polardbx.server.TddlLauncher.main(TddlLauncher.java:82) Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] No found any storage inst of metaDb. at com.alibaba.polardbx.gms.topology.DbTopologyManager.createInternalSystemDbIfNeed(DbTopologyManager.java:208) ... 11 common frames omitted [Uploading PXC-9001 数据库.txt…]()

cheeloosoft commented 2 years ago

PXC-9001.tar.gz 应用logs/tddl下的日志

pyson commented 2 years ago

"No found any storage inst of metaDb" means cn can NOT find any DN info from metadb ,maybe the dn infos of metadb is invalid.

vettalwu commented 2 years ago

@cheeloosoft How do you deploy this polardbx cluster? pxd, k8s or source code?

cheeloosoft commented 2 years ago

source code on CentOS Linux release 7.6.1810 single node

cheeloosoft commented 2 years ago

conf/server.properties

PolarDB-X 服务端口

serverPort=8527

PolarDB-X RPC 端口

rpcPort=9090

MetaDB地址

metaDbAddr=127.0.0.1:4886

MetaDB私有协议端口

metaDbXprotoPort=32886

MetaDB用户

metaDbUser=my_polarx metaDbName=polardbx_meta_db_polardbx

PolarDB-X实例名

instanceId=polardbx-polardbx

galaxyXProtocol=1

metaDbPasswd=7pKen4TpFua3pZBZigJAnAAiRflEzLSTo86sJKStSY8=

vettalwu commented 2 years ago

@cheeloosoft Do you specify the dn list when initialize PolarDB-X?

image

cheeloosoft commented 2 years ago

Initialization command

bin/startup.sh \ -I \ -P asdf1234ghjk5678 \ -d 127.0.0.1:4886:32886 \ -r "" \ -u polardbx_root \ -S "123456"

Generate password for user: mypolarx && #_Q9_7@vW4@)0#R9@W5&6#F7$ 数据库的用户密码 Encrypted password: 7pKen4TpFua3pZBZigJAnAAiRflEzLSTo86sJKStSY8= The property file is resident at resource file, skip saving password into it ======== Paste following configurations to conf/server.properties ! ======= metaDbPasswd=7pKen4TpFua3pZBZigJAnAAiRflEzLSTo86sJKStSY8= ======== Paste above configurations to conf/server.properties ! =======

cheeloosoft commented 2 years ago

@vettalwu logs/tddl/meta-db.log 2021-12-01 16:49:00.629 ERROR [TDDL] Failed to init meta db, err is, tddl version: 5.4.12-SNAPSHOT com.alibaba.polardbx.common.exception.TddlNestableRuntimeException: null at com.alibaba.polardbx.common.utils.GeneralUtil.nestedException(GeneralUtil.java:221) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:56) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.getInstance(MetaDbDataSource.java:463) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbDataSource(MetaDbDataSource.java:489) at com.alibaba.polardbx.config.loader.ServerLoader.initPolarDbXComponents(ServerLoader.java:207) at com.alibaba.polardbx.config.loader.ServerLoader.load(ServerLoader.java:181) at com.alibaba.polardbx.config.loader.ServerLoader.doInit(ServerLoader.java:91) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) at com.alibaba.polardbx.CobarConfig.initCobarConfig(CobarConfig.java:68) at com.alibaba.polardbx.CobarConfig.(CobarConfig.java:61) at com.alibaba.polardbx.CobarServer.(CobarServer.java:141) at com.alibaba.polardbx.CobarServer.(CobarServer.java:95) at com.alibaba.polardbx.server.TddlLauncher.main(TddlLauncher.java:82) Caused by: java.lang.NullPointerException: null at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbDataSource(MetaDbDataSource.java:179) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.doInit(MetaDbDataSource.java:121) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) ... 11 common frames omitted

in MetaDbDataSource metaDbAvailableAddr is null

Cleverdada commented 2 years ago

@vettalwu logs/tddl/meta-db.log 2021-12-01 16:49:00.629 ERROR [TDDL] Failed to init meta db, err is, tddl version: 5.4.12-SNAPSHOT com.alibaba.polardbx.common.exception.TddlNestableRuntimeException: null at com.alibaba.polardbx.common.utils.GeneralUtil.nestedException(GeneralUtil.java:221) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:56) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.getInstance(MetaDbDataSource.java:463) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbDataSource(MetaDbDataSource.java:489) at com.alibaba.polardbx.config.loader.ServerLoader.initPolarDbXComponents(ServerLoader.java:207) at com.alibaba.polardbx.config.loader.ServerLoader.load(ServerLoader.java:181) at com.alibaba.polardbx.config.loader.ServerLoader.doInit(ServerLoader.java:91) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) at com.alibaba.polardbx.CobarConfig.initCobarConfig(CobarConfig.java:68) at com.alibaba.polardbx.CobarConfig.(CobarConfig.java:61) at com.alibaba.polardbx.CobarServer.(CobarServer.java:141) at com.alibaba.polardbx.CobarServer.(CobarServer.java:95) at com.alibaba.polardbx.server.TddlLauncher.main(TddlLauncher.java:82) Caused by: java.lang.NullPointerException: null at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbDataSource(MetaDbDataSource.java:179) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.doInit(MetaDbDataSource.java:121) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) ... 11 common frames omitted

in MetaDbDataSource metaDbAvailableAddr is null

pls copy the "metaDbPasswd=7pKen4TpFua3pZBZigJAnAAiRflEzLSTo86sJKStSY8=" to conf/server.properties and restart