Hello I have a Galera cluster for MySQL 5.6.36 that apparently works fine. I have a microservice with a REST API running in Docker that is connected via JPA + Hibernate to this database. Randomly, the service takes about 15 min to produce the response (all the time is taken by the database operation). I've tried to check most common MySQL and Galera status information but I don't see anything bad in the values, cluster seems to work well and also replication. The query is really simple (a select on a table) and what is really strange is that I don't see anything about that query if I run show processlist in MySQL. Can you suggest me a way to debug this problem considering that it's also very difficult for me to replicate it (apparently it happens randomly without any correlation with the load).
Galera cluster randomly hangs
323 Views Asked by Alessandro Dionisi At
0
There are 0 best solutions below
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in JPA
- JPA - How to query with a LIKE operator in combination with an AttributeConverter
- How to create nested selects with sql?
- Play Framework Unable to build entity manager factory when Working with PostGIS
- Getting entity with a join table GAE
- Is it necessary to create an repository and a service for each entity?
- JPA, Hibernate can I do composite primary key which one element is foreign kay @OneToMany?
- Hibernate Search Faceting not working
- EntityManagerSetupException for multiple joins and a sub query for NamedQuery
- JPA and web app
- JPA findDistinctPropertyBy magic method doesn't work as expected when using spring-boot-starter-jpa
- Inject EntityManager in SwitchYard Junit implementation
- QueryDSL where relationship may be null
- JPA, how can i have two queries, one use lazy and one use eager for fetching?
- Duplicate entry '[X]' for key '[Y]' on JPA repository 'save' operation. Saved entity has its key defined already
- Hibernate's bidirectional OneToOne relationship not working within the same class
Related Questions in GALERA
- Galera is 3x slower than standalone with durable settings, high CPU idle
- MariaDB Galera cluster: are replicate-do-db filters applied before or after data sent?
- Galera Cluster Rancher Node Scaling Issue
- Running MariaDB Galera Cluster on my dev machine fails
- can database size be different on different node in mairadb galera cluster?
- Can't start second node in MySQL Galera cluster
- problems with node joining the cluster when using sst:xtrabackup (galera)
- Galera cluster randomly hangs
- Mariadb galera cluster init unsucessfully
- pt-online-schema-change error with big composite primary key
- MariaDB Galera change default port
- Does maxscale (with Galera) handle Non-primary component/node condition automatically?
- Can't install Galera Manger on Ubuntu
- Is high availability required for nascent applications with low budget, if data loss is a concern?
- MariaDB Galera cluster SST sync from specified donor is impossible
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?