Re: "LockRelease: locktable lookup failed, no lock"
От | Steve Wolfe |
---|---|
Тема | Re: "LockRelease: locktable lookup failed, no lock" |
Дата | |
Msg-id | 006201bf839c$00d466c0$85755ad1@iboats.com обсуждение исходный текст |
Ответ на | "LockRelease: locktable lookup failed, no lock" ("Steve Wolfe" <steve@iboats.com>) |
Список | pgsql-general |
Grr.... Although I'm no longer getting lock releases on this table, a daily vaccum analyze still shows: NOTICE: Rel reef: Uninitialized page 492 - fixing NOTICE: Rel reef: Uninitialized page 498 - fixing NOTICE: Rel reef: Uninitialized page 499 - fixing The database is a fledgling mail archive, when a message comes in, a program parses the message for the relevant information, inserts it into the table, and it's done. Since it's in very early development, there are only very occasional queries on it. Here's the schema that I used to create the table.... create sequence reef_sequence increment 2; create table reef( reef_index int4 default nextval('reef_sequence') primary key, subject varchar(256), author varchar(256), author_email varchar(256), message text, date date, time time, is_reply int ); Now I know that there are problems with that, like "is_reply" should be a bool, not an int. This is a very old project that I'm just starting up again... go easy on me. : ) steve
В списке pgsql-general по дате отправления: