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]
--
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
Craig Stuntz [TeamB]
> 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?
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
http://www.catb.org/~esr/faqs/smart-questions.html
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.
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
What do you see in interbase.log? Also, which edition of IB are you
>using?
>
>--
>Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
> Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>How to ask questions the smart way:
> 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
Dan Palley
interbase locally. Try connecting to it as a remote server using LOCALHOST:
as the server name.
Dan
"Nick Soethof" <nicksoethof[nospam]@gmail.com> wrote in message
news:45081447$1...@newsgroups.borland.com...
Wayne Niddery [TeamB]
>
> 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.
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Nurture your mind with great thoughts. To believe in the heroic makes
heroes." — Benjamin Disraeli
Craig Stuntz [TeamB]
> 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
That can't be all of it.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Useful articles about InterBase development:
http://blogs.teamb.com/craigstuntz/category/21.aspx
Nick Soethof
> That can't be all of it.
>
>--
>Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
> Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>Useful articles about InterBase development:
> 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
Nick Soethof
"Dan Palley" <d...@trams.com> wrote:
>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
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 Soethof
>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.
Craig Stuntz [TeamB]
> 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
--
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
Nick Soethof
> 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
>
>--
>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]
> 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.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Everything You Need to Know About InterBase Character Sets:
http://blogs.teamb.com/craigstuntz/articles/403.aspx
Dan Palley
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
news:4509...@newsgroups.borland.com...
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]
> 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.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt
your DBs! Open Edition users, get 6.0.1.6 from http://mers.com
Nick Soethof
>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
> 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.
--
Bill Todd (TeamB)