Systemd

When we work with PostgreSQL under our myEnv, we regularly get shared memory segment errors. Example:

psql: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed:
FATAL:  could not open shared memory segment "/PostgreSQL.4220847662":
No such file or directory

or we see similar messages in the PostgreSQL error log:

ERROR:  could not open shared memory segment "/PostgreSQL.4220847662":
No such file or directory

Because I am a MariaDB/MySQL admin, I am not very familiar with …

Table of Contents

• SystemD Notizen
• InnoDB NUMA interleave with MariaDB
• Checking Galera Cluster SST timeout with SystemD
• Kill MariaDB Galera node under SystemD
• MariaDB Memory locking (--memlock) with SystemD
• Who is restarting my mariadbd?
• Location of SystemD unit files

SystemD Notizen

SystemD paged per default nach less. Das ist ungewohnt und doof, weil es gegen allgemeines Linux-Verhalten verstösst. Abhilfe schafft:

shell> systemctl --no-pager status
shell> alias systemctl='systemctl --no-pager'

Das …