threefoldtech / grid_deployment

Deploy a full Grid backend with docker-compose and snapshots
Apache License 2.0
2 stars 0 forks source link

[all nets] apply indexer cockroach db fix #54

Closed coesensbert closed 3 months ago

coesensbert commented 4 months ago

see: https://github.com/threefoldtech/tfchain_graphql/issues/130

first test: https://github.com/threefoldtech/tf_operations/issues/2570

apply to:

coesensbert commented 3 months ago

Applied and tested all, for a full indexer sync test see: https://github.com/threefoldtech/tf_operations/issues/2570

coesensbert commented 3 months ago

check:

docker exec -it indexer_db /bin/bash
./cockroach sql --insecure
SHOW CLUSTER SETTING sql.conn.max_read_buffer_message_size;
root@indexersynctest:~/code/grid_deployment/grid-snapshots/testnet# docker exec -it indexer_db /bin/bash
[root@bbeea85333a0 cockroach]# ./cockroach sql --insecure
#
# Welcome to the CockroachDB SQL shell.
# All statements must be terminated by a semicolon.
# To exit, type: \q.
#
# Server version: CockroachDB CCL v22.2.2 (x86_64-pc-linux-gnu, built 2023/01/04 17:23:00, go1.19.1) (same version as client)
# Cluster ID: 0132e4a9-0baf-4072-addf-e3195f64f881
#
# Enter \? for a brief introduction.
#
root@localhost:26257/defaultdb> SHOW CLUSTER SETTING sql.conn.max_read_buffer_message_size;
  sql.conn.max_read_buffer_message_size
-----------------------------------------
  32 MiB
(1 row)

Time: 1ms total (execution 0ms / network 0ms)

root@localhost:26257/defaultdb>