Pular para o conteúdo

Fóruns Banco de dados Oracle Como solucionar problemas de Heartbeat? (Oracle RAC) Como solucionar problemas de Heartbeat? (Oracle RAC)

#95112
antonioDBA
Participante

    Vieri, inicialmente gostaria de lhe agradecer pela atenção e ajuda!

    • Em relação a sua posição sobre o problema: Na verdade o que me deixava intrigado é que todos os logs que você mencionou (Log do S.O, /var/messages, Log da instância Alert, Log do ASM, Log do Cluster) eu já havia analisado e os mesmos se encontravam sem logs de falha ou erros de banco. Como mencionei no post inicial, apenas o log do OCSSD.log que indicava um warning de Heartbeat.
    • Entretanto esta semana, começou a ser gerado um log no messages com o seguinte erro:

    Jul 19 08:09:01 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052452 should have started at 564052093
    Jul 19 08:09:01 orarac1 iscsid: connect to 192.168.131.102:3260 failed (No route to host) * IP DA STORAGE ASM
    Jul 19 08:09:01 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request took too long to execute: 400 ms (> 10 ms) (GSource: 0x39598c60)
    Jul 19 08:09:01 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request was delayed 3590 ms (> 500 ms) before being called (GSource: 0x396760b0)
    Jul 19 08:09:01 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052492 should have started at 564052133
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request took too long to execute: 400 ms (> 10 ms) (GSource: 0x396760b0)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request was delayed 3580 ms (> 500 ms) before being called (GSource: 0x39676170)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052532 should have started at 564052174
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request took too long to execute: 400 ms (> 10 ms) (GSource: 0x39676170)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request was delayed 3580 ms (> 500 ms) before being called (GSource: 0x39676230)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052572 should have started at 564052214
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request took too long to execute: 400 ms (> 10 ms) (GSource: 0x39676230)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request was delayed 3580 ms (> 500 ms) before being called (GSource: 0x396762f0)
    Jul 19 08:09:02 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052612 should have started at 564052254
    Jul 19 08:09:03 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for retransmit request took too long to execute: 410 ms (> 10 ms) (GSource: 0x396762f0)
    Jul 19 08:09:03 orarac1 heartbeat: [5729]: WARN: Gmain_timeout_dispatch: Dispatch function for send local status was delayed 2830 ms (> 510 ms) before being called (GSource: 0x1ed323e0)
    Jul 19 08:09:03 orarac1 heartbeat: [5729]: info: Gmain_timeout_dispatch: started at 564052653 should have started at 564052370
    Jul 19 08:09:03 orarac1 heartbeat: [5729]: ERROR: Message hist queue is filling up (500 messages in queue)

    • E no CRSD.LOG
      2010-07-19 08:15:25.391: [ OCRSRV][1253566784]th_select_handler: Retrieved procctx from ht. constr = [-1406092512] retval lht [1] Wait for disconnect processing to complete on prev client.
  • Os demais estão limpos.

  • Você já teve esse tipo de problema em seu ambiente? Alguma sugestão?

  • Muito obrigado!