on 07-04-2019 1:36 PM
Hi all,
during import of package SAPKE604D8 the follow error occurs. SAP ASE DB Version is 15.7 PL 135 and SAP Basis Release is 740 PL19
Signal 11 was written in ASE <SID>.log and the following output comes in import file
4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 27519] 4 ETW000 [ dev trc,00000] (5702) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this proces 4 ETW000 [ dev trc,00000] s. 4 ETW000 [ dev trc,00000] sql statement is ==> SELECT * FROM "T512G" WHERE "SPRSL" IN ( ? , ? ) AND "MANDT" = ? AND "MOLGA" = ? 4 ETW000 [ dev trc,00000] AND "FORML" = ? FOR UPDATE 4 ETW000 /* R3::0 T:T512G */ 4 ETW000 /*9*/ 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 47231] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dbtran ,00000] ***LOG BY4=>sql error 5702 performing SEL on table T512G 4 ETW000 [ dbtran ,00000] ***LOG BY0=>[ASE Error SQL5702][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process. 4 ETW000 [ dev trc,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' 4 ETW000 RSLT: {dbsl=99, tran=1} 4 ETW000 FHDR: {tab='T512G', fcode=69, mode=2, bpb=0, dbcnt=0, crsr=1, 4 ETW000 hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0, 4 ETW000 init:p=(nil), init:#=0, wa:p=347cda0, wa:#=542} 2EETW125 SQL error "5702" during "T512G" access: "[ASE Error SQL5702][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process." 4 ETW690 COMMIT "7094" "832764" 4 ETW000 [ dev trc,00000] ERROR: -1 in function PrepOperation (SQLAllocStmt) [line 29339] 4 ETW000 [ dev trc,00000] (30102) [HY010] [SAP][ASE ODBC Driver]Function sequence error 4 ETW000 [ dev trc,00000] sql statement is ==> INSERT INTO DDLOG ( TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( ? , ? , ? 4 ETW000 [ dev trc,00000] , ? ) 4 ETW000 /* R3:/bas/753_REL/src/krn/dbi/dbs/dbsynseq:566 T:DDLOG */ 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 47225] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dbsynseq,00000] ***LOG BY4=>sql error 30102 performing INS on table DDLOG 4 ETW000 [ dbsynseq,00000] ***LOG BY0=>[ASE Error SQL30102:HY010][SAP][ASE ODBC Driver]Function sequence error 4 ETW000 [ dbsync ,00000] ***LOG BZY=>unexpected return code 2 calling ins_ddlog 4 ETW000 [ dev trc,00000] db_syflush (TRUE) failed 4 ETW000 [ dev trc,00000] db_con_commit received error 1024 in before-commit action (con_hdl = 0, th_commit = 1, returning 8 4 ETW000 [dbeh.c ,00000] *** ERROR => missing return code handler 4 ETW000 caller does not handle code 1024 from dblink#1[356] 4 ETW000 ==> calling sap_dext to abort transaction 2EETW000 sap_dext called with msgnr "900": 2EETW125 SQL error "30102" during "" access: "[ASE Error SQL30102:HY010][SAP][ASE ODBC Driver]Function sequence error" 4 ETW000 [ dev trc,00000] ERROR: -1 in function DbSlRollback (ROLLBACK) [line 7868] 4 ETW000 [ dev trc,00000] (30273) [08003] [SAP][ASE ODBC Driver]Attempting to use a dead connection in Rollback. 4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 47225] 4 ETW000 [ dev trc,00000] evaluation of transaction state failed. 4 ETW000 [ dev trc,00000] Rollback Work (99) 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: COMMIT/ROLLBACK failed without RECONNECT error code 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: marking CONNECTION as closed 4 ETW000 [ dev trc,00000] hdl_error_on_commit_rollback: DB-ROLLBACK detected RECONNECT state 4 ETW690 ROLLBACK "7094" "832764" 1 ETP154 MAIN IMPORT 1 ETP110 end date and time : "20190704125806" 1 ETP111 exit code : "12" 1 ETP199 ######################################
And the stack trace is:
Kein Titel
00:0002:00000:00179:2019/07/04 11:20:04.24 kernel Current process (0x3790002) infected with signal 11 (SIGSEGV)
00:0002:00000:00179:2019/07/04 11:20:04.24 kernel Address 0x0x000000000089b240 (OptGlobal::OptGlobal(Node<Lop>*, tree*, OptPool*)+0x7882), siginfo (code, address) = (128, 0x(nil))
00:0002:00000:00179:2019/07/04 11:20:04.24 kernel **** Saved signal context (0x0x000000014c8b0400): ****
00:0002:00000:00179:2019/07/04 11:20:04.24 kernel uc_flags: 0x0, uc_link: 0x(nil)
00:0002:00000:00179:2019/07/04 11:20:04.24 kernel uc_sigmask: 0x416000 0xb 0x80 0x0
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel General Registers (uc_mcontext.gregs):
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel PC : 0x000000000089b240 (OptGlobal::OptGlobal(Node<Lop>*, tree*, OptPool*)+0x7882)
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RAX : 0x0000000001d00000 RBX : 0x00000001e2f27a88
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RCX : 0x0000000000000001 RDX : 0x00000001e2ed77d0
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RBP : 0x000000014c8b0860 RSP : 0x000000014c8b0850
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R8 : 0xfffffffffffffff8 R9 : 0x0000000143aba618
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R10 : 0xfffffffffffffff8 R11 : 0x00000001e2ed8050
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R12 : 0x00000001e2ed4850 R13 : 0x00000001e2ed4850
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel R14 : 0x00000001e2f4e9e0 R15 : 0x00000001e2ec91d8
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RDI : 0x00000001e2f27a88 RSI : 0x00000001e2ed4850
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel RIP : 0x000000000089b240 CSGSFS : 0xffff000000000033
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel TRAPNO : 0x000000000000000d ERR : (nil)
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel EFL : 0x0000000000010206
00:0002:00000:00179:2019/07/04 11:20:04.25 kernel **** end of signal context ****
Thanks a lot.
Kind Regards
Ali Özcan
Hi Ali,
Please check 'optimizer level' configuration parameter.
If it set as ase_default, please change it to ase_current.
sp_configure 'optimizer level', 0, 'ase_current'
go
Best regards,
Jongun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.