Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 17.11.2026 23:51
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2w 3d
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 1977768 kB
MemAvailable 7294376 kB
Buffers 79988 kB
Cached 5317012 kB
SwapCached 12 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Server and database settinfs


SERVER_MODE                     SuperServer 3.0.15
DB_NAME                         /var/db/oltp-emul/oltp-hq30.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/var/db/oltp-emul/oltp-hq30.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_30.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq30/bin
param=file_name_this_host_info, val=test-0
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=html_chart_color_memo_all, val=magenta
param=html_chart_color_memo_att, val=magenta
param=html_chart_color_memo_stm, val=magenta
param=html_chart_color_memo_trn, val=magenta
param=html_chart_color_perf_score, val=magenta
param=init_buff, val=4096
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=30300
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-hq30-results.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=50
param=tmpdir, val=/var/tmp/logs.oltp-hq30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-17 23:50:57
DTS_END                         2026-11-17 23:50:57.1330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/41120
TRN_ID                          224484
ATT_ID                          450
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 1000

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 50 minutes: 14708.72 832 735436
customer order: creation 657.34 50 32867
customer order: refuse 53.44 47 2672
order to supplier: creation 171.90 225 8595
order to supplier: removal 12.88 9471 644
invoice (draft): creation 165.30 379 8265
invoice (draft): removal 117.54 163 5877
invoice accept: apply 143.14 1635 7157
invoice accept: cancel 99.30 236 4965
customer reserve: creation 7055.64 28 352782
customer reserve: removal 5197.82 16 259891
realization accept: apply 312.66 37 15633
realization accept: cancel 183.04 21 9152
payment from customer: creation 220.96 34 11048
payment from customer: removal 21.60 18 1080
payment to supplier: creation 184.62 30 9231
payment to supplier: removal 12.72 18 636
service: total inventory turnovers 40.62 406 2031
service: total monetary turnovers 52.88 9 2644
service: aggregate perf. data 5.28 1914 264
service: refresh index statistics 0.04 1894 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 17-11-2026 23:51:10 to 17-11-2026 23:51:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6328
TEST_TIME 2 6204
TEST_TIME 3 7097
TEST_TIME 4 8622
TEST_TIME 5 9697
TEST_TIME 6 10273
TEST_TIME 7 10832
TEST_TIME 8 11328
TEST_TIME 9 11669
TEST_TIME 10 11933
TEST_TIME 11 12073
TEST_TIME 12 12094
TEST_TIME 13 12291
TEST_TIME 14 12364
TEST_TIME 15 12575
TEST_TIME 16 12606
TEST_TIME 17 12701
TEST_TIME 18 12836
TEST_TIME 19 12908
TEST_TIME 20 13014
TEST_TIME 21 13133
TEST_TIME 22 12938
TEST_TIME 23 13093
TEST_TIME 24 13192
TEST_TIME 25 13257
TEST_TIME 26 13257
TEST_TIME 27 13386
TEST_TIME 28 13460
TEST_TIME 29 13438
TEST_TIME 30 13534
TEST_TIME 31 13607
TEST_TIME 32 13749
TEST_TIME 33 13858
TEST_TIME 34 13911
TEST_TIME 35 13971
TEST_TIME 36 13980
TEST_TIME 37 14215
TEST_TIME 38 14241
TEST_TIME 39 14264
TEST_TIME 40 14302
TEST_TIME 41 14349
TEST_TIME 42 14419
TEST_TIME 43 14383
TEST_TIME 44 14470
TEST_TIME 45 14538
TEST_TIME 46 14536
TEST_TIME 47 14603
TEST_TIME 48 14659
TEST_TIME 49 14740
TEST_TIME 50 14709

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-11-2026 23:51:12 to 17-11-2026 23:51:15.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1082814 1082814 0 0.00 0 863 2 0 0
doc_list_biud 1082814 1082814 0 0.00 0 2788 6 0 0
sp_add_invoice_to_stock 7157 7157 0 0.00 6 14374 1635 0 0
sp_cancel_adding_invoice 4965 4965 0 0.00 3 5202 237 0 0
sp_cancel_client_order 2672 2672 0 0.00 3 708 48 0 0
sp_cancel_customer_reserve 259891 259891 0 0.00 1 2791 17 0 0
sp_cancel_pay_from_customer 1080 1080 0 0.00 2 233 19 0 0
sp_cancel_pay_to_supplier 636 636 0 0.00 2 143 18 0 0
sp_cancel_supplier_invoice 5877 5877 0 0.00 1 1292 163 0 0
sp_cancel_supplier_order 644 644 0 0.00 8 55864 9471 0 0
sp_cancel_write_off 9152 9152 0 0.00 1 531 21 0 0
sp_client_order 32867 32867 0 0.00 4 3234 50 0 0
sp_customer_reserve 352782 352782 0 0.00 0 2378 28 0 0
sp_fill_shopping_cart 49727 49727 0 0.00 1 1272 23 0 0
sp_fill_shopping_cart_clo_res 352782 352782 0 0.00 0 1145 3 0 0
sp_get_clo_for_invoice 7157 7157 0 0.00 0 1549 40 0 0
sp_kill_cost_storno 15833 15833 0 0.00 0 419 10 0 0
sp_kill_qstorno_ret_qs2qd 535455 535455 0 0.00 0 2785 8 0 0
sp_kill_qty_storno 305991 305991 0 0.00 0 2787 19 0 0
sp_lock_selected_doc 31593 31593 0 0.00 0 424 2 0 0
sp_make_cost_storno 43069 43069 0 0.00 0 849 7 0 0
sp_multiply_rows_for_pdistr 43069 43069 0 0.00 0 566 10 0 0
sp_multiply_rows_for_qdistr 32867 32867 0 0.00 0 797 20 0 0
sp_pay_from_customer 11048 11048 0 0.00 3 631 35 0 0
sp_pay_to_supplier 9231 9231 0 0.00 3 612 31 0 0
sp_payment_common 20279 20279 0 0.00 1 251 8 0 0
sp_qd_handle_on_cancel_clo 2672 2672 0 0.00 0 704 30 0 0
sp_qd_handle_on_invoice_upd_sts 12122 12122 0 0.00 0 1225 80 0 0
sp_qd_handle_on_reserve_upd_sts 15633 15633 0 0.00 0 1140 10 0 0
sp_reserve_write_off 15633 15633 0 0.00 4 1144 38 0 0
sp_supplier_invoice 8265 8265 0 0.00 6 5788 380 0 0
sp_supplier_order 8595 8595 0 0.00 7 2658 225 0 0
srv_aggregate_perf_data 264 264 0 0.00 75 14810 1915 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1285 269 0 0
srv_find_qd_qs_mism 683405 683405 0 0.00 0 858 1 0 0
srv_make_invnt_saldo 2031 2031 0 0.00 0 32223 406 0 0
srv_make_money_saldo 2644 2644 0 0.00 0 276 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 232 3556 1894 0 0
v_add_invoice_to_stock 14314 14314 0 0.00 0 396 3 0 0
v_all_customers 50328 50328 0 0.00 0 29 1 0 0
v_all_suppliers 41892 41892 0 0.00 0 38 1 0 0
v_all_wares 65734 65734 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 1240 1240 0 0.00 0 67 2 0 0
v_cancel_client_order 5344 5344 0 0.00 0 154 1 0 0
v_cancel_customer_prepayment 2160 2160 0 0.00 0 142 1 0 0
v_cancel_customer_reserve 2218 2218 0 0.00 0 150 2 0 0
v_cancel_payment_to_supplier 1272 1272 0 0.00 0 49 2 0 0
v_cancel_supplier_invoice 1096 1096 0 0.00 0 116 3 0 0
v_cancel_supplier_order 1288 1288 0 0.00 0 130 2 0 0
v_cancel_write_off 2988 2988 0 0.00 0 126 2 0 0
v_max_id_clo_ord 8595 8595 0 0.00 0 86 1 0 0
v_max_id_clo_res 1528 1528 0 0.00 0 196 1 0 0
v_max_id_ord_sup 8265 8265 0 0.00 0 292 2 0 0
v_max_non_paid_invoice 5145 5145 0 0.00 0 36 2 0 0
v_max_non_paid_realizn 10623 10623 0 0.00 0 132 2 0 0
v_min_id_clo_ord 8595 8595 0 0.00 0 415 3 0 0
v_min_id_clo_res 1528 1528 0 0.00 0 346 3 0 0
v_min_id_ord_sup 8265 8265 0 0.00 0 659 4 0 0
v_min_non_paid_invoice 9231 9231 0 0.00 0 232 3 0 0
v_min_non_paid_realizn 11048 11048 0 0.00 0 172 3 0 0
v_our_firm 16256 16256 0 0.00 0 20 1 0 0
v_reserve_write_off 31266 31266 0 0.00 0 279 1 0 0
x_lock_depdocs_on_canc_invoice 10294 10294 0 0.00 0 1109 11 0 0
x_lock_depdocs_on_canc_sup_ord 644 644 0 0.00 0 166 12 0 0
x_make_qstorno_1000_1200 8595 8595 0 0.00 1 2619 160 0 0
x_make_qstorno_1200_2000 8265 8265 0 0.00 1 5763 334 0 0
x_make_qstorno_2100_3300 352782 352782 0 0.00 0 2377 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2026 23:51:15 to 17-11-2026 23:51:19.

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, bytes
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = size of cache for metadata, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:01:01 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:01 186 2147483648 2603096320 2688901120 271129888 11.210 20 11 20 0 274328816 939824 2259104
23:03:02 306 2147483648 2589917904 2673037312 258244912 10.734 20 9 16 1 261086800 924512 1917376
23:04:02 112 2147483648 2603355184 2689880064 271960000 11.240 20 9 18 0 275005264 947264 2098000
23:05:03 160 2147483648 2601726864 2687324160 268350768 11.107 20 11 22 0 272634896 1696208 2587920
23:06:03 229 2147483648 2584691184 2670678016 253447216 10.556 20 8 12 1 256128864 995008 1686640
23:07:03 282 2147483648 2581100688 2663882752 247966416 10.351 19 9 18 0 250580704 989536 1624752
23:08:04 137 2147483648 2597648496 2683801600 263858032 10.942 20 11 22 0 267674736 1584304 2232400
23:09:04 342 2147483648 2601282688 2687123456 265487728 11.002 20 15 31 0 269850688 1122048 3240912
23:10:05 282 2147483648 2581550656 2667597824 248461328 10.370 19 10 20 0 251711040 1175936 2073776
23:11:05 144 2147483648 2597762544 2688118784 265358528 10.997 20 11 21 0 268141920 1387392 1396000
23:12:06 169 2147483648 2597853424 2685890560 265206736 10.992 20 12 24 1 268325840 907408 2211696
23:13:06 197 2147483648 2598421440 2686943232 265529952 11.004 20 16 30 0 269392880 1397568 2465360
23:14:06 1285 2147483648 2594804592 2682503168 261240832 10.845 20 11 23 0 264554784 1296560 2017392
23:15:08 166 2147483648 2601317248 2688589824 266698448 11.047 20 13 24 0 270238736 1467152 2073136
23:16:08 462 2147483648 2596792048 2685964288 264196448 10.954 20 10 18 0 267692048 1359600 2136000
23:17:09 796 2147483648 2593025520 2681577472 261086432 10.839 20 11 23 0 265219616 1192272 2940912
23:18:10 142 2147483648 2604825088 2692005888 268618368 11.117 20 15 30 0 274423920 2982192 2823360
23:19:11 180 2147483648 2591781648 2678566912 257924752 10.722 20 10 20 0 261371024 1708064 1738208
23:20:11 95 2147483648 2596476512 2684325888 261633376 10.860 20 12 23 0 266766272 2685440 2447456
23:21:11 295 2147483648 2600548544 2688249856 265013040 10.985 20 13 27 0 269442272 1889952 2539280
23:22:12 294 2147483648 2598473200 2689597440 265484944 11.002 20 4 8 0 267475376 1352288 638144
23:23:13 131 2147483648 2600261840 2688143360 263085328 10.913 20 13 26 0 269461264 3110160 3265776
23:24:13 132 2147483648 2596518560 2683936768 258468048 10.742 19 12 25 1 266412736 5637712 2306976
23:25:14 173 2147483648 2578620800 2663788544 244571488 10.224 19 8 16 0 248200064 2365376 1263200
23:26:14 140 2147483648 2601286768 2692755456 268825072 11.125 20 8 14 0 271505376 1294896 1385408
23:27:15 171 2147483648 2602178400 2689372160 264368176 10.961 20 15 28 0 271564320 3729360 3466784
23:28:15 169 2147483648 2604002112 2695233536 269264448 11.141 20 7 12 0 273002464 2087104 1650912
23:29:15 95 2147483648 2598894112 2689298432 265449216 11.001 20 5 10 0 269528656 1457184 2622256
23:30:16 154 2147483648 2605166784 2693439488 269431280 11.147 20 17 33 0 275426864 2402160 3593424
23:31:16 247 2147483648 2600566416 2690826240 266735456 11.048 20 12 24 0 271789472 2237568 2816448
23:32:17 131 2147483648 2609154944 2696826880 270696752 11.194 20 14 28 0 278078288 4561728 2819808
23:33:17 123 2147483648 2602133248 2689257472 264925136 10.981 20 12 25 0 269249312 1996944 2327232
23:34:18 123 2147483648 2587146848 2675941376 255224288 10.622 20 6 13 0 257420624 1036416 1159920
23:35:18 191 2147483648 2597473936 2686492672 263060080 10.912 20 13 26 0 266739952 1248736 2431136
23:36:18 414 2147483648 2592956944 2682355712 259299360 10.773 20 12 23 0 263041344 1600400 2141584
23:37:19 194 2147483648 2603438592 2690678784 265995056 11.021 20 13 26 0 271285568 2420576 2869936
23:38:20 136 2147483648 2603020256 2692874240 267532096 11.077 20 14 28 0 272010176 1183648 3294432
23:39:21 151 2147483648 2575030400 2660986880 241936000 10.125 19 13 25 0 245203264 1014704 2252560
23:40:21 216 2147483648 2594457744 2683887616 260805472 10.829 20 9 17 0 263822032 1019040 1997520
23:41:21 139 2147483648 2602765808 2689134592 265036112 10.985 20 19 38 1 271220064 2622400 3561552
23:42:22 143 2147483648 2598185280 2688643072 264937536 10.982 20 10 20 0 268053680 1381472 1734672
23:43:23 164 2147483648 2599424096 2688864256 265306944 10.995 20 8 16 0 268994384 1853040 1834400
23:44:23 1100 2147483648 2598126144 2684915712 262507440 10.892 20 14 28 1 267195920 2083056 2605424
23:45:24 207 2147483648 2602925440 2690514944 264055888 10.949 20 15 30 1 271166720 3766928 3343904
23:46:25 412 2147483648 2594350480 2683920384 260356480 10.812 20 8 16 0 263318880 1497872 1464528
23:47:26 400 2147483648 2598075856 2685984768 261640640 10.860 20 10 20 0 265570592 1905328 2024624
23:48:27 379 2147483648 2607752432 2698051584 271339424 11.217 20 11 22 0 276496224 3050352 2106448
23:49:27 178 2147483648 2600338256 2689503232 264435136 10.963 20 12 24 0 269327104 2501248 2390720
23:50:27 758 2147483648 2597006976 2687778816 263399280 10.925 20 10 21 0 267039792 1622176 2018336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 17-11-2026 23:51:20 to 17-11-2026 23:51:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 17-11-2026 23:51:32 to 17-11-2026 23:51:33.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq30.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          224623
MON$OLDEST_ACTIVE               224624
MON$OLDEST_SNAPSHOT             224624
MON$NEXT_TRANSACTION            224624
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-17 23:00:09.2450
MON$PAGES                       145792
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.15.33893 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33893 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
on disk structure version 12.0

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs.oltp-hq30 according to config parameter 'remove_isql_logs'

17.11.26 23:51:34. There are 3 logs in /var/tmp/logs.oltp-hq30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2026-11-17 23:51:35 No severe PSQL-related problems occured
17.11.26 23:51:36. End of report.