polardbx-sql icon indicating copy to clipboard operation
polardbx-sql copied to clipboard

Published 20 hours ago • verified publisher icon polardb

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

Open cheeloosoft opened this issue 3 years ago • 9 comments

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 avatar Dec 01 '21 03:12 cheeloosoft

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

cheeloosoft avatar Dec 01 '21 03:12 cheeloosoft

"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.

pyson avatar Dec 01 '21 03:12 pyson

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

vettalwu avatar Dec 01 '21 03:12 vettalwu

source code on CentOS Linux release 7.6.1810 single node

cheeloosoft avatar Dec 01 '21 03:12 cheeloosoft

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=

cheeloosoft avatar Dec 01 '21 06:12 cheeloosoft

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

image

vettalwu avatar Dec 01 '21 06:12 vettalwu

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: my_polarx && _#_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 avatar Dec 01 '21 07:12 cheeloosoft

@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

cheeloosoft avatar Dec 01 '21 09:12 cheeloosoft

@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

Cleverdada avatar Mar 29 '22 03:03 Cleverdada