Skip to main content

Questions tagged [logs]

A sequential journal of database write operations that facilitates robust atomic write operations.

Filter by
Sorted by
Tagged with
0 votes
0 answers
62 views

Mariadb is not truncating even Innodb Undo log Truncate is On

we have configured the below settings in our configuration file. --innodb_file_per_table=1 --innodb_undo_tablespaces=3 --innodb_undo_directory=/var/lib/mysql/ --innodb_undo_log_truncate=ON --...
chwajahat's user avatar
0 votes
1 answer
156 views

How to delete "SQL Server Agent" logs from "Log File Viewer"?

On "SQL Server 2019" on Windows 2019: I have opened Microsoft SQL Server Management Studio. I logged into database server. I clicked on "SQL Server Agent" and clicked on "...
folow's user avatar
  • 347
0 votes
0 answers
173 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 ...
Ela's user avatar
  • 500
0 votes
1 answer
225 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?
Mehdi Charife's user avatar
0 votes
2 answers
711 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 ...
Mehdi Charife's user avatar
4 votes
1 answer
3k 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 ...
myxal's user avatar
  • 43
0 votes
1 answer
231 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 ...
Faisal Mushayt's user avatar
3 votes
1 answer
367 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 ...
chrestomanci's user avatar
3 votes
1 answer
882 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 (...
Lucas Miranda's user avatar
0 votes
1 answer
355 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. ...
Olga Pshenichnikova's user avatar
1 vote
0 answers
92 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 ...
Doug's user avatar
  • 11
0 votes
1 answer
235 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 ...
Kamil Sz's user avatar
0 votes
1 answer
300 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 ...
jimmiing's user avatar
0 votes
0 answers
148 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-...
Shlomi Hassid's user avatar
0 votes
0 answers
250 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 ...
Glen G's user avatar
  • 3
0 votes
0 answers
68 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=...
ChrisJ's user avatar
  • 601
0 votes
1 answer
483 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 ...
eek's user avatar
  • 123
0 votes
1 answer
253 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 ...
mva's user avatar
  • 101
0 votes
1 answer
183 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/...
Nirav Bhatt's user avatar
1 vote
1 answer
635 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:...
Akash M's user avatar
  • 113
1 vote
1 answer
922 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 ...
Dip's user avatar
  • 113
0 votes
1 answer
547 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 ...
Litehouse's user avatar
  • 101
1 vote
0 answers
211 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=...
robertpostill's user avatar
0 votes
2 answers
1k 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 ...
SHR's user avatar
  • 874
1 vote
1 answer
341 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....
User1974's user avatar
  • 1,477
0 votes
0 answers
186 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, ...
Gabriele D'Onufrio's user avatar
0 votes
1 answer
147 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. ...
user3156442's user avatar
0 votes
1 answer
37 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 ...
MadOp's user avatar
  • 15
1 vote
2 answers
376 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 ...
Mike Blyth's user avatar
1 vote
1 answer
241 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 ...
Fandango68's user avatar
0 votes
1 answer
2k 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.....
Jivan's user avatar
  • 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 ...
Alex Netkachov's user avatar
5 votes
2 answers
25k 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 ...
Marcello Miorelli's user avatar
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 ...
Emanuel's user avatar
0 votes
1 answer
514 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' ...
Mikhail Aksenov's user avatar
5 votes
1 answer
10k 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 ...
bharat's user avatar
  • 53
1 vote
0 answers
457 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 ...
Rauf Asadov's user avatar
  • 1,273
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 ...
BostonMacOSX's user avatar
0 votes
2 answers
262 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, ...
dwenzel's user avatar
  • 63
1 vote
1 answer
81 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 ...
mekkanizer's user avatar
1 vote
2 answers
1k 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 ...
Marcello Miorelli's user avatar
-2 votes
1 answer
267 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 ...
ModernDBAwithModernTasks's user avatar
0 votes
0 answers
652 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 ...
Xenos's user avatar
  • 195
3 votes
0 answers
236 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 ...
Jan Thomä's user avatar
1 vote
2 answers
87 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, ...
Jane1386's user avatar
0 votes
0 answers
23 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 ...
Thilakar Raj's user avatar
1 vote
0 answers
317 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 ...
Jeff Bauersfeld's user avatar
2 votes
2 answers
304 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 ...
Marcello Miorelli's user avatar
1 vote
3 answers
9k 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 ? ...
ML61's user avatar
  • 103
5 votes
2 answers
827 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 ...
J.D.'s user avatar
  • 38.3k

1
2 3 4 5 6