"Out of range value" Is Displayed When HammerDB Is Used
Symptom
The message "Out of range value" is displayed if the data volume is too large (for example, 1 TB) when HammerDB is used.
Key Process and Cause Analysis
When the data volume is large, data values may exceed the representation range of the INT type.
Conclusion and Solution
You can use a data type that can represent a wider range.
Modify the mysqlolap.tcl file in the /home/HammerDB-3.2/src/mysql directory. Change the INT type in lines 53 and 133 to BIGINT.
- INT: integer of the normal size, which can be signed. If the value is signed, it ranges from -2,147,483,648 to 2,147,483,647. If the value is unsigned, it ranges from 0 to 4,294,967,295. Up to 11-bit width can be specified.
- BIGINT: a large integer, which can be signed. If the value is signed, the value ranges from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. If the value is unsigned, the value ranges from 0 to 18,446,744,073,709,551,615. Up to 20-bit width can be specified.
Parent topic: Troubleshooting