Re: Still a bug in the VACUUM ??? !!!

> 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
> /usr/local/httpd/htdocs/kunden/web41/html/wcopy/batch/vacuum.php
>
>
> Running VACUUM FULL ANALYZE another time there were no errors.

Hi,

I think it is not the same. When I ran the vaccum when no other clients where
connected to the database. I did the "update dpa_text set
titleidx=txt2txtidx(volltext);"  When I ran "vacuumdb --full --verbose
--analyze -d newsdb2 >>/tmp/vacuum.log 2>&1" Maybe the log will provide some
information. I noticed a few messages like this in the database log while
running the vacuum:

Feb 17 11:19:36 postgres2 postgres[1803]: [ID 553393 local0.info] [5] LOG:
pq_flush: send() failed: Broken pipe


regards

-andreas




--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de