chore(cleanup): maybe_create_hypertable #971

New issue

Closed

opened 2026-03-28 04:30:23 +00:00 by mfreeman451 · 1 comment

mfreeman451 commented

2026-03-28 04:30:23 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2726
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2726
Original created: 2026-02-07T00:35:20Z

Describe the bug
Not sure why we have this, we will never not have timescale extension.

  - platform.ocsf_network_activity is created in elixir/serviceradar_core/priv/repo/migrations/20260201072922_create_ocsf_network_activity.exs.
  - It’s created as a normal table, then maybe_create_hypertable/2 converts it to a TimescaleDB hypertable when the timescaledb extension is present.
  - time is TIMESTAMPTZ NOT NULL, which matches how we’re querying in SRQL.

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2726 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2726 Original created: 2026-02-07T00:35:20Z --- **Describe the bug** Not sure why we have this, we will never not have timescale extension. ``` - platform.ocsf_network_activity is created in elixir/serviceradar_core/priv/repo/migrations/20260201072922_create_ocsf_network_activity.exs. - It’s created as a normal table, then maybe_create_hypertable/2 converts it to a TimescaleDB hypertable when the timescaledb extension is present. - time is TIMESTAMPTZ NOT NULL, which matches how we’re querying in SRQL. ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.

mfreeman451 commented

2026-03-28 04:30:24 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2726#issuecomment-4145559544
Original created: 2026-03-27T21:53:27Z

closing, stale

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2726#issuecomment-4145559544 Original created: 2026-03-27T21:53:27Z --- closing, stale