Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.11.2026 05: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 1979224 kB
MemAvailable 7271716 kB
Buffers 91412 kB
Cached 5286792 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 05:50:55
DTS_END                         2026-11-08 05:50:55.4590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(92:14) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/37226
TRN_ID                          232684
ATT_ID                          479
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: 14812.22 925 740611
customer order: creation 690.52 46 34526
customer order: refuse 57.00 49 2850
order to supplier: creation 173.16 208 8658
order to supplier: removal 11.64 9469 582
invoice (draft): creation 177.38 346 8869
invoice (draft): removal 123.18 150 6159
invoice accept: apply 149.70 1481 7485
invoice accept: cancel 99.50 224 4975
customer reserve: creation 7114.42 26 355721
customer reserve: removal 5165.14 15 258257
realization accept: apply 321.36 34 16068
realization accept: cancel 176.06 19 8803
payment from customer: creation 229.98 37 11499
payment from customer: removal 21.78 18 1089
payment to supplier: creation 187.82 30 9391
payment to supplier: removal 14.06 16 703
service: total inventory turnovers 39.04 453 1952
service: total monetary turnovers 55.46 8 2773
service: aggregate perf. data 4.98 1820 249
service: refresh index statistics 0.04 4041 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-11-2026 05:51:14 to 08-11-2026 05:51:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8569
TEST_TIME 2 10183
TEST_TIME 3 11000
TEST_TIME 4 11613
TEST_TIME 5 11840
TEST_TIME 6 12047
TEST_TIME 7 12131
TEST_TIME 8 12223
TEST_TIME 9 12209
TEST_TIME 10 12127
TEST_TIME 11 12379
TEST_TIME 12 12437
TEST_TIME 13 12517
TEST_TIME 14 12667
TEST_TIME 15 12826
TEST_TIME 16 12944
TEST_TIME 17 13163
TEST_TIME 18 13216
TEST_TIME 19 13272
TEST_TIME 20 13328
TEST_TIME 21 13437
TEST_TIME 22 13553
TEST_TIME 23 13581
TEST_TIME 24 13639
TEST_TIME 25 13665
TEST_TIME 26 13706
TEST_TIME 27 13605
TEST_TIME 28 13690
TEST_TIME 29 13634
TEST_TIME 30 13731
TEST_TIME 31 13735
TEST_TIME 32 13759
TEST_TIME 33 13939
TEST_TIME 34 13991
TEST_TIME 35 14061
TEST_TIME 36 14175
TEST_TIME 37 14171
TEST_TIME 38 14236
TEST_TIME 39 14385
TEST_TIME 40 14382
TEST_TIME 41 14468
TEST_TIME 42 14476
TEST_TIME 43 14561
TEST_TIME 44 14559
TEST_TIME 45 14633
TEST_TIME 46 14667
TEST_TIME 47 14692
TEST_TIME 48 14749
TEST_TIME 49 14763
TEST_TIME 50 14812

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-11-2026 05:51:16 to 08-11-2026 05:51:19.

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 1095643 1095643 0 0.00 0 1340 2 0 0
doc_list_biud 1095643 1095643 0 0.00 0 1724 5 0 0
sp_add_invoice_to_stock 7485 7485 0 0.00 8 10877 1481 0 0
sp_cancel_adding_invoice 4975 4975 0 0.00 4 4634 224 0 0
sp_cancel_client_order 2850 2850 0 0.00 3 1347 49 0 0
sp_cancel_customer_reserve 258257 258257 0 0.00 1 1724 16 0 0
sp_cancel_pay_from_customer 1089 1089 0 0.00 2 378 18 0 0
sp_cancel_pay_to_supplier 703 703 0 0.00 2 314 17 0 0
sp_cancel_supplier_invoice 6159 6159 0 0.00 2 1341 150 0 0
sp_cancel_supplier_order 582 582 0 0.00 4 57016 9469 0 0
sp_cancel_write_off 8803 8803 0 0.00 1 852 20 0 0
sp_client_order 34526 34526 0 0.00 4 1130 46 0 0
sp_customer_reserve 355721 355721 0 0.00 0 1911 27 0 0
sp_fill_shopping_cart 52053 52053 0 0.00 1 1319 21 0 0
sp_fill_shopping_cart_clo_res 355721 355721 0 0.00 0 1537 2 0 0
sp_get_clo_for_invoice 7485 7485 0 0.00 0 1317 35 0 0
sp_kill_cost_storno 15570 15570 0 0.00 0 413 9 0 0
sp_kill_qstorno_ret_qs2qd 532058 532058 0 0.00 0 1722 8 0 0
sp_kill_qty_storno 305179 305179 0 0.00 0 1723 18 0 0
sp_lock_selected_doc 32620 32620 0 0.00 0 572 2 0 0
sp_make_cost_storno 44443 44443 0 0.00 0 1228 6 0 0
sp_multiply_rows_for_pdistr 44443 44443 0 0.00 0 649 9 0 0
sp_multiply_rows_for_qdistr 34526 34526 0 0.00 0 1123 18 0 0
sp_pay_from_customer 11499 11499 0 0.00 3 1158 37 0 0
sp_pay_to_supplier 9391 9391 0 0.00 3 1248 30 0 0
sp_payment_common 20890 20890 0 0.00 1 550 11 0 0
sp_qd_handle_on_cancel_clo 2850 2850 0 0.00 0 1338 32 0 0
sp_qd_handle_on_invoice_upd_sts 12460 12460 0 0.00 0 1416 73 0 0
sp_qd_handle_on_reserve_upd_sts 16068 16068 0 0.00 0 938 10 0 0
sp_reserve_write_off 16068 16068 0 0.00 3 1163 35 0 0
sp_supplier_invoice 8869 8869 0 0.00 5 3747 347 0 0
sp_supplier_order 8658 8658 0 0.00 5 1551 208 0 0
srv_aggregate_perf_data 249 249 0 0.00 52 39716 1820 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1398 261 0 0
srv_find_qd_qs_mism 689070 689070 0 0.00 0 1327 1 0 0
srv_make_invnt_saldo 1952 1952 0 0.00 0 73075 453 0 0
srv_make_money_saldo 2773 2773 0 0.00 0 247 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 341 7741 4041 0 0
v_add_invoice_to_stock 14970 14970 0 0.00 0 286 2 0 0
v_all_customers 52254 52254 0 0.00 0 37 1 0 0
v_all_suppliers 42820 42820 0 0.00 0 61 1 0 0
v_all_wares 69052 69052 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 1274 1274 0 0.00 0 52 2 0 0
v_cancel_client_order 5700 5700 0 0.00 0 301 1 0 0
v_cancel_customer_prepayment 2178 2178 0 0.00 0 215 1 0 0
v_cancel_customer_reserve 2054 2054 0 0.00 0 297 2 0 0
v_cancel_payment_to_supplier 1406 1406 0 0.00 0 22 1 0 0
v_cancel_supplier_invoice 1190 1190 0 0.00 0 167 2 0 0
v_cancel_supplier_order 1164 1164 0 0.00 0 260 2 0 0
v_cancel_write_off 3168 3168 0 0.00 0 111 2 0 0
v_max_id_clo_ord 8658 8658 0 0.00 0 28 1 0 0
v_max_id_clo_res 1636 1636 0 0.00 0 46 1 0 0
v_max_id_ord_sup 8869 8869 0 0.00 0 521 2 0 0
v_max_non_paid_invoice 5508 5508 0 0.00 0 152 2 0 0
v_max_non_paid_realizn 11088 11088 0 0.00 0 197 2 0 0
v_min_id_clo_ord 8658 8658 0 0.00 0 386 3 0 0
v_min_id_clo_res 1636 1636 0 0.00 0 698 5 0 0
v_min_id_ord_sup 8869 8869 0 0.00 0 701 4 0 0
v_min_non_paid_invoice 9391 9391 0 0.00 0 379 4 0 0
v_min_non_paid_realizn 11499 11499 0 0.00 0 419 6 0 0
v_our_firm 17620 17620 0 0.00 0 26 1 0 0
v_reserve_write_off 32136 32136 0 0.00 0 546 1 0 0
x_lock_depdocs_on_canc_invoice 10539 10539 0 0.00 0 1156 10 0 0
x_lock_depdocs_on_canc_sup_ord 582 582 0 0.00 0 172 10 0 0
x_make_qstorno_1000_1200 8658 8658 0 0.00 1 1534 151 0 0
x_make_qstorno_1200_2000 8869 8869 0 0.00 1 3716 302 0 0
x_make_qstorno_2100_3300 355721 355721 0 0.00 0 1910 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-11-2026 05:51:19 to 08-11-2026 05:51:23.

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
05:00:59 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:01:59 177 2147483648 2580354928 2661449728 247815328 10.345 20 11 22 0 250866720 836224 2215168
05:02:59 166 2147483648 2609133792 2693967872 272709248 11.268 20 14 26 2 279221824 4234240 2278336
05:04:00 299 2147483648 2604818416 2690957312 271031680 11.206 20 15 31 0 276128656 1346960 3750016
05:05:01 267 2147483648 2590200944 2674503680 256734224 10.678 20 14 27 1 261113008 1605616 2773168
05:06:01 193 2147483648 2592959504 2677440512 259705472 10.788 20 10 20 0 262970992 920560 2344960
05:07:01 189 2147483648 2597571456 2683740160 262862544 10.905 20 10 20 1 267617008 2072752 2681712
05:08:02 150 2147483648 2590345552 2675666944 257057312 10.690 20 11 20 0 260319136 1354896 1906928
05:09:02 1112 2147483648 2594270240 2682744832 262916368 10.907 20 9 18 1 265772928 1060032 1796528
05:10:04 184 2147483648 2580714976 2665103360 248253856 10.362 19 12 22 0 252474096 1554720 2665520
05:11:04 200 2147483648 2597726688 2684207104 263790816 10.939 20 11 22 0 267573728 1702352 2080560
05:12:05 412 2147483648 2600819600 2687303680 265453408 11.001 20 12 24 0 269027776 977456 2596912
05:13:05 165 2147483648 2601755184 2690682880 268572320 11.116 20 8 15 0 272295952 1917600 1806032
05:14:06 179 2147483648 2588961600 2675994624 257087280 10.691 20 5 10 0 259531856 1573712 870864
05:15:06 171 2147483648 2597634464 2686554112 264906752 10.981 20 9 18 0 267923776 1189296 1827728
05:16:08 159 2147483648 2599605408 2687934464 266162640 11.027 20 10 19 0 269689408 1573232 1953536
05:17:08 225 2147483648 2589367328 2675281920 253804000 10.569 19 11 22 0 258124608 2379648 1940960
05:18:09 152 2147483648 2592640992 2678915072 257172704 10.694 20 15 30 0 261719072 1744496 2801872
05:19:09 165 2147483648 2590685520 2678693888 257948640 10.723 20 9 17 1 260559776 1138064 1473072
05:20:09 215 2147483648 2601895472 2689638400 267036384 11.059 20 12 24 0 271915392 2334640 2544368
05:21:10 131 2147483648 2599275888 2686226432 265400064 10.999 20 12 24 0 269805264 1902368 2502832
05:22:10 200 2147483648 2600913392 2688598016 264782848 10.976 20 15 32 0 270396048 2407280 3205920
05:23:11 1394 2147483648 2603744064 2690785280 267159632 11.064 20 11 21 1 271271984 1707600 2404752
05:24:12 419 2147483648 2597224688 2687475712 264115792 10.951 20 7 14 0 266947072 1643072 1188208
05:25:13 200 2147483648 2592366176 2680131584 259121760 10.767 20 10 18 1 262694416 1710672 1861984
05:26:13 206 2147483648 2605329840 2693316608 269512640 11.150 20 13 26 0 274600016 2561104 2526272
05:27:14 353 2147483648 2603611104 2692784128 268597120 11.117 20 9 18 0 272398384 2087776 1713488
05:28:15 618 2147483648 2598476000 2686562304 262629712 10.896 20 10 18 0 267457296 2869520 1958064
05:29:16 171 2147483648 2599457616 2687160320 264476368 10.965 20 11 22 0 268621616 1711488 2433760
05:30:16 216 2147483648 2600431904 2687631360 264609328 10.970 20 12 24 0 268292528 1323744 2359456
05:31:17 242 2147483648 2592149088 2679844864 258188640 10.732 20 11 19 0 261908656 1763184 1956832
05:32:17 158 2147483648 2601063024 2688696320 265426928 11.000 20 11 22 0 270183936 2026624 2730384
05:33:17 274 2147483648 2605653472 2697961472 272519728 11.261 20 6 8 1 275342032 1963232 859072
05:34:18 212 2147483648 2600132224 2688540672 265071840 10.987 20 12 24 0 268624944 1308304 2244800
05:35:18 298 2147483648 2599621840 2687021056 264277760 10.957 20 13 26 0 268620288 1754384 2588144
05:36:19 120 2147483648 2601466400 2691014656 266610800 11.043 20 10 21 0 269950704 1443520 1896384
05:37:19 365 2147483648 2595936480 2686144512 262072752 10.876 20 9 18 0 266283264 1788992 2421520
05:38:20 158 2147483648 2597505808 2684678144 261432160 10.852 20 14 27 0 265435520 1480304 2523056
05:39:20 203 2147483648 2608272144 2695663616 269205392 11.139 20 12 22 0 276755392 4660736 2889264
05:40:20 113 2147483648 2595538848 2683932672 261687936 10.862 20 10 20 1 264817760 1023488 2106336
05:41:21 161 2147483648 2598029120 2685833216 262309216 10.885 20 11 22 0 267111872 1797792 3004864
05:42:21 142 2147483648 2604298528 2692190208 268164096 11.101 20 12 24 0 272497216 1933712 2399408
05:43:21 128 2147483648 2592768192 2679980032 256730016 10.678 20 9 18 0 261074112 2050816 2293280
05:44:22 216 2147483648 2591948816 2678181888 256075472 10.654 20 13 28 0 260582048 1835776 2670800
05:45:22 243 2147483648 2603474080 2692190208 268418096 11.110 20 11 22 0 273797248 2320976 3058176
05:46:22 220 2147483648 2600312000 2690228224 266135856 11.026 20 9 18 0 269194000 1387712 1670432
05:47:23 117 2147483648 2599873008 2689945600 266166128 11.027 20 9 18 0 269316560 992512 2157920
05:48:23 357 2147483648 2599379616 2690867200 265873936 11.016 20 6 12 0 268466912 1616576 976400
05:49:24 209 2147483648 2603627504 2692050944 267226528 11.066 20 11 21 0 272465904 3191072 2048304
05:50:24 220 2147483648 2575060192 2660274176 241486032 10.108 19 7 14 0 244618032 1739792 1392208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 08-11-2026 05:51:24 to 08-11-2026 05:51:35.

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 08-11-2026 05:51:36 to 08-11-2026 05:51:37.

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          231412
MON$OLDEST_ACTIVE               232814
MON$OLDEST_SNAPSHOT             232814
MON$NEXT_TRANSACTION            232814
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 05:00:09.4000
MON$PAGES                       149056
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 05:50:56 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Sun Nov  8 05:50:56 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Sun Nov  8 05:50:56 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
--- end of diff output ---

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

08.11.26 05:51:37. 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 05:51:38 No severe PSQL-related problems occured
08.11.26 05:51:39. End of report.