Administrace komentářů

Dobry den vespolek!

Objevil se mi docela zavazny problem s PostgreSQL 8.1 bezici na CentOS 5.4 (postgresql.x86_64, 8.1.18-2.el5_4.1). Pri trivilanim INSERTu:

INSERT INTO table1 SELECT a,b,c FROM table2 WHERE table2.id=123

mi Postgres zkolabuje (bez ohledu na to, jaky radek se snazim zkopirovat) - vypise chybu o ukonceni konexe - a to tak, ze vzdy

V logach najdu toto:

/var/log/messages:
Feb 9 07:40:05 host kernel: postmaster[14726]: segfault at ffffffffd498de00 rip 0000003fdea7be82 rsp 00007fffce996c68 error 4

/var/lib/pgsql/data/pg_log/postgresql-Tue.log:
LOG: server process (PID 14726) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.

Tento INSERT probiha docela casto a doposud s nim nebyl problem. Probelm se objevil jiz vcera a po reindexaci zase vymizel (ale to mohla byt shoda nahod). Nyni nepomaha nic (reindex, restart postgresu...)

Mate nekdo nejaky smysluplny napad, co s tim? Snad krome toho reportovat bug a doufat, ze ho nekdo-nekdy opravi?...

Diky moc a hezky den!

kokoska.rokoska