Interbase 7.1 won't start as a service in Windows Vista

[Nick Soethof]

I'm trying to make a product vista certified and our product uses interbase 7.1.0.189.

The problem though is that, although the service is started autmatically, I need to start it manually via the console in order to work correctly.

The log file came up with just the usual:
SERVER/set_process_affinity: setting ProcessAffinityMask to 1
Guardian starting: C:\Program Files\Interbase corp\Interbase\Bin\ibserver.exe

Is there a way to fix this problem?

[Craig Stuntz [TeamB]]

Can you clarify what the problem is? I can't tell from your message.

[Nick Soethof]

Post by Craig Stuntz [TeamB]
Can you clarify what the problem is? I can't tell from your message.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their
server: http://support.borland.com/entry.jspa?externalID=293

the service is set to autmatic and claims to be "started" (according to the services manager) although it does not run. When I start my application I get an error that I can't connect to the database (which seems logical because interbase isn't running).

When I connect to the database manually via IBcons.exe it notifies me the following: "The server has not been started. Would you like to start it now?". After starting it manually, my application works fine.


So the problem is that although the services manager is claiming it's running, it is not. Resulting in a problem opening the database in my application. I haven't had this problem in Windows XP sp2

[Craig Stuntz [TeamB]]

Post by Nick Soethof
the service is set to autmatic and claims to be "started" (according
to the services manager) although it does not run. When I start my
application I get an error that I can't connect to the database
(which seems logical because interbase isn't running).

What do you see in interbase.log? Also, which edition of IB are you
using?

[Nick Soethof]

What do you see in interbase.log? Also, which edition of IB are you

Post by Craig Stuntz [TeamB]
using?
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
http://www.catb.org/~esr/faqs/smart-questions.html

interbase 7.1.0.189.
The log file:
SERVER/set_process_affinity: setting ProcessAffinityMask to 1
Guardian starting: C:\Program Files\Interbase corp\Interbase\Bin\ibserver.exe

Eventviewer came up with the following:

InterBaseServer error: 1063
StartServiceCtrlDispatcher failed

[Craig Stuntz [TeamB]]

Post by Nick Soethof
interbase 7.1.0.189.
SERVER/set_process_affinity: setting ProcessAffinityMask to 1
Guardian starting: C:\Program Files\Interbase
corp\Interbase\Bin\ibserver.exe

That can't be all of it.

[Nick Soethof]

Post by Craig Stuntz [TeamB]
That can't be all of it.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
http://blogs.teamb.com/craigstuntz/category/21.aspx

Entire interbase.log

VISTA-PC (Server) Fri Sep 08 15:53:19 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Fri Sep 08 15:53:19 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Fri Sep 08 15:53:20 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client) Fri Sep 08 16:06:52 2006
C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe: normal shutdown


VISTA-PC (Server) Fri Sep 08 16:06:53 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Fri Sep 08 16:06:53 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Fri Sep 08 16:13:48 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 11:38:44 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 11:38:44 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 11:38:44 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 14:07:48 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 14:07:48 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 14:07:49 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 14:23:06 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 14:23:06 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 14:23:06 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 14:31:38 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 14:31:38 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 14:31:39 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 14:59:30 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 14:59:30 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 14:59:31 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Mon Sep 11 15:25:53 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Mon Sep 11 15:25:53 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Mon Sep 11 15:25:54 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Tue Sep 12 15:56:18 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Tue Sep 12 15:56:18 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Tue Sep 12 15:56:20 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Tue Sep 12 16:07:49 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Tue Sep 12 16:07:49 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Tue Sep 12 16:07:50 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Wed Sep 13 08:23:30 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Wed Sep 13 08:23:30 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Wed Sep 13 08:23:30 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client) Wed Sep 13 14:31:24 2006
C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe: normal shutdown


VISTA-PC (Server) Wed Sep 13 14:31:25 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Wed Sep 13 14:31:25 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Server) Wed Sep 13 15:33:51 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Wed Sep 13 15:33:51 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Wed Sep 13 15:33:52 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client) Wed Sep 13 16:32:12 2006
C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe : The guardian was unable to launch the server thread. errno : 1053

VISTA-PC (Server) Wed Sep 13 16:37:37 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Wed Sep 13 16:37:37 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Wed Sep 13 16:37:38 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server) Wed Sep 13 16:50:51 2006
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
and MAX_THREADS to 1


VISTA-PC (Server) Wed Sep 13 16:50:51 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client) Wed Sep 13 16:50:52 2006
Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe

[Craig Stuntz [TeamB]]

Post by Nick Soethof
VISTA-PC (Server) Wed Sep 13 16:50:51 2006
SERVER/set_process_affinity: setting ProcessAffinityMask to 1
VISTA-PC (Client) Wed Sep 13 16:50:52 2006
Guardian starting: C:\Program Files\Interbase
Corp\Interbase\Bin\ibserver.exe

OK, I see this over and over again in your log: Setting the affinity
mask, then the server apparently crashes and Guardian tries to restart
it.

Now Vista isn't a supported OS, being pre-release and all, but I can't
think of a reason why IB shouldn't work on it.

So some additional questions:

o Does IB work if you start the Guardian service manually via the
service control manager (Control Panel->Administrative Tools->Services)
instead of automatically at system startup?

o What is the contents of your IBConfig?

-Craig

[Nick Soethof]

Post by Craig Stuntz [TeamB]
OK, I see this over and over again in your log: Setting the affinity
mask, then the server apparently crashes and Guardian tries to restart
it.
Now Vista isn't a supported OS, being pre-release and all, but I can't
think of a reason why IB shouldn't work on it.
o Does IB work if you start the Guardian service manually via the
service control manager (Control Panel->Administrative Tools->Services)
instead of automatically at system startup?
o What is the contents of your IBConfig?
-Craig
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio González has a new CD of
Irish music out, and it's good: http://tinyurl.com/7hgfr

1) I've disabled automatic startup, restarted the computer, started the service (the guardian) manually but still no luck.
Both processes (ibguard.exe & ibserver.exe) are running but I'm not logged in to the database


2) Followed my ibconfig. I've removed the comments from it.
#ADMIN_DB "admin.ib"

#ANY_EVENT_MEM_SIZE 32768

#ANY_LOCK_MEM_SIZE 98304

#ANY_LOCK_SEM_COUNT 32

#ANY_LOCK_SIGNAL 16

#CPU_AFFINITY

#CONNECTION_TIMEOUT 180

#DATABASE_CACHE_PAGES 2048

#DEADLOCK_TIMEOUT 10

#DUMMY_PACKET_INTERVAL 0

#ENABLE_HYPERTHREADING 1

#EXTERNAL_FILE_DIRECTORY

#EXTERNAL_FUNCTION_DIRECTORY

#LOCK_ACQUIRE_SPINS 0

#LOCK_HASH_SLOTS 101

#MAX_THREADS 1000000

#SERVER_CLIENT_MAPPING 4096

#SERVER_PRIORITY_CLASS 1

#SERVER_WORKING_SIZE_MAX 0

#SERVER_WORKING_SIZE_MIN 0

#SORTMEM_BUFFER_SIZE 1048500

#SWEEP_QUANTUM 250

#SWEEP_YIELD_TIME 1

#TCP_REMOTE_BUFFER 8192

#TMP_DIRECTORY

#USER_QUANTUM 1000

#V4_EVENT_MEMSIZE 32768

#V4_LOCK_GRANT_ORDER 1

#V4_LOCK_MEM_SIZE 98304

#V4_LOCK_SEM_COUNT 32

#V4_LOCK_SIGNAL 16

#V4_SOLARIS_STALL_VALUE 60

[Craig Stuntz [TeamB]]

Post by Nick Soethof
1) I've disabled automatic startup, restarted the computer, started
the service (the guardian) manually but still no luck. Both
processes (ibguard.exe & ibserver.exe) are running but I'm not logged
in to the database

It isn't clear that they're actually running. From your interbase.log
it appears that the server is crashing as soon as it starts, and
Guardian is continuously restarting it.

The log suggests that setting the CPU affinity (or whatever the server
does immediately after that) may be causing the problem. Perhaps Vista
has changed something in this API call, or perhaps this part of Vista
has a bug. I'm not sure.

I was wondering if the CPU_AFFINITY was set in your IBConfig, but it's
commented out, so you must be getting the default setting.

At this point I'm not sure what you can do to solve the problem other
than reinstalling IB on a machine with a supported operating system.
You could try calling support, but they may just tell you that Vista is
not supported yet.

[Dan Palley]

Are you running in a Remote Desktop session? Sounds like you cannot access
interbase locally. Try connecting to it as a remote server using LOCALHOST:
as the server name.

Dan

Post by Nick Soethof

Post by Craig Stuntz [TeamB]
Can you clarify what the problem is? I can't tell from your message.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their
server: http://support.borland.com/entry.jspa?externalID=293

the service is set to autmatic and claims to be "started" (according to
the services manager) although it does not run. When I start my
application I get an error that I can't connect to the database (which
seems logical because interbase isn't running).
When I connect to the database manually via IBcons.exe it notifies me the
following: "The server has not been started. Would you like to start it
now?". After starting it manually, my application works fine.
So the problem is that although the services manager is claiming it's
running, it is not. Resulting in a problem opening the database in my
application. I haven't had this problem in Windows XP sp2

[Nick Soethof]

Post by Dan Palley
Are you running in a Remote Desktop session? Sounds like you cannot access
as the server name.
Dan

I'm running it locally. Remote would be the next step. In IBcons.exe there is a local server but it is not started. In windows XP, it was.

[Dan Palley]

Post by Nick Soethof

Post by Dan Palley
Are you running in a Remote Desktop session? Sounds like you cannot access
as the server name.
Dan

I'm running it locally. Remote would be the next step. In IBcons.exe there
is a local server but it is not started. In windows XP, it was.

Nick, if the server is running (services shows as started), then it really
looks like a local connection issue. Try connecting as a remote server and
let us know what happens. I have RC1 running here -- I'll load IB 7.1 and
give it a try.

Dan

[Dan Palley]

Post by Dan Palley

Post by Nick Soethof

Post by Dan Palley
Are you running in a Remote Desktop session? Sounds like you cannot access
as the server name.
Dan

I'm running it locally. Remote would be the next step. In IBcons.exe
there is a local server but it is not started. In windows XP, it was.

Nick, if the server is running (services shows as started), then it really
looks like a local connection issue. Try connecting as a remote server
and let us know what happens. I have RC1 running here -- I'll load IB 7.1
and give it a try.

Ok, it looks like Fast User Switching is enabled in all versions of Vista
(unlike just home in XP) and cannot be disabled (as far as I can tell).
When Fast User Switching is enabled, you won't be able to connect to
Interbase via a local connection (fast user switching uses Remote Desktop).

For now, you'll need to prefix your database alias with LOCALHOST: and
create a remote connection in IB Console to access Interbase.

I created a QC entry to alleviate this problem
(http://qc.borland.com/wc/qcmain.aspx?d=11504), but it was marked as 'Won't
Do' saying Terminal Server is not supported. I think Interbase folks need
to revisit this issue, as it's only going to get worse with Vista.

Dan

[Craig Stuntz [TeamB]]

Post by Dan Palley
I created a QC entry to alleviate this problem
(http://qc.borland.com/wc/qcmain.aspx?d=11504), but it was marked as
'Won't Do' saying Terminal Server is not supported. I think
Interbase folks need to revisit this issue, as it's only going to get
worse with Vista.

You can (and should) reopen the report by editing it to add this
information.

[Nick Soethof]

Post by Dan Palley
Ok, it looks like Fast User Switching is enabled in all versions of Vista
(unlike just home in XP) and cannot be disabled (as far as I can tell).
When Fast User Switching is enabled, you won't be able to connect to
Interbase via a local connection (fast user switching uses Remote Desktop).
For now, you'll need to prefix your database alias with LOCALHOST: and
create a remote connection in IB Console to access Interbase.
I created a QC entry to alleviate this problem
(http://qc.borland.com/wc/qcmain.aspx?d=11504), but it was marked as 'Won't
Do' saying Terminal Server is not supported. I think Interbase folks need
to revisit this issue, as it's only going to get worse with Vista.
Dan

)If I see it correctly, I need to register a server and make it remote instead of local and set up my host name as LOCALHOST?

)I've tried that and I still need to log in manually to be able to connect to the database. But I appriciate your effort :)

I, myself, don't have an account to access QC :(.

[Bill Todd]

Post by Nick Soethof
I, myself, don't have an account to access QC :(.

Anyone can access QC. All you need is a BDN login and anyone can create
a BDN login.

[Wayne Niddery [TeamB]]

Post by Nick Soethof
the service is set to autmatic and claims to be "started" (according
to the services manager) although it does not run. When I start my
application I get an error that I can't connect to the database
(which seems logical because interbase isn't running).
When I connect to the database manually via IBcons.exe it notifies me
the following: "The server has not been started. Would you like to
start it now?". After starting it manually, my application works
fine.

It sounds like you are using the developer's edition of Interbase shipped
with BDS 2006. You cannot deploy this version, you need to get a server
version for deployment.

[Nick Soethof]

Post by Wayne Niddery [TeamB]
It sounds like you are using the developer's edition of Interbase shipped
with BDS 2006. You cannot deploy this version, you need to get a server
version for deployment.
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Nurture your mind with great thoughts. To believe in the heroic makes
heroes." — Benjamin Disraeli

It is the server version according to my teamleader.