Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.07.2022 22:39
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 | 16097732 kB |
MemAvailable | 31013904 kB |
Buffers | 0 kB |
Cached | 15597224 kB |
SwapCached | 2552 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_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|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2022-07-24 22:38:25
DTS_END 2022-07-24 22:38:25.3950
FB_GDSCODE -1
FB_MNEMONA
STACK SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/44596
TRN_ID 242829
ATT_ID 707
EXC_UNIT 2
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 |
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 |
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
*** OVERALL *** for 120 minutes: |
9401.95 |
18654 |
1128234 |
customer order: creation |
173.28 |
388 |
20794 |
customer order: refuse |
14.99 |
365 |
1799 |
order to supplier: creation |
46.14 |
1265 |
5537 |
order to supplier: removal |
3.55 |
104597 |
426 |
invoice (draft): creation |
45.52 |
3096 |
5462 |
invoice (draft): removal |
55.68 |
783 |
6682 |
invoice accept: apply |
40.91 |
17313 |
4909 |
invoice accept: cancel |
49.84 |
746 |
5981 |
customer reserve: creation |
3797.08 |
170 |
455650 |
customer reserve: removal |
4876.53 |
60 |
585184 |
realization accept: apply |
84.53 |
169 |
10143 |
realization accept: cancel |
84.54 |
118 |
10145 |
payment from customer: creation |
59.13 |
110 |
7095 |
payment from customer: removal |
5.76 |
58 |
691 |
payment to supplier: creation |
48.70 |
112 |
5844 |
payment to supplier: removal |
3.53 |
61 |
424 |
service: total inventory turnovers |
5.03 |
1146 |
603 |
service: total monetary turnovers |
6.20 |
26 |
744 |
service: aggregate perf. data |
0.98 |
18441 |
117 |
service: refresh index statistics |
0.03 |
224056 |
4 |
Completed "Performance in TOTAL". Done for 00:00:03, from 24-07-2022 22:39:39 to 24-07-2022 22:39:42.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
2078 |
TEST_TIME |
2 |
2016 |
TEST_TIME |
3 |
3442 |
TEST_TIME |
4 |
4872 |
TEST_TIME |
5 |
4309 |
TEST_TIME |
6 |
4545 |
TEST_TIME |
7 |
4419 |
TEST_TIME |
8 |
4244 |
TEST_TIME |
9 |
4356 |
TEST_TIME |
10 |
4608 |
TEST_TIME |
11 |
4810 |
TEST_TIME |
12 |
4943 |
TEST_TIME |
13 |
5295 |
TEST_TIME |
14 |
5698 |
TEST_TIME |
15 |
5833 |
TEST_TIME |
16 |
6767 |
TEST_TIME |
17 |
7084 |
TEST_TIME |
18 |
7389 |
TEST_TIME |
19 |
8022 |
TEST_TIME |
20 |
8056 |
TEST_TIME |
21 |
8536 |
TEST_TIME |
22 |
8778 |
TEST_TIME |
23 |
10021 |
TEST_TIME |
24 |
10686 |
TEST_TIME |
25 |
10762 |
TEST_TIME |
26 |
10550 |
TEST_TIME |
27 |
10500 |
TEST_TIME |
28 |
10431 |
TEST_TIME |
29 |
10167 |
TEST_TIME |
30 |
10013 |
TEST_TIME |
31 |
10051 |
TEST_TIME |
32 |
9870 |
TEST_TIME |
33 |
9775 |
TEST_TIME |
34 |
9727 |
TEST_TIME |
35 |
9827 |
TEST_TIME |
36 |
9702 |
TEST_TIME |
37 |
9690 |
TEST_TIME |
38 |
9522 |
TEST_TIME |
39 |
9493 |
TEST_TIME |
40 |
9555 |
TEST_TIME |
41 |
9421 |
TEST_TIME |
42 |
9710 |
TEST_TIME |
43 |
9701 |
TEST_TIME |
44 |
9812 |
TEST_TIME |
45 |
9747 |
TEST_TIME |
46 |
9861 |
TEST_TIME |
47 |
9819 |
TEST_TIME |
48 |
10031 |
TEST_TIME |
49 |
10077 |
TEST_TIME |
50 |
10073 |
TEST_TIME |
51 |
10138 |
TEST_TIME |
52 |
10085 |
TEST_TIME |
53 |
9941 |
TEST_TIME |
54 |
9852 |
TEST_TIME |
55 |
9803 |
TEST_TIME |
56 |
9820 |
TEST_TIME |
57 |
9820 |
TEST_TIME |
58 |
9736 |
TEST_TIME |
59 |
9706 |
TEST_TIME |
60 |
9624 |
TEST_TIME |
61 |
9689 |
TEST_TIME |
62 |
9626 |
TEST_TIME |
63 |
9654 |
TEST_TIME |
64 |
9656 |
TEST_TIME |
65 |
9694 |
TEST_TIME |
66 |
9678 |
TEST_TIME |
67 |
9782 |
TEST_TIME |
68 |
9726 |
TEST_TIME |
69 |
9791 |
TEST_TIME |
70 |
9840 |
TEST_TIME |
71 |
9813 |
TEST_TIME |
72 |
9905 |
TEST_TIME |
73 |
9925 |
TEST_TIME |
74 |
9894 |
TEST_TIME |
75 |
9956 |
TEST_TIME |
76 |
9968 |
TEST_TIME |
77 |
9859 |
TEST_TIME |
78 |
9861 |
TEST_TIME |
79 |
9775 |
TEST_TIME |
80 |
9771 |
TEST_TIME |
81 |
9698 |
TEST_TIME |
82 |
9625 |
TEST_TIME |
83 |
9628 |
TEST_TIME |
84 |
9607 |
TEST_TIME |
85 |
9609 |
TEST_TIME |
86 |
9571 |
TEST_TIME |
87 |
9595 |
TEST_TIME |
88 |
9583 |
TEST_TIME |
89 |
9549 |
TEST_TIME |
90 |
9589 |
TEST_TIME |
91 |
9560 |
TEST_TIME |
92 |
9569 |
TEST_TIME |
93 |
9555 |
TEST_TIME |
94 |
9578 |
TEST_TIME |
95 |
9587 |
TEST_TIME |
96 |
9550 |
TEST_TIME |
97 |
9638 |
TEST_TIME |
98 |
9686 |
TEST_TIME |
99 |
9708 |
TEST_TIME |
100 |
9688 |
TEST_TIME |
101 |
9763 |
TEST_TIME |
102 |
9680 |
TEST_TIME |
103 |
9650 |
TEST_TIME |
104 |
9644 |
TEST_TIME |
105 |
9600 |
TEST_TIME |
106 |
9538 |
TEST_TIME |
107 |
9483 |
TEST_TIME |
108 |
9571 |
TEST_TIME |
109 |
9518 |
TEST_TIME |
110 |
9522 |
TEST_TIME |
111 |
9493 |
TEST_TIME |
112 |
9452 |
TEST_TIME |
113 |
9399 |
TEST_TIME |
114 |
9374 |
TEST_TIME |
115 |
9439 |
TEST_TIME |
116 |
9434 |
TEST_TIME |
117 |
9418 |
TEST_TIME |
118 |
9387 |
TEST_TIME |
119 |
9440 |
TEST_TIME |
120 |
9405 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 24-07-2022 22:39:43 to 24-07-2022 22:39:46.
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 |
1551566 |
1551566 |
0 |
0.00 |
0 |
20968 |
6 |
0 |
0 |
doc_list_biud |
1551545 |
1551545 |
0 |
0.00 |
0 |
56617 |
28 |
0 |
0 |
sp_add_invoice_to_stock |
5015 |
4909 |
106 |
2.11 |
30 |
184583 |
17314 |
0 |
106 |
sp_cancel_adding_invoice |
5981 |
5981 |
0 |
0.00 |
3 |
76676 |
747 |
0 |
0 |
sp_cancel_client_order |
1799 |
1799 |
0 |
0.00 |
4 |
18570 |
366 |
0 |
0 |
sp_cancel_customer_reserve |
585184 |
585184 |
0 |
0.00 |
0 |
56624 |
60 |
0 |
0 |
sp_cancel_pay_from_customer |
691 |
691 |
0 |
0.00 |
2 |
1432 |
58 |
0 |
0 |
sp_cancel_pay_to_supplier |
424 |
424 |
0 |
0.00 |
2 |
2158 |
61 |
0 |
0 |
sp_cancel_supplier_invoice |
6688 |
6682 |
6 |
0.08 |
1 |
23597 |
784 |
0 |
6 |
sp_cancel_supplier_order |
426 |
426 |
0 |
0.00 |
5 |
1072359 |
104598 |
0 |
0 |
sp_cancel_write_off |
10145 |
10145 |
0 |
0.00 |
1 |
22463 |
119 |
0 |
0 |
sp_client_order |
20794 |
20794 |
0 |
0.00 |
3 |
72297 |
389 |
0 |
0 |
sp_customer_reserve |
455650 |
455650 |
0 |
0.00 |
0 |
83635 |
170 |
0 |
0 |
sp_fill_shopping_cart |
31785 |
31785 |
0 |
0.00 |
1 |
10516 |
36 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
455647 |
455647 |
0 |
0.00 |
0 |
12979 |
14 |
0 |
0 |
sp_get_clo_for_invoice |
4906 |
4906 |
0 |
0.00 |
0 |
47103 |
331 |
0 |
0 |
sp_kill_cost_storno |
17241 |
17241 |
0 |
0.00 |
0 |
7128 |
52 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1187621 |
1187621 |
0 |
0.00 |
0 |
56611 |
33 |
0 |
0 |
sp_kill_qty_storno |
625257 |
625257 |
0 |
0.00 |
0 |
56616 |
70 |
0 |
0 |
sp_lock_selected_doc |
20965 |
20965 |
0 |
0.00 |
0 |
10648 |
8 |
0 |
0 |
sp_make_cost_storno |
27988 |
27988 |
0 |
0.00 |
0 |
20966 |
52 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27985 |
27985 |
0 |
0.00 |
0 |
7205 |
23 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20794 |
20794 |
0 |
0.00 |
0 |
72291 |
183 |
0 |
0 |
sp_pay_from_customer |
7095 |
7095 |
0 |
0.00 |
4 |
20972 |
111 |
0 |
0 |
sp_pay_to_supplier |
5844 |
5844 |
0 |
0.00 |
4 |
8168 |
113 |
0 |
0 |
sp_payment_common |
12938 |
12938 |
0 |
0.00 |
1 |
12423 |
25 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1799 |
1799 |
0 |
0.00 |
0 |
18564 |
337 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10885 |
10885 |
0 |
0.00 |
0 |
54382 |
330 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
10136 |
10136 |
0 |
0.00 |
0 |
22437 |
56 |
0 |
0 |
sp_reserve_write_off |
10143 |
10143 |
0 |
0.00 |
6 |
22469 |
170 |
0 |
0 |
sp_supplier_invoice |
5462 |
5462 |
0 |
0.00 |
5 |
82959 |
3096 |
0 |
0 |
sp_supplier_order |
5537 |
5537 |
0 |
0.00 |
4 |
28531 |
1266 |
0 |
0 |
srv_aggregate_perf_data |
117 |
117 |
0 |
0.00 |
2405 |
355818 |
18442 |
0 |
0 |
srv_fill_mon_cache_memory |
65 |
65 |
0 |
0.00 |
1763 |
137286 |
45988 |
0 |
0 |
srv_find_qd_qs_mism |
1081380 |
1081380 |
0 |
0.00 |
0 |
12116 |
5 |
0 |
0 |
srv_make_invnt_saldo |
603 |
603 |
0 |
0.00 |
53 |
78255 |
1146 |
0 |
0 |
srv_make_money_saldo |
744 |
744 |
0 |
0.00 |
1 |
1257 |
27 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
124411 |
368829 |
224057 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
106 |
106 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
6 |
6 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4909 |
4909 |
0 |
0.00 |
0 |
25005 |
181 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
422 |
422 |
0 |
0.00 |
0 |
10540 |
94 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1799 |
1799 |
0 |
0.00 |
0 |
7691 |
19 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
703 |
703 |
0 |
0.00 |
0 |
2424 |
22 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
691 |
691 |
0 |
0.00 |
0 |
2123 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
424 |
424 |
0 |
0.00 |
0 |
664 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
427 |
427 |
0 |
0.00 |
0 |
770 |
9 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
426 |
426 |
0 |
0.00 |
0 |
30267 |
1594 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1033 |
1033 |
0 |
0.00 |
0 |
7842 |
16 |
0 |
0 |
t$perf-norm:sp_client_order |
20794 |
20794 |
0 |
0.00 |
0 |
23548 |
17 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
1037 |
1037 |
0 |
0.00 |
0 |
4704 |
7 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7095 |
7095 |
0 |
0.00 |
0 |
22005 |
16 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5844 |
5844 |
0 |
0.00 |
0 |
23096 |
13 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
10143 |
10143 |
0 |
0.00 |
0 |
26368 |
13 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5462 |
5462 |
0 |
0.00 |
0 |
5684 |
16 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5537 |
5537 |
0 |
0.00 |
0 |
7983 |
16 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
117 |
117 |
0 |
0.00 |
0 |
95 |
3 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
65 |
65 |
0 |
0.00 |
0 |
752 |
18 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
603 |
603 |
0 |
0.00 |
0 |
417 |
11 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
744 |
744 |
0 |
0.00 |
0 |
3198 |
21 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
2 |
3 |
3 |
0 |
0 |
v_add_invoice_to_stock |
10014 |
9802 |
212 |
2.11 |
0 |
12384 |
20 |
0 |
212 |
v_all_customers |
37938 |
37938 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_suppliers |
30694 |
30694 |
0 |
0.00 |
0 |
119 |
1 |
0 |
0 |
v_all_wares |
41576 |
41576 |
0 |
0.00 |
0 |
22 |
1 |
0 |
0 |
v_cancel_adding_invoice |
844 |
844 |
0 |
0.00 |
0 |
2741 |
17 |
0 |
0 |
v_cancel_client_order |
3598 |
3598 |
0 |
0.00 |
0 |
4133 |
8 |
0 |
0 |
v_cancel_customer_prepayment |
1382 |
1382 |
0 |
0.00 |
0 |
955 |
4 |
0 |
0 |
v_cancel_customer_reserve |
1406 |
1406 |
0 |
0.00 |
0 |
2511 |
7 |
0 |
0 |
v_cancel_payment_to_supplier |
848 |
848 |
0 |
0.00 |
0 |
567 |
4 |
0 |
0 |
v_cancel_supplier_invoice |
866 |
854 |
12 |
1.38 |
0 |
2333 |
17 |
0 |
12 |
v_cancel_supplier_order |
852 |
852 |
0 |
0.00 |
0 |
4119 |
14 |
0 |
0 |
v_cancel_write_off |
2066 |
2066 |
0 |
0.00 |
0 |
5984 |
20 |
0 |
0 |
v_max_id_clo_ord |
5537 |
5537 |
0 |
0.00 |
0 |
462 |
1 |
0 |
0 |
v_max_id_clo_res |
1037 |
1037 |
0 |
0.00 |
0 |
3365 |
18 |
0 |
0 |
v_max_id_ord_sup |
5460 |
5460 |
0 |
0.00 |
0 |
5761 |
7 |
0 |
0 |
v_max_non_paid_invoice |
1493 |
1493 |
0 |
0.00 |
0 |
1215 |
4 |
0 |
0 |
v_max_non_paid_realizn |
3801 |
3801 |
0 |
0.00 |
0 |
5795 |
7 |
0 |
0 |
v_min_id_clo_ord |
5537 |
5537 |
0 |
0.00 |
0 |
2485 |
7 |
0 |
0 |
v_min_id_clo_res |
1037 |
1037 |
0 |
0.00 |
0 |
1727 |
5 |
0 |
0 |
v_min_id_ord_sup |
5460 |
5460 |
0 |
0.00 |
0 |
3650 |
7 |
0 |
0 |
v_min_non_paid_invoice |
5843 |
5843 |
0 |
0.00 |
0 |
4764 |
15 |
0 |
0 |
v_min_non_paid_realizn |
7094 |
7094 |
0 |
0.00 |
0 |
6626 |
18 |
0 |
0 |
v_our_firm |
10224 |
10224 |
0 |
0.00 |
0 |
22 |
1 |
0 |
0 |
v_reserve_write_off |
20269 |
20269 |
0 |
0.00 |
0 |
7550 |
7 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
12236 |
12236 |
0 |
0.00 |
0 |
23056 |
136 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
426 |
426 |
0 |
0.00 |
0 |
13595 |
380 |
0 |
0 |
x_make_qstorno_1000_1200 |
5537 |
5537 |
0 |
0.00 |
1 |
28498 |
1195 |
0 |
0 |
x_make_qstorno_1200_2000 |
5462 |
5462 |
0 |
0.00 |
2 |
82952 |
2966 |
0 |
0 |
x_make_qstorno_2100_3300 |
455650 |
455650 |
0 |
0.00 |
0 |
83178 |
154 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 24-07-2022 22:39:47 to 24-07-2022 22:39:51.
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 |
20:08:29 |
2 |
8192000000 |
8797116400 |
8807743488 |
3955424 |
0.048 |
1 |
1 |
2 |
0 |
4053696 |
55488 |
42784 |
20:09:29 |
24091 |
8192000000 |
9908732208 |
10219732992 |
993037328 |
10.811 |
100 |
90 |
180 |
0 |
1022436272 |
6324144 |
23074800 |
20:11:04 |
12344 |
8192000000 |
9955804752 |
10280878080 |
1041446336 |
11.279 |
100 |
86 |
172 |
0 |
1071614880 |
8679648 |
21488896 |
20:12:22 |
12313 |
8192000000 |
9974527792 |
10309734400 |
1065207392 |
11.506 |
100 |
76 |
150 |
1 |
1093327408 |
9024896 |
19095120 |
20:13:39 |
12903 |
8192000000 |
10034161904 |
10379108352 |
1122127360 |
12.047 |
100 |
80 |
161 |
0 |
1150422784 |
9568000 |
18727424 |
20:14:57 |
5597 |
8192000000 |
10067902976 |
10423554048 |
1160042448 |
12.404 |
100 |
84 |
168 |
0 |
1191217648 |
11112928 |
20062272 |
20:16:06 |
4321 |
8192000000 |
10107881712 |
10471481344 |
1196506000 |
12.744 |
100 |
78 |
156 |
0 |
1226738096 |
12926976 |
17305120 |
20:17:13 |
3093 |
8192000000 |
10137239120 |
10508386304 |
1227919328 |
13.035 |
100 |
83 |
167 |
0 |
1259866816 |
13372192 |
18575296 |
20:18:18 |
2033 |
8192000000 |
10167885456 |
10542616576 |
1252626160 |
13.262 |
100 |
85 |
169 |
1 |
1285409104 |
14234768 |
18548176 |
20:19:22 |
1363 |
8192000000 |
10193843440 |
10578739200 |
1283040800 |
13.541 |
100 |
83 |
164 |
0 |
1313595728 |
12402848 |
18152080 |
20:20:26 |
864 |
8192000000 |
10210402064 |
10599886848 |
1300397664 |
13.699 |
100 |
81 |
161 |
1 |
1330081632 |
11451920 |
18232048 |
20:21:46 |
4096 |
8192000000 |
10212867888 |
10618408960 |
1314870208 |
13.830 |
100 |
33 |
60 |
2 |
1328617856 |
6499520 |
7248128 |
20:22:55 |
14369 |
8192000000 |
10201988048 |
10622488576 |
1323665424 |
13.910 |
100 |
13 |
26 |
1 |
1332430272 |
5633216 |
3131632 |
20:24:09 |
6706 |
8192000000 |
10216727264 |
10637598720 |
1334289920 |
14.006 |
100 |
20 |
40 |
0 |
1345145984 |
5932608 |
4923456 |
20:25:17 |
29018 |
8192000000 |
10248022304 |
10660622336 |
1341999152 |
14.075 |
100 |
51 |
102 |
2 |
1360410656 |
6319584 |
12091920 |
20:26:46 |
5651 |
8192000000 |
10243706192 |
10664280064 |
1348964288 |
14.138 |
100 |
27 |
50 |
1 |
1360586224 |
5644544 |
5977392 |
20:27:54 |
7582 |
8192000000 |
10212054336 |
10630463488 |
1305594400 |
13.746 |
98 |
28 |
55 |
0 |
1317491824 |
5377536 |
6519888 |
20:29:03 |
18329 |
8192000000 |
10152565024 |
10559389696 |
1204835392 |
12.821 |
92 |
20 |
40 |
0 |
1214338768 |
5043424 |
4459952 |
20:30:22 |
11465 |
8192000000 |
10157801104 |
10564046848 |
1213245632 |
12.899 |
94 |
23 |
42 |
0 |
1223295744 |
5362608 |
4687504 |
20:31:35 |
9647 |
8192000000 |
10149195360 |
10549485568 |
1220104848 |
12.963 |
97 |
21 |
40 |
1 |
1229918816 |
5671760 |
4142208 |
20:32:48 |
3281 |
8192000000 |
10146362624 |
10543783936 |
1249288944 |
13.232 |
100 |
20 |
40 |
0 |
1258839536 |
5372960 |
4177632 |
20:33:53 |
61627 |
8192000000 |
10163013824 |
10574721024 |
1263228112 |
13.360 |
99 |
42 |
84 |
1 |
1278327072 |
5726176 |
9372784 |
20:35:55 |
8360 |
8192000000 |
10185787168 |
10592997376 |
1290801488 |
13.612 |
100 |
28 |
55 |
1 |
1302505328 |
5821344 |
5882496 |
20:37:05 |
5164 |
8192000000 |
10187448960 |
10601930752 |
1297041904 |
13.668 |
100 |
22 |
43 |
2 |
1307844560 |
6059632 |
4743024 |
20:38:13 |
56943 |
8192000000 |
10213480384 |
10629419008 |
1316798480 |
13.848 |
100 |
20 |
40 |
0 |
1326915664 |
4745856 |
5371328 |
20:40:31 |
33536 |
8192000000 |
10262149056 |
10669821952 |
1348281328 |
14.132 |
100 |
51 |
102 |
0 |
1371886832 |
12412848 |
11192656 |
20:42:09 |
10969 |
8192000000 |
10279827776 |
10699943936 |
1367094608 |
14.301 |
100 |
43 |
83 |
0 |
1392637776 |
16004816 |
9538352 |
20:43:25 |
18678 |
8192000000 |
10305390880 |
10725892096 |
1385697392 |
14.467 |
100 |
49 |
96 |
1 |
1419320208 |
22440576 |
11182240 |
20:44:50 |
46949 |
8192000000 |
10324256432 |
10753216512 |
1401235040 |
14.606 |
100 |
35 |
68 |
0 |
1436325280 |
26726096 |
8364144 |
20:46:39 |
9055 |
8192000000 |
10348008464 |
10767011840 |
1411574560 |
14.698 |
100 |
53 |
102 |
1 |
1457205536 |
33276464 |
12354512 |
20:47:58 |
8765 |
8192000000 |
10351410000 |
10762665984 |
1393655424 |
14.538 |
98 |
67 |
130 |
0 |
1449156544 |
39509456 |
15991664 |
20:49:15 |
7618 |
8192000000 |
10364967216 |
10784833536 |
1416790192 |
14.744 |
100 |
48 |
96 |
1 |
1474667824 |
45553920 |
12323712 |
20:50:29 |
7588 |
8192000000 |
10368000688 |
10789658624 |
1407193392 |
14.659 |
99 |
54 |
107 |
1 |
1472080288 |
51281216 |
13605680 |
20:51:49 |
2705 |
8192000000 |
10367506736 |
10776784896 |
1401204608 |
14.606 |
99 |
78 |
150 |
0 |
1473413152 |
52837168 |
19371376 |
20:52:58 |
3024 |
8192000000 |
10378495104 |
10782814208 |
1394588496 |
14.547 |
100 |
90 |
180 |
2 |
1479438000 |
61789776 |
23059728 |
20:54:07 |
3042 |
8192000000 |
10376569072 |
10793627648 |
1401105168 |
14.605 |
100 |
66 |
131 |
1 |
1484629824 |
66364880 |
17159776 |
20:55:16 |
4760 |
8192000000 |
10353510128 |
10759970816 |
1378278304 |
14.401 |
100 |
73 |
143 |
2 |
1458019792 |
61729264 |
18012224 |
20:56:27 |
1761 |
8192000000 |
10377344560 |
10786222080 |
1398139888 |
14.578 |
100 |
81 |
155 |
0 |
1479584336 |
61803120 |
19641328 |
20:57:39 |
14471 |
8192000000 |
10332696336 |
10753654784 |
1368137152 |
14.310 |
99 |
45 |
90 |
0 |
1432152320 |
52085552 |
11929616 |
20:58:55 |
12328 |
8192000000 |
10329185808 |
10751918080 |
1347668624 |
14.126 |
99 |
29 |
58 |
0 |
1425663168 |
69405824 |
8588720 |
21:00:23 |
27274 |
8192000000 |
10327421664 |
10757451776 |
1360016224 |
14.238 |
100 |
29 |
58 |
0 |
1431100656 |
62014368 |
9070064 |
21:02:08 |
47636 |
8192000000 |
10277106752 |
10717937664 |
1324696736 |
13.919 |
97 |
12 |
23 |
1 |
1359701904 |
31444144 |
3561024 |
21:03:57 |
35444 |
8192000000 |
10269675808 |
10706206720 |
1354680864 |
14.190 |
100 |
34 |
67 |
3 |
1368645616 |
5615328 |
8349424 |
21:05:33 |
59340 |
8192000000 |
10264044384 |
10715746304 |
1348901952 |
14.138 |
99 |
12 |
27 |
0 |
1364838080 |
13204304 |
2731824 |
21:07:33 |
72296 |
8192000000 |
10268399952 |
10710224896 |
1338944816 |
14.048 |
98 |
33 |
66 |
2 |
1351870944 |
5922128 |
7004000 |
21:09:48 |
137286 |
8192000000 |
10272332896 |
10712948736 |
1324329312 |
13.916 |
96 |
17 |
34 |
0 |
1334382448 |
6364848 |
3688288 |
21:13:09 |
22964 |
8192000000 |
10260414304 |
10702540800 |
1347569632 |
14.126 |
98 |
37 |
74 |
0 |
1369037280 |
12445376 |
9022272 |
21:14:33 |
33786 |
8192000000 |
10279623760 |
10721447936 |
1350657696 |
14.153 |
98 |
20 |
40 |
0 |
1368907776 |
13380032 |
4870048 |
21:16:08 |
113514 |
8192000000 |
10292943472 |
10743455744 |
1384821488 |
14.460 |
100 |
10 |
20 |
0 |
1402545024 |
14869456 |
2854080 |
21:19:14 |
45607 |
8192000000 |
10307109072 |
10760011776 |
1403575872 |
14.627 |
100 |
22 |
44 |
0 |
1426357744 |
17711184 |
5070688 |
21:21:02 |
62351 |
8192000000 |
10317459424 |
10761539584 |
1385790976 |
14.468 |
99 |
20 |
36 |
1 |
1403798272 |
13378816 |
4628480 |
21:23:09 |
53088 |
8192000000 |
10315597264 |
10771259392 |
1407303888 |
14.660 |
100 |
23 |
46 |
0 |
1427727616 |
14700592 |
5723136 |
21:25:23 |
22589 |
8192000000 |
10310979088 |
10763538432 |
1394094464 |
14.542 |
99 |
24 |
45 |
0 |
1412743552 |
13575872 |
5073216 |
21:26:55 |
58133 |
8192000000 |
10314049424 |
10782244864 |
1405400256 |
14.643 |
100 |
8 |
16 |
0 |
1420871936 |
13628496 |
1843184 |
21:29:21 |
46103 |
8192000000 |
10320342720 |
10772930560 |
1393664160 |
14.539 |
99 |
19 |
39 |
0 |
1409734240 |
12234160 |
3835920 |
21:31:09 |
84455 |
8192000000 |
10327555872 |
10761936896 |
1392475584 |
14.528 |
99 |
56 |
110 |
3 |
1416228144 |
11034816 |
12717744 |
21:33:36 |
38091 |
8192000000 |
10280941152 |
10742018048 |
1370610112 |
14.333 |
99 |
22 |
45 |
0 |
1387071600 |
11608480 |
4853008 |
21:35:15 |
12489 |
8192000000 |
10288086016 |
10735624192 |
1370628128 |
14.333 |
99 |
28 |
57 |
1 |
1381867392 |
4681072 |
6558192 |
21:36:29 |
41053 |
8192000000 |
10252992976 |
10702479360 |
1300865504 |
13.703 |
94 |
12 |
24 |
0 |
1313951280 |
10521408 |
2564368 |
21:38:10 |
38214 |
8192000000 |
10266023120 |
10718306304 |
1354966624 |
14.192 |
99 |
11 |
22 |
0 |
1372611664 |
15122352 |
2522688 |
21:39:51 |
43021 |
8192000000 |
10254914128 |
10707914752 |
1335739360 |
14.019 |
98 |
19 |
39 |
0 |
1348878848 |
8756336 |
4383152 |
21:41:34 |
49699 |
8192000000 |
10251689008 |
10704973824 |
1299723936 |
13.693 |
95 |
12 |
24 |
0 |
1314169808 |
11558784 |
2887088 |
21:43:26 |
46851 |
8192000000 |
10241381360 |
10681880576 |
1265856320 |
13.384 |
93 |
18 |
36 |
0 |
1278179776 |
8403344 |
3920112 |
21:45:15 |
27795 |
8192000000 |
10264943840 |
10705276928 |
1340758944 |
14.064 |
99 |
42 |
84 |
0 |
1362155536 |
11955296 |
9441296 |
21:46:49 |
34175 |
8192000000 |
10271271472 |
10716786688 |
1340619952 |
14.063 |
99 |
44 |
88 |
0 |
1363913952 |
13442272 |
9851728 |
21:48:24 |
54684 |
8192000000 |
10264684624 |
10703212544 |
1288627952 |
13.592 |
95 |
22 |
44 |
0 |
1306508080 |
13184320 |
4695808 |
21:50:23 |
49466 |
8192000000 |
10272732352 |
10722766848 |
1349029280 |
14.139 |
99 |
28 |
56 |
0 |
1370450688 |
15128192 |
6293216 |
21:52:23 |
20519 |
8192000000 |
10287214496 |
10716401664 |
1359844192 |
14.236 |
100 |
43 |
85 |
1 |
1378852432 |
9943920 |
9064320 |
21:53:55 |
81126 |
8192000000 |
10263738976 |
10718064640 |
1346569712 |
14.117 |
99 |
12 |
24 |
0 |
1364070528 |
14831440 |
2669376 |
21:56:21 |
56757 |
8192000000 |
10276041360 |
10728472576 |
1357819680 |
14.218 |
99 |
12 |
24 |
3 |
1368564400 |
7819616 |
2925104 |
21:58:22 |
95529 |
8192000000 |
10268075616 |
10726297600 |
1346149248 |
14.113 |
98 |
12 |
24 |
0 |
1364711568 |
16266512 |
2295808 |
22:00:58 |
32940 |
8192000000 |
10266165056 |
10723655680 |
1359150592 |
14.230 |
99 |
31 |
64 |
1 |
1376785344 |
10121216 |
7513536 |
22:02:32 |
66648 |
8192000000 |
10270178224 |
10738565120 |
1374064048 |
14.363 |
100 |
14 |
28 |
0 |
1389081952 |
11762896 |
3255008 |
22:04:45 |
65952 |
8192000000 |
10270496816 |
10733223936 |
1359819760 |
14.236 |
99 |
19 |
38 |
0 |
1375467328 |
10822992 |
4824576 |
22:06:58 |
25435 |
8192000000 |
10297880496 |
10743005184 |
1384601136 |
14.458 |
100 |
29 |
54 |
1 |
1398393792 |
7354272 |
6438384 |
22:08:27 |
91343 |
8192000000 |
10310253024 |
10755715072 |
1343702944 |
14.091 |
96 |
26 |
52 |
0 |
1358367152 |
8950064 |
5714144 |
22:10:58 |
89804 |
8192000000 |
10304930432 |
10756042752 |
1362780384 |
14.262 |
97 |
15 |
30 |
0 |
1376134992 |
10276032 |
3078576 |
22:13:34 |
34010 |
8192000000 |
10311236480 |
10759057408 |
1385207824 |
14.463 |
99 |
20 |
41 |
0 |
1398027344 |
8517328 |
4302192 |
22:15:08 |
78238 |
8192000000 |
10324557136 |
10786398208 |
1410158016 |
14.685 |
100 |
21 |
42 |
0 |
1433382928 |
18521616 |
4703296 |
22:17:29 |
115909 |
8192000000 |
10319865888 |
10796584960 |
1388710976 |
14.494 |
99 |
6 |
12 |
0 |
1410125344 |
19965120 |
1449248 |
22:20:26 |
120850 |
8192000000 |
10276208736 |
10748530688 |
1347011008 |
14.121 |
96 |
16 |
32 |
1 |
1361996736 |
11550720 |
3435008 |
22:23:28 |
65892 |
8192000000 |
10288672592 |
10747498496 |
1388613248 |
14.493 |
100 |
8 |
16 |
0 |
1401580816 |
10819232 |
2148336 |
22:25:34 |
83851 |
8192000000 |
10257624544 |
10720272384 |
1324270784 |
13.915 |
95 |
16 |
32 |
0 |
1339823424 |
11583296 |
3969344 |
22:27:59 |
52094 |
8192000000 |
10265624336 |
10723983360 |
1348821632 |
14.137 |
99 |
23 |
47 |
0 |
1369411952 |
14775952 |
5814368 |
22:29:52 |
36759 |
8192000000 |
10281516752 |
10735681536 |
1355334512 |
14.195 |
98 |
28 |
54 |
0 |
1370148608 |
9078784 |
5735312 |
22:32:01 |
53178 |
8192000000 |
10243337072 |
10697162752 |
1309553840 |
13.782 |
96 |
25 |
49 |
0 |
1333413680 |
17744512 |
6115328 |
22:33:56 |
60526 |
8192000000 |
10256317072 |
10719875072 |
1348595040 |
14.135 |
99 |
7 |
14 |
1 |
1361801376 |
11880400 |
1325936 |
22:36:03 |
13791 |
8192000000 |
10276327296 |
10723876864 |
1368442896 |
14.313 |
100 |
28 |
55 |
0 |
1382424976 |
8029664 |
5952416 |
22:37:29 |
48361 |
8192000000 |
10248268832 |
10701221888 |
1316949344 |
13.849 |
97 |
27 |
54 |
0 |
1337417984 |
14673008 |
5795632 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 24-07-2022 22:39:53 to 24-07-2022 22:40:08.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
106 |
v_add_invoice_to_stock |
335544517 |
except |
6 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-07-2022 22:40:09 to 24-07-2022 22:40:11.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 242300
MON$OLDEST_ACTIVE 243070
MON$OLDEST_SNAPSHOT 243070
MON$NEXT_TRANSACTION 243070
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 2017536
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.33613 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33613 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33613 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33613 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0
Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:124:
:125: mscs-test-161.budzdorov.ru Sun Jul 24 22:38:40 2022
:126: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:127:
:128:
:129: mscs-test-161.budzdorov.ru Sun Jul 24 22:38:40 2022
:130: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131:
:132:
:133: mscs-test-161.budzdorov.ru Sun Jul 24 22:38:40 2022
:134: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:135:
:136:
:137: mscs-test-161.budzdorov.ru Sun Jul 24 22:38:41 2022
:138: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139:
--- end of diff output ---
24.07.22 22:40:12. There are 3 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-07-24 22:40:14 |
No severe PSQL-related problems occured |
24.07.22 22:40:15. End of report.