On dom, gen 13, 2002 at 11:30:08 -0500, Tom Lane wrote:
> Hm, you never did a VACUUM at all? Don't see how that can be ---
> removal of CLOG segments is triggered by VACUUM.
uhm... i was sure i didn't do vacuum... but... well... so I made other
tests.
>
> Please let me know if you can still see
On ven, gen 11, 2002 at 03:16:12 -0500, Tom Lane wrote:
> Yes, I would like a copy of your script.
i will package script and 'instructions' soon.
i've got also two snapshots of db after the crash (tar files of postgres
directory)
>
> I just found and fixed a problem that could lead to this kind
On ven, gen 11, 2002 at 01:56:12 -0500, Tom Lane wrote:
> Yup, it looks like a bug to me. Apparently a CLOG segment has been
> recycled too soon. We just found a bug of that ilk in sequence
> processing, but VACUUM doesn't touch sequences, so apparently you have
> a different bug. Please submit
andrea gelmini <[EMAIL PROTECTED]> writes:
> you was right, and there's no need of vacuum db to crash the postmaster...
> doing a fresh installation, a fresh initdb, starting my script (and a
> second bash script that does nothing more than a simple insert) after about
> 1 milion transactions i ca
andrea gelmini <[EMAIL PROTECTED]> writes:
> On ven, gen 11, 2002 at 01:56:12 -0500, Tom Lane wrote:
>> Yup, it looks like a bug to me. Apparently a CLOG segment has been
>> recycled too soon. We just found a bug of that ilk in sequence
>> processing, but VACUUM doesn't touch sequences, so appar
andrea gelmini <[EMAIL PROTECTED]> writes:
> vacuumdb -a -v -f -z
> NOTICE: Analyzing author
> FATAL 2: open of /home/postgres/db/pg_clog/ failed: No such file or directo
> ry
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> be
well, i will be a little verbose, but i am afraid this could be a big bug
in postgresql, so...
i've made a script in python that, by psycopg module, put freecddb archive
in a relational db. so, it does a few select and a lot of insert for each
file of freecddb (something like 500.000 files).
now,
