#1  
Old 21st April 2009, 01:45 AM
ths180
 
Posts: n/a
Default Access Violation at address 00000000. Read of address 00000000


Hallo,

i use the NXserver 2.0.7.6.
I develop a programm with the ado.net connection. Fine!

I have a litte program which executes select and Update commands.
(NXcommand ...)

This program starts every night.

After a few nights, the Memory in the task manager increases fast.

Now, i have tested it with the same programm and an infinite loop.

The nxserver crashes and the exception log shows:

*** Server started ***
Time: [10801125] 20.04.2009 15:31:14
Exception: EAccessViolation
Message: Access violation at address 00000000. Read of address
00000000
Filesize:5478400
Filedate:25.03.2008 15:57:00
Computer:TANKSTELLE
User:Administrator
ThreadID: 3472
ProcessID: 3236
Callstack:
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************

*** Server started ***
Time: [484796] 20.04.2009 15:41:40
Exception: EAccessViolation
Message: Access violation at address 00000000. Read of address
00000000
Filesize:5478400
Filedate:25.03.2008 15:57:00
Computer:TANKSTELLE
User:Administrator
ThreadID: 3696
ProcessID: 3716
Callstack:
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************


Could you help me please?

Thank you very much,

Michael Fritz


--
ths180
  #2  
Old 21st April 2009, 03:07 AM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


Hallo,
this programm increases the memory in task manager fast.
For testing it ist an infinite loop. But only one Select command
increases memory and crashes the nxserver.exe???

NexusDB.ADOProvider.NxConnection conn = new
NxConnection("Transport=TCP;Port=16080;Server=Nexu sDB@127.0.0.1;Database=Global;");

NxCommand p1 = new NxCommand();
p1.Connection = conn;
poll:
conn.Open();
p1.CommandText = "select max(zaehler) from abrech where
artikelnr=5";

double p1s = double.Parse(p1.ExecuteScalar().ToString());
conn.Close();
goto poll;


--
ths180
  #3  
Old 21st April 2009, 07:19 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000

> double p1s = double.Parse(p1.ExecuteScalar().ToString());

What happens if you remove call to actually run the query. Since you're in an
infinite loop the garbage collector doesn't really get a chance to get rid of
the stuff that you're creaeting. The error that you see is not an error in the
runtime engine but it's the saving of the server settings that fails. With the
information at hand I'd say that actually windows runs out of addressable
space, but it's just guess.
  #4  
Old 21st April 2009, 08:04 AM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


Hallo,

without the call to run the query:
double p1s = double.Parse(p1.ExecuteScalar().ToString());

The same things happens.

My program which starts at night:
select commands
Update command
select command
update command

it recalculates counter reading. so it takes the counter of 15.04.2009
and the counter of 14.04.2009. The Update command sets the difference
between the two counter dates...
Then the Next counter...

The table has 3500 entrys/lines.

After some days the same occurs like my test-program with the infinite
loop.

Thank you very much!


--
ths180
  #5  
Old 21st April 2009, 08:38 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000

ths180 wrote:

>
> Hallo,
>
> without the call to run the query:
> double p1s = double.Parse(p1.ExecuteScalar().ToString());
>
> The same things happens.


You need to somehow get the garbage collector do its job. For example try to
call

System.gc();

every n-th loop to force the GC to run.
  #6  
Old 21st April 2009, 11:26 AM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


Hallo,

i have integrate the garbage collector.

But now i have an other Access Violation:

Please help me,

Thank you!

*** Server started ***
Time: [370531] 21.04.2009 01:03:59
Exception: EAccessViolation
Message: Access violation at address 0000000D. Read of address
0000000D
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 2080
ProcessID: 2108
Callstack:
(FFFFF00D) [0000000D]
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************

*** Server started ***
Time: [869812] 21.04.2009 01:12:19
Exception: EAccessViolation
Message: Access violation at address 00405CA0 in module 'nxServer.exe'.
Read of address 69747047
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 2216
ProcessID: 2264
Callstack:
[00405CA0] System.@LStrAddRef (Line 13196, "syssystem.pas")
[0075F2B8] nxBaseServerComp.TnxBaseServer.SaveSettings (Line 568,
"nxBaseServerComp.pas")
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************

*** Server started ***
Time: [1757156] 21.04.2009 01:27:06
Exception: EAccessViolation
Message: Access violation at address 00405CA0 in module 'nxServer.exe'.
Read of address 69747047
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 296
ProcessID: 3352
Callstack:
[00405CA0] System.@LStrAddRef (Line 13196, "syssystem.pas")
[0075F2B8] nxBaseServerComp.TnxBaseServer.SaveSettings (Line 568,
"nxBaseServerComp.pas")
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************


--
ths180
  #7  
Old 21st April 2009, 07:31 PM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


Sometimes the server crashes with this fatal error:

*** Server started ***
Time: [28791421] 21.04.2009 08:57:40
Exception: EExternalException
Message: External exception C000001D
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 2968
ProcessID: 1016
Callstack:
(00372FA0) [7FB73FA0]
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

Time: [28791468] 21.04.2009 08:57:41
Exception: EInvalidPointer
Message: Invalid pointer operation
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 1964
ProcessID: 1016
Callstack:
[00730546] nxptTCPRequestTransport.TnxSimpleTCPRequestSocket. DoExecute
(Line 138, "nxptTCPRequestTransport.pas")
[00731860] nxptTCPRequestTransport.TnxSimpleTCPRequestSocket. Read (Line
400, "nxptTCPRequestTransport.pas")
[005EBE4F] nxllSocket.TnxCustomSocket.Event (Line 1738,
"nxllSocket.pas")
[005EBC53] nxllSocket.TnxAbstractSocket.DoEvent (Line 1639,
"nxllSocket.pas")
[005EA716] nxllSocket.TnxCustomWinSocket.Event (Line 947,
"nxllSocket.pas")
[005EB89D] nxllSocket.TnxServerClientThread.DoRead (Line 1524,
"nxllSocket.pas")
[005EBB53] nxllSocket.TnxServerClientThread.ClientExecute (Line 1608,
"nxllSocket.pas")
[005EBA55] nxllSocket.TnxServerClientThread.DoExecute (Line 1579,
"nxllSocket.pas")
[0051B1E3] nxllThread.TnxThread.Execute (Line 507, "nxllThread.pas")
[00435078] Classes.ThreadProc (Line 9877, "commonClasses.pas")
[00405790] System.ThreadWrapper (Line 12110, "syssystem.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************

*** Server started ***
Time: [30844312] 21.04.2009 09:31:53
Exception: EAccessViolation
Message: Access violation at address 7FB7422B. Write of address
00737F50
Filesize:5478400
Filedate:25.03.2008 15:57:08
Computer:TANKSTELLE
User:Administrator
ThreadID: 3964
ProcessID: 1372
Callstack:
(0037322B) [7FB7422B]
[0075E612] nxBaseServerComp.TnxBaseServer.bsGetSecureServer (Line 322,
"nxBaseServerComp.pas")
[007631C0] nxServerForm.TnxuiServerForm.tmrSecurityCheckTimer (Line
560, "nxServerForm.pas")
[0044C017] ExtCtrls.TTimer.Timer (Line 2281, "ExtCtrls.pas")
[00436DFC] Classes.StdWndProc (Line 11583, "commonClasses.pas")
================================================== ============

*****************************************
*** Fatal Exception Flag has been set ***
*****************************************


--
ths180
  #8  
Old 21st April 2009, 08:14 PM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000

ths180 wrote:

>
> Sometimes the server crashes with this fatal error:


This is very random errors, and an indication more that you're running out of
memory. Have you ruled that out yet?
  #9  
Old 21st April 2009, 09:14 PM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


In every loop:
GC.Collect();
GC.WaitForPendingFinalizers();

Do you have an idea?

Thanks...


--
ths180
  #10  
Old 21st April 2009, 09:30 PM
ths180
 
Posts: n/a
Default Re: Access Violation at address 00000000. Read of address 00000000


I get the following failure in my program and the nxserver crashes...


System.Exception: Error: Error: NexusDB: A fatal error has occured.
Server operations are suspended until the server is restarted. Check
exception log at server for further information [$3C53/15443]
bei NexusDB.ADOProvider.NxDatasetProxy.Execute(String sCmd, Int32
TimeOut, NxDataset& resultset, Boolean readBlobs, UInt32 BufferSize,
NxParameterCollection& parameters)
bei NexusDB.ADOProvider.NxCommand.InternalExecuteScala r()
bei NexusDB.ADOProvider.NxCommand.ExecuteScalar()
bei WindowsFormsApplication1.Form1.Form1_Load(Object sender,
EventArgs e) in Cokumente und
EinstellungenAdministratorDesktopsplitZS.cs:Zeile 63.
bei System.Windows.Forms.Form.OnLoad(EventArgs e)
bei System.Windows.Forms.Form.OnCreateControl()
bei System.Windows.Forms.Control.CreateControl(Boolean
fIgnoreVisible)
bei System.Windows.Forms.Control.CreateControl()
bei System.Windows.Forms.Control.WmShowWindow(Message& m)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
bei System.Windows.Forms.ContainerControl.WndProc(Mess age& m)
bei System.Windows.Forms.Form.WmShowWindow(Message& m)
bei System.Windows.Forms.Form.WndProc(Message& m)
bei
System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
bei
System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)


************** Geladene Assemblys **************
mscorlib
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------
WindowsFormsApplication1
Assembly-Version: 1.0.0.0.
Win32-Version: 1.0.0.0.
CodeBase:
file:///C:/Dokumente%20und%20Einstellungen/Administrator/Desktop/split/bin/Debug/WindowsFormsApplication1.exe.
----------------------------------------
System.Windows.Forms
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll.
----------------------------------------
System
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll.
----------------------------------------
System.Drawing
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll.
----------------------------------------
System.Configuration
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll.
----------------------------------------
System.Xml
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll.
----------------------------------------
NexusDB.ADOProvider
Assembly-Version: 2.0.7.75.
Win32-Version: 2.0.7.75.
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/NexusDB.ADOProvider/2.0.7.75/NexusDB.ADOProvider.dll.
----------------------------------------
System.Data
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll.
----------------------------------------
System.Windows.Forms.resources
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_de_b77a5c561934e089/System.Windows.Forms.resources.dll.
----------------------------------------
mscorlib.resources
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
CodeBase:
file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------


--
ths180


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
Using Portal Control to access Windows 7 Portal Host is very slow Wolfgang nexusdb.public.support.portal 24 29th July 2010 02:45 PM
Gateway Access Violation Hannes Danzl[NDD] nexusdb.public.support.portal 2 28th May 2010 03:15 PM
Error 5 access denied Charalampos Michael nexusdb.public.support.portal 3 18th January 2010 05:54 AM


All times are GMT +11. The time now is 06:57 AM.


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