> I poked around in the dump for awhile. I still can't reproduce the
> failure from a standing start. It looks to me like Tatsuo's database
> was possibly produced from separate schema and data load steps, followed
> by some update operations. It would be nice to have a full script for
> reproducing the state of the database.
Sorry, I don't have full SQL logs.
Here are DML used for the database:
INSERT INTO msginfo(file_size, file_mtime, msg_date, flags, hdr_from,
hdr_to, hdr_cc, hdr_newsgroups, hdr_subject,
hdr_msgid, hdr_inreplyto, hdr_references, body_text,
body_index)
VALUES(%u, E'%s', E'%s', %u, E'%s', E'%s', E'%s', E'%s', E'%s', E'%s',
E'%s', E'%s', E'%s', to_tsvector(E'%s'))
DELETE FROM msginfo WHERE msg_sid = %lu
DELETE FROM msginfo WHERE msg_sid IN
(SELECT msg_sid FROM msginfo EXCEPT SELECT msg_sid FROM msg_folderinfo)
So no exotic things appear...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
