Weird MTS Problem

[Vinodpillai]

I am using an ActiveX Dll built using Vb6.0 and MTS 2.0. Backend is Oracle 8.0.5 with patch 80525. The application server is Compaq P6 - Winnt 4.0 SP6 , 1 GB ram , 20GB HDD dual processor.
The mtx.exe size increses upto 50MB plus and then the system does not allow users to connect to the application server. There is no message in event viewer and no .trc files generated. We are using Microsoft odbc for Oracle. And have installed MDAC2.5.

Generally all that our code does is that it has 2 classes:
one a queryclass that takes a queryid and a recordset from the client and internally it fetches the query from oracles replaces it values and then fires the query. The output is sent back to the client.

In other classes all that we do is call the query class to update data and maybe execute a stored proc etc.

We have checked for mem leaks by setting all declared objects to nothing. Also after closing each module we waited for the timeout time to see if mtx.exe is disappearing. This has worked fine.

But now either the app server hangs or the performance gets slow.

Can u help us with some tools or ideas to track and solve this problem. Any mem leak tools that are available.

 

[Guest_imported]

Vinod,

Facing the same problem. Have found two reasons why this happens. Suppose your class is having method expecting 3 params but from the asp page where u are calling u miss one or more parameters this happens, we have reproduced this.

an other reason is invalid class references, suppose you have two dlls 1 & 2, 2 refers to 1, 1 was recompiled with non-project compatability and gets hosted but 2 is still have references to the old class ids.

I myself is in lookout as to how to find out automatically with the help of some tools as to what asp gets hung.

Do tell me also later if you find some tools.

Cheers,
Sujay

 

[Guest_imported]

Hi Vinodpillai,
Did you ever solve this problem, if so what was the cause?


James

 

[Vinodpillai]

We have not yet solved this problem. We have had Microsoft, oracle etc review code, check our app servers put patches etc, but non have resolved the problem. The issue becomes sever at times when the system gets hanged.
Primarily we have been able to reduce it. Like if you execute any long running procedures from the same class that others could use to query data then the server hangs.
eg I have a query class with a method fetch data and Execute procedure in it. Then if someone calls execute proc the class sometimes seems to hang for all. When u look into oracle u could find a single session with multiple cursors in it. This you can view thru plsql developer tool. We are currently looking at xtremesoft site for their tool to trace MTS.
If I have any solution I will post it up here.