Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 13.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 6d
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 1813940 kB
MemAvailable 7280256 kB
Buffers 81124 kB
Cached 5501824 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-13 11:50:57
DTS_END                         2026-11-13 11:50:57.1490
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/37786
TRN_ID                          217451
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: 14672.56 898 733628
customer order: creation 645.36 48 32268
customer order: refuse 52.76 49 2638
order to supplier: creation 165.26 212 8263
order to supplier: removal 12.02 9186 601
invoice (draft): creation 161.52 358 8076
invoice (draft): removal 115.92 151 5796
invoice accept: apply 139.38 1663 6969
invoice accept: cancel 96.76 220 4838
customer reserve: creation 7126.72 27 356336
customer reserve: removal 5186.66 15 259333
realization accept: apply 293.26 37 14663
realization accept: cancel 161.02 20 8051
payment from customer: creation 214.26 34 10713
payment from customer: removal 19.54 19 977
payment to supplier: creation 175.44 29 8772
payment to supplier: removal 12.96 19 648
service: total inventory turnovers 36.40 493 1820
service: total monetary turnovers 52.66 8 2633
service: aggregate perf. data 4.62 1993 231
service: refresh index statistics 0.04 3387 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7730
TEST_TIME 2 9299
TEST_TIME 3 9909
TEST_TIME 4 10560
TEST_TIME 5 10887
TEST_TIME 6 11309
TEST_TIME 7 11744
TEST_TIME 8 11921
TEST_TIME 9 12092
TEST_TIME 10 12284
TEST_TIME 11 12410
TEST_TIME 12 12598
TEST_TIME 13 12706
TEST_TIME 14 12906
TEST_TIME 15 13045
TEST_TIME 16 13078
TEST_TIME 17 13152
TEST_TIME 18 13253
TEST_TIME 19 13386
TEST_TIME 20 13400
TEST_TIME 21 13498
TEST_TIME 22 13549
TEST_TIME 23 13633
TEST_TIME 24 13645
TEST_TIME 25 13674
TEST_TIME 26 13719
TEST_TIME 27 13805
TEST_TIME 28 13774
TEST_TIME 29 13887
TEST_TIME 30 13862
TEST_TIME 31 13877
TEST_TIME 32 13927
TEST_TIME 33 13944
TEST_TIME 34 14007
TEST_TIME 35 14190
TEST_TIME 36 14268
TEST_TIME 37 14259
TEST_TIME 38 14502
TEST_TIME 39 14428
TEST_TIME 40 14521
TEST_TIME 41 14489
TEST_TIME 42 14509
TEST_TIME 43 14516
TEST_TIME 44 14517
TEST_TIME 45 14551
TEST_TIME 46 14554
TEST_TIME 47 14645
TEST_TIME 48 14604
TEST_TIME 49 14653
TEST_TIME 50 14673

Performance per minute, chart


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

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 1081797 1081797 0 0.00 0 3102 2 0 0
doc_list_biud 1081797 1081797 0 0.00 0 2475 5 0 0
sp_add_invoice_to_stock 6969 6969 0 0.00 10 11455 1664 0 0
sp_cancel_adding_invoice 4838 4838 0 0.00 3 5026 220 0 0
sp_cancel_client_order 2638 2638 0 0.00 3 2481 49 0 0
sp_cancel_customer_reserve 259333 259333 0 0.00 1 2019 15 0 0
sp_cancel_pay_from_customer 977 977 0 0.00 2 420 19 0 0
sp_cancel_pay_to_supplier 648 648 0 0.00 2 426 20 0 0
sp_cancel_supplier_invoice 5796 5796 0 0.00 1 1041 152 0 0
sp_cancel_supplier_order 601 601 0 0.00 5 58677 9187 0 0
sp_cancel_write_off 8051 8051 0 0.00 1 763 20 0 0
sp_client_order 32268 32268 0 0.00 4 3142 48 0 0
sp_customer_reserve 356336 356336 0 0.00 0 3127 28 0 0
sp_fill_shopping_cart 48607 48607 0 0.00 1 1269 21 0 0
sp_fill_shopping_cart_clo_res 356336 356336 0 0.00 0 1078 3 0 0
sp_get_clo_for_invoice 6969 6969 0 0.00 0 1694 38 0 0
sp_kill_cost_storno 14514 14514 0 0.00 0 977 10 0 0
sp_kill_qstorno_ret_qs2qd 533114 533114 0 0.00 0 2009 8 0 0
sp_kill_qty_storno 302889 302889 0 0.00 0 2475 18 0 0
sp_lock_selected_doc 30183 30183 0 0.00 0 413 2 0 0
sp_make_cost_storno 41117 41117 0 0.00 0 3092 7 0 0
sp_multiply_rows_for_pdistr 41117 41117 0 0.00 0 378 10 0 0
sp_multiply_rows_for_qdistr 32268 32268 0 0.00 0 877 18 0 0
sp_pay_from_customer 10713 10713 0 0.00 3 1022 34 0 0
sp_pay_to_supplier 8772 8772 0 0.00 3 577 30 0 0
sp_payment_common 19485 19485 0 0.00 1 409 7 0 0
sp_qd_handle_on_cancel_clo 2638 2638 0 0.00 0 2474 32 0 0
sp_qd_handle_on_invoice_upd_sts 11807 11807 0 0.00 0 1596 72 0 0
sp_qd_handle_on_reserve_upd_sts 14663 14663 0 0.00 0 1084 11 0 0
sp_reserve_write_off 14663 14663 0 0.00 3 1090 37 0 0
sp_supplier_invoice 8076 8076 0 0.00 5 4329 358 0 0
sp_supplier_order 8263 8263 0 0.00 5 3451 212 0 0
srv_aggregate_perf_data 231 231 0 0.00 19 34034 1993 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 941 313 0 0
srv_find_qd_qs_mism 681788 681788 0 0.00 0 1296 1 0 0
srv_make_invnt_saldo 1820 1820 0 0.00 1 74941 493 0 0
srv_make_money_saldo 2633 2633 0 0.00 0 276 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 353 6421 3387 0 0
v_add_invoice_to_stock 13938 13938 0 0.00 0 403 3 0 0
v_all_customers 49542 49542 0 0.00 0 54 1 0 0
v_all_suppliers 40004 40004 0 0.00 0 34 1 0 0
v_all_wares 64536 64536 0 0.00 0 54 1 0 0
v_cancel_adding_invoice 1196 1196 0 0.00 0 80 2 0 0
v_cancel_client_order 5276 5276 0 0.00 0 503 2 0 0
v_cancel_customer_prepayment 1954 1954 0 0.00 0 359 2 0 0
v_cancel_customer_reserve 2044 2044 0 0.00 0 386 2 0 0
v_cancel_payment_to_supplier 1296 1296 0 0.00 0 328 2 0 0
v_cancel_supplier_invoice 1180 1180 0 0.00 0 108 3 0 0
v_cancel_supplier_order 1202 1202 0 0.00 0 57 2 0 0
v_cancel_write_off 2954 2954 0 0.00 0 332 2 0 0
v_max_id_clo_ord 8263 8263 0 0.00 0 52 1 0 0
v_max_id_clo_res 1517 1517 0 0.00 0 104 1 0 0
v_max_id_ord_sup 8076 8076 0 0.00 0 429 2 0 0
v_max_non_paid_invoice 5109 5109 0 0.00 0 47 2 0 0
v_max_non_paid_realizn 10337 10337 0 0.00 0 107 2 0 0
v_min_id_clo_ord 8263 8263 0 0.00 0 271 3 0 0
v_min_id_clo_res 1517 1517 0 0.00 0 500 4 0 0
v_min_id_ord_sup 8076 8076 0 0.00 0 803 5 0 0
v_min_non_paid_invoice 8772 8772 0 0.00 0 267 3 0 0
v_min_non_paid_realizn 10713 10713 0 0.00 0 239 2 0 0
v_our_firm 15746 15746 0 0.00 0 48 1 0 0
v_reserve_write_off 29326 29326 0 0.00 0 425 1 0 0
x_lock_depdocs_on_canc_invoice 10044 10044 0 0.00 0 1957 10 0 0
x_lock_depdocs_on_canc_sup_ord 601 601 0 0.00 0 192 12 0 0
x_make_qstorno_1000_1200 8263 8263 0 0.00 1 3424 154 0 0
x_make_qstorno_1200_2000 8076 8076 0 0.00 1 4265 313 0 0
x_make_qstorno_2100_3300 356336 356336 0 0.00 0 3125 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2026 11:51:15 to 13-11-2026 11: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
11:01:00 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:01 231 2147483648 2598371424 2683031552 266299680 11.032 20 12 21 0 269022240 691008 2031552
11:03:01 286 2147483648 2603512192 2690015232 272110272 11.246 20 9 18 0 275452544 871120 2471152
11:04:02 179 2147483648 2595566528 2683326464 264757296 10.975 20 5 10 0 266906640 1134768 1014576
11:05:02 460 2147483648 2571062560 2650861568 236176704 9.908 19 12 26 0 239337280 740944 2419632
11:06:03 469 2147483648 2605957376 2693095424 273629488 11.301 20 7 14 0 275515024 606096 1279440
11:07:04 167 2147483648 2585992240 2672128000 254197456 10.584 20 6 12 0 257187104 1204400 1785248
11:08:04 164 2147483648 2605752848 2693754880 271843280 11.236 20 17 30 2 276645376 1793760 3008336
11:09:04 191 2147483648 2582191904 2669051904 250696720 10.453 20 5 8 0 252454240 1131424 626096
11:10:05 661 2147483648 2606983376 2695024640 271734352 11.232 20 11 22 0 276572016 2427840 2409824
11:11:06 246 2147483648 2599813728 2688708608 267322608 11.070 20 10 20 1 270966224 1050608 2593008
11:12:06 121 2147483648 2597345872 2683396096 263863152 10.942 20 12 23 1 267947344 1612256 2471936
11:13:07 295 2147483648 2596255600 2683150336 262346416 10.886 20 12 22 0 266465184 1878128 2240640
11:14:07 128 2147483648 2597675456 2689097728 263522576 10.929 20 7 14 0 267666112 2907984 1235552
11:15:08 167 2147483648 2590002368 2675744768 255626208 10.637 19 14 28 0 260309616 2077440 2605968
11:16:08 848 2147483648 2593255792 2680381440 257574224 10.709 20 14 28 0 262048912 1734768 2739920
11:17:09 107 2147483648 2601390416 2688458752 265724368 11.011 20 13 25 0 271318768 2758656 2835744
11:18:10 199 2147483648 2602261184 2691477504 268115520 11.099 20 10 20 0 271746112 1559136 2071456
11:19:10 176 2147483648 2598227680 2685542400 262603936 10.896 20 10 20 0 266950736 2249968 2096832
11:20:10 212 2147483648 2597924400 2689032192 265718304 11.011 20 8 16 0 268612784 1180224 1714256
11:21:11 349 2147483648 2586733616 2671091712 248517920 10.372 19 12 24 0 251730240 1199360 2012960
11:22:11 300 2147483648 2585909376 2672848896 252752640 10.530 20 11 21 0 256727776 1269104 2706032
11:23:12 287 2147483648 2598989632 2689769472 266085040 11.024 20 10 20 0 269534144 1411024 2038080
11:24:13 182 2147483648 2599676304 2688995328 265395056 10.999 20 12 24 0 269601968 1873168 2333744
11:25:13 812 2147483648 2596514656 2683502592 260893504 10.832 20 14 27 1 265093728 1738064 2462160
11:26:14 167 2147483648 2600628688 2688770048 267207888 11.065 20 14 26 1 270548720 1002720 2338112
11:27:15 208 2147483648 2598740784 2685632512 262537584 10.893 20 14 28 1 268439200 2610672 3290944
11:28:15 99 2147483648 2599980384 2687152128 264495248 10.965 20 12 24 0 268612256 1928128 2188880
11:29:15 194 2147483648 2604144368 2693754880 270006160 11.168 20 12 23 0 274104720 2248832 1849728
11:30:17 562 2147483648 2602978928 2691420160 268139008 11.100 20 12 24 0 272342288 2018768 2184512
11:31:18 116 2147483648 2600108608 2688245760 265685680 11.009 20 10 20 0 269570352 2075184 1809488
11:32:18 189 2147483648 2598377440 2688176128 264435120 10.963 20 7 14 0 267829488 2048672 1345696
11:33:19 590 2147483648 2595316784 2684071936 261769664 10.865 20 10 20 0 264923216 1555216 1598336
11:34:20 692 2147483648 2598902720 2687094784 261932800 10.871 20 13 26 0 267364896 2632176 2799920
11:35:22 861 2147483648 2605472128 2694631424 268378016 11.108 20 11 22 0 273318736 2556512 2384208
11:36:23 174 2147483648 2598573616 2687479808 264348768 10.960 20 10 20 0 267988128 1483344 2156016
11:37:24 407 2147483648 2593558112 2683183104 260869328 10.831 20 8 16 0 263937104 1680288 1387488
11:38:24 158 2147483648 2601733280 2690002944 265475312 11.002 20 11 20 0 270451328 2994528 1981488
11:39:25 200 2147483648 2601265840 2692423680 268190672 11.102 20 7 13 0 270569712 910704 1468336
11:40:25 183 2147483648 2602065904 2691153920 266857344 11.053 20 9 18 0 271046416 2433472 1755600
11:41:25 448 2147483648 2600178112 2688978944 265330640 10.996 20 15 30 0 269945792 1664112 2951040
11:42:26 777 2147483648 2600457184 2689163264 265982816 11.020 20 16 29 1 271159984 1886592 3290576
11:43:27 166 2147483648 2592892256 2681483264 258674144 10.750 20 8 16 0 262672976 2561360 1437472
11:44:27 178 2147483648 2598924656 2685960192 263263984 10.920 20 13 26 0 267631024 1902288 2464752
11:45:28 259 2147483648 2599012576 2689998848 266324128 11.033 20 6 11 0 268572608 1094272 1154208
11:46:29 141 2147483648 2601397920 2687954944 263969904 10.946 20 15 27 0 269655072 3072416 2612752
11:47:30 146 2147483648 2589963504 2678411264 255623552 10.637 20 6 12 0 258382096 1656576 1101968
11:48:31 941 2147483648 2594269088 2684698624 261388272 10.851 20 5 11 0 263451040 1167680 895088
11:49:32 267 2147483648 2605789264 2694066176 269651152 11.155 20 11 21 0 273871568 2356240 1864176
11:50:32 140 2147483648 2592990464 2680664064 256939584 10.686 20 12 24 0 261112544 1871120 2301840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 13-11-2026 11:51:20 to 13-11-2026 11:51:33.

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 13-11-2026 11:51:34 to 13-11-2026 11:51:35.

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          217659
MON$OLDEST_ACTIVE               217660
MON$OLDEST_SNAPSHOT             217660
MON$NEXT_TRANSACTION            217660
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-13 11:00:08.9650
MON$PAGES                       134912
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'

13.11.26 11:51:35. There are 6 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-13 11:51:36 No severe PSQL-related problems occured
13.11.26 11:51:37. End of report.