From 728b372a16e5bae7f985f2d8dcc3fe2705b8b07e Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期五, 28 八月 2026 16:38:31 +0800
Subject: [PATCH] fix: 数据导入页进入时 batches 请求合并为 1 个 + Tomcat 线程池 500,缓解导入占满线程导致接口 pending(浏览器无响应)
---
HANDOFF.md | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/HANDOFF.md b/HANDOFF.md
index 6434f60..7f47aa8 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -3,6 +3,34 @@
> **鐢ㄦ硶**锛氭柊瀵硅瘽寮�濮嬪悗锛屽厛璇绘湰鏂囦欢 + 椤圭洰鏍圭洰褰� `AGENTS.md`锛屽嵆鍙棤缂濇帴鍔涖��
> **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄��
+## 浠婃棩锛�2026-08-28锛�
+
+### 1. 鐧诲綍楠岃瘉鐮侊細娴嬭瘯闃舵鍙烦杩囷紙宸插畬鎴愬苟楠岃瘉锛�
+- 鍚庣鏂板 `app.captcha.required` 寮�鍏筹紙缂虹渷 `true`=鍚敤锛夛紱鏈満 application.yml 涓� example 鐜颁负 `false`锛堟祴璇曢樁娈佃烦杩囷紝**姝e紡鍙戝竷鍓嶆敼鍥� `true`**锛夈��
+- LoginController锛歚captchaRequired=false` 鏃剁櫥褰曚笉鏍¢獙楠岃瘉鐮侊紱鏂板鍏紑鎺ュ彛 `GET /api/auth/captcha-config` 杩斿洖 `{required}`銆�
+- Login.vue锛氬惎鍔ㄦ椂鎷夊彇璇ラ厤缃紱`required=false` 鏃堕殣钘忛獙璇佺爜鍖哄煙骞舵樉绀恒�屾祴璇曟ā寮忥細琛屼负楠岃瘉鐮佸凡璺宠繃銆嶆彁绀猴紝鐧诲綍璺宠繃楠岃瘉锛涢厤缃姹傚け璐ユ椂榛樿鎸夊惎鐢ㄥ鐞嗭紙瀹夊叏鍏滃簳锛夈��
+- 宸插疄娴嬶細captcha-config 杩斿洖 required=false锛沘dmin/admin123 涓嶅甫楠岃瘉鐮佺洿鎺ョ櫥褰� 200锛涘悗绔� mvn compile 鉁呫�佸墠绔� npm run build 鉁呫��
+- 鈿狅笍 闇�閲嶆柊鎵撳寘鎵嶅湪娴嬭瘯鐜鐢熸晥锛涙寮忓彂甯冩椂鎶� `app.captcha.required` 鏀瑰洖 `true`銆�
+
+### 2. 鏁版嵁瀵煎叆娴忚鍣ㄥ穿婧冩帓鏌ワ紙杩涜涓紝鐢ㄦ埛绾跨储鏇存柊锛�
+- 鐢ㄦ埛琛ュ厖锛氬叡 3 鍙版満鍣ㄥ嚭鐜帮紙瀵规柟寮�鍙戞満 + 鏄ㄥぉ鎵撳寘娴嬭瘯 1 鍙� + 浠婂ぉ 1 鍙帮級锛涘鏂硅褰曠殑銆岃繀闆�/椹卞姩銆嶆槸鍏朵富瑙傚垽鏂紱鐜拌薄鏃跺ソ鏃跺潖銆佹瘡鍙扮害 1/3 鐢ㄦ埛宕┿��
+- 宸叉帓闄わ細/import/batches锛坙imit鈮�200銆�81 鏉$害 17KB锛夛紱杩涘叆椤甸潰鏃犺疆璇�/瀹氭椂鍣ㄣ��
+- 鐢ㄦ埛鎬�鐤戙�岀洰褰曞鍏ワ紙娴忚/鎵弿鐩綍锛夈�嶁啋 宸插姞鍥猴紙瑙佷笅锛夈�傛敞鎰忥細璇ュ姛鑳介渶鐢ㄦ埛涓诲姩鎵撳紑鐩綍娴忚/鐐圭洰褰曞鍏ユ墠瑙﹀彂锛屼笌銆岀偣鏁版嵁瀵煎叆鑿滃崟灏卞穿銆嶇幇璞′笉瀹屽叏鍚诲悎锛�**寰呯敤鎴风‘璁ゅ穿婧冩椂鐐圭殑鍏蜂綋鎸夐挳**銆�
+- 鍔犲浐锛堝凡瀹屾垚锛岀紪璇�/鏋勫缓閫氳繃锛夛細鍚庣 `listDirs` 瀛愮洰褰�/鏂囦欢鍒楄〃鍚勯檺 300锛堟柊澧� `dirsTruncated`/`filesTruncated` 鏍囪锛宍excelCount` 浠嶄负鐪熷疄鎬绘暟锛夛紱鍓嶇銆屼粠鐩綍鎵归噺瀵煎叆銆嶆瘡鎵归檺 60 涓枃浠讹紙瓒呴檺鎻愮ず鍒嗘壒锛夛紱鐩綍娴忚寮圭獥鏄剧ず鎴柇鎻愮ず銆�
+- 寰呭姙锛氳宕╂簝鏈哄櫒鐢ㄦ埛鍦� Chrome 寮� `chrome://crashes` 璁颁笅鍘熷洜鐮侊紙OOM / GPU / STATUS_ACCESS_VIOLATION 绛夛級锛屽苟纭宕╂簝鏃剁偣鐨勬槸渚ц竟鏍忋�屾暟鎹鍏ャ�嶈彍鍗曡繕鏄〉闈笂鏌愪釜鎸夐挳锛涙嵁姝ゅ喅瀹氫笅涓�姝ャ��
+- **閲嶅ぇ杩涘睍锛�08-28 涓嬪崍锛�**锛�
+ - 鐢ㄦ埛纭锛�**宕╂簝鏃舵湇鍔″櫒鍚庣鏃ュ織鏃犱换浣曡褰� 鈫� 璇锋眰鏍规湰娌″埌鍚庣** 鈫� 鍗″湪**闈欐�佽祫婧�/缃戠粶灞�**锛堢偣鑿滃崟鍚庢祻瑙堝櫒鐜板満涓嬭浇鏁版嵁瀵煎叆椤� chunk JS锛岃繕娌″埌鍙� API 閭d竴姝ワ級銆傛帴鍙�/鏁版嵁搴撳交搴曟帓闄ゃ��
+ - 鐢ㄦ埛鎻忚堪琛ュ厖锛氱偣渚ц竟鏍忋�屾暟鎹鍏ャ�嶈彍鍗� 鈫� 鏃犲弽搴斻�佸仠鐣欎富椤� 鈫� 娴忚鍣ㄥ脊銆屽簲鐢ㄧ▼搴忔棤鍙嶅簲锛屾槸绛夊緟杩樻槸閫�鍑恒��= 娓叉煋/娴忚鍣ㄨ繘绋� hang锛岄潪 crash銆�
+ - 鍙戝竷鏈哄櫒鎵嶆槸鐢ㄦ埛杩愯鐜锛涙湰鏈� D:\trafficAudit 浠呮墦鍖呮祴璇曪紙17:39 鍚庡仠姝紝鏃ュ織姝e父锛夈��
+ - **鏈湴鎵撳寘褰㈡�佸帇娴嬶紙headless Chrome锛�20 杞彍鍗曞垏鎹級**锛氬鑸� 17~89ms銆�0 JS 閿欒銆丏OM 鎭� 949 鑺傜偣鏃犵疮绉�佸爢鍐呭瓨 11~37MB 鏃犳硠婕忋�佹渶闀块暱浠诲姟 80ms 鈫� 搴旂敤 JS 灞傛棤姝诲惊鐜�/澶ц绠�/娉勬紡銆�
+ - **宸插姞 Tomcat 璁块棶鏃ュ織**锛坄server.tomcat.basedir: .` + accesslog锛宩ar 鍚岀骇 `logs/access.*.log`锛宲attern 鍚� `%D` 鑰楁椂锛岄潤鎬佽祫婧愪篃璁板綍锛夆�斺�旀湰鍦板疄娴� chunk 璇锋眰 3ms銆�**閲嶆柊鎵撳寘鍙戝竷鍚�**锛屼笅娆″穿婧冪湅 access log锛歝hunk 璇锋眰鏄惁鍒拌揪銆佽�楁椂澶氬皯 鈫� 鐩存帴瀹氫綅銆屾湇鍔″櫒鎱€�嶈繕鏄�屽鎴风娌″彂鍑鸿姹傘�嶃��
+ - 寰呯敤鎴凤細閲嶆柊鎵撳寘鍙戝竷鍚庯紝宕╂簝鏃剁湅 鈶犳湇鍔″櫒 `logs/access.*.log` 鈶″鎴风 F12 Network 涓� `chunk-*.js` 璇锋眰鐘舵�侊紙pending/stalled/鑰楁椂锛夈��
+
+### 3. 寰呭姙涓嶅彉
+- `docs/鎵撳寘閮ㄧ讲璇存槑.docx` 绗叚鑺傘�屽缃� application.yml 闇�鍖呭惈瀹屾暣閰嶇疆銆嶆敼涓恒�屽睘鎬х骇鍚堝苟銆嶅悗閲嶆柊瀵煎嚭 docx锛堟湭鍋氾級銆�
+- 宕╂簝鏍瑰洜纭鍚庯細淇 commit `cf57c2b` 涓�屾寚鍚戝鎴风鐜銆嶇殑鏃х粨璁恒��
+
+
## 銆囥�佸叧鏈轰氦鎺ワ紙2026-08-27 娣卞锛岀敤鎴峰叧鏈哄墠锛�
- **褰撳墠杩愯鐘舵��**锛氬墠鍚庣搴旂敤鏈嶅姟鍏ㄩ儴宸插仠姝紙寮�鍙戞湇鍔°�佹墦鍖呯増鍧囨湭杩愯锛夛紱浠呮暟鎹簱鍦ㄨ窇
锛圡ySQL80 鏈嶅姟=3305锛屾湰椤圭洰鐢紱MySQL57=3306 鍕垮姩锛夛紱8080 涓� IIS 绔欑偣浠嶅湪浣嗘湰椤圭洰宸蹭笉鍐嶄緷璧� IIS銆�
@@ -87,6 +115,7 @@
- 鍚庣画鎵╁睍锛欻203-1 鍏矾鏃呭銆乄203 姘磋矾銆丳203 娓彛銆丠204 鑳芥簮绛夛紙闇�姹傛枃妗� v2/v3 璁″垝锛夛紝鍏堟妸 H203-2 婕旂ず鍋氬ソ銆�
- 銆愭柊闇�姹偮蜂粎璁板綍鏈疄鐜奥�2026-08-23銆戠櫥褰曞悗棣栭〉鏂板銆屽叏鐪佷氦閫氳繍杈撴�佸娍鎰熺煡鍥俱�嶏細鎶婅揣杩愩�佸杩愩�佸贰娓稿嚭绉熴�佺綉绾﹁溅銆佹姇璧勩�佽兘鑰楃瓑鏂归潰鐨勫彉鍖栨�佸娍鍙鍖栧睍绀恒��
- 銆愭柊闇�姹偮蜂粎璁板綍鏈疄鐜奥�2026-08-23銆戞墿灞曠幇鏈� AI 鍒嗘瀽涓恒�孉I 鍔╂墜銆嶏細浠ユ湰鍦版暟鎹簱鏁版嵁涓哄熀纭�寤虹珛鐭ヨ瘑搴擄紝鍋� RAG锛屾敮鎸佽嚜鐒惰瑷�鎻愰棶/鑱婂ぉ锛岀伒娲绘煡鐪嬩笌鎸栨帢鏁版嵁銆�
+- **2026-08-28 澶嶆牳銆岀偣鏁版嵁瀵煎叆娴忚鍣ㄥ穿婧冦�嶏紙鎵撳寘娴嬭瘯鐜锛岄儴鍒嗙敤鎴凤級**锛氶噸鐐规帓鏌� `GET /api/import/batches`鈥斺�斿悗绔� limit 涓婇檺 200锛涘叏琛� 81 鏉°�乪rror_detail 鏈�闀� 2.6KB銆佸叏閲忓搷搴旂害 17KB锛堝墠绔彧鍙� 50 鏉★級锛涘墠绔〃鏍间粎 8 鍒楃煭瀛楁锛坋rrorDetail 涓嶆覆鏌擄級銆佹棤杞/瀹氭椂鍣ㄣ��**缁撹锛氭帴鍙d笉鏄穿婧冩牴鍥�**锛堣嫢鎺ュ彛鏈夐棶棰橈紝鎵�鏈夌敤鎴烽兘浼氬穿锛岃�岄潪"閮ㄥ垎鐢ㄦ埛"锛夈�傜幇璞$鍚堝鎴风鐜宸紓锛堢涓夋柟鎵╁睍娉ㄥ叆/鏃ф樉鍗¢┍鍔�/浣庨厤鍐呭瓨锛屼笌 08-27 杩呴浄鎵╁睍+Intel 鏃ч┍鍔ㄧ粨璁轰竴鑷达級銆傚缓璁宕╂簝鐢ㄦ埛渚濇楠岃瘉锛氭棤鐥曟ā寮忊啋鎹� Edge鈫掔鎵╁睍锛屽苟鐪� chrome://crashes銆�
- 銆愭柊闇�姹偮蜂粎璁板綍鏈疄鐜奥�2026-08-28銆戝鍔�**缁忔祹鎸囨爣璇曠畻鍔熻兘**锛氶瀵奸潪甯稿叧娉ㄧ粡娴庢寚鏍囷紝**璐ц繍鏄ぇ澶�**锛涘父椹荤幇鍦虹殑鎵�鏈変汉閮借浼氳绠楄揣杩愮浉鍏虫暟鎹紙璐ц繍閲�/鍛ㄨ浆閲忕瓑锛夈�傞瀵肩粡甯歌姹傛妸鏌愪釜鏁版嵁銆屽帇涓�鍘嬨�嶏紝浠婂悗鑰冭檻鍦ㄨ蒋浠堕噷澧炲姞璇曠畻鍔熻兘鈥斺�斿彲鎸夐渶瑕佽皟鏁�/娴嬬畻鎸囨爣鏁板�硷紙濡傛ā鎷熶笅璋冩煇浼佷笟/鏌愬彛寰勭殑璐ц繍閲忓悗鐪嬫眹鎬讳笌瓒嬪娍褰卞搷锛夛紝杈呭姪鐜板満浜哄憳蹇�熻瘯绠椾笌搴斿銆�
## 鍏�佹瘡鏃ヤ氦鎺ョ害瀹�
--
Gitblit v1.9.1