Hi,

I was running a manual vaccum through pgadmin 1.4.1 on a database and my connection to the database was lost during it. I reconnected to the database, went to Tools->Server Status->Log File and there is an entry that says:

"This application has requested the Runtime to terminate in an unusual way. Please contact the application's support team for more information".

I am running XP Pro SP2. Database is 8.1.1 and is not located on the same machine.

I also have autovaccum enabled.

Would be happy to give more information if I can.

Mike

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

I just tried to re-vacuum the database by using the local copy of pgadmin on the database machine. When it got to the same table and began working it stopped again. This time an error message was displayed instead of the connection being closed. The error:

"failed to re-find parent key in "idx_volume_consultant"

Should I just recreate the index and try to vacuum (full) again? I want to assume it got corrupted during the original vacuum attempt.

I have been starting the vacuum from the database name level in pgadmin.

Mike
On Fri, Dec 30, 2005 at 10:38:31AM -0600, Mike G. wrote:
> Hi,
>
> I was running a manual vaccum through pgadmin 1.4.1 on a database and my connection to the database was lost during it. I reconnected to the database, went to Tools->Server Status->Log File and there is an entry that says:
>
> "This application has requested the Runtime to terminate in an unusual way. Please contact the application's support team for more information".
>
> I am running XP Pro SP2. Database is 8.1.1 and is not located on the same machine.
>
> I also have autovaccum enabled.
>
> Would be happy to give more information if I can.
>
> Mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Mike G. wrote:
> I just tried to re-vacuum the database by using the local copy of pgadmin on the database machine. When it got to the same table and began working it stopped again. This time an error message was displayed instead of the connection being closed. The error:
>
> "failed to re-find parent key in "idx_volume_consultant"

Please post on pgsql-bugs for proper support.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Le Vendredi 30 Décembre 2005 16:47, Andreas Pflug a écrit*:
unsubscribe-unsubscribe-unsubscribe-unsubscribe
unsubscribe-unsubscribe-unsubscribe-unsubscribe
unsubscribe-unsubscribe-unsubscribe-unsubscribe

> Mike G. wrote:
> > I just tried to re-vacuum the database by using the local copy of pgadmin
> > on the database machine. When it got to the same table and began working
> > it stopped again. This time an error message was displayed instead of
> > the connection being closed. The error:
> >
> > "failed to re-find parent key in "idx_volume_consultant"
>
> Please post on pgsql-bugs for proper support.
>
> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Serge FAUCILHON
site Pôle de Guyane
Centre de Ressources Informatiques Universitaires de Guyane : Chef de Projet


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

unsubscribe-unsubscribe-unsubscribe-unsubscribe
unsubscribe-unsubscribe-unsubscribe-unsubscribe
unsubscribe-unsubscribe-unsubscribe-unsubscribe

Le Vendredi 30 Décembre 2005 14:05, Mike G. a écrit*:
> I just tried to re-vacuum the database by using the local copy of pgadmin
> on the database machine. When it got to the same table and began working
> it stopped again. This time an error message was displayed instead of the
> connection being closed. The error:
>
> "failed to re-find parent key in "idx_volume_consultant"
>
> Should I just recreate the index and try to vacuum (full) again? I want to
> assume it got corrupted during the original vacuum attempt.
>
> I have been starting the vacuum from the database name level in pgadmin.
>
> Mike
>
> On Fri, Dec 30, 2005 at 10:38:31AM -0600, Mike G. wrote:
> > Hi,
> >
> > I was running a manual vaccum through pgadmin 1.4.1 on a database and my
> > connection to the database was lost during it. I reconnected to the
> > database, went to Tools->Server Status->Log File and there is an entry
> > that says:
> >
> > "This application has requested the Runtime to terminate in an unusual
> > way. Please contact the application's support team for more
> > information".
> >
> > I am running XP Pro SP2. Database is 8.1.1 and is not located on the
> > same machine.
> >
> > I also have autovaccum enabled.
> >
> > Would be happy to give more information if I can.
> >
> > Mike
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Serge FAUCILHON
site Pôle de Guyane
Centre de Ressources Informatiques Universitaires de Guyane : Chef de Projet


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster