996M2(2024.05.23.0_64位)[0626]，SETADDNEWABIL以及自定义属性报错

wangyunjio

[@TakeOnEx]
#if
#act
SETADDNEWABIL 3 = 3#1#3000
BREAK

以上是QF触发脚本




以下是M2报错
[2024-07-02 18:48:30:759] 执行SQL异常 TDbThread.ExecSql,Sql:MERGE INTO dbo.TBL_ITEM_EX_ABIL A
USING ( SELECT 23059 AS FLD_MAKEINDEX,'{"abil":[{"i":0,"t":"","c":255,"v":[]},{"i":1,"t":"","c":255,"v":[]},{"i":2,"t":"","c":255,"v":[]},{"i":3,"t":"","c":255,"v":[]},{"i":4,"t":"","c":255,"v":[]},{"i":5,"t":"","c":255,"v":[]}],"name":"","abilex":"1=3000"}' AS FLD_EX_ABIL ) B
ON (A.FLD_MAKEINDEX=B.FLD_MAKEINDEX)
WHEN MATCHED THEN
        UPDATE SET A.FLD_EX_ABIL=B.FLD_EX_ABIL
WHEN NOT MATCHED THEN
        INSERT(FLD_MAKEINDEX,FLD_EX_ABIL,fld_Params)
        VALUES(B.FLD_MAKEINDEX,B.FLD_EX_ABIL,'');  Except：[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]列名 'fld_Params' 无效。[000000000123CC21] JclDebug._ZN8Jcldebug17TJclStackInfoListC3EbiPvbS1_S1_ (Line 5509, "JclDebug.pas" + 34)
[000000000123C472] JclDebug._ZN8Jcldebug18JclCreateStackListEbiPvbS0_ (Line 5351, "JclDebug.pas" + 1)
[000000000123C352] JclDebug._ZN8Jcldebug21DoExceptionStackTraceEPN6System7TObjectEPvbS3_ (Line 5292, "JclDebug.pas" + 20)
[000000000123F445] JclDebug._ZN8Jcldebug14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 6741, "JclDebug.pas" + 7)
[000000000122E0A2] JclHookExcept._ZN13Jclhookexcept13TNotifierItem8DoNotifyEPN6System7TObjectEPvbS4_ (Line 272, "JclHookExcept.pas" + 5)
[000000000122E30B] JclHookExcept._ZN13Jclhookexcept14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 339, "JclHookExcept.pas" + 13)
[000000000122E470] JclHookExcept._ZN13Jclhookexcept20HookedRaiseExceptionEjjjPNS_19TExceptionArgumentsE (Line 381, "JclHookExcept.pas" + 14)
[00000000002823D3] System._ZN6System14_RaiseAtExceptEPNS_7TObjectEPv (Line 22402, "System.pas" + 32)
[0000000000282438] System._ZN6System11_RaiseAgainEv (Line 23481, "System.pas" + 9)
[0000000000913D14] FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand15InternalExecuteEiib (Line 6853, "FireDAC.Comp.Client.pas" + 16)
[000000000091411F] FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand7ExecuteEiib (Line 6871, "FireDAC.Comp.Client.pas" + 4)
[000000000091DBB5] FireDAC.Comp.Client._ZN7Firedac4Comp6Client17TFDAdaptedDataSet15DoExecuteSourceEii (Line 10127, "FireDAC.Comp.Client.pas" + 5)
[00000000008CC591] FireDAC.Comp.DataSet._ZN7Firedac4Comp7Dataset10TFDDataSet7ExecuteEii (Line 3189, "FireDAC.Comp.DataSet.pas" + 9)
[0000000000920F19] FireDAC.Comp.Client._ZN7Firedac4Comp6Client14TFDCustomQuery7ExecSQLEv (Line 11583, "FireDAC.Comp.Client.pas" + 2)
[0000000000E8FEA6] uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringEPNS1_7TVarRecEi (Line 3892, "uThread_Db.pas" + 11)
[0000000000E8FA5F] uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringE (Line 3818, "uThread_Db.pas" + 1)
[0000000000E86282] uThread_Db._ZN10Uthread_db9TDbThread15UpdateBatchAbliEv (Line 2591, "uThread_Db.pas" + 22)
[0000000000E7751E] uThread_Db._ZN10Uthread_db9TDbThread5OnRunEv (Line 462, "uThread_Db.pas" + 71)
[0000000000741686] uThreadPools._ZN12Uthreadpools11TThreadPool10ThreadProcEv (Line 174, "uThreadPools.pas" + 18)
[000000000074123F] uThreadPools._ZN12Uthreadpools9TMyThread7ExecuteEv (Line 74, "uThreadPools.pas" + 4)
[00000000004427E3] System.Classes._ZN6System7Classes10ThreadProcEPNS0_7TThreadE (Line 15845, "System.Classes.pas" + 18)
[0000000000282FAD] System._ZN6System13ThreadWrapperEPv (Line 25726, "System.pas" + 9)
[00007FF8032E6FD4] BaseThreadInitThunk
[00007FF8035FCEC1] RtlUserThreadStart


反反复复多次测试，会导致M2重启

996技术-wang

[@TakeOnEx]

#act
SETADDNEWABIL 3 = 3#1#3000 测试了并未重启 即使穿戴项链都没 。。。 先排查下相关触发呢

wangyunjio

996技术-wang 发表于 2024-7-4 14:20
[@TakeOnEx]

#act

是工具服吗？

wangyunjio

996技术-wang 发表于 2024-7-4 14:20
[@TakeOnEx]

#act

用工具服就会这样，用本地服就没事！

996技术-wang

这个已经修复了的5.23热更日志里提了