圈子推荐
查看所有吧>>
活跃用户
    压测导致进程挂掉分析

    在数据库进行压测时候,导致数据库进程宕掉,问题如下所示:


    ======》》

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    2021-03-04 13:36:25.558 vastuser bank_of_a pool-173-48-26-77.bstnma.fios.verizon.net 281065141978064 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 6/2120.

    2021-03-04 13:36:25.558 vastuser bank_of_a pool-173-48-26-78.bstnma.fios.verizon.net 280873136309200 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 6/2120.

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    2021-03-04 13:36:25.559 vastuser bank_of_a pool-173-48-26-78.bstnma.fios.verizon.net 280985752454096 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 11/2115.

    2021-03-04 13:36:25.560 vastuser bank_of_a pool-173-48-26-78.bstnma.fios.verizon.net 280892522316752 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 5/2121.

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  sorry, too many clients already

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  could not fork new process for connection socket 17876 : Success

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  sorry, too many clients already

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  could not fork new process for connection socket 17876 : Success

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  sorry, too many clients already

    2021-03-04 13:36:25.562 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] WARNING:  could not fork new process for connection socket 17876 : Success

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    0 [BACKEND] FATAL:  no signal slot available for new thread creation

    2021-03-04 13:36:25.563 vastuser bank_of_a pool-173-48-26-77.bstnma.fios.verizon.net 280876942771152 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 8/2118.

    2021-03-04 13:36:25.565 vastuser bank_of_a pool-173-48-26-78.bstnma.fios.verizon.net 280876066948048 0 0 [BACKEND] FATAL:  Too many clients already, active/non-active: 4/2122.

    2021-03-04 13:36:25.566 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] PANIC:  no free slots in PMChildFlags array

    2021-03-04 13:36:25.566 [unknown] [unknown] localhost 281472151650320 0 0 [BACKEND] BACKTRACELOG:  tid[32180]'s backtrace:

    /home/vastbase/local/vastbase/bin/vastbase() [0xd20e38]

    /home/vastbase/local/vastbase/bin/vastbase(_Z9errfinishiz+0x300) [0xd18148]

    /home/vastbase/local/vastbase/bin/vastbase(_Z25AssignPostmasterChildSlotv+0xf0) [0x15c06d0]

    /home/vastbase/local/vastbase/bin/vastbase() [0x10f1978]

    /home/vastbase/local/vastbase/bin/vastbase(_Z14PostmasterMainiPPc+0x184c) [0x10f4634]

    /home/vastbase/local/vastbase/bin/vastbase(main+0x34c) [0x907ce4]

    /lib64/libc.so.6(__libc_start_main+0xe0) [0xffff57d93fe0]

    /home/vastbase/local/vastbase/bin/vastbase() [0x94689c]

    Use addr2line to get pretty function name and line




    ======》》


    这个是因为进程数有关,将max_connections调大到9090,再次测试,进程正常。

    • 分享到:
    排序方式:回复时间 共有1条评论

    黄港 发表于 03月16日 10:10 1 楼

    连接不够?

    | 回复