Skip to content

Instantly share code, notes, and snippets.

@H-Kwon
Created January 10, 2024 16:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save H-Kwon/e3c7fb25c55a57df57579efbebc5671c to your computer and use it in GitHub Desktop.
Save H-Kwon/e3c7fb25c55a57df57579efbebc5671c to your computer and use it in GitHub Desktop.
20240110-virtuoso_prod.log
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