sqlexit funny behavior
Posted in 1997
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
Greetings, We have several server-type applications when started, open a database, read tables for initialization, close the database via E/SQL and then remain idle for hours or days until called upon. This situation seemed perfect for sqlexit to free the database resources used during initialization. When the servers' initialization are finished, sqlexit is called after the CLOSE DATABASE statement. The problem appears when the server wakes up, does its work, closes the database and then calls sqlexit for the second time. From the debugger, the server goes into an infinite loop inside sqlexit. The stack track shows an infinite loop in the following routines: sqlexit killbackend wait _wait_sys $cerror The ESQL product is INFORMIX-ESQL Version 5.03.UC1 The On-Line server is RSAM Version 5.03.UC1 The hardware and OS are HP-UX 09.01 A 9000/755 and HP-UX 10.20 A 9000/755. The sqlexit routine would be a very nice thing to have working properly in these server applications. What I am doing wrong? Any help and/or advice would be appreciated on this. Thanks! mgo -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet