Hi,
I have got some PL/pgsql script which are working on PostgreSQL 9.1.
But on PGXC 1.2.1, I have got the error message : consistency check on
SPI tuple count failed
I read the oldest post on mail list about this error but in my case,
T_TABLE_EXAMPLE is empty so could we talk about inconstencies ?
I am working on replicated tables.
DO $$
DECLARE
CPA_ID BIGINT;
[...]
BEGIN
SELECT "CPA_ID" INTO CPA_ID FROM "T_TABLE_EXAMPLE" WHERE
"CPA_FILENAME" = 'example_string' AND "CPA_DELETE" IS NULL;
IF CPA_ID IS NULL
THEN
INSERT INTO "T_TABLE" (version, "CPA_FILENAME") VALUES (0,
'example_string') RETURNING "CPA_ID" INTO CPA_ID;
END IF;
[...]
END$$;
The entire error is :
ERROR: consistency check on SPI tuple count failed
CONTEXT: SQL statement "INSERT INTO "T_TABLE" (version, "CPA_FILENAME")
VALUES (0, 'example_string') RETURNING "CPA_ID""
PL/pgSQL function inline_code_block line 20 at SQL statement
Line 20 is the empty line just under SELECT query.
And when I execute the SQL statement "INSERT INTO "T_TABLE" (version,
"CPA_FILENAME") VALUES (0, 'example_string') RETURNING "CPA_ID""
directly, it works. I can read T_TABLE_EXAMPLE and my data are on both
datanodes.
Thibault
|
