# Uncategorized **URL:** https://forums.percona.com/c/uncategorized/1.md?page=3 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 4 --- ## [Pmm client 2.40.1 on Ubuntu 22.04](https://forums.percona.com/t/pmm-client-2-40-1-on-ubuntu-22-04/33008)
**Author:** [@anonymous\_lee](https://forums.percona.com/u/anonymous_lee)\ **Replies:** 3\ **Last updated:** [September 10, 2024, 2:04pm UTC](https://forums.percona.com/t/pmm-client-2-40-1-on-ubuntu-22-04/33008 "2024-09-10T14:04:13Z")
I installed and started pmm client 2.40.1 on Ubuntu 22.04, but db information comes out fine, but node information does not come out properly. How can I solve this? --- ## [The node information of the aws rds recently created in pmm is not visible](https://forums.percona.com/t/the-node-information-of-the-aws-rds-recently-created-in-pmm-is-not-visible/32595)
**Author:** [@anonymous\_lee](https://forums.percona.com/u/anonymous_lee)\ **Replies:** 9\ **Last updated:** [September 9, 2024, 1:09am UTC](https://forums.percona.com/t/the-node-information-of-the-aws-rds-recently-created-in-pmm-is-not-visible/32595 "2024-09-09T01:09:35Z")
Hello everyone The node information of the aws rds recently created in pmm is not visible. Some CPU-related information is visible, but memory-related information is not visible. Below is a portion of rds.log.(pmm-ser… --- ## [Pgpool health check failed causing failover](https://forums.percona.com/t/pgpool-health-check-failed-causing-failover/32895)
**Author:** [@Rajkamal](https://forums.percona.com/u/Rajkamal)\ **Replies:** 4\ **Last updated:** [September 5, 2024, 10:56am UTC](https://forums.percona.com/t/pgpool-health-check-failed-causing-failover/32895 "2024-09-05T10:56:22Z")
Hello Team, I am new to PG and PGPOOL. we have a production environment in which recently while doing DR drill activity , pgpool failover has been triggered. What I see from the logs is during health check for node 0 fr… --- ## [MongoDB loadbalancers svc stuck in pending state, without external IP address](https://forums.percona.com/t/mongodb-loadbalancers-svc-stuck-in-pending-state-without-external-ip-address/32764)
**Author:** [@Divyansh\_Verma](https://forums.percona.com/u/Divyansh_Verma)\ **Replies:** 5\ **Last updated:** [September 5, 2024, 2:34am UTC](https://forums.percona.com/t/mongodb-loadbalancers-svc-stuck-in-pending-state-without-external-ip-address/32764 "2024-09-05T02:34:23Z")
kubectl get svc -n obto NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE mongodb-zjc-rs0 ClusterIP… --- ## [PMM2.x source code debugging](https://forums.percona.com/t/pmm2-x-source-code-debugging/32735)
**Author:** [@han7](https://forums.percona.com/u/han7)\ **Replies:** 0\ **Last updated:** [August 30, 2024, 8:25am UTC](https://forums.percona.com/t/pmm2-x-source-code-debugging/32735 "2024-08-30T08:25:50Z")
Hi,I have downloaded the source code of pmm and want to do some Chinese translation, but I do not know how to start it, nor have I found relevant deployment documents. Could you please tell me how to deploy and package … --- ## [Cluster Join Node- Error](https://forums.percona.com/t/cluster-join-node-error/32624)
**Author:** [@Omer\_Faruk\_Icen](https://forums.percona.com/u/Omer_Faruk_Icen)\ **Replies:** 1\ **Last updated:** [August 27, 2024, 1:36pm UTC](https://forums.percona.com/t/cluster-join-node-error/32624 "2024-08-27T13:36:38Z")
Hi Dear Percona Support Team, When I joined a node to the cluster, it started with an SST process. After that, I noticed the presence of gcache.page files when I checked the datadir. Below are the relevant Actually Dat… --- ## [How to interrupt xtrabackup related innodb table import?](https://forums.percona.com/t/how-to-interrupt-xtrabackup-related-innodb-table-import/32448)
**Author:** [@Jacob\_Lukose](https://forums.percona.com/u/Jacob_Lukose)\ **Replies:** 5\ **Last updated:** [August 21, 2024, 3:50pm UTC](https://forums.percona.com/t/how-to-interrupt-xtrabackup-related-innodb-table-import/32448 "2024-08-21T15:50:29Z")
Hi, We are using xtrabackup to backup and restore our database. During restore phase, we use xtrabackup to restore the database, table by table. For each table, an alter table… import tablespace command is called to loa… --- ## [Oracle CPQ to snowflake](https://forums.percona.com/t/oracle-cpq-to-snowflake/32492)
**Author:** [@saichinnu1852](https://forums.percona.com/u/saichinnu1852)\ **Replies:** 1\ **Last updated:** [August 21, 2024, 3:41pm UTC](https://forums.percona.com/t/oracle-cpq-to-snowflake/32492 "2024-08-21T15:41:19Z")
I’m looking for some advice on how to extract data from Oracle CPQ to snowflake. I do not have any idea about how Oracle CPQ works and not sure on the data model how the system works. Is there any way we can extract Orac… --- ## [Percona Server MySQL 8.0.37 Linux generic version has missing Libs](https://forums.percona.com/t/percona-server-mysql-8-0-37-linux-generic-version-has-missing-libs/32311)
**Author:** [@Chanakya](https://forums.percona.com/u/Chanakya)\ **Replies:** 10\ **Last updated:** [August 19, 2024, 10:11pm UTC](https://forums.percona.com/t/percona-server-mysql-8-0-37-linux-generic-version-has-missing-libs/32311 "2024-08-19T22:11:00Z")
Linux generic version for 8.0.37 is packaged without libssl3.so MySQL doesn’t start with following error: bin/mysqld: error while loading shared libraries: libssl3.so: cannot open shared object file: No such file or di… --- ## [SST (State Snapshot Transfer) process Time](https://forums.percona.com/t/sst-state-snapshot-transfer-process-time/32361)
**Author:** [@Omer\_Faruk\_Icen](https://forums.percona.com/u/Omer_Faruk_Icen)\ **Replies:** 3\ **Last updated:** [August 19, 2024, 1:53pm UTC](https://forums.percona.com/t/sst-state-snapshot-transfer-process-time/32361 "2024-08-19T13:53:59Z")
Dear Percona Support Team, I am currently managing a Percona XtraDB Cluster, and I’ve encountered a significant issue where one of our nodes is lagging far behind. The SST (State Snapshot Transfer) process to bring this… --- ## [Data sync between 2 percona xtradb mysql clusters](https://forums.percona.com/t/data-sync-between-2-percona-xtradb-mysql-clusters/31804)
**Author:** [@sarath](https://forums.percona.com/u/sarath)\ **Replies:** 4\ **Last updated:** [August 12, 2024, 5:02pm UTC](https://forums.percona.com/t/data-sync-between-2-percona-xtradb-mysql-clusters/31804 "2024-08-12T17:02:45Z")
Hi All Good Afternoon I have two Percona XtraDB MySQL clusters: Cluster A: Master: 172.10.10.05 Node: 172.10.10.06 Cluster B: Master: 172.10.10.07 Node: 172.10.10.08 I am trying to set up bidirectional replicati… --- ## [Exposing mysqld and node exporter metrics to host ip address in pmm 2.41.0](https://forums.percona.com/t/exposing-mysqld-and-node-exporter-metrics-to-host-ip-address-in-pmm-2-41-0/28184)
**Author:** [@krkumar](https://forums.percona.com/u/krkumar)\ **Replies:** 4\ **Last updated:** [July 25, 2024, 9:45pm UTC](https://forums.percona.com/t/exposing-mysqld-and-node-exporter-metrics-to-host-ip-address-in-pmm-2-41-0/28184 "2024-07-25T21:45:47Z")
Hi, Before pmm server 2.41.0 version we were able to utilize metrics exposed by mysqld & node exporter and using them with our dashboarding tool but with 2.41.0 this has been stopped. I cam across --expose-exporter fla… --- ## [Replication lag & Long running alter queries](https://forums.percona.com/t/replication-lag-long-running-alter-queries/31679)
**Author:** [@kapilsingla](https://forums.percona.com/u/kapilsingla)\ **Replies:** 1\ **Last updated:** [July 18, 2024, 1:22pm UTC](https://forums.percona.com/t/replication-lag-long-running-alter-queries/31679 "2024-07-18T13:22:28Z")
Hi All, We have long running “ALTER TABLE … ROW\_FORMAT=COMPRESSED KEY\_BLOCK\_SIZE = 4;” queries on source mysql instance. After the queries reach the replica mysql instance, over replication, we have noticed that the rep… --- ## [Unable to get the address in the alerts](https://forums.percona.com/t/unable-to-get-the-address-in-the-alerts/31667)
**Author:** [@ManwinderSingh](https://forums.percona.com/u/ManwinderSingh)\ **Replies:** 0\ **Last updated:** [July 17, 2024, 5:50pm UTC](https://forums.percona.com/t/unable-to-get-the-address-in-the-alerts/31667 "2024-07-17T17:50:07Z")
Hi everyone, I’m dealing with a lot of nodes that are displayed in the settings for alerts. While I can retrieve the node\_name and other information through metrics, I’m unable to find the address (specifically the port… --- ## [How to modify --disable-tablestats parameter](https://forums.percona.com/t/how-to-modify-disable-tablestats-parameter/31502)
**Author:** [@j\_a\_y](https://forums.percona.com/u/j_a_y)\ **Replies:** 1\ **Last updated:** [July 9, 2024, 10:26am UTC](https://forums.percona.com/t/how-to-modify-disable-tablestats-parameter/31502 "2024-07-09T10:26:42Z")
For a PMM Client already configured to monitor a Percona Server, can you modify the number of tables for which tablestats collection is disabled, after the service has been already added? The --disable-tablestats paramet… --- ## [Stuck atter node crash](https://forums.percona.com/t/stuck-atter-node-crash/31466)
**Author:** [@n7qnm](https://forums.percona.com/u/n7qnm)\ **Replies:** 0\ **Last updated:** [July 6, 2024, 9:16pm UTC](https://forums.percona.com/t/stuck-atter-node-crash/31466 "2024-07-06T21:16:36Z")
I’m running a 4 node k8s cluster (one control plane and 3 workers) in a Proxmox 5 node cluster, and running a 3 node xtradb cluster on the worker nodes. Last night, the physical node supporting one of my k8s worker node… --- ## [How to configure the PAM authentication in Postgres 12](https://forums.percona.com/t/how-to-configure-the-pam-authentication-in-postgres-12/31106)
**Author:** [@Balaji](https://forums.percona.com/u/Balaji)\ **Replies:** 2\ **Last updated:** [July 5, 2024, 9:11am UTC](https://forums.percona.com/t/how-to-configure-the-pam-authentication-in-postgres-12/31106 "2024-07-05T09:11:56Z")
Hello Guys, I am new to the Postgres. I want to configure the PAM authentication. How we will configure the PAM . Thanks in advance --- ## [Failed to evaluate queries and expressions: failed to execute conditions: input data must be a wide series but got type long (input refid)](https://forums.percona.com/t/failed-to-evaluate-queries-and-expressions-failed-to-execute-conditions-input-data-must-be-a-wide-series-but-got-type-long-input-refid/31392)
**Author:** [@Mantresh\_Kumar](https://forums.percona.com/u/Mantresh_Kumar)\ **Replies:** 1\ **Last updated:** [July 5, 2024, 5:39am UTC](https://forums.percona.com/t/failed-to-evaluate-queries-and-expressions-failed-to-execute-conditions-input-data-must-be-a-wide-series-but-got-type-long-input-refid/31392 "2024-07-05T05:39:05Z")
I was trying to set an alert on the basis of high execution time of slow query. But getting this error “Failed to evaluate queries and expressions: failed to execute conditions: input data must be a wide series but got … --- ## [Is Ubuntu 18.04 not supported by percona-server 5.7?](https://forums.percona.com/t/is-ubuntu-18-04-not-supported-by-percona-server-5-7/31412)
**Author:** [@Elvin\_Zhang](https://forums.percona.com/u/Elvin_Zhang)\ **Replies:** 3\ **Last updated:** [July 4, 2024, 12:33pm UTC](https://forums.percona.com/t/is-ubuntu-18-04-not-supported-by-percona-server-5-7/31412 "2024-07-04T12:33:33Z")
Hi, I am building images based on ubuntu18.04. Last successful build was on March 2024. I tried the following installation code: RUN curl -k -L https://repo.percona.com/apt/percona-release\_latest.$(lsb\_release -sc)\_al… --- ## [How can I get slow queries of MongoDB on Dahsboard just like Postgres Instance Dashboard (Experimental) of Percona?](https://forums.percona.com/t/how-can-i-get-slow-queries-of-mongodb-on-dahsboard-just-like-postgres-instance-dashboard-experimental-of-percona/31375)
**Author:** [@Mantresh\_Kumar](https://forums.percona.com/u/Mantresh_Kumar)\ **Replies:** 4\ **Last updated:** [July 3, 2024, 11:33am UTC](https://forums.percona.com/t/how-can-i-get-slow-queries-of-mongodb-on-dahsboard-just-like-postgres-instance-dashboard-experimental-of-percona/31375 "2024-07-03T11:33:21Z")
I’m not getting slow queries panel for mongoDB just like postgres slow queries monitoring on postgres Instance Dashboard (Experimental). Can you suggest how can I monitor Mongo Slow Queries using PMM? --- ## [QAN PostgreSQL explain plan is not user friendly like MySQL or MariaDB](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330)
**Author:** [@Naresh9999](https://forums.percona.com/u/Naresh9999)\ **Replies:** 2\ **Last updated:** [July 1, 2024, 3:34pm UTC](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330 "2024-07-01T15:34:55Z")
Hi Team, We are only seeing the below in the PostgreSQL query to explain plan TAB. And Table not found error. Can we get explain plan like MariaDB, how many rows scanning whether index is being used or not. --- ## [Percona-xtradb cluster in docker swarm timed out](https://forums.percona.com/t/percona-xtradb-cluster-in-docker-swarm-timed-out/31256)
**Author:** [@vbvbrj](https://forums.percona.com/u/vbvbrj)\ **Replies:** 3\ **Last updated:** [July 1, 2024, 5:02am UTC](https://forums.percona.com/t/percona-xtradb-cluster-in-docker-swarm-timed-out/31256 "2024-07-01T05:02:05Z")
Hello. Recently I created a stack with a docker-compose.yml to deploy in a docker swarm of 4 servers for percona-xtradb with etcd. This is the docker-compose.yml: # syntax=docker/dockerfile:1 version: '3.9' services: … --- ## [Can I install percona server 5.7.37-40 on Debian 12?](https://forums.percona.com/t/can-i-install-percona-server-5-7-37-40-on-debian-12/31278)
**Author:** [@Roni\_Alboim](https://forums.percona.com/u/Roni_Alboim)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 4:03pm UTC](https://forums.percona.com/t/can-i-install-percona-server-5-7-37-40-on-debian-12/31278 "2024-06-27T16:03:08Z")
My old server is Ubuntu 18.04 with Percona Server 5.7.37-40 and I want to switch master to new server with Debian 12, can I install ver. 5.7.37-40 on it? And if I install latest 5.7.44-48-1.bookworm, will it be possible… --- ## [Error locking mutex 22](https://forums.percona.com/t/error-locking-mutex-22/31224)
**Author:** [@kranthij29](https://forums.percona.com/u/kranthij29)\ **Replies:** 3\ **Last updated:** [June 27, 2024, 2:32pm UTC](https://forums.percona.com/t/error-locking-mutex-22/31224 "2024-06-27T14:32:04Z")
Error locking mutex 22 pure virtual method called terminate called without an active exception 07:12:30 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of… --- ## [Pt-query-digest missing report (query rank is inconsistent)](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216)
**Author:** [@alwaysdba](https://forums.percona.com/u/alwaysdba)\ **Replies:** 2\ **Last updated:** [June 26, 2024, 6:21am UTC](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216 "2024-06-26T06:21:12Z")
Hi Team, I am currently using pt-query-digest with my slow query log file, which provides detailed information on unique queries (including the number of executions and the average time spent on each). But, when I manua… --- ## [Restore backup from pbm backup directory without pbm list](https://forums.percona.com/t/restore-backup-from-pbm-backup-directory-without-pbm-list/31076)
**Author:** [@Samir\_Naves](https://forums.percona.com/u/Samir_Naves)\ **Replies:** 1\ **Last updated:** [June 19, 2024, 12:26pm UTC](https://forums.percona.com/t/restore-backup-from-pbm-backup-directory-without-pbm-list/31076 "2024-06-19T12:26:16Z")
can i insert on pbm list one information from another backup snapshots to restore? --- ## [Percona HA not working over two availability zones](https://forums.percona.com/t/percona-ha-not-working-over-two-availability-zones/31057)
**Author:** [@tdiallo](https://forums.percona.com/u/tdiallo)\ **Replies:** 2\ **Last updated:** [June 17, 2024, 6:15pm UTC](https://forums.percona.com/t/percona-ha-not-working-over-two-availability-zones/31057 "2024-06-17T18:15:42Z")
We are using 6 nodes cluster. 3 nodes located in NYC and 3 nodes located in California. We are using Mysql for databases and installed Redhat SSO on redhat 8. Every time we have a network or power issue in one datacent… --- ## [Pmm server inside docker with host nginx proxy pass and client connection](https://forums.percona.com/t/pmm-server-inside-docker-with-host-nginx-proxy-pass-and-client-connection/30989)
**Author:** [@apollo](https://forums.percona.com/u/apollo)\ **Replies:** 1\ **Last updated:** [June 12, 2024, 10:37pm UTC](https://forums.percona.com/t/pmm-server-inside-docker-with-host-nginx-proxy-pass-and-client-connection/30989 "2024-06-12T22:37:50Z")
server1 (with pmm server): services: pmm-server: image: percona/pmm-server:latest container\_name: pmm-server ports: - '127.0.0.1:81:80' - '8443:443' restart: always environment: -… --- ## [Xtrabackup fails with OS errno 2](https://forums.percona.com/t/xtrabackup-fails-with-os-errno-2/30885)
**Author:** [@Yadvendra\_kushwaha](https://forums.percona.com/u/Yadvendra_kushwaha)\ **Replies:** 1\ **Last updated:** [June 8, 2024, 7:31am UTC](https://forums.percona.com/t/xtrabackup-fails-with-os-errno-2/30885 "2024-06-08T07:31:45Z")
I am trying to take a full backup remotely as below sudo xtrabackup --user=root --password=password --host=1.1.1.1 --backup --target-dir=./data.resync But backup failes with below error \[Note\] \[MY-011825\] \[Xtrabacku… --- ## [Error Pt-archival](https://forums.percona.com/t/error-pt-archival/30651)
**Author:** [@SumitKumar](https://forums.percona.com/u/SumitKumar)\ **Replies:** 11\ **Last updated:** [June 7, 2024, 3:53am UTC](https://forums.percona.com/t/error-pt-archival/30651 "2024-06-07T03:53:23Z")
Hi , We are getting below error during pt-archival of 1 table’s Unicode non-character U+FFFF is illegal for open interchange at /bin/pt-archiver line 6923. Kindly check and help for this [Previous page](https://forums.percona.com/c/uncategorized/1.md?page=2) [Next page](https://forums.percona.com/c/uncategorized/1.md?page=4)