Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

We are seeing strange behavior of "remote_idle_timeout"-option for SQL Anywhere 16.0.0.2798.
Timeout occurs after double the number of seconds. For example:

1) set temporary option "remote_idle_timeout" = 30;

ASA (-o) log (30 * 2 = 60 seconds!):

I. 06/10 11:59:31. CONNECTION_PROPERTY('remote_idle_timeout')=30
I. 06/10 12:00:32. SQLCODE = -982, SQLSTATE = WW051, ERRORMSG() = Connection timed out

Web (-zoc) log:

[connid = 28, 06/10 11:59:31.446]
[connid = 28, 06/10 11:59:31.446, REQUEST]
POST /d4w/api/getNewBookingsLong HTTP/1.0
Accept-Charset: windows-1251, UTF-8, *
Date: Mon, 10 Jun 2019 08:59:31 GMT
Authorization: Basic ...
Host: ....com
User-Agent: SQLAnywhere/16.0.0.2798
Connection: close
Content-Type: application/xml; charset=UTF-8
Content-Length: 0

[connid = 28, Timeout] [connid = 28, socket closed] [connid = 28, Error: socket closed by peer]

2) set temporary option "remote_idle_timeout" = 80;

ASA (-o) log (80 * 2 = 160 seconds!):

I. 06/10 12:03:25. CONNECTION_PROPERTY('remote_idle_timeout')=80
I. 06/10 12:06:06. SQLCODE = -982, SQLSTATE = WW051, ERRORMSG() = Connection timed out

Web (-zoc) log:

[connid = 28, 06/10 12:03:25.652, REQUEST]
POST /d4w/api/getNewBookingsLong HTTP/1.0
Accept-Charset: windows-1251, UTF-8, *
Date: Mon, 10 Jun 2019 09:03:25 GMT
Authorization: Basic ...
Host: ....com
User-Agent: SQLAnywhere/16.0.0.2798
Connection: close
Content-Type: application/xml; charset=UTF-8
Content-Length: 0

[connid = 28, Timeout] [connid = 28, socket closed] [connid = 28, Error: socket closed by peer]

Is this doubling the timeout wait correct?

ps: When the connection is interrupted by the web service, we get the following error:

I. 06/10 12:20:59. SQLCODE = -983, SQLSTATE = WW052, ERRORMSG() = HTTP request failed. Status code '504 Unused'

asked 10 Jun '19, 05:45

Ilia63's gravatar image

Ilia63
1.2k545982
accept rate: 44%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×261

question asked: 10 Jun '19, 05:45

question was seen: 974 times

last updated: 10 Jun '19, 05:45