Trying to upgrade PowerDNS - required database schema upgrade failed (Column length too big)

Published on October 2nd 2024 - Listed in PowerDNS MySQL Databases - 0 comments

PowerDNS replication failing (TCP nameserver had error, cycling backend: GSQLBackend unable to lookup)

Published on September 17th 2024 - Listed in Linux MySQL Databases DNS PowerDNS - 0 comments

Understanding an erroneous spike in Grafana graph with data from InfluxDB

Published on May 4th 2024 - Listed in Databases Influx Grafana - 0 comments

How to reset MariaDB root login to use unix socket authentication

Published on February 18th 2024 - Listed in MariaDB Linux Databases - 0 comments

MySQL (Community) server upgrade 5.7 to 8.0 failed, packages have unmet dependencies

Published on November 23rd 2023 - Listed in MySQL Linux Databases - 0 comments

ERROR 3105 (HY000) at line 554: The value specified for generated column 'column' in table 'table' is not allowed

Published on October 23rd 2023 - Listed in MySQL Databases MariaDB - 0 comments

How to fix a broken MySQL / MariaDB replication (Relay log read failure) after a crash on the slave server

Published on July 26th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

Adding performance data to dbstats action of check_postgres monitoring plugin

Published on July 12th 2023 - Listed in Databases PostgreSQL Monitoring Perl - 0 comments

MSSQL Available Space alert: How to manually grow the database file with SSMS

Published on July 11th 2023 - Listed in Monitoring Databases Windows - 0 comments

How to monitor PostgreSQL databases with check_postgresl.pl, managed through Puppet

Published on June 30th 2023 - last updated on July 3rd 2023 - Listed in Databases PostgreSQL Monitoring - 0 comments

Notes for double LTS upgrade: Ubuntu 18.04 to 22.04 and MariaDB 10.3 to 10.6

Published on June 20th 2023 - last updated on September 7th 2023 - Listed in MariaDB Database Linux - 0 comments

APT upgrade error while upgrading Galera cluster node from MariaDB 10.3 to MariaDB 10.4

Published on June 20th 2023 - Listed in Galera Database MariaDB - 0 comments

mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table

Published on June 6th 2023 - Listed in MySQL Databases MariaDB - 0 comments

Galera garbd terminated: Group requested gcs_proto_ver: 2, max supported by this node: 0

Published on May 31st 2023 - Listed in Galera Database MariaDB - 0 comments

How to monitor PostgreSQL database size in AWS RDS

Published on April 28th 2023 - Listed in Monitoring AWS PostgreSQL Databases Cloud - 0 comments

How to create databases, users (roles) and install extensions in AWS RDS PostgreSQL

Published on April 27th 2023 - last updated on May 8th 2023 - Listed in AWS Cloud Postgres Databases - 0 comments

How to do TAG filtering in InfluxDB (SHOW TAG VALUES with a WHERE clause)

Published on February 21st 2023 - Listed in Influx Database Grafana - 0 comments

How to delete (old) monitoring data in InfluxDB with WHERE condition

Published on February 17th 2023 - last updated on February 20th 2023 - Listed in Icinga Influx Database - 0 comments

(Performance) Comparison of different compression methods used in combination with mysqldump

Published on February 8th 2023 - Listed in MySQL MariaDB Databases Linux - 0 comments

ERROR: relation table does not exist during PostgreSQL maintenance tasks (VACUUM, REINDEX)

Published on January 25th 2023 - Listed in Databases PostgreSQL - 0 comments

New version of check_mysql_slavestatus released: Bugfix when using both -H and -S (socket) parameters

Published on January 3rd 2023 - Listed in Monitoring MySQL MariaDB Databases - 0 comments

Ansible and the problem to reset the MySQL root password (unable to connect to database, check login_user and login_password are correct)

Published on August 18th 2022 - Listed in Ansible Linux MySQL MariaDB Databases - 2 comments

After Confluence copy: java.sql.SQLException: The user specified as a definer does not exist

Published on August 17th 2022 - last updated on February 15th 2023 - Listed in Atlassian MySQL MariaDB Databases - 2 comments

check_mysql_write 1.6 available: Plugin now creates monitoring table by itself

Published on June 21st 2022 - Listed in MySQL MariaDB Database Monitoring - 0 comments

How to append additional key value pair to a JSON object in MySQL or MariaDB

Published on May 13th 2022 - Listed in MySQL MariaDB Database Linux Coding - 0 comments

Invoice Ninja v5: How to make the Account Management setting available to additional (admin) users

Published on April 29th 2022 - Listed in Internet Personal Databases - 0 comments

MySQL / MariaDB mysqldump error: Cannot load from mysql.proc. The table is probably corrupted (1728)

Published on March 17th 2022 - Listed in MySQL MariaDB Database Linux Backup - 2 comments

Icingaweb2 error: Base table or view not found (rememberme does not exist)

Published on March 15th 2022 - last updated on January 31st 2023 - Listed in Icinga MySQL Databases - 1 comments

Python coding: Why query results of mysql.connector are in brackets and how to print real values

Published on March 10th 2022 - Listed in Coding Python MySQL Databases - 0 comments

New version of check_couchdb_replication: Rewrite and improvements

Published on February 24th 2022 - Listed in Monitoring CouchDB Databases - 0 comments

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Published on January 26th 2022 - last updated on January 28th 2022 - Listed in MySQL MariaDB Database Linux Backup - 0 comments

MySQL / MariaDB not logging errors (log_error file empty) on Ubuntu

Published on October 20th 2021 - Listed in MySQL MariaDB Database Linux - 0 comments

How to fix data corruption and strange characters in InfluxDB measurements and series names

Published on October 8th 2021 - Listed in Influx Database - 1 comments

MySQL syntax error when inserting empty values using PHP (not automatically assigned NULL)

Published on September 22nd 2021 - Listed in PHP MySQL MariaDB Database Coding - 0 comments

Confluence upgrade from 7.7 to 7.13 fails with SQL error on replicated MySQL database

Published on September 6th 2021 - last updated on November 13th 2023 - Listed in Atlassian MySQL Database - 0 comments

Modify InfluxDB subscription to send data to multiple subscribers (asynchronous data replication)

Published on June 28th 2021 - Listed in Influx Database - 0 comments

Galera Cluster wsrep sst crash when trying to sync table without PK (Primary Key)

Published on May 7th 2021 - Listed in MySQL Database MariaDB Galera - 0 comments

MySQL replication out of sync: How to do a full database restore and solve error 1032 (could not execute update_rows)

Published on April 23rd 2021 - last updated on January 31st 2022 - Listed in MySQL Database Database - 7 comments

How to do bulk/mass changes on DNS records in PowerDNS with MySQL backend

Published on March 2nd 2021 - Listed in DNS PowerDNS Linux Coding Shell MySQL Database - 0 comments

How to create a user and grant privileges in MySQL 8.x using GRANT

Published on November 23rd 2020 - Listed in MySQL Database Database - 0 comments

MySQL and MariaDB multi source replication and how to monitor them with check_mysql_slavestatus

Published on September 30th 2020 - Listed in Monitoring MySQL MariaDB Database - 7 comments

Convert database and tables from utf8 to utf8mb4 and solve collation errors in Jira and Confluence

Published on September 29th 2020 - last updated on February 23rd 2022 - Listed in Atlassian Database MySQL - 11 comments

Atlassian Jira not starting, shows setup page in browser and database is not yet configured in logs

Published on September 8th 2020 - Listed in Atlassian Database MySQL - 0 comments

How to install MySQL 5.7 on Ubuntu 20.04 focal (and properly avoid MySQL 8.0 packages)

Published on August 31st 2020 - last updated on February 4th 2022 - Listed in MySQL Database Linux Ubuntu - 9 comments

Error on Tomcat start java.sql.SQLException: The server time zone value CEST is unrecognized after updating MySQL JDBC connector

Published on August 11th 2020 - last updated on August 12th 2020 - Listed in Tomcat Atlassian Database - 0 comments

Speed comparison PHP 7.0 vs. 7.2 vs. 7.4 using MySQL PDO connection

Published on July 21st 2020 - Listed in PHP Linux Database - 0 comments

check_mongodb returns python error on MongoDB 4.x database size check

Published on May 14th 2020 - Listed in Monitoring Database MongoDB - 0 comments

Galera node unable to sync from donor: Requesting state transfer failed: -113(No route to host)

Published on April 21st 2020 - last updated on December 22nd 2020 - Listed in MySQL Database Galera - 2 comments

PostgreSQL returns password authentication failed for user although password is correct

Published on February 14th 2020 - Listed in PostgreSQL Database - 1 comments

Galera cluster unable to sync SST: xtrabackup checkpoints missing, failed innobackupex on donor

Published on September 23rd 2019 - last updated on November 12th 2024 - Listed in MariaDB Database Galera - 0 comments

Monitoring plugin check_mysql_slavestatus now supports mysql option file, socket (and more updates)

Published on August 22nd 2019 - Listed in MySQL MariaDB Database Monitoring - 0 comments

Comparing Galera cluster wsrep sst methods rsync vs. mariabackup

Published on August 20th 2019 - last updated on December 22nd 2020 - Listed in Database MySQL MariaDB Galera - 0 comments

How to monitor MySQL or MariaDB Galera Cluster writes and avoid deadlocks

Published on May 24th 2019 - last updated on December 22nd 2020 - Listed in Database MySQL Monitoring Galera - 0 comments

InfluxDB backup on localhost fails with error: failed copy backup to file: err=

Published on March 14th 2019 - last updated on March 14th 2019 - Listed in Database Influx - 0 comments

How to solve Rancher 1.x service stuck in removing (in progress)

Published on February 13th 2019 - last updated on March 13th 2019 - Listed in Rancher Docker Linux Database MySQL - 1 comments

How to create a new admin user in a clustered CouchDB

Published on November 21st 2018 - Listed in CouchDB Database - 0 comments

Creating an InfluxDB asynchronous replication using subscription service

Published on November 13th 2018 - last updated on February 20th 2023 - Listed in Database Influx Monitoring Icinga - 1 comments

MariaDB Galera Cluster: When the data is in sync but the query results differ

Published on November 9th 2018 - Listed in MySQL MariaDB Database Galera - 0 comments

Fix table increment counter in MariaDB or MySQL after manual row deletion

Published on July 24th 2018 - Listed in PHP MySQL MariaDB Database - 0 comments

Freeing up disk space from CouchDB - do not forget the views!

Published on July 19th 2018 - Listed in CouchDB Database DB Linux - 3 comments

Rancher 1.6: Github user not able to login (Internal Server Error)

Published on May 31st 2018 - Listed in Docker Rancher Linux DB Database MySQL Git - 0 comments

Quickly show character sets and collations of all tables in a MySQL database

Published on May 30th 2018 - last updated on September 29th 2020 - Listed in DB Database MySQL - 0 comments

How to build a generic Icinga2 service graph in Grafana using InfluxDB

Published on May 11th 2018 - Listed in Icinga Monitoring Grafana Influx Database - 2 comments

Galera node on Ubuntu 14.04 Trusty not joining after update to MariaDB 10.0.34

Published on April 25th 2018 - last updated on December 22nd 2020 - Listed in MySQL MariaDB Database DB Galera - 0 comments

New version of check_couchdb_replication allows check of all replications

Published on March 26th 2018 - Listed in Database DB CouchDB Nagios Icinga Monitoring - 0 comments

New monitoring plugin check couchdb replication to monitor CouchDB replications

Published on January 8th 2018 - Listed in Nagios Icinga Monitoring Database CouchDB - 0 comments

New version of check_es_system plugin fixes authentication problems

Published on January 5th 2018 - Listed in Monitoring Nagios Icinga Elasticsearch DB Database - 0 comments

Recover a crashed MySQL or MariaDB InnoDB database from ibd files

Published on December 13th 2017 - Listed in Database DB MySQL MariaDB - 2 comments

Create separate measurement tables in InfluxDB for Icinga 2 NRPE checks

Published on December 12th 2017 - last updated on February 20th 2023 - Listed in Icinga Monitoring Influx Database - 3 comments

Icinga2 graphing with InfluxDB and Grafana

Published on December 8th 2017 - last updated on April 25th 2024 - Listed in Icinga Monitoring Influx Database - 1 comments

Automatically cleaning up archived WAL files on a PostgreSQL server

Published on October 27th 2017 - Listed in DB Postgres PGSQL Database PostgreSQL - 7 comments

check_mssql_health: Monitoring MSSQL with SQL query and negative thresholds

Published on July 28th 2017 - Listed in Windows Monitoring Database DB - 0 comments

How to monitor a PostgreSQL replication

Published on July 26th 2017 - last updated on June 15th 2021 - Listed in DB Postgres Database Monitoring Icinga Nagios - 3 comments

Unable to delete application link in JIRA (NullPointerException: consumer)

Published on April 3rd 2017 - Listed in Linux Database Windows Atlassian - 0 comments

Galera Arbitrator garbd not starting: Exception in creating receive loop

Published on March 29th 2017 - last updated on December 22nd 2020 - Listed in MySQL DB Database MariaDB Galera - 1 comments

Tackling Confluence migration issues (Windows+MSSQL to Linux+MariaDB)

Published on March 24th 2017 - Listed in Linux Database MySQL Windows Atlassian - 0 comments

MySQL InnoDB: Operating system error number 13 in a file operation

Published on February 21st 2017 - Listed in Linux Database MySQL - 0 comments

Update MySQL table by appending text to existing column value

Published on October 6th 2016 - Listed in MySQL DB Database - 0 comments

How to measure the data size (usage) of single tables or databases in MariaDB or MySQL

Published on January 27th 2016 - last updated on February 6th 2023 - Listed in Database MySQL MariaDB - 1 comments

It is 2015 and we still should not use MongoDB (POV of a Systems Engineer)

Published on September 15th 2015 - last updated on February 11th 2023 - Listed in Database MongoDB DB - 0 comments

MongoDB 3.x: Create log rotation script

Published on July 6th 2015 - Listed in DB MongoDB Database - 4 comments

Allow user to execute eval() command on MongoDB 3.x

Published on May 26th 2015 - Listed in DB MongoDB Database - 1 comments

Authentication on MongoDB 3.x fails with mechanism MONGODB-CR

Published on May 20th 2015 - Listed in MongoDB Database - 6 comments

MySQL replication not working - but in SHOW SLAVE STATUS everything is OK

Published on January 16th 2015 - Listed in MySQL Database Solaris Nagios Monitoring - 0 comments

MySQL Galera cluster not starting (failed to open channel)

Published on July 14th 2014 - last updated on December 22nd 2020 - Listed in MySQL Database Galera - 3 comments

How to do a Redis Master Slave switch/failover

Published on April 24th 2014 - last updated on May 26th 2021 - Listed in Database Linux Redis - 0 comments

check_mysql_slavestatus now works with MySQL 5.6

Published on January 6th 2014 - Listed in MySQL Database - 0 comments

How to change the collation of a MySQL database

Published on December 11th 2013 - Listed in MySQL Database - 1 comments

check_mysql_slavestatus plugin now handles IO Running in Connecting state

Published on October 17th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

New version of check_mysql_slave released (minor bugfixes)

Published on September 27th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

You have an error in your SQL syntax - single quote in text issue

Published on September 19th 2013 - Listed in PHP MySQL Database - 2 comments

MySQL: Created table did not inherit default collation of database

Published on August 29th 2013 - Listed in Database MySQL - 0 comments

First steps with MongoDB: Create a real admin user (DBA)

Published on July 24th 2013 - last updated on February 1st 2022 - Listed in MongoDB Database - 0 comments

MySQL replication stopped due to crashed table (Error no 144)

Published on July 18th 2013 - Listed in MySQL Database Unix - 0 comments

MySQL (Percona) replication stopped due to corrupt innodb ibd file

Published on June 18th 2013 - Listed in MySQL Solaris SmartOS Unix Database - 0 comments

Updated check_mysql_slavestatus plugin and documentation

Published on April 28th 2013 - Listed in Nagios MySQL Database Monitoring - 0 comments

SmartOS: svcs: Could not bind to repository server. Finding the cause.

Published on January 9th 2013 - Listed in Solaris Shell Database SmartOS Unix - 8 comments

MySQL: Cannot create or drop Stored Procedures when binary logs active

Published on January 7th 2013 - Listed in Database Linux MySQL - 0 comments

Weird case: MySQL causing high disk IO when ZFS filesystem shrinks

Published on December 18th 2012 - Listed in BSD Database Shell MySQL ZFS Rant - 1 comments

Get MySQL Status - but only some values

Published on November 28th 2012 - Listed in Database Linux Shell MySQL - 2 comments

Some notes on a MySQL downgrade 5.1 to 5.0

Published on August 16th 2012 - Listed in Linux Database MySQL - 0 comments

Basic math calculations with fields in MySQL query (output in new column)

Published on March 7th 2012 - Listed in Linux Database MySQL - 0 comments

Upgrade of VPS server (Xen) from Debian Lenny to Squeeze (MySQL problems)

Published on February 4th 2012 - Listed in Linux MySQL Database - 0 comments

Minor update of Nagios plugin check_mysql_slavestatus

Published on December 27th 2011 - Listed in Nagios Database MySQL Monitoring - 0 comments

SLES11SP1 asks for db-devel - but there isn't any

Published on November 21st 2011 - Listed in Linux Database - 2 comments

How to install perl DBD::Oracle on SLES10 (without CPAN)

Published on September 27th 2011 - Listed in Linux Database - 0 comments

How to dump and restore a Postgres database

Published on June 24th 2011 - Listed in Linux Database Postgres - 0 comments

Perfdata now in check_mysql_slavestatus

Published on June 22nd 2011 - Listed in Linux Nagios Database MySQL Monitoring - 0 comments

Howto change default MySQL privileges/permissions in Confixx

Published on May 24th 2011 - Listed in Linux Internet Database MySQL - 0 comments

HowTo Change Confixx email account password in Roundcube

Published on August 14th 2010 - Listed in Internet Linux PHP Database MySQL Roundcube - 0 comments

Wrong latin1 Umlaut entries with phpMyAdmin 3.1.0

Published on December 4th 2008 - Listed in PHP Database MySQL - 0 comments

Cleanup Confixx after a server transfer

Published on October 21st 2008 - Listed in Linux MySQL Database - 0 comments

Update of Nagios Plugin check_mysql_slavestatus.sh

Published on October 16th 2008 - Listed in Nagios Shell MySQL Monitoring Database - 0 comments