62,614
社区成员
发帖
与我相关
我的任务
分享
告警VoicebeanImpl{call_id=261459, insert_date=2013-12-27 09:43:13.0, alarm_orgfp='2729237416_1123543517_771361430_468760835', alarm_sid='3471369430_3076361554_2675571861_386802867', alarm_last_event_time=2013-12-27 09:43:12.0, voice_msg='发生此告警的网元IP:10.96.170.12,告警正文:主机10.96.170.12decode_1141_gprs_gg.xml进程异常,责任人:郭晓玲、丁书亮、华亮,启动账户:ngjf6,位置:*decode_1141_gprs_gg.xml*ngjf6,告警发生时间:2013-12-27 09:43:13', telno1='13663026621', telno2='13937172227', telno3='null', read_status=0, read_date=null, send_status=0, send_date=null, alarm_ne_name='HA4-CJ12', alarm_ne_ip='10.96.170.12'}操作完成,拔打号码数:1
2013-12-27 09:44:43:INFO pool-1-thread-32 com.boco.bomc.hn.fm.voice.bean.VoiceBusiTask - 处理一个语音任务完成,耗时:90188ms ,voicebean=VoicebeanImpl{call_id=261459, insert_date=2013-12-27 09:43:13.0, alarm_orgfp='2729237416_1123543517_771361430_468760835', alarm_sid='3471369430_3076361554_2675571861_386802867', alarm_last_event_time=2013-12-27 09:43:12.0, voice_msg='发生此告警的网元IP:10.96.170.12,告警正文:主机10.96.170.12decode_1141_gprs_gg.xml进程异常,责任人:郭晓玲、丁书亮、华亮,启动账户:ngjf6,位置:*decode_1141_gprs_gg.xml*ngjf6,告警发生时间:2013-12-27 09:43:13', telno1='13663026621', telno2='13937172227', telno3='null', read_status=0, read_date=null, send_status=0, send_date=null, alarm_ne_name='HA4-CJ12', alarm_ne_ip='10.96.170.12'}
2013-12-27 09:44:43:ERROR Thread-9 com.boco.bomc.hn.fm.voice.util.DialBusiOper - 更新Iptfa_alarm_hnvoice_sms的send_status为1出现异常
java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
at oracle.jdbc.driver.ClientDataSupport$$EnhancerByProxool$$2f2045b.prepareStatement(<generated>)
at com.boco.bomc.hn.fm.voice.util.DialBusiOper.__updateWatingSmsRecordByPhone(DialBusiOper.java:309)
at com.boco.bomc.hn.fm.voice.util.DialBusiOper.access$500(DialBusiOper.java:21)
at com.boco.bomc.hn.fm.voice.util.DialBusiOper$UpdateSendStatus.run(DialBusiOper.java:392)
2013-12-27 09:44:43:ERROR Thread-9 com.boco.bomc.hn.fm.voice.util.DialBusiOper - 任务发送状态更新更新线程出现异常
com.boco.bomc.hn.fm.voice.HNVoiceException: 数据库连接已断开!
at com.boco.bomc.hn.fm.voice.util.DialBusiOper.__updateWatingSmsRecordByPhone(DialBusiOper.java:322)
at com.boco.bomc.hn.fm.voice.util.DialBusiOper.access$500(DialBusiOper.java:21)
at com.boco.bomc.hn.fm.voice.util.DialBusiOper$UpdateSendStatus.run(DialBusiOper.java:392)
2013-12-27 09:44:43:ERROR Thread-9 com.boco.bomc.hn.fm.voice.util.DialBusiOper - 处理异常,重新进行处理
2013-12-27 09:44:43:ERROR Thread-8 com.boco.bomc.hn.fm.voice.dao.VoicebeanDao - 更新语音拔打状态,callid=261459,status=1,SQL:UPDATE IPTFA_ALARM_HNVOICE_QUEUE SET SEND_STATUS = ? , SEND_DATE=sysdate WHERE CALL_ID = ?
java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
at oracle.jdbc.driver.ClientDataSupport$$EnhancerByProxool$$2f2045b.prepareStatement(<generated>)
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao.__updateSendStatusQueueVoiceBeans(VoicebeanDao.java:269)
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao.access$400(VoicebeanDao.java:24)
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao$UpdateSendStatus.run(VoicebeanDao.java:239)
2013-12-27 09:44:43:ERROR Thread-8 com.boco.bomc.hn.fm.voice.dao.VoicebeanDao - 任务发送状态更新更新线程出现异常
com.boco.bomc.hn.fm.voice.HNVoiceException: 数据库连接已断开!
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao.__updateSendStatusQueueVoiceBeans(VoicebeanDao.java:278)
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao.access$400(VoicebeanDao.java:24)
at com.boco.bomc.hn.fm.voice.dao.VoicebeanDao$UpdateSendStatus.run(VoicebeanDao.java:239)
2013-12-27 09:44:43:INFO Thread-8 com.boco.bomc.hn.fm.voice.dao.VoicebeanDao - 任务发送状态更新线程出现异常,开始重新处理
private class UpdateSendStatus extends Thread {
@Override
public void run() {
logger.info("短信发送及语音状态更新线程开始启动");
while (true) {
Connection update_conn = null;
StatusUpdate u = null;
try {
update_conn = ConnectionPool.getInstance().getNewConnection();
while (true) {
try {
sleep(1);
} catch (Exception e) {
//
}
u = null;
try {
u = updateQueue.take();
} catch (Exception e) {
//
}
if (u == null) {
continue;
}
if (Update_type_voice == u.getUpdate_type()) {
//更新语音状态表
__updateDailSendStatus(u.getPhone(), u.getAlarm_last_date(), u.getSendStatus(), update_conn);
} else if (Update_type_sms == u.getUpdate_type()) {
//更新短信状态表
__updateWatingSmsRecordByPhone(u.getPhone(), u.getAlarm_last_date(), u.getSendStatus(), update_conn);
} else {
logger.error("更新类型[" + u.getUpdate_type() + "]电话号码:" + u.getPhone() + ",告警更新时间:" + u.getAlarm_last_date() + "更新状态:" + u.getSendStatus() + "异常!!");
}
}
} catch (Exception e) {
logger.error("任务发送状态更新更新线程出现异常", e);
if (u != null) {
try {
updateQueue.put(u); //重新放回队列中处理
} catch (Exception e1) {
// e1.printStackTrace();
}
}
} finally {
DbUtil.closeDbResource(null, null, update_conn);
}
logger.error("处理异常,重新进行处理");
}
}
}