OCI calls either hang or don't return in Oracle Failsafe failover

From: Alex <alexdia_at_pacbell.net>
Date: 15 Feb 2002 20:02:38 -0800
Message-ID: <dff07522.0202152002.22525d63@posting.google.com>

Hello,

I've been attempting to test my application server stability in Oracle failover situations.

In some situations, the application seemed to go into a deadlock. After much troubleshooting, I've found that OCI calls sometimes seem to hang at a certain point once failover operation is triggered.

I was expecting that I would get an exception condition, however, this does not seem to be the case. Actually, I do get an exception condition, but not _always_ .

I believe it would be most relevant to mention that I am using Oracle Fail Safe ( release 3.1.2 ) and Oracle 8i release 8.1.7 on Win2K to maintain the database clusters which are set up in conjunction with MS clustering installation as suggested. The actual database failover process works well once no application OCI calls are made at the time of failover.

Is there any solution or workaround to this ? Is this a known problem ?

For example, via the debugger, I get this call stack:

NTDLL! 77f827e8()
NTDLL! 77f838c6()

ORANL8! 60a0c691()
ORANL8! 60a19879()
ORANL8! 60a19638()
ORANL8! 60a1997c()
ORAN8! 60b11f5a()

ORAN8! 60b61d81()
ORAN8! 60b61cbf()

ORACLIENT8! 60429b1e()
ORACLIENT8! 604b4695()
ORACLIENT8! 604b9ece()
ORACLIENT8! 604b9f1a()
ORACLIENT8! 604bbbfd()
ORACLIENT8! 604bcc68()
ORACLIENT8! 60482944()
ORACLIENT8! 604698a0()

OCIW32! 04661e7c()
DbOrclI::OLog(cda_def * 0x0aac7940, unsigned char * 0x0aac7980, unsigned char * 0x040b2b40, int -1, unsigned char * 0x040b2974, int -1, unsigned char * 0x040b201c, int -1, unsigned long 0) line 279 + 42 bytes
DbOrclStoreC::connect(const char * 0x040b201c, const char * 0x040b2b40, const char * 0x040b2974) line 417 + 44 bytes DbOrclStoreC::DbOrclStoreC(int 6, const char * 0x040b201c, const char * 0x040b2b40, const char * 0x040b2974, unsigned int 40) line 252 DbStoreFactoryC::Create(ServerConfigI::DatabaseVendorT DATABASE_VENDOR_ORCL, int 6, const char * 0x040b201c, const char * 0x040b2b40, const char * 0x040b2974, unsigned int 40) line 440 + 54 bytes

DbMgrC::createConnection(unsigned int 6) line 573 + 62 bytes
DbMgrC::getConnection(unsigned char 1) line 367 + 10 bytes
DbMgrC::GetSerializableConnection() line 293

Feedback is very much appreciated.

Thanks,

Alex

Received on Fri Feb 15 2002 - 22:02:38 CST