All of a sudden Journey Report not generating

[imjustleaving]

Describe the Bug

Since the update in late february, when I try to generate a journey report the button just spins and doest do anything. I was able to generate these reports before with no problem, but now it does nothing. Logs show nothing relevant in terms of errors.

Database

PostgreSQL

Relevant log output

yarn run v1.22.22
$ npm-run-all check-db update-tracker start-server
$ node scripts/check-db.js
✓ DATABASE_URL is defined.
✓ Database connection successful.
✓ Database version check successful.
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "umami", schema "public" at "db:5432"
7 migrations found in prisma/migrations
No pending migrations to apply.
✓ Database is up to date.
$ node scripts/update-tracker.js
$ node server.js
   ▲ Next.js 15.0.4
   - Local:        http://localhost:3000
   - Network:      http://0.0.0.0:3000
 ✓ Starting...
 ✓ Ready in 70ms
2025-03-04 15:30:49.318 UTC [26] LOG:  checkpoint complete: wrote 34 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.312 s, sync=0.171 s, total=3.528 s; sync files=31, longest=0.023 s, average=0.006 s; distance=175 kB, estimate=365 kB
2025-03-04 15:35:45.415 UTC [26] LOG:  checkpoint starting: time
2025-03-04 15:35:48.803 UTC [26] LOG:  checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 1 recycled; write=3.011 s, sync=0.320 s, total=3.388 s; sync files=31, longest=0.018 s, average=0.011 s; distance=171 kB, estimate=345 kB
2025-03-04 15:40:45.903 UTC [26] LOG:  checkpoint starting: time
2025-03-04 15:40:47.912 UTC [26] LOG:  checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.707 s, sync=0.180 s, total=2.009 s; sync files=16, longest=0.019 s, average=0.012 s; distance=95 kB, estimate=320 kB
2025-03-04 15:45:46.011 UTC [26] LOG:  checkpoint starting: time
2025-03-04 15:45:51.860 UTC [26] LOG:  checkpoint complete: wrote 57 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.617 s, sync=0.187 s, total=5.850 s; sync files=31, longest=0.023 s, average=0.007 s; distance=316 kB, estimate=320 kB
2025-03-04 16:05:47.256 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:05:51.925 UTC [26] LOG:  checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.113 s, sync=0.355 s, total=4.670 s; sync files=31, longest=0.023 s, average=0.012 s; distance=228 kB, estimate=311 kB
2025-03-04 16:10:48.023 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:10:55.145 UTC [26] LOG:  checkpoint complete: wrote 64 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.322 s, sync=0.753 s, total=7.122 s; sync files=31, longest=0.135 s, average=0.025 s; distance=352 kB, estimate=352 kB
2025-03-04 16:15:48.243 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:15:49.976 UTC [26] LOG:  checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.506 s, sync=0.177 s, total=1.733 s; sync files=16, longest=0.020 s, average=0.012 s; distance=85 kB, estimate=325 kB
2025-03-04 16:20:49.076 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:20:53.959 UTC [26] LOG:  checkpoint complete: wrote 47 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.615 s, sync=0.062 s, total=4.884 s; sync files=31, longest=0.051 s, average=0.002 s; distance=262 kB, estimate=319 kB
2025-03-04 16:25:50.050 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:25:57.128 UTC [26] LOG:  checkpoint complete: wrote 70 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.921 s, sync=0.057 s, total=7.079 s; sync files=31, longest=0.027 s, average=0.002 s; distance=409 kB, estimate=409 kB
2025-03-04 16:30:50.228 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:30:53.528 UTC [26] LOG:  checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.011 s, sync=0.088 s, total=3.301 s; sync files=31, longest=0.076 s, average=0.003 s; distance=173 kB, estimate=386 kB
2025-03-04 16:35:50.623 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:35:59.145 UTC [26] LOG:  checkpoint complete: wrote 82 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.126 s, sync=0.290 s, total=8.522 s; sync files=32, longest=0.213 s, average=0.010 s; distance=473 kB, estimate=473 kB
2025-03-04 16:40:50.232 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:41:02.767 UTC [26] LOG:  checkpoint complete: wrote 125 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=12.437 s, sync=0.051 s, total=12.535 s; sync files=31, longest=0.028 s, average=0.002 s; distance=751 kB, estimate=751 kB
2025-03-04 16:45:50.867 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:45:57.664 UTC [26] LOG:  checkpoint complete: wrote 67 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.621 s, sync=0.120 s, total=6.797 s; sync files=31, longest=0.022 s, average=0.004 s; distance=405 kB, estimate=717 kB
2025-03-04 16:50:50.764 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:50:57.220 UTC [26] LOG:  checkpoint complete: wrote 57 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.619 s, sync=0.595 s, total=6.456 s; sync files=31, longest=0.110 s, average=0.020 s; distance=333 kB, estimate=678 kB
2025-03-04 16:55:50.319 UTC [26] LOG:  checkpoint starting: time
2025-03-04 16:55:53.490 UTC [26] LOG:  checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.909 s, sync=0.212 s, total=3.171 s; sync files=16, longest=0.022 s, average=0.014 s; distance=165 kB, estimate=627 kB
2025-03-04 17:00:50.547 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:00:53.252 UTC [26] LOG:  checkpoint complete: wrote 26 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.509 s, sync=0.147 s, total=2.706 s; sync files=16, longest=0.025 s, average=0.010 s; distance=134 kB, estimate=578 kB
2025-03-04 17:05:50.351 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:05:52.792 UTC [26] LOG:  checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.208 s, sync=0.182 s, total=2.441 s; sync files=16, longest=0.021 s, average=0.012 s; distance=123 kB, estimate=532 kB
2025-03-04 17:10:50.870 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:10:53.051 UTC [26] LOG:  checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.907 s, sync=0.186 s, total=2.182 s; sync files=16, longest=0.021 s, average=0.012 s; distance=106 kB, estimate=490 kB
2025-03-04 17:15:50.147 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:15:51.868 UTC [26] LOG:  checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.506 s, sync=0.166 s, total=1.721 s; sync files=16, longest=0.015 s, average=0.011 s; distance=82 kB, estimate=449 kB
2025-03-04 17:20:50.967 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:21:02.671 UTC [26] LOG:  checkpoint complete: wrote 116 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.540 s, sync=0.108 s, total=11.704 s; sync files=32, longest=0.029 s, average=0.004 s; distance=674 kB, estimate=674 kB
2025-03-04 17:25:50.763 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:25:53.575 UTC [26] LOG:  checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.610 s, sync=0.154 s, total=2.812 s; sync files=16, longest=0.021 s, average=0.010 s; distance=131 kB, estimate=619 kB
2025-03-04 17:30:50.675 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:30:56.355 UTC [26] LOG:  checkpoint complete: wrote 56 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.517 s, sync=0.114 s, total=5.680 s; sync files=31, longest=0.023 s, average=0.004 s; distance=319 kB, estimate=589 kB
2025-03-04 17:35:50.455 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:35:56.827 UTC [26] LOG:  checkpoint complete: wrote 62 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.120 s, sync=0.109 s, total=6.373 s; sync files=31, longest=0.067 s, average=0.004 s; distance=336 kB, estimate=564 kB
2025-03-04 17:40:50.927 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:40:59.273 UTC [26] LOG:  checkpoint complete: wrote 81 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.026 s, sync=0.134 s, total=8.347 s; sync files=31, longest=0.024 s, average=0.005 s; distance=486 kB, estimate=556 kB
2025-03-04 17:50:50.471 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:50:52.760 UTC [26] LOG:  checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.107 s, sync=0.134 s, total=2.289 s; sync files=16, longest=0.069 s, average=0.009 s; distance=119 kB, estimate=512 kB
2025-03-04 17:55:50.860 UTC [26] LOG:  checkpoint starting: time
2025-03-04 17:55:57.429 UTC [26] LOG:  checkpoint complete: wrote 63 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.379 s, sync=0.142 s, total=6.570 s; sync files=31, longest=0.024 s, average=0.005 s; distance=359 kB, estimate=497 kB
2025-03-04 18:00:50.518 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:00:53.326 UTC [26] LOG:  checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.609 s, sync=0.112 s, total=2.808 s; sync files=16, longest=0.021 s, average=0.007 s; distance=153 kB, estimate=463 kB
2025-03-04 18:05:50.426 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:06:00.315 UTC [26] LOG:  checkpoint complete: wrote 98 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.731 s, sync=0.054 s, total=9.890 s; sync files=32, longest=0.043 s, average=0.002 s; distance=565 kB, estimate=565 kB
2025-03-04 18:10:50.413 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:10:54.259 UTC [26] LOG:  checkpoint complete: wrote 37 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.611 s, sync=0.183 s, total=3.846 s; sync files=16, longest=0.024 s, average=0.012 s; distance=188 kB, estimate=527 kB
2025-03-04 18:15:50.337 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:15:56.483 UTC [26] LOG:  checkpoint complete: wrote 60 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.919 s, sync=0.161 s, total=6.147 s; sync files=31, longest=0.032 s, average=0.006 s; distance=338 kB, estimate=508 kB
2025-03-04 18:20:50.580 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:20:55.858 UTC [26] LOG:  checkpoint complete: wrote 51 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.017 s, sync=0.221 s, total=5.278 s; sync files=32, longest=0.150 s, average=0.007 s; distance=267 kB, estimate=484 kB
2025-03-04 18:25:50.898 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:25:53.529 UTC [26] LOG:  checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.108 s, sync=0.375 s, total=2.631 s; sync files=16, longest=0.199 s, average=0.024 s; distance=104 kB, estimate=446 kB
2025-03-04 18:30:50.607 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:30:53.723 UTC [26] LOG:  checkpoint complete: wrote 29 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.810 s, sync=0.184 s, total=3.117 s; sync files=16, longest=0.021 s, average=0.012 s; distance=144 kB, estimate=416 kB
2025-03-04 18:35:50.823 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:35:56.329 UTC [26] LOG:  checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.118 s, sync=0.141 s, total=5.506 s; sync files=31, longest=0.078 s, average=0.005 s; distance=295 kB, estimate=404 kB
2025-03-04 18:40:50.427 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:40:55.159 UTC [26] LOG:  checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.421 s, sync=0.186 s, total=4.732 s; sync files=31, longest=0.145 s, average=0.006 s; distance=257 kB, estimate=389 kB
2025-03-04 18:45:50.259 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:45:56.060 UTC [26] LOG:  checkpoint complete: wrote 55 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.428 s, sync=0.289 s, total=5.802 s; sync files=31, longest=0.030 s, average=0.010 s; distance=325 kB, estimate=383 kB
2025-03-04 18:50:50.159 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:50:55.485 UTC [26] LOG:  checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.126 s, sync=0.123 s, total=5.326 s; sync files=31, longest=0.022 s, average=0.004 s; distance=286 kB, estimate=373 kB
2025-03-04 18:55:50.583 UTC [26] LOG:  checkpoint starting: time
2025-03-04 18:55:55.196 UTC [26] LOG:  checkpoint complete: wrote 43 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.215 s, sync=0.348 s, total=4.613 s; sync files=31, longest=0.021 s, average=0.012 s; distance=251 kB, estimate=361 kB
2025-03-04 19:00:50.296 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:00:55.825 UTC [26] LOG:  checkpoint complete: wrote 54 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.320 s, sync=0.160 s, total=5.530 s; sync files=31, longest=0.034 s, average=0.006 s; distance=317 kB, estimate=356 kB
2025-03-04 19:05:50.923 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:05:53.782 UTC [26] LOG:  checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.609 s, sync=0.204 s, total=2.859 s; sync files=17, longest=0.031 s, average=0.012 s; distance=147 kB, estimate=335 kB
2025-03-04 19:10:50.872 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:10:57.788 UTC [26] LOG:  checkpoint complete: wrote 59 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.820 s, sync=0.904 s, total=6.916 s; sync files=31, longest=0.310 s, average=0.030 s; distance=334 kB, estimate=335 kB
2025-03-04 19:12:26.580 UTC [33288] ERROR:  duplicate key value violates unique constraint "session_pkey"
2025-03-04 19:12:26.580 UTC [33288] DETAIL:  Key (session_id)=(3d3b7b8b-7ea5-5b47-a78e-a51499f4ff0d) already exists.
2025-03-04 19:12:26.580 UTC [33288] STATEMENT:  INSERT INTO "public"."session" ("session_id","website_id","hostname","browser","os","device","screen","language","country","city","created_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING "public"."session"."session_id", "public"."session"."website_id", "public"."session"."hostname", "public"."session"."browser", "public"."session"."os", "public"."session"."device", "public"."session"."screen", "public"."session"."language", "public"."session"."country", "public"."session"."subdivision1", "public"."session"."subdivision2", "public"."session"."city", "public"."session"."created_at"
2025-03-04 19:15:50.888 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:15:57.213 UTC [26] LOG:  checkpoint complete: wrote 62 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.121 s, sync=0.155 s, total=6.325 s; sync files=31, longest=0.023 s, average=0.005 s; distance=347 kB, estimate=347 kB
2025-03-04 19:20:50.311 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:20:57.487 UTC [26] LOG:  checkpoint complete: wrote 71 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.024 s, sync=0.096 s, total=7.176 s; sync files=31, longest=0.048 s, average=0.004 s; distance=434 kB, estimate=434 kB
2025-03-04 19:25:50.586 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:25:57.784 UTC [26] LOG:  checkpoint complete: wrote 70 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.921 s, sync=0.225 s, total=7.198 s; sync files=31, longest=0.047 s, average=0.008 s; distance=423 kB, estimate=433 kB
2025-03-04 19:30:50.883 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:30:54.490 UTC [26] LOG:  checkpoint complete: wrote 32 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.113 s, sync=0.289 s, total=3.607 s; sync files=16, longest=0.087 s, average=0.019 s; distance=179 kB, estimate=408 kB
2025-03-04 19:35:50.587 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:35:56.053 UTC [26] LOG:  checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.217 s, sync=0.087 s, total=5.466 s; sync files=16, longest=0.087 s, average=0.006 s; distance=304 kB, estimate=398 kB
2025-03-04 19:40:50.153 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:40:56.554 UTC [26] LOG:  checkpoint complete: wrote 63 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.219 s, sync=0.132 s, total=6.401 s; sync files=32, longest=0.083 s, average=0.005 s; distance=373 kB, estimate=395 kB
2025-03-04 19:45:50.651 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:45:55.049 UTC [26] LOG:  checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.114 s, sync=0.233 s, total=4.398 s; sync files=31, longest=0.024 s, average=0.008 s; distance=239 kB, estimate=379 kB
2025-03-04 19:50:50.149 UTC [26] LOG:  checkpoint starting: time
2025-03-04 19:50:55.304 UTC [26] LOG:  checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.716 s, sync=0.208 s, total=5.156 s; sync files=31, longest=0.145 s, average=0.007 s; distance=282 kB, estimate=370 kB

Which Umami version are you using? (if relevant)

No response

Which browser are you using? (if relevant)

No response

How are you deploying your application? (if relevant)

No response

[franciscao633]

Do you experience the same issue when you create a new journey report? I think I've seen this issue with very old saved reports, but have not got around to the root cause of it. If the new report works, just save that one and delete the old one.