In article <19930126.100713.257@almaden.ibm.com> pbenton@vnet.ibm.com writes:
>Can anyone help with the following questions ?
>
>Occasionally, its sqlexec child process terminates. The parent
>process traps the SIGCLD (UNIX) signal and executes a siglongjmp()
>(UNIX system call) to recovery code (set up with the sigsetjmp()
>UNIX system call). The recovery code includes calling sqlexit()
>and sqlstart() to clean up and start up a new sqlexec process.
>The database is then opened again. However, when the process
>again PREPAREs all the SQL statements, Informix returns the error
>code -258 "System error--invalid statement ID received by the
>sqlexec process". The process tries periodically to PREPARE the
>SQL statements until it's successful, but Informix continues to
>return the same error code. Only in a few cases did Informix
>successfully PREPARE some (but not all) of the SQL statements
>after several attempts by the process.
You need to issue a CLOSE DATABASE statement to clean up all the
structs in the client program. The sqlexit() only terminates the
server process - it has no effect on the structures previously
allocated in the application.
Dave
--
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney