It sounds impossible, but I just had a sequence of dbping executions that ran the connection number up beyond 400,000 on a SQL Anywhere 16 database. It only takes a few milliseconds for a connect/disconnect so exhausting the INTEGER range is not out of the question.

If the connection number wraps to 1, do new connection numbers step over small assigned values that are still in use?

Do new connection numbers "step over" high-valued connection numbers (events, services, backups, exchanges, etc)?

asked 27 Feb '15, 15:08

Breck%20Carter's gravatar image

Breck Carter
25.7k427586846
accept rate: 20%


The range of user connection numbers is from 1 to 999,999,999. If you did have more than a billion connections and disconnections, the connection numbers would start from 1 again, but they would not reuse any connection numbers already in use.

So the ranges for user and temporary connection numbers are never violated, and even if you use more than a billion connection numbers, there can never be two connections with the same number.

permanent link

answered 27 Feb '15, 15:13

Ian%20McHardy's gravatar image

Ian McHardy
2.9k23049
accept rate: 38%

See also this question: When will SQLA reuse the connection id

permanent link

answered 02 Mar '15, 03:21

Martin's gravatar image

Martin
8.6k116150237
accept rate: 14%

Your answer
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:

×125

question asked: 27 Feb '15, 15:08

question was seen: 389 times

last updated: 02 Mar '15, 03:21