Tag - Bugs

PostgreSQL fsync Failure Fixed – Minor Versions Released Feb 14, 2019

fsync postgresql upgrade

In case you didn’t already see this news, PostgreSQL has got its first minor version released for 2019. This includes minor version updates for all supported PostgreSQL versions. We have indicated in our previous blog post that PostgreSQL 9.3 had gone EOL, and it would not support any more updates. This release includes the […]

Read more

Why Optimization derived_merge can Break Your Queries

MySQL optimizer bugs

Lately, I worked on several queries which started returning wrong results after upgrading MySQL Server to version 5.7 The reason for the failure was derived merge optimization which is one of the default
optimizer_switch  options. Issues were solved, though at the price of performance, when we turned it
OFF . But, more importantly, we could […]

Read more

MySQL 8.0 GA: Quality or Not?

MySQL 8.0 GA

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?
When it comes to being a software critic, a lot.
In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun to […]

Read more

Updates to Percona Bug Tracking

report bugs

We’re completing our move of Percona bug tracking into JIRA, and the drop-dead date is December 28, 2017.
For some time now, Percona has maintained both the legacy Launchpad bug tracking system and a JIRA bug tracking system for some of the newer products. The time has come to consolidate everything into the JIRA […]

Read more

MySQL super_read_only Bugs

MySQL Error Code 1215

This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances.
Background
In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This allows slave instances to use the GTID feature regardless whether the binlog option is set or not. Here is […]

Read more