Problem with records that disappear.
| От | Condor |
|---|---|
| Тема | Problem with records that disappear. |
| Дата | |
| Msg-id | 6ff4bdd3aff41ad7f706bc5e2eba9f03@stz-bg.com обсуждение |
| Ответы |
Re: Problem with records that disappear.
Re: Problem with records that disappear. Re: Problem with records that disappear. |
| Список | pgsql-general |
Hello,
from some time I have a very strange problem with my postgresql 9.2.2
64bit.
I make a few changes with an plp function:
BEGIN
UPDATE table SET X = X where id = aid;
UPDATE table_2 SET Y=Y where id = aid;
IF aid > 0 THEN
SELECT INTO ids id FROM table_3 WHERE x = x;
IF aid IS NULL THEN
INSERT INTO table_3 (id) VALUES (x);
ELSE
UPDATE table_3 SET id = id + 1 WHERE x = X;
END IF;
END IF;
RETURN 200;
END;
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas for
the moment
what is the problem in my postgresql or in my php code. I'm sure there
was a recording was made.
I run in middle night vacuum, reindex on tables and vacuum analyze;
I check my postgresql logs, but no any errors. I check the php logs,
but no errors.
My vacuum also did not log any error messages. This problem happened
one or two times per month
and I can't track him. Is not happened very often. My question is: Is
there any chance this function
to stay opened or some thing like that and on the night when vacuum is
started to rollback changes ?
Also any other suggestions are welcome.
Cheers,
Hristo C.
В списке pgsql-general по дате отправления: