4.10 Threading issue with a service (BIG ISSUE FOR US)

oodesigns · Post by **oodesigns** » Thu 27 Sep 2007 09:15

Hi

I am having an issue converting from 3.55 to 4.10 .

We have a threaded NT service that works OK (we have been using for some time with many thousands of users).

When we use 4.10 start the service so it connects to a database then turn the machine off. I am using Win 2003 server. It takes long time to shut down the MACHINE when using driver 4.10 ie a few minutes.

When using 3.55 it takes 7 seconds to shut down .
This is VERY repeatable.

I must say that if I start / stop the service it takes no time at all, it is just when the machine is turned off. I have tried logging etc.. and cannot see where it is taking the time

Any thoughts as we need to be able to support Windows 2003 Server. If I use 3.55 I can get round this issue BUT cannot support Vista.

All the best (and worrried)

Mike

oodesigns · Post by **oodesigns** » Thu 27 Sep 2007 10:17

I

More information.

I have test with the last version of 3.80.0.38 07.06.07 and it works to the extent that the server machine shuts down as expected.

Mike

oodesigns · Post by **oodesigns** » Thu 27 Sep 2007 10:33

Hi

Tried 4.00.0.6 20.04.07 and it did take it's time like the other version of 4
for the machine to shut down.

Mike

Antaeus · Post by **Antaeus** » Fri 28 Sep 2007 10:26

Please make a small test service application that reproduces this problem and send this application to us at evgeniyd*crlab*com for test. Also include the script to create server objects used by the application.

oodesigns · Post by **oodesigns** » Fri 28 Sep 2007 12:34

Please I do not have the resources at the moment. Please can you do this as it would be a useful testing tool for yourselves!

Write NT Service
create thread
connect to database
Create Query + Store proce objects
Do nothing more....

Close Machine

The machine waits a few minutes to close if using any version 4 of the application.

yeohray · Post by **yeohray** » Sat 29 Sep 2007 05:40

Perhaps you could use SQL Profiler to run a trace to log the events to a database table or log file when you close the machine, and compare the events that are generated for both versions 3 and 4 of SDAC.

oodesigns · Post by **oodesigns** » Mon 01 Oct 2007 05:49

Hi

I will give it a try, later on but I am doing NOTHING with the database except copnnected to it. Unless your components do something else?.

Please can YOU not try yourselves?

Mike

Antaeus · Post by **Antaeus** » Mon 01 Oct 2007 09:37

I created a test service application following the steps you have provided, but could not reproduced this problem. If the service application is run, time of my computer shutdown is the same.

oodesigns · Post by **oodesigns** » Mon 01 Oct 2007 12:57

Hi

Could you please send the source / exe to me I will try it on one of our servers.

Mike

Antaeus · Post by **Antaeus** » Tue 02 Oct 2007 08:09

I have sent the exe file and sources of my service to you by e-mail.

oodesigns · Post by **oodesigns** » Tue 02 Oct 2007 09:45

Hi

Thanks very much for that. Could you please email them to [email protected] as well as I cannot access the other account at present.

Mike

Antaeus · Post by **Antaeus** » Tue 02 Oct 2007 10:35

I have forwarded them to the specified address.