After upgrading from CrateDB 5.3.2 to 5.4.2 with CrateDB JDBC 2.6.0 jar, all write threads are getting blocked with single monitor. Below is the thread dump url for reference. Thread dump report: Java thread dump analysis report Link to download : Download Threaddump cratedb[crate03][write][T#25]…

Hi @Satishlk , Could you elaborate a bit on your setup and the issue you are observing at a higher level? are you running INSERTs or UPDATEs? are there any exceptions logged in the CrateDB log on the nodes?

Hi @hernanc , We are using 3 nodes cluster with 32 CPU and 48 GB ram.We are using Crate as secondary database for searches of txn data .We have pipeline job which sync data from mysql to kafka to crate database . We have exposed api’s to aggregate data to show in client application.Insertions ar…

Hi After running optimize and analyze and reducing connections on crate cluster, system was running fine for couple of weeks with reduced response time from 20sec to 300 ms and reduced cpu from 100% to 30%.We have upgraded kernal version on crate cluster aws ec2 machines we started seeing similar…

CrateDB 5.4: Write thread pool getting stuck after upgrade from 5.3.2

CrateDB

hernanc October 5, 2023, 2:21pm 5

In case anyone comes across this thread in the future, the conversation has continued in Crate database showing “shard is now inactive” - CrateDB - CrateDB Community

Topic		Replies	Views
CrateDB database logs showing "shard is now inactive", and threads are getting blocked CrateDB	16	732	October 25, 2023
Unstable cluster with 5.3+ version CrateDB	4	274	December 11, 2023
3rd node of 3 Node cluster always syncing complete data CrateDB	6	494	October 18, 2022
What can be the root cause of a recent crash we encountered in one of our CrateDB nodes? CrateDB	0	805	January 27, 2022
How to handle "There are still active requests on this node, delaying graceful shutdown"? CrateDB	9	1085	December 23, 2021

CrateDB 5.4: Write thread pool getting stuck after upgrade from 5.3.2

Related topics