SQL Anywhere database - What is connection number 1000000001?

Author

What is connection number 1000000001?

Breck Carter

2005-05-30, 3:23 am

What is the meaning of connection number 1000000001 with
empty Userid and ReqType 'unknown (0)' showing in the
sa_conn_info result set on dbsrv9 version 9.0.2.3124?

Number,Name,Userid,D
BNumber,LastReqTime,
ProcessTime,Port,Req
Type
,CommLink,NodeAddr,L
astIdle,CurrTaskSw,B
lockedOn,LockName,Un
cmtOps
1000000001,'','',0,'
',,,'unknown (0)','NA','NA',0,,0,
0,0

This entry showed up after a few minutes of operation, and
isn't going away; I'm just curious about what it might
represent.

Note: other connections are numbered 95, 96, etc.

Breck

Ian McHardy

2005-05-30, 9:23 am

As of 9.0.1, connection numbers 1 billion and higher are internal,
non-client connections. Some examples are for doing a checkpoint, running
an event, etc.

The ReqType, etc. values are normal for internal connections. I wouldn't
expect an empty string for a user name though.

Are you experiencing any problems? Is this reproducible?

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
<Breck Carter> wrote in message news:429abaff.3cf8.1681692777@sybase.com...
> What is the meaning of connection number 1000000001 with
> empty Userid and ReqType 'unknown (0)' showing in the
> sa_conn_info result set on dbsrv9 version 9.0.2.3124?
>
> Number,Name,Userid,D
BNumber,LastReqTime,
ProcessTime,Port,Req
Type
> ,CommLink,NodeAddr,L
astIdle,CurrTaskSw,B
lockedOn,LockName,Un
cmtOps
> 1000000001,'','',0,'
',,,'unknown (0)','NA','NA',0,,0,
0,0
>
> This entry showed up after a few minutes of operation, and
> isn't going away; I'm just curious about what it might
> represent.
>
> Note: other connections are numbered 95, 96, etc.
>
> Breck

Breck Carter [TeamSybase]

2005-05-30, 11:23 am

On 30 May 2005 06:56:47 -0700, "Ian McHardy"
< mchardy_no@spam_iany
where.com> wrote:

>As of 9.0.1, connection numbers 1 billion and higher are internal,
>non-client connections. Some examples are for doing a checkpoint, running
>an event, etc.
>
>The ReqType, etc. values are normal for internal connections. I wouldn't
>expect an empty string for a user name though.
>
>Are you experiencing any problems? Is this reproducible?

Could it be a live backup process? I think one was started about the
time the connection appeared.

The user name is definitely empty, which is the one thing that ruffled
my feathers :)

It is not causing problems as far as I know. The db is 25G so a
reproducible will take some effort but I'm not sure it's warranted.

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links