tuple concurrently updated
My application receives the folllowing error sometimes.
Any idea how to fix ?
Andrus.
7/XX000:Error while executing the query;ERROR: tuple concurrently updated
CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
line 2 at execute statement
SELECT drop_table('templsabi');CREATE TABLE templsabi AS
select
toode,
osak as sihtyksus,
partii,
laosumma,
1 as lj, 0 as st, 0 as vm,
0 as kaubasumma,
kogus,
0 as kogpak,
CAST('' AS CHAR(10)) as yksus,
CAST('' AS CHAR(1)) as doktyyp
from HETKESEI
where true
AND osak LIKE 'TARTU%' ESCAPE '!'
AND toode='DIS123103'
;SELECT * FROM templsabi
drop_table is defined as
CREATE OR REPLACE FUNCTION drop_table(TEXT)
RETURNS VOID STRICT LANGUAGE plpgsql AS $$
BEGIN
EXECUTE 'DROP TABLE ' || $1;
EXCEPTION WHEN UNDEFINED_TABLE THEN
RETURN;
END;
$$;
"Andrus" <kobruleht2@hot.ee> writes:
My application receives the folllowing error sometimes.
7/XX000:Error while executing the query;ERROR: tuple concurrently updated
CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
line 2 at execute statement
That's a bit interesting ... what PG version is this exactly? What else
might be touching that table at the same time? Do you have autovacuum
enabled?
regards, tom lane
That's a bit interesting ... what PG version is this exactly?
"PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
What else might be touching that table at the same time?
Maybe some other client executes same or other command at same time in same
database.
templsabi table is created, dropped and updated frequently by a number of
clients concurrently.
Do you have autovacuum enabled?
Yes.
Andrus.