Questions tagged [logs]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
14 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' ...
0
votes
1answer
7 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 ...
0
votes
0answers
27 views

mongod log ms meaning

I cannot understand from reading the documentation what is the meaning of the ms in the mongod.log at the end of the following line: 2019-10-30T21:09:41.647Z I COMMAND [co48] command Db.noa ...
1
vote
0answers
51 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 ...
0
votes
0answers
7 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 ...
0
votes
2answers
37 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, ...
1
vote
1answer
33 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 ...
1
vote
2answers
86 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 ...
-2
votes
1answer
51 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
0answers
21 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 ...
2
votes
0answers
20 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 ...
1
vote
2answers
44 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, ...
0
votes
0answers
20 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
0answers
54 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 ...
1
vote
2answers
80 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 ...
0
votes
2answers
233 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 ? ...
5
votes
2answers
515 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 ...
-2
votes
1answer
136 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 ...
0
votes
0answers
22 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
vote
1answer
2k 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 ...
3
votes
1answer
429 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 ...
3
votes
1answer
305 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 ...
1
vote
1answer
74 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 = '...
2
votes
1answer
249 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 ...
1
vote
2answers
143 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 ...
0
votes
3answers
86 views

Restore deleted data from a Table which occurred daily

I am not sure whether this is restore data scenario is possible. Scenario: I have a table with few 100 data inserts every day.I didn't realize that because of some reason(identified later as a bug in ...
0
votes
0answers
53 views

Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]

please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally ...
1
vote
1answer
336 views

How do I determine the time period to which the SQL Server i/o warning is referring?

SQL Server log shows batches of warnings, of the type: SQL Server has encountered 18757 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\.. SQL Server has ...
0
votes
2answers
4k views

Starting mongod daemon with a config file for a shard

In a Linux machine, I changed the mongod.service file to run a config file I created. ExecStart=/usr/bin/mongod --config /etc/some_name.conf When I start mongod with this config file manually, it ...
1
vote
0answers
477 views

SQL Server Login auditing capturing Logon events when set to Failed logins only

I have an issue where within my SQL Server 2016 Standard instance, Login auditing is set to Failed logins only but within the ERRORLOG file, it is capturing Both failed and succesful logins. Once I ...
3
votes
1answer
45 views

Auditing Failed Logins in SQL Server

Are there ways to understand which password entered when connecting to my server ?
1
vote
1answer
33 views

Log table that grows like flash [closed]

I have my own app that get low traffic (like 100 ppl per day). As part of my research I am 'logging' all the queries done to by the server in a table in the database. An example, if user enters home ...
1
vote
1answer
119 views

Exclude application from postgres logs

Currently on one of our dev servers we log everything what happend in database, but lots of traffic in is generated by patroni cluster and is not needed in further investigation. Is possibile to ...
1
vote
2answers
158 views

Is there a way to limit log file usage for a transaction in SQL Server?

This question is a follow up on these two: Auto rollback Explicit transactions after X amount of time Database file …_log has a max file size set to x MB. If it runs out of space, the database will ...
1
vote
1answer
439 views

Change logging level programmatically for multiple jobs

I have multiple Sql Agent jobs, with multiple steps each. For a large subset of these jobs, I want to set the logging levels to PERFORMANCE instead of BASIC - the logs are taking a lot of log space, ...
0
votes
1answer
193 views

ODBC SQL tracer file question marks

I have an MS Access query that connects to an Oracle Express database via an ODBC connection. I've figured out a way to trace the SQL that is sent from MS Access to the ODBC connection. This is what ...
1
vote
1answer
55 views

Will logRotate cause any unavailability in MongoDB service?

In another question, I've mentioned that how would I rotate logs in MongoDB Replica Set installed in Windows Server. However, it seems there's no built-in way to get it automatically on Windows - only ...
0
votes
1answer
598 views

Get postgresql exact log file name with sql

I get current log file by using SQL without getting in server via ssh. So I use a query like the one below; SELECT pg_read_binary_file( concat_ws('/', current_setting('log_directory'), '...
0
votes
1answer
164 views

How to properly debug and inspect SQL Queries in PHP File?

My website AdminPanel has a PHP file which takes almost 30-40 seconds in loading. I doubt the queries which are making the mess, but may be it is the code but the code structure seems perfect. I want ...
1
vote
1answer
354 views

Another “log_min_duration_statement is ignored” question

Following the recommendations in log_min_duration_statement setting is ignored I set these two values and then reloaded. log_min_duration_statement = 2000 log_statement = 'none' However, I'm still ...
1
vote
2answers
720 views

MySQL Still purging binary logs and ignoring expire_logs_days

We are running mysql v5.6.17 and I cannot find if there is something else that is causing the binary logs to be purged other than the following: Adding expire_logs_days to the my.ini (and ...
3
votes
1answer
3k views

MySQL audit and general log

May ask for the difference of MySQL Audit log plugin and general log? I looking for any activities done in a MySQL server.
2
votes
1answer
1k views

Log (ldf) file grows continuously

We have a problem with just one of the databases on our SQL2008 Server. For some reason recently the log file is just growing and growing. The server runs the following backups Weekly - Full Daily - ...
2
votes
1answer
244 views

What are the three parts of a LSN?

I am curious about what the 3 parts of a Log Sequence Number (LSN) are and how they are generated. A log sequence number is an ever-increasing, three-part number that uniquely defines the position ...
4
votes
1answer
2k views

Why do I have to backup a transaction log twice for it to shrink?

This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file - that is not the question. If you feel like answering that one should not do ...
3
votes
2answers
4k views

SQL Server : log folder too large

Please note that I'm not talking about transaction logs. I'm referring to a folder within SQL Server called 'Log' where ErrorLog and SQLDrmp files exists. Well, the fact is that this folder is ...
1
vote
1answer
208 views

How to shrink over sized logs in Database Mirroring? [duplicate]

I've searched the forums here at dba.se and other places on the Net and haven't found a specific answer. I know this question looks similar to many, but the ones that I've found only address how to ...
0
votes
1answer
186 views

Huge ASPState database log

We're using SqlServer to store users session state of our webapps. We've recently noticed the ASPState.log_ldf file has reached 50GB. Is it safe to put the web apps down and then drop and recreate ...
5
votes
2answers
6k views

Transaction Log Files Larger Than Data Files [duplicate]

I'm an accidental DBA and need help determining a course of action regarding transaction log files on several databases. I ran Brent Ozar's sp_blitz to see what areas of concern there might be on an ...
1
vote
1answer
77 views

Which database type for log analysis?

I am running a database for log analysis. At the moment I use a MySQL database and the table for my analysis looks like this: UUID REQUEST_ID REQUEST_TIMESTAMP RESPONSE_TIMESTAMP RUNTIME SERVER_NAME ...