Geneos - Does the var_ref value in Database Logging have a maximum limit?

If the var_ref value exceeds 2,147,483,647 then we get back a negative value (rather than the large unsigned int stored in the database)

If the REF value in the var_ref_table exceeds 2,147,483,647 in value, then the var_ref values that will be stored in user tables will be negative. For example:

select ref from var_ref_table WHERE varname ='%toolkit2.2.value' and tablename='os_table'

Result: 2,305,291,474

But in the Gateway, the resulting REF value is already translated into a negative value:

DEBUG: Schema1_0::executePreparedQueryReturnLong QUERY=[SELECT ref FROM var_ref_table WHERE varname = :varname AND tablename = :tablename] DATA=[ :varname='%toolkit2.2.value' :tablename='os_table' ]
DEBUG: Schema1_0::executePreparedQueryReturnLong Returning-1989675822

NOTE

The value for the var_ref column is determined by auto-incrementing positive integer, databases should implement this as the largest value + 1.

MySQL

CREATE TABLE `node_ref_table` (
`ref` int(11) NOT NULL auto_increment,

...

A 4 byte positive integer displayed to 11 characters when selected.

SQL Server / Sybase

CREATE TABLE var_ref_table (ref numeric(10,0) identity, ...

Positive integer to 10 digits of precision. "identity" is the auto-increment type.

Oracle

CREATE TABLE var_ref_table (REF NUMERIC(10,0) ...

CREATE SEQUENCE var_ref_seq START WITH 1 INCREMENT BY 1 NOMAXVALUE;
CREATE TRIGGER var_ref_trigger BEFORE INSERT ON var_ref_table FOR EACH ROW BEGIN SELECT var_ref_seq.nextval INTO :new.REF FROM dual;END;

As before but a trigger is used to auto-increment the value.

The gateway should be able to detect the error conditions since version GA4.2 (AA-534).

Articles in this section

Geneos - Does the var_ref value in Database Logging have a maximum limit?

Comments

Articles in this section

Related articles