dbTalk Databases Forums  

unstable server

comp.databases.informix comp.databases.informix


Discuss unstable server in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bill Hamilton
 
Posts: n/a

Default unstable server - 08-09-2011 , 08:21 PM






I have one Windows 2008 server running 11.70.TC1IE that requires a restart 2-5 times a day.
The web service (IIS) and all com objects and other programs and my services are running on the same server.
The ODBC driver is the one from the bundle.

The trouble seems to begin with this error:
“Desc:[Informix][Informix ODBC Driver]
General error.Not enough space for parser stacks Src:Microsoft OLE DB Provider for ODBC Drivers Info:
Message:'IDispatch error #3092' “

It can occur in any program.Then IDS refuses all connections.
I have increased STACKSIZE to 256 and the problem persists.
Is there anyway to find out what is causing this?
Would the “parser stacks” be some stacks inside ODBC driver or IIS?

The customer is afraid for me to install TC3IE until their busy season is over or I would have done that already.

Reply With Quote
  #2  
Old   
fbyte13@googlemail.com
 
Posts: n/a

Default Re: unstable server - 08-11-2011 , 09:24 AM






That error appears to be generated in the ODBC driver not in the IDS
server ([Informix][Informix ODBC Driver]) so changes in the engine
side wouldn't make much difference.
That problem usually appears when the SQL parser inside the ODBC
driver gets out of memory.
You can try disable the SQL parsing with the SKIPPARSING option:

http://publib.boulder.ibm.com/infoce...s_odbc_044.htm

Still, I suggest to move to the latest 3.70.TC3, it contains more bug
fixes than plain TC1

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.