bugs or no in PostgreSQL 7.1 ?
От | Andrey Mikuloff |
---|---|
Тема | bugs or no in PostgreSQL 7.1 ? |
Дата | |
Msg-id | 9d55gb$30od$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: bugs or no in PostgreSQL 7.1 ?
|
Список | pgsql-general |
After compiling and porting database from 7.0.3 to 7.1 perfomance was cool, but later, when many clients connected to our server and process transactions (creating documents e.t.c.) PostgreSQL 7.1 say's "ERROR: Cannot insert a duplicate key into unique index pay_docs_list_pkey", but all indexes and sequences was OK, and after vacuum, reindexing base and increasing last number of sequence (defined as "serial") errors was repeated. And also, time to time, Postgres die with logs: Server process (pid ...) exited with status 139 at ... Terminating any active server processes... The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. This error usualy after vacuum small tables on the fly And in final PostgreSQL 7.1 kill our databse, i.e. can't restart on they database with error - can't restore pg_xlog records... More: what is error on start PostgreSQL 7.1: [: 11800: unary operator expected it's sometime displaing, but not always ? Postgresql was compiled with params --enable-locale --enable-recode --with-maxbackends=1024, data was in koi8 with recode by charset.conf. Also php4.0.4pl1 What occurs??????????? May be some bugs with die or no answer of backend becouse used 'recode' ? I think that 'recode' more quickly than 'multibyte', or no ? Sorry my bad english, can answer in russian or english Andrey Mikuloff
В списке pgsql-general по дате отправления: