› Fóruns › Banco de dados Oracle › Como solucionar problemas de Heartbeat? (Oracle RAC) › Como solucionar problemas de Heartbeat? (Oracle RAC)
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!