random FlushRelationBuffers() failed on Pg8.0.1 Win32

Поиск
Список
Период
Сортировка
От	Qingqing Zhou
Тема	random FlushRelationBuffers() failed on Pg8.0.1 Win32
Дата	18 марта 2005 г. 08:22:27
Msg-id	d12sqp$t57$1@news.hub.org обсуждение исходный текст
Список	pgsql-bugs
Дерево обсуждения
PG version =
"PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3
(mingw special 20030504-1)"

Attached is the regression result of my test on Pg8.0.1 win32. The problem
is quite random. On the second round, it just disappeared.


------------------------ first round --------------------------

*** ./expected/strings.out Sun Mar 14 12:25:18 2004
--- ./results/strings.out Mon Mar 14 09:51:59 2005
***************
*** 640,658 ****
--- 640,668 ----
  (4 rows)

  DROP TABLE toasttest;
+ ERROR:  FlushRelationBuffers("pg_toast_18740", 0): block 1 is referenced
(private 0, global 1)
  --
  -- test substr with toasted bytea values
  --
  CREATE TABLE toasttest(f1 bytea);
+ ERROR:  relation "toasttest" already exists
  insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
+ ERROR:  column "f1" is of type text but expression is of type bytea
+ HINT:  You will need to rewrite or cast the expression.
  insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
+ ERROR:  column "f1" is of type text but expression is of type bytea
+ HINT:  You will need to rewrite or cast the expression.
  --
  -- Ensure that some values are uncompressed, to test the faster substring
  -- operation used in that case
  --
  alter table toasttest alter column f1 set storage external;
  insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
+ ERROR:  column "f1" is of type text but expression is of type bytea
+ HINT:  You will need to rewrite or cast the expression.
  insert into toasttest values(decode(repeat('1234567890',10000),'escape'));
+ ERROR:  column "f1" is of type text but expression is of type bytea
+ HINT:  You will need to rewrite or cast the expression.
  -- If the starting position is zero or less, then return from the start of
the string
  -- adjusting the length to be consistent with the "negative start" per
SQL92.
  SELECT substr(f1, -1, 5) from toasttest;
***************
*** 690,695 ****
--- 700,706 ----
  (4 rows)

  DROP TABLE toasttest;
+ ERROR:  FlushRelationBuffers("pg_toast_18740", 0): block 1 is referenced
(private 0, global 1)
  --
  -- test length
  --

======================================================================

*** ./expected/type_sanity.out Thu Aug  5 05:34:34 2004
--- ./results/type_sanity.out Mon Mar 14 09:52:22 2005
***************
*** 258,262 ****
       (p1.attstorage != p2.typstorage AND p1.attstorage != 'p'));
   attrelid | attname | oid | typname
  ----------+---------+-----+---------
! (0 rows)

--- 258,263 ----
       (p1.attstorage != p2.typstorage AND p1.attstorage != 'p'));
   attrelid | attname | oid | typname
  ----------+---------+-----+---------
!     18740 | f1      |  25 | text
! (1 row)


======================================================================

*** ./expected/misc.out Fri Mar  4 16:06:11 2005
--- ./results/misc.out Mon Mar 14 09:54:07 2005
***************
*** 658,667 ****
   timestamptz_tbl
   timetz_tbl
   tinterval_tbl
   toyemp
   varchar_tbl
   xacttest
! (97 rows)

  SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
   name
--- 658,668 ----
   timestamptz_tbl
   timetz_tbl
   tinterval_tbl
+  toasttest
   toyemp
   varchar_tbl
   xacttest
! (98 rows)

  SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
   name

======================================================================

*** ./expected/portals_p2.out Mon Jul 16 13:07:00 2001
--- ./results/portals_p2.out Mon Mar 14 09:54:10 2005
***************
*** 4,122 ****
  BEGIN;
  DECLARE foo13 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 50;
  DECLARE foo14 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 51;
  DECLARE foo15 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 52;
  DECLARE foo16 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 53;
  DECLARE foo17 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 54;
  DECLARE foo18 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 55;
  DECLARE foo19 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 56;
  DECLARE foo20 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 57;
  DECLARE foo21 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 58;
  DECLARE foo22 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 59;
  DECLARE foo23 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 60;
  DECLARE foo24 CURSOR FOR
     SELECT * FROM onek2 WHERE unique1 = 50;
  DECLARE foo25 CURSOR FOR
     SELECT * FROM onek2 WHERE unique1 = 60;
  FETCH all in foo13;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       50 |     253 |   0 |    2 |   0 |     10 |       0 |       50 |
50 |        50 |       50 |   0 |    1 | YBAAAA   | TJAAAA   | HHHHxx
! (1 row)
!
  FETCH all in foo14;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       51 |      76 |   1 |    3 |   1 |     11 |       1 |       51 |
51 |        51 |       51 |   2 |    3 | ZBAAAA   | YCAAAA   | AAAAxx
! (1 row)
!
  FETCH all in foo15;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       52 |     985 |   0 |    0 |   2 |     12 |       2 |       52 |
52 |        52 |       52 |   4 |    5 | ACAAAA   | XLBAAA   | HHHHxx
! (1 row)
!
  FETCH all in foo16;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       53 |     196 |   1 |    1 |   3 |     13 |       3 |       53 |
53 |        53 |       53 |   6 |    7 | BCAAAA   | OHAAAA   | AAAAxx
! (1 row)
!
  FETCH all in foo17;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       54 |     356 |   0 |    2 |   4 |     14 |       4 |       54 |
54 |        54 |       54 |   8 |    9 | CCAAAA   | SNAAAA   | AAAAxx
! (1 row)
!
  FETCH all in foo18;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       55 |     627 |   1 |    3 |   5 |     15 |       5 |       55 |
55 |        55 |       55 |  10 |   11 | DCAAAA   | DYAAAA   | VVVVxx
! (1 row)
!
  FETCH all in foo19;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       56 |      54 |   0 |    0 |   6 |     16 |       6 |       56 |
56 |        56 |       56 |  12 |   13 | ECAAAA   | CCAAAA   | OOOOxx
! (1 row)
!
  FETCH all in foo20;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       57 |     942 |   1 |    1 |   7 |     17 |       7 |       57 |
57 |        57 |       57 |  14 |   15 | FCAAAA   | GKBAAA   | OOOOxx
! (1 row)
!
  FETCH all in foo21;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       58 |     114 |   0 |    2 |   8 |     18 |       8 |       58 |
58 |        58 |       58 |  16 |   17 | GCAAAA   | KEAAAA   | OOOOxx
! (1 row)
!
  FETCH all in foo22;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       59 |     593 |   1 |    3 |   9 |     19 |       9 |       59 |
59 |        59 |       59 |  18 |   19 | HCAAAA   | VWAAAA   | HHHHxx
! (1 row)
!
  FETCH all in foo23;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       60 |     483 |   0 |    0 |   0 |      0 |       0 |       60 |
60 |        60 |       60 |   0 |    1 | ICAAAA   | PSAAAA   | VVVVxx
! (1 row)
!
  FETCH all in foo24;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       50 |     253 |   0 |    2 |   0 |     10 |       0 |       50 |
50 |        50 |       50 |   0 |    1 | YBAAAA   | TJAAAA   | HHHHxx
! (1 row)
!
  FETCH all in foo25;
!  unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
!       60 |     483 |   0 |    0 |   0 |      0 |       0 |       60 |
60 |        60 |       60 |   0 |    1 | ICAAAA   | PSAAAA   | VVVVxx
! (1 row)
!
  CLOSE foo13;
  CLOSE foo14;
  CLOSE foo15;
  CLOSE foo16;
  CLOSE foo17;
  CLOSE foo18;
  CLOSE foo19;
  CLOSE foo20;
  CLOSE foo21;
  CLOSE foo22;
  CLOSE foo23;
  CLOSE foo24;
  CLOSE foo25;
  END;
--- 4,96 ----
  BEGIN;
  DECLARE foo13 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 50;
+ ERROR:  could not open relation 1663/17230/16396: Invalid argument
  DECLARE foo14 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 51;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo15 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 52;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo16 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 53;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo17 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 54;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo18 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 55;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo19 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 56;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo20 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 57;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo21 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 58;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo22 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 59;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo23 CURSOR FOR
     SELECT * FROM onek WHERE unique1 = 60;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo24 CURSOR FOR
     SELECT * FROM onek2 WHERE unique1 = 50;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  DECLARE foo25 CURSOR FOR
     SELECT * FROM onek2 WHERE unique1 = 60;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo13;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo14;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo15;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo16;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo17;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo18;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo19;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo20;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo21;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo22;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo23;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo24;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  FETCH all in foo25;
! ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo13;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo14;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo15;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo16;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo17;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo18;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo19;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo20;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo21;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo22;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo23;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo24;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  CLOSE foo25;
+ ERROR:  current transaction is aborted, commands ignored until end of
transaction block
  END;

======================================================================

------------------------ second round --------------------------
All 96 tests passed.
В списке pgsql-bugs по дате отправления:
Предыдущее

От: "John Smith"
Дата: 18 марта 2005 г., 08:20:05
Сообщение: BUG #1547: CREATE TYPE AS error
Следующее

От: "Spencer Riddering"
Дата: 18 марта 2005 г., 08:22:38
Сообщение: BUG #1550: LOCK TABLE in plpgsql function doesn't work.
Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

random FlushRelationBuffers() failed on Pg8.0.1 Win32

Предыдущее

Следующее
