代码之家  ›  专栏  ›  技术社区  ›  Kev

PostgreSQL 9.0.1+ActivePerl 1007+Apache 2.2.17上的间歇Pg.dll崩溃

  •  0
  • Kev  · 技术社区  · 14 年前

    我会升级DBD::Pg,但是我找不到比我们使用的(2.14.1)更新的PPD。也就是说,此后的变化似乎与我们的使用没有特别的关系。

    Windows事件查看器显示:

    Event Type: Error
    Event Source:   Application Error
    Event Category: (100)
    Event ID:   1000
    Date:       2010-11-01
    Time:       9:55:28 AM
    User:       N/A
    Computer:   myserver
    Description:
    Faulting application httpd.exe, version 2.2.17.0, faulting module Pg.dll, version 0.0.0.0, fault address 0x0000e8a5.
    

    [Mon Nov 01 09:55:32 2010] [notice] Parent: child process exited with status 3221225477 -- Restarting.
    

    不是很有用,所以我查看了PostgreSQL日志(Pg.dll是 DBD::Pg

    2010-11-01 09:55:32 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:32 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    2010-11-01 09:55:33 EDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
    
    
    2010-11-01 09:55:33 EDT LOG:  unexpected EOF on client connection
    

    但除此之外,我不知道原因,除了可能的高倍(但不是那么高——我们只有很少的用户)服务器负载。

    你知道是什么引起的吗?

    1 回复  |  直到 14 年前
        1
  •  0
  •   Kev    14 年前

    间歇性的网络问题可能会导致这种情况。我试着从运行PostgreSQL的同一服务器上的VirtualBox上运行的Turnkey使用psql登录到PostgreSQL,这有时会导致PostgreSQL线程占用更多的CPU,最后不允许登录。在Turnkey上安装PostgreSQL使这种情况停止了,因此有可能是Windows级别的一般网络问题导致PostgreSQL和Pg.dll阻塞,然后导致Apache崩溃,因为DBD::Pg是通过mod_perl持久加载的。