when executing OCI_ReleaseResultsets,program crashed (not always,occasional)
multithead Environment, OCI_Initialize(NULL, NULL,
OCI_ENV_DEFAULT|OCI_ENV_CONTEXT|OCI_ENV_THREADED))
core info:
0x00002ae0fb715cf8 in skgesig_sigactionHandler () from
/home/uapp2/instantclient/libclntsh.so.11.1
Did anybody hear that oracle 11g(linux x64) had such bugs under multithread
Environment?
or did anybody have the similar problem?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using OCILIB 3.7.0
program is simple, but under mulithread environment
OCI_ExecuteStmt(pStmt,"select * from table");
OCI_GetResultset(pStmt);
while(OCI_FetchNext(rs))
{
......
}
OCI_ReleaseResultsets(pStmt);
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't think so, because I repeat doing the same work on the same table, it's
impossible that the 1-- N times right but the N+1 times error.
some people said that's maybe libclntsh.so.11.xxx's bug(about mutlithreaded
environment), using libclintsh.so.10.xxx is ok. But no official confirmation.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
when executing OCI_ReleaseResultsets,program crashed (not always,occasional)
multithead Environment, OCI_Initialize(NULL, NULL,
OCI_ENV_DEFAULT|OCI_ENV_CONTEXT|OCI_ENV_THREADED))
core info:
0x00002ae0fb715cf8 in skgesig_sigactionHandler () from
/home/uapp2/instantclient/libclntsh.so.11.1
Did anybody hear that oracle 11g(linux x64) had such bugs under multithread
Environment?
or did anybody have the similar problem?
Hi,
What version of OCILIB are you using ? Are you using array binds ?
Vincent
I'm using OCILIB 3.7.0
program is simple, but under mulithread environment
OCI_ExecuteStmt(pStmt,"select * from table");
OCI_GetResultset(pStmt);
while(OCI_FetchNext(rs))
{
......
}
OCI_ReleaseResultsets(pStmt);
Program terminated with signal 7, Bus error
if don't OCI_ReleaseResultsets(), do you get the crash in OCI_StatementFree()
?
the crash happens occasionally , my program has run for several months ,only
happend once.
OCI_StatementFree only when program exits
It looks like a buffer overwrite... Are you sure that at some point yu don't
overwrite a resultset content date ?
I don't think so, because I repeat doing the same work on the same table, it's
impossible that the 1-- N times right but the N+1 times error.
some people said that's maybe libclntsh.so.11.xxx's bug(about mutlithreaded
environment), using libclintsh.so.10.xxx is ok. But no official confirmation.