pgsql seems to get stuck.
Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    Jul 2008
    Posts
    6

    Default pgsql seems to get stuck.

    Hi,

    It's been a few days I'm experiencing troubles with hem & pgsql. All worked fine before, then now, suddenly hem cannot access the db, if I exit hem and restart it it tells about database connection timeout. I am unable to connect through pgsql console (it's stuck trying to connect indefinetly) and pgadmin does the same when try to connect to db. I tried to stop the service, it seems to be done instantly, but if I try to start the service, it is taking forever and never starts it. The only solution I found is to shutdown my computer and restart, then all works fine... for a short while before getting stuck again.

    Could it be related to database size? (6 million hands)?

    I tried upgrade hem to version 1.06.02 and pgsql to 8.3.3 but it's exactly the same problem.

    I have searched online but found nothing related to my problem, if anyone could help, that'd be great.

    Thanks,
    David.

  2. #2
    [Former] HM Support fabio's Avatar
    Join Date
    Jul 2008
    Posts
    2,067

    Default

    Its most likely a problem with your antivirus

  3. #3
    Junior Member
    Join Date
    Jul 2008
    Posts
    6

    Default

    I'm using bitdefender 2009, Is there a known problem with it? Also, it has been working fine for a while, but started to stuck regularly 3 days ago.

    I noticed something interesting when it's stuck: in the task manager, there's a postgres.exe process with 80Kb memory usage only (IO Ready/write are 0), and that process is impossible to kill (Access denied), even process explorer is unable to kill it but shows strange infos about it :
    File \Device\Afd\Endpoint
    File \Device\NamedPipe\Win32Pipes.00000730.00000002
    File \Device\NamedPipe\Win32Pipes.00000730.00000002
    File \Device\Afd\Endpoint
    File \Program Files\PostgreSQL\8.3\data
    Process <Non-existent Process>(1840)
    ...

    On top of that Windows has no Description or Name for the process and also, Image file for the process doesn't exist. (all other postgres.exe instances are named PostgreSQL Server + they have image file c:\Program Files\PostgreSQL\8.3\bin.postgres.exe" and they are killable). Others are also shown to have a "non existent process" as parent so I guess that is ok. Process has only one thread, and when I try to terminate it I get a message "Unable to access Thread"

    Seems the process is somewhat messed up, and it's related to named pipe. I searched on many postgres forums, but I didn't find anything related.

    Well I know this is not a postgre forum :-) but I never used postgre for anything else than hem...

  4. #4
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,889

    Default

    Can you try the following: http://208.109.95.123/faq/?f=153

    Also go to C:\Program Files\PostgreSQL\8.2\data and delete the postmaster.pid file if theres one there
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  5. #5
    Junior Member
    Join Date
    Jul 2008
    Posts
    6

    Default

    Hi,

    I did try, but it didn't help... same problem (except now postgres.exe processes belongs to "SYSTEM"). So I uninstalled my antivirus... and no more problems....

    Any idea if there something I can do to have both antivirus and database on my computer? If not, I guess I'll get another box for the DB

    David.

  6. #6
    [Former] HM Support fabio's Avatar
    Join Date
    Jul 2008
    Posts
    2,067

    Default

    I never used Bitdefender, but maybe you can add postgres to a trusted zone or something

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •