2022 Developer Survey is open! Take survey.

Questions tagged [logs]

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

Filter by
Sorted by
Tagged with
1 vote
0 answers
18 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 ...
user avatar
  • 11
0 votes
1 answer
36 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 ...
user avatar
0 votes
0 answers
50 views

Oracle RDS Logminer ORA-01291 Missing Log File?

I have an Oracle RDS database I manage, and I need to be able to pull changes from the database for replication to another system. Once connect to the database, below is the commands I run. EXEC ...
user avatar
  • 101
0 votes
1 answer
84 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 ...
user avatar
0 votes
0 answers
29 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-...
user avatar
0 votes
0 answers
33 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 ...
user avatar
  • 3
0 votes
0 answers
13 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=...
user avatar
  • 459
0 votes
1 answer
90 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 ...
user avatar
  • 123
0 votes
1 answer
52 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 ...
user avatar
  • 101
0 votes
1 answer
26 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/...
user avatar
1 vote
1 answer
59 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:...
user avatar
  • 113
1 vote
1 answer
129 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 ...
user avatar
  • 113
0 votes
1 answer
145 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 ...
user avatar
  • 101
1 vote
0 answers
76 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=...
user avatar
0 votes
2 answers
301 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 ...
user avatar
  • 794
1 vote
1 answer
104 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....
user avatar
  • 1,377
0 votes
0 answers
57 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, ...
user avatar
0 votes
1 answer
38 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. ...
user avatar
0 votes
1 answer
32 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 ...
user avatar
  • 15
0 votes
0 answers
114 views

PITR Restore on Postgresql Windows

I have Postgresql 11 running on Windows server and master/slave replication working perfectly. I have enable the wal_archiving and also i have enabled automatic backups using pg_dump I need to ask if ...
user avatar
1 vote
2 answers
173 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 ...
user avatar
1 vote
1 answer
58 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 ...
user avatar
0 votes
1 answer
546 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.....
user avatar
  • 111
0 votes
0 answers
21 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 ...
user avatar
4 votes
2 answers
12k 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 ...
user avatar
0 votes
1 answer
772 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 ...
user avatar
0 votes
1 answer
181 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' ...
user avatar
4 votes
1 answer
3k 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 ...
user avatar
  • 43
1 vote
0 answers
159 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 ...
user avatar
  • 1,163
0 votes
0 answers
12 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 ...
user avatar
0 votes
2 answers
137 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, ...
user avatar
  • 63
1 vote
1 answer
62 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 ...
user avatar
1 vote
2 answers
565 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 ...
user avatar
-2 votes
1 answer
149 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 ...
user avatar
0 votes
0 answers
209 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 ...
user avatar
  • 175
2 votes
0 answers
45 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 ...
user avatar
1 vote
2 answers
53 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, ...
user avatar
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 ...
user avatar
1 vote
0 answers
158 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 ...
user avatar
1 vote
2 answers
218 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 ...
user avatar
1 vote
2 answers
4k 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 ? ...
user avatar
  • 43
5 votes
2 answers
539 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 ...
user avatar
  • 24.3k
-2 votes
1 answer
223 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 ...
user avatar
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 ...
user avatar
  • 1,007
1 vote
1 answer
9k views

How to log ALL queries made by users in SQL Server 2017 Standard? [duplicate]

Is there a possibility to do this? All queries and actions performed in any database need to be logged, because of in house compliance. I need information (and/or source) if we need MS SQL 2017 ...
user avatar
  • 143
6 votes
3 answers
2k views

Replay (re-execute) MySQL SELECT queries from a log file

MySQL Benchmarking I would like to evaluate the performance of a different MySQL instance by re-executing real queries from log files. I am aware of tools like mysqlslap, that produces random and ...
user avatar
  • 211
5 votes
1 answer
1k views

SQL Server logs "blob data", viewable with journalctl

What does it mean when I run journalctl -u mssql-server.service and it says B blob data, Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine... Sep 06 17:34:44 x230 ...
user avatar
  • 55.7k
1 vote
1 answer
113 views

Postgres logging_collector probably blocks auto_explain output

Postgres 10.4 Postgres 9.6 Problem on both versions I want to collect postgresql slow queries plan, so I added to my postgresql.conf setting from documentation session_preload_libraries = '...
user avatar
2 votes
1 answer
408 views

How to read mysqld.log files? [closed]

can someone tell me how to read the mysqld.log? I'm curious about the third column. Because every time i start/stop the mysql it give different output. I hope someone can explain to me :). Below is ...
user avatar
1 vote
2 answers
419 views

Why do uncommitted transactions rollback instead of redo after a crash in ARIES?

Since all actions within a transaction are idempotent in crash recovery algorithms like ARIES that use write-ahead logging why do we rollback after a crash during an uncommitted transaction to get ...
user avatar

1
2 3 4 5