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

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
oodesigns
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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
Posts: 56
Joined: Mon 26 Mar 2007 01:25

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 26
Joined: Wed 04 Oct 2006 01:41

Post by oodesigns » Tue 02 Oct 2007 09:45

Hi

Thanks very much for that. Could you please email them to mike@worksmart.co.uk as well as I cannot access the other account at present.

Mike

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 02 Oct 2007 10:35

I have forwarded them to the specified address.

Post Reply