#1  
Old 16th July 2003, 12:41 AM
Miro Hryckowiak
 
Posts: n/a
Default EM beta 4 & nexusDB beta 4 on the same machine - bug?

Hi,

NexusDB b4
Enterprise Manager b4

Running NexusDB and EM on the same machine and having aliases pointing to
the same files created withn NexusDB and EM (Internal Server) causing EM to
not being able to connect to the "remote" database.
Here is the log fragment:

2003-07-15 14:20:58 21696307 3752 Exception Cvt: NexusDB: INTERNAL:
File could not be opened [K:\nexusDB\tester\nxTrans.cfg, error 32, The
process cannot access the file because it is being used by another process]
[$2405/9221]

Tried with different network configuration on the NexusDB (only NP, only
TCP, both NP and TCP).

Is the EM Internal server locking that cfg file?

To manage the databases one have to delete the alias from within the EM
(Internal Server). Then access to the NexusDB databases on the same machine
(via NexusDB@192.168.0.xxx) is possible.

Suggestion - some check if there is already NexusDB running and prevent to
start the EM Internal Server in that case?

Best,
Miro


  #2  
Old 16th July 2003, 12:51 AM
Franz-Leo Chomse [NDX]
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?


>Is the EM Internal server locking that cfg file?


Like FlashFiler the nexus servers are opening the files exclusively.
Thus only one server can access the files at the same time.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)
  #3  
Old 16th July 2003, 01:13 AM
miab
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?

Franz-Leo Chomse [NDX] <franz.leo.chomse@ndx.nexusdb.com> wrote:
>> Is the EM Internal server locking that cfg file?

>
> Like FlashFiler the nexus servers are opening the files exclusively.
> Thus only one server can access the files at the same time.


But embedded alias is bloking TCP/IP access.

miab

  #4  
Old 16th July 2003, 01:32 AM
Franz-Leo Chomse [NDX]
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?


>But embedded alias is bloking TCP/IP access.


The transport doesn't matter. Only one server can access the same
physical file at the same time.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)
  #5  
Old 16th July 2003, 01:36 AM
miab
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?

Franz-Leo Chomse [NDX] <franz.leo.chomse@ndx.nexusdb.com> wrote:
>> But embedded alias is bloking TCP/IP access.

>
> The transport doesn't matter. Only one server can access the same
> physical file at the same time.


_embedded alias_ not acces to data.

miab

  #6  
Old 16th July 2003, 01:56 AM
Franz-Leo Chomse [NDX]
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?


>_embedded alias_ not acces to data.


if you try to open a table in a directory which is used by the
stand alone server the embedded server can not access it.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)
  #7  
Old 16th July 2003, 02:10 AM
miab
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?

Franz-Leo Chomse [NDX] <franz.leo.chomse@ndx.nexusdb.com> wrote:
>> _embedded alias_ not acces to data.

>
> if you try to open a table in a directory which is used by the
> stand alone server the embedded server can not access it.


If I try open table by the stand alone server in directory wich have
embedded alias I can not acces it.

miab

  #8  
Old 16th July 2003, 09:03 AM
Hannes Danzl [NDD]
 
Posts: n/a
Default Re: EM beta 4 & nexusDB beta 4 on the same machine - bug?

this is as designed.

for working with data files a serverengine needs exclusive access to a
database. a database is with the current RecordEngine defined as a directory
on the disk, thus when setting an alias and opening tables in it they are
opened exclusively.
if now a second serverengine (other dedicated server or embedded server)
tries to access this table (file) it rhows above exception. NexusDB is a
real Client/Server database and does NOT allow filesharing.
please note that the above situation is working on a first-come,
first-server method, thus the first serverngine to open a file gets access
and then locks it. the subsequent tries of any other serverengine will fail
until the file is closed by the original engine. please also note that
closing the tnxtable is NOT enough to ensure the table file is closed on the
server side. that's due to caching/performance reasons.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm


"Miro Hryckowiak" <firstmiro.NOSPAM@wp.pl> wrote in message
news:3f13f5dd@wic040d....
> Hi,
>
> NexusDB b4
> Enterprise Manager b4
>
> Running NexusDB and EM on the same machine and having aliases pointing to
> the same files created withn NexusDB and EM (Internal Server) causing EM

to
> not being able to connect to the "remote" database.
> Here is the log fragment:
>
> 2003-07-15 14:20:58 21696307 3752 Exception Cvt: NexusDB:

INTERNAL:
> File could not be opened [K:\nexusDB\tester\nxTrans.cfg, error 32, The
> process cannot access the file because it is being used by another

process]
> [$2405/9221]
>
> Tried with different network configuration on the NexusDB (only NP, only
> TCP, both NP and TCP).
>
> Is the EM Internal server locking that cfg file?
>
> To manage the databases one have to delete the alias from within the EM
> (Internal Server). Then access to the NexusDB databases on the same

machine
> (via NexusDB@192.168.0.xxx) is possible.
>
> Suggestion - some check if there is already NexusDB running and prevent

to
> start the EM Internal Server in that case?
>
> Best,
> Miro
>
>





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NexusDB V3.00 beta 3 released Hannes Danzl[NDD] nexusdb.public.announcements 0 7th May 2009 09:20 PM
NexusDB V3 Public Beta 2 available now. Hannes Danzl[NDD] nexusdb.public.announcements 0 23rd March 2009 01:57 PM
NexusDB V3 beta 1 survey Hannes Danzl[NDD] nexusdb.public.announcements 0 13th February 2009 02:59 PM
NexusDB V3 Public Beta 1 available now. Hannes Danzl[NDD] nexusdb.public.announcements 0 28th January 2009 12:09 AM
NexusDB Beta 3 and Dotnet Provider Beta 17 Bernhard Roos nexusdb.public.support.adoprovider 1 31st January 2006 05:26 AM


All times are GMT +11. The time now is 08:46 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.