Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.07.2022 22:40
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 | 16148876 kB |
MemAvailable | 31091020 kB |
Buffers | 0 kB |
Cached | 15597972 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 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-22 22:38:21
DTS_END 2022-07-22 22:38:21.8500
FB_GDSCODE -1
FB_MNEMONA
STACK SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/41702
TRN_ID 238130
ATT_ID 654
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: |
9245.02 |
18447 |
1109402 |
customer order: creation |
168.81 |
406 |
20257 |
customer order: refuse |
14.70 |
329 |
1764 |
order to supplier: creation |
45.15 |
1305 |
5418 |
order to supplier: removal |
3.48 |
89586 |
417 |
invoice (draft): creation |
44.91 |
3315 |
5389 |
invoice (draft): removal |
53.92 |
713 |
6470 |
invoice accept: apply |
40.32 |
16630 |
4838 |
invoice accept: cancel |
48.88 |
800 |
5865 |
customer reserve: creation |
3747.38 |
164 |
449685 |
customer reserve: removal |
4783.23 |
51 |
573988 |
realization accept: apply |
82.28 |
171 |
9874 |
realization accept: cancel |
86.22 |
102 |
10346 |
payment from customer: creation |
57.81 |
127 |
6937 |
payment from customer: removal |
5.88 |
78 |
705 |
payment to supplier: creation |
47.92 |
129 |
5750 |
payment to supplier: removal |
3.22 |
58 |
386 |
service: total inventory turnovers |
4.44 |
1150 |
533 |
service: total monetary turnovers |
5.71 |
27 |
685 |
service: aggregate perf. data |
0.76 |
22235 |
91 |
service: refresh index statistics |
0.03 |
231558 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 22-07-2022 22:40:49 to 22-07-2022 22:40:51.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
4035 |
TEST_TIME |
2 |
5212 |
TEST_TIME |
3 |
5286 |
TEST_TIME |
4 |
4788 |
TEST_TIME |
5 |
4809 |
TEST_TIME |
6 |
5206 |
TEST_TIME |
7 |
5053 |
TEST_TIME |
8 |
5248 |
TEST_TIME |
9 |
5291 |
TEST_TIME |
10 |
5671 |
TEST_TIME |
11 |
5658 |
TEST_TIME |
12 |
5696 |
TEST_TIME |
13 |
6635 |
TEST_TIME |
14 |
7597 |
TEST_TIME |
15 |
7839 |
TEST_TIME |
16 |
7841 |
TEST_TIME |
17 |
8170 |
TEST_TIME |
18 |
8748 |
TEST_TIME |
19 |
8903 |
TEST_TIME |
20 |
8778 |
TEST_TIME |
21 |
9543 |
TEST_TIME |
22 |
9702 |
TEST_TIME |
23 |
9453 |
TEST_TIME |
24 |
9718 |
TEST_TIME |
25 |
9922 |
TEST_TIME |
26 |
9985 |
TEST_TIME |
27 |
9789 |
TEST_TIME |
28 |
9943 |
TEST_TIME |
29 |
10171 |
TEST_TIME |
30 |
10034 |
TEST_TIME |
31 |
9955 |
TEST_TIME |
32 |
10123 |
TEST_TIME |
33 |
10056 |
TEST_TIME |
34 |
10062 |
TEST_TIME |
35 |
9999 |
TEST_TIME |
36 |
9938 |
TEST_TIME |
37 |
9857 |
TEST_TIME |
38 |
9886 |
TEST_TIME |
39 |
9656 |
TEST_TIME |
40 |
9665 |
TEST_TIME |
41 |
9539 |
TEST_TIME |
42 |
9581 |
TEST_TIME |
43 |
9653 |
TEST_TIME |
44 |
9557 |
TEST_TIME |
45 |
9415 |
TEST_TIME |
46 |
9378 |
TEST_TIME |
47 |
9254 |
TEST_TIME |
48 |
9112 |
TEST_TIME |
49 |
9218 |
TEST_TIME |
50 |
9298 |
TEST_TIME |
51 |
9296 |
TEST_TIME |
52 |
9270 |
TEST_TIME |
53 |
9253 |
TEST_TIME |
54 |
9204 |
TEST_TIME |
55 |
9210 |
TEST_TIME |
56 |
9252 |
TEST_TIME |
57 |
9372 |
TEST_TIME |
58 |
9307 |
TEST_TIME |
59 |
9414 |
TEST_TIME |
60 |
9385 |
TEST_TIME |
61 |
9508 |
TEST_TIME |
62 |
9562 |
TEST_TIME |
63 |
9476 |
TEST_TIME |
64 |
9513 |
TEST_TIME |
65 |
9636 |
TEST_TIME |
66 |
9695 |
TEST_TIME |
67 |
9571 |
TEST_TIME |
68 |
9484 |
TEST_TIME |
69 |
9422 |
TEST_TIME |
70 |
9408 |
TEST_TIME |
71 |
9416 |
TEST_TIME |
72 |
9360 |
TEST_TIME |
73 |
9316 |
TEST_TIME |
74 |
9324 |
TEST_TIME |
75 |
9247 |
TEST_TIME |
76 |
9183 |
TEST_TIME |
77 |
9199 |
TEST_TIME |
78 |
9159 |
TEST_TIME |
79 |
9180 |
TEST_TIME |
80 |
9153 |
TEST_TIME |
81 |
9184 |
TEST_TIME |
82 |
9196 |
TEST_TIME |
83 |
9281 |
TEST_TIME |
84 |
9255 |
TEST_TIME |
85 |
9209 |
TEST_TIME |
86 |
9280 |
TEST_TIME |
87 |
9354 |
TEST_TIME |
88 |
9400 |
TEST_TIME |
89 |
9462 |
TEST_TIME |
90 |
9435 |
TEST_TIME |
91 |
9440 |
TEST_TIME |
92 |
9368 |
TEST_TIME |
93 |
9297 |
TEST_TIME |
94 |
9368 |
TEST_TIME |
95 |
9311 |
TEST_TIME |
96 |
9273 |
TEST_TIME |
97 |
9227 |
TEST_TIME |
98 |
9165 |
TEST_TIME |
99 |
9254 |
TEST_TIME |
100 |
9251 |
TEST_TIME |
101 |
9211 |
TEST_TIME |
102 |
9190 |
TEST_TIME |
103 |
9266 |
TEST_TIME |
104 |
9265 |
TEST_TIME |
105 |
9298 |
TEST_TIME |
106 |
9310 |
TEST_TIME |
107 |
9337 |
TEST_TIME |
108 |
9343 |
TEST_TIME |
109 |
9327 |
TEST_TIME |
110 |
9385 |
TEST_TIME |
111 |
9413 |
TEST_TIME |
112 |
9506 |
TEST_TIME |
113 |
9490 |
TEST_TIME |
114 |
9444 |
TEST_TIME |
115 |
9415 |
TEST_TIME |
116 |
9387 |
TEST_TIME |
117 |
9350 |
TEST_TIME |
118 |
9309 |
TEST_TIME |
119 |
9268 |
TEST_TIME |
120 |
9247 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 22-07-2022 22:40:52 to 22-07-2022 22:40:56.
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 |
1527405 |
1527405 |
0 |
0.00 |
0 |
61614 |
5 |
0 |
0 |
doc_list_biud |
1527405 |
1527405 |
0 |
0.00 |
0 |
60853 |
25 |
0 |
0 |
sp_add_invoice_to_stock |
4949 |
4838 |
111 |
2.24 |
42 |
147123 |
16630 |
0 |
111 |
sp_cancel_adding_invoice |
5865 |
5865 |
0 |
0.00 |
5 |
82423 |
800 |
0 |
0 |
sp_cancel_client_order |
1764 |
1764 |
0 |
0.00 |
4 |
10041 |
329 |
0 |
0 |
sp_cancel_customer_reserve |
573988 |
573988 |
0 |
0.00 |
0 |
60859 |
52 |
0 |
0 |
sp_cancel_pay_from_customer |
705 |
705 |
0 |
0.00 |
2 |
4763 |
78 |
0 |
0 |
sp_cancel_pay_to_supplier |
386 |
386 |
0 |
0.00 |
3 |
1211 |
58 |
0 |
0 |
sp_cancel_supplier_invoice |
6479 |
6470 |
9 |
0.13 |
2 |
52218 |
713 |
0 |
9 |
sp_cancel_supplier_order |
417 |
417 |
0 |
0.00 |
5 |
820939 |
89586 |
0 |
0 |
sp_cancel_write_off |
10346 |
10346 |
0 |
0.00 |
1 |
9176 |
102 |
0 |
0 |
sp_client_order |
20257 |
20257 |
0 |
0.00 |
3 |
54709 |
406 |
0 |
0 |
sp_customer_reserve |
449685 |
449685 |
0 |
0.00 |
0 |
75498 |
164 |
0 |
0 |
sp_fill_shopping_cart |
31060 |
31060 |
0 |
0.00 |
1 |
14387 |
40 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
449678 |
449678 |
0 |
0.00 |
0 |
18195 |
14 |
0 |
0 |
sp_get_clo_for_invoice |
4830 |
4830 |
0 |
0.00 |
0 |
49328 |
330 |
0 |
0 |
sp_kill_cost_storno |
17302 |
17302 |
0 |
0.00 |
0 |
5487 |
50 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1165209 |
1165209 |
0 |
0.00 |
0 |
60848 |
28 |
0 |
0 |
sp_kill_qty_storno |
613554 |
613554 |
0 |
0.00 |
0 |
60853 |
61 |
0 |
0 |
sp_lock_selected_doc |
20389 |
20389 |
0 |
0.00 |
0 |
8020 |
4 |
0 |
0 |
sp_make_cost_storno |
27391 |
27391 |
0 |
0.00 |
0 |
61592 |
52 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27391 |
27391 |
0 |
0.00 |
0 |
8400 |
25 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20257 |
20257 |
0 |
0.00 |
0 |
53754 |
168 |
0 |
0 |
sp_pay_from_customer |
6937 |
6937 |
0 |
0.00 |
4 |
41201 |
127 |
0 |
0 |
sp_pay_to_supplier |
5750 |
5750 |
0 |
0.00 |
4 |
24252 |
129 |
0 |
0 |
sp_payment_common |
12687 |
12687 |
0 |
0.00 |
1 |
41193 |
39 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1764 |
1764 |
0 |
0.00 |
0 |
10035 |
300 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10695 |
10695 |
0 |
0.00 |
0 |
26655 |
314 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9874 |
9874 |
0 |
0.00 |
0 |
16728 |
60 |
0 |
0 |
sp_reserve_write_off |
9874 |
9874 |
0 |
0.00 |
6 |
18781 |
172 |
0 |
0 |
sp_supplier_invoice |
5389 |
5389 |
0 |
0.00 |
6 |
75991 |
3316 |
0 |
0 |
sp_supplier_order |
5418 |
5418 |
0 |
0.00 |
5 |
62852 |
1305 |
0 |
0 |
srv_aggregate_perf_data |
91 |
91 |
0 |
0.00 |
2578 |
388322 |
22235 |
0 |
0 |
srv_fill_mon_cache_memory |
61 |
61 |
0 |
0.00 |
1724 |
138045 |
47976 |
0 |
0 |
srv_find_qd_qs_mism |
1063595 |
1063595 |
0 |
0.00 |
0 |
13219 |
5 |
0 |
0 |
srv_make_invnt_saldo |
533 |
533 |
0 |
0.00 |
39 |
53659 |
1151 |
0 |
0 |
srv_make_money_saldo |
685 |
685 |
0 |
0.00 |
1 |
2791 |
28 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
147843 |
402177 |
231558 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
111 |
111 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
9 |
9 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4839 |
4839 |
0 |
0.00 |
0 |
9646 |
166 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
431 |
431 |
0 |
0.00 |
0 |
8697 |
140 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1764 |
1764 |
0 |
0.00 |
0 |
9108 |
24 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
663 |
663 |
0 |
0.00 |
0 |
1047 |
10 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
705 |
705 |
0 |
0.00 |
0 |
833 |
3 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
386 |
386 |
0 |
0.00 |
0 |
774 |
4 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
391 |
391 |
0 |
0.00 |
0 |
3372 |
17 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
417 |
417 |
0 |
0.00 |
0 |
31872 |
1738 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
930 |
930 |
0 |
0.00 |
0 |
3084 |
12 |
0 |
0 |
t$perf-norm:sp_client_order |
20257 |
20257 |
0 |
0.00 |
0 |
38405 |
20 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
1021 |
1021 |
0 |
0.00 |
0 |
2406 |
8 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6937 |
6937 |
0 |
0.00 |
0 |
6525 |
10 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5750 |
5750 |
0 |
0.00 |
0 |
5936 |
11 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9874 |
9874 |
0 |
0.00 |
0 |
9407 |
14 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5389 |
5389 |
0 |
0.00 |
0 |
8081 |
20 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5418 |
5418 |
0 |
0.00 |
0 |
15628 |
17 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
91 |
91 |
0 |
0.00 |
0 |
103 |
3 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
61 |
61 |
0 |
0.00 |
0 |
788 |
28 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
533 |
533 |
0 |
0.00 |
0 |
639 |
17 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
685 |
685 |
0 |
0.00 |
0 |
8252 |
34 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
1 |
24 |
7 |
0 |
0 |
v_add_invoice_to_stock |
9878 |
9656 |
222 |
2.24 |
0 |
5824 |
18 |
0 |
222 |
v_all_customers |
37018 |
37018 |
0 |
0.00 |
0 |
33 |
0 |
0 |
0 |
v_all_suppliers |
30096 |
30096 |
0 |
0.00 |
0 |
19 |
1 |
0 |
0 |
v_all_wares |
40512 |
40512 |
0 |
0.00 |
0 |
19 |
1 |
0 |
0 |
v_cancel_adding_invoice |
862 |
862 |
0 |
0.00 |
0 |
2396 |
9 |
0 |
0 |
v_cancel_client_order |
3528 |
3528 |
0 |
0.00 |
0 |
3300 |
5 |
0 |
0 |
v_cancel_customer_prepayment |
1410 |
1410 |
0 |
0.00 |
0 |
2633 |
8 |
0 |
0 |
v_cancel_customer_reserve |
1326 |
1326 |
0 |
0.00 |
0 |
2914 |
10 |
0 |
0 |
v_cancel_payment_to_supplier |
772 |
772 |
0 |
0.00 |
0 |
1077 |
6 |
0 |
0 |
v_cancel_supplier_invoice |
800 |
782 |
18 |
2.25 |
0 |
2396 |
24 |
0 |
18 |
v_cancel_supplier_order |
834 |
834 |
0 |
0.00 |
0 |
1726 |
8 |
0 |
0 |
v_cancel_write_off |
1860 |
1860 |
0 |
0.00 |
0 |
5455 |
18 |
0 |
0 |
v_max_id_clo_ord |
5418 |
5418 |
0 |
0.00 |
0 |
280 |
1 |
0 |
0 |
v_max_id_clo_res |
1021 |
1021 |
0 |
0.00 |
0 |
3899 |
14 |
0 |
0 |
v_max_id_ord_sup |
5386 |
5386 |
0 |
0.00 |
0 |
3656 |
5 |
0 |
0 |
v_max_non_paid_invoice |
1506 |
1506 |
0 |
0.00 |
0 |
3306 |
4 |
0 |
0 |
v_max_non_paid_realizn |
3679 |
3679 |
0 |
0.00 |
0 |
6069 |
6 |
0 |
0 |
v_min_id_clo_ord |
5418 |
5418 |
0 |
0.00 |
0 |
3162 |
6 |
0 |
0 |
v_min_id_clo_res |
1021 |
1021 |
0 |
0.00 |
0 |
2305 |
6 |
0 |
0 |
v_min_id_ord_sup |
5386 |
5386 |
0 |
0.00 |
0 |
3289 |
7 |
0 |
0 |
v_min_non_paid_invoice |
5750 |
5750 |
0 |
0.00 |
0 |
15778 |
21 |
0 |
0 |
v_min_non_paid_realizn |
6937 |
6937 |
0 |
0.00 |
0 |
41189 |
38 |
0 |
0 |
v_our_firm |
10010 |
10010 |
0 |
0.00 |
0 |
50 |
1 |
0 |
0 |
v_reserve_write_off |
19748 |
19748 |
0 |
0.00 |
0 |
5326 |
7 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
11944 |
11944 |
0 |
0.00 |
0 |
14925 |
98 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
417 |
417 |
0 |
0.00 |
0 |
12350 |
395 |
0 |
0 |
x_make_qstorno_1000_1200 |
5418 |
5418 |
0 |
0.00 |
1 |
58702 |
1235 |
0 |
0 |
x_make_qstorno_1200_2000 |
5389 |
5389 |
0 |
0.00 |
2 |
75977 |
3162 |
0 |
0 |
x_make_qstorno_2100_3300 |
449685 |
449685 |
0 |
0.00 |
0 |
75497 |
148 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:05, from 22-07-2022 22:40:56 to 22-07-2022 22:41:01.
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:25 |
3 |
8192000000 |
8797116400 |
8807743488 |
3955424 |
0.048 |
1 |
1 |
2 |
0 |
4053696 |
55488 |
42784 |
20:09:26 |
19791 |
8192000000 |
9902687840 |
10213142528 |
985446176 |
10.737 |
100 |
87 |
174 |
0 |
1014254128 |
5996704 |
22811248 |
20:10:50 |
23472 |
8192000000 |
9943905824 |
10264309760 |
1019103520 |
11.063 |
100 |
87 |
172 |
1 |
1049728800 |
8365168 |
22260112 |
20:12:18 |
19678 |
8192000000 |
9982848928 |
10311254016 |
1058678880 |
11.444 |
100 |
87 |
174 |
0 |
1090313696 |
9583104 |
22051712 |
20:13:42 |
12557 |
8192000000 |
10019328576 |
10365816832 |
1111816800 |
11.950 |
100 |
72 |
144 |
0 |
1140019600 |
11002288 |
17200512 |
20:15:08 |
7222 |
8192000000 |
10082477072 |
10442252288 |
1173862576 |
12.533 |
100 |
79 |
159 |
0 |
1205093136 |
12879792 |
18350768 |
20:16:17 |
3317 |
8192000000 |
10128492816 |
10495852544 |
1215066608 |
12.916 |
100 |
75 |
150 |
0 |
1244516176 |
12695424 |
16754144 |
20:17:25 |
2294 |
8192000000 |
10166605232 |
10541211648 |
1243754320 |
13.181 |
100 |
75 |
147 |
0 |
1273399616 |
13674208 |
15971088 |
20:18:29 |
1740 |
8192000000 |
10200681280 |
10578653184 |
1282148800 |
13.533 |
100 |
93 |
186 |
0 |
1317312512 |
14492048 |
20671664 |
20:19:33 |
3111 |
8192000000 |
10212595280 |
10597941248 |
1300206000 |
13.697 |
100 |
86 |
170 |
1 |
1333874000 |
15418848 |
18249152 |
20:20:37 |
3394 |
8192000000 |
10198285264 |
10601955328 |
1306420400 |
13.754 |
100 |
44 |
86 |
0 |
1323447136 |
7620320 |
9406416 |
20:21:42 |
6581 |
8192000000 |
10206105824 |
10617344000 |
1317852960 |
13.857 |
100 |
23 |
46 |
0 |
1330291504 |
7611808 |
4826736 |
20:22:48 |
5707 |
8192000000 |
10211160848 |
10626174976 |
1326379440 |
13.934 |
100 |
16 |
30 |
0 |
1335725296 |
5991312 |
3354544 |
20:23:56 |
51870 |
8192000000 |
10216633968 |
10640408576 |
1329001920 |
13.958 |
100 |
22 |
42 |
1 |
1339263184 |
5422832 |
4838432 |
20:25:51 |
5325 |
8192000000 |
10226003776 |
10648383488 |
1339276560 |
14.051 |
100 |
26 |
50 |
0 |
1351048032 |
5828432 |
5943040 |
20:27:00 |
9277 |
8192000000 |
10233496016 |
10652463104 |
1326116128 |
13.932 |
99 |
16 |
30 |
0 |
1334852928 |
5020160 |
3716640 |
20:28:10 |
59717 |
8192000000 |
10192419472 |
10607427584 |
1276957568 |
13.485 |
97 |
34 |
67 |
0 |
1290279776 |
5026848 |
8295360 |
20:30:10 |
3194 |
8192000000 |
10174845616 |
10579812352 |
1282714592 |
13.538 |
100 |
25 |
50 |
0 |
1294704464 |
6455136 |
5534736 |
20:31:13 |
7867 |
8192000000 |
10133257824 |
10527223808 |
1215386400 |
12.919 |
97 |
17 |
34 |
0 |
1224241712 |
5024736 |
3830576 |
20:32:26 |
58045 |
8192000000 |
10141826992 |
10547806208 |
1237696112 |
13.125 |
98 |
32 |
64 |
0 |
1250955840 |
5648352 |
7611376 |
20:34:25 |
5815 |
8192000000 |
10173578480 |
10581897216 |
1283669648 |
13.547 |
100 |
32 |
62 |
1 |
1296811360 |
6110528 |
7031184 |
20:35:32 |
9561 |
8192000000 |
10194901360 |
10607235072 |
1300177632 |
13.697 |
100 |
16 |
32 |
0 |
1309756848 |
5534208 |
4045008 |
20:36:43 |
16564 |
8192000000 |
10196651408 |
10614149120 |
1313859456 |
13.821 |
100 |
26 |
52 |
1 |
1325243792 |
5678624 |
5705712 |
20:38:02 |
7589 |
8192000000 |
10206200080 |
10628440064 |
1320356112 |
13.880 |
100 |
21 |
42 |
0 |
1330258384 |
5343088 |
4559184 |
20:39:16 |
8310 |
8192000000 |
10252890960 |
10663841792 |
1338582704 |
14.045 |
100 |
44 |
88 |
0 |
1357601376 |
8919568 |
10099104 |
20:40:30 |
2489 |
8192000000 |
10277436192 |
10691145728 |
1367264432 |
14.303 |
100 |
68 |
134 |
0 |
1394330080 |
11516928 |
15548720 |
20:41:36 |
17494 |
8192000000 |
10285308000 |
10709598208 |
1381712432 |
14.432 |
100 |
46 |
92 |
0 |
1406725952 |
14312976 |
10700544 |
20:43:06 |
18002 |
8192000000 |
10303461872 |
10729934848 |
1397195168 |
14.570 |
100 |
39 |
78 |
0 |
1423377408 |
16699408 |
9482832 |
20:44:44 |
30544 |
8192000000 |
10304500688 |
10737426432 |
1388230416 |
14.490 |
99 |
28 |
56 |
0 |
1412173936 |
16865616 |
7077904 |
20:46:18 |
18566 |
8192000000 |
10325284304 |
10753626112 |
1404689536 |
14.637 |
100 |
44 |
86 |
0 |
1439786480 |
25398576 |
9698368 |
20:47:41 |
7983 |
8192000000 |
10326761648 |
10747060224 |
1392081280 |
14.524 |
99 |
43 |
84 |
1 |
1428843984 |
25802560 |
10960144 |
20:48:54 |
5416 |
8192000000 |
10328713984 |
10749792256 |
1400600304 |
14.600 |
100 |
58 |
115 |
2 |
1444429456 |
29665696 |
14163456 |
20:50:03 |
8546 |
8192000000 |
10333188768 |
10755088384 |
1398698016 |
14.583 |
100 |
57 |
114 |
1 |
1447270224 |
33716960 |
14855248 |
20:51:25 |
5388 |
8192000000 |
10328954880 |
10747830272 |
1383960528 |
14.452 |
100 |
66 |
130 |
0 |
1440013616 |
38985792 |
17067296 |
20:52:39 |
1724 |
8192000000 |
10337149088 |
10754654208 |
1393352752 |
14.536 |
100 |
63 |
126 |
2 |
1441745232 |
32278496 |
16113984 |
20:53:46 |
13181 |
8192000000 |
10305125792 |
10736451584 |
1368670832 |
14.315 |
99 |
45 |
91 |
0 |
1407978880 |
28027024 |
11281024 |
20:55:16 |
27713 |
8192000000 |
10298371552 |
10724782080 |
1352709296 |
14.172 |
98 |
32 |
62 |
1 |
1393698096 |
32329936 |
8658864 |
20:56:49 |
22649 |
8192000000 |
10282432688 |
10722123776 |
1328897808 |
13.957 |
96 |
30 |
60 |
1 |
1373600016 |
36398496 |
8303712 |
20:58:16 |
6456 |
8192000000 |
10249660288 |
10669105152 |
1301934800 |
13.713 |
98 |
29 |
56 |
1 |
1339846640 |
30455136 |
7456704 |
20:59:31 |
5619 |
8192000000 |
10302149808 |
10715877376 |
1348795344 |
14.137 |
100 |
58 |
116 |
1 |
1406440000 |
43296352 |
14348304 |
21:00:39 |
24441 |
8192000000 |
10264611616 |
10681757696 |
1316406656 |
13.844 |
98 |
31 |
63 |
0 |
1348171520 |
23288768 |
8476096 |
21:02:18 |
21091 |
8192000000 |
10272757136 |
10709839872 |
1344456832 |
14.098 |
100 |
24 |
48 |
0 |
1384240480 |
33263312 |
6520336 |
21:03:46 |
29487 |
8192000000 |
10265699280 |
10692370432 |
1342348448 |
14.079 |
99 |
24 |
48 |
0 |
1381776800 |
33215424 |
6212928 |
21:05:26 |
20252 |
8192000000 |
10265851584 |
10696290304 |
1334648576 |
14.009 |
99 |
22 |
44 |
1 |
1368038144 |
27692160 |
5697408 |
21:06:48 |
25516 |
8192000000 |
10258267376 |
10686685184 |
1317529488 |
13.854 |
98 |
17 |
33 |
0 |
1349632528 |
27732464 |
4370576 |
21:08:30 |
52175 |
8192000000 |
10290734640 |
10721611776 |
1369752464 |
14.325 |
100 |
36 |
73 |
0 |
1399985760 |
21859536 |
8373760 |
21:10:28 |
62722 |
8192000000 |
10268104816 |
10722140160 |
1356309824 |
14.204 |
99 |
18 |
36 |
0 |
1377337552 |
16800992 |
4226736 |
21:13:35 |
138044 |
8192000000 |
10281239872 |
10727018496 |
1354206272 |
14.185 |
98 |
24 |
46 |
0 |
1367671168 |
8301552 |
5163344 |
21:18:02 |
82323 |
8192000000 |
10297118176 |
10746589184 |
1390410336 |
14.510 |
100 |
28 |
54 |
0 |
1405181376 |
8719968 |
6051072 |
21:20:29 |
30339 |
8192000000 |
10295656944 |
10749399040 |
1392555776 |
14.529 |
100 |
25 |
50 |
0 |
1411962224 |
12848736 |
6557712 |
21:22:56 |
116446 |
8192000000 |
10298651648 |
10755141632 |
1386954080 |
14.479 |
99 |
10 |
20 |
0 |
1400299440 |
10905808 |
2439552 |
21:26:04 |
79202 |
8192000000 |
10320447504 |
10771243008 |
1406358224 |
14.652 |
100 |
28 |
56 |
0 |
1429112656 |
16329680 |
6424752 |
21:28:23 |
64170 |
8192000000 |
10297295776 |
10767728640 |
1402278688 |
14.615 |
100 |
16 |
32 |
0 |
1421243856 |
15471200 |
3493968 |
21:30:39 |
98140 |
8192000000 |
10285860528 |
10735747072 |
1321507120 |
13.890 |
94 |
12 |
24 |
0 |
1332398480 |
8313040 |
2578320 |
21:33:19 |
62533 |
8192000000 |
10297430656 |
10746290176 |
1363877216 |
14.272 |
97 |
19 |
36 |
0 |
1381696512 |
13404128 |
4415168 |
21:35:22 |
80203 |
8192000000 |
10306061328 |
10754215936 |
1353793440 |
14.182 |
97 |
12 |
24 |
0 |
1367961392 |
11388912 |
2779040 |
21:37:43 |
82007 |
8192000000 |
10306618592 |
10753675264 |
1344825856 |
14.101 |
96 |
19 |
38 |
0 |
1367527664 |
18494048 |
4207760 |
21:40:07 |
60018 |
8192000000 |
10284104640 |
10736984064 |
1353089600 |
14.175 |
98 |
11 |
20 |
1 |
1367710912 |
12482480 |
2138832 |
21:42:07 |
33392 |
8192000000 |
10304362192 |
10737594368 |
1369084016 |
14.319 |
99 |
38 |
77 |
1 |
1387399824 |
10214960 |
8100848 |
21:43:42 |
103398 |
8192000000 |
10276594512 |
10729226240 |
1305114000 |
13.742 |
94 |
8 |
16 |
0 |
1319534624 |
12460048 |
1960576 |
21:47:26 |
49811 |
8192000000 |
10276070336 |
10727874560 |
1371567184 |
14.341 |
99 |
29 |
56 |
0 |
1386709120 |
9175776 |
5966160 |
21:49:19 |
60667 |
8192000000 |
10258688864 |
10716606464 |
1337426800 |
14.034 |
97 |
13 |
26 |
0 |
1349690208 |
9215008 |
3048400 |
21:51:26 |
71496 |
8192000000 |
10252613568 |
10704990208 |
1288031232 |
13.586 |
94 |
15 |
31 |
1 |
1300845152 |
9069712 |
3744208 |
21:53:46 |
82999 |
8192000000 |
10224672704 |
10671218688 |
1281081808 |
13.523 |
94 |
14 |
26 |
1 |
1300804160 |
16757360 |
2964992 |
21:56:21 |
65066 |
8192000000 |
10244913168 |
10698256384 |
1333139408 |
13.996 |
99 |
17 |
34 |
0 |
1349583664 |
12995056 |
3449200 |
21:58:26 |
46847 |
8192000000 |
10260428016 |
10702995456 |
1352537856 |
14.170 |
100 |
21 |
42 |
0 |
1368429952 |
11042272 |
4849824 |
22:00:14 |
26205 |
8192000000 |
10255211616 |
10699808768 |
1318202384 |
13.860 |
97 |
23 |
46 |
0 |
1336622224 |
13308064 |
5111776 |
22:01:57 |
31006 |
8192000000 |
10267152112 |
10706427904 |
1334614080 |
14.009 |
98 |
22 |
44 |
0 |
1349522224 |
9650160 |
5257984 |
22:03:28 |
13362 |
8192000000 |
10289630592 |
10720063488 |
1364594640 |
14.279 |
100 |
47 |
94 |
0 |
1390780112 |
15560256 |
10625216 |
22:04:44 |
72910 |
8192000000 |
10294311168 |
10742489088 |
1354999648 |
14.192 |
99 |
13 |
26 |
0 |
1376916576 |
18739296 |
3177632 |
22:07:07 |
81226 |
8192000000 |
10288181616 |
10728116224 |
1342518880 |
14.080 |
98 |
16 |
31 |
0 |
1356760752 |
11230160 |
3011712 |
22:09:28 |
59694 |
8192000000 |
10298624736 |
10749816832 |
1392908912 |
14.532 |
100 |
22 |
44 |
0 |
1411885120 |
14404464 |
4571744 |
22:11:43 |
16005 |
8192000000 |
10290218432 |
10734497792 |
1380077680 |
14.417 |
100 |
34 |
69 |
1 |
1402468560 |
14659792 |
7731088 |
22:12:59 |
36562 |
8192000000 |
10285707872 |
10740723712 |
1389243584 |
14.499 |
100 |
14 |
28 |
3 |
1400673776 |
8449104 |
2981088 |
22:14:37 |
58667 |
8192000000 |
10286249728 |
10745298944 |
1381620944 |
14.431 |
99 |
11 |
22 |
1 |
1397956880 |
13650016 |
2685920 |
22:16:36 |
68734 |
8192000000 |
10298673872 |
10763620352 |
1390890320 |
14.514 |
100 |
19 |
38 |
0 |
1415391296 |
20010752 |
4490224 |
22:18:51 |
91958 |
8192000000 |
10291752992 |
10740555776 |
1361202176 |
14.248 |
97 |
14 |
28 |
0 |
1378438992 |
14119904 |
3116912 |
22:21:25 |
30367 |
8192000000 |
10297711392 |
10741817344 |
1363833584 |
14.272 |
98 |
24 |
48 |
0 |
1378648880 |
9573104 |
5242192 |
22:23:02 |
52782 |
8192000000 |
10286401952 |
10740482048 |
1374650000 |
14.369 |
99 |
19 |
38 |
0 |
1390243216 |
11417072 |
4176144 |
22:24:57 |
65376 |
8192000000 |
10282893392 |
10725138432 |
1319239392 |
13.870 |
95 |
21 |
42 |
0 |
1331697344 |
8201472 |
4256480 |
22:27:07 |
55317 |
8192000000 |
10270032544 |
10708463616 |
1306299184 |
13.752 |
95 |
20 |
40 |
0 |
1322724080 |
12064048 |
4360848 |
22:29:06 |
77330 |
8192000000 |
10283243504 |
10761195520 |
1346942608 |
14.120 |
98 |
10 |
20 |
0 |
1373091408 |
23912576 |
2236224 |
22:31:23 |
126022 |
8192000000 |
10269593744 |
10718535680 |
1330150112 |
13.969 |
97 |
12 |
24 |
0 |
1348125632 |
15210240 |
2765280 |
22:34:29 |
58640 |
8192000000 |
10265714448 |
10720727040 |
1345225856 |
14.105 |
98 |
11 |
22 |
0 |
1366032688 |
17975328 |
2831504 |
22:36:37 |
61490 |
8192000000 |
10276434864 |
10732294144 |
1355494480 |
14.197 |
98 |
17 |
34 |
0 |
1371348976 |
11972352 |
3882144 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 22-07-2022 22:41:02 to 22-07-2022 22:41:17.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
111 |
v_add_invoice_to_stock |
335544517 |
except |
9 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-07-2022 22:41:18 to 22-07-2022 22:41:20.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 236167
MON$OLDEST_ACTIVE 238299
MON$OLDEST_SNAPSHOT 238299
MON$NEXT_TRANSACTION 238299
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 2024928
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.33612 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33612 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33612 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33612 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 ---
:32:
:33: mscs-test-161.budzdorov.ru Fri Jul 22 22:38:47 2022
:34: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35:
:36:
:37: mscs-test-161.budzdorov.ru Fri Jul 22 22:38:47 2022
:38: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39:
:40:
:41: mscs-test-161.budzdorov.ru Fri Jul 22 22:38:47 2022
:42: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43:
:44:
:45: mscs-test-161.budzdorov.ru Fri Jul 22 22:38:47 2022
:46: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47:
--- end of diff output ---
22.07.22 22:41:21. 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-22 22:41:23 |
No severe PSQL-related problems occured |
22.07.22 22:41:25. End of report.