Updated at March 20, 2024 06:18 AM
Getting database logs
Логи баз данных доступны только для БД, созданных после 1 декабря 2020 года.
В настоящее время реализована возможность получения логов для следующих баз данных:
- MySQL
- PostgreSQL/PostgresPro
- ClickHouse
- Redis
- MongoBD
Отметим, что для реализации получения логов необходимо подключиться к БД по SSH.
Ниже представлено детальное описание получения логов из каждого типа БД.
Для получения логов необходимо подключиться по SSH и ввести следующую команду:
\[admin@mysql-8658 ~\]journalctl -u mysqld
Далее, ответом будут выведены логи:
\-- Logs begin at Fri 2020-12-25 08:35:15 UTC, end at Mon 2021-01-11 18:41:34 UTC. --Dec 25 08:35:21 mysql-v5dot6-2020-11-30.novalocal systemd\[1\]: Starting MySQL Community Server...Dec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 0 \[Warning\] TIMESTAMP with implicit DDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 0 \[Note\] Ignoring --secure-file-privDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 0 \[Note\] /usr/sbin/mysqld (mysqld 5.6Dec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Using atomics toDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: The InnoDB memoryDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Mutexes and rw\_loDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Memory barrier isDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Compressed tablesDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Using Linux nativDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Using CPU crc32 iDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Initializing buffDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Completed initialDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: The first specifiDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Setting file ./ibDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Database physicalDec 25 08:35:25 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:25 1276 \[Note\] InnoDB: Setting log fileDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Setting log fileDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Renaming log fileDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Warning\] InnoDB: New log filesDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Doublewrite buffeDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Doublewrite buffeDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: 128 rollback segmDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Warning\] InnoDB: Creating foreiDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Foreign key constDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Creating tablespaDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Tablespace and daDec 25 08:35:26 mysql-8658.novalocal mysql-systemd-start\[867\]: 2020-12-25 08:35:26 1276 \[Note\] InnoDB: Waiting for purgelines 1-29
Для получения логов необходимо подключиться по SSH и ввести следующую команду:
\[admin@postgresql-9641 ~\]journalctl -u postgresql
Далее, ответом будут выведены логи:
\-- Logs begin at Fri 2020-12-25 07:48:19 UTC, end at Mon 2021-01-11 18:46:16 UTC. --Dec 25 07:48:25 postgresql-12-2020-12-11.novalocal systemd\[1\]: Starting PostgreSQL 12 database server...Dec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.309 UTC \[883\] LOG: starting PosDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.310 UTC \[883\] LOG: listening onDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.310 UTC \[883\] LOG: listening onDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.315 UTC \[883\] LOG: listening onDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.364 UTC \[883\] LOG: listening onDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.414 UTC \[883\] LOG: redirectingDec 25 07:48:25 postgresql-12-2020-12-11.novalocal postmaster\[883\]: 2020-12-25 07:48:25.414 UTC \[883\] HINT: Future logDec 25 07:48:25 postgresql-12-2020-12-11.novalocal systemd\[1\]: Started PostgreSQL 12 database server.Dec 25 07:48:32 postgresql-9641.novalocal systemd\[1\]: Stopping PostgreSQL 12 database server...Dec 25 07:48:32 postgresql-9641.novalocal systemd\[1\]: Stopped PostgreSQL 12 database server.Dec 25 07:48:40 postgresql-9641.novalocal systemd\[1\]: Starting PostgreSQL 12 database server...Dec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.885 GMT \[1660\] LOG: starting PostgreSQLDec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.885 GMT \[1660\] LOG: listening on IPv4 aDec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.885 GMT \[1660\] LOG: listening on IPv6 aDec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.905 GMT \[1660\] LOG: listening on Unix sDec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.962 GMT \[1662\] LOG: database system wasDec 25 07:48:40 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:40.998 GMT \[1660\] LOG: database system isDec 25 07:48:41 postgresql-9641.novalocal systemd\[1\]: Started PostgreSQL 12 database server.Dec 25 07:48:41 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:41.023 GMT \[1671\] FATAL: role "os\_admin" dDec 25 07:48:41 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:41.039 GMT \[1673\] FATAL: role "os\_admin" dDec 25 07:48:41 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 07:48:41.082 GMT \[1677\] FATAL: role "os\_admin" dDec 25 13:20:10 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 13:20:10.575 GMT \[16971\] FATAL: unsupported fronDec 25 13:20:10 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 13:20:10.833 GMT \[16972\] FATAL: unsupported fronDec 25 13:20:11 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 13:20:11.086 GMT \[16973\] FATAL: no PostgreSQL usDec 25 16:16:02 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 16:16:02.956 GMT \[19980\] FATAL: unsupported fronDec 25 16:16:03 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 16:16:03.333 GMT \[19981\] FATAL: unsupported fronDec 25 16:16:03 postgresql-9641.novalocal postmaster\[1660\]: 2020-12-25 16:16:03.711 GMT \[19982\] FATAL: no PostgreSQL uslines 1-29
Для получения логов необходимо подключиться по SSH и ввести следующую команду:
\[admin@clickhouse5992 ~\]less /var/log/clickhouse-server/clickhouse-server.log
Далее, ответом будут выведены логи:
2020.12.25 20:27:13.406404 \[ 1025 \] {} <Information> SentryWriter: Sending crash reports is disabled2020.12.25 20:27:13.433539 \[ 1025 \] {} <Trace> Pipe: Pipe capacity is 1.00 MiB2020.12.25 20:27:13.583904 \[ 1025 \] {} <Information> : Starting ClickHouse 20.8.4.11 with revision 54438, no build id, PID 10252020.12.25 20:27:13.584058 \[ 1025 \] {} <Information> Application: starting up2020.12.25 20:27:13.823630 \[ 1025 \] {} <Trace> Application: Will mlockall to prevent executable memory from being paged out. It may take a few seconds.2020.12.25 20:27:14.690702 \[ 1025 \] {} <Trace> Application: The memory map of clickhouse executable has been mlock'ed2020.12.25 20:27:14.691026 \[ 1025 \] {} <Debug> Application: rlimit on number of file descriptors is 5000002020.12.25 20:27:14.691049 \[ 1025 \] {} <Debug> Application: Initializing DateLUT.2020.12.25 20:27:14.691056 \[ 1025 \] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.2020.12.25 20:27:14.691101 \[ 1025 \] {} <Debug> Application: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it2020.12.25 20:27:14.770070 \[ 1025 \] {} <Debug> Application: Configuration parameter 'interserver\_http\_host' doesn't exist or exists and empty. Will use 'clickhouse5992.novalocal' as replica host.2020.12.25 20:27:14.771874 \[ 1025 \] {} <Debug> ConfigReloader: Loading config '/etc/clickhouse-server/users.xml'2020.12.25 20:27:14.773718 \[ 1025 \] {} <Debug> ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration2020.12.25 20:27:14.774576 \[ 1025 \] {} <Debug> ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration2020.12.25 20:27:14.775142 \[ 1025 \] {} <Warning> Access(local directory): File /var/lib/clickhouse/access/users.list doesn't exist2020.12.25 20:27:14.775180 \[ 1025 \] {} <Warning> Access(local directory): Recovering lists in directory /var/lib/clickhouse/access/2020.12.25 20:27:14.775619 \[ 1025 \] {} <Information> Application: Uncompressed cache size was lowered to 1.85 GiB because the system has low amount of memory2020.12.25 20:27:14.775701 \[ 1025 \] {} <Information> Application: Mark cache size was lowered to 1.85 GiB because the system has low amount of memory2020.12.25 20:27:14.775850 \[ 1025 \] {} <Information> Application: Setting max\_server\_memory\_usage was set to 3.33 GiB (3/var/log/clickhouse-server/clickhouse-server.log
Для получения логов необходимо подключиться по SSH и ввести следующую команду:
\[admin@redis-4275 ~\]journalctl -u redis
Далее, ответом будут выведены логи:
\-- Logs begin at Mon 2021-01-11 15:45:47 UTC, end at Mon 2021-01-11 19:06:17 UTC. --Jan 11 15:45:47 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:47.013 \* MASTER <-> REPLICA sync startJan 11 15:45:47 redis-4275.novalocal redis\[1440\]: MASTER <-> REPLICA sync startedJan 11 15:45:47 redis-4275.novalocal redis\[1440\]: Non blocking connect for SYNC fired the event.Jan 11 15:45:47 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:47.034 \* Non blocking connect for SYNCJan 11 15:45:47 redis-4275.novalocal redis\[1440\]: Error reply to PING from master: '-Reading from master: Resource tempoJan 11 15:45:47 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:47.050 # Error reply to PING from mastJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Connecting to MASTER 194.40.243.61:8886Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.016 \* Connecting to MASTER 194.40.2Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.016 \* MASTER <-> REPLICA sync startJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: MASTER <-> REPLICA sync startedJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Non blocking connect for SYNC fired the event.Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.035 \* Non blocking connect for SYNCJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Master replied to PING, replication can continue...Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.053 \* Master replied to PING, repliJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Partial resynchronization not possible (no cached master)Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.089 \* Partial resynchronization notJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Full resync from master: ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ:1Jan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.108 \* Full resync from master: ZZZZJan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.108 \* MASTER <-> REPLICA sync: receJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: MASTER <-> REPLICA sync: receiving 55648 bytes from masterJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: MASTER <-> REPLICA sync: Flushing old dataJan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.181 \* MASTER <-> REPLICA sync: FlusJan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.182 \* MASTER <-> REPLICA sync: LoadJan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.182 # Wrong signature trying to loaJan 11 15:45:48 redis-4275.novalocal redis-server\[1440\]: 1440:S 11 Jan 2021 15:45:48.182 # Failed trying to load the MASJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: MASTER <-> REPLICA sync: Loading DB in memoryJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Wrong signature trying to load DB from fileJan 11 15:45:48 redis-4275.novalocal redis\[1440\]: Failed trying to load the MASTER synchronization DB from disklines 1-29
Для получения логов необходимо подключиться по SSH и ввести следующую команду:
\[admin@mongodb-5604 ~\]$ journalctl -u mongod
Далее, ответом будут выведены логи:
\-- Logs begin at Thu 2020-12-31 03:20:03 UTC, end at Mon 2021-01-11 19:09:03 UTC. --Dec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.602+0000 I NETWORK \[listener\] connectionDec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.602+0000 I NETWORK \[conn49341\] receivedDec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.605+0000 I NETWORK \[listener\] connectionDec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.605+0000 I NETWORK \[conn49342\] receivedDec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.608+0000 I NETWORK \[conn49341\] end conneDec 31 03:20:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:20:16.608+0000 I NETWORK \[conn49342\] end conneDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.604+0000 I NETWORK \[listener\] connectionDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.605+0000 I NETWORK \[conn49343\] receivedDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.606+0000 I NETWORK \[listener\] connectionDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.607+0000 I NETWORK \[conn49344\] receivedDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.609+0000 I NETWORK \[conn49343\] end conneDec 31 03:21:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:21:16.610+0000 I NETWORK \[conn49344\] end conneDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.607+0000 I NETWORK \[listener\] connectionDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.608+0000 I NETWORK \[conn49345\] receivedDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.609+0000 I NETWORK \[listener\] connectionDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.609+0000 I NETWORK \[conn49346\] receivedDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.611+0000 I NETWORK \[conn49345\] end conneDec 31 03:22:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:22:16.612+0000 I NETWORK \[conn49346\] end conneDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.612+0000 I NETWORK \[listener\] connectionDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.613+0000 I NETWORK \[conn49347\] receivedDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.613+0000 I NETWORK \[listener\] connectionDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.614+0000 I NETWORK \[conn49348\] receivedDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.615+0000 I NETWORK \[conn49347\] end conneDec 31 03:23:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:23:16.616+0000 I NETWORK \[conn49348\] end conneDec 31 03:24:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:24:16.611+0000 I NETWORK \[listener\] connectionDec 31 03:24:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:24:16.611+0000 I NETWORK \[conn49349\] receivedDec 31 03:24:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:24:16.612+0000 I NETWORK \[listener\] connectionDec 31 03:24:16 mongodb-5604.novalocal mongod.27017\[1718\]: 2020-12-31T03:24:16.613+0000 I NETWORK \[conn49350\] receivedlines 1-29
--