Re: postgres locks... [more information]

Ok, I think I know what happened, kind of..

One of my users' databases was currupt. I actually had to delete the
entire base/<dbname> folder. Then I went in and drop/created the DB
again and it seems to work fine.

Is there any was to know how this happened? I have a .tar of the currupt
DB if someone is interested...

I would hope that 7.1 fixes this issue, any thoughts?

Thanks,
Jeff Davis

Jeff Davis wrote:

> I think this is a bug, but I don't have really enough info to go on
> for a report. I was running postgres on my server and everything
> seemed OK. Eventually I figured out that some of my websites weren't
> loading and connected it to postgres.
>
> Basically, psql would sit there trying to connect, meanwhile all the
> attempted connections wouldn't die. I had to "kill -9" all the
> postgres/postmaster processes. Then I ran pg_ctl start, and it seemed
> OK. However, same problem. So, I killed again, then ran ipcclean
> (there were shm errors), the started and it worked. I had to delete a
> socket file in /tmp also in order to get it going again.
>
> During the time, I appearently lost several unimportant tables. I am
> running 7.0.3/debian-woody. Is this a known problem? I really need to
> have a reliable version of postgres running.
>
> Thanks for any advice,
> Jeff Davis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>