More details on Database corruption

From: George Kousi <g(dot)kousi(at)albourne(dot)com>
To: "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org>
Subject: More details on Database corruption
Date: 1998-08-13 15:54:16
Message-ID: 35D30C27.59CE912E@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

I managed to recreate a simple example that's crashing postgres. I am
running on a DEC Alpha with Digital Unix Version 4.0d and Postgres
3.2. I tried this example several times, on several databases and it
crashes every time. We also re-built Postgres and still did not work.
Here's the example. Can anybody please help?

Thank you...
George K.
/***** INPUT FILE: hist.sql *******/

drop table tasks;
CREATE TABLE tasks (
task INT4 NOT NULL,
job INT4 NOT NULL,
Version1 CHAR(6) DEFAULT '',
Version2 CHAR(6) DEFAULT '',
Version3 CHAR(6) DEFAULT '',
Version4 CHAR(6) DEFAULT '',
Version5 CHAR(6) DEFAULT ''
);

INSERT INTO tasks (task, job) VALUES (1, 1);
select * from tasks;
update tasks set version1='1',version2='2', version3='3', version4='4',
version5='5' where task=1;
select * from tasks;

/****** OUTPUT FROM pgsql **********/
test=> \i hist.sql
drop table tasks;
DROP
CREATE TABLE tasks (
task INT4 NOT NULL,
job INT4 NOT NULL,
Version1 CHAR(6) DEFAULT '',
Version2 CHAR(6) DEFAULT '',
Version3 CHAR(6) DEFAULT '',
Version4 CHAR(6) DEFAULT '',
Version5 CHAR(6) DEFAULT ''
);
CREATE

INSERT INTO tasks (task, job) VALUES (1, 1);
INSERT 4410388 1
select * from tasks;
task|job|version1|version2|version3|version4|version5
----+---+--------+--------+--------+--------+--------
1| 1| | | | |
(1 row)

update tasks set version1='1',version2='2', version3='3', version4='4',
version5='5' where task=1;
UPDATE 1
select * from tasks;
FATAL: unrecognized data from the backend. It probably dumped core.
FATAL: unrecognized data from the backend. It probably dumped core.

EOF
test=>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Kousi 1998-08-13 15:59:25 More Details (cont.)
Previous Message Glenn Sullivan 1998-08-13 14:42:41 Re: [GENERAL] Pricing

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1998-08-13 16:11:48 Re: [HACKERS] tuple return from function
Previous Message Dr. Michael Meskes 1998-08-13 15:42:05 Re: [HACKERS] Latest ecpg patch?