Issues
- Secrets are recreated on deletion with delete-pvc finalizerK8SPG-751
- Enable users to change cluster label for pmm-adminK8SPG-750natalia.marukovich
- kubectl delete pg cluster does not appear to delete everythingK8SPG-749
- PerconaPGCluster status improvementsK8SPG-748
- Fix PVC resizing status handling in PostgresCluster controllerK8SPG-747
- Migrate to aws-sdk-go-v2 from aws-sdk-goK8SPG-746
- Support Sidecar containers which will be GA from K8s 1.33K8SPG-745
- Document how to build operator for contributorsK8SPG-744dmitriy.kostiuk
- Disable client-side throttling in go-clientK8SPG-743Slava Sarzhan
- "ERROR failed to cleanup outdated backups" during pillar minor upgradeK8SPG-740
- Inconsistent update of PostgresCluster & PG generationK8SPG-739
- Add startup log to print commit hash, branch and build timeK8SPG-738ege.gunes
- datadir stats are not accessible by node_exporter in PostgreSQL podsK8SPG-737Andrii Dema
- [DOCU] - Missing docummentationK8SPG-736Anastasia Alexandrova
- Release 2.5.1K8SPG-735Resolved issue: K8SPG-735Eleonora Zinchenko
- Update Jenkinsfile to use 1.29 cluster versionK8SPG-734Resolved issue: K8SPG-734
- [Docu] - Missing documentation on certified image for different versions of operatorK8SPG-733Resolved issue: K8SPG-733Eleonora Zinchenko
- pgbackrest debug logs is hard to readK8SPG-732George Kechagias
- Zero downtime major upgrades for PostgreSQLK8SPG-731
- Add status.observedGeneration Field to Percona PG ClusterK8SPG-730
- Add Label for CRDK8SPG-729Andrii Dema
- Configure s3 to support minioK8SPG-728
- Can't connect to a DB created from template0K8SPG-727
- Add securityContext for all sidecarsK8SPG-726natalia.marukovich
- Add Support for Configuring repo-host Resources in Percona Postgres Custom ResourceK8SPG-725natalia.marukovich
- Updating versions of custom extensions doesn't workK8SPG-724
- Output warning about CRDs after helm upgradeK8SPG-723Julio Pasinatto
- [investigation] Deployment bug affecting the reinitialization behavior.K8SPG-722ege.gunes
- Remove PG 12 from Jenkins jobsK8SPG-721Resolved issue: K8SPG-721Julio Pasinatto
- Add support for PMM v3K8SPG-719Julio Pasinatto
- PG replicas go to 1 when patching cluster to have 2 -> 3 -> 2 -> 3 replicas in the loopK8SPG-716George Kechagias
- Add pgvector to custom-extensions e2e testsK8SPG-715Eleonora Zinchenko
- Malformed version panic in upgrade to 2.6.0K8SPG-714Resolved issue: K8SPG-714Julio Pasinatto
- "error": "postgresclusters.postgres-operator.crunchydata.com \"cluster1\" not found" when deleting clusterK8SPG-713Resolved issue: K8SPG-713Eleonora Zinchenko
- Ability to control every parameter supported by Patroni configuration.K8SPG-712ege.gunes
- Export Patroni metricsK8SPG-718George Kechagias
- Add README.md how to build product images for PG operatorK8SPG-711Resolved issue: K8SPG-711Slava Sarzhan
- Allow disabling backupsK8SPG-710ege.gunes
- Set default value for `repo1-retention-full`K8SPG-709
- Cluster label is missing for Postgresql databasesK8SPG-717Resolved issue: K8SPG-717natalia.marukovich
- Add sleep-forever / Patroni pause.K8SPG-708George Kechagias
- Make patroni create_replica_methods configurable through cr.yamlK8SPG-707Resolved issue: K8SPG-707ege.gunes
- Add pg_repack to PostgreSQL imagesK8SPG-706Resolved issue: K8SPG-706
- Add `perconapgupgrades` to the list of created CRDs to docsK8SPG-705
- Configuring replica_create_methodsK8SPG-704ege.gunes
- Reconcilier fails with "job.batch not found" when using ttlSecondsAfterFinishedK8SPG-703Andrii Dema
- Fix pod exec failing intermittently with retry logicK8SPG-702Resolved issue: K8SPG-702Julio Pasinatto
- Make spec.extensions.image optionalK8SPG-701Resolved issue: K8SPG-701Eleonora Zinchenko
- Backup fails with "Can't start backup. Previous backup is still in progress" if manually delete the pg-backup objectK8SPG-700Resolved issue: K8SPG-700Julio Pasinatto
- Add support for pgvector in our imageK8SPG-699Resolved issue: K8SPG-699dmitriy.kostiuk
LP #1714630: pt-query-digest parses timestamps incorrectly from general log
Description
Environment
Smart Checklist
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
LowFix versions
Details
Details
Assignee
Reporter
Priority
Fix versions
Smart Checklist
Smart Checklist
Smart Checklist
Activity
lpjirasyncJanuary 24, 2018 at 9:42 PM
**Comment from Launchpad by: Carlos Salguero on: 09-01-2018 17:38:39
Was this fixed in the related issue?
lpjirasyncJanuary 24, 2018 at 9:42 PM
**Comment from Launchpad by: Nickolay Ihalainen on: 14-12-2017 04:23:42
related issue:
https://bugs.launchpad.net/percona-toolkit/+bug/1738128
lpjirasyncJanuary 24, 2018 at 9:42 PM
**Comment from Launchpad by: Nickolay Ihalainen on: 14-12-2017 03:42:31
Another example for general log timestamp in 5.7:
/usr/local/mysql/bin/mysqld, Version: 5.7.19-17-log (Percona Server (GPL), Release 17, Revision e19a6b7b73f). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
2017-12-08T14:56:57.252473-07:00 1 Query BEGIN
Works with:
my $genlog_line_1= qr{
\A
(?\d{6}\s+\d{1,2}:\d\d:\d\d|\d{4}\d{1,2}\d{1,2}T\d\d:\d\d:\d\d\.\d+(?:Z|-?\d\d:\d\d)))? # Timestamp
\s+
(?:\s*(\d+)) # Thread ID
\s
(\w+) # Command
\s+
(.*) # Argument
\Z
}xs;
**Reported in Launchpad by Nickolay Ihalainen last update 09-01-2018 17:38:40
General log contains timestamps like: 2017-08-31T15:58:05.255051Z
my $genlog_line_1= qr{
\A
(?\d{6}\s+\d{1,2}:\d\d:\d\d|\d{4}\d{1,2}\d{1,2}T\d\d:\d\d:\d\d\.\d+Z))? # Timestamp
\s+
(?:\s*(\d+)) # Thread ID
\s
(\w+) # Command
\s+
(.*) # Argument
\Z
}xs;
It's not considered as proper TS or as mysql TS in parse_timestamp function and QPS always calculated as 0:
$mysql_ts = qr/(\d\d)(\d\d)(\d\d) (\d)\d+)\d+)(\.\d+)?/;
$proper_ts = qr/(\d\d\d\d)(\d\d)(\d\d)[T ](\d\d)\d\d)\d\d)(\.\d+)?/;
Suggested fix remove Z from genlog_line_1:
(?\d{6}\s+\d{1,2}:\d\d:\d\d|\d{4}\d{1,2}\d{1,2}T\d\d:\d\d:\d\d\.\d+))?Z? # Timestamp
/opt/mysql/product/mysql/bin/mysqld, Version: 5.7.18-15-29.20-log (Percona XtraDB Cluster binary (GPL) 5.7.18-29.20, Revision 7693d6e, wsrep_29.20). started with:
Tcp port: 3306 Unix socket: /opt/mysql/product/mysql/mysql3306.sock
Time Id Command Argument
2017-08-31T15:58:05.255051Z 2166396 Query SELECT 1
2017-08-31T15:59:05.255051Z 2166396 Query SELECT 1