Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.11.2026 17: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 4d
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 1662184 kB
MemAvailable 7259460 kB
Buffers 87680 kB
Cached 5595832 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-04 17:51:05
DTS_END                         2026-11-04 17:51:05.6160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(226:22) ==> SP_CANCEL_ADDING_INVOICE(35:5) ==> SP_ADD_INVOICE_TO_STOCK(92:14) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/42632
TRN_ID                          181526
ATT_ID                          383
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: 10653.96 1038 532698
customer order: creation 541.76 58 27088
customer order: refuse 42.76 54 2138
order to supplier: creation 136.68 246 6834
order to supplier: removal 9.58 9147 479
invoice (draft): creation 137.00 370 6850
invoice (draft): removal 91.78 151 4589
invoice accept: apply 118.54 1759 5927
invoice accept: cancel 75.26 236 3763
customer reserve: creation 5115.12 34 255756
customer reserve: removal 3569.36 18 178468
realization accept: apply 251.56 44 12578
realization accept: cancel 132.32 23 6616
payment from customer: creation 178.74 40 8937
payment from customer: removal 16.94 24 847
payment to supplier: creation 148.46 37 7423
payment to supplier: removal 10.80 21 540
service: total inventory turnovers 29.98 553 1499
service: total monetary turnovers 42.84 8 2142
service: aggregate perf. data 4.44 1515 222
service: refresh index statistics 0.04 6415 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 04-11-2026 17:51:36 to 04-11-2026 17:51:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 12352
TEST_TIME 2 10179
TEST_TIME 3 9670
TEST_TIME 4 9217
TEST_TIME 5 8615
TEST_TIME 6 8813
TEST_TIME 7 8979
TEST_TIME 8 9164
TEST_TIME 9 8910
TEST_TIME 10 8969
TEST_TIME 11 8769
TEST_TIME 12 8638
TEST_TIME 13 8936
TEST_TIME 14 9196
TEST_TIME 15 9237
TEST_TIME 16 9439
TEST_TIME 17 9527
TEST_TIME 18 9704
TEST_TIME 19 9740
TEST_TIME 20 9892
TEST_TIME 21 9930
TEST_TIME 22 9985
TEST_TIME 23 10101
TEST_TIME 24 10154
TEST_TIME 25 10157
TEST_TIME 26 10123
TEST_TIME 27 10037
TEST_TIME 28 10100
TEST_TIME 29 10164
TEST_TIME 30 10150
TEST_TIME 31 10197
TEST_TIME 32 10258
TEST_TIME 33 10294
TEST_TIME 34 10267
TEST_TIME 35 10151
TEST_TIME 36 10210
TEST_TIME 37 10214
TEST_TIME 38 10285
TEST_TIME 39 10359
TEST_TIME 40 10429
TEST_TIME 41 10486
TEST_TIME 42 10515
TEST_TIME 43 10575
TEST_TIME 44 10631
TEST_TIME 45 10672
TEST_TIME 46 10743
TEST_TIME 47 10792
TEST_TIME 48 10793
TEST_TIME 49 10827
TEST_TIME 50 10654

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2026 17:51:38 to 04-11-2026 17:51:41.

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 790943 790943 0 0.00 0 1494 3 0 0
doc_list_biud 790943 790943 0 0.00 0 2092 6 0 0
sp_add_invoice_to_stock 5927 5927 0 0.00 9 17505 1759 0 0
sp_cancel_adding_invoice 3763 3763 0 0.00 2 6136 237 0 0
sp_cancel_client_order 2138 2138 0 0.00 3 1682 55 0 0
sp_cancel_customer_reserve 178468 178468 0 0.00 1 2092 18 0 0
sp_cancel_pay_from_customer 847 847 0 0.00 2 422 24 0 0
sp_cancel_pay_to_supplier 540 540 0 0.00 2 231 22 0 0
sp_cancel_supplier_invoice 4589 4589 0 0.00 2 1394 151 0 0
sp_cancel_supplier_order 479 479 0 0.00 5 59688 9148 0 0
sp_cancel_write_off 6616 6616 0 0.00 1 1270 23 0 0
sp_client_order 27088 27088 0 0.00 4 1143 58 0 0
sp_customer_reserve 255756 255756 0 0.00 0 2957 35 0 0
sp_fill_shopping_cart 40772 40772 0 0.00 1 2453 22 0 0
sp_fill_shopping_cart_clo_res 255756 255756 0 0.00 0 1429 3 0 0
sp_get_clo_for_invoice 5927 5927 0 0.00 0 2142 40 0 0
sp_kill_cost_storno 11766 11766 0 0.00 0 781 10 0 0
sp_kill_qstorno_ret_qs2qd 368620 368620 0 0.00 0 2088 9 0 0
sp_kill_qty_storno 214558 214558 0 0.00 0 2092 21 0 0
sp_lock_selected_doc 25477 25477 0 0.00 0 839 2 0 0
sp_make_cost_storno 34865 34865 0 0.00 0 961 7 0 0
sp_multiply_rows_for_pdistr 34865 34865 0 0.00 0 731 11 0 0
sp_multiply_rows_for_qdistr 27088 27088 0 0.00 0 1129 24 0 0
sp_pay_from_customer 8937 8937 0 0.00 3 962 41 0 0
sp_pay_to_supplier 7423 7423 0 0.00 3 995 38 0 0
sp_payment_common 16360 16360 0 0.00 1 721 12 0 0
sp_qd_handle_on_cancel_clo 2138 2138 0 0.00 0 1664 36 0 0
sp_qd_handle_on_invoice_upd_sts 9690 9690 0 0.00 0 1425 75 0 0
sp_qd_handle_on_reserve_upd_sts 12578 12578 0 0.00 0 1370 13 0 0
sp_reserve_write_off 12578 12578 0 0.00 3 1384 44 0 0
sp_supplier_invoice 6850 6850 0 0.00 6 4773 371 0 0
sp_supplier_order 6834 6834 0 0.00 6 2592 247 0 0
srv_aggregate_perf_data 222 222 0 0.00 66 16665 1516 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 2045 387 0 0
srv_find_qd_qs_mism 493877 493877 0 0.00 0 1492 2 0 0
srv_make_invnt_saldo 1499 1499 0 0.00 1 50508 554 0 0
srv_make_money_saldo 2142 2142 0 0.00 0 196 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 460 12371 6416 0 0
v_add_invoice_to_stock 11854 11854 0 0.00 0 427 3 0 0
v_all_customers 41188 41188 0 0.00 0 110 1 0 0
v_all_suppliers 33004 33004 0 0.00 0 73 1 0 0
v_all_wares 54176 54176 0 0.00 0 102 1 0 0
v_cancel_adding_invoice 978 978 0 0.00 0 108 2 0 0
v_cancel_client_order 4276 4276 0 0.00 0 393 2 0 0
v_cancel_customer_prepayment 1694 1694 0 0.00 0 122 2 0 0
v_cancel_customer_reserve 1630 1630 0 0.00 0 394 2 0 0
v_cancel_payment_to_supplier 1080 1080 0 0.00 0 48 2 0 0
v_cancel_supplier_invoice 902 902 0 0.00 0 128 3 0 0
v_cancel_supplier_order 958 958 0 0.00 0 62 2 0 0
v_cancel_write_off 2426 2426 0 0.00 0 555 3 0 0
v_max_id_clo_ord 6834 6834 0 0.00 0 65 2 0 0
v_max_id_clo_res 1260 1260 0 0.00 0 134 2 0 0
v_max_id_ord_sup 6850 6850 0 0.00 0 534 2 0 0
v_max_non_paid_invoice 4605 4605 0 0.00 0 124 2 0 0
v_max_non_paid_realizn 8676 8676 0 0.00 0 374 2 0 0
v_min_id_clo_ord 6834 6834 0 0.00 0 349 3 0 0
v_min_id_clo_res 1260 1260 0 0.00 0 668 9 0 0
v_min_id_ord_sup 6850 6850 0 0.00 0 824 7 0 0
v_min_non_paid_invoice 7423 7423 0 0.00 0 433 4 0 0
v_min_non_paid_realizn 8937 8937 0 0.00 0 715 7 0 0
v_our_firm 13510 13510 0 0.00 0 80 1 0 0
v_reserve_write_off 25156 25156 0 0.00 0 602 2 0 0
x_lock_depdocs_on_canc_invoice 7901 7901 0 0.00 0 1045 9 0 0
x_lock_depdocs_on_canc_sup_ord 479 479 0 0.00 0 164 9 0 0
x_make_qstorno_1000_1200 6834 6834 0 0.00 1 2392 186 0 0
x_make_qstorno_1200_2000 6850 6850 0 0.00 2 4743 318 0 0
x_make_qstorno_2100_3300 255756 255756 0 0.00 0 2514 29 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2026 17:51:41 to 04-11-2026 17:51:45.

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
17:01:10 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:10 197 2147483648 2603348928 2690535424 272320368 11.253 20 6 12 0 274379712 622992 1436352
17:03:11 223 2147483648 2594515408 2677641216 261878816 10.869 20 12 22 1 264984976 922848 2183312
17:04:12 441 2147483648 2601486544 2689236992 270130064 11.173 20 8 16 0 272786864 1004176 1652624
17:05:12 68 2147483648 2597084000 2684055552 266140320 11.026 20 5 9 0 268269808 1034816 1094672
17:06:13 339 2147483648 2604765136 2693160960 273400768 11.293 20 7 12 0 276418768 1067136 1950864
17:07:14 206 2147483648 2585614800 2668937216 252514064 10.521 20 12 22 0 256320128 1338016 2468048
17:08:14 199 2147483648 2601165008 2688704512 268795120 11.124 20 9 16 0 271226544 1077392 1354032
17:09:15 256 2147483648 2568803360 2651414528 237356112 9.952 20 11 21 1 240134144 1037984 1740048
17:10:16 474 2147483648 2600609360 2688778240 268391856 11.109 20 7 14 0 271038704 1103680 1543168
17:11:17 298 2147483648 2600369808 2687406080 267126816 11.062 20 8 15 0 269867456 1372336 1368304
17:12:17 282 2147483648 2593793552 2678714368 257267344 10.698 20 11 22 0 263051136 4121296 1662496
17:13:18 318 2147483648 2599583472 2689298432 267984208 11.094 20 7 12 0 270964416 1164512 1815696
17:14:18 400 2147483648 2597659312 2686083072 265789152 11.013 20 6 10 0 268024480 1235168 1000160
17:15:19 2045 2147483648 2590597856 2676146176 247985920 10.352 19 12 24 0 251577200 1220928 2370352
17:16:21 128 2147483648 2593370160 2680406016 259763920 10.790 20 12 23 1 263028416 1189632 2074864
17:17:22 1010 2147483648 2601603040 2689581056 267539056 11.078 20 11 22 0 271280544 1916608 1824880
17:18:24 226 2147483648 2603440480 2691149824 268332656 11.107 20 12 24 0 273597232 2415952 2848624
17:19:25 138 2147483648 2602354464 2689703936 265672608 11.009 20 11 24 0 270277520 1919376 2685536
17:20:25 168 2147483648 2594983088 2680504320 258782880 10.754 20 15 31 0 263855872 1719552 3353440
17:21:26 220 2147483648 2599277408 2687746048 264235488 10.956 20 11 22 0 268718080 2187360 2295232
17:22:26 170 2147483648 2601005488 2692055040 269315504 11.143 20 5 10 0 271068064 854848 897712
17:23:27 775 2147483648 2601547296 2691928064 268437328 11.111 20 9 18 0 271843840 1492976 1913536
17:24:28 315 2147483648 2597152288 2684014592 262914048 10.907 20 13 23 2 266725856 1578256 2233552
17:25:29 155 2147483648 2601147776 2690805760 267551232 11.078 20 9 16 1 271149424 2009488 1588704
17:26:29 214 2147483648 2598805568 2688090112 265545744 11.004 20 9 17 1 269047376 1669616 1832016
17:27:32 351 2147483648 2596959712 2684674048 261789152 10.865 20 13 24 1 265992176 1486896 2716128
17:28:32 240 2147483648 2582733040 2665914368 247571088 10.336 19 15 31 0 252971584 2127600 3272896
17:29:34 204 2147483648 2598429136 2687094784 263730176 10.937 20 11 22 0 268680656 2825248 2125232
17:30:35 279 2147483648 2600427440 2690035712 265453376 11.001 20 10 20 0 270076912 2302576 2320960
17:31:35 303 2147483648 2600413664 2688651264 266387360 11.035 20 12 23 1 269505568 1119824 1998384
17:32:36 277 2147483648 2588404416 2673696768 252288400 10.513 19 10 20 1 255923360 1538064 2096896
17:33:36 896 2147483648 2599932480 2688397312 267092432 11.061 20 7 12 0 268928320 1008176 827712
17:34:38 326 2147483648 2599846240 2688004096 265310320 10.995 20 11 20 0 268982064 1189520 2482224
17:35:39 879 2147483648 2594951584 2685628416 262487408 10.891 20 12 24 0 266805776 1487712 2830656
17:36:41 1050 2147483648 2603163200 2692153344 266363008 11.034 20 9 18 0 270792656 2551744 1877904
17:37:42 315 2147483648 2590089104 2678030336 254963200 10.612 20 10 20 0 258859920 1832240 2064480
17:38:43 224 2147483648 2601745872 2689986560 266021616 11.022 20 15 30 0 270267904 1677664 2568624
17:39:44 319 2147483648 2588644368 2676428800 254809568 10.606 20 9 17 0 258221072 1709264 1702240
17:40:45 812 2147483648 2599686000 2690134016 266046416 11.023 20 5 10 1 268697088 1343424 1307248
17:41:46 167 2147483648 2593241552 2683191296 260229248 10.808 20 7 14 0 262942160 1155296 1557616
17:42:46 452 2147483648 2600798608 2688126976 264386928 10.961 20 12 23 1 267878688 1132656 2359104
17:43:47 164 2147483648 2604829328 2696122368 268312272 11.106 20 10 20 1 274249872 3885264 2052336
17:44:47 739 2147483648 2594711504 2685476864 259783392 10.791 20 11 22 0 263991232 2181008 2026832
17:45:48 167 2147483648 2593986080 2683686912 259785776 10.791 20 9 19 0 262849696 1290992 1772928
17:46:49 371 2147483648 2596568400 2685440000 260759232 10.827 20 9 18 0 265432032 2856208 1816592
17:47:50 195 2147483648 2596477392 2684018688 260557632 10.820 20 14 28 0 265628880 2354688 2716560
17:48:50 652 2147483648 2577258656 2662420480 240113296 10.056 19 12 23 0 244097568 1919472 2064800
17:49:51 351 2147483648 2589353840 2677174272 254130480 10.581 20 11 22 0 258964240 2613248 2220512
17:50:52 184 2147483648 2603979328 2694934528 269494832 11.150 20 8 14 0 273585840 2669280 1421728

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 04-11-2026 17:51:46 to 04-11-2026 17:52:00.

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 04-11-2026 17:52:01 to 04-11-2026 17:52:02.

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          181343
MON$OLDEST_ACTIVE               182781
MON$OLDEST_SNAPSHOT             182781
MON$NEXT_TRANSACTION            182781
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-04 17:00:11.2810
MON$PAGES                       111584
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    Wed Nov  4 17:51:08 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'

04.11.26 17:52:03. 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-04 17:52:04 No severe PSQL-related problems occured
04.11.26 17:52:04. End of report.