Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 11.11.2026 11: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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 1w 4d
Command: who -b
bootup_info system boot 2026-11-09 10: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 8138016 kB
MemFree 1899776 kB
MemAvailable 7303540 kB
Buffers 79992 kB
Cached 5444296 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-11 11:50:57
DTS_END                         2026-11-11 11:50:57.2710
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/60674
TRN_ID                          220854
ATT_ID                          461
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: 14517.18 967 725859
customer order: creation 652.38 47 32619
customer order: refuse 54.06 48 2703
order to supplier: creation 164.22 211 8211
order to supplier: removal 12.04 9246 602
invoice (draft): creation 161.32 357 8066
invoice (draft): removal 117.66 149 5883
invoice accept: apply 138.82 1618 6941
invoice accept: cancel 98.42 222 4921
customer reserve: creation 6944.64 27 347232
customer reserve: removal 5165.26 15 258263
realization accept: apply 304.80 36 15240
realization accept: cancel 179.56 20 8978
payment from customer: creation 215.58 34 10779
payment from customer: removal 22.04 19 1102
payment to supplier: creation 179.62 36 8981
payment to supplier: removal 12.50 18 625
service: total inventory turnovers 38.28 425 1914
service: total monetary turnovers 51.36 8 2568
service: aggregate perf. data 4.58 1866 229
service: refresh index statistics 0.04 4930 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7783
TEST_TIME 2 9389
TEST_TIME 3 10114
TEST_TIME 4 11086
TEST_TIME 5 11381
TEST_TIME 6 11689
TEST_TIME 7 12081
TEST_TIME 8 12221
TEST_TIME 9 12451
TEST_TIME 10 12555
TEST_TIME 11 12643
TEST_TIME 12 12836
TEST_TIME 13 13066
TEST_TIME 14 13222
TEST_TIME 15 13154
TEST_TIME 16 13297
TEST_TIME 17 13337
TEST_TIME 18 13400
TEST_TIME 19 13368
TEST_TIME 20 13342
TEST_TIME 21 13294
TEST_TIME 22 13348
TEST_TIME 23 13388
TEST_TIME 24 13363
TEST_TIME 25 13340
TEST_TIME 26 13414
TEST_TIME 27 13538
TEST_TIME 28 13521
TEST_TIME 29 13460
TEST_TIME 30 13563
TEST_TIME 31 13606
TEST_TIME 32 13617
TEST_TIME 33 13699
TEST_TIME 34 13762
TEST_TIME 35 13847
TEST_TIME 36 13923
TEST_TIME 37 14018
TEST_TIME 38 14128
TEST_TIME 39 14115
TEST_TIME 40 14134
TEST_TIME 41 14165
TEST_TIME 42 14258
TEST_TIME 43 14262
TEST_TIME 44 14330
TEST_TIME 45 14354
TEST_TIME 46 14375
TEST_TIME 47 14394
TEST_TIME 48 14493
TEST_TIME 49 14473
TEST_TIME 50 14517

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 11-11-2026 11:51:11 to 11-11-2026 11:51:13.

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 1067486 1067486 0 0.00 0 771 2 0 0
doc_list_biud 1067486 1067486 0 0.00 0 2082 5 0 0
sp_add_invoice_to_stock 6941 6941 0 0.00 6 15644 1619 0 0
sp_cancel_adding_invoice 4921 4921 0 0.00 3 6167 223 0 0
sp_cancel_client_order 2703 2703 0 0.00 2 1158 48 0 0
sp_cancel_customer_reserve 258263 258263 0 0.00 1 1797 16 0 0
sp_cancel_pay_from_customer 1102 1102 0 0.00 2 347 20 0 0
sp_cancel_pay_to_supplier 625 625 0 0.00 2 293 18 0 0
sp_cancel_supplier_invoice 5883 5883 0 0.00 1 1020 150 0 0
sp_cancel_supplier_order 602 602 0 0.00 9 58767 9247 0 0
sp_cancel_write_off 8978 8978 0 0.00 1 879 20 0 0
sp_client_order 32619 32619 0 0.00 4 1428 47 0 0
sp_customer_reserve 347232 347232 0 0.00 0 2345 28 0 0
sp_fill_shopping_cart 48896 48896 0 0.00 1 1918 20 0 0
sp_fill_shopping_cart_clo_res 347232 347232 0 0.00 0 991 3 0 0
sp_get_clo_for_invoice 6941 6941 0 0.00 0 1081 38 0 0
sp_kill_cost_storno 15626 15626 0 0.00 0 714 10 0 0
sp_kill_qstorno_ret_qs2qd 531989 531989 0 0.00 0 1543 8 0 0
sp_kill_qty_storno 303531 303531 0 0.00 0 2081 18 0 0
sp_lock_selected_doc 31002 31002 0 0.00 0 344 2 0 0
sp_make_cost_storno 41941 41941 0 0.00 0 770 7 0 0
sp_multiply_rows_for_pdistr 41941 41941 0 0.00 0 655 10 0 0
sp_multiply_rows_for_qdistr 32619 32619 0 0.00 0 968 18 0 0
sp_pay_from_customer 10779 10779 0 0.00 3 708 34 0 0
sp_pay_to_supplier 8981 8981 0 0.00 3 777 36 0 0
sp_payment_common 19760 19760 0 0.00 1 395 11 0 0
sp_qd_handle_on_cancel_clo 2703 2703 0 0.00 0 1145 32 0 0
sp_qd_handle_on_invoice_upd_sts 11862 11862 0 0.00 0 2079 71 0 0
sp_qd_handle_on_reserve_upd_sts 15240 15240 0 0.00 0 1029 10 0 0
sp_reserve_write_off 15240 15240 0 0.00 3 1041 36 0 0
sp_supplier_invoice 8066 8066 0 0.00 6 4686 358 0 0
sp_supplier_order 8211 8211 0 0.00 5 2762 211 0 0
srv_aggregate_perf_data 229 229 0 0.00 20 10354 1866 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1237 294 0 0
srv_find_qd_qs_mism 674765 674765 0 0.00 0 709 1 0 0
srv_make_invnt_saldo 1914 1914 0 0.00 1 40757 426 0 0
srv_make_money_saldo 2568 2568 0 0.00 0 197 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 210 9650 4930 0 0
v_add_invoice_to_stock 13882 13882 0 0.00 0 324 3 0 0
v_all_customers 49836 49836 0 0.00 0 32 1 0 0
v_all_suppliers 40462 40462 0 0.00 0 65 1 0 0
v_all_wares 65238 65238 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 1240 1240 0 0.00 0 254 2 0 0
v_cancel_client_order 5406 5406 0 0.00 0 312 1 0 0
v_cancel_customer_prepayment 2204 2204 0 0.00 0 132 2 0 0
v_cancel_customer_reserve 2180 2180 0 0.00 0 394 2 0 0
v_cancel_payment_to_supplier 1250 1250 0 0.00 0 66 2 0 0
v_cancel_supplier_invoice 1122 1122 0 0.00 0 267 4 0 0
v_cancel_supplier_order 1204 1204 0 0.00 0 62 1 0 0
v_cancel_write_off 3036 3036 0 0.00 0 200 2 0 0
v_max_id_clo_ord 8211 8211 0 0.00 0 63 1 0 0
v_max_id_clo_res 1571 1571 0 0.00 0 214 2 0 0
v_max_id_ord_sup 8066 8066 0 0.00 0 495 2 0 0
v_max_non_paid_invoice 5027 5027 0 0.00 0 48 2 0 0
v_max_non_paid_realizn 10346 10346 0 0.00 0 39 2 0 0
v_min_id_clo_ord 8211 8211 0 0.00 0 273 3 0 0
v_min_id_clo_res 1571 1571 0 0.00 0 393 4 0 0
v_min_id_ord_sup 8066 8066 0 0.00 0 805 5 0 0
v_min_non_paid_invoice 8981 8981 0 0.00 0 393 9 0 0
v_min_non_paid_realizn 10779 10779 0 0.00 0 340 3 0 0
v_our_firm 16268 16268 0 0.00 0 30 1 0 0
v_reserve_write_off 30480 30480 0 0.00 0 373 1 0 0
x_lock_depdocs_on_canc_invoice 10243 10243 0 0.00 0 879 10 0 0
x_lock_depdocs_on_canc_sup_ord 602 602 0 0.00 0 335 10 0 0
x_make_qstorno_1000_1200 8211 8211 0 0.00 1 2730 156 0 0
x_make_qstorno_1200_2000 8066 8066 0 0.00 1 4630 314 0 0
x_make_qstorno_2100_3300 347232 347232 0 0.00 0 2332 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2026 11:51:14 to 11-11-2026 11:51:18.

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
11:01:01 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:01 217 2147483648 2566005568 2644639744 235639232 9.887 19 7 14 1 237986272 797056 1549984
11:03:02 235 2147483648 2601947984 2688831488 271125632 11.209 20 5 10 0 273030480 1132544 772304
11:04:02 209 2147483648 2605293056 2691403776 268963456 11.130 20 10 20 2 275681392 4726384 1991552
11:05:03 214 2147483648 2586422176 2669719552 252973648 10.538 20 11 21 0 256295664 953568 2368448
11:06:03 149 2147483648 2601000688 2688315392 268429568 11.110 20 9 16 0 271494048 1053696 2010784
11:07:04 244 2147483648 2593094368 2678370304 259583696 10.784 20 12 23 0 262676368 1229408 1863264
11:08:04 498 2147483648 2604938704 2693709824 271742032 11.232 20 12 22 0 275095024 1443344 1909648
11:09:05 483 2147483648 2595246688 2682499072 261701968 10.862 20 8 16 0 265123904 1481824 1940112
11:10:05 118 2147483648 2594368272 2681311232 260994224 10.836 20 11 22 0 264158384 1125968 2038192
11:11:06 665 2147483648 2576608704 2662035456 244671600 10.228 19 10 20 0 247989424 1291616 2026208
11:12:06 180 2147483648 2597542304 2687463424 266231776 11.029 20 9 19 0 270572336 2156960 2183600
11:13:07 530 2147483648 2594441216 2682417152 262083712 10.876 20 8 15 0 264679152 1215088 1380352
11:14:08 598 2147483648 2596729936 2684997632 262746256 10.901 20 14 27 0 267442944 1609056 3087632
11:15:08 330 2147483648 2600180704 2690101248 267411024 11.073 20 10 20 0 269993536 1072784 1509728
11:16:09 358 2147483648 2598899552 2686308352 264220416 10.955 20 11 22 0 268340976 1966192 2154368
11:17:10 174 2147483648 2593622208 2682212352 260267328 10.809 20 9 16 0 263565056 1364144 1933584
11:18:10 151 2147483648 2594047376 2680786944 260046912 10.801 20 11 22 0 264269760 2072096 2150752
11:19:11 161 2147483648 2599848960 2687787008 266233408 11.030 20 13 24 0 270713856 1626560 2853888
11:20:11 1234 2147483648 2603819824 2690969600 267317568 11.069 20 14 30 0 273032368 2210336 3504464
11:21:13 306 2147483648 2598669952 2688266240 264520176 10.966 20 10 20 1 268428128 1979440 1928512
11:22:13 223 2147483648 2586862400 2674618368 253553056 10.560 20 13 27 2 256926208 1118768 2254384
11:23:14 158 2147483648 2595183776 2682073088 258617024 10.748 20 13 26 0 263057424 2061696 2378704
11:24:14 219 2147483648 2600552064 2690035712 266629984 11.044 20 13 24 1 269926784 1074128 2222672
11:25:15 1111 2147483648 2597156208 2686537728 264316864 10.959 20 8 16 0 267779824 1891248 1571712
11:26:17 297 2147483648 2608969728 2698559488 268512592 11.113 20 11 22 1 279026208 8006848 2506768
11:27:17 114 2147483648 2594891280 2682302464 257322832 10.700 20 13 26 0 263758736 3882528 2553376
11:28:18 109 2147483648 2602675408 2692444160 267267392 11.068 20 9 19 0 271622496 2775040 1580064
11:29:18 262 2147483648 2593224288 2681761792 260947456 10.834 20 6 13 0 262828288 944416 936416
11:30:19 150 2147483648 2603574112 2689650688 265912736 11.018 20 14 29 0 272396704 3668464 2815504
11:31:19 248 2147483648 2607626992 2698412032 272793248 11.271 20 10 20 1 277530800 2648000 2089552
11:32:20 169 2147483648 2588419952 2674458624 252175872 10.508 20 9 18 0 257242304 3026976 2039456
11:33:20 285 2147483648 2593146560 2681573376 259532256 10.782 20 12 24 0 263294992 1468768 2293968
11:34:20 106 2147483648 2603748064 2692116480 268128224 11.099 20 12 22 1 273357232 2416448 2812560
11:35:21 179 2147483648 2594683328 2683793408 259535248 10.782 20 11 22 0 264040496 2326048 2179200
11:36:21 310 2147483648 2599639120 2689200128 264813008 10.977 20 9 18 0 269474688 2772848 1888832
11:37:22 275 2147483648 2605357424 2694942720 269689536 11.157 20 10 20 0 274044992 2279440 2076016
11:38:23 117 2147483648 2599714224 2688901120 264699264 10.973 20 13 26 0 269515664 2259488 2556912
11:39:24 257 2147483648 2570889136 2656849920 237594544 9.961 19 10 21 0 240851840 1403616 1853680
11:40:24 447 2147483648 2596289616 2686607360 263202816 10.918 20 8 16 0 265835840 1203440 1429584
11:41:26 183 2147483648 2590797264 2678534144 255435424 10.630 19 10 20 0 259071040 2112736 1522880
11:42:27 176 2147483648 2581784832 2667081728 246440608 10.294 20 12 24 0 251516208 2299120 2776480
11:43:27 252 2147483648 2595799216 2685112320 263064336 10.913 20 9 19 0 266195104 1336368 1794400
11:44:28 400 2147483648 2603367856 2693763072 267153088 11.063 20 11 22 0 272539536 3270528 2115920
11:45:29 311 2147483648 2605193968 2695581696 268010720 11.095 20 9 18 0 274664768 4419584 2234464
11:46:29 152 2147483648 2595243104 2683699200 260654832 10.823 20 11 22 0 264254128 1505696 2093600
11:47:30 373 2147483648 2599266688 2687193088 263809168 10.940 20 11 20 1 268031456 2167456 2054832
11:48:30 187 2147483648 2610208784 2700697600 273104752 11.282 20 12 22 0 279633008 4172224 2356032
11:49:31 194 2147483648 2597524000 2688684032 263363872 10.924 20 8 16 0 266815296 2061552 1389872
11:50:31 201 2147483648 2601174864 2689187840 263607040 10.933 20 15 31 0 269655792 2965296 3083456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 11-11-2026 11:51:19 to 11-11-2026 11:51:31.

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 11-11-2026 11:51:32 to 11-11-2026 11: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          221064
MON$OLDEST_ACTIVE               221065
MON$OLDEST_SNAPSHOT             221065
MON$NEXT_TRANSACTION            221065
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-11 11:00:10.8330
MON$PAGES                       136064
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 ---
:6: 
:7: test-0    Wed Nov 11 11:50:57 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov 11 11:50:58 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
--- end of diff output ---

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

11.11.26 11:51:33. 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-11 11:51:35 No severe PSQL-related problems occured
11.11.26 11:51:35. End of report.