# \#troubleshooting **URL:** https://forums.percona.com/tag/troubleshooting/8.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [Increased I/O Wait and CPU Load after Upgrading MySQL from 5.7 to 8.0](https://forums.percona.com/t/increased-i-o-wait-and-cpu-load-after-upgrading-mysql-from-5-7-to-8-0/29423)
**Author:** [@cesanek](https://forums.percona.com/u/cesanek)\ **Replies:** 6\ **Last updated:** [April 5, 2024, 8:12am UTC](https://forums.percona.com/t/increased-i-o-wait-and-cpu-load-after-upgrading-mysql-from-5-7-to-8-0/29423 "2024-04-05T08:12:54Z")
Hello, I’m dealing with an issue where immediately after upgrading MySQL from version 5.7 to 8.0, there’s been a significant increase in I/O wait and CPU load. Please refer to the attached PPM graph. I have a cluster co… --- ## [Problem in adding 2nd node to Percona Xtradb cluster 8.0.35](https://forums.percona.com/t/problem-in-adding-2nd-node-to-percona-xtradb-cluster-8-0-35/29512)
**Author:** [@Maxwell](https://forums.percona.com/u/Maxwell)\ **Replies:** 2\ **Last updated:** [April 2, 2024, 4:09pm UTC](https://forums.percona.com/t/problem-in-adding-2nd-node-to-percona-xtradb-cluster-8-0-35/29512 "2024-04-02T16:09:39Z")
Hi, First bootstrap was fine. But joining the 2nd node has some issue. I have no idea what is the problem. Thank you for your help in advance. Here is the log from joiner. Log of wsrep recovery (--wsrep-recover): IN… --- ## [Enable Authorisation on Percona MongoDB Docker](https://forums.percona.com/t/enable-authorisation-on-percona-mongodb-docker/22872)
**Author:** [@tonylindsay](https://forums.percona.com/u/tonylindsay)\ **Replies:** 0\ **Last updated:** [June 16, 2023, 12:02pm UTC](https://forums.percona.com/t/enable-authorisation-on-percona-mongodb-docker/22872 "2023-06-16T12:02:39Z")
I have set up a Percona Server for mongoDB in a docker container and believed I had activated authorisation on the container \[when I logged onto the container and examined the /etc/mongod.conf file the authorization is s… --- ## [Error Running pmm-client](https://forums.percona.com/t/error-running-pmm-client/15988)
**Author:** [@Somasuntaram\_M](https://forums.percona.com/u/Somasuntaram_M)\ **Replies:** 2\ **Last updated:** [March 20, 2023, 2:44pm UTC](https://forums.percona.com/t/error-running-pmm-client/15988 "2023-03-20T14:44:29Z")
Have configured pmm server and also pmm-client in kubernetes environment. when trying to run pmm-client after running pmm-server getting the following error. ERRO\[2022-06-06T03:03:21.598+00:00\] failed to query events\_st… --- ## [Data at rest Encryption issue - MySQL 8.0.23](https://forums.percona.com/t/data-at-rest-encryption-issue-mysql-8-0-23/10785)
**Author:** [@Adithya](https://forums.percona.com/u/Adithya)\ **Replies:** 4\ **Last updated:** [November 14, 2022, 12:56am UTC](https://forums.percona.com/t/data-at-rest-encryption-issue-mysql-8-0-23/10785 "2022-11-14T00:56:08Z")
Hi, I am trying to enable Data at rest Encryption for mysql 8.0.23 version percona server innodb cluster. used below hashicorp vault details in keyring\_vault.conf for all the 3 nodes with diff secret\_mount\_point detai… --- ## [Pt-online-schema-change increases table size](https://forums.percona.com/t/pt-online-schema-change-increases-table-size/13612)
**Author:** [@caseyrubick](https://forums.percona.com/u/caseyrubick)\ **Replies:** 1\ **Last updated:** [July 18, 2022, 12:41pm UTC](https://forums.percona.com/t/pt-online-schema-change-increases-table-size/13612 "2022-07-18T12:41:32Z")
Hello, could you please help me? I have Percona Server 5.7 and latest Percona Toolkit installed. I want to run pt-online-schema-change to get some diskspace As per information schema I have a lot space to reclaim. Also… --- ## [Percona XtraDB Cluster on Kubernetes mysql operator (Point-In-Time Recovery) not happening](https://forums.percona.com/t/percona-xtradb-cluster-on-kubernetes-mysql-operator-point-in-time-recovery-not-happening/12783)
**Author:** [@mohamedkashifuddin](https://forums.percona.com/u/mohamedkashifuddin)\ **Replies:** 13\ **Last updated:** [April 18, 2022, 8:27am UTC](https://forums.percona.com/t/percona-xtradb-cluster-on-kubernetes-mysql-operator-point-in-time-recovery-not-happening/12783 "2022-04-18T08:27:16Z")
HI team, I m facing a issue while doing a Point-In-Time Recovery restore in percona MySQL operator in K8s, As mentioned in the blog for a PITR I should mention the latest name + the PTIR should be turn on and I did tur… --- ## [PITR in Kubernetes Cluster not being taken - Operator not found](https://forums.percona.com/t/pitr-in-kubernetes-cluster-not-being-taken-operator-not-found/14720)
**Author:** [@anon17965173](https://forums.percona.com/u/anon17965173)\ **Replies:** 1\ **Last updated:** [March 11, 2022, 8:13pm UTC](https://forums.percona.com/t/pitr-in-kubernetes-cluster-not-being-taken-operator-not-found/14720 "2022-03-11T20:13:29Z")
I have PITR enabled as per documentation: backup: enabled: true restartOnFailure: true image: repository: percona/percona-server-mongodb-operator tag: 1.11.0-backup serviceAccountName: percona-server-mo… --- ## [Deploying Mongo Replicaset in multiple data centres](https://forums.percona.com/t/deploying-mongo-replicaset-in-multiple-data-centres/14275)
**Author:** [@Adithya](https://forums.percona.com/u/Adithya)\ **Replies:** 1\ **Last updated:** [February 7, 2022, 2:50pm UTC](https://forums.percona.com/t/deploying-mongo-replicaset-in-multiple-data-centres/14275 "2022-02-07T14:50:37Z")
Hi Team / @spronin We have a requirement to deploy pods of a replicaset across multiple k8s clusters (in different regions) & enable replication b/w pods and automate all the provisioning/operations using percona operat… --- ## [Percona XtraDB Cluster MySQL operator K8s with ha-proxy for failover](https://forums.percona.com/t/percona-xtradb-cluster-mysql-operator-k8s-with-ha-proxy-for-failover/13015)
**Author:** [@mohamedkashifuddin](https://forums.percona.com/u/mohamedkashifuddin)\ **Replies:** 0\ **Last updated:** [November 16, 2021, 5:06am UTC](https://forums.percona.com/t/percona-xtradb-cluster-mysql-operator-k8s-with-ha-proxy-for-failover/13015 "2021-11-16T05:06:56Z")
Hi Team, I have a use case where i m having two percona MySQL operators in the same gke cluster and i have a centralised ha-proxy, what i m trying over here is i want to configure these two percona mysql operators in th… --- ## [LDAP integration with percona Mongo operator](https://forums.percona.com/t/ldap-integration-with-percona-mongo-operator/12362)
**Author:** [@Adithya](https://forums.percona.com/u/Adithya)\ **Replies:** 2\ **Last updated:** [September 30, 2021, 9:01am UTC](https://forums.percona.com/t/ldap-integration-with-percona-mongo-operator/12362 "2021-09-30T09:01:05Z")
Hi Team, As per documentation we don’t see LDAP functionality in mongo operator. Please let us know if we have LDAP support for MongoDB kubernetes operator ? If not let us know if this feature will be added in near futu… --- ## [TLS implementation for mongo deployment with load balancer enabled](https://forums.percona.com/t/tls-implementation-for-mongo-deployment-with-load-balancer-enabled/12076)
**Author:** [@Adithya](https://forums.percona.com/u/Adithya)\ **Replies:** 2\ **Last updated:** [September 21, 2021, 5:13pm UTC](https://forums.percona.com/t/tls-implementation-for-mongo-deployment-with-load-balancer-enabled/12076 "2021-09-21T17:13:52Z")
Hi Team, As per the Transport Layer Security (TLS) we are trying to enable TLS for mongo deployment in EKS. Have below queries : If we enable exposeType as loadbalencer do we have to create TLS certificates along with… --- ## [HI EVERYONE! i have a problem wwhen i restart my system ( i have 2 node of Percona XtraDB Cluster 5.7, rehl 7.9 enterprise). i can't start mysql again](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165)
**Author:** [@Th\_ng\_D\_ng\_Van](https://forums.percona.com/u/Th_ng_D_ng_Van)\ **Replies:** 2\ **Last updated:** [September 15, 2021, 6:17pm UTC](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165 "2021-09-15T18:17:38Z")
here is my config of my.cnf ============================= # !includedir /etc/my.cnf.d/ !includedir /etc/percona-xtradb-cluster.conf.d/ \[mysqld\] wait\_timeout = 31536000 max\_allowed\_packet=1024M lower\_case\_table\_names=1 w… --- ## [exposeType : LoadBalancer queries for percona Mongo k8s operator](https://forums.percona.com/t/exposetype-loadbalancer-queries-for-percona-mongo-k8s-operator/11633)
**Author:** [@Adithya](https://forums.percona.com/u/Adithya)\ **Replies:** 8\ **Last updated:** [August 10, 2021, 7:36am UTC](https://forums.percona.com/t/exposetype-loadbalancer-queries-for-percona-mongo-k8s-operator/11633 "2021-08-10T07:36:23Z")
Hi Team, We are trying percona operator for MongoDB with exposeType : LoadBalancer in our development servers using AWS EKS We have below queries reg the loadbalencers : LB name mongo1-cdbr1-0 LoadBalancer 10.10… --- ## [Preventing pt-table-sync from causing replication lag](https://forums.percona.com/t/preventing-pt-table-sync-from-causing-replication-lag/11060)
**Author:** [@linuxleah](https://forums.percona.com/u/linuxleah)\ **Replies:** 1\ **Last updated:** [July 6, 2021, 3:51pm UTC](https://forums.percona.com/t/preventing-pt-table-sync-from-causing-replication-lag/11060 "2021-07-06T15:51:20Z")
Hello all! At work, we are dealing with a situation where one of our replicas is out of sync with its primary on a couple of key databases. We’ve worked up a script using pt-table-sync to attempt to bring the replica b… --- ## [Traefik reverse proxy with pathprefix attribute](https://forums.percona.com/t/traefik-reverse-proxy-with-pathprefix-attribute/8373)
**Author:** [@lucmichalski](https://forums.percona.com/u/lucmichalski)\ **Replies:** 3\ **Last updated:** [December 16, 2020, 6:18am UTC](https://forums.percona.com/t/traefik-reverse-proxy-with-pathprefix-attribute/8373 "2020-12-16T06:18:26Z")
Hi guys, Hope you are all well ! I need to use traefik and to create a path like /admin/pmm-server to access the service. For doing so, I thought to override your nginx configuration, mainly by adding a variable for t… --- ## [Victoriametrics, postgresql entered FATAL state, too many start retries too quickly](https://forums.percona.com/t/victoriametrics-postgresql-entered-fatal-state-too-many-start-retries-too-quickly/8357)
**Author:** [@lucmichalski](https://forums.percona.com/u/lucmichalski)\ **Replies:** 2\ **Last updated:** [December 8, 2020, 1:35am UTC](https://forums.percona.com/t/victoriametrics-postgresql-entered-fatal-state-too-many-start-retries-too-quickly/8357 "2020-12-08T01:35:13Z")
Hi guys, Hope you are all well ! I am facing an issue when restarting pmm-server service from docker and here is below a screenshot of my error logs: Here is my docker-compose: I tried to stop/remove containers… --- ## [Why restore failed with "error demultiplexing archive" error?](https://forums.percona.com/t/why-restore-failed-with-error-demultiplexing-archive-error/8015)
**Author:** [@vvol](https://forums.percona.com/u/vvol)\ **Replies:** 7\ **Last updated:** [December 2, 2020, 8:36am UTC](https://forums.percona.com/t/why-restore-failed-with-error-demultiplexing-archive-error/8015 "2020-12-02T08:36:18Z")
Hello, I’m currently trying to restore backup to freshly installed mongodb instance and get the following error while restoring collection: \[ERROR\] restore/2020-09-07T10:54:20Z: restore: restore mongo dump (successes:… --- ## [Error Log has "Got an error reading communication packets" after patching MySQL to 5.7.30](https://forums.percona.com/t/error-log-has-got-an-error-reading-communication-packets-after-patching-mysql-to-5-7-30/7866)
**Author:** [@sachinambardekar](https://forums.percona.com/u/sachinambardekar)\ **Replies:** 4\ **Last updated:** [November 10, 2020, 2:26pm UTC](https://forums.percona.com/t/error-log-has-got-an-error-reading-communication-packets-after-patching-mysql-to-5-7-30/7866 "2020-11-10T14:26:18Z")
Hello Team, I are seeing "Got an error reading communication packets " message in the error log after patching the instance to MySQL 5.7.30. Please advise. Thank you, SA --- ## [Percona Tools pt\_query\_digest: Profile file 'Query ID' field truncated](https://forums.percona.com/t/percona-tools-pt-query-digest-profile-file-query-id-field-truncated/8206)
**Author:** [@AndrewG](https://forums.percona.com/u/AndrewG)\ **Replies:** 1\ **Last updated:** [November 10, 2020, 5:03am UTC](https://forums.percona.com/t/percona-tools-pt-query-digest-profile-file-query-id-field-truncated/8206 "2020-11-10T05:03:41Z")
Hi All, So, I trying to use pt\_query\_digest to analyse Percona Slow Query Logs. So far, so good. And I get the ‘profile’ report paragraph with a ‘Query Id’ column which only shows the first 25 hex digits of 32. So, I… --- ## [2nd+ servers Mysql won't start](https://forums.percona.com/t/2nd-servers-mysql-wont-start/8235)
**Author:** [@anaxamaxan](https://forums.percona.com/u/anaxamaxan)\ **Replies:** 2\ **Last updated:** [November 5, 2020, 1:35am UTC](https://forums.percona.com/t/2nd-servers-mysql-wont-start/8235 "2020-11-05T01:35:39Z")
I’ve been following the configuration steps for XtraDB Cluster 8 on three fresh Ubuntu 20.04 instances. I bootstrapped the first node per the instructions, and verified that the values for wsrep\_local\_state\_uuid, wsrep\_… --- ## [Receiving " Invalid Username and Password " Error](https://forums.percona.com/t/receiving-invalid-username-and-password-error/8221)
**Author:** [@kalyan\_rajput](https://forums.percona.com/u/kalyan_rajput)\ **Replies:** 3\ **Last updated:** [November 3, 2020, 8:49am UTC](https://forums.percona.com/t/receiving-invalid-username-and-password-error/8221 "2020-11-03T08:49:18Z")
Hi Team, Recently I have changed the Password on the PMM Console from Default to New one. After that we are receiving Error Code " Invalid Username and Password " when we try to fetch configured exporters list using Pmm… --- ## [Struggling to complete the installation in CentOS8](https://forums.percona.com/t/struggling-to-complete-the-installation-in-centos8/8177)
**Author:** [@real\_passcode](https://forums.percona.com/u/real_passcode)\ **Replies:** 4\ **Last updated:** [October 27, 2020, 9:18pm UTC](https://forums.percona.com/t/struggling-to-complete-the-installation-in-centos8/8177 "2020-10-27T21:18:36Z")
It just won’t let me join the Percona party. #################################### Error: Transaction test error: file /usr/bin/mysql from install of percona-server-client-8.0.21-12.2.el8.x86\_64 conflicts with file fro… --- ## [Cant get PMM to work using documentation install instructions](https://forums.percona.com/t/cant-get-pmm-to-work-using-documentation-install-instructions/8192)
**Author:** [@rmccleave559](https://forums.percona.com/u/rmccleave559)\ **Replies:** 1\ **Last updated:** [October 27, 2020, 8:21am UTC](https://forums.percona.com/t/cant-get-pmm-to-work-using-documentation-install-instructions/8192 "2020-10-27T08:21:53Z")
Hello, I have been trying to get PMM to work on my local cluster, I can get it installed using a docker image and get the client installed on the DB host and register it successfully. I added the mysql checks and yet no… --- ## [Unable to bootstrap Node 1 of Pecona XtraDB cluster 8.0](https://forums.percona.com/t/unable-to-bootstrap-node-1-of-pecona-xtradb-cluster-8-0/8134)
**Author:** [@salman253](https://forums.percona.com/u/salman253)\ **Replies:** 1\ **Last updated:** [October 24, 2020, 12:12pm UTC](https://forums.percona.com/t/unable-to-bootstrap-node-1-of-pecona-xtradb-cluster-8-0/8134 "2020-10-24T12:12:07Z")
Hi, I have installed PXC 8.0 on 2 nodes (Ubuntu 20). After sufficient configuration to my.cnf file I am trying to bootstrap Node 1 as below: systemctl start mysql@bootstrap.service The command stuck for 1-2 mins and… --- ## [Failed to start mysql on new node](https://forums.percona.com/t/failed-to-start-mysql-on-new-node/7956)
**Author:** [@ashfahrul](https://forums.percona.com/u/ashfahrul)\ **Replies:** 3\ **Last updated:** [October 23, 2020, 11:29am UTC](https://forums.percona.com/t/failed-to-start-mysql-on-new-node/7956 "2020-10-23T11:29:00Z")
Hi, Have a great day ! I wanna ask a question, we have 3 node configuration of pxc, and this is the configuration : Node1 = pxc1 –\> Bootstrap Node2 = pxc2 –\> mysql Node3 = pxc3 –\> mysql When I try to start mysql in … --- ## [MySQL performance good after restart, than it drops](https://forums.percona.com/t/mysql-performance-good-after-restart-than-it-drops/7990)
**Author:** [@Frank](https://forums.percona.com/u/Frank)\ **Replies:** 3\ **Last updated:** [October 6, 2020, 4:13pm UTC](https://forums.percona.com/t/mysql-performance-good-after-restart-than-it-drops/7990 "2020-10-06T16:13:00Z")
We are running a MySQL community server version 5.7.27-1 on a debian system. Every time we restart the MySQL server our data load is done in 3.5 hours, the second run is most of the time at the same speed, than the perfo… --- ## [pt-online-schema-change execute very slowly](https://forums.percona.com/t/pt-online-schema-change-execute-very-slowly/8048)
**Author:** [@triThirty](https://forums.percona.com/u/triThirty)\ **Replies:** 1\ **Last updated:** [September 17, 2020, 3:36am UTC](https://forums.percona.com/t/pt-online-schema-change-execute-very-slowly/8048 "2020-09-17T03:36:33Z")
Hi guys, I meet a problem when I use pt-online-schema-change to change the table structure. RDS: I use AWS RDS to run my mysql server which version is mysql 5.6, and the server has tow replications. Run command: pt-on… --- ## [pt-online-schema-change breaks slave replication](https://forums.percona.com/t/pt-online-schema-change-breaks-slave-replication/7927)
**Author:** [@aluthens](https://forums.percona.com/u/aluthens)\ **Replies:** 4\ **Last updated:** [September 7, 2020, 4:40pm UTC](https://forums.percona.com/t/pt-online-schema-change-breaks-slave-replication/7927 "2020-09-07T16:40:44Z")
Our database configuration is very simple with one master database and one slave database. Whenever a pt-online-schema-change of any kind (seemingly independent of table size or table alteration being performed), replica… --- ## [Mongodb rs cluster ldap configuration](https://forums.percona.com/t/mongodb-rs-cluster-ldap-configuration/7781)
**Author:** [@bsiara](https://forums.percona.com/u/bsiara)\ **Replies:** 3\ **Last updated:** [August 11, 2020, 6:25am UTC](https://forums.percona.com/t/mongodb-rs-cluster-ldap-configuration/7781 "2020-08-11T06:25:03Z")
Hi, I want to swich my rs cluster from sasl-ldap to direct ldap conection, this is my configuration: systemLog: destination: file path: /data/mongod.log logAppend: true logRotate: reopen component: accessControl: ver… [Next page](https://forums.percona.com/tag/troubleshooting/8.md?match_all_tags=true&page=1&tags%5B%5D=troubleshooting)