Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
249
questions
0
votes
0
answers
121
views
Analyze MariaDB error logs to get information what were happened on server
Can you help me understand what was happen on MariaDB server. I wasn't able to connect to this server because there was 'Too many connections'. This is one of our slave in replication so non of main ...
- 500
0
votes
1
answer
147
views
How is the current sequence number in the control file used during recovery?
During recovery, how is the current sequence number used to determine the redo log files used to re-construct the database as well as the order in which to apply the changes recorded in them?
- 131
0
votes
2
answers
358
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
3
votes
1
answer
2k
views
MySQL 8.0.30+: redo_log_capacity vs log_file_size?
Cheers. We're trying to track down the cause of a significant increase in IO load after switching from MySQL 5.7 to 8.0.30, and one issue we've noticed is related to this part of documentation:
The ...
- 33
0
votes
1
answer
126
views
Cassandra has stopped producing log files
I've recently taken up the role of managing a Cassandra Cluster that has been running in production for a few years. This is my first time working with Cassandra so I would appreciate any insights.
It ...
3
votes
1
answer
278
views
PostgreSQL time series table with composite partitions
I am investigating how I might structure a PostgreSQL table to store a large amount of time stamped data that also needs to be portioned by another field.
My expected data structure will be something ...
- 33
2
votes
1
answer
558
views
How to enable authentication logs in Firebird 2.5?
I downloaded Firebird 2.5 from the official website and installed on a Linux machine. The install location is /opt/firebird.
I want to be able to view authentication attempt logs for security reasons (...
0
votes
1
answer
211
views
Database alters MOUNT mode after reboot
We have Oracle XE 10.2.0.1.0 running on CentOS 6.9.
The Database works stable all the time, except the system reboots.
If reboot command is issued in the OS terminal, the Database enters MOUNT mode.
...
1
vote
0
answers
73
views
SSIS in Azure: operation_messages_scaleout event_messages_scaleout tables not populating
We are running SSIS packages in AZure. I am finding that for some reason we have stopped populating the SSISDB tables (operation_messages_scaleout, event_messages_scaleout). It does appear that the ...
- 11
0
votes
1
answer
179
views
How to log deadlocks for each database separately
I have MariaDB 10.6.5 server with several databases.
I added a line innodb_print_all_deadlocks = 1 to config file.
Now all deadlocks are logged to one file /var/log/mysql/mariadb.err
Is there any way ...
- 1
0
votes
1
answer
270
views
Do we need additional license to dump goldengate trail logs to kafka?
We have a Oracle (12c) GoldenGate license only (we do not have an oracle goldengate for big data).
We need to transfer the gg trail logs to kafka then to hdfs.
Do we need to buy the oracle goldengate ...
- 3
0
votes
0
answers
136
views
Log files are still created even when general_log is OFF - MySQL (MariaDB)
I have a MySQL server (10.4.21-MariaDB) installed by the XAMPP stack on ubuntu.
I notice in the mysql folder (/opt/lampp/var/mysql) several files:
ip-172-31-14-21.err
ip-172-31-14-21.log
ip-172-31-14-...
- 111
0
votes
0
answers
217
views
MariaDB rotated logs are empty on CentOS7
I've been having the same problem for a couple of weeks now. I have the following /etc/logrotate.d/mariadb file configuration:
/var/log/mariadb/*.log {
create 600 mysql mysql
...
- 3
0
votes
0
answers
53
views
Postgres connection logged temp file, but no query?
I'm going over some logs for a Postgres database and came across the following logs and I'm at a loss as to what would've caused it.
connection authorized: user=app1 database=pg SSL enabled (protocol=...
- 581
0
votes
1
answer
389
views
SQL Server 2017 freezing during bulk insert of large file into in-memory staging table
Running SQL Server 2017 CU20 Standard on a dedicated Dell PowerEdge with 28 cores and 192GB of RAM.
I have a stored procedure that processes large files (~7GB each) in a loop by bulk inserting them ...
- 123
0
votes
1
answer
207
views
convert RDS csvlog into pgreplay-go compatible for replaying
Before upgrading AWS RDS PostgreSQL version at production, I want to replay 1-hour recorded logs at the test instance.
Unfortunately pgreplay is single-threaded application, limited by single CPU ...
- 101
0
votes
1
answer
118
views
Postgresql log uploading service on Ubuntu Linux
I am trying to create a systemctl service to collect + upload logs for Postgresql 12 on Ubuntu Linux. However, I am expert at none of the two.
While I have set up the server modifying /etc/postgresql/...
- 103
1
vote
1
answer
541
views
Clear PostgreSQL logs in AWS Ubuntu Server
I am trying to clear the logs of an postgresql under /var/log/postgresql/ but I am getting error message as below:
/var/log/postgresql$ sudo > postgresql-11-main.log
-bash: postgresql-11-main.log:...
- 113
1
vote
1
answer
641
views
An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action
Background:
I am trying to keep a track record of what users are querying in the database. One option I found is to create a Server and Database Audit Specification. I did not want to include INSERT ...
- 113
0
votes
1
answer
413
views
How to monitor for MySQL select queries that return too many records? [closed]
I realize there are simple ways to limit results in SQL. I have a legacy implementation. I would like to get a handle on select queries that return results exceeding some user defined limit. The goal ...
- 101
1
vote
0
answers
195
views
User names in postgres docker image logs
I'm looking to get thorough logs of user activity attributable back to users from the official docker image of Postgres. I'm running my docker image like so:
docker run --name pg -e POSTGRES_PASSWORD=...
- 317
0
votes
2
answers
904
views
"user does not exist " when calling DBMS_LOGMNR.START_LOGMNR
I have a CDB user called "MYADMIN" and I'm trying to make it connect to log miner.
-- enable calling admin username on CDB
ALTER SESSION set "_ORACLE_SCRIPT"=true
/
-- create ...
- 874
1
vote
1
answer
287
views
Why am I able to create MV logs using PK — even though there is no PK?
I have a table that does not have a primary key:
I'm able to create MV logs on the table — without specifying whether to use the primary key or the rowid:
create materialized view log on maximo....
- 1,447
0
votes
0
answers
135
views
After a reboot and latest CU for sqlserver 2017 I get this annoying message
After a reboot and latest CU for sqlserver 2017 I get this annoying message (the xxxxx was a number)
SSBDT: Dialog timer delete during registration (did:
xxxxxxxxxxxxxxxxxxxxxxxxxxxx:Initiator, ...
0
votes
1
answer
129
views
Mysql falls every day
My database Mysql fallas every day:
Looking at the tail -100 /var/log/mysqld.log
Shows:
2020-08-16 20:56:03 7f787c7fb700 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.
...
0
votes
1
answer
34
views
SQL Backup routine regarding DB Logs
I recently had an incident that got me rethinking my backup plan: One of our MSSQL driven aplications stalled because the log fle had grown too big on the filesystem (it was 50 GBs IIRC).
It turned ...
- 15
1
vote
2
answers
314
views
Non-deterministic functions and row-based binary logging (MySQL)
Newbie questions. I'm working on a MySQL project that will use only row-level binary logging. There will be no replication. Since logging is row-level, does it even matter if a function is ...
- 123
1
vote
1
answer
183
views
Why does SQL Server Backupset table goes back a few months, but Agent Logs go back further?
I ran this script looking at the history of my backups for the past month.
select * from msdb.dbo.backupset order by backup_start_date
No problem, but if I want to go back to Jan 2020, there are no ...
- 295
0
votes
1
answer
1k
views
Stop logging INSERT INTO statements in PostgreSQL (but keep SELECT)
Using logging_collector = on and log_statement = 'all' (from postgresql.conf), currently my log files are correctly populated with every single query that has been executed.
This works great. Except.....
- 121
0
votes
0
answers
31
views
Suggestion for log storage with search by keywords/tag
I'm trying to find a solution for dealing with a data set of logs of about 500Gb. Ideally what I search for is an index over log message keywords that I parse from the log messages. Like:
Log message
...
- 101
5
votes
2
answers
22k
views
how to list all features installed in a sql server instance?
There are other Installation related questions with similar details here and here.
I could not find anything related to listing the installed features in sql server 2016 though.
I can do it manually ...
- 15.8k
0
votes
1
answer
1k
views
MongoDB deleted logs
So I recently realized my /var directory was growing but couldn't find anything using du, then find out about lsof and found the following:
lsof -nP | grep '(deleted)'
mongod 23184 23205 ...
- 1
0
votes
1
answer
417
views
auto_explain does not log
looks like i do it wrong. I turned auto_explain on with adding next valued to postgresql.conf:
shared_preload_libraries = 'pg_stat_statements,pg_wait_sampling,pg_stat_kcache,auto_explain'
...
- 421
5
votes
1
answer
9k
views
Raise NOTICE, Raise INFO not saved to logs in POSTGRES
I searched a lot on google but no solution found, I am not sure what I am missing here.
My intention here is to store the notice , info from this procedure to postgres logs (txt files) that are ...
- 53
1
vote
0
answers
392
views
Why is failed job not logged in SQL Server Agent Error Log?
I have a failed job which is logged in SQL Server Logs but not logged in SQL Server Agent Error Logs. The job is executed as user: NT SERVICE\SQLSERVERAGENT. Limit size of job history and Remove agent ...
- 1,253
0
votes
0
answers
16
views
How to correctly have binary logs stored.....Mysql/Maria
So I'm taking a full backup at 12AM each day.
At 2,4,6,8,10etc etc I'm taking incrementals.
Using Mariadb and maraibackup...
At each point I want to flush and purge the logs so I don't have to ...
- 139
0
votes
2
answers
234
views
Can't see process progress, machine getting slow trying to import 500 million records
Working environment:
PostgreSQL 12.0, Ubuntu 18.10, 4GB memory, i5-3230M CPU @ 2.60GHz × 4, Os 64 bits
I'm trying to import a .csv file with more than 500 million records into a PostgreSQL db table, ...
- 63
1
vote
1
answer
77
views
Logging security events in MSSQL
I need to log events of admin changing someone's password, and user changing his password. How do I do that?
I've found a nice solution based on Service Broker, however the resulting table only ...
- 113
1
vote
2
answers
952
views
how to find out how long the last DBCC checkdb took to complete?
In most of my servers I have dbcc checkdb scheduled to run.
I can get the last known good DBCC Checkdb through DBCC DBINFO().
I can read the tracks left on the sql server log and I get something ...
- 15.8k
-2
votes
1
answer
244
views
SQL Server Event Log Summary [closed]
I want to generate a daily summary of SQL Server Event Logs which will be sent via email. I have currently been able to set up SQL email alerts for error logs,but they are sent individualy when an ...
0
votes
0
answers
531
views
Disable mysql general query log for specific user (or schema)?
MySQL can log all queries in what is called "General Log"
Is there a way to keep this query log but skip all queries for a specific user? Or maybe for a specific database?
I would like so because I ...
- 195
3
votes
0
answers
226
views
Is binary log purging done by expire_logs_days equivalent to PURGE BINARY LOGS?
In a MySQL replication environment where replication is done with binary logs, if you run PURGE BINARY LOGS on the master, the server will not delete logs that are currently being replicated by a ...
- 131
1
vote
2
answers
82
views
Can anything reveal that 2 independant entries were created or updated at the same time?
Imaginary example, simplified to better explain the question.
Let's say I have a form with the following fields :
user email
who did you vote for in 2012
who did you vote for in 2016
When submitted, ...
- 13
0
votes
0
answers
22
views
MYSQL need log executed query in table along with executed user name
I would to like the executed quires with entire database tables for some mysql users only. Because some of users executed wrong query in production environment. And needs to store this log in new ...
1
vote
0
answers
284
views
How to change permissions of Oracle generated logs?
The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions ...
- 183
2
votes
2
answers
279
views
is it possible to trim the table output for a specific job?
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
Log ...
- 15.8k
1
vote
3
answers
7k
views
How to change the expiration date of binlog files?
I have a server with Ubuntu 18.04 and MySQL 8.0.11
I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate.
How to change the expiration date of binlog files ?
...
- 83
5
votes
2
answers
744
views
Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?
If I size my log files to evenly split the entire drive they reside on, leaving no extra space available, will log backups still be able to occur successfully? I have several databases, with one log ...
- 35.2k
-2
votes
1
answer
272
views
Centralized Logs (error, deadlocks, slow queries) For SQL Servers
I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk stack.
What is the best and performant way to send these kind of logs to a log collector?
I ...
- 663
0
votes
0
answers
23
views
Log file is growing up and is not releasing space [duplicate]
The database is under Full Recovery Method, the DBCC SQLPERF (LOGSPACE) shows 3 % used. Even after I take Log back ups frequently it is not releasing space. There is no active transaction and ...
- 1,039