Consistency check

[mitsu-ko]

Hi,

I use consistency check feature in HammerDB 4.10 on PostgreSQL 15.6. Before benchmark, 'checkschema' is done without error. After running TPC-C benchmark, I run 'checkschame', consistency check fail is outputted under following.

Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Checking tpcc TPROC-C schema
Vuser 1:Check database
Vuser 1:Check tables and indices
Vuser 1:Check procedures
Vuser 1:Check consistency 1
Vuser 1:Check consistency 2
Error in Virtual User 1: TPROC-C Schema check failed tpcc schema consistency check 2 failed
Vuser 1:FINISHED FAILED

Does it means HammerDB bug or PostgreSQL bug? And I'd like to know more detail information why check is failed. It's important problem. But error message is too simple.

Regards,

[sm-shaw]

I can reproduce, and this is a HammerDB bug. I will create an issue from the discussion for the fix.
The bug/fix will not have any impact on test performance.

[sm-shaw]

Issue #687 has been raised with further explanation.

[sm-shaw]

PR #688 fixes the issue and the consistency checks run successfully afterwards.

[mitsu-ko]

Hi sm-shaw-san,

Thank you very much for your fast work. I think consistency check feature is very interesting. I appreciate for your work.

Regards,

[sm-shaw]

No problem, and thank-you for raising the issue. I am not entirely sure how this bug got through but that is what the consistency checks are for to identify issues in both the HammerDB and database code. For example, when testing distributed databases and replication it will be a good check to ensure that all parts of the system are working.