• Welcome, Guest. Please login.
 
July 16, 2019, 12:38:55 pm

News:

Welcome to the SQLitening support forums!


Error -18 still pops up intermittently

Started by Fredrick Ughimi, October 22, 2011, 07:09:39 am

Previous topic - Next topic

Fredrick Ughimi

Hello,

Program connects and works fine but Error -18 still pops up intermittently.

The Clients and Server runs on Windows XP SP2.

Best regards,


Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

%SQLitening_SendOrReceiveError  = -18 - Error sending or receiving message"

cj

ConnectionTimeOut = Number Minutes --- Control the number of minutes the server will wait to receive a message from an active connection.  Default is 30. Set to -1 if you want to never timeout.

Have you tried setting ConnectionTimeOut to -1  in SqliteningServer.Cfg
Is the server software up to date, size 125,440 bytes?

Don't test here with XP.



Fredrick Ughimi

I have tried using -1 and installed the latest Server. Error still showing. The error pops up more frequently now.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

The latest server I downloaded and using is ver 1.53 and its 122kb. Its there a newer version?
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

No newer version than 1.53 at this time.  10/22/2011

Fred Meier

Does error happen on all clients or just one?  Anything unusual in SQLiteningServer.Log?

This error normally means a TCP/Communications/Network problem.

Fredrick Ughimi

It happens on the 3 clients presently in use. Nothing unsual I can see in the Log (well, how would anything usual look like?).

Well, for the past hour or so since I changed the value of CONNECTIONTIMEOUT to -1 the error hasn't poped up. Still watching...

Are you saying there is a problem with the network?
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

October 22, 2011, 12:51:01 pm #8 Last Edit: October 22, 2011, 12:54:26 pm by cj
SQLiteningServer.log
111022102117 Dcon #16317 TimeOut

If nothing is sent to server within timeout period error 18's appear (as they should) on client.


cj

Refreshing the FACT does not disconnect clients (which is very cool.) :D
Tried several times while changing timeout.

Fredrick Ughimi

Is there a side effect if you tell the server not to timeout (ConnectionTimeOut=-1)?
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

Fred or someone else may have to answer this.
When a client ends the server terminates the connection.
My answer is no problem..


Fred Meier

QuoteIs there a side effect if you tell the server not to timeout (ConnectionTimeOut=-1)?

Each connection consumes resources at the server (memory/handles/cycles/etc).  If you have a client that connects and then leaves for the day you probable should disconnect it.  It's your call.  If you have a finite number of clients and you have the server resources to have them all connected then no problem.

Fredrick Ughimi

Thank you for the information. Can I set it to one minute? I.e ConnectionTimeOut=60
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

Per manual:
ConnectionTimeOut = Number Minutes --- Control the number of minutes the server will wait to receive a message from an active connection.  Default is 30. Set to -1 if you want to never timeout.

It is in minutes, not seconds. 
1 = 1 minute (which will force users to send something to the server every 59 seconds or get timed out.)