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