ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
4k stars 565 forks source link

[pg] failed on grafana save dashboard #8398

Open rekby opened 2 months ago

rekby commented 2 months ago

Request:

INSERT INTO "dashboard" ("uid","slug","org_id","gnet_id","version","plugin_id","created","updated","updated_by","created_by","folder_id","folder_uid","is_folder","has_acl","title","data") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) RETURNING "id"
packages in text format ``` PostgreSQL Type: Parse Length: 289 Statement: Query [truncated]: INSERT INTO "dashboard" ("uid","slug","org_id","gnet_id","version","plugin_id","created","updated","updated_by","created_by","folder_id","folder_uid","is_folder","has_acl","title","data") VALUES ($1, $2, $3, $4, $5, $6, Parameters: 0 PostgreSQL Type: Describe Length: 6 Statement: PostgreSQL Type: Sync Length: 4 PostgreSQL Type: Parameter description Length: 70 Parameters: 16 PostgreSQL Type: Row description Length: 27 Field count: 1 Column name: id Table OID: 0 Column index: 0 Type OID: 23 Column length: 0 Type modifier: 0 Format: Text (0) PostgreSQL Type: Ready for query Length: 5 Status: In a transaction (84) PostgreSQL Type: Bind Length: 1746 Portal: Statement: Parameter formats: 0 Parameter values: 16 Column length: 14 Data: 626477367a6669776a7132326f61 Column length: 13 Data: 6e65772d64617368626f617264 Column length: 1 Data: 31 Column length: 1 Data: 30 Column length: 1 Data: 31 Column length: 0 Column length: 19 Data: 323032342d30382d32382031333a33353a3338 Column length: 19 Data: 323032342d30382d32382031333a33353a3338 Column length: 1 Data: 31 Column length: 1 Data: 31 Column length: 1 Data: 30 Column length: -1 Column length: 5 Data: 66616c7365 Column length: 5 Data: 66616c7365 Column length: 13 Data: 4e65772064617368626f617264 Column length: 1574 Data [truncated]: 7b22616e6e6f746174696f6e73223a7b226c697374223a5b7b226275696c74496e223a312c2264617461736f75726365223a7b2274797065223a2267726166616e61222c22756964223a222d2d2047726166616e61202d2d227d2c22656e61626c65223a747275652c22686964652 Result formats: 1 Format: Binary (1) PostgreSQL Type: Execute Length: 9 Portal: Returns: all rows PostgreSQL Type: Sync Length: 4 ```

error:

Status: PRECONDITION_FAILED
Issues: 
<main>: Error: ydb/library/yql/minikql/computation/mkql_value_builder.cpp:52: Terminate was called, reason(50): ERROR:  invalid input syntax for type boolean: ""

Reproduce steps:

  1. Run local YDB https://github.com/ydb-platform/ydb/wiki/Local-run-postgres-tests
  2. Run install and run grafana
git clone https://github.com/ydb-platform/postgres-compatibility-tests
cd postgres-compatibility-tests
git clone postgres compatibility
git checkout 06b4540bd1a6679f1dffefb8d217311f0dc47047
cat ./manual-in-progress/grafana/ydb-schema.sql | psql postgres://root:1234@localhost:5432/local
cat ./manual-in-progress/grafana/ydb-data.sql | psql postgres://root:1234@localhost:5432/local
  1. Try to add and save new dashboard
    • enter with login/password admin/admin
    • click "Dashboards"
    • click "+ Create Dashboard"
    • click "+ Add visualization"
    • close popped up window (select data source)
    • click "save" at up right corner
    • click "save" again.

image

rekby commented 2 months ago

wait https://github.com/ydb-platform/ydb/issues/8401

SloNN commented 2 months ago

@rekby makes a repro

rekby commented 1 month ago

writed manual repro