Hi,

I have a DBISAM server running on a Small Business Server 2003 box. Approximately 20 clients connect to the DBISAM server, mostly external access over the internet. Approximately
once a week the client applications lose connectivity and report the following error in their system error logs:

"The following information is part of the event: DBISAM Engine Error # 11279 An unknown error ('Access violation at address 004081F4 in module 'dbsrvr.exe'. Read of address 397A1700')
occurred with the connection to the database server at '127.0.0.1', please check the server log."

This behaviour occurs for remote clients and local clients running on the server machine. Restarting the DBISAM server fixes the problem. Checking the server log doesn't reveal any info
because the server must be restarted first which seems to clear the log - Any suggestions?

Thanks, Tony.

That error message is from a client running on the server itself - remote clients would show the remote IP address in their error messages.

Tony.

Tony Pomfrett <tonyp@aline.com.au> wrote:

Correction:

That error message is from a client running on the server itself - remote clients would show the server external IP address in their error messages.

The situation is a little more complex. The DBISAM server is running as a service. I have another service running on the server box and its function is to monitor a table in the database (via
the DBISAM server not direct access) and send out emails if it finds certain records have been added. It is this service which throws up the errror shown above - but note that it says the
error is caused by the DBISAM server. The remote clients, which are different applications to the monitoring service also have the same problem.

Tony.

Tony,

<< I have a DBISAM server running on a Small Business Server 2003 box.
Approximately 20 clients connect to the DBISAM server, mostly external
access over the internet. Approximately once a week the client applications
lose connectivity and report the following error in their system error logs:

"The following information is part of the event: DBISAM Engine Error #
11279 An unknown error ('Access violation at address 004081F4 in module
'dbsrvr.exe'. Read of address 397A1700') occurred with the connection to the
database server at '127.0.0.1', please check the server log." >>

Is there an indication of the operation that caused the error in the log ?
(There should be something to the right of the above message).

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Tony,

<< I have a DBISAM server running on a Small Business Server 2003 box.
Approximately 20 clients connect to the DBISAM server, mostly external
access over the internet. Approximately once a week the client applications
lose connectivity and report the following error in their system error logs:

"The following information is part of the event: DBISAM Engine Error #
11279 An unknown error ('Access violation at address 004081F4 in module
'dbsrvr.exe'. Read of address 397A1700') occurred with the connection to the
database server at '127.0.0.1', please check the server log." >>

Hi Tim,

Perhaps I don't understand how to use the log. I try to access the log via the sysadmin program which refuses to log in to the DBISAM server until I restart the DBISAM server. The act of
restarting the DBISAM server seems to clear the log.  Is there a setting to prevent the log from being cleared or is there another way to access the log without using sysadmin?

Tony.
Is there an indication of the operation that caused the error in the log ?
(There should be something to the right of the above message).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tony,

<< Perhaps I don't understand how to use the log. I try to access the log
via the sysadmin program which refuses to log in to the DBISAM server until
I restart the DBISAM server. >>

That's really weird - you should always be able to log into the server via
the admin port, even if there are issues with the data connections.  The two
are completely separate.

<< The act of restarting the DBISAM server seems to clear the log.  Is there
a setting to prevent the log from being cleared or is there another way to
access the log without using sysadmin? >>

Yes, you can start the dbsrvr.exe process with the /al flag:

http://www.elevatesoft.com/dbisam4d5_configuring_starting_server.htm


--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I have attached an extract from the server log - it seems that a request from an external client caused an error and from that point on the internal client (which monitors the database)
raises an error every time it attempts to connect. Usernames and IP addresses have been altered.

Also, there are a number of "dead session removal" errors throughout the log like this:

11/03/2007 9:22:10 PM [ERROR] Internal error removing dead session [Access violation at address 7C8396D0 in module 'ntdll.dll'. Read of address 53657475] [Client Last User Name:
xxxxxxxx Last Address: xxx.xxx.1.195 Thread: 0 Session: 22958088]
11/03/2007 9:22:42 PM Connection accepted [Client Version: 4.25 User Name:  Address: 127.0.0.1 Encrypted: Yes Thread: 3936 Session: 43692040]
11/03/2007 9:22:42 PM Login [Client Version: 4.25 User Name: xxxxxxxx Address: 127.0.0.1 Encrypted: Yes Thread: 3936 Session: 43692040]
11/03/2007 9:22:42 PM Logout [Client Version: 4.25 User Name: xxxxxxxx Address: 127.0.0.1 Encrypted: Yes Thread: 3936 Session: 43692040]

Although they don't cause the server to crash.

Tony,

<< I have attached an extract from the server log - it seems that a request
from an external client caused an error and from that point on the internal
client (which monitors the database) raises an error every time it attempts
to connect. Usernames and IP addresses have been altered. >>

The error was during compression of a BLOB.  Are you using compressed BLOBs
at all ?  If not, then the compression error was during the sending of the
reply back to the client, which most likely means that there is a fatal
issue occurring with respect to memory allocation or something similar.

Could you send me the whole log via private email ?  I want to see what that
particular client was doing prior to the error.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Email sent to support@elevatesoft.com


>Could you send me the whole log via private email ?  I want to see what that
>particular client was doing prior to the error.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tony,

<< Email sent to support@elevatesoft.com >>

Thanks, see my email replies.

--
Tim Young
Elevate Software
www.elevatesoft.com