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.

Update 2: This is another symptom caused by dbsrv17 -k... so don't use dbsrv17 -k if you need these property values (such as when you use Foxhound).

To determine if your server is running with -k:

SELECT IF PROPERTY ( 'CollectStatistics' ) = 'Yes' 
       THEN 'dbsrv -k NOT specified'
       ELSE 'dbsrv -k IS specified'
       END IF AS "dbsrv -k";

dbsrv -k
'dbsrv -k IS specified'

dbsrv -k
'dbsrv -k NOT specified'

Two snapshots of property values have revealed unexpectedly large numeric values.


sa_conn_properties HeapsQuery 18446744073709551588 sa_conn_properties HeapsQuery 18446744073709551590 sa_conn_properties HeapsRelocatable 18446744073709551609 sa_conn_properties HeapsRelocatable 18446744073709551611 sa_conn_properties PrepStmt 18446744073709551612 sa_conn_properties PrepStmt 18446744073709551613 sa_conn_properties QueryCachedPlans 18446744073709551613 sa_conn_properties QueryCachedPlans 18446744073709551614 sa_conn_properties QueryCachePages 18446744073709551609 sa_conn_properties QueryCachePages 18446744073709551611 sa_db_properties Cursor 18446744073709551615 sa_db_properties CursorOpen 18446744073709551615 sa_db_properties HeapsLocked 18446744073709539678 sa_db_properties HeapsLocked 18446744073709547711 sa_db_properties HeapsQuery 18446744073709551615 sa_db_properties HeapsRelocatable 18446744073709539728 sa_db_properties HeapsRelocatable 18446744073709547759 sa_db_properties LockCount 18446744073709548295 sa_db_properties LTMTrunc 18446744073709551615 sa_db_properties QueryCachedPlans 18446744073709551608 sa_db_properties QueryCachedPlans 18446744073709551615 sa_db_properties QueryMemActiveCurr 18446744073709551615 sa_db_properties RemoteTrunc 18446744073709551615 sa_db_properties RollbackLogPages 18446744073709551611 sa_db_properties RollbackLogPages 18446744073709551615 sa_db_properties SyncTrunc 18446744073709551615 sa_eng_properties AvailIO 18446744073709551376 sa_eng_properties AvailIO 18446744073709551611 sa_eng_properties CacheFileDirty 18446744073709548666 sa_eng_properties Cursor 18446744073709551613 sa_eng_properties Cursor 18446744073709551614 sa_eng_properties CursorOpen 18446744073709551613 sa_eng_properties CursorOpen 18446744073709551614 sa_eng_properties HeapsQuery 18446744073709551615 sa_eng_properties QueryMemActiveCurr 18446744073709551615

Other diagnostic trace data shows that DB_PROPERTY ( 'ConnCount' ) frequently returned values like 18446744073709551613, 18446744073709551614 and 18446744073709551615.

This is a preliminary report of customer experience and it hasn't been reproduced yet.

Update 1: Failed to reproduce symptoms on a overloaded server (503 Conns, 42000 Req/s, 24000 Commits/s, 450 Unsch Req, 55% CPU of 8, 3000% Recovery Urgency, 4000 Disk Writes/s)

This question is marked "community wiki".

asked 04 Apr '20, 14:27

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 10 Apr '20, 09:53

it seems that you see maximum unsigned int64. I know it is not a solution, just thoughts. It looks suspicious.

(09 Apr '20, 05:57) Vlad
Replies hidden

My guess is that when CollectStatistics is 'No' then all the underlying variables are left uninitialized (e.g., garbage UNSIGNED BIGINT).

IMO they should all be initialized to NULL which is what you see if you SELECT PROPERTY ( 'UnknownPropertyName' )... that would be my reading of The Watcom Rule :)

(10 Apr '20, 09:56) Breck Carter

> I know it is not a solution

FWIW dbsrv17 -k is an effective test of how Foxhound handles garbage properties, where "effective" means "Foxhound fails" :)

Changes are in progress to handle garbage properties better (because it can happen any time, and has happened in the past).

A change to detect CollectStatistics = 'No' is also under consideration because "Foxhound == Pointless" when that's the case.

These changes will force a new build since a patch probably won't work for the OFSS component.

(10 Apr '20, 10:04) Breck Carter
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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 04 Apr '20, 14:27

question was seen: 1,093 times

last updated: 10 Apr '20, 10:04