I'm getting futher in focussing on the problem. I can reproduce these
messages I get when vacuuming a database.
And by reproduce I mean on a different system a clean installed database It
takes me less then a minute....
NOTICE: Rel pg_class: TID 294/3: InsertTransactionInProgress 20065 - can't
shrink relation
NOTICE: Rel pg_class: TID 294/4: InsertTransactionInProgress 20065 - can't
shrink relation
NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (1615) IS NOT
THE SAME AS HEAP' (1587)
NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (1615) IS NOT THE
SAME AS HEAP' (1587)
VACUUM
The message below is also one of the messages I get when restarting the
database after a crash.
Starting postgresql service: IpcMemoryCreate: shmget failed (Identifier
removed) key=5432010, size=120, permission=700
IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010, size=120,
permission=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment
I get these messages by doing many revokes (> 1000)
psql -e template1 < /tmp/test-revokes
where test-revokes looks like:
\connect foodb
begin;
alter user hr270 nocreateuser;
REVOKE all on foo from pn407;
REVOKE all on bar from pn407;
another 1000 of revokes
.
.
REVOKE all on foo2 from pn407;
end;
And while doing that I perform a vacuum.
vacuumdb foodb
Please tell me I'm doing something I really shouldn't be doing.
Cheers Wim.
