Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.01.2023 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 | 15389688 kB |
MemAvailable | 30389320 kB |
Buffers | 0 kB |
Cached | 16303808 kB |
SwapCached | 2276 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 2023-01-15 22:38:33
DTS_END 2023-01-15 22:38:33.8420
FB_GDSCODE -1
FB_MNEMONA
STACK SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/35116
TRN_ID 234160
ATT_ID 681
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: |
9379.12 |
19503 |
1125494 |
customer order: creation |
167.43 |
348 |
20091 |
customer order: refuse |
13.89 |
352 |
1667 |
order to supplier: creation |
45.16 |
1233 |
5419 |
order to supplier: removal |
3.50 |
105156 |
420 |
invoice (draft): creation |
43.99 |
3470 |
5279 |
invoice (draft): removal |
55.01 |
825 |
6601 |
invoice accept: apply |
41.57 |
18307 |
4988 |
invoice accept: cancel |
50.18 |
813 |
6022 |
customer reserve: creation |
3764.62 |
184 |
451754 |
customer reserve: removal |
4895.01 |
58 |
587401 |
realization accept: apply |
81.80 |
182 |
9816 |
realization accept: cancel |
88.60 |
113 |
10632 |
payment from customer: creation |
59.08 |
111 |
7089 |
payment from customer: removal |
5.74 |
86 |
689 |
payment to supplier: creation |
48.85 |
132 |
5862 |
payment to supplier: removal |
3.18 |
109 |
382 |
service: total inventory turnovers |
4.76 |
1113 |
571 |
service: total monetary turnovers |
5.93 |
38 |
712 |
service: aggregate perf. data |
0.79 |
22147 |
95 |
service: refresh index statistics |
0.03 |
235280 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 15-01-2023 22:39:26 to 15-01-2023 22:39:28.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
6695 |
TEST_TIME |
2 |
5837 |
TEST_TIME |
3 |
5766 |
TEST_TIME |
4 |
6713 |
TEST_TIME |
5 |
6645 |
TEST_TIME |
6 |
6639 |
TEST_TIME |
7 |
6497 |
TEST_TIME |
8 |
7090 |
TEST_TIME |
9 |
6945 |
TEST_TIME |
10 |
6944 |
TEST_TIME |
11 |
6792 |
TEST_TIME |
12 |
6923 |
TEST_TIME |
13 |
7233 |
TEST_TIME |
14 |
7308 |
TEST_TIME |
15 |
7431 |
TEST_TIME |
16 |
7536 |
TEST_TIME |
17 |
7813 |
TEST_TIME |
18 |
7892 |
TEST_TIME |
19 |
7841 |
TEST_TIME |
20 |
7855 |
TEST_TIME |
21 |
7894 |
TEST_TIME |
22 |
7839 |
TEST_TIME |
23 |
7904 |
TEST_TIME |
24 |
8457 |
TEST_TIME |
25 |
8627 |
TEST_TIME |
26 |
8605 |
TEST_TIME |
27 |
8948 |
TEST_TIME |
28 |
9303 |
TEST_TIME |
29 |
10235 |
TEST_TIME |
30 |
10838 |
TEST_TIME |
31 |
10639 |
TEST_TIME |
32 |
10444 |
TEST_TIME |
33 |
10235 |
TEST_TIME |
34 |
10225 |
TEST_TIME |
35 |
10144 |
TEST_TIME |
36 |
10100 |
TEST_TIME |
37 |
10056 |
TEST_TIME |
38 |
10009 |
TEST_TIME |
39 |
9973 |
TEST_TIME |
40 |
9843 |
TEST_TIME |
41 |
9800 |
TEST_TIME |
42 |
9685 |
TEST_TIME |
43 |
9743 |
TEST_TIME |
44 |
9742 |
TEST_TIME |
45 |
9697 |
TEST_TIME |
46 |
9564 |
TEST_TIME |
47 |
9560 |
TEST_TIME |
48 |
9479 |
TEST_TIME |
49 |
9457 |
TEST_TIME |
50 |
9365 |
TEST_TIME |
51 |
9313 |
TEST_TIME |
52 |
9284 |
TEST_TIME |
53 |
9343 |
TEST_TIME |
54 |
9181 |
TEST_TIME |
55 |
9254 |
TEST_TIME |
56 |
9204 |
TEST_TIME |
57 |
9144 |
TEST_TIME |
58 |
9130 |
TEST_TIME |
59 |
9124 |
TEST_TIME |
60 |
9119 |
TEST_TIME |
61 |
9095 |
TEST_TIME |
62 |
9227 |
TEST_TIME |
63 |
9162 |
TEST_TIME |
64 |
9236 |
TEST_TIME |
65 |
9332 |
TEST_TIME |
66 |
9307 |
TEST_TIME |
67 |
9300 |
TEST_TIME |
68 |
9440 |
TEST_TIME |
69 |
9372 |
TEST_TIME |
70 |
9587 |
TEST_TIME |
71 |
9575 |
TEST_TIME |
72 |
9645 |
TEST_TIME |
73 |
9638 |
TEST_TIME |
74 |
9552 |
TEST_TIME |
75 |
9482 |
TEST_TIME |
76 |
9451 |
TEST_TIME |
77 |
9409 |
TEST_TIME |
78 |
9454 |
TEST_TIME |
79 |
9387 |
TEST_TIME |
80 |
9333 |
TEST_TIME |
81 |
9309 |
TEST_TIME |
82 |
9247 |
TEST_TIME |
83 |
9212 |
TEST_TIME |
84 |
9200 |
TEST_TIME |
85 |
9315 |
TEST_TIME |
86 |
9296 |
TEST_TIME |
87 |
9269 |
TEST_TIME |
88 |
9306 |
TEST_TIME |
89 |
9259 |
TEST_TIME |
90 |
9308 |
TEST_TIME |
91 |
9353 |
TEST_TIME |
92 |
9329 |
TEST_TIME |
93 |
9378 |
TEST_TIME |
94 |
9465 |
TEST_TIME |
95 |
9462 |
TEST_TIME |
96 |
9534 |
TEST_TIME |
97 |
9544 |
TEST_TIME |
98 |
9497 |
TEST_TIME |
99 |
9477 |
TEST_TIME |
100 |
9456 |
TEST_TIME |
101 |
9416 |
TEST_TIME |
102 |
9431 |
TEST_TIME |
103 |
9402 |
TEST_TIME |
104 |
9391 |
TEST_TIME |
105 |
9372 |
TEST_TIME |
106 |
9321 |
TEST_TIME |
107 |
9320 |
TEST_TIME |
108 |
9277 |
TEST_TIME |
109 |
9248 |
TEST_TIME |
110 |
9208 |
TEST_TIME |
111 |
9255 |
TEST_TIME |
112 |
9257 |
TEST_TIME |
113 |
9236 |
TEST_TIME |
114 |
9270 |
TEST_TIME |
115 |
9335 |
TEST_TIME |
116 |
9311 |
TEST_TIME |
117 |
9300 |
TEST_TIME |
118 |
9383 |
TEST_TIME |
119 |
9395 |
TEST_TIME |
120 |
9385 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 15-01-2023 22:39:29 to 15-01-2023 22:39:33.
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 |
1544583 |
1544583 |
0 |
0.00 |
0 |
21975 |
6 |
0 |
0 |
doc_list_biud |
1544581 |
1544581 |
0 |
0.00 |
0 |
42325 |
28 |
0 |
0 |
sp_add_invoice_to_stock |
5104 |
4988 |
116 |
2.27 |
37 |
158850 |
18308 |
0 |
116 |
sp_cancel_adding_invoice |
6022 |
6022 |
0 |
0.00 |
4 |
62020 |
813 |
0 |
0 |
sp_cancel_client_order |
1667 |
1667 |
0 |
0.00 |
4 |
11055 |
353 |
0 |
0 |
sp_cancel_customer_reserve |
587401 |
587401 |
0 |
0.00 |
0 |
24676 |
59 |
0 |
0 |
sp_cancel_pay_from_customer |
689 |
689 |
0 |
0.00 |
2 |
5005 |
86 |
0 |
0 |
sp_cancel_pay_to_supplier |
382 |
382 |
0 |
0.00 |
3 |
8895 |
110 |
0 |
0 |
sp_cancel_supplier_invoice |
6612 |
6601 |
11 |
0.16 |
2 |
42386 |
826 |
0 |
11 |
sp_cancel_supplier_order |
420 |
420 |
0 |
0.00 |
9 |
1097907 |
105156 |
0 |
0 |
sp_cancel_write_off |
10632 |
10632 |
0 |
0.00 |
1 |
13496 |
114 |
0 |
0 |
sp_client_order |
20091 |
20091 |
0 |
0.00 |
3 |
26466 |
348 |
0 |
0 |
sp_customer_reserve |
451754 |
451754 |
0 |
0.00 |
0 |
38732 |
185 |
0 |
0 |
sp_fill_shopping_cart |
30783 |
30783 |
0 |
0.00 |
1 |
26654 |
45 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
451743 |
451743 |
0 |
0.00 |
0 |
18000 |
13 |
0 |
0 |
sp_get_clo_for_invoice |
4976 |
4976 |
0 |
0.00 |
0 |
30090 |
329 |
0 |
0 |
sp_kill_cost_storno |
17725 |
17725 |
0 |
0.00 |
0 |
11951 |
55 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1192455 |
1192455 |
0 |
0.00 |
0 |
42323 |
32 |
0 |
0 |
sp_kill_qty_storno |
627535 |
627535 |
0 |
0.00 |
0 |
42323 |
69 |
0 |
0 |
sp_lock_selected_doc |
20399 |
20399 |
0 |
0.00 |
0 |
8181 |
5 |
0 |
0 |
sp_make_cost_storno |
27743 |
27743 |
0 |
0.00 |
0 |
21972 |
51 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27743 |
27743 |
0 |
0.00 |
0 |
8298 |
29 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20091 |
20091 |
0 |
0.00 |
0 |
10640 |
156 |
0 |
0 |
sp_pay_from_customer |
7089 |
7089 |
0 |
0.00 |
4 |
10195 |
112 |
0 |
0 |
sp_pay_to_supplier |
5862 |
5862 |
0 |
0.00 |
4 |
21980 |
132 |
0 |
0 |
sp_payment_common |
12951 |
12951 |
0 |
0.00 |
1 |
8496 |
31 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1667 |
1667 |
0 |
0.00 |
0 |
11048 |
327 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10998 |
10998 |
0 |
0.00 |
0 |
20353 |
319 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9816 |
9816 |
0 |
0.00 |
0 |
26819 |
66 |
0 |
0 |
sp_reserve_write_off |
9816 |
9816 |
0 |
0.00 |
6 |
26858 |
183 |
0 |
0 |
sp_supplier_invoice |
5279 |
5279 |
0 |
0.00 |
6 |
97418 |
3471 |
0 |
0 |
sp_supplier_order |
5419 |
5419 |
0 |
0.00 |
4 |
89848 |
1233 |
0 |
0 |
srv_aggregate_perf_data |
95 |
95 |
0 |
0.00 |
2956 |
224750 |
22147 |
0 |
0 |
srv_fill_mon_cache_memory |
66 |
66 |
0 |
0.00 |
1855 |
134009 |
42425 |
0 |
0 |
srv_find_qd_qs_mism |
1079053 |
1079053 |
0 |
0.00 |
0 |
16319 |
5 |
0 |
0 |
srv_make_invnt_saldo |
571 |
571 |
0 |
0.00 |
35 |
35900 |
1113 |
0 |
0 |
srv_make_money_saldo |
712 |
712 |
0 |
0.00 |
1 |
3188 |
38 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
71783 |
343236 |
235280 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
116 |
116 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
11 |
11 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4988 |
4988 |
0 |
0.00 |
0 |
13445 |
190 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
399 |
399 |
0 |
0.00 |
0 |
4541 |
125 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1667 |
1667 |
0 |
0.00 |
0 |
4194 |
18 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
658 |
658 |
0 |
0.00 |
0 |
4248 |
20 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
689 |
689 |
0 |
0.00 |
0 |
593 |
4 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
382 |
382 |
0 |
0.00 |
0 |
491 |
4 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
373 |
373 |
0 |
0.00 |
0 |
722 |
15 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
420 |
420 |
0 |
0.00 |
0 |
24953 |
1628 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1019 |
1019 |
0 |
0.00 |
0 |
2229 |
13 |
0 |
0 |
t$perf-norm:sp_client_order |
20091 |
20091 |
0 |
0.00 |
0 |
8595 |
20 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
998 |
998 |
0 |
0.00 |
0 |
12030 |
19 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7089 |
7089 |
0 |
0.00 |
0 |
5367 |
11 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5862 |
5862 |
0 |
0.00 |
0 |
7368 |
11 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9816 |
9816 |
0 |
0.00 |
0 |
6475 |
15 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5279 |
5279 |
0 |
0.00 |
0 |
6171 |
20 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5419 |
5419 |
0 |
0.00 |
0 |
9173 |
17 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
95 |
95 |
0 |
0.00 |
0 |
503 |
12 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
66 |
66 |
0 |
0.00 |
0 |
143 |
2 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
571 |
571 |
0 |
0.00 |
0 |
2074 |
36 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
712 |
712 |
0 |
0.00 |
0 |
2021 |
33 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
2 |
2 |
2 |
0 |
0 |
v_add_invoice_to_stock |
10184 |
9952 |
232 |
2.27 |
0 |
3792 |
16 |
0 |
232 |
v_all_customers |
36976 |
36976 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_suppliers |
29806 |
29806 |
0 |
0.00 |
0 |
19 |
1 |
0 |
0 |
v_all_wares |
40180 |
40180 |
0 |
0.00 |
0 |
54 |
1 |
0 |
0 |
v_cancel_adding_invoice |
798 |
798 |
0 |
0.00 |
0 |
2722 |
11 |
0 |
0 |
v_cancel_client_order |
3334 |
3334 |
0 |
0.00 |
0 |
2112 |
4 |
0 |
0 |
v_cancel_customer_prepayment |
1378 |
1378 |
0 |
0.00 |
0 |
2026 |
5 |
0 |
0 |
v_cancel_customer_reserve |
1316 |
1316 |
0 |
0.00 |
0 |
1261 |
4 |
0 |
0 |
v_cancel_payment_to_supplier |
764 |
764 |
0 |
0.00 |
0 |
3871 |
10 |
0 |
0 |
v_cancel_supplier_invoice |
768 |
746 |
22 |
2.86 |
0 |
1193 |
15 |
0 |
22 |
v_cancel_supplier_order |
840 |
840 |
0 |
0.00 |
0 |
467 |
5 |
0 |
0 |
v_cancel_write_off |
2038 |
2038 |
0 |
0.00 |
0 |
4492 |
16 |
0 |
0 |
v_max_id_clo_ord |
5419 |
5419 |
0 |
0.00 |
0 |
359 |
1 |
0 |
0 |
v_max_id_clo_res |
998 |
998 |
0 |
0.00 |
0 |
3272 |
15 |
0 |
0 |
v_max_id_ord_sup |
5274 |
5274 |
0 |
0.00 |
0 |
4275 |
3 |
0 |
0 |
v_max_non_paid_invoice |
1652 |
1652 |
0 |
0.00 |
0 |
2358 |
8 |
0 |
0 |
v_max_non_paid_realizn |
3698 |
3698 |
0 |
0.00 |
0 |
3157 |
5 |
0 |
0 |
v_min_id_clo_ord |
5419 |
5419 |
0 |
0.00 |
0 |
4947 |
8 |
0 |
0 |
v_min_id_clo_res |
998 |
998 |
0 |
0.00 |
0 |
2470 |
11 |
0 |
0 |
v_min_id_ord_sup |
5274 |
5274 |
0 |
0.00 |
0 |
10479 |
11 |
0 |
0 |
v_min_non_paid_invoice |
5862 |
5862 |
0 |
0.00 |
0 |
8490 |
21 |
0 |
0 |
v_min_non_paid_realizn |
7089 |
7089 |
0 |
0.00 |
0 |
8261 |
24 |
0 |
0 |
v_our_firm |
9986 |
9986 |
0 |
0.00 |
0 |
21 |
1 |
0 |
0 |
v_reserve_write_off |
19632 |
19632 |
0 |
0.00 |
0 |
3901 |
6 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
12250 |
12250 |
0 |
0.00 |
0 |
19559 |
127 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
420 |
420 |
0 |
0.00 |
0 |
22733 |
468 |
0 |
0 |
x_make_qstorno_1000_1200 |
5419 |
5419 |
0 |
0.00 |
1 |
89739 |
1156 |
0 |
0 |
x_make_qstorno_1200_2000 |
5279 |
5279 |
0 |
0.00 |
4 |
83355 |
3297 |
0 |
0 |
x_make_qstorno_2100_3300 |
451754 |
451754 |
0 |
0.00 |
0 |
38730 |
168 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 15-01-2023 22:39:34 to 15-01-2023 22:39:38.
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:37 |
33 |
8192000000 |
8819571248 |
8837701632 |
20589440 |
0.250 |
6 |
5 |
7 |
0 |
20883008 |
111568 |
182000 |
20:09:39 |
24886 |
8192000000 |
9878324992 |
10183897088 |
957496160 |
10.465 |
100 |
87 |
174 |
0 |
986997952 |
5915856 |
23585936 |
20:11:12 |
24910 |
8192000000 |
9932958384 |
10252124160 |
1014820336 |
11.022 |
100 |
87 |
174 |
0 |
1045654112 |
8194752 |
22639024 |
20:12:44 |
19324 |
8192000000 |
9970685344 |
10303160320 |
1053761088 |
11.397 |
100 |
85 |
169 |
1 |
1084856352 |
9915696 |
21179568 |
20:14:04 |
8907 |
8192000000 |
10026003184 |
10370629632 |
1112528672 |
11.956 |
100 |
85 |
170 |
1 |
1143880864 |
10875680 |
20476512 |
20:15:18 |
6370 |
8192000000 |
10070743312 |
10427015168 |
1160341808 |
12.406 |
100 |
85 |
168 |
0 |
1192033632 |
12158896 |
19532928 |
20:16:31 |
4655 |
8192000000 |
10139272000 |
10508247040 |
1220046096 |
12.962 |
100 |
80 |
159 |
0 |
1251023728 |
13463696 |
17513936 |
20:17:37 |
1915 |
8192000000 |
10170157840 |
10548518912 |
1257976496 |
13.311 |
100 |
77 |
152 |
0 |
1287461600 |
13218960 |
16266144 |
20:18:41 |
2171 |
8192000000 |
10199934448 |
10579660800 |
1274912160 |
13.467 |
100 |
89 |
173 |
1 |
1307888944 |
14149168 |
18827616 |
20:19:44 |
1472 |
8192000000 |
10214839600 |
10600321024 |
1299580816 |
13.691 |
100 |
90 |
175 |
0 |
1332169104 |
12917616 |
19670672 |
20:20:47 |
2335 |
8192000000 |
10212997728 |
10612772864 |
1313147472 |
13.815 |
100 |
52 |
104 |
0 |
1334975056 |
10283280 |
11544304 |
20:21:52 |
42396 |
8192000000 |
10219879872 |
10623913984 |
1316574288 |
13.846 |
100 |
37 |
72 |
0 |
1335673920 |
10123600 |
8976032 |
20:23:36 |
9170 |
8192000000 |
10215282736 |
10630389760 |
1325292752 |
13.925 |
100 |
13 |
26 |
0 |
1333186864 |
5414224 |
2479888 |
20:24:53 |
8900 |
8192000000 |
10218900976 |
10635583488 |
1334021264 |
14.003 |
100 |
20 |
40 |
0 |
1343951632 |
4905056 |
5025312 |
20:26:13 |
6244 |
8192000000 |
10227486944 |
10647855104 |
1340865888 |
14.065 |
100 |
29 |
57 |
1 |
1353827872 |
6618832 |
6343152 |
20:27:21 |
43969 |
8192000000 |
10242816128 |
10652450816 |
1320001584 |
13.877 |
98 |
39 |
77 |
0 |
1335105792 |
5457600 |
9646608 |
20:29:07 |
6338 |
8192000000 |
10228397232 |
10644377600 |
1333991920 |
14.003 |
100 |
34 |
68 |
0 |
1348750752 |
7204992 |
7553840 |
20:30:14 |
9027 |
8192000000 |
10163668944 |
10564554752 |
1224678976 |
13.005 |
95 |
22 |
45 |
1 |
1235127648 |
4956784 |
5491888 |
20:31:25 |
9042 |
8192000000 |
10123793936 |
10520788992 |
1175548832 |
12.549 |
94 |
18 |
35 |
0 |
1184375232 |
4952736 |
3873664 |
20:32:35 |
33386 |
8192000000 |
10139367632 |
10529771520 |
1226181168 |
13.019 |
99 |
51 |
100 |
0 |
1244962800 |
6823184 |
11958448 |
20:34:14 |
3392 |
8192000000 |
10152696848 |
10559045632 |
1263364400 |
13.361 |
100 |
41 |
83 |
1 |
1281154624 |
8673072 |
9117152 |
20:35:18 |
7499 |
8192000000 |
10167750224 |
10575478784 |
1274829200 |
13.466 |
100 |
18 |
36 |
0 |
1284786240 |
6073920 |
3883120 |
20:36:31 |
15201 |
8192000000 |
10184084592 |
10596950016 |
1291882336 |
13.621 |
100 |
9 |
19 |
0 |
1299489776 |
5638544 |
1968896 |
20:37:49 |
17687 |
8192000000 |
10195688512 |
10607214592 |
1302135696 |
13.715 |
100 |
22 |
44 |
0 |
1312284048 |
5400944 |
4747408 |
20:39:12 |
8460 |
8192000000 |
10235056288 |
10645700608 |
1329111664 |
13.959 |
100 |
39 |
79 |
0 |
1349500768 |
11379264 |
9009840 |
20:40:26 |
18231 |
8192000000 |
10251450560 |
10663354368 |
1346021376 |
14.112 |
100 |
56 |
111 |
1 |
1368152960 |
9971568 |
12160016 |
20:41:48 |
19781 |
8192000000 |
10261708816 |
10678362112 |
1354667760 |
14.189 |
100 |
45 |
89 |
1 |
1376063712 |
11681680 |
9714272 |
20:43:21 |
27124 |
8192000000 |
10272229296 |
10698878976 |
1368500368 |
14.314 |
100 |
36 |
70 |
0 |
1387511056 |
11213552 |
7797136 |
20:44:52 |
8086 |
8192000000 |
10277650544 |
10699345920 |
1367489584 |
14.305 |
100 |
48 |
96 |
0 |
1392487104 |
13942592 |
11054928 |
20:46:06 |
10236 |
8192000000 |
10287945120 |
10711179264 |
1375916608 |
14.380 |
100 |
47 |
94 |
1 |
1401769824 |
15169296 |
10683920 |
20:47:21 |
9112 |
8192000000 |
10292652688 |
10715136000 |
1378185584 |
14.400 |
100 |
42 |
84 |
1 |
1401002944 |
13587872 |
9229488 |
20:48:34 |
6269 |
8192000000 |
10310280224 |
10733707264 |
1392930896 |
14.532 |
100 |
49 |
98 |
0 |
1420298336 |
15558112 |
11809328 |
20:49:46 |
7874 |
8192000000 |
10314442016 |
10732204032 |
1389344496 |
14.500 |
100 |
58 |
115 |
0 |
1421099824 |
18582144 |
13173184 |
20:51:00 |
4086 |
8192000000 |
10324599728 |
10742087680 |
1388888928 |
14.496 |
99 |
62 |
123 |
1 |
1430712736 |
27023536 |
14800272 |
20:52:08 |
2515 |
8192000000 |
10327712832 |
10736742400 |
1385395968 |
14.465 |
100 |
72 |
146 |
2 |
1433568816 |
30185984 |
17986864 |
20:53:14 |
3911 |
8192000000 |
10331218432 |
10744881152 |
1387051056 |
14.480 |
100 |
78 |
155 |
0 |
1441195824 |
34368768 |
19776000 |
20:54:24 |
1854 |
8192000000 |
10336565984 |
10743074816 |
1381825328 |
14.433 |
99 |
80 |
156 |
1 |
1439912640 |
39151744 |
18935568 |
20:55:28 |
5688 |
8192000000 |
10333396528 |
10740981760 |
1380639232 |
14.422 |
100 |
79 |
154 |
0 |
1438028208 |
37708816 |
19680160 |
20:56:36 |
5487 |
8192000000 |
10324462080 |
10739830784 |
1380783360 |
14.424 |
100 |
52 |
104 |
0 |
1429843904 |
35667648 |
13392896 |
20:57:46 |
2458 |
8192000000 |
10332169424 |
10739646464 |
1367201136 |
14.302 |
99 |
74 |
146 |
2 |
1428972416 |
43919680 |
17851600 |
20:58:56 |
4292 |
8192000000 |
10343179360 |
10743820288 |
1378703008 |
14.405 |
100 |
66 |
132 |
0 |
1441507328 |
45928864 |
16875456 |
21:00:03 |
5434 |
8192000000 |
10351636624 |
10757926912 |
1390193440 |
14.508 |
100 |
64 |
127 |
0 |
1455208752 |
48383440 |
16631872 |
21:01:19 |
10138 |
8192000000 |
10349702736 |
10756792320 |
1364700272 |
14.280 |
99 |
58 |
116 |
0 |
1438175152 |
57299648 |
16175232 |
21:02:37 |
2126 |
8192000000 |
10357175312 |
10774634496 |
1381722080 |
14.432 |
99 |
65 |
128 |
1 |
1453096560 |
54016656 |
17357824 |
21:03:49 |
4135 |
8192000000 |
10349606368 |
10765938688 |
1381289856 |
14.428 |
99 |
53 |
104 |
0 |
1448205392 |
52943072 |
13972464 |
21:04:56 |
6682 |
8192000000 |
10360357904 |
10788159488 |
1385281920 |
14.464 |
100 |
48 |
94 |
0 |
1458841632 |
60375200 |
13184512 |
21:06:08 |
29069 |
8192000000 |
10306580032 |
10744102912 |
1343859200 |
14.092 |
99 |
25 |
50 |
0 |
1404914832 |
52776240 |
8279392 |
21:07:40 |
23412 |
8192000000 |
10263250704 |
10703863808 |
1311091152 |
13.796 |
98 |
18 |
36 |
0 |
1354532432 |
38490800 |
4950480 |
21:09:24 |
102607 |
8192000000 |
10282158864 |
10725429248 |
1352134912 |
14.167 |
99 |
40 |
76 |
1 |
1367994816 |
7583280 |
8276624 |
21:12:55 |
39602 |
8192000000 |
10274053856 |
10736107520 |
1374296192 |
14.366 |
100 |
7 |
14 |
0 |
1389261488 |
13262512 |
1702784 |
21:15:31 |
57794 |
8192000000 |
10273487840 |
10720997376 |
1364860608 |
14.281 |
99 |
29 |
57 |
1 |
1381947008 |
10549552 |
6536848 |
21:17:29 |
92339 |
8192000000 |
10297535408 |
10742661120 |
1362817088 |
14.263 |
98 |
18 |
37 |
0 |
1377423632 |
10434576 |
4171968 |
21:20:05 |
98649 |
8192000000 |
10308391408 |
10772193280 |
1399793776 |
14.593 |
100 |
17 |
35 |
0 |
1421755792 |
17704912 |
4257104 |
21:22:49 |
134009 |
8192000000 |
10312176176 |
10778537984 |
1386358400 |
14.473 |
99 |
26 |
50 |
2 |
1408874464 |
16536720 |
5979344 |
21:26:04 |
29998 |
8192000000 |
10318211120 |
10769371136 |
1405202976 |
14.641 |
100 |
27 |
53 |
2 |
1423884496 |
12357456 |
6324064 |
21:27:36 |
56811 |
8192000000 |
10309666272 |
10767921152 |
1403962288 |
14.630 |
100 |
21 |
42 |
0 |
1416259520 |
7683072 |
4614160 |
21:29:44 |
70928 |
8192000000 |
10311771344 |
10777210880 |
1404651552 |
14.636 |
99 |
11 |
22 |
0 |
1419455552 |
11910240 |
2893760 |
21:31:55 |
69607 |
8192000000 |
10314121280 |
10770472960 |
1408094048 |
14.667 |
100 |
21 |
42 |
0 |
1427687056 |
14410832 |
5182176 |
21:34:17 |
29054 |
8192000000 |
10308177600 |
10770247680 |
1405179024 |
14.641 |
100 |
11 |
22 |
0 |
1418420352 |
10786832 |
2454496 |
21:35:52 |
48919 |
8192000000 |
10303959664 |
10775912448 |
1401873008 |
14.612 |
99 |
9 |
18 |
0 |
1418791456 |
14850112 |
2068336 |
21:37:50 |
45411 |
8192000000 |
10293797280 |
10754805760 |
1372089088 |
14.346 |
98 |
11 |
22 |
0 |
1382144608 |
8026080 |
2029440 |
21:39:37 |
58980 |
8192000000 |
10307906112 |
10782846976 |
1392281152 |
14.526 |
99 |
28 |
54 |
1 |
1414956592 |
16408832 |
6266608 |
21:41:40 |
56385 |
8192000000 |
10309910688 |
10781831168 |
1373116464 |
14.355 |
97 |
20 |
40 |
0 |
1388603456 |
11215712 |
4271280 |
21:43:37 |
75268 |
8192000000 |
10317125424 |
10770341888 |
1395493712 |
14.555 |
99 |
21 |
42 |
0 |
1415979424 |
15447920 |
5037792 |
21:46:08 |
66378 |
8192000000 |
10294734448 |
10742132736 |
1327654864 |
13.946 |
96 |
21 |
40 |
3 |
1351906208 |
19364304 |
4887040 |
21:48:16 |
55624 |
8192000000 |
10283235504 |
10759049216 |
1368991984 |
14.318 |
100 |
9 |
18 |
0 |
1390582432 |
19451536 |
2138912 |
21:50:16 |
59994 |
8192000000 |
10261617936 |
10718048256 |
1335421248 |
14.016 |
98 |
19 |
38 |
0 |
1351233344 |
11364448 |
4447648 |
21:52:17 |
104602 |
8192000000 |
10232628064 |
10668834816 |
1298814064 |
13.684 |
97 |
23 |
46 |
0 |
1312514320 |
8473712 |
5226544 |
21:55:06 |
30112 |
8192000000 |
10244918496 |
10680741888 |
1323480960 |
13.908 |
98 |
28 |
54 |
0 |
1337798816 |
7639280 |
6678576 |
21:56:37 |
57595 |
8192000000 |
10225248528 |
10686226432 |
1282261920 |
13.534 |
95 |
7 |
14 |
0 |
1295293392 |
10923200 |
2108272 |
21:58:35 |
75782 |
8192000000 |
10248995024 |
10708369408 |
1349454656 |
14.143 |
100 |
19 |
36 |
1 |
1364318240 |
10553728 |
4309856 |
22:00:51 |
49673 |
8192000000 |
10240941056 |
10694488064 |
1310621856 |
13.792 |
97 |
20 |
40 |
0 |
1330239728 |
14639856 |
4978016 |
22:03:01 |
71978 |
8192000000 |
10251248288 |
10729209856 |
1334733824 |
14.010 |
99 |
9 |
18 |
0 |
1363647696 |
26623072 |
2290800 |
22:05:13 |
26020 |
8192000000 |
10253921744 |
10703671296 |
1329325664 |
13.961 |
98 |
20 |
37 |
0 |
1340758368 |
7317824 |
4114880 |
22:06:42 |
56319 |
8192000000 |
10260135392 |
10703544320 |
1331414528 |
13.980 |
98 |
18 |
36 |
0 |
1346321904 |
11012784 |
3894592 |
22:08:39 |
60954 |
8192000000 |
10263763424 |
10715774976 |
1340254656 |
14.060 |
98 |
17 |
34 |
0 |
1352678176 |
8742816 |
3680704 |
22:10:40 |
49432 |
8192000000 |
10282783552 |
10733330432 |
1364810224 |
14.281 |
99 |
23 |
46 |
0 |
1382140448 |
12246560 |
5083664 |
22:12:31 |
71879 |
8192000000 |
10307937648 |
10770341888 |
1370205600 |
14.329 |
99 |
7 |
14 |
0 |
1391862560 |
20724752 |
932208 |
22:15:13 |
84160 |
8192000000 |
10305111616 |
10754760704 |
1364796608 |
14.280 |
98 |
20 |
36 |
0 |
1380283536 |
11594272 |
3892656 |
22:17:37 |
51176 |
8192000000 |
10301346032 |
10751389696 |
1376731152 |
14.387 |
99 |
45 |
90 |
0 |
1404105200 |
16782320 |
10591728 |
22:19:34 |
110666 |
8192000000 |
10295835920 |
10766237696 |
1381192144 |
14.427 |
99 |
24 |
48 |
1 |
1398041360 |
11747840 |
5101376 |
22:22:27 |
51161 |
8192000000 |
10294187984 |
10760544256 |
1401041536 |
14.604 |
100 |
23 |
47 |
0 |
1415320208 |
9288032 |
4990640 |
22:24:18 |
59693 |
8192000000 |
10296895968 |
10756829184 |
1393431184 |
14.536 |
99 |
9 |
18 |
0 |
1403766336 |
8126048 |
2209104 |
22:26:21 |
48475 |
8192000000 |
10294214112 |
10770317312 |
1389617376 |
14.502 |
99 |
6 |
12 |
0 |
1402416512 |
11399904 |
1399232 |
22:28:51 |
68168 |
8192000000 |
10287245200 |
10758033408 |
1371699872 |
14.342 |
98 |
11 |
23 |
0 |
1387555104 |
13127440 |
2727792 |
22:31:01 |
35500 |
8192000000 |
10287594592 |
10739220480 |
1336589264 |
14.027 |
96 |
16 |
30 |
1 |
1353001088 |
12584560 |
3827264 |
22:32:56 |
71959 |
8192000000 |
10283730320 |
10746380288 |
1347059248 |
14.121 |
97 |
9 |
18 |
0 |
1363259552 |
14261888 |
1938416 |
22:35:20 |
33734 |
8192000000 |
10275511360 |
10726887424 |
1342198928 |
14.077 |
98 |
27 |
54 |
1 |
1364514480 |
15799072 |
6516480 |
22:36:55 |
33838 |
8192000000 |
10291899984 |
10724573184 |
1349459744 |
14.143 |
98 |
35 |
70 |
0 |
1366650272 |
9826144 |
7364384 |
22:38:30 |
22171 |
8192000000 |
9065122352 |
9287409664 |
230215504 |
2.733 |
17 |
2 |
4 |
0 |
233896384 |
3345264 |
335616 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 15-01-2023 22:39:40 to 15-01-2023 22:39:56.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
116 |
v_add_invoice_to_stock |
335544517 |
except |
11 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-01-2023 22:39:57 to 15-01-2023 22:39:59.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 234470
MON$OLDEST_ACTIVE 234471
MON$OLDEST_SNAPSHOT 234471
MON$NEXT_TRANSACTION 234471
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 2022144
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.33653 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33653 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33653 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33653 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 ---
--- end of diff output ---
15.01.23 22:40:00. 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 |
2023-01-15 22:40:02 |
No severe PSQL-related problems occured |
15.01.23 22:40:04. End of report.