Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-17 Thread Andreas Schmitz
On Monday 17 February 2003 19:56, Tom Lane wrote: Andreas Schmitz [EMAIL PROTECTED] writes: I think it is not the same. When I ran the vaccum when no other clients whe= re=20 connected to the database. The vacuum that reports the NOTICEs is not the one that created the problem. The

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-17 Thread Andreas Schmitz
The last lines of output were: NOTICE: Rel pg_class: Uninitialized page 3344 - fixing [...] NOTICE: Rel pg_class: Uninitialized page 3355 - fixing NOTICE: Rel pg_class: Uninitialized page 3356 - fixing batch/nachts.sh: line 3: 30855 Segmentation fault /usr/bin/php -q

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-17 Thread Tom Lane
Andreas Schmitz [EMAIL PROTECTED] writes: I think it is not the same. When I ran the vaccum when no other clients whe= re=20 connected to the database. The vacuum that reports the NOTICEs is not the one that created the problem. The scenario I was talking about requires concurrent clients

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-15 Thread Andreas Schmitz
On Friday 14 February 2003 17:55, Tom Lane wrote: Andreas Schmitz [EMAIL PROTECTED] writes: I have a problem with the vacuum full. every time I run the vacuum command I loose data from the parent tables. maybe also from the subtables (haven't checked yet). I tried it a few times up to now

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-15 Thread daniel alvarez
I have a problem with the vacuum full. every time I run the vacuum command I loose data from the parent tables. maybe also from the subtables (haven't checked yet). I tried it a few times up to now an I can reproduce the phenomena. That sounds ugly ... but are you sure you don't

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-15 Thread Tom Lane
Andreas Schmitz [EMAIL PROTECTED] writes: however, what kind of details do you need to qualify if it's a postgres problem or not ? Ultimately, we need a way to reproduce the problem for debugging. If it is a Postgres bug, it should be possible to reproduce it. regards,

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-15 Thread Tom Lane
daniel alvarez [EMAIL PROTECTED] writes: NOTICE: Rel pg_class: Uninitialized page 3344 - fixing NOTICE: Rel pg_class: Uninitialized page 3345 - fixing NOTICE: Rel pg_class: Uninitialized page 3346 - fixing NOTICE: Rel pg_class: Uninitialized page 3347 - fixing NOTICE: Rel pg_class:

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-14 Thread Tom Lane
Andreas Schmitz [EMAIL PROTECTED] writes: I have a problem with the vacuum full. every time I run the vacuum command I loose data from the parent tables. maybe also from the subtables (haven't checked yet). I tried it a few times up to now an I can reproduce the phenomena. That sounds ugly

[ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-14 Thread Andreas Schmitz
Hello *, I have a problem with the vacuum full. every time I run the vacuum command I loose data from the parent tables. maybe also from the subtables (haven't checked yet). I tried it a few times up to now an I can reproduce the phenomena. I am running postgresql 7.3.2 on solaris 8 (E450 4x