Kbase P96116: Ctrl-C during the query process causes the oracle connection to be disconnected
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX 11i 64-bit
OpenEdge 10.0A
Oracle DataServer
SYMPTOM(s):
Ctrl-C during the query process causes the oracle connection to be disconnected
Press ctrl-C while the query is performing long sort in the oracle database
The following error displays in the UNIX terminal:
SYSTEM ERROR: Bad return from select, errno=26. (784)
ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)
** sltln: environment variable cannot be evaluated.
Press space bar to continue.
Failed to connect to ORACLE database <db_name>. (1451)
User has to quit and restart the application
This problem happen frequently if query is stopped before anything has been returned
The DataServer license, the Application and the Oracle database resides on the same machine.
User is connecting to the Oracle database through the DataServer broker, _probrkr, as a remote connection
The ps grep shows quite a few _orasrv processes are in the idle state
CAUSE:
The exact cause is unknown as to why the progress broker connection would terminate upon pressing the ctrl-C, hence, the _progres process loses the Oracle connection. This losing of connection to the broker also causes the _orasrv to become an orphan process.
FIX:
The workaround is to not use the DataServer broker since the DataServer and the application are on the same machine.