Questions tagged [log]
The log tag has no summary.
162 questions
0 votes
0 answers
46 views
MongoDB log rotation only happens on reboot, not daily as expected
I'm trying to use LogRotate to manage my MongoDB logs because they were growing too large. My goal is to: Create a new log file daily Compress old logs Keep logs for only the last 14 days Delete ...
0 votes
2 answers
11k views
How to upgrade MySQL from 8.0 to 8.4?
I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
John John
0 votes
2 answers
1k views
What's inside a redo record in Oracle's Redo log?
While reading the Redo log wiki page, I was confronted with the following statement: For example, if a user UPDATEs a salary-value in a table containing employee-related data, the DBMS generates a ...
- 131
0 votes
1 answer
599 views
getting the name of the function which caused trigger to activate in postgresql
Is there a way to get name of the function/procedure, which contains query, which caused a TRIGGER to activate? For example I have function update_user_whatever and it updates user data and I want to ...
- 107
0 votes
1 answer
680 views
Recover deleted redo log files
I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
- 228
1 vote
1 answer
188 views
Cassandra System.Log shows nodtool tpstats output
We have a Docker Cassandra container running 6.8.21. At times when the container is restarted the the Logs show the usual startup activities and all just works well post that. But on a few occasions ...
- 11
0 votes
1 answer
663 views
mssql 2019 alwayson cluster backup log chain is broken
now i had one mssql 2019 alwayson cluster.i backup database on master node using monthly fullbackup. weekly differential backup. daily log backup. but unfortunately then backup log chain always ...
- 1
1 vote
1 answer
2k views
How to delete MongoDB log files
We are using MongoDB 4.0.4 version for our project. The database configuration is done as below: Created a custom database in MongoDB and the service is running in authentication mode. Using Windows ...
1 vote
4 answers
2k views
PostgreSQL logging: Statements splits into multiple lines
In PostgreSQL v10 and above, I activated the logging of the statements using the extension pg_stat_statements. My configuration: logging_collector = on log_line_prefix = '%t [%p]: [%l-1] db=%d,user=%u,...
- 29
1 vote
0 answers
56 views
How to solve Log shipping issues when Shadow copy volume-level backups are in place?
How to solve Log shipping issues when Shadow copy volume-level backups are in place? I tried setting up log shipping but it failed each time because the backup chain of the virtual log, the block ...
- 11
0 votes
1 answer
293 views
MariaDB Understanding "Event" Interval
I've created my first EVENT: ALTER EVENT flush_logs_event ON SCHEDULE EVERY 6 HOUR COMMENT 'Rotate /var/log/mysql/master-bin*' DO FLUSH LOGS; I changed it from "12" to "6" ...
- 187
0 votes
1 answer
1k views
MariaDB master-bin Log Rotation
I've just setup MariaDB replication with 2 slaves in Debian 11 (Bullseye). I'm a bit alarmed to see the file size reach such a size without log rotation: -rw-rw---- 1 mysql adm 297394983 Dec 8 05:...
- 187
1 vote
3 answers
1k views
WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly
My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
1 vote
1 answer
725 views
MariaDB hidden disk usage for log dir
We have a simple master/slave cluster in our environment which is sets up on Ubuntu 20.04 and MariaDB 10.5: MariaDB [(none)]> SELECT VERSION(); +--------------------------------------------+ | ...
0 votes
0 answers
71 views
Detail about communication packets error log
On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day: 2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading communication packets My question is ...
- 139