Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 16.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 2d
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 1933652 kB
MemAvailable 7292944 kB
Buffers 79360 kB
Cached 5362740 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-16 23:51:04
DTS_END                         2026-11-16 23:51:04.6260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/33896
TRN_ID                          235403
ATT_ID                          476
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: 15809.18 835 790459
customer order: creation 697.78 45 34889
customer order: refuse 57.54 47 2877
order to supplier: creation 179.02 204 8951
order to supplier: removal 13.60 8729 680
invoice (draft): creation 178.26 358 8913
invoice (draft): removal 131.30 151 6565
invoice accept: apply 148.34 1541 7417
invoice accept: cancel 105.42 221 5271
customer reserve: creation 7578.94 25 378947
customer reserve: removal 5633.04 15 281652
realization accept: apply 323.38 34 16169
realization accept: cancel 197.66 19 9883
payment from customer: creation 232.90 32 11645
payment from customer: removal 22.70 17 1135
payment to supplier: creation 192.52 28 9626
payment to supplier: removal 13.56 15 678
service: total inventory turnovers 41.32 431 2066
service: total monetary turnovers 56.78 8 2839
service: aggregate perf. data 5.08 1883 254
service: refresh index statistics 0.04 2899 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 16-11-2026 23:51:18 to 16-11-2026 23:51:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 18991
TEST_TIME 2 16050
TEST_TIME 3 15446
TEST_TIME 4 15305
TEST_TIME 5 15024
TEST_TIME 6 15233
TEST_TIME 7 14984
TEST_TIME 8 14922
TEST_TIME 9 14860
TEST_TIME 10 14926
TEST_TIME 11 14927
TEST_TIME 12 14912
TEST_TIME 13 15147
TEST_TIME 14 15087
TEST_TIME 15 15083
TEST_TIME 16 15054
TEST_TIME 17 15085
TEST_TIME 18 15133
TEST_TIME 19 15016
TEST_TIME 20 15105
TEST_TIME 21 15058
TEST_TIME 22 15120
TEST_TIME 23 15139
TEST_TIME 24 15199
TEST_TIME 25 15160
TEST_TIME 26 15156
TEST_TIME 27 15191
TEST_TIME 28 15347
TEST_TIME 29 15328
TEST_TIME 30 15373
TEST_TIME 31 15368
TEST_TIME 32 15513
TEST_TIME 33 15528
TEST_TIME 34 15543
TEST_TIME 35 15654
TEST_TIME 36 15611
TEST_TIME 37 15585
TEST_TIME 38 15676
TEST_TIME 39 15734
TEST_TIME 40 15703
TEST_TIME 41 15814
TEST_TIME 42 15788
TEST_TIME 43 15884
TEST_TIME 44 15924
TEST_TIME 45 15982
TEST_TIME 46 15955
TEST_TIME 47 15987
TEST_TIME 48 15983
TEST_TIME 49 16108
TEST_TIME 50 15809

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-11-2026 23:51:20 to 16-11-2026 23:51:23.

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 1160722 1160722 0 0.00 0 928 2 0 0
doc_list_biud 1160722 1160722 0 0.00 0 1544 5 0 0
sp_add_invoice_to_stock 7417 7417 0 0.00 10 13437 1541 0 0
sp_cancel_adding_invoice 5271 5271 0 0.00 3 4691 222 0 0
sp_cancel_client_order 2877 2877 0 0.00 3 865 47 0 0
sp_cancel_customer_reserve 281652 281652 0 0.00 1 1420 15 0 0
sp_cancel_pay_from_customer 1135 1135 0 0.00 2 167 17 0 0
sp_cancel_pay_to_supplier 678 678 0 0.00 2 121 16 0 0
sp_cancel_supplier_invoice 6565 6565 0 0.00 1 1326 151 0 0
sp_cancel_supplier_order 680 680 0 0.00 4 60843 8729 0 0
sp_cancel_write_off 9883 9883 0 0.00 1 939 20 0 0
sp_client_order 34889 34889 0 0.00 4 1058 45 0 0
sp_customer_reserve 378947 378947 0 0.00 0 2015 26 0 0
sp_fill_shopping_cart 52753 52753 0 0.00 1 1468 20 0 0
sp_fill_shopping_cart_clo_res 378947 378947 0 0.00 0 924 2 0 0
sp_get_clo_for_invoice 7417 7417 0 0.00 0 1358 38 0 0
sp_kill_cost_storno 16967 16967 0 0.00 0 846 9 0 0
sp_kill_qstorno_ret_qs2qd 580432 580432 0 0.00 0 1451 8 0 0
sp_kill_qty_storno 330514 330514 0 0.00 0 1544 18 0 0
sp_lock_selected_doc 32939 32939 0 0.00 0 367 2 0 0
sp_make_cost_storno 44857 44857 0 0.00 0 839 7 0 0
sp_multiply_rows_for_pdistr 44857 44857 0 0.00 0 460 9 0 0
sp_multiply_rows_for_qdistr 34889 34889 0 0.00 0 1012 18 0 0
sp_pay_from_customer 11645 11645 0 0.00 3 845 32 0 0
sp_pay_to_supplier 9626 9626 0 0.00 3 895 28 0 0
sp_payment_common 21271 21271 0 0.00 1 407 7 0 0
sp_qd_handle_on_cancel_clo 2877 2877 0 0.00 0 862 31 0 0
sp_qd_handle_on_invoice_upd_sts 12688 12688 0 0.00 0 1065 74 0 0
sp_qd_handle_on_reserve_upd_sts 16169 16169 0 0.00 0 1544 9 0 0
sp_reserve_write_off 16169 16169 0 0.00 3 1556 35 0 0
sp_supplier_invoice 8913 8913 0 0.00 7 3102 359 0 0
sp_supplier_order 8951 8951 0 0.00 5 1860 204 0 0
srv_aggregate_perf_data 254 254 0 0.00 80 14182 1884 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 929 254 0 0
srv_find_qd_qs_mism 734076 734076 0 0.00 0 928 1 0 0
srv_make_invnt_saldo 2066 2066 0 0.00 0 73180 431 0 0
srv_make_money_saldo 2839 2839 0 0.00 0 324 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 215 5584 2900 0 0
v_add_invoice_to_stock 14834 14834 0 0.00 0 655 3 0 0
v_all_customers 52954 52954 0 0.00 0 26 1 0 0
v_all_suppliers 44586 44586 0 0.00 0 47 1 0 0
v_all_wares 69778 69778 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 1306 1306 0 0.00 0 285 2 0 0
v_cancel_client_order 5754 5754 0 0.00 0 199 1 0 0
v_cancel_customer_prepayment 2270 2270 0 0.00 0 156 1 0 0
v_cancel_customer_reserve 2098 2098 0 0.00 0 266 2 0 0
v_cancel_payment_to_supplier 1356 1356 0 0.00 0 23 1 0 0
v_cancel_supplier_invoice 1258 1258 0 0.00 0 64 3 0 0
v_cancel_supplier_order 1360 1360 0 0.00 0 30 1 0 0
v_cancel_write_off 3304 3304 0 0.00 0 357 2 0 0
v_max_id_clo_ord 8951 8951 0 0.00 0 68 1 0 0
v_max_id_clo_res 1566 1566 0 0.00 0 259 1 0 0
v_max_id_ord_sup 8913 8913 0 0.00 0 469 2 0 0
v_max_non_paid_invoice 5197 5197 0 0.00 0 129 2 0 0
v_max_non_paid_realizn 11211 11211 0 0.00 0 50 1 0 0
v_min_id_clo_ord 8951 8951 0 0.00 0 249 3 0 0
v_min_id_clo_res 1566 1566 0 0.00 0 347 3 0 0
v_min_id_ord_sup 8913 8913 0 0.00 0 743 4 0 0
v_min_non_paid_invoice 9626 9626 0 0.00 0 402 3 0 0
v_min_non_paid_realizn 11645 11645 0 0.00 0 356 2 0 0
v_our_firm 17692 17692 0 0.00 0 24 1 0 0
v_reserve_write_off 32338 32338 0 0.00 0 730 1 0 0
x_lock_depdocs_on_canc_invoice 11207 11207 0 0.00 0 737 9 0 0
x_lock_depdocs_on_canc_sup_ord 680 680 0 0.00 0 125 10 0 0
x_make_qstorno_1000_1200 8951 8951 0 0.00 1 1771 148 0 0
x_make_qstorno_1200_2000 8913 8913 0 0.00 1 3083 315 0 0
x_make_qstorno_2100_3300 378947 378947 0 0.00 0 2010 22 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 16-11-2026 23:51:23 to 16-11-2026 23:51:26.

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:08 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:08 148 2147483648 2550474800 2626924544 221051200 9.332 18 8 13 0 222902208 666928 1184080
23:03:09 334 2147483648 2596039104 2681036800 264447360 10.964 20 6 12 0 266507696 743584 1316752
23:04:09 272 2147483648 2604789136 2690486272 271818992 11.235 20 14 31 1 275677408 1009952 2848464
23:05:10 193 2147483648 2599892336 2685083648 264757376 10.975 20 15 30 1 269422208 1694720 2970112
23:06:10 180 2147483648 2573610416 2656559104 239977072 10.051 19 15 30 0 244518352 1437984 3103296
23:07:10 239 2147483648 2604375376 2692055040 270552048 11.188 20 12 26 1 275291648 1763552 2976048
23:08:11 68 2147483648 2597577584 2683899904 263253776 10.920 20 13 26 0 267006032 1337568 2414688
23:09:11 273 2147483648 2596817456 2684784640 263649552 10.934 20 9 16 0 266229344 1146304 1433488
23:10:12 194 2147483648 2602047984 2689650688 265678640 11.009 20 10 20 0 272550272 4941312 1930320
23:11:12 165 2147483648 2593209792 2679402496 259680800 10.787 20 16 34 0 264246720 1337168 3228752
23:12:13 238 2147483648 2586967824 2672078848 252009632 10.502 19 12 23 0 255291888 1030864 2251392
23:13:13 200 2147483648 2601495488 2689761280 269793952 11.161 20 14 28 0 273733152 1005920 2933280
23:14:14 188 2147483648 2596951408 2685714432 261607440 10.859 20 13 24 1 266489952 2525264 2357248
23:15:14 650 2147483648 2597554112 2686947328 264082608 10.950 20 9 18 0 267203936 1540624 1580704
23:16:15 629 2147483648 2597641984 2687283200 264706080 10.973 20 8 16 0 267188464 1268160 1214224
23:17:17 193 2147483648 2580407792 2666344448 247629360 10.338 20 10 20 0 251331296 1775328 1926608
23:18:17 166 2147483648 2598152432 2685816832 263463840 10.927 20 9 16 1 267954304 2358368 2132096
23:19:18 141 2147483648 2592353664 2679218176 257101792 10.692 20 12 24 0 262123488 2700416 2321280
23:20:18 161 2147483648 2594774576 2682499072 261484208 10.854 20 14 28 1 265658608 1460576 2713824
23:21:19 149 2147483648 2602107520 2689585152 266305520 11.032 20 13 24 0 271982288 2366656 3310112
23:22:19 929 2147483648 2594908144 2685956096 262560096 10.894 20 5 10 0 264726992 1298032 868864
23:23:20 265 2147483648 2595230688 2681323520 259450800 10.779 20 10 20 0 263479744 2076288 1952656
23:24:21 314 2147483648 2606596480 2693603328 269130640 11.136 20 17 34 0 275011040 2263232 3617168
23:25:21 248 2147483648 2599319584 2686103552 260279904 10.810 20 12 24 0 267381904 4658512 2443488
23:26:22 768 2147483648 2601479312 2691166208 266154880 11.027 20 7 14 0 269110704 1754464 1201360
23:27:22 515 2147483648 2602385936 2692255744 268912752 11.128 20 12 22 0 271911616 1257376 1741488
23:28:23 131 2147483648 2599691424 2686984192 262760592 10.901 20 15 30 0 268369008 2341168 3267248
23:29:24 201 2147483648 2607620912 2696216576 268078032 11.097 20 14 28 0 277172528 6076544 3017952
23:30:25 264 2147483648 2600187840 2691129344 267067056 11.060 20 6 12 0 270175776 1965456 1143264
23:31:25 105 2147483648 2588952672 2672939008 251247984 10.474 19 17 33 0 257172272 2996208 2928080
23:32:26 315 2147483648 2576019696 2661974016 242257504 10.137 19 10 20 0 245644736 1512896 1874336
23:33:26 190 2147483648 2600512960 2689454080 265315600 10.996 20 12 24 0 269251712 1281328 2654784
23:34:27 161 2147483648 2600194448 2689318912 263147584 10.916 20 11 22 0 268837120 3499936 2189600
23:35:27 168 2147483648 2602054656 2691211264 267566128 11.079 20 10 21 0 270831760 1176336 2089296
23:36:28 184 2147483648 2601188016 2689118208 265930304 11.018 20 13 25 0 270592160 2102672 2559184
23:37:28 262 2147483648 2596097472 2688073728 263185872 10.917 20 7 14 0 266130608 1574608 1370128
23:38:29 350 2147483648 2591810768 2680127488 258005664 10.725 20 7 14 0 260456464 1373136 1077664
23:39:29 273 2147483648 2601167872 2689515520 264715584 10.974 20 15 30 0 269932288 2370352 2846352
23:40:30 189 2147483648 2604832272 2693099520 266967216 11.057 20 14 26 0 273695312 3874528 2853568
23:41:30 238 2147483648 2597751104 2689011712 265301920 10.995 20 6 12 0 267616624 1423648 891056
23:42:31 125 2147483648 2600792240 2690875392 266122208 11.025 20 9 18 0 270106624 2244128 1740288
23:43:31 218 2147483648 2599191152 2687545344 263143872 10.915 20 14 26 0 267785728 1927104 2714752
23:44:32 203 2147483648 2603907856 2693509120 267081760 11.061 20 11 22 0 273009440 3771632 2156048
23:45:32 204 2147483648 2601652272 2690818048 263967856 10.946 20 9 18 0 269577760 4000704 1609200
23:46:34 256 2147483648 2604499120 2694090752 267877984 11.090 20 10 20 0 273143200 3329664 1935552
23:47:35 162 2147483648 2592609504 2682601472 258593648 10.747 20 10 22 0 262072304 1443952 2034704
23:48:35 195 2147483648 2604100176 2692665344 267961792 11.093 20 12 24 0 272311296 2084800 2264704
23:49:35 150 2147483648 2599869504 2690252800 264624416 10.970 20 10 20 0 268220736 1385280 2211040
23:50:36 150 2147483648 2603576560 2691858432 265349104 10.997 20 11 22 0 272772880 4799088 2624688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 16-11-2026 23:51:27 to 16-11-2026 23:51:38.

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 16-11-2026 23:51:39 to 16-11-2026 23:51:40.

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          235402
MON$OLDEST_ACTIVE               236463
MON$OLDEST_SNAPSHOT             236463
MON$NEXT_TRANSACTION            236463
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-16 23:00:10.7430
MON$PAGES                       150592
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    Mon Nov 16 23:51:05 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
--- end of diff output ---

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

16.11.26 23:51:40. 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-16 23:51:42 No severe PSQL-related problems occured
16.11.26 23:51:42. End of report.