Skip to content

Unable to create server due to sql: no rows in result set #10370

@yyforyongyu

Description

@yyforyongyu

From this build, which used the following setup,

make itest-parallel tranches=8 backend=bitcoind dbbackend=sqlite nativesql=true tags=test_native_sql

The failed logs,

2025-11-13 13:27:59.526 [WRN] LTND config.go:879: open /tmp/itest-self_node_announcement_persistence-Alice-15-1763040476173382397/lnd.conf: no such file or directory
2025-11-13 13:27:59.527 [INF] LTND lnd.go:186: Version Info version=0.20.99-beta commit=v0.20.0-beta-37-g40d09a9b1 debuglevel=development logging=debug
2025-11-13 13:27:59.527 [INF] LTND lnd.go:213: Network Info active_chain=Bitcoin network=regtest
2025-11-13 13:27:59.528 [DBG] ARPC autopilot_server.go:140: Autopilot RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] NTFR chain_server.go:210: ChainNotifier RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] NTFR chain_server.go:214: ChainKit RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] NRPC neutrino_server.go:141: Neutrino RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] SGNR signer_server.go:216: Signer RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] VRPC server.go:66: Versioner RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] WLKT walletkit_server.go:344: WalletKit RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] DRPC dev_server.go:137: DEV RPC server successfully registered with root the gRPC server
2025-11-13 13:27:59.528 [DBG] IRPC invoices_server.go:190: Invoices RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] PRPC peers_server.go:119: Peers RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [DBG] RRPC router_server.go:301: Router RPC server successfully registered with root gRPC server
2025-11-13 13:27:59.528 [INF] RPCS lnd.go:923: RPC server listening on 127.0.0.1:10502
2025-11-13 13:27:59.530 [DBG] ARPC autopilot_server.go:163: Autopilot REST server successfully registered with root REST server
2025-11-13 13:27:59.530 [DBG] NTFR chain_server.go:237: ChainNotifier REST server successfully registered with root REST server
2025-11-13 13:27:59.530 [DBG] NTFR chain_server.go:248: ChainKit REST server successfully registered with root REST server
2025-11-13 13:27:59.533 [DBG] NRPC neutrino_server.go:164: Neutrino REST server successfully registered with root REST server
2025-11-13 13:27:59.534 [DBG] SGNR signer_server.go:239: Signer REST server successfully registered with root REST server
2025-11-13 13:27:59.534 [DBG] VRPC server.go:89: Versioner REST server successfully registered with root REST server
2025-11-13 13:27:59.535 [DBG] WLKT walletkit_server.go:367: WalletKit REST server successfully registered with root REST server
2025-11-13 13:27:59.540 [DBG] DRPC dev_server.go:160: DEV REST server successfully registered with the root REST server
2025-11-13 13:27:59.541 [DBG] IRPC invoices_server.go:213: Invoices REST server successfully registered with root REST server
2025-11-13 13:27:59.541 [DBG] PRPC peers_server.go:142: Peers REST server successfully registered with root REST server
2025-11-13 13:27:59.541 [DBG] RRPC router_server.go:324: Router REST server successfully registered with root REST server
2025-11-13 13:27:59.542 [INF] RPCS lnd.go:1044: gRPC proxy started at 127.0.0.1:10503
2025-11-13 13:27:59.542 [INF] LTND config_builder.go:993: Opening the main database, this might take a few minutes...
2025-11-13 13:27:59.549 [INF] LTND config_builder.go:1041: Creating local graph and channel state DB instances
2025-11-13 13:27:59.550 [INF] CHDB db.go:1686: Checking for schema update: latest_version=33, db_version=33
2025-11-13 13:27:59.550 [INF] CHDB db.go:1780: Applying 2 optional migrations
2025-11-13 13:27:59.551 [INF] CHDB db.go:1784: Checking for optional update: name=prune_revocation_log
2025-11-13 13:27:59.551 [DBG] CHDB db.go:1788: Skipping optional migration: name=prune_revocation_log as it is not specified in the config
2025-11-13 13:27:59.551 [INF] CHDB db.go:1784: Checking for optional update: name=gc_decayed_log
2025-11-13 13:27:59.551 [DBG] CHDB db.go:1798: Skipping optional migration: name=gc_decayed_log as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000001_invoices' (version 1) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000002_amp_invoices' (version 2) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000003_invoice_events' (version 3) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000004_invoice_expiry_fix' (version 4) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000005_migration_tracker' (version 5) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000006_invoice_migration' (version 6) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration 'kv_invoice_migration' (version 7) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000007_invoice_add_settled_index' (version 8) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration '000008_graph' (version 9) as it has already been applied
2025-11-13 13:27:59.551 [INF] SQLD migrations.go:432: Skipping migration 'kv_graph_migration' (version 10) as it has already been applied
2025-11-13 13:27:59.553 [INF] LTND config_builder.go:1325: Database(s) now open (time_to_open=11.310453ms)!
2025-11-13 13:27:59.557 [INF] RPCC infrastructure.go:1545: Established connection to RPC server 127.0.0.1:10057
2025-11-13 13:27:59.557 [INF] RPCC infrastructure.go:1545: Established connection to RPC server 127.0.0.1:10057
2025-11-13 13:27:59.560 [DBG] RPCC infrastructure.go:1678: Detected bitcoind version: /Satoshi:29.0.0/
2025-11-13 13:27:59.561 [INF] RPCC infrastructure.go:1545: Established connection to RPC server 127.0.0.1:10057
2025-11-13 13:27:59.562 [INF] BTWL bitcoind_zmq_events.go:246: Started listening for bitcoind block notifications via ZMQ on 127.0.0.1:10055
2025-11-13 13:27:59.562 [INF] BTWL bitcoind_zmq_events.go:343: Started listening for bitcoind transaction notifications via ZMQ on 127.0.0.1:10056
2025-11-13 13:27:59.563 [DBG] RPCC infrastructure.go:1678: Detected bitcoind version: /Satoshi:29.0.0/
2025-11-13 13:27:59.566 [INF] CHRE chainregistry.go:720: Using external fee estimator http://localhost:10007/fee-estimates.json: cached=false: min update timeout=5m0s, max update timeout=20m0s
2025-11-13 13:27:59.566 [INF] LNWL estimator.go:843: Starting Web API fee estimator...
2025-11-13 13:27:59.566 [DBG] LNWL estimator.go:1011: Received response from source: {"fee_by_block_target":{"1":50000},"min_relay_feerate":1012}
2025-11-13 13:27:59.570 [INF] BTWL wallet.go:4411: Opened wallet
2025-11-13 13:27:59.572 [INF] BTWL wallet.go:1430: The wallet has been unlocked without a time limit
2025-11-13 13:27:59.612 [INF] CHRE chainregistry.go:792: LightningWallet opened
2025-11-13 13:27:59.613 [DBG] BTWL chainntfns.go:521: Birthday block has already been verified: height=0, hash=0f9188f13cb7b2c71f2a335e3a4fc328bf5beb436012afca590b1a11466e2206
2025-11-13 13:27:59.617 [INF] HSWC circuit_map.go:280: Cleaning circuits from disk for closed channels
2025-11-13 13:27:59.617 [DBG] HSWC circuit_map.go:324: Found 0 closed channels
2025-11-13 13:27:59.617 [INF] HSWC circuit_map.go:328: Finished cleaning: no closed channels found, no actions taken.
2025-11-13 13:27:59.617 [INF] HSWC circuit_map.go:497: Restoring in-memory circuit state from disk
2025-11-13 13:27:59.618 [INF] HSWC circuit_map.go:602: Payment circuits loaded: num_pending=0, num_open=0
2025-11-13 13:27:59.619 [ERR] LTND lnd.go:169: Shutting down due to error in main method err="can't set self node: unable to upsert source node: upserting node(037e10ee34f414c80687ffa3dc0f68a9b6c88254f44d0b62d5018526627cd5e6cc): sql: no rows in result set"
2025-11-13 13:27:59.621 [INF] BTWL chainntfns.go:155: Stopped waiting for wallet sync due to error: wallet shutting down
2025-11-13 13:27:59.621 [INF] LNWL estimator.go:877: Stopping web API fee estimator
2025-11-13 13:27:59.621 [INF] SQLB db.go:299: Closing database towerserverdb
2025-11-13 13:27:59.621 [INF] SQLB db.go:299: Closing database walletdb
2025-11-13 13:27:59.621 [INF] SQLB db.go:299: Closing database channeldb
2025-11-13 13:27:59.621 [INF] SQLB db.go:299: Closing database macaroondb
2025-11-13 13:27:59.622 [INF] SQLB db.go:299: Closing database decayedlogdb
2025-11-13 13:27:59.622 [INF] SQLB db.go:299: Closing database towerclientdb
2025-11-13 13:27:59.624 [INF] LTND lnd.go:152: Shutdown complete
unable to create server: can't set self node: unable to upsert source node: upserting node(037e10ee34f414c80687ffa3dc0f68a9b6c88254f44d0b62d5018526627cd5e6cc): sql: no rows in result set

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

In progress

Relationships

None yet

Development

No branches or pull requests

Issue actions