Index problem...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings...

I'm getting an error.  The error says...

places=# REINDEX INDEX maps_map_id_seq;
ERROR:  "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR:  missing chunk number 0 for toast value 131343627

I have tried reindexing the index, the table, and the database. I continue to get this error. What can I do to recover from this.

Carol Walter

PS Let me say that I know this is my fault. This index is very bloated. Yesterday, I tried to vacuum. I got errors because max_fsm_pages what set at a number that was too small.



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux