| > A vacuum without the analyze gives the error
| > ERROR: No one parent tuple was found
|
| I think you might be getting bit by the same bug that was biting Alfred
| Perlstein a month or so back. Try 7.0.3 and see if it's any better...
| if not, let me know and we'll probe deeper.
|
| (Marc
| | (Marc hasn't officially announced 7.0.3 yet, but to the best of my
| | knowledge the release-candidate tarballs currently available from our
| | FTP server will be it.)
|
| I've upgraded to 7.0.3, now I get...
|
| c2net=> vacuum verbose analyze some_table;
| NOTICE: --Relation some_table--
| | I've upgraded to 7.0.3, now I get...
| |
| | c2net=> vacuum verbose analyze some_table;
| | NOTICE: --Relation some_table--
| |
| | It's been sitting like that for about half an hour now. There's only
| | about 3000 records in that table.
|
| As a side note, when I ^C the vacuum I get..
| | The very next vacuum I do produces the exact same response. The next one
| | after that though continues..
|
| And as another side note :) ...
|
| vacuum some_table (without the analyze) completes quite happily.
Grr! There must be a law against replying to so many of your own messages...
Can someone tell me what a postmaster process exiting with status = 26
means? FWIW, I'm doing a COPY table FROM stdin with about 14 million
records to trigger this.
Thanks,
-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictate
| > Can someone tell me what a postmaster process exiting with status = 26
| > means? FWIW, I'm doing a COPY table FROM stdin with about 14 million
| > records to trigger this.
|
| That means it got a signal 26. Since you didn't mention what platform
| you are on, I'm not going to guess what s
| > Signal 26 on FreeBSD is SIGVTARLM.
|
| We don't ever set a virtual timer alarm, either. Is it possible that
| you are running the postmaster with a ulimit-style limit on total
| process runtime?
No, I've tested this and postmaster is being started in an unlimited
enviornment.
The code
