coolify icon indicating copy to clipboard operation
coolify copied to clipboard

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

Open PolpOnline opened this issue 1 year ago β€’ 18 comments

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 avatar Nov 15 '24 19:11 PolpOnline

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 avatar Nov 21 '24 16:11 peaklabs-dev

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

ldenblyd avatar Nov 21 '24 16:11 ldenblyd

Sorry for the late reply

https://github.com/user-attachments/assets/8b009537-1440-4293-8fae-27973779c7eb

PolpOnline avatar Nov 22 '24 19:11 PolpOnline

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

GodGMN avatar Nov 23 '24 00:11 GodGMN

Hello, is this fixed? I still get this error on v4.0.0-beta.379... Image

andresousadotpt avatar Dec 16 '24 15:12 andresousadotpt

not fixed - beta 379

matifanger avatar Dec 19 '24 03:12 matifanger

I can confirm the error still occur on v4.0.0-beta.379.

lamualfa avatar Dec 19 '24 07:12 lamualfa

Hey, I've just got the error also on a nixpacks project. Just changed the nginx config a little bit and redeployed. Then the errors started comming in.

Restarting the project again seems to have solved the issue.

also on: v4.0.0-beta.379

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

schliesser avatar Dec 20 '24 11:12 schliesser

Same here

ekimcem avatar Dec 21 '24 21:12 ekimcem

Same-same

ton77v avatar Dec 25 '24 08:12 ton77v

Same

Image

50l3r avatar Dec 27 '24 10:12 50l3r

Same on v4.0.0-beta.380

I just enabled Metrics on the server

Image

AhmedKamal20 avatar Jan 09 '25 14:01 AhmedKamal20

same here. started appearing after a preview deployment, with the url template wrongly configured (container started successfully but url was not a valid url)

Version: v4.0.0-beta.379

flomero avatar Jan 09 '25 19:01 flomero

Still having the same issue on v4.0.0-beta.380. It happened after a container restart, but I don’t think the restart caused it. I was adjusting Traefik settings a few times in the app config and restarted a couple of times before the error started showing up.

luk82 avatar Jan 18 '25 20:01 luk82

Any chance those effected might have a build occurring or hanging in the background?

When I had this problem, it was resolved by:

  • (re)building without cache from docker image
  • *not clicking deploy now (instead of waiting in queue)

WilliamAGH avatar Jan 21 '25 03:01 WilliamAGH

I am testing some fixes in this pr, coming in the next sentinel version.

andrasbacsai avatar Feb 04 '25 09:02 andrasbacsai

can confirm this is still happening, even though its marked as done. do we need to do anything in Coolify to update the sentinel on servers?

adamJLev avatar Apr 28 '25 13:04 adamJLev

same

nicanordlc avatar Jun 12 '25 00:06 nicanordlc

Same - still seeing this on v4.0.0-beta.420.6.

PelagicDev avatar Jul 23 '25 20:07 PelagicDev

The PR was submitted to the Senitnel repository and is still open. it has not been merged yet by the Senitnel developers.

Cinzya avatar Jul 24 '25 20:07 Cinzya

Added fixes for this in Sentinel version 0.0.16, not released yet.

andrasbacsai avatar Sep 15 '25 09:09 andrasbacsai

Released the new version. You should get autoupdated based on your update configuration for your instance.

Cloud users will be updated soon as well.

andrasbacsai avatar Sep 15 '25 11:09 andrasbacsai