外部节点的区块数据库配置为mysql
【问题分类】
- bug
- P2P网络相关(包含libp2p,liquid)
- 链账户身份与权限相关(证书问题、public、多签投票问题)
- 核心交易引擎相关(交易池、DAG)
- 共识相关
- 智能合约相关
- 存储相关
- SDK相关
- 长安链CMC工具
- 长安链管理台
- 长安链浏览器
- 长安链合约IDE
- 长安链web签名插件
- 跨链相关
- 轻节点相关
- 隐私计算相关
- 密码学相关
- 环境依赖
- 其他补充:
【问题描述】(请对问题进行描述,方便定位问题)
具体的现象,操作步骤,前置条件等,尽可能描述清楚,有截图说明更佳
集群内部有3个节点区块数据库为leveldb,外部节点是mysql数据库,启动外部节点失败,具体原因是什么 节点配置:
auth_type: permissionedWithCert
log:
config_file: ../config/log.yml
crypto_engine: tencentsm
blockchain:
- chainId: sql
genesis: ../config/sql.yml
node:
org_id: sql.com
priv_key_file: ../config/consensus4.sql.com.key
cert_file: ../config/consensus4.sql.com.crt
cert_cache_size: 1000
cert_key_usage_check: true
fast_sync:
enabled: true
min_full_blocks: 10
pkcs11:
enabled: false
type: ""
library: ""
label: ""
password: ""
session_cache_size: 0
hash: ""
net:
provider: LibP2P
listen_addr: /ip4/0.0.0.0/tcp/11301
peer_stream_pool_size: 100
max_peer_count_allow: 20
peer_elimination_strategy: 3
seeds:
- /dns/consensus3.sql.com/tcp/30201/p2p/QmbaSbNuma2Hm6hgnBzbovYeyfRMGdYu8mxkSCmyoSro4W
- /dns/consensus1.sql.com/tcp/30201/p2p/Qma8scsKrBhJAHMxGVRNDcc5RRzQgSy9XbqYvHZ7E66vaC
- /dns/consensus0.sql.com/tcp/30201/p2p/QmTefNMuRQ8tWGYW3bvk6jfpf37eWQg5Ucbm3J4L7ynnrC
tls:
enabled: true
priv_key_file: ../config/consensus4.sql.com.key
cert_file: ../config/consensus4.sql.com.crt
priv_enc_key_file: ""
cert_enc_file: ""
txpool:
pool_type: single
max_txpool_size: 100000
max_config_txpool_size: 100
is_dump_txs_in_queue: true
common_queue_num: 8
batch_max_size: 100
batch_create_timeout: 50
rpc:
provider: grpc
port: 12301
check_chain_conf_trust_roots_change_interval: 60
gateway: null
ratelimit: null
subscriber:
ratelimit:
enabled: false
type: ""
token_per_second: 100
token_bucket_size: 100
tls:
mode: twoway
priv_key_file: ../config/consensus4.sql.com.key
cert_file: ../config/consensus4.sql.com.crt
priv_enc_key_file: ""
cert_enc_file: ""
blacklist: null
max_send_msg_size: 100
max_recv_msg_size: 100
tx_filter:
type: 0
sharding:
length: 5
timeout: 3
snapshot:
type: 0
timed:
interval: 10
block_height:
interval: 10
serialize_interval: 10
path: ../data/tx_filter
birds_nest:
length: 10
snapshot: null
rules:
absolute_expire_time: 172800
cuckoo:
key_type: 1
tags_per_bucket: 2
bits_per_item: 11
max_num_keys: 2000000
table_type: 0
birds_nest:
length: 10
snapshot:
type: 0
timed:
interval: 10
block_height:
interval: 10
serialize_interval: 10
path: ../data/tx_filter
rules:
absolute_expire_time: 172800
cuckoo:
key_type: 1
tags_per_bucket: 2
bits_per_item: 11
max_num_keys: 2000000
table_type: 0
monitor:
enabled: false
port: 8081
pprof:
enabled: false
port: 24321
consensus:
raft:
snap_count: 10
async_wal_save: true
ticker: 1
scheduler:
rwset_log: false
storage:
store_path: ../data/ledgerData
unarchive_block_height: 300000
disable_block_file_db: false
logdb_segment_async: false
logdb_segment_size: 128
read_bfdb_timeout: 1000
enable_bigfilter: false
bigfilter_config: null
enable_rwc: true
rolling_window_cache_capacity: 55000
write_block_type: 0
disable_state_cache: true
state_cache_config: null
blockdb_config:
provider: sql
sqldb_config:
sqldb_type: mysql
dsn: *********
statedb_config:
provider: leveldb
leveldb_config:
store_path: ../data/leveldb/state
historydb_config:
provider: leveldb
disable_key_history: false
disable_contract_history: true
disable_account_history: true
leveldb_config:
store_path: ../data/leveldb/history
resultdb_config:
provider: leveldb
leveldb_config:
store_path: ../data/leveldb/result
disable_contract_eventdb: true
contract_eventdb_config: null
vm:
go:
enable: true
data_mount_path: ../data/go
log_mount_path: ../log/go
protocol: tcp
log_in_console: true
log_level: WARN
max_send_msg_size: 100
max_recv_msg_size: 100
dial_timeout: 10
max_concurrency: 20
runtime_server:
port: 32351
contract_engine:
host: 127.0.0.1
port: 22351
max_connection: 10
报错信息:
2025-07-01 14:54:18.260 [WARN] [Storage] @sql v2@v2.3.6/blockstore_impl.go:2287 archive feature not support in this store config
2025-07-01 14:54:18.268 [ERROR] [Blockchain] @sql blockchain/blockchain_init.go:186 init base module[Ledger] failed, put chain[sql] genesis block failed, table row query error
2025-07-01 14:54:18.268 [ERROR] [Blockchain] blockchain/chainmaker_server.go:216 init blockchain[sql] failed, put chain[sql] genesis block failed, table row query error
2025-07-01 14:54:18.268 [ERROR] [Cli] cmd/cli_start.go:57 chainmaker server init failed, init all blockchains fail
ChainMaker exit
【系统信息】(请填写系统信息,方便定位问题)
- chainmaker-go version * : [v2.3.4]
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information