Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.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 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 1763052 kB
MemAvailable 7383724 kB
Buffers 86700 kB
Cached 5620888 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 11:51:05
DTS_END                         2026-11-04 11:51:05.9550
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(35:5) ==> SP_ADD_INVOICE_TO_STOCK(239:30) ==> SP_CANCEL_WRITE_OFF(59:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/53978
TRN_ID                          188171
ATT_ID                          393
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: 11304.06 906 565203
customer order: creation 552.86 54 27643
customer order: refuse 45.06 51 2253
order to supplier: creation 144.14 235 7207
order to supplier: removal 10.78 8609 539
invoice (draft): creation 140.36 373 7018
invoice (draft): removal 98.76 146 4938
invoice accept: apply 119.76 1728 5988
invoice accept: cancel 82.22 223 4111
customer reserve: creation 5363.90 33 268195
customer reserve: removal 3897.20 17 194860
realization accept: apply 259.78 41 12989
realization accept: cancel 148.06 22 7403
payment from customer: creation 183.42 37 9171
payment from customer: removal 17.58 20 879
payment to supplier: creation 150.24 33 7512
payment to supplier: removal 10.06 19 503
service: total inventory turnovers 31.18 551 1559
service: total monetary turnovers 44.18 9 2209
service: aggregate perf. data 4.48 1537 224
service: refresh index statistics 0.04 4385 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-11-2026 11:51:21 to 04-11-2026 11:51:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11665
TEST_TIME 2 9818
TEST_TIME 3 9447
TEST_TIME 4 9545
TEST_TIME 5 9724
TEST_TIME 6 9676
TEST_TIME 7 9933
TEST_TIME 8 10063
TEST_TIME 9 10159
TEST_TIME 10 10152
TEST_TIME 11 10208
TEST_TIME 12 10090
TEST_TIME 13 10198
TEST_TIME 14 10197
TEST_TIME 15 10332
TEST_TIME 16 10399
TEST_TIME 17 10475
TEST_TIME 18 10588
TEST_TIME 19 10619
TEST_TIME 20 10628
TEST_TIME 21 10618
TEST_TIME 22 10740
TEST_TIME 23 10790
TEST_TIME 24 10721
TEST_TIME 25 10845
TEST_TIME 26 10874
TEST_TIME 27 10992
TEST_TIME 28 10959
TEST_TIME 29 10943
TEST_TIME 30 10935
TEST_TIME 31 10960
TEST_TIME 32 11005
TEST_TIME 33 11129
TEST_TIME 34 11152
TEST_TIME 35 11199
TEST_TIME 36 11207
TEST_TIME 37 11303
TEST_TIME 38 11312
TEST_TIME 39 11330
TEST_TIME 40 11400
TEST_TIME 41 11430
TEST_TIME 42 11478
TEST_TIME 43 11531
TEST_TIME 44 11558
TEST_TIME 45 11633
TEST_TIME 46 11610
TEST_TIME 47 11616
TEST_TIME 48 11586
TEST_TIME 49 11525
TEST_TIME 50 11304

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2026 11:51:24 to 04-11-2026 11:51:27.

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 835196 835196 0 0.00 0 1064 2 0 0
doc_list_biud 835196 835196 0 0.00 0 2421 6 0 0
sp_add_invoice_to_stock 5988 5988 0 0.00 8 15594 1729 0 0
sp_cancel_adding_invoice 4111 4111 0 0.00 3 5389 224 0 0
sp_cancel_client_order 2253 2253 0 0.00 3 2428 51 0 0
sp_cancel_customer_reserve 194860 194860 0 0.00 1 2248 17 0 0
sp_cancel_pay_from_customer 879 879 0 0.00 2 469 20 0 0
sp_cancel_pay_to_supplier 503 503 0 0.00 2 325 20 0 0
sp_cancel_supplier_invoice 4938 4938 0 0.00 2 1623 146 0 0
sp_cancel_supplier_order 539 539 0 0.00 9 49175 8610 0 0
sp_cancel_write_off 7403 7403 0 0.00 1 971 22 0 0
sp_client_order 27643 27643 0 0.00 4 1688 55 0 0
sp_customer_reserve 268195 268195 0 0.00 0 3026 33 0 0
sp_fill_shopping_cart 41868 41868 0 0.00 1 1517 22 0 0
sp_fill_shopping_cart_clo_res 268195 268195 0 0.00 0 1526 3 0 0
sp_get_clo_for_invoice 5988 5988 0 0.00 0 1111 38 0 0
sp_kill_cost_storno 12896 12896 0 0.00 0 689 9 0 0
sp_kill_qstorno_ret_qs2qd 402600 402600 0 0.00 0 2240 9 0 0
sp_kill_qty_storno 233081 233081 0 0.00 0 2421 20 0 0
sp_lock_selected_doc 26228 26228 0 0.00 0 429 2 0 0
sp_make_cost_storno 35660 35660 0 0.00 0 829 7 0 0
sp_multiply_rows_for_pdistr 35660 35660 0 0.00 0 510 11 0 0
sp_multiply_rows_for_qdistr 27643 27643 0 0.00 0 1118 22 0 0
sp_pay_from_customer 9171 9171 0 0.00 3 1150 37 0 0
sp_pay_to_supplier 7512 7512 0 0.00 3 679 34 0 0
sp_payment_common 16683 16683 0 0.00 1 627 8 0 0
sp_qd_handle_on_cancel_clo 2253 2253 0 0.00 0 2420 34 0 0
sp_qd_handle_on_invoice_upd_sts 10099 10099 0 0.00 0 1486 71 0 0
sp_qd_handle_on_reserve_upd_sts 12989 12989 0 0.00 0 1386 13 0 0
sp_reserve_write_off 12989 12989 0 0.00 3 1398 42 0 0
sp_supplier_invoice 7018 7018 0 0.00 5 4863 373 0 0
sp_supplier_order 7207 7207 0 0.00 5 3169 236 0 0
srv_aggregate_perf_data 224 224 0 0.00 44 10592 1538 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 682 249 0 0
srv_find_qd_qs_mism 525106 525106 0 0.00 0 1058 2 0 0
srv_make_invnt_saldo 1559 1559 0 0.00 0 106946 551 0 0
srv_make_money_saldo 2209 2209 0 0.00 0 677 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 251 8519 4385 0 0
v_add_invoice_to_stock 11976 11976 0 0.00 0 608 3 0 0
v_all_customers 42044 42044 0 0.00 0 45 1 0 0
v_all_suppliers 34832 34832 0 0.00 0 56 1 0 0
v_all_wares 55286 55286 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 1068 1068 0 0.00 0 391 2 0 0
v_cancel_client_order 4506 4506 0 0.00 0 359 2 0 0
v_cancel_customer_prepayment 1758 1758 0 0.00 0 75 1 0 0
v_cancel_customer_reserve 1702 1702 0 0.00 0 465 3 0 0
v_cancel_payment_to_supplier 1006 1006 0 0.00 0 125 2 0 0
v_cancel_supplier_invoice 870 870 0 0.00 0 48 3 0 0
v_cancel_supplier_order 1078 1078 0 0.00 0 311 2 0 0
v_cancel_write_off 2514 2514 0 0.00 0 202 2 0 0
v_max_id_clo_ord 7207 7207 0 0.00 0 108 2 0 0
v_max_id_clo_res 1259 1259 0 0.00 0 301 2 0 0
v_max_id_ord_sup 7018 7018 0 0.00 0 719 2 0 0
v_max_non_paid_invoice 4321 4321 0 0.00 0 171 2 0 0
v_max_non_paid_realizn 8761 8761 0 0.00 0 185 2 0 0
v_min_id_clo_ord 7207 7207 0 0.00 0 306 3 0 0
v_min_id_clo_res 1259 1259 0 0.00 0 633 6 0 0
v_min_id_ord_sup 7018 7018 0 0.00 0 1264 7 0 0
v_min_non_paid_invoice 7512 7512 0 0.00 0 341 3 0 0
v_min_non_paid_realizn 9171 9171 0 0.00 0 620 3 0 0
v_our_firm 14062 14062 0 0.00 0 41 1 0 0
v_reserve_write_off 25978 25978 0 0.00 0 495 2 0 0
x_lock_depdocs_on_canc_invoice 8614 8614 0 0.00 0 919 9 0 0
x_lock_depdocs_on_canc_sup_ord 539 539 0 0.00 0 262 12 0 0
x_make_qstorno_1000_1200 7207 7207 0 0.00 1 2858 173 0 0
x_make_qstorno_1200_2000 7018 7018 0 0.00 1 4770 324 0 0
x_make_qstorno_2100_3300 268195 268195 0 0.00 0 3021 28 0 0

Completed "Performance in DETAILS". Done for 00:00:06, from 04-11-2026 11:51:27 to 04-11-2026 11:51:33.

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:10 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:11 223 2147483648 2604540144 2689486848 271808880 11.235 20 8 14 3 274728720 808496 2111344
11:03:11 363 2147483648 2596413936 2682150912 265815664 11.014 20 5 8 0 267265568 764240 685664
11:04:12 145 2147483648 2601266272 2686881792 268211632 11.102 20 12 23 0 272253520 1117488 2924400
11:05:13 202 2147483648 2600304512 2687787008 268871360 11.127 20 9 17 1 271554576 989392 1693824
11:06:13 322 2147483648 2601392080 2686930944 268400512 11.109 20 13 26 0 271546016 1007648 2137856
11:07:14 642 2147483648 2599926592 2688458752 267297952 11.069 20 5 10 0 269533040 926576 1308512
11:08:15 221 2147483648 2599356640 2686738432 266912032 11.055 20 9 18 0 269880608 1091952 1876624
11:09:16 427 2147483648 2588874704 2675867648 257127616 10.693 20 8 16 0 260011552 1312912 1571024
11:10:17 236 2147483648 2605290048 2692976640 272139648 11.247 20 10 19 0 275896896 1569424 2187824
11:11:17 261 2147483648 2589643552 2676592640 257703952 10.714 20 8 16 1 260362336 1262784 1395600
11:12:18 154 2147483648 2595881264 2682105856 261801472 10.866 20 11 22 0 265763216 1701216 2260528
11:13:18 161 2147483648 2603533888 2691866624 270342832 11.181 20 11 22 0 274475024 1826192 2306000
11:14:19 126 2147483648 2599024480 2686943232 265905552 11.017 20 9 17 0 268837184 1465936 1465696
11:15:19 221 2147483648 2600818576 2687356928 265720112 11.011 20 15 30 0 270758880 1943472 3095296
11:16:20 198 2147483648 2604269760 2691948544 268512672 11.113 20 11 22 0 273193088 1960688 2719728
11:17:20 270 2147483648 2599579920 2688843776 267519824 11.077 20 8 16 0 270239392 862160 1857408
11:18:21 86 2147483648 2590540800 2678173696 257866288 10.720 20 10 14 2 260996544 924752 2205504
11:19:21 174 2147483648 2605102016 2692648960 268594320 11.116 20 9 18 0 272912976 2280976 2037680
11:20:22 99 2147483648 2591129824 2678575104 259221008 10.770 20 8 13 0 261996688 1078912 1696768
11:21:22 325 2147483648 2595305456 2683015168 261548608 10.856 20 8 17 0 264594480 1093584 1952288
11:22:23 572 2147483648 2591115552 2678235136 257291024 10.699 20 14 28 0 261725376 1464800 2969552
11:23:24 327 2147483648 2596043408 2681532416 259975280 10.798 20 17 34 0 264857200 1822576 3059344
11:24:25 210 2147483648 2597161760 2686095360 263668272 10.935 20 10 20 0 266769360 1289328 1811760
11:25:26 141 2147483648 2599797776 2687614976 265231296 10.993 20 13 26 0 269623392 1673024 2719072
11:26:26 232 2147483648 2596238448 2684260352 260274912 10.809 20 8 16 0 264864448 2965088 1624448
11:27:27 164 2147483648 2603152608 2691346432 265934752 11.019 20 12 24 0 271494416 3131952 2427712
11:28:27 276 2147483648 2598984912 2691723264 266729456 11.048 20 6 12 0 269671280 1350016 1591808
11:29:28 236 2147483648 2595909584 2685497344 264204224 10.955 20 7 10 2 266883024 838576 1840224
11:30:29 335 2147483648 2593937840 2682163200 261256576 10.846 20 8 16 0 263688880 1181024 1251280
11:31:29 208 2147483648 2597687440 2684866560 261836576 10.867 20 13 26 0 266319392 2178736 2304080
11:32:30 140 2147483648 2606565760 2694959104 270746464 11.196 20 12 24 0 274959072 1726416 2486192
11:33:30 110 2147483648 2601166768 2689695744 265304080 10.995 20 10 20 1 270350112 2635712 2410320
11:34:31 150 2147483648 2598144576 2684407808 262015216 10.874 20 13 25 0 266995488 2433072 2547200
11:35:31 180 2147483648 2597576688 2685444096 263338176 10.923 20 9 19 0 267028800 1697824 1992800
11:36:32 678 2147483648 2595497520 2684583936 261054880 10.838 20 12 24 0 265118192 1800192 2263120
11:37:33 256 2147483648 2601164096 2691264512 267929456 11.092 20 9 18 0 270955408 1084064 1941888
11:38:34 300 2147483648 2598877248 2687012864 264436832 10.963 20 11 22 0 269074320 2126352 2511136
11:39:34 373 2147483648 2594017808 2681700352 259632736 10.786 20 11 21 0 262705904 1481760 1591408
11:40:35 194 2147483648 2598489280 2689884160 266421632 11.036 20 5 10 0 268631840 928720 1281488
11:41:35 162 2147483648 2603251824 2690977792 265854288 11.016 20 13 26 0 271184256 2413776 2916192
11:42:36 240 2147483648 2583705216 2669379584 249835584 10.421 19 11 22 0 253744960 1584096 2325280
11:43:36 154 2147483648 2592429616 2680455168 257829872 10.719 20 12 24 0 261617296 1628304 2159120
11:44:37 286 2147483648 2595907696 2684440576 260819520 10.830 20 12 24 0 264927632 1819712 2288400
11:45:37 209 2147483648 2589278112 2681163776 254626224 10.600 19 8 16 0 257537344 1343904 1567216
11:46:38 343 2147483648 2598752944 2686697472 262276272 10.883 20 10 18 0 266308832 2555904 1476656
11:47:39 173 2147483648 2588650064 2675175424 253299280 10.550 20 12 22 0 257560032 2214336 2046416
11:48:39 287 2147483648 2600956320 2688925696 264626880 10.970 20 13 27 0 268960352 1904736 2428736
11:49:40 218 2147483648 2600226688 2689224704 266078880 11.024 20 10 20 0 269950544 1639648 2232016
11:50:40 217 2147483648 2593787840 2681556992 258509536 10.744 20 12 24 0 262429696 1921104 1999056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 11:51:52 to 04-11-2026 11:51:53.

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          185078
MON$OLDEST_ACTIVE               188302
MON$OLDEST_SNAPSHOT             188302
MON$NEXT_TRANSACTION            188302
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 11:00:10.5130
MON$PAGES                       112416
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 11:51:06 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov  4 11:51:06 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
--- end of diff output ---

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

04.11.26 11:51:54. 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 11:51:56 No severe PSQL-related problems occured
04.11.26 11:51:56. End of report.