Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.12.2022 01:40
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. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. 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 mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 11067652 kB
MemAvailable 30186120 kB
Buffers 0 kB
Cached 20561588 kB
SwapCached 3172 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 

SERVER_MODE                     SuperServer 3.0.11
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
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=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
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=init_buff, val=10000
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_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
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=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.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=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 

FINISH_STATE                    
DTS_END                         
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           
IP                              
TRN_ID                          
ATT_ID                          
EXC_UNIT

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 50

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 120 minutes: 9327.36 21954 1119283
customer order: creation 180.07 342 21608
customer order: refuse 15.03 356 1804
order to supplier: creation 49.12 1173 5894
order to supplier: removal 3.44 82347 413
invoice (draft): creation 48.42 3159 5810
invoice (draft): removal 50.39 680 6047
invoice accept: apply 43.99 17266 5279
invoice accept: cancel 45.03 674 5403
customer reserve: creation 4103.25 171 492390
customer reserve: removal 4486.83 50 538419
realization accept: apply 89.48 163 10738
realization accept: cancel 73.90 106 8868
payment from customer: creation 62.91 87 7549
payment from customer: removal 6.12 111 734
payment to supplier: creation 52.71 106 6325
payment to supplier: removal 3.62 87 434
service: total inventory turnovers 4.98 1063 598
service: total monetary turnovers 7.10 21 852
service: aggregate perf. data 0.95 16914 114
service: refresh index statistics 0.03 314207 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-12-2022 01:40:48 to 29-12-2022 01:40:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4161
TEST_TIME 2 3800
TEST_TIME 3 5333
TEST_TIME 4 5069
TEST_TIME 5 5018
TEST_TIME 6 5146
TEST_TIME 7 4944
TEST_TIME 8 5424
TEST_TIME 9 5816
TEST_TIME 10 5972
TEST_TIME 11 6360
TEST_TIME 12 6694
TEST_TIME 13 6690
TEST_TIME 14 6622
TEST_TIME 15 6845
TEST_TIME 16 7172
TEST_TIME 17 7688
TEST_TIME 18 8101
TEST_TIME 19 8098
TEST_TIME 20 8527
TEST_TIME 21 8879
TEST_TIME 22 9296
TEST_TIME 23 9160
TEST_TIME 24 9557
TEST_TIME 25 10188
TEST_TIME 26 10435
TEST_TIME 27 10415
TEST_TIME 28 10249
TEST_TIME 29 10097
TEST_TIME 30 10207
TEST_TIME 31 10006
TEST_TIME 32 9988
TEST_TIME 33 9858
TEST_TIME 34 9718
TEST_TIME 35 9693
TEST_TIME 36 9656
TEST_TIME 37 9686
TEST_TIME 38 9832
TEST_TIME 39 9840
TEST_TIME 40 9819
TEST_TIME 41 9775
TEST_TIME 42 9609
TEST_TIME 43 9583
TEST_TIME 44 9585
TEST_TIME 45 9460
TEST_TIME 46 9383
TEST_TIME 47 9439
TEST_TIME 48 9373
TEST_TIME 49 9316
TEST_TIME 50 9458
TEST_TIME 51 9538
TEST_TIME 52 9569
TEST_TIME 53 9583
TEST_TIME 54 9631
TEST_TIME 55 9718
TEST_TIME 56 9660
TEST_TIME 57 9735
TEST_TIME 58 9744
TEST_TIME 59 9811
TEST_TIME 60 9861
TEST_TIME 61 9918
TEST_TIME 62 9988
TEST_TIME 63 9871
TEST_TIME 64 9785
TEST_TIME 65 9690
TEST_TIME 66 9697
TEST_TIME 67 9660
TEST_TIME 68 9622
TEST_TIME 69 9682
TEST_TIME 70 9624
TEST_TIME 71 9539
TEST_TIME 72 9459
TEST_TIME 73 9516
TEST_TIME 74 9511
TEST_TIME 75 9524
TEST_TIME 76 9563
TEST_TIME 77 9542
TEST_TIME 78 9532
TEST_TIME 79 9522
TEST_TIME 80 9564
TEST_TIME 81 9491
TEST_TIME 82 9664
TEST_TIME 83 9648
TEST_TIME 84 9629
TEST_TIME 85 9591
TEST_TIME 86 9565
TEST_TIME 87 9537
TEST_TIME 88 9487
TEST_TIME 89 9496
TEST_TIME 90 9453
TEST_TIME 91 9381
TEST_TIME 92 9412
TEST_TIME 93 9402
TEST_TIME 94 9413
TEST_TIME 95 9420
TEST_TIME 96 9443
TEST_TIME 97 9474
TEST_TIME 98 9444
TEST_TIME 99 9493
TEST_TIME 100 9469
TEST_TIME 101 9590
TEST_TIME 102 9586
TEST_TIME 103 9574
TEST_TIME 104 9555
TEST_TIME 105 9584
TEST_TIME 106 9577
TEST_TIME 107 9510
TEST_TIME 108 9483
TEST_TIME 109 9490
TEST_TIME 110 9477
TEST_TIME 111 9423
TEST_TIME 112 9421
TEST_TIME 113 9389
TEST_TIME 114 9365
TEST_TIME 115 9386
TEST_TIME 116 9403
TEST_TIME 117 9405
TEST_TIME 118 9374
TEST_TIME 119 9384
TEST_TIME 120 9401

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-12-2022 01:40:51 to 29-12-2022 01:40:55.

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 1574037 1574037 0 0.00 0 19100 6 0 0
doc_list_biud 1574034 1574034 0 0.00 0 20439 22 0 0
sp_add_invoice_to_stock 5417 5279 138 2.54 31 227823 17267 0 138
sp_cancel_adding_invoice 5403 5403 0 0.00 3 40369 674 0 0
sp_cancel_client_order 1804 1804 0 0.00 4 20446 357 0 0
sp_cancel_customer_reserve 538419 538419 0 0.00 0 19617 50 0 0
sp_cancel_pay_from_customer 734 734 0 0.00 2 7272 111 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 2 5665 87 0 0
sp_cancel_supplier_invoice 6058 6047 11 0.18 1 14877 681 0 11
sp_cancel_supplier_order 413 413 0 0.00 9 900393 82347 0 0
sp_cancel_write_off 8868 8868 0 0.00 1 9848 106 0 0
sp_client_order 21608 21608 0 0.00 3 18461 343 0 0
sp_customer_reserve 492390 492390 0 0.00 0 91933 171 0 0
sp_fill_shopping_cart 33305 33305 0 0.00 1 12683 35 0 0
sp_fill_shopping_cart_clo_res 492384 492384 0 0.00 0 16523 15 0 0
sp_get_clo_for_invoice 5270 5270 0 0.00 0 30741 281 0 0
sp_kill_cost_storno 15439 15439 0 0.00 0 8628 46 0 0
sp_kill_qstorno_ret_qs2qd 1092166 1092166 0 0.00 0 18405 27 0 0
sp_kill_qty_storno 576958 576958 0 0.00 0 20439 59 0 0
sp_lock_selected_doc 22074 22074 0 0.00 0 6384 6 0 0
sp_make_cost_storno 29879 29879 0 0.00 0 14390 44 0 0
sp_multiply_rows_for_pdistr 29879 29879 0 0.00 0 5798 23 0 0
sp_multiply_rows_for_qdistr 21608 21608 0 0.00 0 18451 153 0 0
sp_pay_from_customer 7549 7549 0 0.00 4 15181 88 0 0
sp_pay_to_supplier 6325 6325 0 0.00 4 14438 106 0 0
sp_payment_common 13873 13873 0 0.00 1 9881 18 0 0
sp_qd_handle_on_cancel_clo 1804 1804 0 0.00 0 20438 330 0 0
sp_qd_handle_on_invoice_upd_sts 10670 10670 0 0.00 0 15494 269 0 0
sp_qd_handle_on_reserve_upd_sts 10737 10737 0 0.00 0 11102 61 0 0
sp_reserve_write_off 10738 10738 0 0.00 6 14089 163 0 0
sp_supplier_invoice 5810 5810 0 0.00 5 95583 3159 0 0
sp_supplier_order 5894 5894 0 0.00 6 28482 1173 0 0
srv_aggregate_perf_data 114 114 0 0.00 2474 128905 16915 0 0
srv_fill_mon_cache_memory 67 67 0 0.00 1675 124952 42596 0 0
srv_find_qd_qs_mism 1067981 1067981 0 0.00 0 19100 6 0 0
srv_make_invnt_saldo 598 598 0 0.00 37 47624 1064 0 0
srv_make_money_saldo 852 852 0 0.00 0 991 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 209353 438690 314207 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5279 5279 0 0.00 0 20643 142 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 4399 93 0 0
t$perf-norm:sp_cancel_client_order 1804 1804 0 0.00 0 4140 12 0 0
t$perf-norm:sp_cancel_customer_reserve 714 714 0 0.00 0 4378 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 734 734 0 0.00 0 1882 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 3132 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 452 452 0 0.00 0 2364 22 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 22576 1418 0 0
t$perf-norm:sp_cancel_write_off 1119 1119 0 0.00 0 8260 15 0 0
t$perf-norm:sp_client_order 21608 21608 0 0.00 0 6185 14 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 4347 13 0 0
t$perf-norm:sp_pay_from_customer 7549 7549 0 0.00 0 7976 11 0 0
t$perf-norm:sp_pay_to_supplier 6325 6325 0 0.00 0 3387 9 0 0
t$perf-norm:sp_reserve_write_off 10738 10738 0 0.00 0 4729 10 0 0
t$perf-norm:sp_supplier_invoice 5810 5810 0 0.00 0 13058 20 0 0
t$perf-norm:sp_supplier_order 5894 5894 0 0.00 0 8745 17 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 398 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 67 67 0 0.00 0 189 4 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 2942 19 0 0
t$perf-norm:srv_make_money_saldo 852 852 0 0.00 0 934 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 10810 10534 276 2.55 0 8631 21 0 276
v_all_customers 39026 39026 0 0.00 0 50 0 0 0
v_all_suppliers 32638 32638 0 0.00 0 25 1 0 0
v_all_wares 43216 43216 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 224 6 0 0
v_cancel_client_order 3608 3608 0 0.00 0 6861 7 0 0
v_cancel_customer_prepayment 1468 1468 0 0.00 0 7243 21 0 0
v_cancel_customer_reserve 1428 1428 0 0.00 0 1596 7 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 5660 16 0 0
v_cancel_supplier_invoice 926 904 22 2.37 0 1882 21 0 22
v_cancel_supplier_order 826 826 0 0.00 0 2605 9 0 0
v_cancel_write_off 2238 2238 0 0.00 0 2691 14 0 0
v_max_id_clo_ord 5889 5889 0 0.00 0 876 1 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 2746 18 0 0
v_max_id_ord_sup 5806 5806 0 0.00 0 2632 3 0 0
v_max_non_paid_invoice 1701 1701 0 0.00 0 658 2 0 0
v_max_non_paid_realizn 4030 4030 0 0.00 0 3016 5 0 0
v_min_id_clo_ord 5889 5889 0 0.00 0 3150 6 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 6094 22 0 0
v_min_id_ord_sup 5806 5806 0 0.00 0 3561 6 0 0
v_min_non_paid_invoice 6325 6325 0 0.00 0 9876 12 0 0
v_min_non_paid_realizn 7548 7548 0 0.00 0 4012 11 0 0
v_our_firm 11226 11226 0 0.00 0 22 1 0 0
v_reserve_write_off 21474 21474 0 0.00 0 13908 10 0 0
x_lock_depdocs_on_canc_invoice 10998 10998 0 0.00 0 8961 104 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 12587 347 0 0
x_make_qstorno_1000_1200 5894 5894 0 0.00 2 28474 1106 0 0
x_make_qstorno_1200_2000 5810 5810 0 0.00 2 91922 3032 0 0
x_make_qstorno_2100_3300 492390 492390 0 0.00 0 91930 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-12-2022 01:40:56 to 29-12-2022 01:41:00.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, 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        = metadata cache, 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: 1000000 for all connections, with total size: 8192000000
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
23:08:38 1 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
23:09:39 28217 8192000000 9916316640 10229825536 999867664 10.877 100 86 172 0 1028016304 5763936 22384704
23:11:11 16746 8192000000 9968814608 10293850112 1050522416 11.366 100 93 186 0 1082666016 8597872 23545728
23:12:45 20540 8192000000 9992782160 10327130112 1073577680 11.586 100 87 174 0 1105712128 10197168 21937280
23:14:09 7301 8192000000 10032187824 10377256960 1117190336 12.000 100 88 176 0 1149385040 10641824 21552880
23:15:18 6441 8192000000 10093423472 10454077440 1179581072 12.586 100 73 145 1 1206920368 11834576 15504720
23:16:25 2976 8192000000 10134767376 10504572928 1225395264 13.012 100 77 153 0 1254207696 11496224 17316208
23:17:31 1576 8192000000 10163682512 10535292928 1253057344 13.266 100 81 162 0 1283160224 13067984 17034896
23:18:34 1864 8192000000 10186962496 10567606272 1275594096 13.473 100 86 173 1 1308615424 13990160 19031168
23:19:37 1164 8192000000 10210243168 10596855808 1299968960 13.695 100 92 184 1 1333068624 13168576 19931088
23:20:39 1583 8192000000 10212676112 10605621248 1307660432 13.765 100 69 136 1 1332600480 9963120 14976928
23:21:42 6098 8192000000 10195546080 10604568576 1306768080 13.757 100 32 63 0 1321384544 7709056 6907408
23:22:49 65409 8192000000 10212689248 10625892352 1319935936 13.876 100 33 66 0 1334155584 6539984 7679664
23:24:59 5780 8192000000 10221803424 10634993664 1323944784 13.912 100 38 75 0 1340702624 8704544 8053296
23:26:08 4114 8192000000 10224770416 10636226560 1327941632 13.949 100 27 55 0 1340214512 6171168 6101712
23:27:16 16796 8192000000 10210882944 10620653568 1304755744 13.738 98 19 38 0 1314685616 5486960 4442912
23:28:33 29077 8192000000 10177876992 10593169408 1241729808 13.162 94 20 40 0 1251135808 4884720 4521280
23:30:04 3561 8192000000 10178741584 10589343744 1287913472 13.585 100 32 65 0 1302105456 6588608 7603376
23:31:08 7913 8192000000 10132966832 10532331520 1223919328 12.998 97 16 33 0 1232589984 5221728 3448928
23:32:18 15293 8192000000 10141584320 10534350848 1232246288 13.075 98 29 57 0 1243041136 4612864 6181984
23:33:35 22601 8192000000 10141228064 10547781632 1215922640 12.924 96 16 30 0 1224232112 5336544 2972928
23:34:58 5576 8192000000 10162366368 10572840960 1275146512 13.469 100 27 55 0 1288117072 6599136 6371424
23:36:05 5147 8192000000 10184913056 10599587840 1296282192 13.661 100 23 45 1 1306862448 5430512 5149744
23:37:11 14958 8192000000 10196187792 10608132096 1309027712 13.777 100 43 85 4 1325439904 5225008 11187184
23:38:27 23439 8192000000 10213853664 10627981312 1320872912 13.885 100 26 49 0 1331614880 5461600 5280368
23:40:06 49619 8192000000 10250962144 10670460928 1353054816 14.175 100 35 69 0 1368161920 7720304 7386800
23:41:57 48238 8192000000 10267577920 10691051520 1367213104 14.302 100 29 58 2 1383777440 9863552 6700784
23:43:50 11450 8192000000 10299869472 10717605888 1387835088 14.487 100 49 96 1 1410109936 11289472 10985376
23:45:03 40163 8192000000 10315467232 10743193600 1397230192 14.570 100 51 102 0 1425341888 15362784 12748912
23:47:04 3670 8192000000 10339466112 10761838592 1410676976 14.690 100 62 122 1 1446500880 21196816 14627088
23:48:13 14835 8192000000 10345530848 10771828736 1417725856 14.753 100 61 123 1 1456066304 23567168 14773280
23:49:32 1675 8192000000 10351234816 10775650304 1415818832 14.736 100 59 114 0 1457642224 28491280 13332112
23:50:36 3803 8192000000 10352269152 10783588352 1424835616 14.816 100 57 113 0 1464205568 25746768 13623184
23:51:47 8867 8192000000 10332066208 10761474048 1388732384 14.495 98 41 80 0 1426627808 27798496 10096928
23:53:00 1845 8192000000 10360621456 10781220864 1416929616 14.745 100 71 141 0 1465955472 31869424 17156432
23:54:10 2133 8192000000 10360307040 10778898432 1412591952 14.707 100 71 140 1 1468003840 37447232 17964656
23:55:15 4391 8192000000 10331449136 10760761344 1394157760 14.543 100 49 98 1 1444918336 37110432 13650144
23:56:21 12416 8192000000 10298956592 10727305216 1362603520 14.261 99 29 56 3 1404789152 34230320 7955312
23:57:45 3453 8192000000 10331142832 10752761856 1388239424 14.490 100 52 104 0 1437076528 35965856 12871248
23:58:52 12988 8192000000 10296757680 10731761664 1369610976 14.324 100 29 58 0 1411385728 33991392 7783360
00:00:08 17421 8192000000 10292435872 10718756864 1358405424 14.223 100 25 50 1 1398888784 33815632 6667728
00:01:32 10331 8192000000 10297656864 10729369600 1373622624 14.359 100 34 68 0 1412216256 29671504 8922128
00:02:43 22249 8192000000 10262347296 10699165696 1326749536 13.938 98 24 48 1 1364104928 30604464 6750928
00:04:07 20393 8192000000 10261314192 10696687616 1334937008 14.012 99 22 44 1 1357499520 16353664 6208848
00:05:29 42240 8192000000 10245669344 10677428224 1296848848 13.667 96 16 32 1 1311117968 9981184 4287936
00:07:17 124952 8192000000 10254564768 10694217728 1309491920 13.781 97 36 71 0 1330837456 13211616 8133920
00:10:42 124879 8192000000 10307266784 10736562176 1333126496 13.995 97 33 66 0 1350284528 10076368 7081664
00:13:48 26080 8192000000 10295719712 10736664576 1358733104 14.226 98 41 82 1 1385366864 17518000 9115760
00:15:16 22399 8192000000 10300967696 10745475072 1384729840 14.459 100 28 57 0 1415665824 23909248 7026736
00:16:39 28873 8192000000 10304276224 10762194944 1395714112 14.557 100 9 18 0 1416407776 18468016 2225648
00:18:13 31409 8192000000 10297401920 10753998848 1398563472 14.582 100 6 12 0 1408813408 8606640 1643296
00:19:53 36214 8192000000 10288305392 10743455744 1389000576 14.497 99 16 33 0 1404093360 11516208 3576576
00:21:30 59559 8192000000 10299757232 10754031616 1385318976 14.464 99 32 64 1 1404302896 11685088 7298832
00:23:32 18671 8192000000 10299182720 10759905280 1402470832 14.617 100 16 32 0 1417140832 11203232 3466768
00:24:52 48157 8192000000 10314615952 10775306240 1411572752 14.698 100 18 36 0 1432496544 16577280 4346512
00:26:40 52026 8192000000 10313279888 10775695360 1402376160 14.616 99 17 34 0 1423625920 17152352 4097408
00:28:41 63836 8192000000 10305172368 10766323712 1371750592 14.343 97 16 31 0 1388496560 13369520 3376448
00:30:50 57469 8192000000 10290963424 10747604992 1361142256 14.248 97 27 54 0 1381513984 13675600 6696128
00:32:49 49118 8192000000 10295875712 10754654208 1369082112 14.319 98 25 50 0 1389921728 15022080 5817536
00:34:55 41033 8192000000 10291086560 10738315264 1356298576 14.204 97 40 80 0 1379864784 14781744 8784464
00:36:40 82853 8192000000 10289121920 10742935552 1327713120 13.946 96 14 28 0 1348363184 17554320 3095744
00:39:04 78860 8192000000 10287414880 10738614272 1333751504 14.001 96 20 40 0 1348327584 10466976 4109104
00:41:25 64007 8192000000 10276895248 10707439616 1350403760 14.151 99 37 74 0 1372176448 13554752 8217936
00:43:44 14016 8192000000 10254382784 10693898240 1347071552 14.121 100 32 61 2 1366706016 12928864 6705600
00:45:03 73065 8192000000 10279179312 10736726016 1358363536 14.223 99 17 34 1 1389635728 27262496 4009696
00:47:16 53591 8192000000 10258783520 10733568000 1335574832 14.017 98 3 6 0 1359140432 23186944 378656
00:49:12 65112 8192000000 10243903328 10696081408 1321083920 13.887 97 5 9 0 1335954672 14089136 781616
00:51:18 48324 8192000000 10244653312 10703630336 1325755040 13.929 98 7 14 0 1342360896 14857440 1748416
00:53:06 40743 8192000000 10252782192 10697236480 1330100528 13.968 98 33 66 1 1347412224 9810272 7501424
00:54:59 65975 8192000000 10260805264 10705764352 1318933328 13.867 97 33 66 0 1337354912 11305248 7116336
00:57:05 38168 8192000000 10278859920 10724028416 1367493904 14.305 100 36 72 0 1386794288 11569680 7730704
00:58:45 29069 8192000000 10273555264 10711543808 1358551280 14.224 99 22 44 0 1371664896 8621664 4491952
01:00:17 37880 8192000000 10277960400 10736721920 1358289664 14.222 99 31 62 0 1384627600 19132944 7204992
01:02:43 47796 8192000000 10297412816 10730848256 1365639040 14.288 99 30 60 0 1382423568 9035664 7748864
01:04:40 60554 8192000000 10291309264 10739126272 1378449968 14.403 100 16 32 1 1390203744 7765664 3988112
01:06:44 55564 8192000000 10279441136 10730192896 1376217984 14.383 99 27 54 0 1391990480 9885136 5887360
01:08:42 57336 8192000000 10290264288 10757922816 1392584672 14.529 100 7 14 0 1406089392 11940624 1564096
01:10:41 51140 8192000000 10290604752 10747174912 1368763760 14.316 98 11 20 0 1380256048 9399920 2092368
01:12:38 29095 8192000000 10285186528 10734673920 1367744496 14.307 98 22 43 0 1377910928 5647600 4518832
01:14:10 37990 8192000000 10295957936 10742882304 1378434800 14.403 99 38 77 1 1399071392 11658448 8978144
01:15:53 47682 8192000000 10315199616 10755678208 1388609264 14.493 100 35 70 0 1409020720 13050544 7360912
01:17:42 91125 8192000000 10299957936 10760343552 1332267888 13.988 96 17 34 0 1360401936 24476256 3657792
01:20:13 88167 8192000000 10281037584 10724491264 1297793520 13.675 94 18 35 0 1315284896 13895200 3596176
01:22:49 20791 8192000000 10271919024 10698559488 1331213584 13.978 98 44 88 0 1349093632 8247088 9632960
01:24:11 78365 8192000000 10261495952 10708168704 1338828496 14.047 98 23 46 0 1353651104 9407184 5415424
01:26:32 74457 8192000000 10280844592 10737733632 1338347552 14.043 97 30 60 0 1356204960 11146336 6711072
01:28:48 56647 8192000000 10248510304 10709708800 1293768944 13.639 94 8 16 0 1306033536 10718272 1546320
01:30:44 46734 8192000000 10251272864 10705121280 1348370944 14.133 99 17 34 1 1362359408 9994400 3994064
01:32:34 66058 8192000000 10277412704 10737930240 1350578144 14.153 99 15 30 0 1374470912 20632112 3260656
01:35:14 62892 8192000000 10250199024 10699448320 1273407648 13.453 93 19 38 0 1288022128 10362912 4251568
01:37:23 49548 8192000000 10235546320 10679431168 1295446032 13.654 95 22 42 1 1314055824 13904128 4705664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 29-12-2022 01:41:02 to 29-12-2022 01:41:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-12-2022 01:41:18 to 29-12-2022 01:41:20.

Content of mon$database and FB version 

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          244349
MON$OLDEST_ACTIVE               248008
MON$OLDEST_SNAPSHOT             248008
MON$NEXT_TRANSACTION            248008
MON$PAGE_BUFFERS                1000000
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               2020-04-03 16:41:55.3470
MON$PAGES                       2006912
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.11.33650 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33650 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33650 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33650 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/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 ---
:815: 
:816: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:817:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:818: 
:819: 
:820: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:821:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:822:     Uncommitted work may have been lost.
:823:     Error writing data to the connection.
:824: 
:825: 
:826: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:827:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:828:     Uncommitted work may have been lost.
:829:     Error writing data to the connection.
:830: 
:831: 
:832: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:833:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:834: 
:835: 
:836: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:837:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:838: 
:839: 
:840: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:841:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:842: 
:843: 
:844: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:845:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:846:     Uncommitted work may have been lost.
:847:     Error writing data to the connection.
:848: 
:849: 
:850: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:851:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:852:     Uncommitted work may have been lost.
:853:     Error writing data to the connection.
:854: 
:855: 
:856: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:857:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:858:     Uncommitted work may have been lost.
:859:     Error writing data to the connection.
:860: 
:861: 
:862: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:863:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:864:     Uncommitted work may have been lost.
:865:     Error writing data to the connection.
:866: 
:867: 
:868: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:869:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:870:     Uncommitted work may have been lost.
:871:     Error writing data to the connection.
:872: 
:873: 
:874: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:875:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:876:     Uncommitted work may have been lost.
:877:     Error writing data to the connection.
:878: 
:879: 
:880: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:881:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:882: 
:883: 
:884: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:885:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:886:     Uncommitted work may have been lost.
:887:     Error writing data to the connection.
:888: 
:889: 
:890: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:891:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:892:     Uncommitted work may have been lost.
:893:     Error writing data to the connection.
:894: 
:895: 
:896: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:897:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:898:     Uncommitted work may have been lost.
:899:     Error writing data to the connection.
:900: 
:901: 
:902: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:903:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:904: 
:905: 
:906: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:907:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:908:     Uncommitted work may have been lost.
:909:     Error writing data to the connection.
:910: 
:911: 
:912: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:913:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:914:     Uncommitted work may have been lost.
:915:     Error writing data to the connection.
:916: 
:917: 
:918: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:919:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:920:     Uncommitted work may have been lost.
:921:     Error writing data to the connection.
:922: 
:923: 
:924: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:925:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:926:     Uncommitted work may have been lost.
:927:     Error writing data to the connection.
:928: 
:929: 
:930: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:931:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:932:     Uncommitted work may have been lost.
:933:     Error writing data to the connection.
:934: 
:935: 
:936: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:937:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:938:     Uncommitted work may have been lost.
:939:     Error writing data to the connection.
:940: 
:941: 
:942: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:943:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:944:     Uncommitted work may have been lost.
:945:     Error writing data to the connection.
:946: 
:947: 
:948: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:949:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:950:     Uncommitted work may have been lost.
:951:     Error writing data to the connection.
:952: 
:953: 
:954: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:955:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:956: 
:957: 
:958: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:959:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:960:     Uncommitted work may have been lost.
:961:     Error writing data to the connection.
:962: 
:963: 
:964: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:965:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:966:     Uncommitted work may have been lost.
:967:     Error writing data to the connection.
:968: 
:969: 
:970: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:971:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:972:     Uncommitted work may have been lost.
:973:     Error writing data to the connection.
:974: 
:975: 
:976: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:977:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:978:     Uncommitted work may have been lost.
:979:     Error writing data to the connection.
:980: 
:981: 
:982: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:983:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:984:     Uncommitted work may have been lost.
:985:     Error writing data to the connection.
:986: 
:987: 
:988: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:989:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:990:     Uncommitted work may have been lost.
:991:     Error writing data to the connection.
:992: 
:993: 
:994: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:995:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:996:     Uncommitted work may have been lost.
:997:     Error writing data to the connection.
:998: 
:999: 
:1000: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1001:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1002:     Uncommitted work may have been lost.
:1003:     Error writing data to the connection.
:1004: 
:1005: 
:1006: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1007:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1008:     Uncommitted work may have been lost.
:1009:     Error writing data to the connection.
:1010: 
:1011: 
:1012: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1013:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1014: 
:1015: 
:1016: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1017:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1018:     Uncommitted work may have been lost.
:1019:     Error writing data to the connection.
:1020: 
:1021: 
:1022: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1023:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1024:     Uncommitted work may have been lost.
:1025:     Error writing data to the connection.
:1026: 
:1027: 
:1028: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1029:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1030:     Uncommitted work may have been lost.
:1031:     Error writing data to the connection.
:1032: 
:1033: 
:1034: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1035:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1036:     Uncommitted work may have been lost.
:1037:     Error writing data to the connection.
:1038: 
:1039: 
:1040: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1041:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1042:     Uncommitted work may have been lost.
:1043:     Error writing data to the connection.
:1044: 
:1045: 
:1046: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1047:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1048:     Uncommitted work may have been lost.
:1049:     Error writing data to the connection.
:1050: 
:1051: 
:1052: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1053:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1054:     Uncommitted work may have been lost.
:1055:     Error writing data to the connection.
:1056: 
:1057: 
:1058: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1059:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1060:     Uncommitted work may have been lost.
:1061:     Error writing data to the connection.
:1062: 
:1063: 
:1064: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1065:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1066:     Uncommitted work may have been lost.
:1067:     Error writing data to the connection.
:1068: 
:1069: 
:1070: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1071:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1072:     Uncommitted work may have been lost.
:1073:     Error writing data to the connection.
:1074: 
:1075: 
:1076: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1077:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1078:     Uncommitted work may have been lost.
:1079:     Error writing data to the connection.
:1080: 
:1081: 
:1082: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1083:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1084:     Uncommitted work may have been lost.
:1085:     Error writing data to the connection.
:1086: 
:1087: 
:1088: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1089:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1090:     Uncommitted work may have been lost.
:1091:     Error writing data to the connection.
:1092: 
:1093: 
:1094: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1095:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1096:     Uncommitted work may have been lost.
:1097:     Error writing data to the connection.
:1098: 
:1099: 
:1100: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1101:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1102:     Uncommitted work may have been lost.
:1103:     Error writing data to the connection.
:1104: 
:1105: 
:1106: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1107:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1108:     Uncommitted work may have been lost.
:1109:     Error writing data to the connection.
:1110: 
:1111: 
:1112: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1113:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1114:     Uncommitted work may have been lost.
:1115:     Error writing data to the connection.
:1116: 
:1117: 
:1118: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1119:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1120:     Uncommitted work may have been lost.
:1121:     Error writing data to the connection.
:1122: 
:1123: 
:1124: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1125:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1126:     Uncommitted work may have been lost.
:1127:     Error writing data to the connection.
:1128: 
:1129: 
:1130: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1131:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1132:     Uncommitted work may have been lost.
:1133:     Error writing data to the connection.
:1134: 
:1135: 
:1136: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1137:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1138:     Uncommitted work may have been lost.
:1139:     Error writing data to the connection.
:1140: 
:1141: 
:1142: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1143:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1144: 
:1145: 
:1146: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1147:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1148:     Uncommitted work may have been lost.
:1149:     Error writing data to the connection.
:1150: 
:1151: 
:1152: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1153:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1154:     Uncommitted work may have been lost.
:1155:     Error writing data to the connection.
:1156: 
:1157: 
:1158: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1159:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1160:     Uncommitted work may have been lost.
:1161:     Error writing data to the connection.
:1162: 
:1163: 
:1164: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1165:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1166:     Uncommitted work may have been lost.
:1167:     Error writing data to the connection.
:1168: 
:1169: 
:1170: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1171:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1172:     Uncommitted work may have been lost.
:1173:     Error writing data to the connection.
:1174: 
:1175: 
:1176: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1177:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1178: 
:1179: 
:1180: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1181:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1182:     Uncommitted work may have been lost.
:1183:     Error writing data to the connection.
:1184: 
:1185: 
:1186: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1187:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1188: 
:1189: 
:1190: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1191:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1192: 
:1193: 
:1194: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1195:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1196:     Uncommitted work may have been lost.
:1197:     Error writing data to the connection.
:1198: 
:1199: 
:1200: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1201:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1202:     Uncommitted work may have been lost.
:1203:     Error writing data to the connection.
:1204: 
:1205: 
:1206: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1207:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1208: 
:1209: 
:1210: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1211:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1212:     Uncommitted work may have been lost.
:1213:     Error writing data to the connection.
:1214: 
:1215: 
:1216: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1217:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1218:     Uncommitted work may have been lost.
:1219:     Error writing data to the connection.
:1220: 
:1221: 
:1222: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1223:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1224: 
:1225: 
:1226: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1227:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1228:     Uncommitted work may have been lost.
:1229:     Error writing data to the connection.
:1230: 
:1231: 
:1232: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1233:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1234:     Uncommitted work may have been lost.
:1235:     Error writing data to the connection.
:1236: 
:1237: 
:1238: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1239:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1240:     Uncommitted work may have been lost.
:1241:     Error writing data to the connection.
:1242: 
:1243: 
:1244: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1245:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1246:     Uncommitted work may have been lost.
:1247:     Error writing data to the connection.
:1248: 
:1249: 
:1250: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1251:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1252:     Uncommitted work may have been lost.
:1253:     Error writing data to the connection.
:1254: 
:1255: 
:1256: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1257:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1258:     Uncommitted work may have been lost.
:1259:     Error writing data to the connection.
:1260: 
:1261: 
:1262: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1263:     /opt/fb30/bin/fbguard: /opt/fb30/bin/firebird terminated abnormally (-1)
:1264: 
:1265: 
:1266: 
:1267: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1268:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1269:     Uncommitted work may have been lost.
:1270:     Error writing data to the connection.
:1271: 
:1272: 
:1273: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1274:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1275:     Uncommitted work may have been lost.
:1276:     Error writing data to the connection.
:1277: 
:1278: 
:1279: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1280:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1281:     Uncommitted work may have been lost.
:1282:     Error writing data to the connection.
:1283: 
:1284: 
:1285: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1286:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1287:     Uncommitted work may have been lost.
:1288:     Error writing data to the connection.
:1289: 
:1290: 
:1291: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1292:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1293:     Uncommitted work may have been lost.
:1294:     Error writing data to the connection.
:1295: 
:1296: 
:1297: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1298:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1299:     Uncommitted work may have been lost.
:1300:     Error writing data to the connection.
:1301: 
:1302: 
:1303: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1304:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1305:     Uncommitted work may have been lost.
:1306:     Error writing data to the connection.
:1307: 
:1308: 
:1309: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1310:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1311:     Uncommitted work may have been lost.
:1312:     Error writing data to the connection.
:1313: 
:1314: 
:1315: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1316:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1317:     Uncommitted work may have been lost.
:1318:     Error writing data to the connection.
:1319: 
:1320: 
:1321: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1322:     /opt/fb30/bin/fbguard: guardian starting /opt/fb30/bin/firebird
:1323: 
:1324: 
:1325: 
:1326: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1327:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1328:     Uncommitted work may have been lost.
:1329:     Error writing data to the connection.
:1330: 
:1331: 
:1332: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1333:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1334:     Uncommitted work may have been lost.
:1335:     Error writing data to the connection.
:1336: 
:1337: 
:1338: mscs-test-161.budzdorov.ru    Thu Dec 29 01:40:10 2022
:1339:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1340:     Uncommitted work may have been lost.
:1341:     Error writing data to the connection.
:1342: 
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'  

29.12.22 01:41:21. There are 6 logs in /var/tmp/logs-oltp30 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
2022-12-29 01:41:24 No severe PSQL-related problems occured
29.12.22 01:41:25. End of report.