久久久久av_欧美日韩一区二区在线_国产精品三区四区_日韩中字在线

Discuz! 官方交流社區

標題: 高并發下論壇間歇性出現(Discuz! Database Error)Bug修復 [打印本頁]

作者: discus999 時間: 2025-4-17 10:51
標題: 高并發下論壇間歇性出現(Discuz! Database Error)Bug修復
Bug：高并發下，pre_common_session會員認證表的delete操作表鎖沖突導致數據庫連接數耗盡，適用X3.2、X3.4

Fix：
public function delete_by_session($session, $onlinehold, $guestspan) {
if(!empty($session) && is_array($session)) {
$onlinehold = time() - $onlinehold;
$guestspan = time() - $guestspan;
$session = daddslashes($session);

$condition = " sid='{$session[sid]}' ";
$condition .= " OR lastactivity<$onlinehold ";
$condition .= " OR (uid='0' AND ip1='{$session['ip1']}' AND ip2='{$session['ip2']}' AND ip3='{$session['ip3']}' AND ip4='{$session['ip4']}' AND lastactivity>$guestspan) ";
$condition .= $session['uid'] ? " OR (uid='{$session['uid']}') " : '';
//DB::delete('common_session', $condition);
//fix by wangxj
$query = DB::query("SELECT sid FROM ".DB::table('common_session')." WHERE $condition");
$sids = array();
while ($row = DB::fetch($query)) {
$sids[] = $row['sid'];
}
// 按主鍵sid刪除
if (!empty($sids)) {
DB::delete('common_session', DB::field('sid', $sids));
}
}
}

歡迎光臨 Discuz! 官方交流社區 (http://www.9999xn.com/)