-
-
Save H-Kwon/e3c7fb25c55a57df57579efbebc5671c to your computer and use it in GitHub Desktop.
20240110-virtuoso_prod.log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sat Dec 09 2023 | |
23:40:30 OpenLink Virtuoso Universal Server | |
23:40:30 Version 07.20.3238-pthreads for Linux as of Sep 26 2023 (d89671fa1) | |
23:40:30 uses OpenSSL 1.0.2u 20 Dec 2019 | |
23:40:30 uses parts of PCRE, Html Tidy | |
23:40:30 Begin to restore with file prefix prod-2023-12-09_# | |
23:40:30 --> Backup file # 1 [0x133C-0x2B-0xD4] | |
23:41:10 End of restoring from backup, 503743 pages | |
23:41:10 Server exiting | |
Sat Dec 09 2023 | |
23:42:21 OpenLink Virtuoso Universal Server | |
23:42:21 Version 07.20.3238-pthreads for Linux as of Sep 26 2023 (d89671fa1) | |
23:42:21 uses OpenSSL 1.0.2u 20 Dec 2019 | |
23:42:21 uses parts of PCRE, Html Tidy | |
23:42:23 Database version 3126 | |
23:42:23 SQL Optimizer enabled (max 1000 layouts) | |
23:42:24 Compiler unit is timed at 0.000111 msec | |
23:42:25 Roll forward started | |
23:42:25 Roll forward complete | |
23:42:26 Checkpoint started | |
23:42:26 Checkpoint finished, log reused | |
23:42:28 HTTP/WebDAV server online at 7000 | |
23:42:28 Server online at 1111 (pid 1864775) | |
Sun Dec 10 2023 | |
03:11:07 * Monitor: Locks are held for a long time | |
05:42:35 Checkpoint started | |
05:42:36 Checkpoint finished, log reused | |
06:24:03 * Monitor: Locks are held for a long time | |
09:52:07 * Monitor: Locks are held for a long time | |
10:03:54 * Monitor: Locks are held for a long time | |
10:42:45 Read wait on column page 5266. Waits should be on the index leaf page | |
10:42:45 Read wait on column page 26077. Waits should be on the index leaf page | |
10:42:45 Read wait on column page 26080. Waits should be on the index leaf page | |
10:42:45 Read wait on column page 26082. Waits should be on the index leaf page | |
10:42:45 Read wait on column page 26084. Waits should be on the index leaf page | |
10:42:45 Checkpoint started | |
10:42:46 Checkpoint finished, log reused | |
10:42:47 * Monitor: Locks are held for a long time | |
11:26:26 * Monitor: Locks are held for a long time | |
11:30:37 * Monitor: Locks are held for a long time | |
11:38:15 * Monitor: Locks are held for a long time | |
11:45:07 * Monitor: Locks are held for a long time | |
11:55:45 * Monitor: Locks are held for a long time | |
12:57:17 * Monitor: Locks are held for a long time | |
16:06:05 * Monitor: Locks are held for a long time | |
20:43:00 Checkpoint started | |
20:43:00 Checkpoint finished, log reused | |
23:17:20 * Monitor: Locks are held for a long time | |
Mon Dec 11 2023 | |
01:41:09 * Monitor: Locks are held for a long time | |
01:43:08 Checkpoint started | |
01:43:09 Checkpoint finished, log reused | |
02:10:30 * Monitor: Locks are held for a long time | |
07:43:20 Checkpoint started | |
07:43:20 Checkpoint finished, log reused | |
07:59:40 * Monitor: Locks are held for a long time | |
11:39:46 * Monitor: Locks are held for a long time | |
12:43:29 Checkpoint started | |
12:43:29 Checkpoint finished, log reused | |
12:55:14 * Monitor: Locks are held for a long time | |
14:09:11 * Monitor: Locks are held for a long time | |
15:06:56 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
15:08:28 * Monitor: Locks are held for a long time | |
15:51:59 * Monitor: Locks are held for a long time | |
17:43:40 Read wait on column page 66968. Waits should be on the index leaf page | |
17:43:41 Checkpoint started | |
17:43:42 Checkpoint finished, log reused | |
19:47:52 * Monitor: Locks are held for a long time | |
19:58:15 * Monitor: Locks are held for a long time | |
20:01:37 * Monitor: Locks are held for a long time | |
20:17:14 * Monitor: Locks are held for a long time | |
20:55:03 * Monitor: Locks are held for a long time | |
Tue Dec 12 2023 | |
01:43:49 Read wait on column page 328407. Waits should be on the index leaf page | |
01:43:50 Checkpoint started | |
01:43:51 Checkpoint finished, log reused | |
02:08:57 * Monitor: Locks are held for a long time | |
02:21:28 * Monitor: Locks are held for a long time | |
03:27:00 * Monitor: Locks are held for a long time | |
03:30:25 * Monitor: Locks are held for a long time | |
06:43:55 * Monitor: Locks are held for a long time | |
06:44:01 Checkpoint started | |
06:44:01 Checkpoint finished, log reused | |
07:24:36 * Monitor: Locks are held for a long time | |
07:34:58 * Monitor: Locks are held for a long time | |
08:09:53 * Monitor: Locks are held for a long time | |
08:46:16 * Monitor: Locks are held for a long time | |
10:08:13 * Monitor: Locks are held for a long time | |
10:44:10 Read wait on column page 87213. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32700. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32701. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32703. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32706. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32708. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32711. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32713. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32715. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32752. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32754. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32765. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 32767. Waits should be on the index leaf page | |
10:44:10 Read wait on column page 45056. Waits should be on the index leaf page | |
10:44:11 Checkpoint started | |
10:44:11 Checkpoint finished, log reused | |
14:44:24 Checkpoint started | |
14:44:24 Checkpoint finished, log reused | |
14:49:23 * Monitor: Locks are held for a long time | |
14:53:47 * Monitor: Locks are held for a long time | |
14:58:38 * Monitor: Locks are held for a long time | |
15:36:32 * Monitor: Locks are held for a long time | |
16:33:39 * Monitor: Locks are held for a long time | |
18:24:59 * Monitor: Locks are held for a long time | |
19:44:33 Checkpoint started | |
19:44:34 Checkpoint finished, log reused | |
19:46:36 * Monitor: Locks are held for a long time | |
19:48:40 * Monitor: Locks are held for a long time | |
19:51:53 * Monitor: Locks are held for a long time | |
Wed Dec 13 2023 | |
02:44:41 Checkpoint started | |
02:44:42 Checkpoint finished, log reused | |
03:31:01 * Monitor: Locks are held for a long time | |
11:44:56 Checkpoint started | |
11:44:57 Checkpoint finished, log reused | |
12:01:04 * Monitor: Locks are held for a long time | |
13:56:51 * Monitor: Locks are held for a long time | |
18:45:07 Read wait on column page 341875. Waits should be on the index leaf page | |
18:45:07 Read wait on column page 25951. Waits should be on the index leaf page | |
18:45:07 Read wait on column page 341872. Waits should be on the index leaf page | |
18:45:07 Checkpoint started | |
18:45:08 Checkpoint finished, log reused | |
22:45:16 Checkpoint started | |
22:45:17 Checkpoint finished, log reused | |
22:50:02 * Monitor: Locks are held for a long time | |
23:05:43 * Monitor: Locks are held for a long time | |
23:20:15 * Monitor: Locks are held for a long time | |
Thu Dec 14 2023 | |
00:02:20 * Monitor: Locks are held for a long time | |
00:05:39 * Monitor: Locks are held for a long time | |
00:33:30 * Monitor: Locks are held for a long time | |
08:45:36 Checkpoint started | |
08:45:36 Checkpoint finished, log reused | |
08:54:34 * Monitor: Locks are held for a long time | |
10:26:29 * Monitor: Locks are held for a long time | |
14:45:49 Checkpoint started | |
14:45:50 Checkpoint finished, log reused | |
14:46:58 * Monitor: Locks are held for a long time | |
15:03:07 * Monitor: Locks are held for a long time | |
20:45:58 Checkpoint started | |
20:45:59 Checkpoint finished, log reused | |
Fri Dec 15 2023 | |
02:46:07 Checkpoint started | |
02:46:08 Checkpoint finished, log reused | |
10:45:33 * Monitor: Locks are held for a long time | |
10:45:39 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:46:22 Checkpoint started | |
10:46:23 Checkpoint finished, log reused | |
10:47:39 * Monitor: Locks are held for a long time | |
10:47:55 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:49:55 * Monitor: Locks are held for a long time | |
10:49:57 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:52:01 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:52:01 * Monitor: Locks are held for a long time | |
10:52:16 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (2) | |
10:53:04 * Monitor: Many lock waits | |
10:54:05 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:54:05 * Monitor: Locks are held for a long time | |
10:56:41 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:56:41 * Monitor: Locks are held for a long time | |
10:57:07 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (2) | |
10:57:18 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
10:58:47 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
10:58:47 * Monitor: Locks are held for a long time | |
10:59:08 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (2) | |
10:59:54 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:01:09 * Monitor: Locks are held for a long time | |
11:01:20 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:03:21 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:03:51 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:04:06 * Monitor: Locks are held for a long time | |
11:06:28 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:06:28 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:06:42 * Monitor: Locks are held for a long time | |
11:08:52 * Monitor: Locks are held for a long time | |
11:09:32 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:09:54 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:11:09 * Monitor: Locks are held for a long time | |
11:29:04 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:29:56 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:30:19 * Monitor: Locks are held for a long time | |
11:31:11 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:32:00 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:32:37 * Monitor: Locks are held for a long time | |
11:33:13 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:34:09 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:35:04 * Monitor: Locks are held for a long time | |
11:35:15 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:36:47 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:37:12 * Monitor: Many lock waits | |
11:37:29 * Monitor: Locks are held for a long time | |
11:37:47 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:39:14 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:39:48 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:39:52 * Monitor: Locks are held for a long time | |
11:40:58 * Monitor: Many lock waits | |
11:41:37 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:41:50 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:42:14 * Monitor: Locks are held for a long time | |
11:43:51 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:43:57 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:44:33 * Monitor: Locks are held for a long time | |
11:45:52 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:46:16 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:46:54 * Monitor: Locks are held for a long time | |
11:48:24 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:48:40 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:49:18 * Monitor: Locks are held for a long time | |
11:50:25 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:50:58 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:51:32 * Monitor: Locks are held for a long time | |
11:52:27 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:53:13 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:53:47 * Monitor: Locks are held for a long time | |
11:54:28 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:55:26 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:55:58 * Monitor: Locks are held for a long time | |
11:56:29 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:57:39 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
11:58:13 * Monitor: Locks are held for a long time | |
11:58:30 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
11:59:53 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
12:00:28 * Monitor: Locks are held for a long time | |
12:00:32 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
12:02:14 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
12:02:32 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
12:02:50 * Monitor: Locks are held for a long time | |
12:04:32 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
12:04:34 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
12:05:04 * Monitor: Locks are held for a long time | |
12:53:49 Checkpoint started | |
12:53:49 Checkpoint finished, log reused | |
12:53:50 Checkpoint started | |
12:53:50 Checkpoint finished, log reused | |
12:53:50 Checkpoint started | |
12:53:50 Checkpoint finished, log reused | |
12:53:50 Starting online backup from page 1 to 1081344, current log is: /opt/database-prod/virtuoso.trx | |
12:53:51 Backing up page 10000 | |
12:53:54 Backing up page 20000 | |
12:53:56 Backing up page 30000 | |
12:53:58 Backing up page 40000 | |
12:54:01 Backing up page 50000 | |
12:54:03 Backing up page 60000 | |
12:54:06 Backing up page 70000 | |
12:54:10 Backing up page 80000 | |
12:54:13 Backing up page 90000 | |
12:54:16 Backing up page 100000 | |
12:54:19 Backing up page 110000 | |
12:54:22 Backing up page 120000 | |
12:54:25 Backing up page 130000 | |
12:54:28 Backing up page 140000 | |
12:54:31 Backing up page 150000 | |
12:54:33 Backing up page 160000 | |
12:54:36 Backing up page 170000 | |
12:54:40 Backing up page 180000 | |
12:54:43 Backing up page 190000 | |
12:54:46 Backing up page 200000 | |
12:54:49 Backing up page 210000 | |
12:54:52 Backing up page 220000 | |
12:54:54 Backing up page 230000 | |
12:54:57 Backing up page 240000 | |
12:55:00 Backing up page 250000 | |
12:55:02 Backing up page 260000 | |
12:55:04 Backing up page 270000 | |
12:55:07 Backing up page 280000 | |
12:55:09 Backing up page 290000 | |
12:55:11 Backing up page 300000 | |
12:55:14 Backing up page 310000 | |
12:55:17 Backing up page 320000 | |
12:55:19 Backing up page 330000 | |
12:55:21 Backing up page 340000 | |
12:55:22 Backing up page 350000 | |
12:55:23 Backing up page 360000 | |
12:55:25 Backing up page 370000 | |
12:55:26 Backing up page 380000 | |
12:55:30 Backing up page 390000 | |
12:55:34 Backing up page 400000 | |
12:55:37 Backing up page 410000 | |
12:55:41 Backing up page 420000 | |
12:55:45 Backing up page 430000 | |
12:55:48 Backing up page 440000 | |
12:55:51 Backing up page 450000 | |
12:55:54 Backing up page 460000 | |
12:55:57 Backing up page 470000 | |
12:55:59 Backing up page 480000 | |
12:56:00 Backing up page 490000 | |
12:56:02 Backing up page 500000 | |
12:56:03 Backing up page 510000 | |
12:56:04 Backing up page 520000 | |
12:56:04 Backing up page 530000 | |
12:56:06 Backing up page 540000 | |
12:56:08 Backing up page 550000 | |
12:56:10 Backing up page 560000 | |
12:56:12 Backing up page 570000 | |
12:56:14 Backing up page 580000 | |
12:56:16 Backing up page 590000 | |
12:56:18 Backing up page 600000 | |
12:56:21 Backing up page 610000 | |
12:56:24 Backing up page 620000 | |
12:56:26 Backing up page 630000 | |
12:56:28 Backing up page 640000 | |
12:56:29 Backing up page 650000 | |
12:56:31 Backing up page 660000 | |
12:56:33 Backing up page 670000 | |
12:56:35 Backing up page 680000 | |
12:56:37 Backing up page 690000 | |
12:56:39 Backing up page 700000 | |
12:56:40 Backing up page 710000 | |
12:56:40 Backing up page 720000 | |
12:56:41 Backing up page 730000 | |
12:56:42 Backing up page 740000 | |
12:56:43 Backing up page 750000 | |
12:56:43 Backing up page 760000 | |
12:56:44 Backing up page 770000 | |
12:56:45 Backing up page 780000 | |
12:56:46 Backing up page 790000 | |
12:56:46 Backing up page 800000 | |
12:56:47 Backing up page 810000 | |
12:56:47 Backing up page 820000 | |
12:56:47 Backing up page 830000 | |
12:56:47 Backing up page 840000 | |
12:56:47 Backing up page 850000 | |
12:56:47 Backing up page 860000 | |
12:56:47 Backing up page 870000 | |
12:56:47 Backing up page 880000 | |
12:56:47 Backing up page 890000 | |
12:56:47 Backing up page 900000 | |
12:56:47 Backing up page 910000 | |
12:56:47 Backing up page 920000 | |
12:56:47 Backing up page 930000 | |
12:56:47 Backing up page 940000 | |
12:56:47 Backing up page 950000 | |
12:56:47 Backing up page 960000 | |
12:56:47 Backing up page 970000 | |
12:56:47 Backing up page 980000 | |
12:56:47 Backing up page 990000 | |
12:56:47 Backing up page 1000000 | |
12:56:47 Backing up page 1010000 | |
12:56:47 Backing up page 1020000 | |
12:56:47 Backing up page 1030000 | |
12:56:47 Backing up page 1040000 | |
12:56:47 Backing up page 1050000 | |
12:56:47 Backing up page 1060000 | |
12:56:47 Backing up page 1070000 | |
12:56:47 Backing up page 1080000 | |
12:56:47 Backed up pages: [505596] | |
12:56:47 Checkpoint started | |
12:56:47 Checkpoint finished, log reused | |
13:26:16 Server received signal 15 | |
13:26:16 Initiating quick shutdown | |
13:26:16 Checkpoint started | |
13:26:16 Checkpoint finished, log reused | |
13:26:16 Server shutdown complete | |
Fri Dec 15 2023 | |
13:26:16 OpenLink Virtuoso Universal Server | |
13:26:16 Version 07.20.3238-pthreads for Linux as of Sep 26 2023 (d89671fa1) | |
13:26:16 uses OpenSSL 1.0.2u 20 Dec 2019 | |
13:26:16 uses parts of PCRE, Html Tidy | |
13:26:20 Database version 3126 | |
13:26:20 Unlinked the temp db file /opt/database-prod/virtuoso-temp.db as its size (18MB) was greater than TempDBSize INI (0MB) | |
13:26:20 SQL Optimizer enabled (max 1000 layouts) | |
13:26:21 Compiler unit is timed at 0.000107 msec | |
13:26:22 Roll forward started | |
13:26:22 Roll forward complete | |
13:26:23 Checkpoint started | |
13:26:23 Checkpoint finished, log reused | |
13:26:25 HTTP/WebDAV server online at 7000 | |
13:26:25 Server online at 1111 (pid 1918336) | |
13:52:43 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
13:53:51 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
13:54:19 * Monitor: Locks are held for a long time | |
13:55:14 * Monitor: System is under high load. Adding cluster nodes or using more replicated copies may needed | |
13:56:14 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
13:56:33 * Monitor: Many lock waits | |
13:57:34 * Monitor: Locks are held for a long time | |
13:58:14 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
13:59:16 * Monitor: Many lock waits | |
13:59:54 * Monitor: Locks are held for a long time | |
14:00:16 Server received signal 15 | |
14:00:16 Initiating quick shutdown | |
14:00:18 Checkpoint started | |
14:00:18 Checkpoint finished, log reused | |
14:00:18 Server shutdown complete | |
Fri Dec 15 2023 | |
14:00:18 OpenLink Virtuoso Universal Server | |
14:00:18 Version 07.20.3238-pthreads for Linux as of Sep 26 2023 (d89671fa1) | |
14:00:18 uses OpenSSL 1.0.2u 20 Dec 2019 | |
14:00:18 uses parts of PCRE, Html Tidy | |
14:00:21 Database version 3126 | |
14:00:21 Unlinked the temp db file /opt/database-prod/virtuoso-temp.db as its size (12MB) was greater than TempDBSize INI (0MB) | |
14:00:21 SQL Optimizer enabled (max 1000 layouts) | |
14:00:23 Compiler unit is timed at 0.000108 msec | |
14:00:24 Roll forward started | |
14:00:24 Roll forward complete | |
14:00:25 Checkpoint started | |
14:00:25 Checkpoint finished, log reused | |
14:00:27 HTTP/WebDAV server online at 7000 | |
14:00:27 Server online at 1111 (pid 1918422) | |
23:00:38 Checkpoint started | |
23:00:38 Checkpoint finished, log reused | |
Sat Dec 16 2023 | |
03:32:07 * Monitor: Locks are held for a long time | |
04:00:45 Checkpoint started | |
04:00:46 Checkpoint finished, log reused | |
11:00:56 Checkpoint started | |
11:00:56 Checkpoint finished, log reused | |
18:01:03 Checkpoint started | |
18:01:04 Checkpoint finished, log reused | |
Sun Dec 17 2023 | |
02:01:13 Checkpoint started | |
02:01:14 Checkpoint finished, log reused | |
04:53:24 * Monitor: Locks are held for a long time | |
10:01:23 Checkpoint started | |
10:01:23 Checkpoint finished, log reused | |
20:01:41 Checkpoint started | |
20:01:41 Checkpoint finished, log reused | |
Mon Dec 18 2023 | |
07:01:53 Checkpoint started | |
07:01:54 Checkpoint finished, log reused | |
09:45:47 * Monitor: Locks are held for a long time | |
11:02:04 Checkpoint started | |
11:02:05 Checkpoint finished, log reused | |
15:02:13 Checkpoint started | |
15:02:14 Checkpoint finished, log reused | |
23:02:26 Checkpoint started | |
23:02:27 Checkpoint finished, log reused | |
Tue Dec 19 2023 | |
07:46:15 * Monitor: Locks are held for a long time | |
07:49:57 * Monitor: Locks are held for a long time | |
07:57:50 * Monitor: Locks are held for a long time | |
08:02:41 Read wait on column page 361492. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 361493. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26027. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26030. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26032. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26034. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26035. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26059. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 26061. Waits should be on the index leaf page | |
08:02:41 Read wait on column page 328341. Waits should be on the index leaf page | |
08:02:41 Checkpoint started | |
08:02:42 Checkpoint finished, log reused | |
08:34:29 * Monitor: Locks are held for a long time | |
11:02:49 Read wait on column page 4936. Waits should be on the index leaf page | |
11:02:49 Read wait on column page 5635. Waits should be on the index leaf page | |
11:02:49 Read wait on column page 5043. Waits should be on the index leaf page | |
11:02:50 Checkpoint started | |
11:02:51 Checkpoint finished, log reused | |
14:02:58 Checkpoint started | |
14:02:58 Checkpoint finished, log reused | |
14:08:20 * Monitor: Locks are held for a long time | |
14:30:50 * Monitor: Locks are held for a long time | |
18:03:05 Checkpoint started | |
18:03:06 Checkpoint finished, log reused | |
18:57:17 * Monitor: Locks are held for a long time | |
22:11:22 * Monitor: Locks are held for a long time | |
23:25:50 * Monitor: Locks are held for a long time | |
Wed Dec 20 2023 | |
01:03:17 Checkpoint started | |
01:03:17 Checkpoint finished, log reused | |
08:03:25 Read wait on column page 154917. Waits should be on the index leaf page | |
08:03:25 Read wait on column page 328384. Waits should be on the index leaf page | |
08:03:25 Read wait on column page 5203. Waits should be on the index leaf page | |
08:03:26 Checkpoint started | |
08:03:27 Checkpoint finished, log reused | |
08:03:33 * Monitor: Locks are held for a long time | |
14:03:40 Checkpoint started | |
14:03:40 Checkpoint finished, log reused | |
20:03:49 Checkpoint started | |
20:03:50 Checkpoint finished, log reused | |
Thu Dec 21 2023 | |
00:03:58 Read wait on column page 87224. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328360. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328362. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328393. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328395. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328397. Waits should be on the index leaf page | |
00:03:58 Read wait on column page 328399. Waits should be on the index leaf page | |
00:03:59 Checkpoint started | |
00:04:00 Checkpoint finished, log reused | |
02:28:35 * Monitor: Locks are held for a long time | |
02:39:15 * Monitor: Locks are held for a long time | |
03:04:07 Checkpoint started | |
03:04:09 Checkpoint finished, log reused | |
03:09:03 * Monitor: Locks are held for a long time | |
09:04:17 Read wait on column page 5757. Waits should be on the index leaf page | |
09:04:17 Read wait on column page 4912. Waits should be on the index leaf page | |
09:04:17 Read wait on column page 87252. Waits should be on the index leaf page | |
09:04:17 Read wait on column page 87254. Waits should be on the index leaf page | |
09:04:17 Read wait on column page 847876. Waits should be on the index leaf page | |
09:04:18 Checkpoint started | |
09:04:18 Checkpoint finished, log reused | |
09:08:40 * Monitor: Locks are held for a long time | |
12:04:24 Checkpoint started | |
12:04:25 Checkpoint finished, log reused | |
15:04:32 Read wait on column page 341904. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17828. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17833. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17836. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17838. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17842. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17845. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17848. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17849. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17852. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17854. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17858. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17859. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17862. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17863. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17864. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17865. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17868. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17869. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17870. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17871. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17872. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17875. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17876. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17877. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17878. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17881. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17883. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17884. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17886. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17887. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17888. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17889. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17890. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17893. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17894. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17895. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17896. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17898. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17899. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17900. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17901. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17902. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17904. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17905. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17906. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17907. Waits should be on the index leaf page | |
15:04:32 Read wait on column page 17908. Waits should be on the index leaf page | |
15:04:33 Checkpoint started | |
15:04:34 Checkpoint finished, log reused | |
21:04:39 Checkpoint started | |
21:04:40 Checkpoint finished, log reused | |
Fri Dec 22 2023 | |
03:04:49 Checkpoint started | |
03:04:50 Checkpoint finished, log reused | |
11:05:05 Checkpoint started | |
11:05:06 Checkpoint finished, log reused | |
12:01:06 * Monitor: Locks are held for a long time | |
12:38:53 * Monitor: Locks are held for a long time | |
19:05:16 Checkpoint started | |
19:05:18 Checkpoint finished, log reused | |
20:06:34 * Monitor: Locks are held for a long time | |
21:13:19 * Monitor: Locks are held for a long time | |
23:05:24 Checkpoint started | |
23:05:24 Checkpoint finished, log reused | |
Sat Dec 23 2023 | |
00:48:31 * Monitor: Locks are held for a long time | |
03:05:31 Checkpoint started | |
03:05:32 Checkpoint finished, log reused | |
08:05:41 Checkpoint started | |
08:05:41 Checkpoint finished, log reused | |
Sun Dec 24 2023 | |
00:06:08 Checkpoint started | |
00:06:09 Checkpoint finished, log reused | |
04:58:25 * Monitor: Locks are held for a long time | |
05:06:17 Checkpoint started | |
05:06:17 Checkpoint finished, log reused | |
09:06:26 Checkpoint started | |
09:06:26 Checkpoint finished, log reused | |
12:56:19 * Monitor: Locks are held for a long time | |
13:06:32 Checkpoint started | |
13:06:32 Checkpoint finished, log reused | |
16:37:56 * Monitor: Locks are held for a long time | |
20:54:27 * Monitor: Locks are held for a long time | |
21:06:47 Checkpoint started | |
21:06:47 Checkpoint finished, log reused | |
23:06:52 Checkpoint started | |
23:06:53 Checkpoint finished, log reused | |
Mon Dec 25 2023 | |
08:07:03 Checkpoint started | |
08:07:04 Checkpoint finished, log reused | |
Tue Dec 26 2023 | |
00:07:29 Checkpoint started | |
00:07:30 Checkpoint finished, log reused | |
08:07:40 Read wait on column page 328359. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 328360. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 328399. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 361481. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 361490. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 361491. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 361500. Waits should be on the index leaf page | |
08:07:40 Read wait on column page 361502. Waits should be on the index leaf page | |
08:07:41 Checkpoint started | |
08:07:41 Checkpoint finished, log reused | |
15:07:54 Checkpoint started | |
15:07:55 Checkpoint finished, log reused | |
23:08:08 Checkpoint started | |
23:08:09 Checkpoint finished, log reused | |
Wed Dec 27 2023 | |
08:08:23 Checkpoint started | |
08:08:24 Checkpoint finished, log reused | |
09:23:28 * Monitor: Locks are held for a long time | |
11:39:06 * Monitor: Locks are held for a long time | |
16:08:35 Checkpoint started | |
16:08:36 Checkpoint finished, log reused | |
23:08:45 Checkpoint started | |
23:08:46 Checkpoint finished, log reused | |
Thu Dec 28 2023 | |
02:52:20 * Monitor: Locks are held for a long time | |
10:09:02 Checkpoint started | |
10:09:02 Checkpoint finished, log reused | |
12:54:45 * Monitor: Locks are held for a long time | |
14:09:09 * Monitor: Locks are held for a long time | |
14:09:10 Checkpoint started | |
14:09:10 Checkpoint finished, log reused | |
14:17:22 * Monitor: Locks are held for a long time | |
16:09:14 Checkpoint started | |
16:09:15 Checkpoint finished, log reused | |
16:09:17 * Monitor: Locks are held for a long time | |
17:14:47 * Monitor: Locks are held for a long time | |
22:09:23 Checkpoint started | |
22:09:24 Checkpoint finished, log reused | |
23:35:02 * Monitor: Locks are held for a long time | |
23:54:37 * Monitor: Locks are held for a long time | |
Fri Dec 29 2023 | |
07:09:34 Checkpoint started | |
07:09:35 Checkpoint finished, log reused | |
09:48:58 * Monitor: Locks are held for a long time | |
13:09:45 Checkpoint started | |
13:09:46 Checkpoint finished, log reused | |
Sat Dec 30 2023 | |
02:10:06 Checkpoint started | |
02:10:07 Checkpoint finished, log reused | |
08:12:46 * Monitor: Locks are held for a long time | |
11:10:19 Checkpoint started | |
11:10:20 Checkpoint finished, log reused | |
21:10:34 Checkpoint started | |
21:10:34 Checkpoint finished, log reused | |
Sun Dec 31 2023 | |
08:10:47 Checkpoint started | |
08:10:48 Checkpoint finished, log reused | |
13:10:57 Checkpoint started | |
13:10:58 Checkpoint finished, log reused | |
16:11:03 Checkpoint started | |
16:11:03 Checkpoint finished, log reused | |
Mon Jan 01 2024 | |
05:11:23 Checkpoint started | |
05:11:24 Checkpoint finished, log reused | |
13:11:35 Checkpoint started | |
13:11:35 Checkpoint finished, log reused | |
20:11:54 Checkpoint started | |
20:11:54 Checkpoint finished, log reused | |
Tue Jan 02 2024 | |
00:11:59 Checkpoint started | |
00:12:00 Checkpoint finished, log reused | |
03:12:08 Checkpoint started | |
03:12:08 Checkpoint finished, log reused | |
09:12:17 Checkpoint started | |
09:12:17 Checkpoint finished, log reused | |
12:12:27 Checkpoint started | |
12:12:28 Checkpoint finished, log reused | |
16:12:34 Read wait on column page 4992. Waits should be on the index leaf page | |
16:12:34 Read wait on column page 5700. Waits should be on the index leaf page | |
16:12:34 Read wait on column page 87238. Waits should be on the index leaf page | |
16:12:34 Read wait on column page 66949. Waits should be on the index leaf page | |
16:12:35 Checkpoint started | |
16:12:36 Checkpoint finished, log reused | |
19:12:39 Checkpoint started | |
19:12:40 Checkpoint finished, log reused | |
22:12:47 Checkpoint started | |
22:12:48 Checkpoint finished, log reused | |
Wed Jan 03 2024 | |
01:12:52 Checkpoint started | |
01:12:52 Checkpoint finished, log reused | |
04:13:00 Checkpoint started | |
04:13:01 Checkpoint finished, log reused | |
07:13:06 Checkpoint started | |
07:13:07 Checkpoint finished, log reused | |
07:15:24 * Monitor: Locks are held for a long time | |
07:34:23 * Monitor: Locks are held for a long time | |
10:13:12 Checkpoint started | |
10:13:13 Checkpoint finished, log reused | |
16:56:46 * Monitor: Locks are held for a long time | |
17:13:23 Checkpoint started | |
17:13:24 Checkpoint finished, log reused | |
Thu Jan 04 2024 | |
06:13:40 Read wait on column page 66932. Waits should be on the index leaf page | |
06:13:41 Checkpoint started | |
06:13:42 Checkpoint finished, log reused | |
09:53:45 * Monitor: Locks are held for a long time | |
12:13:52 Checkpoint started | |
12:13:53 Checkpoint finished, log reused | |
16:13:59 Checkpoint started | |
16:13:59 Checkpoint finished, log reused | |
16:42:03 * Monitor: Locks are held for a long time | |
19:14:06 Checkpoint started | |
19:14:07 Checkpoint finished, log reused | |
20:21:30 * Monitor: Locks are held for a long time | |
Fri Jan 05 2024 | |
02:14:18 Checkpoint started | |
02:14:19 Checkpoint finished, log reused | |
08:40:08 * Monitor: Locks are held for a long time | |
10:14:29 Checkpoint started | |
10:14:29 Checkpoint finished, log reused | |
17:14:39 Checkpoint started | |
17:14:39 Checkpoint finished, log reused | |
23:14:44 Checkpoint started | |
23:14:44 Checkpoint finished, log reused | |
Sat Jan 06 2024 | |
05:14:54 Checkpoint started | |
05:14:55 Checkpoint finished, log reused | |
10:15:03 Checkpoint started | |
10:15:04 Checkpoint finished, log reused | |
17:15:13 Checkpoint started | |
17:15:14 Checkpoint finished, log reused | |
22:15:24 Checkpoint started | |
22:15:25 Checkpoint finished, log reused | |
Sun Jan 07 2024 | |
07:15:39 Checkpoint started | |
07:15:40 Checkpoint finished, log reused | |
16:15:57 Checkpoint started | |
16:15:58 Checkpoint finished, log reused | |
Mon Jan 08 2024 | |
00:16:06 Checkpoint started | |
00:16:06 Checkpoint finished, log reused | |
02:22:04 * Monitor: Locks are held for a long time | |
02:54:34 * Monitor: Locks are held for a long time | |
08:16:20 Checkpoint started | |
08:16:21 Checkpoint finished, log reused | |
12:55:01 * Monitor: Locks are held for a long time | |
14:16:32 Checkpoint started | |
14:16:33 Checkpoint finished, log reused | |
16:29:54 * Monitor: Locks are held for a long time | |
23:16:44 Read wait on column page 4911. Waits should be on the index leaf page | |
23:16:44 Read wait on column page 106132. Waits should be on the index leaf page | |
23:16:44 Read wait on column page 106134. Waits should be on the index leaf page | |
23:16:44 Checkpoint started | |
23:16:45 Checkpoint finished, log reused | |
Tue Jan 09 2024 | |
06:16:57 Checkpoint started | |
06:16:58 Checkpoint finished, log reused | |
11:17:08 Checkpoint started | |
11:17:08 Checkpoint finished, log reused | |
17:17:19 Checkpoint started | |
17:17:20 Checkpoint finished, log reused | |
Wed Jan 10 2024 | |
01:17:37 * Monitor: Locks are held for a long time | |
03:17:36 Checkpoint started | |
03:17:37 Checkpoint finished, log reused | |
06:36:37 * Monitor: Locks are held for a long time | |
09:00:56 * Monitor: Locks are held for a long time | |
10:17:51 Checkpoint started | |
10:17:52 Checkpoint finished, log reused | |
10:48:53 * Monitor: Locks are held for a long time | |
13:51:37 * Monitor: Locks are held for a long time | |
13:52:22 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
13:52:22 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (2) | |
14:01:46 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (1) | |
14:01:46 * Monitor: Should read for update because lock escalation from shared to exclusive fails frequently (2) | |
14:18:01 Checkpoint started | |
14:18:02 Checkpoint finished, log reused | |
14:20:20 * Monitor: Locks are held for a long time | |
15:07:22 * Monitor: Locks are held for a long time | |
16:18:07 Read wait on column page 106136. Waits should be on the index leaf page | |
16:18:07 Read wait on column page 361492. Waits should be on the index leaf page | |
16:18:07 Read wait on column page 361495. Waits should be on the index leaf page | |
16:18:07 Read wait on column page 328332. Waits should be on the index leaf page | |
16:18:08 Checkpoint started | |
16:18:09 Checkpoint finished, log reused | |
16:46:16 * Monitor: Locks are held for a long time |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment