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=>
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 |
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? |