graphprotocol / graphprotocol/graph-node
[Bug] graphman sometimes creates the wrong index
Abierto
@incrypto32 ya está trabajando en esto.
Desde el 10/1/2024.
bug
- Lenguaje dominante
- Rust
- Estrellas
- 3.2k
- Forks
- 1.1k
- Merge medio
- 4 d 1 h
- PR fusionados (30 d)
- 1
Descripción
Bug report
The following graphman command resulted in an unexpected index:
graphman index create sgd647572 pool_hour_data pool
Index creation started. Please wait.
Index creation completed.
Listing information about the table in the DB showed the following index having been created:
=> \d sgd647572.pool_hour_data
Table "sgd647572.pool_hour_data"
Column | Type | Collation | Nullable | Default
-------------------------+-----------+-----------+----------+-------------------------------------------------------
vid | bigint | | not null | nextval('sgd647572.pool_hour_data_vid_seq'::regclass)
block_range | int4range | | not null |
id | text | | not null |
period_start_unix | integer | | not null |
pool | text | | not null |
[...]
Indexes:
"pool_hour_data_pkey" PRIMARY KEY, btree (vid)
"attr_15_0_pool_hour_data_id" btree (id)
[...]
"attr_15_9_pool_hour_data_fee_growth_global_1x128" btree (fee_growth_global_1x128)
"brin_pool_hour_data" brin (lower(block_range) int4_minmax_multi_ops, COALESCE(upper(block_range), 2147483647) int4_minmax_multi_ops, vid int8_minmax_multi_ops)
"manual_pool_hour_data_pool" btree (pool, block_range)
"pool_hour_data_block_range_closed" btree (COALESCE(upper(block_range), 2147483647)) WHERE COALESCE(upper(block_range), 2147483647) < 2147483647
"pool_hour_data_id_block_range_excl" gist (id, block_range)
I saw this behaviour earlier on other SGs as well, in one case on a token table.
Relevant log output
No response
IPFS hash
QmZeCuoZeadgHkGwLwMeguyqUKz1WPWQYKcKyMCeQqGhsF
Subgraph name or link to explorer
No response
Some information to help us out
- Tick this box if this bug is caused by a regression found in the latest release.
- Tick this box if this bug is specific to the hosted service.
- I have searched the issue tracker to make sure this issue is not a duplicate.
OS information
None
Guía de contribución
Primeros pasos
- Lee el issue completo y luego la guía de contribución del proyecto.
- Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
- Haz un fork del repositorio y trabaja en una rama.
- Abre un pull request que haga referencia al número del issue.
Evaluación
Este issue todavía no se ha evaluado.