on 2020 Apr 04 3:27 PM
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 17.0.10.5963 property values have revealed unexpectedly large numeric values.
property
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.
Request clarification before answering.
User | Count |
---|---|
87 | |
9 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.