Message: NexusDB: INTERNAL: Error when reading from file [z:\ord\ITNETU.nx1, error 1006, The volume for a file has been externally altered

The error is raised from the nexusdb server (3.04.1)

Could be thas it is caused by an antivirus program (Clam antivirus is
installed)?

z: is an external USB hard disk

To solve the problem is necessary to stop and restart the server

Roberto

Time: [24070704] 26/08/2010 14.22.43
ExceptionInfo: nil
Exception: EnxDualWin32FileException
Message: NexusDB: INTERNAL: Error when reading from file [z:\ord\ITNETU.nx1,
error 1006, The volume for a file has been externally altered so that the
opened file is no longer valid] [$2401/9217]
Filesize: 7852544
Filedate: 2010-05-08 13.14.34
Computer: SERVERHP
User: SYSTEM
ThreadID: 3244
ProcessID: 296
Version: 3,0401
Client:
C:\Programmi\Master\Oroplus\V5\oroplus.exe;Size:60 420314;Date:2010-07-12
09.17.24;Computer:PC-FABBRICA;User:utente
SessionID: 2106002816
Connected From: 192.168.1.111:1272
--------------------------------------------------------------
Callstack (Frames):
[005AEA3E] nxsrFileImplWin32.TnxDualWin32File.ReadFileAt (Line 1626,
"nxsrFileImplWin32.pas")
[005AEB31] nxsrFileImplWin32.TnxDualWin32File.ReadFileExactAt (Line 1643,
"nxsrFileImplWin32.pas")
[005AD9ED] nxsrFileImplWin32.TnxBaseWin32File.ReadDecryptFile ExactAt (Line
1091, "nxsrFileImplWin32.pas")
[005AD8DF] nxsrFileImplWin32.TnxBaseWin32File.ReadBlock (Line 1071,
"nxsrFileImplWin32.pas")
[005BA5DE] nxsrBufferManager.TnxReadOnlyBlock.CacheBlockNeede d (Line 4801,
"nxsrBufferManager.pas")
[005B3981] nxsrBufferManager.TnxReadOnlyBlock.Block (Line 2365,
"nxsrBufferManager.pas")
[005B7ECB] nxsrBufferManager.TnxBufferManager.GetBlock (Line 4027,
"nxsrBufferManager.pas")
[005B97AA] nxsrBufferManager.TnxBlockAccess.GetBlock (Line 4493,
"nxsrBufferManager.pas")
[005B1102] nxsrBufferManager.TnxBaseFileHeaderAccess.AcquireH eader (Line
1456, "nxsrBufferManager.pas")
[007DACC6] nxseHeaderAccess.Tnx2xFileHeaderAccess.AcquireHead er (Line 450,
"nxseHeaderAccess.pas")
[005B11E5] nxsrBufferManager.TnxBaseFileHeaderAccess.Create (Line 1482,
"nxsrBufferManager.pas")
[005B14EA]
nxsrBufferManager.TnxBaseFileHeaderAccessFactory.C reateFileHeaderAccess
(Line 1567, "nxsrBufferManager.pas")
[005B9843] nxsrBufferManager.TnxBlockAccess.HeaderAccess (Line 4510,
"nxsrBufferManager.pas")
[005C1D5F] nxsrIndexEngineBase.TnxBaseIndexHeaderAccess.bhaGe tFileHeader
(Line 990, "nxsrIndexEngineBase.pas")
[007E1B09]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.ieNextKeyPrim
(Line 2142, "nxseIndexEngineStaticKeyBstarTree.pas")
[007E2F92]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.NextKey
(Line 2691, "nxseIndexEngineStaticKeyBstarTree.pas")
[0061E834] nxsrServerEngine.TnxServerTableCursor.sbcRecordGet Next (Line
12128, "nxsrServerEngine.pas")
[00618367] nxsrServerEngine.TnxServerBaseCursor.RecordGetNext (Line 9389,
"nxsrServerEngine.pas")
[008A9451] nxchCommandHandler.TnxServerCommandHandler.nmCurso rRecordGetNext
(Line 2754, "nxchCommandHandler.pas")
[0089E279] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line 609,
"nxchCommandHandler.pas")
[0053B976] nxllTransport.TnxBaseTransport.btProcess (Line 1802,
"nxllTransport.pas")
[00632342] nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived
(Line 3012, "nxptBasePooledTransport.pas")
[0063200B] nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived
(Line 2894, "nxptBasePooledTransport.pas")
[00639CC9] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
632, "nxtwWinsockTransport.pas")
[00639C30] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
611, "nxtwWinsockTransport.pas")
[0062FFBE] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute (Line
2045, "nxptBasePooledTransport.pas")
[00537A8C] nxllThread.TnxInitThread.DoExecute (Line 650, "nxllThread.pas")
[00537823] nxllThread.TnxThread.Execute (Line 454, "nxllThread.pas")
[0045746E] Classes.ThreadProc
[004074C0] System.ThreadWrapper
================================================== ============

Time: [24070735] 26/08/2010 14.22.43
ExceptionInfo: $039BF0FC
ExceptionRecord: $039BF1B4
ExceptionCode: $C0000005 = EXCEPTION_ACCESS_VIOLATION - The thread tried
to read from or write to a virtual address for which it does not have the
appropriate access.
ExceptionFlags: $00000000
ExceptionRecord: $00000000
ExceptionAddress: $00000000
ExceptionInformation[0]: $00000008
ExceptionInformation[1]: $00000000
ContextRecord:
ContextFlags: $0001003F
Dr0: $00000000
Dr1: $00000000
Dr2: $00000000
Dr3: $00000000
Dr6: $00000000
Dr7: $00000000
SegGs: $00000000
SegFs: $0000003B
SegEs: $00000023
SegDs: $00000023
Edi: $039BFB1C
Esi: $00000000
Ebx: $7AF4BFE0
Edx: $7AF4C000
Ecx: $007DA2D8
Eax: $00000000
Ebp: $039BF4AC
Eip: $00000000
SegCs: $0000001B
EFlags: $00010286
Esp: $039BF49C
SegSs: $00000023
Exception: nil!
Filesize: 7852544
Filedate: 2010-05-08 13.14.34
Computer: SERVERHP
User: SYSTEM
ThreadID: 3244
ProcessID: 296
Version: 3,0401
Client:
C:\Programmi\Master\Oroplus\V5\oroplus.exe;Size:60 420314;Date:2010-07-12
09.17.24;Computer:PC-FABBRICA;User:utente
SessionID: 2106002816
Connected From: 192.168.1.111:1272
--------------------------------------------------------------
Callstack (Frames):
[005B14EA]
nxsrBufferManager.TnxBaseFileHeaderAccessFactory.C reateFileHeaderAccess
(Line 1567, "nxsrBufferManager.pas")
[005B9843] nxsrBufferManager.TnxBlockAccess.HeaderAccess (Line 4510,
"nxsrBufferManager.pas")
[005C1D5F] nxsrIndexEngineBase.TnxBaseIndexHeaderAccess.bhaGe tFileHeader
(Line 990, "nxsrIndexEngineBase.pas")
[007E1B09]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.ieNextKeyPrim
(Line 2142, "nxseIndexEngineStaticKeyBstarTree.pas")
[007E2F92]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.NextKey
(Line 2691, "nxseIndexEngineStaticKeyBstarTree.pas")
[0061E834] nxsrServerEngine.TnxServerTableCursor.sbcRecordGet Next (Line
12128, "nxsrServerEngine.pas")
[00618367] nxsrServerEngine.TnxServerBaseCursor.RecordGetNext (Line 9389,
"nxsrServerEngine.pas")
[008A9451] nxchCommandHandler.TnxServerCommandHandler.nmCurso rRecordGetNext
(Line 2754, "nxchCommandHandler.pas")
[0089E279] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line 609,
"nxchCommandHandler.pas")
[0053B976] nxllTransport.TnxBaseTransport.btProcess (Line 1802,
"nxllTransport.pas")
[00632342] nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived
(Line 3012, "nxptBasePooledTransport.pas")
[0063200B] nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived
(Line 2894, "nxptBasePooledTransport.pas")
[00639CC9] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
632, "nxtwWinsockTransport.pas")
[00639C30] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
611, "nxtwWinsockTransport.pas")
[0062FFBE] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute (Line
2045, "nxptBasePooledTransport.pas")
[00537A8C] nxllThread.TnxInitThread.DoExecute (Line 650, "nxllThread.pas")
[00537823] nxllThread.TnxThread.Execute (Line 454, "nxllThread.pas")
[0045746E] Classes.ThreadProc
[004074C0] System.ThreadWrapper
--------------------------------------------------------------
Callstack (Raw):
[005AEA3E] nxsrFileImplWin32.TnxDualWin32File.ReadFileAt (Line 1626,
"nxsrFileImplWin32.pas")
[00588B6F] JclHookExcept.DoExceptNotify (Line 271, "JclHookExcept.pas")
[00588BDE] JclHookExcept.HookedRaiseException (Line 287,
"JclHookExcept.pas")
[005AEA3E] nxsrFileImplWin32.TnxDualWin32File.ReadFileAt (Line 1626,
"nxsrFileImplWin32.pas")
[00588BDE] JclHookExcept.HookedRaiseException (Line 287,
"JclHookExcept.pas")
[005AEA3E] nxsrFileImplWin32.TnxDualWin32File.ReadFileAt (Line 1626,
"nxsrFileImplWin32.pas")
[005AEB31] nxsrFileImplWin32.TnxDualWin32File.ReadFileExactAt (Line 1643,
"nxsrFileImplWin32.pas")
[005AD9ED] nxsrFileImplWin32.TnxBaseWin32File.ReadDecryptFile ExactAt (Line
1091, "nxsrFileImplWin32.pas")
[005AD8DF] nxsrFileImplWin32.TnxBaseWin32File.ReadBlock (Line 1071,
"nxsrFileImplWin32.pas")
[005BA5DE] nxsrBufferManager.TnxReadOnlyBlock.CacheBlockNeede d (Line 4801,
"nxsrBufferManager.pas")
[005B3981] nxsrBufferManager.TnxReadOnlyBlock.Block (Line 2365,
"nxsrBufferManager.pas")
[005B6582] nxsrBufferManager.TnxBufferManager.bmGetBlock (Line 3445,
"nxsrBufferManager.pas")
[005B7ECB] nxsrBufferManager.TnxBufferManager.GetBlock (Line 4027,
"nxsrBufferManager.pas")
[005B97AA] nxsrBufferManager.TnxBlockAccess.GetBlock (Line 4493,
"nxsrBufferManager.pas")
[005B1102] nxsrBufferManager.TnxBaseFileHeaderAccess.AcquireH eader (Line
1456, "nxsrBufferManager.pas")
[007DACC6] nxseHeaderAccess.Tnx2xFileHeaderAccess.AcquireHead er (Line 450,
"nxseHeaderAccess.pas")
[005B11E5] nxsrBufferManager.TnxBaseFileHeaderAccess.Create (Line 1482,
"nxsrBufferManager.pas")
[005B14EA]
nxsrBufferManager.TnxBaseFileHeaderAccessFactory.C reateFileHeaderAccess
(Line 1567, "nxsrBufferManager.pas")
[005B97D8] nxsrBufferManager.TnxBlockAccess.GetBlock (Line 4496,
"nxsrBufferManager.pas")
[005B9843] nxsrBufferManager.TnxBlockAccess.HeaderAccess (Line 4510,
"nxsrBufferManager.pas")
[005C1D5F] nxsrIndexEngineBase.TnxBaseIndexHeaderAccess.bhaGe tFileHeader
(Line 990, "nxsrIndexEngineBase.pas")
[007E3457]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.ValidateIndexPath
(Line 2789, "nxseIndexEngineStaticKeyBstarTree.pas")
[007E1B09]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.ieNextKeyPrim
(Line 2142, "nxseIndexEngineStaticKeyBstarTree.pas")
[007E2F92]
nxseIndexEngineStaticKeyBstarTree.TnxStaticKeyBsta rTreeIndexEngine.NextKey
(Line 2691, "nxseIndexEngineStaticKeyBstarTree.pas")
[0061E834] nxsrServerEngine.TnxServerTableCursor.sbcRecordGet Next (Line
12128, "nxsrServerEngine.pas")
[0052C59A] nxllUtils.nxIsClassInstance (Line 2080, "nxllUtils.pas")
[00618367] nxsrServerEngine.TnxServerBaseCursor.RecordGetNext (Line 9389,
"nxsrServerEngine.pas")
[008A9451] nxchCommandHandler.TnxServerCommandHandler.nmCurso rRecordGetNext
(Line 2754, "nxchCommandHandler.pas")
[00524EFD] nxllSyncPortal.TnxThreadStates.Acquire (Line 99,
"nxllSyncPortal.pas")
[0089E279] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line 609,
"nxchCommandHandler.pas")
[0053B976] nxllTransport.TnxBaseTransport.btProcess (Line 1802,
"nxllTransport.pas")
[00632342] nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived
(Line 3012, "nxptBasePooledTransport.pas")
[0063200B] nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived
(Line 2894, "nxptBasePooledTransport.pas")
[00639CC9] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
632, "nxtwWinsockTransport.pas")
[00639C30] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed (Line
611, "nxtwWinsockTransport.pas")
[0062FFBE] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute (Line
2045, "nxptBasePooledTransport.pas")
[00537A8C] nxllThread.TnxInitThread.DoExecute (Line 650, "nxllThread.pas")
[00537823] nxllThread.TnxThread.Execute (Line 454, "nxllThread.pas")
[0045746E] Classes.ThreadProc
[004074C0] System.ThreadWrapper

Roberto Nicchi wrote:

> The error is raised from the nexusdb server (3.04.1)
>
> Could be thas it is caused by an antivirus program (Clam antivirus is
> installed)?

NexusDB database files should ALWAYS be excluded from AV scans.

--

Hannes Danzl / NexusDB

Manuals - http://www.nexusdb.com/support/index..._manual_v3.htm
Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php

Hannes,

| NexusDB database files should ALWAYS be excluded from AV scans.

I've never done that. Is there an extent list available? Does it
include those ANNOYING left-over SQL files from EM?

--

Q

08/31/2010 13:26:49

XanaNews Version 1.19.1.278 [Q'sBrokenToolBar]

Q Correll wrote:

> Hannes,
>
> > NexusDB database files should ALWAYS be excluded from AV scans.
>
> I've never done that. Is there an extent list available?

I usually simply exclude the DB folder.

> Does it
> include those ANNOYING left-over SQL files from EM?

Not sure what you mean

--

Hannes Danzl / NexusDB

Manuals - http://www.nexusdb.com/support/index..._manual_v3.htm
Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php

Hannes,

| I usually simply exclude the DB folder.

Sounds like a good idea. Thanks!

| | Does it
| | include those ANNOYING left-over SQL files from EM?
|
| Not sure what you mean

$SQL$VIEWS.nx1
$SQL$TRIGGERS.nx1
$SQL$PROCEDURES.nx1
$SQL$FUNCTIONS.nx1

Whenever I use EM that garbage is always left in the directory where I
was working.

--

Q

08/31/2010 20:26:26

XanaNews Version 1.19.1.278 [Q'sBrokenToolBar]

> $SQL$VIEWS.nx1
> $SQL$TRIGGERS.nx1
> $SQL$PROCEDURES.nx1
> $SQL$FUNCTIONS.nx1
>
> Whenever I use EM that garbage is always left in the directory where I
> was working.

Well, these are the system tables holding views, triggers, stored procs and
functions. I would *strongly* recommend to leave them alone

--

Hannes Danzl / NexusDB

Manuals - http://www.nexusdb.com/support/index..._manual_v3.htm
Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php

Hannes,

| Well, these are the system tables holding views, triggers, stored
| procs and functions. I would strongly recommend to leave them alone

I have always blown them away after I finish using EM. <g> They always
re-appear the next time I do something with EM. <g>


--

Q

08/31/2010 23:24:43

XanaNews Version 1.19.1.278 [Q'sBrokenToolBar]

Now i have exluded .nx1 files. Later i will know if the problem is solved

Roberto

"Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> ha scritto nel messaggio
news:xn0gylxvd1gdeth001@news.nexusdb.com...
> Roberto Nicchi wrote:
>
>> The error is raised from the nexusdb server (3.04.1)
>>
>> Could be thas it is caused by an antivirus program (Clam antivirus is
>> installed)?
>
> NexusDB database files should ALWAYS be excluded from AV scans.
>
> --
>
> Hannes Danzl / NexusDB
>
> Manuals - http://www.nexusdb.com/support/index..._manual_v3.htm
> Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
> Newsgroup Web Gateway - http://www.nexusdb.com/forums/
> Newsgroup Search - http://www.nexusdb.com/forums/search.php

Q Correll wrote:

> Hannes,
>
> > Well, these are the system tables holding views, triggers, stored
> > procs and functions. I would strongly recommend to leave them alone
>
> I have always blown them away after I finish using EM. <g> They always
> re-appear the next time I do something with EM. <g>

Well, if you ever create a view, trigger or stored procedure, then deleting
them means you are deleting whatever you just created...

Thorsten,

| Well, if you ever create a view, trigger or stored procedure, then
| deleting them means you are deleting whatever you just created...

Ah. Understood.

I guess I'm relatively safe since I have NOT done any SQL at all. <g>
However, I guess I'll stop referring to them as "left-over garbage" now
that I have an understanding of what they're for. <g>

Thanks for the explanation!

Aside: I've been lurking your exchange in the Embarcadero NG's about
Packages, Uses, registration, etc., ... Cool! ;-)

--

Q

09/01/2010 09:23:47

XanaNews Version 1.19.1.278 [Q'sBrokenToolBar]