Title
#users-public
m

Muhammad Amal

09/16/2022, 8:31 AM
why my quest DB 6.5 always stop 2-3 times on a day. cpu usage is 60% any idea to optimize this case ?
Jaromir Hamala

Jaromir Hamala

09/16/2022, 9:03 AM
hello Muhammad, by “stop” you mean querying is stopped? or perhaps ingestion is stopped? or both? is there anything in questdb server logs during these periods? how long does it usually take and does it recover by itself?
m

Muhammad Amal

09/16/2022, 9:13 AM
Stop it's mean, the application quite and service stop
m

Muhammad Amal

09/16/2022, 11:29 PM
Thank you @Alex Pelagenko. any solution for this problems ?
12:08 PM
anyone please help
Alex Pelagenko

Alex Pelagenko

09/17/2022, 12:29 PM
Is it oom kill?
12:40 PM
It depends. Are you using latest version?
m

Muhammad Amal

09/17/2022, 12:43 PM
Yes, version 6.5
Alex Pelagenko

Alex Pelagenko

09/17/2022, 1:06 PM
Try 6.5.2
m

Muhammad Amal

09/17/2022, 1:09 PM
I used 6.5 version binary for production, how about the database to migrate 6.5.2 ? And config file to optimize ?
Alex Pelagenko

Alex Pelagenko

09/17/2022, 1:28 PM
Just overwrite the binaries
1:29 PM
Migration is usually automatic but in this case there is no data or config migration
m

Muhammad Amal

09/17/2022, 1:32 PM
The step : • Stop old version • Run version 6.5.2 with questdb start • Remove binary 6.5 Just like that?
1:36 PM
Cause I’ve more than 1000 sensors table data
Alex Pelagenko

Alex Pelagenko

09/17/2022, 1:38 PM
Make a backup, always good thing
m

Muhammad Amal

09/17/2022, 1:44 PM
Absolutely, but can you explain the step on top ?
4:24 PM
@Alex Pelagenko
Alex Pelagenko

Alex Pelagenko

09/20/2022, 9:22 AM
Hey. Sorry for delay, got distracted. To update on say Linux you overwrite the binaries folder with new binaries and then do restart with
questdb.sh stop
questdb.sh start
you can take the folder backup in between or follow backup instructions on the version running before the upgrade