timescale / timescale/tiger-cli

tiger db psql fails to connect — FATAL: cannot disable read-only mode (SQLSTATE 25006)

Open
#212 3 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
119
Forks
12
Avg merge
2d 15h
Merged PRs (30d)
33

Description

Tiger CLI 0.23.0, windows/amd64. Config: read_only: all.

With read_only: all set, the CLI appends options=-c tsdb_admin.read_only_connection=true to the connection string, which causes a server error when connecting:

$ tiger db psql <service-id> --role <role>
Error: failed to connect to user=<role> database=tsdb:
        server error: FATAL: cannot disable read-only mode: connection is in protected read-only state (SQLSTATE 25006)

The same connection string without that parameter connects fine.

Also, if run immediately before it — same role, same service, same config:

$ tiger db test-connection <service-id> --role <role>
Connection successful

test-connection evidently does not send that parameter, so it reports healthy for a role/config pair that cannot actually connect.

Note the message says the connection is being disabled when the client asked to enable read-only mode.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the tiger db psql and tiger db test-connection command entry points and trace how each constructs its connection string. Reproduce the read_only: all case, compare their handling of tsdb_admin.read_only_connection=true, and add coverage showing that the affected role can connect consistently.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
cli, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
68/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.