Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
2.0.0
-
None
-
None
-
None
-
ALU MGC8 product
Description
Our tester found the issue again. Here is the description. If the same data is fetched repeatedly via our command interface, it failed sometimes. Below is our log for your reference. And odbc log is also attached.
The log of successful data fetch:
00001(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: DB command allowed for table 4505
00002(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: START
00003(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - tableIndex(4506)
00003(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - Id(154)
00004(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - TableName(MGCPRFLMEGACO)
00005(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - rowSize(156)
00006(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - numCols(30)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - numKeys(1)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - logLevel(31)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - encryptIndex(-1)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: INFO - key MGCOPRFLID : pres(0)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - Primary Key Count(0)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - stmtLen(35)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.078 13310: getApi: DEBUG - stmt(SELECT count
FROM MGCPRFLMEGACO )
00001(00672),00000(00000) 0x00000001 04-26 04:21:22.079 13310: getApi: INFO - count(1)
The log of failing to get data immediately after the successful one above:
00001(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: DB command allowed for table 4505
00002(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: START
00003(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - tableIndex(4506)
00003(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - Id(154)
00004(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - TableName(MGCPRFLMEGACO)
00005(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - rowSize(156)
00006(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - numCols(30)
00007(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - numKeys(1)
00008(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - logLevel(31)
00008(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - encryptIndex(-1)
00009(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: INFO - key MGCOPRFLID : pres(0)
00010(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - Primary Key Count(0)
00011(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - stmtLen(35)
00012(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi: DEBUG - stmt(SELECT count FROM MGCPRFLMEGACO )
00001(00672),00000(00000) 0x00000001 04-26 04:21:22.478 13312: getApi(../src/GetDBApi.c:683): ERROR - SQLExecDirect Failed - Unknown prepared statement handler (113) 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 = 13312 & plxThreadName = dbp:Pool