Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: sql: Scan error on column index 5, name "usedPercent": converting NULL to float64 is unsupported #4309

Open
PolpOnline opened this issue Nov 15, 2024 · 4 comments
Open

[Bug]: sql: Scan error on column index 5, name "usedPercent": converting NULL to float64 is unsupported #4309

PolpOnline opened this issue Nov 15, 2024 · 4 comments
Labels
🐛 Bug Reported issues that need to be reproduced by the team.
Milestone
v4.0.0 Stable Rel...

Comments

@PolpOnline
Copy link

Error Message and Logs

sql: Scan error on column index 5, name "usedPercent": converting NULL to float64 is unsupported

Steps to Reproduce

  1. Go to metrics page on any service with data less than the selected date.
  2. Select an amount of time that is greater than the data available.

Example Repository URL

No response

Coolify Version

v4.0.0-beta.369

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Debian GNU/Linux 12 (bookworm)

Additional Information

No response
@PolpOnline PolpOnline added 🐛 Bug Reported issues that need to be reproduced by the team. 🔍 Triage Issues that need assessment and prioritization. labels Nov 15, 2024
@peaklabs-dev
Copy link
Member

I am unable to reproduce this error. Maybe you can make a short video so I can better see what is going on.

@peaklabs-dev peaklabs-dev added 💤 Waiting for feedback Issues awaiting a response from the author. and removed 🔍 Triage Issues that need assessment and prioritization. labels Nov 21, 2024
@peaklabs-dev peaklabs-dev added this to the v4.0.0 Stable Release milestone Nov 21, 2024
@ldenblyd
Copy link

i have the same issue when i try to deploy a nodejs app with nixpacks

@PolpOnline
Copy link
Author

PolpOnline commented Nov 22, 2024 •
edited
Loading

Sorry for the late reply

output.mp4

@peaklabs-dev peaklabs-dev removed the 💤 Waiting for feedback Issues awaiting a response from the author. label Nov 22, 2024
@GodGMN
Copy link

GodGMN commented Nov 23, 2024 •
edited
Loading

Same there. I started getting this when I redeployed a container and it failed, rolling back to the previous one. The metrics were set to last 5 minutes, but there was no data yet, and this started popping every few seconds. I am not 100% confident in the origin of the error though, but I can say I do have the metrics activated too and that they don't load so it seems like the error is coming from there.

Image

Edit: five minutes have passed (notice the time in the tray) and it did stop popping up and it started showing data. Seems like that was indeed the cause.

Image

vishwamartur added a commit to vishwamartur/coolify that referenced this issue Nov 23, 2024
@vishwamartur
Fix metrics error when data is less than selected date
f45411f 
Related to coollabsio#4309

Fix the 'sql: Scan error on column index 5, name "usedPercent": converting NULL to float64 is unsupported' error on the metrics page.

* Update the `getMemoryMetrics` method in `app/Models/Server.php` to handle NULL values for the "usedPercent" field by setting them to 0.0.
* Add a check for NULL values in the `getMemoryMetrics` method before converting to float64.
@vishwamartur vishwamartur mentioned this issue Nov 23, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
🐛 Bug Reported issues that need to be reproduced by the team.
Projects
None yet
Milestone
v4.0.0 Stable Release
Development

No branches or pull requests
4 participants
@ldenblyd @GodGMN @PolpOnline @peaklabs-dev