pg.ddx.io pgvector/pgvector GitHub issues and pull requests
help / color / mirror / Atom feed[pgvector/pgvector] issue #1064: Corrupted index prevent table update
5+ messages / 2 participants
[nested] [flat]
* [pgvector/pgvector] issue #1064: Corrupted index prevent table update
@ 2026-11-14 01:06 "juchiast (@juchiast)" <noreply+juchiast@github.com>
0 siblings, 0 replies; 5+ messages in thread
From: juchiast (@juchiast) @ 2026-11-14 01:06 UTC (permalink / raw)
To: pgvector/pgvector <noreply+pgvector-pgvector@github.com>
We have a vector column and index defined as:
```sql
ALTER TABLE "table_name" ADD COLUMN IF NOT EXISTS "description_embedding_vector" vector(1536)
CREATE INDEX IF NOT EXISTS "IDX_index_name" ON "table_name" USING hnsw ("description_embedding_vector" vector_cosine_ops) WHERE "description_embedding_vector" IS NOT NULL;
```
Once in a while, this happen on our production system:
This error comes out of nowhere, on queries updating unrelated columns:
```
code: “22000”, message: “different vector dimensions 1536 and 0"
file: Some("vector.c"), line: Some(66), routine: Some("CheckDims")
```
The whole table is locked, cannot update any rows.
I checked and all values in the vector column are valid an has dimension 1536.
I have to remove and create the index again to fix the table:
```sql
DROP INDEX "IDX_index_name";
CREATE INDEX "IDX_index_name" ON "table_name" USING hnsw ("description_embedding_vector" vector_cosine_ops) WHERE "description_embedding_vector" IS NOT NULL;
```
After this, table is back working as normal.
This seems like a bug in pgvector, any idea?
^ permalink raw [nested|flat] 5+ messages in thread
* Re: [pgvector/pgvector] issue #1064: Corrupted index prevent table update
@ 2026-11-14 01:11 ` "ankane (@ankane)" <noreply+ankane@github.com>
3 siblings, 0 replies; 5+ messages in thread
From: ankane (@ankane) @ 2026-11-14 01:11 UTC (permalink / raw)
To: pgvector/pgvector <noreply+pgvector-pgvector@github.com>
Hi @juchiast, what exact version of Postgres (`SELECT version();`) and pgvector are you on?
^ permalink raw [nested|flat] 5+ messages in thread
* Re: [pgvector/pgvector] issue #1064: Corrupted index prevent table update
@ 2026-11-14 01:41 ` "ankane (@ankane)" <noreply+ankane@github.com>
3 siblings, 0 replies; 5+ messages in thread
From: ankane (@ankane) @ 2026-11-14 01:41 UTC (permalink / raw)
To: pgvector/pgvector <noreply+pgvector-pgvector@github.com>
@ankane closed this.
^ permalink raw [nested|flat] 5+ messages in thread
* Re: [pgvector/pgvector] issue #1064: Corrupted index prevent table update
@ 2026-11-14 01:41 ` "ankane (@ankane)" <noreply+ankane@github.com>
3 siblings, 0 replies; 5+ messages in thread
From: ankane (@ankane) @ 2026-11-14 01:41 UTC (permalink / raw)
To: pgvector/pgvector <noreply+pgvector-pgvector@github.com>
Based on the line number, it's likely fixed in 0.8.4 (#990).
^ permalink raw [nested|flat] 5+ messages in thread
* Re: [pgvector/pgvector] issue #1064: Corrupted index prevent table update
@ 2026-11-14 02:37 ` "juchiast (@juchiast)" <noreply+juchiast@github.com>
3 siblings, 0 replies; 5+ messages in thread
From: juchiast (@juchiast) @ 2026-11-14 02:37 UTC (permalink / raw)
To: pgvector/pgvector <noreply+pgvector-pgvector@github.com>
@ankane Thanks! We are using 0.8.0. We'll update the extension.
^ permalink raw [nested|flat] 5+ messages in thread
end of thread, other threads:[~2026-11-14 02:37 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-11-14 01:06 [pgvector/pgvector] issue #1064: Corrupted index prevent table update "juchiast (@juchiast)" <noreply+juchiast@github.com>
2026-11-14 01:11 ` "ankane (@ankane)" <noreply+ankane@github.com>
2026-11-14 01:41 ` "ankane (@ankane)" <noreply+ankane@github.com>
2026-11-14 01:41 ` "ankane (@ankane)" <noreply+ankane@github.com>
2026-11-14 02:37 ` "juchiast (@juchiast)" <noreply+juchiast@github.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox