Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.07.2022 07:48
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 | 15687956 kB |
MemAvailable | 31088492 kB |
Buffers | 0 kB |
Cached | 16043876 kB |
SwapCached | 2500 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 4.0.2
DB_NAME /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
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-22 07:47:29
DTS_END 2022-07-22 07:47:29.0760
FB_GDSCODE -1
FB_MNEMONA
STACK SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/46650
TRN_ID 213948
ATT_ID 592
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: |
8995.12 |
24386 |
1079414 |
customer order: creation |
164.24 |
488 |
19709 |
customer order: refuse |
13.43 |
424 |
1612 |
order to supplier: creation |
42.81 |
1397 |
5137 |
order to supplier: removal |
3.48 |
155595 |
417 |
invoice (draft): creation |
44.33 |
3124 |
5320 |
invoice (draft): removal |
50.20 |
998 |
6024 |
invoice accept: apply |
40.61 |
27203 |
4873 |
invoice accept: cancel |
45.94 |
1239 |
5513 |
customer reserve: creation |
3793.71 |
256 |
455245 |
customer reserve: removal |
4516.29 |
93 |
541955 |
realization accept: apply |
79.51 |
299 |
9541 |
realization accept: cancel |
76.97 |
156 |
9236 |
payment from customer: creation |
57.43 |
195 |
6892 |
payment from customer: removal |
5.37 |
128 |
644 |
payment to supplier: creation |
45.65 |
218 |
5478 |
payment to supplier: removal |
3.03 |
151 |
364 |
service: total inventory turnovers |
3.68 |
4444 |
441 |
service: total monetary turnovers |
7.62 |
341 |
914 |
service: aggregate perf. data |
0.78 |
18885 |
93 |
service: refresh index statistics |
0.05 |
272085 |
6 |
Completed "Performance in TOTAL". Done for 00:00:02, from 22-07-2022 07:49:05 to 22-07-2022 07:49:07.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
7911 |
TEST_TIME |
2 |
6374 |
TEST_TIME |
3 |
6629 |
TEST_TIME |
4 |
6823 |
TEST_TIME |
5 |
6271 |
TEST_TIME |
6 |
6443 |
TEST_TIME |
7 |
6659 |
TEST_TIME |
8 |
7201 |
TEST_TIME |
9 |
6857 |
TEST_TIME |
10 |
7117 |
TEST_TIME |
11 |
7359 |
TEST_TIME |
12 |
7213 |
TEST_TIME |
13 |
7611 |
TEST_TIME |
14 |
7695 |
TEST_TIME |
15 |
7619 |
TEST_TIME |
16 |
7770 |
TEST_TIME |
17 |
7748 |
TEST_TIME |
18 |
7746 |
TEST_TIME |
19 |
7780 |
TEST_TIME |
20 |
7950 |
TEST_TIME |
21 |
8162 |
TEST_TIME |
22 |
8188 |
TEST_TIME |
23 |
8410 |
TEST_TIME |
24 |
8688 |
TEST_TIME |
25 |
8955 |
TEST_TIME |
26 |
8789 |
TEST_TIME |
27 |
8645 |
TEST_TIME |
28 |
8921 |
TEST_TIME |
29 |
9064 |
TEST_TIME |
30 |
9468 |
TEST_TIME |
31 |
9757 |
TEST_TIME |
32 |
9696 |
TEST_TIME |
33 |
10163 |
TEST_TIME |
34 |
10482 |
TEST_TIME |
35 |
10979 |
TEST_TIME |
36 |
10740 |
TEST_TIME |
37 |
10707 |
TEST_TIME |
38 |
10619 |
TEST_TIME |
39 |
10675 |
TEST_TIME |
40 |
10517 |
TEST_TIME |
41 |
10544 |
TEST_TIME |
42 |
10425 |
TEST_TIME |
43 |
10341 |
TEST_TIME |
44 |
10218 |
TEST_TIME |
45 |
10146 |
TEST_TIME |
46 |
10169 |
TEST_TIME |
47 |
10220 |
TEST_TIME |
48 |
10100 |
TEST_TIME |
49 |
10128 |
TEST_TIME |
50 |
9975 |
TEST_TIME |
51 |
9886 |
TEST_TIME |
52 |
9712 |
TEST_TIME |
53 |
9764 |
TEST_TIME |
54 |
9704 |
TEST_TIME |
55 |
9640 |
TEST_TIME |
56 |
9651 |
TEST_TIME |
57 |
9593 |
TEST_TIME |
58 |
9586 |
TEST_TIME |
59 |
9556 |
TEST_TIME |
60 |
9590 |
TEST_TIME |
61 |
9531 |
TEST_TIME |
62 |
9500 |
TEST_TIME |
63 |
9476 |
TEST_TIME |
64 |
9407 |
TEST_TIME |
65 |
9394 |
TEST_TIME |
66 |
9344 |
TEST_TIME |
67 |
9315 |
TEST_TIME |
68 |
9265 |
TEST_TIME |
69 |
9216 |
TEST_TIME |
70 |
9222 |
TEST_TIME |
71 |
9282 |
TEST_TIME |
72 |
9291 |
TEST_TIME |
73 |
9383 |
TEST_TIME |
74 |
9398 |
TEST_TIME |
75 |
9446 |
TEST_TIME |
76 |
9467 |
TEST_TIME |
77 |
9422 |
TEST_TIME |
78 |
9468 |
TEST_TIME |
79 |
9501 |
TEST_TIME |
80 |
9484 |
TEST_TIME |
81 |
9403 |
TEST_TIME |
82 |
9460 |
TEST_TIME |
83 |
9427 |
TEST_TIME |
84 |
9407 |
TEST_TIME |
85 |
9369 |
TEST_TIME |
86 |
9376 |
TEST_TIME |
87 |
9362 |
TEST_TIME |
88 |
9356 |
TEST_TIME |
89 |
9318 |
TEST_TIME |
90 |
9278 |
TEST_TIME |
91 |
9257 |
TEST_TIME |
92 |
9200 |
TEST_TIME |
93 |
9161 |
TEST_TIME |
94 |
9210 |
TEST_TIME |
95 |
9189 |
TEST_TIME |
96 |
9132 |
TEST_TIME |
97 |
9111 |
TEST_TIME |
98 |
9070 |
TEST_TIME |
99 |
9027 |
TEST_TIME |
100 |
9102 |
TEST_TIME |
101 |
9135 |
TEST_TIME |
102 |
9152 |
TEST_TIME |
103 |
9158 |
TEST_TIME |
104 |
9130 |
TEST_TIME |
105 |
9127 |
TEST_TIME |
106 |
9178 |
TEST_TIME |
107 |
9173 |
TEST_TIME |
108 |
9177 |
TEST_TIME |
109 |
9194 |
TEST_TIME |
110 |
9215 |
TEST_TIME |
111 |
9236 |
TEST_TIME |
112 |
9210 |
TEST_TIME |
113 |
9197 |
TEST_TIME |
114 |
9228 |
TEST_TIME |
115 |
9157 |
TEST_TIME |
116 |
9140 |
TEST_TIME |
117 |
9121 |
TEST_TIME |
118 |
9100 |
TEST_TIME |
119 |
9078 |
TEST_TIME |
120 |
9015 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 22-07-2022 07:49:08 to 22-07-2022 07:49:12.
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 |
1498967 |
1498967 |
0 |
0.00 |
0 |
27911 |
13 |
0 |
0 |
doc_list_biud |
1498967 |
1498967 |
0 |
0.00 |
0 |
33301 |
40 |
0 |
0 |
sp_add_invoice_to_stock |
4964 |
4873 |
91 |
1.83 |
48 |
236993 |
27203 |
0 |
91 |
sp_cancel_adding_invoice |
5513 |
5513 |
0 |
0.00 |
6 |
102921 |
1239 |
0 |
0 |
sp_cancel_client_order |
1612 |
1612 |
0 |
0.00 |
6 |
11760 |
425 |
0 |
0 |
sp_cancel_customer_reserve |
541955 |
541955 |
0 |
0.00 |
1 |
29166 |
94 |
0 |
0 |
sp_cancel_pay_from_customer |
644 |
644 |
0 |
0.00 |
3 |
3515 |
129 |
0 |
0 |
sp_cancel_pay_to_supplier |
364 |
364 |
0 |
0.00 |
4 |
10319 |
152 |
0 |
0 |
sp_cancel_supplier_invoice |
6029 |
6024 |
5 |
0.08 |
2 |
28916 |
998 |
0 |
5 |
sp_cancel_supplier_order |
417 |
417 |
0 |
0.00 |
11 |
1258125 |
155595 |
0 |
0 |
sp_cancel_write_off |
9236 |
9236 |
0 |
0.00 |
2 |
11913 |
156 |
0 |
0 |
sp_client_order |
19709 |
19709 |
0 |
0.00 |
5 |
37550 |
488 |
0 |
0 |
sp_customer_reserve |
455245 |
455245 |
0 |
0.00 |
0 |
87253 |
257 |
0 |
0 |
sp_fill_shopping_cart |
30149 |
30149 |
0 |
0.00 |
1 |
11349 |
86 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
455220 |
455220 |
0 |
0.00 |
0 |
21500 |
18 |
0 |
0 |
sp_get_clo_for_invoice |
4840 |
4840 |
0 |
0.00 |
0 |
19917 |
269 |
0 |
0 |
sp_kill_cost_storno |
15757 |
15757 |
0 |
0.00 |
0 |
16096 |
77 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1099587 |
1099587 |
0 |
0.00 |
0 |
33300 |
41 |
0 |
0 |
sp_kill_qty_storno |
579136 |
579136 |
0 |
0.00 |
0 |
33301 |
95 |
0 |
0 |
sp_lock_selected_doc |
19813 |
19813 |
0 |
0.00 |
0 |
10848 |
9 |
0 |
0 |
sp_make_cost_storno |
26749 |
26749 |
0 |
0.00 |
0 |
14233 |
87 |
0 |
0 |
sp_multiply_rows_for_pdistr |
26749 |
26749 |
0 |
0.00 |
0 |
9172 |
39 |
0 |
0 |
sp_multiply_rows_for_qdistr |
19709 |
19709 |
0 |
0.00 |
0 |
37465 |
166 |
0 |
0 |
sp_pay_from_customer |
6892 |
6892 |
0 |
0.00 |
5 |
13457 |
196 |
0 |
0 |
sp_pay_to_supplier |
5478 |
5478 |
0 |
0.00 |
6 |
15478 |
218 |
0 |
0 |
sp_payment_common |
12370 |
12370 |
0 |
0.00 |
2 |
12000 |
49 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1612 |
1612 |
0 |
0.00 |
0 |
11749 |
339 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10351 |
10351 |
0 |
0.00 |
0 |
23770 |
530 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9541 |
9541 |
0 |
0.00 |
0 |
21160 |
71 |
0 |
0 |
sp_reserve_write_off |
9541 |
9541 |
0 |
0.00 |
8 |
21265 |
300 |
0 |
0 |
sp_supplier_invoice |
5320 |
5320 |
0 |
0.00 |
11 |
68525 |
3125 |
0 |
0 |
sp_supplier_order |
5137 |
5137 |
0 |
0.00 |
7 |
44673 |
1398 |
0 |
0 |
srv_aggregate_perf_data |
93 |
93 |
0 |
0.00 |
2265 |
119334 |
18886 |
0 |
0 |
srv_fill_mon_cache_memory |
69 |
69 |
0 |
0.00 |
788 |
177480 |
38529 |
0 |
0 |
srv_find_qd_qs_mism |
1032382 |
1032382 |
0 |
0.00 |
0 |
27909 |
10 |
0 |
0 |
srv_make_invnt_saldo |
441 |
441 |
0 |
0.00 |
66 |
81193 |
4445 |
0 |
0 |
srv_make_money_saldo |
914 |
914 |
0 |
0.00 |
1 |
10461 |
342 |
0 |
0 |
srv_recalc_idx_stat |
6 |
6 |
0 |
0.00 |
47554 |
687203 |
272085 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
91 |
91 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
5 |
5 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4875 |
4875 |
0 |
0.00 |
1 |
20545 |
1045 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
418 |
418 |
0 |
0.00 |
1 |
6919 |
482 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1612 |
1612 |
0 |
0.00 |
0 |
4358 |
34 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
652 |
652 |
0 |
0.00 |
0 |
3388 |
32 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
644 |
644 |
0 |
0.00 |
0 |
789 |
16 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
364 |
364 |
0 |
0.00 |
0 |
394 |
11 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
376 |
376 |
0 |
0.00 |
0 |
976 |
29 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
417 |
417 |
0 |
0.00 |
0 |
114604 |
6998 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
952 |
952 |
0 |
0.00 |
0 |
5267 |
26 |
0 |
0 |
t$perf-norm:sp_client_order |
19709 |
19709 |
0 |
0.00 |
0 |
14235 |
41 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
949 |
949 |
0 |
0.00 |
0 |
481 |
12 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6892 |
6892 |
0 |
0.00 |
0 |
25469 |
26 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5478 |
5478 |
0 |
0.00 |
0 |
4041 |
21 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9541 |
9541 |
0 |
0.00 |
0 |
10842 |
26 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5320 |
5320 |
0 |
0.00 |
0 |
12508 |
54 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5137 |
5137 |
0 |
0.00 |
0 |
8203 |
40 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
93 |
93 |
0 |
0.00 |
0 |
2024 |
35 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
69 |
69 |
0 |
0.00 |
0 |
518 |
11 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
441 |
441 |
0 |
0.00 |
0 |
907 |
23 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
914 |
914 |
0 |
0.00 |
0 |
1727 |
10 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
6 |
6 |
0 |
0.00 |
4 |
474 |
148 |
0 |
0 |
v_add_invoice_to_stock |
9856 |
9674 |
182 |
1.84 |
0 |
6398 |
27 |
0 |
182 |
v_all_customers |
36152 |
36152 |
0 |
0.00 |
0 |
111 |
4 |
0 |
0 |
v_all_suppliers |
28908 |
28908 |
0 |
0.00 |
0 |
64 |
4 |
0 |
0 |
v_all_wares |
39418 |
39418 |
0 |
0.00 |
0 |
113 |
4 |
0 |
0 |
v_cancel_adding_invoice |
836 |
836 |
0 |
0.00 |
0 |
2041 |
20 |
0 |
0 |
v_cancel_client_order |
3224 |
3224 |
0 |
0.00 |
0 |
2360 |
11 |
0 |
0 |
v_cancel_customer_prepayment |
1288 |
1288 |
0 |
0.00 |
0 |
3155 |
13 |
0 |
0 |
v_cancel_customer_reserve |
1304 |
1304 |
0 |
0.00 |
0 |
3169 |
15 |
0 |
0 |
v_cancel_payment_to_supplier |
728 |
728 |
0 |
0.00 |
0 |
1564 |
13 |
0 |
0 |
v_cancel_supplier_invoice |
762 |
752 |
10 |
1.31 |
0 |
7892 |
43 |
0 |
10 |
v_cancel_supplier_order |
834 |
834 |
0 |
0.00 |
0 |
2324 |
16 |
0 |
0 |
v_cancel_write_off |
1904 |
1904 |
0 |
0.00 |
0 |
3855 |
28 |
0 |
0 |
v_max_id_clo_ord |
5136 |
5136 |
0 |
0.00 |
0 |
129 |
5 |
0 |
0 |
v_max_id_clo_res |
949 |
949 |
0 |
0.00 |
0 |
772 |
9 |
0 |
0 |
v_max_id_ord_sup |
5304 |
5304 |
0 |
0.00 |
0 |
2998 |
6 |
0 |
0 |
v_max_non_paid_invoice |
1464 |
1464 |
0 |
0.00 |
0 |
157 |
8 |
0 |
0 |
v_max_non_paid_realizn |
3622 |
3622 |
0 |
0.00 |
0 |
2573 |
8 |
0 |
0 |
v_min_id_clo_ord |
5136 |
5136 |
0 |
0.00 |
0 |
6994 |
11 |
0 |
0 |
v_min_id_clo_res |
949 |
949 |
0 |
0.00 |
0 |
2775 |
18 |
0 |
0 |
v_min_id_ord_sup |
5304 |
5304 |
0 |
0.00 |
0 |
7548 |
9 |
0 |
0 |
v_min_non_paid_invoice |
5478 |
5478 |
0 |
0.00 |
0 |
11345 |
17 |
0 |
0 |
v_min_non_paid_realizn |
6892 |
6892 |
0 |
0.00 |
0 |
11989 |
21 |
0 |
0 |
v_our_firm |
9806 |
9806 |
0 |
0.00 |
0 |
69 |
5 |
0 |
0 |
v_reserve_write_off |
19082 |
19082 |
0 |
0.00 |
0 |
4609 |
14 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
11161 |
11161 |
0 |
0.00 |
0 |
25013 |
124 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
417 |
417 |
0 |
0.00 |
0 |
11906 |
365 |
0 |
0 |
x_make_qstorno_1000_1200 |
5137 |
5137 |
0 |
0.00 |
2 |
44663 |
1221 |
0 |
0 |
x_make_qstorno_1200_2000 |
5320 |
5320 |
0 |
0.00 |
5 |
68495 |
2894 |
0 |
0 |
x_make_qstorno_2100_3300 |
455245 |
455245 |
0 |
0.00 |
0 |
87247 |
225 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 22-07-2022 07:49:13 to 22-07-2022 07:49:17.
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 |
05:17:32 |
3 |
8192000000 |
8798437344 |
8809598976 |
4462976 |
0.054 |
2 |
1 |
2 |
0 |
4562368 |
63616 |
35776 |
05:18:33 |
30393 |
8192000000 |
9723253520 |
10023227392 |
802933152 |
8.926 |
100 |
88 |
176 |
0 |
831854224 |
7958640 |
20962432 |
05:20:08 |
19648 |
8192000000 |
9779003152 |
10088407040 |
849794976 |
9.398 |
100 |
92 |
184 |
0 |
884341008 |
13268672 |
21277360 |
05:21:32 |
13779 |
8192000000 |
9805245248 |
10126753792 |
874600368 |
9.646 |
100 |
86 |
172 |
0 |
915009744 |
20850560 |
19558816 |
05:22:51 |
8286 |
8192000000 |
9864897728 |
10195972096 |
909180816 |
9.989 |
100 |
84 |
168 |
0 |
978813600 |
51525792 |
18106992 |
05:24:03 |
3738 |
8192000000 |
9896271600 |
10240192512 |
943894208 |
10.331 |
100 |
78 |
154 |
0 |
1022515888 |
62660064 |
15961616 |
05:25:10 |
1935 |
8192000000 |
9953910112 |
10303119360 |
981909424 |
10.703 |
100 |
86 |
169 |
0 |
1066803056 |
67576352 |
17317280 |
05:26:14 |
1605 |
8192000000 |
9989482192 |
10346614784 |
1010550912 |
10.981 |
100 |
88 |
168 |
3 |
1105014592 |
77043744 |
17419936 |
05:27:18 |
1067 |
8192000000 |
10015730192 |
10384482304 |
1034435024 |
11.211 |
100 |
98 |
197 |
3 |
1142171360 |
88140992 |
19595344 |
05:28:21 |
1037 |
8192000000 |
10014571872 |
10385702912 |
1051120320 |
11.371 |
100 |
91 |
173 |
2 |
1133213264 |
64040256 |
18052688 |
05:29:23 |
860 |
8192000000 |
10036948992 |
10417127424 |
1067410000 |
11.527 |
100 |
97 |
188 |
1 |
1154279216 |
69390144 |
17479072 |
05:30:33 |
4339 |
8192000000 |
10030357136 |
10417790976 |
1069535808 |
11.548 |
100 |
64 |
118 |
1 |
1150864192 |
69267440 |
12060944 |
05:31:38 |
997 |
8192000000 |
10037864576 |
10419732480 |
1081008288 |
11.657 |
100 |
91 |
171 |
0 |
1158828240 |
59825168 |
17994784 |
05:32:40 |
1297 |
8192000000 |
10052379360 |
10439409664 |
1087065856 |
11.715 |
100 |
94 |
184 |
1 |
1173286160 |
66118496 |
20101808 |
05:33:43 |
1042 |
8192000000 |
10057974752 |
10444525568 |
1090836048 |
11.751 |
100 |
93 |
181 |
1 |
1180995856 |
71757696 |
18402112 |
05:34:45 |
1320 |
8192000000 |
10042595584 |
10433433600 |
1094028896 |
11.781 |
100 |
86 |
160 |
3 |
1161610736 |
50616080 |
16965760 |
05:35:47 |
1059 |
8192000000 |
10051532208 |
10444570624 |
1099570992 |
11.834 |
100 |
93 |
176 |
2 |
1177436384 |
59463856 |
18401536 |
05:36:49 |
2334 |
8192000000 |
10073787792 |
10469003264 |
1100205280 |
11.840 |
100 |
78 |
150 |
2 |
1200734992 |
85905568 |
14624144 |
05:37:52 |
1037 |
8192000000 |
10078176816 |
10469007360 |
1102705584 |
11.863 |
100 |
97 |
193 |
1 |
1201075472 |
79483632 |
18886256 |
05:38:55 |
1295 |
8192000000 |
10054198800 |
10445062144 |
1092069296 |
11.762 |
100 |
95 |
173 |
2 |
1179467392 |
69346368 |
18051728 |
05:39:57 |
1089 |
8192000000 |
10051486736 |
10436050944 |
1072049216 |
11.572 |
100 |
93 |
165 |
2 |
1172555840 |
82119168 |
18387456 |
05:40:59 |
1213 |
8192000000 |
10048738016 |
10429247488 |
1069755568 |
11.550 |
100 |
98 |
187 |
0 |
1170053008 |
81103808 |
19193632 |
05:42:01 |
923 |
8192000000 |
10015209792 |
10395521024 |
1055001504 |
11.409 |
100 |
87 |
167 |
0 |
1141975136 |
68470016 |
18503616 |
05:43:03 |
2033 |
8192000000 |
10000560640 |
10385694720 |
1073455328 |
11.585 |
100 |
74 |
141 |
0 |
1123667216 |
34683312 |
15528576 |
05:44:06 |
16613 |
8192000000 |
9985929232 |
10379939840 |
1021588864 |
11.087 |
98 |
45 |
88 |
1 |
1096110256 |
65398784 |
9122608 |
05:45:24 |
8515 |
8192000000 |
9953863984 |
10340311040 |
1029343232 |
11.162 |
99 |
40 |
77 |
3 |
1091333104 |
54381808 |
7608064 |
05:46:34 |
1239 |
8192000000 |
9976110800 |
10345914368 |
1021628416 |
11.088 |
99 |
91 |
179 |
3 |
1103938240 |
63298848 |
19010976 |
05:47:37 |
5696 |
8192000000 |
9967313568 |
10344878080 |
1038980880 |
11.255 |
99 |
67 |
114 |
1 |
1095932368 |
45761296 |
11190192 |
05:48:46 |
789 |
8192000000 |
10022961152 |
10401251328 |
1067682336 |
11.530 |
100 |
96 |
185 |
2 |
1144584240 |
57134080 |
19767824 |
05:49:51 |
3706 |
8192000000 |
10071654960 |
10459275264 |
1087148576 |
11.716 |
100 |
73 |
143 |
0 |
1195747120 |
94593376 |
14005168 |
05:50:59 |
1585 |
8192000000 |
10090246880 |
10478018560 |
1102393024 |
11.860 |
100 |
85 |
166 |
0 |
1205749792 |
86302112 |
17054656 |
05:52:03 |
16869 |
8192000000 |
10100348000 |
10499239936 |
1109142656 |
11.924 |
100 |
53 |
105 |
1 |
1210853920 |
90748416 |
10962848 |
05:53:31 |
1872 |
8192000000 |
10147099168 |
10551341056 |
1128687424 |
12.109 |
100 |
86 |
164 |
0 |
1264395040 |
118038800 |
17668816 |
05:54:35 |
2149 |
8192000000 |
10173705008 |
10573615104 |
1135396448 |
12.172 |
100 |
86 |
170 |
3 |
1297293840 |
140698624 |
21198768 |
05:55:41 |
2829 |
8192000000 |
10152563488 |
10566549504 |
1136529568 |
12.183 |
100 |
68 |
123 |
0 |
1273757200 |
124295488 |
12932144 |
05:56:48 |
4473 |
8192000000 |
10202894912 |
10603061248 |
1144871520 |
12.261 |
100 |
75 |
141 |
3 |
1306040176 |
146056432 |
15112224 |
05:57:57 |
3130 |
8192000000 |
10197527712 |
10610937856 |
1151073328 |
12.320 |
100 |
77 |
150 |
0 |
1316572048 |
149217472 |
16281248 |
05:59:03 |
4911 |
8192000000 |
10236219712 |
10640154624 |
1163950192 |
12.440 |
100 |
72 |
142 |
0 |
1348335424 |
168647488 |
15737744 |
06:00:12 |
1485 |
8192000000 |
10274605584 |
10684567552 |
1182455904 |
12.613 |
100 |
87 |
169 |
3 |
1383748944 |
182745760 |
18547280 |
06:01:17 |
1195 |
8192000000 |
10327312272 |
10732474368 |
1195046384 |
12.730 |
100 |
84 |
167 |
1 |
1437101920 |
223651616 |
18403920 |
06:02:22 |
3647 |
8192000000 |
10334709712 |
10744995840 |
1194208560 |
12.723 |
100 |
76 |
145 |
0 |
1446247424 |
235173952 |
16864912 |
06:03:29 |
943 |
8192000000 |
10383263232 |
10804834304 |
1196701440 |
12.746 |
100 |
94 |
182 |
3 |
1487821360 |
269882112 |
21237808 |
06:04:35 |
1115 |
8192000000 |
10427603152 |
10833301504 |
1204213744 |
12.815 |
100 |
88 |
171 |
1 |
1532165360 |
308061568 |
19890048 |
06:05:39 |
1200 |
8192000000 |
10444308848 |
10850906112 |
1196550928 |
12.744 |
100 |
89 |
170 |
0 |
1550799632 |
334405312 |
19843392 |
06:06:45 |
909 |
8192000000 |
10436801584 |
10885718016 |
1192568672 |
12.707 |
100 |
97 |
192 |
0 |
1544899584 |
329367584 |
22963328 |
06:07:49 |
1073 |
8192000000 |
10450536448 |
10894053376 |
1189604416 |
12.680 |
100 |
93 |
178 |
0 |
1559705184 |
347896976 |
22203792 |
06:08:55 |
1936 |
8192000000 |
10453494144 |
10872393728 |
1178519056 |
12.576 |
99 |
93 |
182 |
3 |
1556765696 |
355760976 |
22485664 |
06:09:59 |
783 |
8192000000 |
10438757152 |
10897408000 |
1190930688 |
12.692 |
100 |
97 |
185 |
0 |
1543177520 |
328183760 |
24063072 |
06:11:03 |
990 |
8192000000 |
10447257568 |
10899709952 |
1193870352 |
12.719 |
100 |
94 |
179 |
0 |
1554968448 |
339066240 |
22031856 |
06:12:05 |
3542 |
8192000000 |
10430121040 |
10910842880 |
1201977456 |
12.795 |
100 |
62 |
119 |
2 |
1530931680 |
313208352 |
15745872 |
06:13:13 |
6118 |
8192000000 |
10466362304 |
10884919296 |
1196094896 |
12.740 |
100 |
67 |
134 |
0 |
1563457200 |
350618496 |
16743808 |
06:14:41 |
19178 |
8192000000 |
10536937392 |
11001589760 |
1176652656 |
12.559 |
99 |
62 |
121 |
0 |
1660011728 |
467445472 |
15913600 |
06:16:20 |
12659 |
8192000000 |
10475649488 |
10919895040 |
1176890848 |
12.561 |
100 |
44 |
88 |
0 |
1597787024 |
409763344 |
11132832 |
06:17:38 |
12878 |
8192000000 |
10412453696 |
10896347136 |
1146111552 |
12.273 |
99 |
31 |
60 |
1 |
1511922080 |
357471040 |
8339488 |
06:19:08 |
40484 |
8192000000 |
10362970512 |
10806693888 |
1131535184 |
12.136 |
99 |
22 |
44 |
1 |
1446079808 |
308771968 |
5772656 |
06:21:01 |
29842 |
8192000000 |
10248514368 |
10690351104 |
1151907056 |
12.327 |
100 |
21 |
42 |
0 |
1387813392 |
230918928 |
4987408 |
06:23:04 |
28665 |
8192000000 |
10076203376 |
10507149312 |
1103084496 |
11.867 |
96 |
38 |
67 |
0 |
1158965680 |
48897728 |
6983456 |
06:24:33 |
65694 |
8192000000 |
10129889600 |
10579013632 |
1133640608 |
12.156 |
100 |
26 |
44 |
2 |
1200447776 |
61462224 |
5344944 |
06:26:54 |
177478 |
8192000000 |
10094355568 |
10570207232 |
1142904096 |
12.243 |
100 |
15 |
31 |
0 |
1192028752 |
46041040 |
3083616 |
06:30:52 |
36073 |
8192000000 |
10056965936 |
10492796928 |
1105394656 |
11.889 |
97 |
39 |
70 |
1 |
1134317120 |
20650768 |
8271696 |
06:32:31 |
63275 |
8192000000 |
10083709520 |
10566176768 |
1122882064 |
12.054 |
99 |
9 |
18 |
0 |
1162511520 |
37807904 |
1821552 |
06:34:51 |
119741 |
8192000000 |
10071717152 |
10547978240 |
1104932560 |
11.884 |
96 |
34 |
67 |
1 |
1135972688 |
24189840 |
6850288 |
06:37:54 |
7515 |
8192000000 |
10126153984 |
10541420544 |
1135010496 |
12.169 |
99 |
72 |
126 |
4 |
1205641552 |
57239296 |
13391760 |
06:39:02 |
126696 |
8192000000 |
10122348032 |
10581438464 |
1132906672 |
12.149 |
99 |
30 |
60 |
2 |
1228273504 |
87948784 |
7418048 |
06:42:21 |
60836 |
8192000000 |
10089212576 |
10524635136 |
1134546800 |
12.164 |
99 |
52 |
97 |
2 |
1179128352 |
34385856 |
10195696 |
06:44:22 |
40020 |
8192000000 |
10122839712 |
10570063872 |
1134626784 |
12.165 |
100 |
38 |
74 |
0 |
1202168656 |
58980976 |
8560896 |
06:46:03 |
54068 |
8192000000 |
10138361600 |
10599735296 |
1134398656 |
12.163 |
99 |
41 |
81 |
0 |
1234327296 |
91570784 |
8357856 |
06:48:01 |
110122 |
8192000000 |
10104653104 |
10595483648 |
1101813808 |
11.855 |
96 |
11 |
20 |
0 |
1176340448 |
72229200 |
2297440 |
06:50:52 |
65594 |
8192000000 |
10095510928 |
10569211904 |
1129155776 |
12.113 |
99 |
18 |
36 |
0 |
1196945808 |
63809072 |
3980960 |
06:53:17 |
72885 |
8192000000 |
10057021344 |
10536120320 |
1115715376 |
11.986 |
98 |
20 |
39 |
0 |
1155995136 |
36173456 |
4106304 |
06:55:42 |
30204 |
8192000000 |
10073256864 |
10521710592 |
1106565552 |
11.900 |
97 |
10 |
20 |
0 |
1136620320 |
27608256 |
2446512 |
06:57:22 |
13702 |
8192000000 |
10144033360 |
10597093376 |
1141272384 |
12.227 |
100 |
32 |
64 |
0 |
1224827216 |
76906864 |
6647968 |
06:58:43 |
56963 |
8192000000 |
10142036416 |
10618433536 |
1129512880 |
12.117 |
99 |
22 |
42 |
0 |
1242382944 |
108282432 |
4587632 |
07:00:48 |
104374 |
8192000000 |
10086856000 |
10560864256 |
1095676032 |
11.797 |
96 |
15 |
29 |
0 |
1131130400 |
32803792 |
2650576 |
07:03:32 |
37557 |
8192000000 |
10060876672 |
10493292544 |
1118565872 |
12.013 |
98 |
31 |
55 |
1 |
1146632800 |
22429376 |
5637552 |
07:05:11 |
90838 |
8192000000 |
10137949152 |
10600058880 |
1129988640 |
12.121 |
98 |
34 |
68 |
0 |
1193963776 |
57233632 |
6741504 |
07:07:49 |
55901 |
8192000000 |
10178613008 |
10612166656 |
1142950624 |
12.243 |
99 |
36 |
71 |
2 |
1234371184 |
84095632 |
7324928 |
07:09:47 |
90923 |
8192000000 |
10173912512 |
10663940096 |
1132132848 |
12.141 |
99 |
25 |
50 |
0 |
1272759680 |
135429936 |
5196896 |
07:12:32 |
43518 |
8192000000 |
10132251472 |
10563293184 |
1136817664 |
12.186 |
100 |
37 |
73 |
2 |
1213849696 |
69081376 |
7950656 |
07:14:18 |
59503 |
8192000000 |
10086433232 |
10596741120 |
1139715152 |
12.213 |
100 |
12 |
22 |
0 |
1212847616 |
70957184 |
2175280 |
07:16:19 |
37299 |
8192000000 |
10062692192 |
10506883072 |
1070032304 |
11.552 |
94 |
28 |
56 |
0 |
1098657280 |
22514560 |
6110416 |
07:17:57 |
61499 |
8192000000 |
10084004272 |
10547417088 |
1098428624 |
11.823 |
98 |
22 |
44 |
0 |
1159136144 |
56290800 |
4416720 |
07:20:38 |
87951 |
8192000000 |
10065386320 |
10549309440 |
1075765888 |
11.607 |
96 |
26 |
52 |
0 |
1160175184 |
79202704 |
5206592 |
07:23:07 |
15715 |
8192000000 |
10060390336 |
10489171968 |
1111788832 |
11.949 |
100 |
33 |
62 |
0 |
1154119696 |
35983424 |
6347440 |
07:24:23 |
66197 |
8192000000 |
10112831936 |
10552528896 |
1110622656 |
11.938 |
98 |
20 |
40 |
0 |
1185881920 |
70863424 |
4395840 |
07:26:39 |
92045 |
8192000000 |
10110862096 |
10584653824 |
1102243952 |
11.859 |
97 |
14 |
28 |
0 |
1232191040 |
126655136 |
3291952 |
07:29:14 |
77991 |
8192000000 |
10073856672 |
10528260096 |
1113710784 |
11.968 |
98 |
19 |
36 |
0 |
1145000800 |
27631280 |
3658736 |
07:31:36 |
31681 |
8192000000 |
10090002864 |
10548424704 |
1101056512 |
11.848 |
97 |
47 |
93 |
0 |
1175419168 |
65315408 |
9047248 |
07:33:09 |
12459 |
8192000000 |
10134254032 |
10566942720 |
1126853424 |
12.092 |
100 |
65 |
130 |
0 |
1228393984 |
88643984 |
12896576 |
07:34:26 |
24357 |
8192000000 |
10101547792 |
10531598336 |
1133206512 |
12.152 |
100 |
45 |
88 |
0 |
1179829536 |
37948448 |
8674576 |
07:35:52 |
53585 |
8192000000 |
10088997280 |
10553769984 |
1109222752 |
11.925 |
98 |
31 |
62 |
0 |
1192475472 |
77180000 |
6072720 |
07:37:46 |
93601 |
8192000000 |
10073483568 |
10532106240 |
1110359888 |
11.936 |
98 |
22 |
44 |
0 |
1155693888 |
40669312 |
4664688 |
07:40:20 |
37959 |
8192000000 |
10148392800 |
10590810112 |
1112673344 |
11.958 |
98 |
47 |
94 |
0 |
1199126112 |
76983232 |
9469536 |
07:41:59 |
93204 |
8192000000 |
10094936240 |
10539692032 |
1123964752 |
12.064 |
99 |
16 |
29 |
0 |
1149110688 |
22193312 |
2952624 |
07:44:47 |
19905 |
8192000000 |
10065315072 |
10524770304 |
1135682864 |
12.175 |
100 |
40 |
72 |
2 |
1171216192 |
27469936 |
8063392 |
07:46:08 |
52659 |
8192000000 |
10047943536 |
10515222528 |
1090740320 |
11.750 |
96 |
16 |
29 |
3 |
1132194368 |
38166080 |
3287968 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 22-07-2022 07:49:19 to 22-07-2022 07:49:35.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
91 |
v_add_invoice_to_stock |
335544517 |
except |
5 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-07-2022 07:49:36 to 22-07-2022 07:49:38.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 212846
MON$OLDEST_ACTIVE 214058
MON$OLDEST_SNAPSHOT 214058
MON$NEXT_TRANSACTION 214058
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-30 07:30:08.6030 GMT
MON$PAGES 2083744
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
MON$CRYPT_STATE 0
MON$GUID {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID 02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT 767
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.2.2806 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2806 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2806 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2806 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.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 ---
:6:
:7: mscs-test-161.budzdorov.ru Fri Jul 22 07:47:29 2022
:8: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9:
:10:
:11: mscs-test-161.budzdorov.ru Fri Jul 22 07:47:42 2022
:12: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13:
:14:
:15: mscs-test-161.budzdorov.ru Fri Jul 22 07:47:43 2022
:16: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:17:
--- end of diff output ---
22.07.22 07:49:39. There are 3 logs in /var/tmp/logs-oltp40 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-22 07:49:41 |
No severe PSQL-related problems occured |
22.07.22 07:49:42. End of report.