Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.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 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+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 1d
Command: who -b
bootup_info system boot 2026-10-26 18:11
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 8138024 kB
MemFree 1725128 kB
MemAvailable 7385892 kB
Buffers 91604 kB
Cached 5653900 kB
SwapCached 16 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-08 11:51:16
DTS_END                         2026-11-08 11:51:16.4000
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/57218
TRN_ID                          155905
ATT_ID                          353
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: 8571.08 854 428554
customer order: creation 463.24 67 23162
customer order: refuse 35.24 56 1762
order to supplier: creation 118.90 264 5945
order to supplier: removal 9.02 8337 451
invoice (draft): creation 115.58 403 5779
invoice (draft): removal 78.02 158 3901
invoice accept: apply 97.50 1948 4875
invoice accept: cancel 63.34 260 3167
customer reserve: creation 4057.86 40 202893
customer reserve: removal 2839.58 19 141979
realization accept: apply 216.28 51 10814
realization accept: cancel 111.56 27 5578
payment from customer: creation 153.34 47 7667
payment from customer: removal 14.24 25 712
payment to supplier: creation 125.46 40 6273
payment to supplier: removal 7.50 25 375
service: total inventory turnovers 25.06 725 1253
service: total monetary turnovers 35.68 8 1784
service: aggregate perf. data 3.64 1318 182
service: refresh index statistics 0.04 3258 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-11-2026 11:51:31 to 08-11-2026 11:51:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7660
TEST_TIME 2 7073
TEST_TIME 3 6942
TEST_TIME 4 6634
TEST_TIME 5 6755
TEST_TIME 6 6786
TEST_TIME 7 6981
TEST_TIME 8 7184
TEST_TIME 9 7303
TEST_TIME 10 7286
TEST_TIME 11 7207
TEST_TIME 12 7228
TEST_TIME 13 7411
TEST_TIME 14 7461
TEST_TIME 15 7566
TEST_TIME 16 7582
TEST_TIME 17 7687
TEST_TIME 18 7744
TEST_TIME 19 7769
TEST_TIME 20 7919
TEST_TIME 21 7942
TEST_TIME 22 7936
TEST_TIME 23 7992
TEST_TIME 24 8015
TEST_TIME 25 8005
TEST_TIME 26 8099
TEST_TIME 27 8197
TEST_TIME 28 8162
TEST_TIME 29 8199
TEST_TIME 30 8269
TEST_TIME 31 8260
TEST_TIME 32 8334
TEST_TIME 33 8343
TEST_TIME 34 8295
TEST_TIME 35 8377
TEST_TIME 36 8394
TEST_TIME 37 8385
TEST_TIME 38 8407
TEST_TIME 39 8504
TEST_TIME 40 8559
TEST_TIME 41 8519
TEST_TIME 42 8531
TEST_TIME 43 8530
TEST_TIME 44 8548
TEST_TIME 45 8566
TEST_TIME 46 8606
TEST_TIME 47 8629
TEST_TIME 48 8677
TEST_TIME 49 8668
TEST_TIME 50 8571

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-11-2026 11:51:33 to 08-11-2026 11:51:36.

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 635622 635622 0 0.00 0 1759 3 0 0
doc_list_biud 635622 635622 0 0.00 0 3062 7 0 0
sp_add_invoice_to_stock 4875 4875 0 0.00 5 18697 1948 0 0
sp_cancel_adding_invoice 3167 3167 0 0.00 4 5992 261 0 0
sp_cancel_client_order 1762 1762 0 0.00 3 1698 57 0 0
sp_cancel_customer_reserve 141979 141979 0 0.00 1 2382 20 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 2 607 26 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 2 400 25 0 0
sp_cancel_supplier_invoice 3901 3901 0 0.00 2 1964 158 0 0
sp_cancel_supplier_order 451 451 0 0.00 8 59584 8338 0 0
sp_cancel_write_off 5578 5578 0 0.00 1 1111 27 0 0
sp_client_order 23162 23162 0 0.00 4 2006 67 0 0
sp_customer_reserve 202893 202893 0 0.00 0 5073 40 0 0
sp_fill_shopping_cart 34886 34886 0 0.00 1 2367 24 0 0
sp_fill_shopping_cart_clo_res 202893 202893 0 0.00 0 1858 4 0 0
sp_get_clo_for_invoice 4875 4875 0 0.00 0 1610 42 0 0
sp_kill_cost_storno 9832 9832 0 0.00 0 1371 11 0 0
sp_kill_qstorno_ret_qs2qd 293888 293888 0 0.00 0 3061 10 0 0
sp_kill_qty_storno 172527 172527 0 0.00 0 3062 23 0 0
sp_lock_selected_doc 21578 21578 0 0.00 0 516 2 0 0
sp_make_cost_storno 29629 29629 0 0.00 0 873 7 0 0
sp_multiply_rows_for_pdistr 29629 29629 0 0.00 0 859 13 0 0
sp_multiply_rows_for_qdistr 23162 23162 0 0.00 0 1997 28 0 0
sp_pay_from_customer 7667 7667 0 0.00 3 1373 47 0 0
sp_pay_to_supplier 6273 6273 0 0.00 3 1657 40 0 0
sp_payment_common 13940 13940 0 0.00 1 782 14 0 0
sp_qd_handle_on_cancel_clo 1762 1762 0 0.00 0 1694 37 0 0
sp_qd_handle_on_invoice_upd_sts 8042 8042 0 0.00 0 2215 78 0 0
sp_qd_handle_on_reserve_upd_sts 10814 10814 0 0.00 0 1605 17 0 0
sp_reserve_write_off 10814 10814 0 0.00 3 1614 52 0 0
sp_supplier_invoice 5779 5779 0 0.00 5 5177 403 0 0
sp_supplier_order 5945 5945 0 0.00 6 2928 264 0 0
srv_aggregate_perf_data 182 182 0 0.00 26 7219 1319 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 3873 484 0 0
srv_find_qd_qs_mism 396561 396561 0 0.00 0 1759 2 0 0
srv_make_invnt_saldo 1253 1253 0 0.00 2 95422 726 0 0
srv_make_money_saldo 1784 1784 0 0.00 0 256 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 476 6041 3259 0 0
v_add_invoice_to_stock 9750 9750 0 0.00 0 458 3 0 0
v_all_customers 35418 35418 0 0.00 0 57 1 0 0
v_all_suppliers 27944 27944 0 0.00 0 95 1 0 0
v_all_wares 46324 46324 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 954 954 0 0.00 0 77 2 0 0
v_cancel_client_order 3524 3524 0 0.00 0 398 2 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 433 3 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 77 2 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 245 3 0 0
v_cancel_supplier_invoice 776 776 0 0.00 0 247 3 0 0
v_cancel_supplier_order 902 902 0 0.00 0 450 3 0 0
v_cancel_write_off 2068 2068 0 0.00 0 369 3 0 0
v_max_id_clo_ord 5945 5945 0 0.00 0 372 2 0 0
v_max_id_clo_res 1084 1084 0 0.00 0 709 3 0 0
v_max_id_ord_sup 5779 5779 0 0.00 0 1021 3 0 0
v_max_non_paid_invoice 4025 4025 0 0.00 0 269 2 0 0
v_max_non_paid_realizn 7417 7417 0 0.00 0 265 3 0 0
v_min_id_clo_ord 5945 5945 0 0.00 0 591 4 0 0
v_min_id_clo_res 1084 1084 0 0.00 0 653 11 0 0
v_min_id_ord_sup 5779 5779 0 0.00 0 1423 11 0 0
v_min_non_paid_invoice 6273 6273 0 0.00 0 766 5 0 0
v_min_non_paid_realizn 7667 7667 0 0.00 0 571 7 0 0
v_our_firm 11406 11406 0 0.00 0 66 1 0 0
v_reserve_write_off 21628 21628 0 0.00 0 530 2 0 0
x_lock_depdocs_on_canc_invoice 6680 6680 0 0.00 0 1512 10 0 0
x_lock_depdocs_on_canc_sup_ord 451 451 0 0.00 0 303 10 0 0
x_make_qstorno_1000_1200 5945 5945 0 0.00 1 2880 201 0 0
x_make_qstorno_1200_2000 5779 5779 0 0.00 1 4000 342 0 0
x_make_qstorno_2100_3300 202893 202893 0 0.00 0 5068 34 0 0

Completed "Performance in DETAILS". Done for 00:00:06, from 08-11-2026 11:51:36 to 08-11-2026 11:51:42.

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:21 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:22 244 2147483648 2599084512 2684604416 268085504 11.098 20 5 9 0 270033088 525104 1422480
11:03:22 505 2147483648 2570690176 2648801280 237977056 9.976 20 9 18 0 240699664 868720 1853888
11:04:23 210 2147483648 2601926656 2686218240 269372976 11.145 20 11 21 0 272202416 852816 1976624
11:05:24 453 2147483648 2571077760 2650603520 236036560 9.902 19 12 22 1 239217328 955984 2224784
11:06:25 267 2147483648 2597684512 2683281408 264816496 10.977 20 9 16 0 267953200 1295968 1840736
11:07:26 171 2147483648 2602214112 2689626112 270561312 11.189 20 9 18 0 273794544 852784 2380448
11:08:26 186 2147483648 2580681312 2663157760 247908080 10.349 20 12 21 0 251412144 1255184 2248880
11:09:27 185 2147483648 2601473888 2688122880 269192880 11.138 20 8 16 0 271581056 973008 1415168
11:10:27 297 2147483648 2583341632 2667659264 251705280 10.491 19 7 12 0 253839328 1073696 1060352
11:11:28 884 2147483648 2594599856 2678644736 258777744 10.754 20 14 28 0 263344896 1388688 3178464
11:12:29 296 2147483648 2603782176 2690510848 268842464 11.126 20 14 28 0 273127152 923088 3361600
11:13:30 71 2147483648 2593890496 2681303040 261517504 10.855 20 6 12 0 264457488 1119280 1820704
11:14:31 357 2147483648 2595033328 2681245696 261658848 10.861 20 10 20 0 265689968 1974864 2056256
11:15:32 156 2147483648 2602477360 2690285568 269074576 11.134 20 9 18 0 272746368 1845792 1826000
11:16:33 300 2147483648 2605859536 2694963200 271758704 11.233 20 13 26 0 275613440 1254800 2599936
11:17:33 875 2147483648 2586670656 2672332800 250149360 10.433 19 10 18 1 253397408 1282688 1965360
11:18:35 207 2147483648 2593691296 2680061952 260961856 10.835 20 10 20 0 263961952 1158640 1841456
11:19:36 314 2147483648 2599029760 2685571072 265530352 11.004 20 10 20 0 268552496 1266528 1755616
11:20:37 488 2147483648 2601480176 2690867200 269117552 11.136 20 7 14 0 272678592 1805664 1755376
11:21:38 176 2147483648 2596167088 2684514304 263417376 10.926 20 11 21 0 266443808 1303232 1723200
11:22:39 241 2147483648 2592062432 2682146816 260268464 10.809 20 6 12 1 263110560 1795120 1046976
11:23:39 118 2147483648 2597872704 2687336448 266009264 11.021 20 10 20 0 269526128 1308256 2208608
11:24:40 174 2147483648 2605922576 2694557696 270999056 11.205 20 15 33 0 275972800 2317840 2655904
11:25:40 141 2147483648 2595250768 2684129280 262946768 10.908 20 7 14 0 265381088 1185472 1248848
11:26:41 351 2147483648 2592745440 2681303040 260325840 10.811 20 9 12 0 263085488 1089440 1670208
11:27:42 482 2147483648 2602384160 2690875392 268088688 11.098 20 10 20 0 271740880 1911520 1740672
11:28:42 127 2147483648 2604053616 2695229440 267510672 11.077 20 11 21 0 273700832 4521552 1668608
11:29:44 193 2147483648 2595295808 2686414848 263703808 10.936 20 7 14 1 265842896 1050448 1088640
11:30:44 532 2147483648 2599143424 2689503232 264292800 10.958 20 11 23 0 267538496 1235520 2010176
11:31:45 197 2147483648 2601625264 2690666496 268367328 11.108 20 9 18 0 271583008 1375760 1839920
11:32:46 313 2147483648 2601540096 2691121152 267983488 11.094 20 8 16 0 271082000 1624352 1474160
11:33:47 354 2147483648 2601282496 2690252800 267818480 11.088 20 12 23 0 271500240 1607504 2074256
11:34:47 385 2147483648 2590422192 2678697984 257370768 10.702 20 7 14 1 259870464 1180880 1318816
11:35:48 1396 2147483648 2604327744 2692726784 269184592 11.138 20 11 22 0 273388800 2002896 2201312
11:36:50 148 2147483648 2595531280 2684514304 262063040 10.876 20 8 17 0 264742192 1183728 1495424
11:37:50 2272 2147483648 2601989584 2694270976 269698608 11.157 20 8 16 0 272639264 1491792 1448864
11:38:53 405 2147483648 2596473616 2684420096 260724880 10.826 20 13 26 0 265136720 2102448 2309392
11:39:54 1243 2147483648 2586063952 2673176576 251825104 10.495 20 8 16 0 254945616 1193904 1926608
11:40:55 382 2147483648 2596048928 2686275584 260922064 10.833 20 5 8 0 265063792 3424928 716800
11:41:56 3873 2147483648 2602574144 2690547712 266630896 11.044 20 11 22 0 270727440 1490240 2606304
11:43:03 627 2147483648 2596105520 2685710336 262405008 10.888 20 6 12 0 265798624 1983248 1410368
11:44:04 271 2147483648 2592622816 2679029760 257008144 10.688 20 12 24 0 261469552 2155584 2305824
11:45:05 384 2147483648 2598129424 2688757760 265244464 10.993 20 10 20 0 269083168 1714752 2123952
11:46:08 899 2147483648 2602358240 2692923392 268489584 11.113 20 9 18 0 272013120 1929776 1593760
11:47:09 373 2147483648 2604819488 2694688768 270577728 11.189 20 12 24 0 274245920 1069072 2599120
11:48:10 389 2147483648 2602527296 2693677056 267822112 11.088 20 6 12 1 271400192 2004096 1573984
11:49:11 408 2147483648 2600629168 2692939776 265627712 11.007 20 5 10 1 269610544 3035696 947136
11:50:12 312 2147483648 2599768384 2688348160 264105856 10.951 20 10 20 0 268148240 1791056 2251328
11:51:12 362 2147483648 2597137680 2687000576 262264112 10.883 20 10 20 0 266388368 2244784 1879472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 08-11-2026 11:51:43 to 08-11-2026 11:51:59.

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:02, from 08-11-2026 11:51:59 to 08-11-2026 11:52:01.

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          155904
MON$OLDEST_ACTIVE               156229
MON$OLDEST_SNAPSHOT             156229
MON$NEXT_TRANSACTION            156229
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-08 11:00:12.0940
MON$PAGES                       100512
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.33892 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33892 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33892 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33892 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    Sun Nov  8 11:51:17 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'

08.11.26 11:52:02. 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-08 11:52:03 No severe PSQL-related problems occured
08.11.26 11:52:04. End of report.