[GH-ISSUE #2222] Request Analytics panel shows no data despite active traffic #32171

Open
opened 2026-06-15 09:29:20 -05:00 by GiteaMirror · 18 comments
Owner

Originally created by @blakey108 on GitHub (Jan 7, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/2222

Originally assigned to: @oschwartz10612 on GitHub.

Describe the Bug

The Request Analytics view in Pangolin reports zero requests across all metrics despite active services and confirmed inbound traffic. Analytics appear to have stopped populating entirely.

Image

Environment

OS Type & Version: Ubuntu 22.04 LTS
Pangolin Version: fosrl/pangolin:ee-latest
Gerbil Version: fosrl/gerbil:latest
Traefik Version: traefik:v3.4.0
Newt Version: 1.8.1

To Reproduce

Deploy Pangolin stack with Traefik, Gerbil, Newt, CrowdSec, and middleware-manager.

Expose multiple services through Pangolin.

Generate inbound traffic to exposed services (confirmed via application access and Traefik logs).

Navigate to Request Analytics in Pangolin UI.

Set a broad date range and select “All resources”.

Refresh analytics.

Expected Behavior

Request Analytics should display non-zero request counts, daily activity graphs, and geographic breakdowns corresponding to inbound traffic.

Originally created by @blakey108 on GitHub (Jan 7, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/2222 Originally assigned to: @oschwartz10612 on GitHub. ### Describe the Bug The Request Analytics view in Pangolin reports zero requests across all metrics despite active services and confirmed inbound traffic. Analytics appear to have stopped populating entirely. <img width="850" height="1246" alt="Image" src="https://github.com/user-attachments/assets/c17db2d9-7b5d-4336-8120-184059c902ae" /> ### Environment OS Type & Version: Ubuntu 22.04 LTS Pangolin Version: fosrl/pangolin:ee-latest Gerbil Version: fosrl/gerbil:latest Traefik Version: traefik:v3.4.0 Newt Version: 1.8.1 ### To Reproduce Deploy Pangolin stack with Traefik, Gerbil, Newt, CrowdSec, and middleware-manager. Expose multiple services through Pangolin. Generate inbound traffic to exposed services (confirmed via application access and Traefik logs). Navigate to Request Analytics in Pangolin UI. Set a broad date range and select “All resources”. Refresh analytics. ### Expected Behavior Request Analytics should display non-zero request counts, daily activity graphs, and geographic breakdowns corresponding to inbound traffic.
GiteaMirror added the needs investigating label 2026-06-15 09:29:20 -05:00
Author
Owner

@Latschenharry commented on GitHub (Jan 19, 2026):

Same Problem for me

<!-- gh-comment-id:3767082150 --> @Latschenharry commented on GitHub (Jan 19, 2026): Same Problem for me
Author
Owner

@oschwartz10612 commented on GitHub (Jan 20, 2026):

Just checking some obvious things first:

  • In the org settings is the request log retention set to something not disabled?
  • Does anything show up in the log table but not the analytics?
  • If you make the time period smaller does it show anything?
<!-- gh-comment-id:3771078995 --> @oschwartz10612 commented on GitHub (Jan 20, 2026): Just checking some obvious things first: * In the org settings is the request log retention set to something not disabled? * Does anything show up in the log table but not the analytics? * If you make the time period smaller does it show anything?
Author
Owner

@Latschenharry commented on GitHub (Jan 20, 2026):

Log Settings:
Image
Both Logs and analytics show no entrys even for short time period:

Image Image
<!-- gh-comment-id:3771545929 --> @Latschenharry commented on GitHub (Jan 20, 2026): Log Settings: <img width="644" height="304" alt="Image" src="https://github.com/user-attachments/assets/c2282e8e-325c-46e2-840f-d6b186487c4c" /> Both Logs and analytics show no entrys even for short time period: <img width="1140" height="316" alt="Image" src="https://github.com/user-attachments/assets/54baa621-e95c-4e9d-b135-5e90f58c9806" /> <img width="1060" height="324" alt="Image" src="https://github.com/user-attachments/assets/522ca685-1bac-459f-89a1-89837c61de58" />
Author
Owner

@oschwartz10612 commented on GitHub (Jan 20, 2026):

Hum... thanks! One more request: could you let me know if you see anything unusual in your pangolin logs? It may also be helpful to turn on debug in config.yml and restart to see if it says anything about request logs.

<!-- gh-comment-id:3774199939 --> @oschwartz10612 commented on GitHub (Jan 20, 2026): Hum... thanks! One more request: could you let me know if you see anything unusual in your pangolin logs? It may also be helpful to turn on debug in `config.yml` and restart to see if it says anything about request logs.
Author
Owner

@Latschenharry commented on GitHub (Jan 20, 2026):

With Debug on i can see the following error in the pangolin container logs:

Image
<!-- gh-comment-id:3775011738 --> @Latschenharry commented on GitHub (Jan 20, 2026): With Debug on i can see the following error in the pangolin container logs: <img width="817" height="201" alt="Image" src="https://github.com/user-attachments/assets/ae226e75-e171-444d-97ba-14f1fa4ca3a4" />
Author
Owner

@oschwartz10612 commented on GitHub (Jan 20, 2026):

It looks like you might have a corrupted database. Are you able to
perform other actions in pangolin like adding a site or changing settings?

Is your disk full by chance? - Just wanted to check.

<!-- gh-comment-id:3775324184 --> @oschwartz10612 commented on GitHub (Jan 20, 2026): It looks like you might have a corrupted database. Are you able to perform other actions in pangolin like adding a site or changing settings? Is your disk full by chance? - Just wanted to check.
Author
Owner

@Latschenharry commented on GitHub (Jan 21, 2026):

Storage is free:
Image

Changing Settings and adding a new site works without problems:
Image

<!-- gh-comment-id:3776795816 --> @Latschenharry commented on GitHub (Jan 21, 2026): Storage is free: <img width="748" height="132" alt="Image" src="https://github.com/user-attachments/assets/5c22eb53-53b4-4b1b-a9ac-7554bffa49fb" /> Changing Settings and adding a new site works without problems: <img width="1080" height="258" alt="Image" src="https://github.com/user-attachments/assets/113fd9d2-694e-435f-a2d7-eef6cce26aaf" />
Author
Owner

@oschwartz10612 commented on GitHub (Jan 21, 2026):

Hum maybe this table is corrupted only? Will do some research to see if
there is a remediation or cause.

<!-- gh-comment-id:3780059194 --> @oschwartz10612 commented on GitHub (Jan 21, 2026): Hum maybe this table is corrupted only? Will do some research to see if there is a remediation or cause.
Author
Owner

@Latschenharry commented on GitHub (Jan 23, 2026):

Found the following in the database:

Image
<!-- gh-comment-id:3792945599 --> @Latschenharry commented on GitHub (Jan 23, 2026): Found the following in the database: <img width="550" height="106" alt="Image" src="https://github.com/user-attachments/assets/a9a8297a-4eb3-41a8-bb8f-1e590375f1d7" />
Author
Owner

@Latschenharry commented on GitHub (Jan 23, 2026):

i fixed my errors by opening the sqlite file in "DB Browser for SQlite" exporting it as sql and then importing it back into an sqlite file. now there are no coruption errors anymore and i got analytic logs:

Image
<!-- gh-comment-id:3792970086 --> @Latschenharry commented on GitHub (Jan 23, 2026): i fixed my errors by opening the sqlite file in "DB Browser for SQlite" exporting it as sql and then importing it back into an sqlite file. now there are no coruption errors anymore and i got analytic logs: <img width="1558" height="1196" alt="Image" src="https://github.com/user-attachments/assets/5c46af95-053a-4fb6-94a9-ddba2b095488" />
Author
Owner

@brunoaferreira commented on GitHub (Feb 5, 2026):

Getting the same, when I request Analytics. Cant see anything on the table

<!-- gh-comment-id:3856592693 --> @brunoaferreira commented on GitHub (Feb 5, 2026): Getting the same, when I request Analytics. Cant see anything on the table
Author
Owner

@oschwartz10612 commented on GitHub (Feb 6, 2026):

Apparently this is an index problem. Re importing the database reset the indexes. I will see if I can tell what causes this.

<!-- gh-comment-id:3861908985 --> @oschwartz10612 commented on GitHub (Feb 6, 2026): Apparently this is an index problem. Re importing the database reset the indexes. I will see if I can tell what causes this.
Author
Owner

@oschwartz10612 commented on GitHub (Feb 6, 2026):

Getting the same, when I request Analytics. Cant see anything on the table

Are you getting the same error in the logs?

<!-- gh-comment-id:3861911250 --> @oschwartz10612 commented on GitHub (Feb 6, 2026): > Getting the same, when I request Analytics. Cant see anything on the table Are you getting the same error in the logs?
Author
Owner

@brunoaferreira commented on GitHub (Feb 6, 2026):

I ran my sqlite on DB Browser for SQLite and integrity check says ok.

Image

To solve this issue, I updated my pagonlin to use postgres instead of sqlite

<!-- gh-comment-id:3861972216 --> @brunoaferreira commented on GitHub (Feb 6, 2026): I ran my sqlite on DB Browser for SQLite and integrity check says `ok`. <img width="150" height="80" alt="Image" src="https://github.com/user-attachments/assets/74fe425a-841e-4572-9883-d6cfa368e14b" /> To solve this issue, I updated my pagonlin to use postgres instead of sqlite
Author
Owner

@oschwartz10612 commented on GitHub (Feb 6, 2026):

I tried to fix in ac09e3aaf9. Will see for the next release.

For future travelers you could try the following:

sqlite3 config/db/db.sqlite "PRAGMA integrity_check;"

if thats bad then

sqlite3 config/db/db.sqlite "REINDEX idx_requestAuditLog_timestamp"
sqlite3 config/db/db.sqlite "REINDEX idx_requestAuditLog_org_timestamp"
<!-- gh-comment-id:3862053750 --> @oschwartz10612 commented on GitHub (Feb 6, 2026): I tried to fix in ac09e3aaf99bf16c3a65ad64f10d34193f76bab1. Will see for the next release. For future travelers you could try the following: ``` sqlite3 config/db/db.sqlite "PRAGMA integrity_check;" ``` if thats bad then ``` sqlite3 config/db/db.sqlite "REINDEX idx_requestAuditLog_timestamp" sqlite3 config/db/db.sqlite "REINDEX idx_requestAuditLog_org_timestamp" ```
Author
Owner

@gmcouto commented on GitHub (Mar 14, 2026):

Here I get some basic data, but otherwise it is mostly empty. When I hover countries they just get colored but no additional data shows up

Image

This is me hovering US...
Image

If I wiggle the mouse over all the countries they all get highlighted:

Image Image
<!-- gh-comment-id:4060992384 --> @gmcouto commented on GitHub (Mar 14, 2026): Here I get some basic data, but otherwise it is mostly empty. When I hover countries they just get colored but no additional data shows up <img width="1633" height="1270" alt="Image" src="https://github.com/user-attachments/assets/01089931-183c-4ae1-9bc3-760ef510fe69" /> This is me hovering US... <img width="794" height="628" alt="Image" src="https://github.com/user-attachments/assets/1e15a740-18ae-490f-9ce5-90c5ad3fab48" /> If I wiggle the mouse over all the countries they all get highlighted: <img width="782" height="647" alt="Image" src="https://github.com/user-attachments/assets/5a7733c7-c04f-4058-9ce1-d8243f56a1de" /> <img width="1587" height="1252" alt="Image" src="https://github.com/user-attachments/assets/af515683-f6f7-47d8-ad0a-61be6588a658" />
Author
Owner

@wan0v commented on GitHub (Apr 29, 2026):

@gmcouto I have had the same issue with no countries showing up. I am using pangolin since way before they have added that section. After setting up geo blocking as stated in the guide https://docs.pangolin.net/self-host/advanced/enable-geoblocking the countries showed up (which makes a lot of sense tbh).

<!-- gh-comment-id:4343505027 --> @wan0v commented on GitHub (Apr 29, 2026): @gmcouto I have had the same issue with no countries showing up. I am using pangolin since way before they have added that section. After setting up geo blocking as stated in the guide https://docs.pangolin.net/self-host/advanced/enable-geoblocking the countries showed up (which makes a lot of sense tbh).
Author
Owner

@AstralDestiny commented on GitHub (Apr 29, 2026):

You have geoblocking / asn enabled? if not they don't show up data wise as they have no point of reference.

<!-- gh-comment-id:4343570622 --> @AstralDestiny commented on GitHub (Apr 29, 2026): You have geoblocking / asn enabled? if not they don't show up data wise as they have no point of reference.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#32171