ALU log: 00001(00111),00000(00000) 0x00000001 05-08 13:59:53.482 24608: ../src/PrflSchedDBApi.c:561: [ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (399) given to mysqld_stmt_reset ODBC Error/Warning = HY000, MySQL Error/Warning = 1243, ConnStr = socket=/opt/MySql/mysqld/mysql.sock;uid=PERM_DBP_SOFT;database=SoftSwitch;OPTIONS=4;, plx Caller's plxThreadID = 24608 & plxThreadName = dbp:Pool ALU log: 00001(00111),00000(00000) 0x00000001 05-08 13:59:53.483 24608: RAW DB ERROR is 1243 at: ../src/DBPCommon.c:74 00001(00111),00000(00000) 0x00000001 05-08 13:59:54.682 24610: DB command allowed for table 4456 00001(00111),00000(00000) 0x00000001 05-08 13:59:54.682 24610: ../src/PrflSchedDBApi.c:561: [ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (443) given to mysqld_stmt_reset ODBC Error/Warning = HY000, MySQL Error/Warning = 1243, ConnStr = socket=/opt/MySql/mysqld/mysql.sock;uid=PERM_DBP_SOFT;database=SoftSwitch;OPTIONS=4;, plx Caller's plxThreadID = 24610 & plxThreadName = dbp:Pool 00001(00111),00000(00000) 0x00000001 05-08 13:59:54.682 24610: RAW DB ERROR is 1243 at: ../src/DBPCommon.c:74 00001(00111),00000(00000) 0x00000001 05-08 13:59:55.882 24613: DB command allowed for table 4805 00001(00111),00000(00000) 0x00000001 05-08 13:59:55.883 24613: getTgCtrlSched: INFO - count(6) 00001(00111),00000(00000) 0x00000001 05-08 13:59:55.888 24613: ../src/TgCtrlDBApi.c:1612: More than 1 record with TgCtrlSchedId: 32. not popping from MergeTgCtrlPlanSchedMap 00001(00111),00000(00000) 0x00000001 05-08 13:59:57.082 24558: DB command allowed for table 4805 00001(00111),00000(00000) 0x00000001 05-08 13:59:57.083 24558: getTgCtrlSched: INFO - count(5) 00001(00111),00000(00000) 0x00000001 05-08 13:59:57.087 24558: RAW DB ERROR is 0 at: ../src/DBPCommon.c:74 00001(00111),00000(00000) 0x00000001 05-08 13:59:58.282 24561: DB command allowed for table 4805 00001(00111),00000(00000) 0x00000001 05-08 13:59:58.282 24561: ../src/TgCtrlDBApi.c:1121: [ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (397) given to mysqld_stmt_reset ODBC Error/Warning = HY000, MySQL Error/Warning = 1243, ConnStr = socket=/opt/MySql/mysqld/mysql.sock;uid=PERM_DBP_SOFT;database=SoftSwitch;OPTIONS=4;, plx Caller's plxThreadID = 24561 & plxThreadName = dbp:Pool 00001(00111),00000(00000) 0x00000001 05-08 13:59:58.282 24561: ../db_rst.c:8622 {dbpUtilTgCtrlSchedCount()} Error: getTgCtrlSched failed ODBC log: >>> 13:59:53 --- SQLExecDirect (thread: 34) --- StatementHandle: aa93eb8 StatementText: SELECT count(*) FROM PrflSched WHERE prflSchedName='DATE2' TextLength: -3 ->MADB_StmtPrepare [HY000](1243)[ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (399) given to mysqld_stmt_reset <<< --- end of function, returning -1 --- >>> 13:59:53 --- SQLError->SQLGetDiagRec (thread: 34) --- Env: aa8b028 Dbc: aa8b278 Stmt: aa93eb8 >>> 13:59:53 --- SQLGetDiagRec (thread: 34) --- HandleType: 3 Handle: aa93eb8 MessageText: f6f1d626 BufferLength: 512 TextLengthPtr: f6f1d624 >>> 13:59:53 --- SQLFreeStmt (thread: 34) --- ->MA_SQLFreeStmt Stmt: aa93eb8 Option: 0 -->resetting aa941e0 >>> 13:59:53 --- SQLFreeStmt (thread: 34) --- ->MA_SQLFreeStmt Stmt: aa93eb8 Option: 2 >>> 13:59:54 --- SQLExecDirect (thread: 35) --- StatementHandle: aaa79d0 StatementText: SELECT count(*) FROM PrflSched WHERE prflSchedName='DATE2' TextLength: -3 ->MADB_StmtPrepare [HY000](1243)[ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (443) given to mysqld_stmt_reset <<< --- end of function, returning -1 --- >>> 13:59:54 --- SQLError->SQLGetDiagRec (thread: 35) --- Env: aa9eb40 Dbc: aa9ed90 Stmt: aaa79d0 >>> 13:59:54 --- SQLGetDiagRec (thread: 35) --- HandleType: 3 Handle: aaa79d0 MessageText: bedfe626 BufferLength: 512 TextLengthPtr: bedfe624 >>> 13:59:54 --- SQLFreeStmt (thread: 35) --- ->MA_SQLFreeStmt Stmt: aaa79d0 Option: 0 -->resetting aaa7cf8 >>> 13:59:54 --- SQLFreeStmt (thread: 35) --- ->MA_SQLFreeStmt Stmt: aaa79d0 Option: 2 >>> 13:59:55 --- SQLExecDirect (thread: 36) --- StatementHandle: aabb4e8 StatementText: SELECT count(*) FROM TgCtrlSched where tgCtrlSchedName='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 0 -->resetting aabb810 >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 2 >>> 13:59:55 --- SQLBindParameter (thread: 36) --- Stmt: bd3df448 ParameterNumber: 1 InputOutputType: 1 ValueType: 1 ParameterType: 1 ColumnSize: 32 DecimalDigits: 0 ParameterValuePtr: bede604d BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLExecute (thread: 36) --- Stmt: bd3df448 ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 1 TargetType: 1 BufferLength: 32 StrLen_or_Ind: bede5f64 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 2 TargetType: -16 BufferLength: 0 StrLen_or_Ind: bede5f60 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 3 TargetType: -16 BufferLength: 0 StrLen_or_Ind: bede5f5c ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 4 TargetType: -16 BufferLength: 0 StrLen_or_Ind: bede5f58 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 5 TargetType: 1 BufferLength: 21 StrLen_or_Ind: bede5f54 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindCol (thread: 36) --- Stmt: bd3df448 ColumnNumber: 6 TargetType: 1 BufferLength: 21 StrLen_or_Ind: bede5f50 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 100 <<< --- end of function, returning 100 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: bd3df448 Option: 0 -->resetting bd3df770 >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: bd3df448 Option: 2 >>> 13:59:55 --- SQLExecDirect (thread: 36) --- StatementHandle: aabb4e8 StatementText: SELECT id FROM MergeTgCtrlSchedMap where name='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 0 -->resetting aabb810 >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 2 >>> 13:59:55 --- SQLExecDirect (thread: 36) --- StatementHandle: aabb4e8 StatementText: SELECT prflSchedId FROM PrflSched where prflSchedName='DATE1' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 0 -->resetting aabb810 >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 2 >>> 13:59:55 --- SQLExecDirect (thread: 36) --- StatementHandle: aabb4e8 StatementText: SELECT count(*) FROM TgCtrlSched WHERE tgCtrlSchedId = 32 TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFetch (thread: 36) --- >>> 13:59:55 --- MADB_StmtFetch (thread: 36) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 0 -->resetting aabb810 >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: aabb4e8 Option: 2 >>> 13:59:55 --- SQLAllocStmt (thread: 36) --- InputHandle: aab28a8 OutputHandlePtr: bd84c938 >>> 13:59:55 --- MA_SQLAllocHandle(Stmt) (thread: 36) --- InputHandle: aab28a8 OutputHandlePtr: bd84c938 -->inited bd040980 *OutputHandlePtr: bd03fda8 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLPrepare (thread: 36) --- Stmt: bd03fda8 StatementText: DELETE FROM TgCtrlSched WHERE tgCtrlSchedName=? AND prflId=? TextLength: -3 ->MADB_StmtPrepare <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindParameter (thread: 36) --- Stmt: bd03fda8 ParameterNumber: 1 InputOutputType: 1 ValueType: 1 ParameterType: 1 ColumnSize: 11 DecimalDigits: 0 ParameterValuePtr: f73ec9e5 BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLBindParameter (thread: 36) --- Stmt: bd03fda8 ParameterNumber: 2 InputOutputType: 1 ValueType: -16 ParameterType: 4 ColumnSize: 10 DecimalDigits: 0 ParameterValuePtr: f73eca38 BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLExecute (thread: 36) --- Stmt: bd03fda8 ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:55 --- SQLFreeStmt (thread: 36) --- ->MA_SQLFreeStmt Stmt: bd03fda8 Option: 0 -->resetting bd040980 >>> 13:59:57 --- SQLExecDirect (thread: 13) --- StatementHandle: a8ec370 StatementText: SELECT count(*) FROM TgCtrlSched where tgCtrlSchedName='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 0 -->resetting a8ec698 >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 2 >>> 13:59:57 --- SQLBindParameter (thread: 13) --- Stmt: bd153c48 ParameterNumber: 1 InputOutputType: 1 ValueType: 1 ParameterType: 1 ColumnSize: 32 DecimalDigits: 0 ParameterValuePtr: f737004d BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLExecute (thread: 13) --- Stmt: bd153c48 ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 1 TargetType: 1 BufferLength: 32 StrLen_or_Ind: f736ff64 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 2 TargetType: -16 BufferLength: 0 StrLen_or_Ind: f736ff60 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 3 TargetType: -16 BufferLength: 0 StrLen_or_Ind: f736ff5c ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 4 TargetType: -16 BufferLength: 0 StrLen_or_Ind: f736ff58 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 5 TargetType: 1 BufferLength: 21 StrLen_or_Ind: f736ff54 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindCol (thread: 13) --- Stmt: bd153c48 ColumnNumber: 6 TargetType: 1 BufferLength: 21 StrLen_or_Ind: f736ff50 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 100 <<< --- end of function, returning 100 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: bd153c48 Option: 0 -->resetting bd153f70 >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: bd153c48 Option: 2 >>> 13:59:57 --- SQLExecDirect (thread: 13) --- StatementHandle: a8ec370 StatementText: SELECT id FROM MergeTgCtrlSchedMap where name='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 0 -->resetting a8ec698 >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 2 >>> 13:59:57 --- SQLExecDirect (thread: 13) --- StatementHandle: a8ec370 StatementText: SELECT prflSchedId FROM PrflSched where prflSchedName='DATE2' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 0 -->resetting a8ec698 >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 2 >>> 13:59:57 --- SQLExecDirect (thread: 13) --- StatementHandle: a8ec370 StatementText: SELECT count(*) FROM TgCtrlSched WHERE tgCtrlSchedId = 32 TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFetch (thread: 13) --- >>> 13:59:57 --- MADB_StmtFetch (thread: 13) --- ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 0 -->resetting a8ec698 >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: a8ec370 Option: 2 >>> 13:59:57 --- SQLBindParameter (thread: 13) --- Stmt: bd173c98 ParameterNumber: 1 InputOutputType: 1 ValueType: 1 ParameterType: 1 ColumnSize: 11 DecimalDigits: 0 ParameterValuePtr: f73fdc35 BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLBindParameter (thread: 13) --- Stmt: bd173c98 ParameterNumber: 2 InputOutputType: 1 ValueType: -16 ParameterType: 4 ColumnSize: 10 DecimalDigits: 0 ParameterValuePtr: f73fdc88 BufferLength: 0 StrLen_or_IndPtr: 0 ret: 0 <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLExecute (thread: 13) --- Stmt: bd173c98 ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:57 --- SQLFreeStmt (thread: 13) --- ->MA_SQLFreeStmt Stmt: bd173c98 Option: 0 -->resetting bd173fc0 >>> 13:59:58 --- SQLExecDirect (thread: 14) --- StatementHandle: a8eb618 StatementText: SELECT count(*) FROM TgCtrlSched where tgCtrlSchedName='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare [HY000](1243)[ma-2.0.7][10.0.14-MariaDB-log]Unknown prepared statement handler (397) given to mysqld_stmt_reset <<< --- end of function, returning -1 --- >>> 13:59:58 --- SQLError->SQLGetDiagRec (thread: 14) --- Env: a8d84b8 Dbc: a8d8708 Stmt: a8eb618 >>> 13:59:58 --- SQLGetDiagRec (thread: 14) --- HandleType: 3 Handle: a8eb618 MessageText: f7356af6 BufferLength: 512 TextLengthPtr: f7356af4 >>> 13:59:58 --- SQLFreeStmt (thread: 14) --- ->MA_SQLFreeStmt Stmt: a8eb618 Option: 0 -->resetting a8eb940 >>> 13:59:58 --- SQLFreeStmt (thread: 14) --- ->MA_SQLFreeStmt Stmt: a8eb618 Option: 2 >>> 13:59:59 --- SQLExecDirect (thread: 15) --- StatementHandle: a91dbf0 StatementText: SELECT count(*) FROM TgCtrlSched where tgCtrlSchedName='SCHEDLIST' TextLength: -3 ->MADB_StmtPrepare ->MADB_StmtExecute <<< --- end of function, returning 0 --- >>> 13:59:59 --- SQLFetch (thread: 15) --- >>> 13:59:59 --- MADB_StmtFetch (thread: 15) --- ret: 0 <<< --- end of function, returning 0 ---