I am having trouble managing a Interbase XE
The database sustains about 300 transactions per second, and I am trying to verify lock-related performance, since some deadlocks are popping up during busy hours.
I try to execute iblockpr.exe from Interbase XE update 3 (10.0.5.595) with the the following error:
-----------------------
C:\Embarcadero\InterBase>bin\iblockpr.exe -i
Unable to access lock table.
\Embarcadero\InterBase\/SRVDB01.lck
operating system directive CreateFile failed
----------------------
Vote for best question.
Score: 0
# Vote: 0
Date Posted: 15-Oct-2014, at 11:31 AM EST
From: Fernando Korndoefer
Re: Error when trying view lock table with iblockpr.exe
Try InterBase XE3 server instead. It's possible the newer iblockpr does
not work with the older server.
Fernando Korndoefer wrote:
> Upgraded iblockpr.exe from version 10.0.5.595 to 11.0.4.810, copied from XE3U5.
>
> While I point %INTERBASE% environment to the Intarbase install directory, iblockpr still creates the file "C:\HOSTNAME.lck" with defaultsize of 256Kb (V4_LOCK_MEM_SIZE is set to 512Kb) and spits the message "Unable to read lock table version 0".
>
> Any thoughts?
Vote for best answer.
Score: 0
# Vote: 0
Date Posted: 20-Oct-2014, at 2:52 PM EST
From: quinn wildman
Re: Error when trying view lock table with iblockpr.exe
Thanks for the tip!
Upgraded iblockpr.exe from version 10.0.5.595 to 11.0.4.810, copied from XE3U5.
While I point %INTERBASE% environment to the Intarbase install directory, iblockpr still creates the file "C:\HOSTNAME.lck" with defaultsize of 256Kb (V4_LOCK_MEM_SIZE is set to 512Kb) and spits the message "Unable to read lock table version 0".
Any thoughts?
> {quote:title=quinn wildman wrote:}{quote}
> Fernando Korndoefer wrote:
> > The paths exist and the lock file exists, but no luck.
> > The message changed, though. It seems iblockpr tries to access the file as network resource, causing the previous message. Would this be because the "/" iblockpr prepends to the file name?
> > But now I think I'm just hitting INTB-1459...
>
>
> Oh, now I recall that iblockpr does not work with InterBase XE on
> Windows. If you need it, get it from XE3 developer edition.
Vote for best answer.
Score: 0
# Vote: 0
Date Posted: 20-Oct-2014, at 8:55 AM EST
From: Fernando Korndoefer
Re: Error when trying view lock table with iblockpr.exe
Fernando Korndoefer wrote:
> The paths exist and the lock file exists, but no luck.
> The message changed, though. It seems iblockpr tries to access the file as network resource, causing the previous message. Would this be because the "/" iblockpr prepends to the file name?
> But now I think I'm just hitting INTB-1459...
Oh, now I recall that iblockpr does not work with InterBase XE on
Windows. If you need it, get it from XE3 developer edition.
Vote for best answer.
Score: 0
# Vote: 0
Date Posted: 17-Oct-2014, at 3:47 PM EST
From: quinn wildman
Re: Error when trying view lock table with iblockpr.exe
Hi
The paths exist and the lock file exists, but no luck.
The message changed, though. It seems iblockpr tries to access the file as network resource, causing the previous message. Would this be because the "/" iblockpr prepends to the file name?
But now I think I'm just hitting INTB-1459...
--
c:\Embarcadero\InterBase\bin>set INTERBASE=c:\Embarcadero\InterBase\
c:\Embarcadero\InterBase\bin>iblockpr.exe -i
*Unable to access lock table - file too small.*
c:\Embarcadero\InterBase\/SRVDB01.lck
--
> {quote:title=quinn wildman wrote:}{quote}
> Try specifying InterBase environment variable which equals when
> InterBase is installed before running iblockpr.
>
> The iblockpr printout is pretty cryptic. Good luck with it.
>
> Fernando Korndoefer wrote:
> > I am having trouble managing a Interbase XE
> >
> > The database sustains about 300 transactions per second, and I am trying to verify lock-related performance, since some deadlocks are popping up during busy hours.
> >
> > I try to execute iblockpr.exe from Interbase XE update 3 (10.0.5.595) with the the following error:
> > -----------------------
> > C:\Embarcadero\InterBase>bin\iblockpr.exe -i
> > Unable to access lock table.
> > \Embarcadero\InterBase\/SRVDB01.lck
> > operating system directive CreateFile failed
> > ----------------------
> >
Vote for best answer.
Score: 0
# Vote: 0
Date Posted: 17-Oct-2014, at 9:09 AM EST
From: Fernando Korndoefer
Re: Error when trying view lock table with iblockpr.exe
Try specifying InterBase environment variable which equals when
InterBase is installed before running iblockpr.
The iblockpr printout is pretty cryptic. Good luck with it.
Fernando Korndoefer wrote:
> I am having trouble managing a Interbase XE
>
> The database sustains about 300 transactions per second, and I am trying to verify lock-related performance, since some deadlocks are popping up during busy hours.
>
> I try to execute iblockpr.exe from Interbase XE update 3 (10.0.5.595) with the the following error:
> -----------------------
> C:\Embarcadero\InterBase>bin\iblockpr.exe -i
> Unable to access lock table.
> \Embarcadero\InterBase\/SRVDB01.lck
> operating system directive CreateFile failed
> ----------------------
>
Mega Search
Sign Up 
