SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Pages: [1] 2 3 ... 5

Author Topic: Error -18 still pops up intermittently  (Read 18667 times)

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Error -18 still pops up intermittently
« on: October 22, 2011, 04:39:39 AM »

Hello,

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

The Clients and Server runs on Windows XP SP2.

Best regards,


Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #1 on: October 22, 2011, 05:22:59 AM »

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

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #2 on: October 22, 2011, 05:29:44 AM »

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.


Logged

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Error -18 still pops up intermittently
« Reply #3 on: October 22, 2011, 06:30:37 AM »

I have tried using -1 and installed the latest Server. Error still showing. The error pops up more frequently now.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Error -18 still pops up intermittently
« Reply #4 on: October 22, 2011, 07:17:09 AM »

The latest server I downloaded and using is ver 1.53 and its 122kb. Its there a newer version?
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #5 on: October 22, 2011, 07:25:02 AM »

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

Fred Meier

  • Master Geek
  • ****
  • Posts: 806
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #6 on: October 22, 2011, 09:39:53 AM »

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

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

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Error -18 still pops up intermittently
« Reply #7 on: October 22, 2011, 10:06:58 AM »

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?
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #8 on: October 22, 2011, 10:21:01 AM »

SQLiteningServer.log
111022102117 Dcon #16317 TimeOut

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

« Last Edit: October 22, 2011, 10:24:26 AM by cj »
Logged

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #9 on: October 22, 2011, 10:53:41 AM »

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

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Error -18 still pops up intermittently
« Reply #10 on: October 22, 2011, 11:01:31 AM »

Is there a side effect if you tell the server not to timeout (ConnectionTimeOut=-1)?
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #11 on: October 22, 2011, 11:07:28 AM »

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

Logged

Fred Meier

  • Master Geek
  • ****
  • Posts: 806
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #12 on: October 22, 2011, 11:12:52 AM »

Quote
Is 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.
Logged

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Error -18 still pops up intermittently
« Reply #13 on: October 22, 2011, 12:03:38 PM »

Thank you for the information. Can I set it to one minute? I.e ConnectionTimeOut=60
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

cj

  • Master Geek
  • ****
  • Posts: 700
    • View Profile
Re: Error -18 still pops up intermittently
« Reply #14 on: October 22, 2011, 12:10:39 PM »

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.)
Logged
Pages: [1] 2 3 ... 5