A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.
Questions tagged [logging]
102 questions
8
votes
1 answer
Disable full-text logging (SQL Server)
Any way to disable FT logs completely? I spent hours googling - no luck.
I get tons of "informational" messages literally every second.
2020-01-01 10:43:16.48 spid33s Informational: Full-text Auto population initialized for table or indexed view…
jitbit
- 765
- 1
- 8
- 15
7
votes
1 answer
How to disable the logging of parameter values in PostgreSQL
Is there a way to disable the logging of the parameter values used in a query, while still logging the actual query itself?
I'd like to set log_min_duration_statement = 0 to use with pgBadger. I'm getting two lines per query like:
LOG: Select *…
Dave Stibrany
- 279
- 2
- 9
6
votes
1 answer
What does SQL Server's Error Log actually log?
If you have ever played around with the error_reported Extended Event, then it becomes very obvious that the SQL Server Error Log only logs a tiny fraction of the errors that are thrown by code running on your server. Indeed, many things that it…
J. Mini
- 1,161
- 8
- 32
6
votes
3 answers
SQL Server - Sudden log autogrowth after database backup
I have to manage a SQL Server 2008 Database, using SQL Server Management Studio 2012. The database file is about 290Gb. The problem we have is that the log file used to grow a lot.
Doing some internet research (I'm totally new to DB management), I…
Luis García
- 63
- 5
6
votes
1 answer
Logging Stored Procedure Parameter Values
I've worked in an SQL Server environment before where logging was made part of our stored procedures to capture execution start/end, parameter values and error messages which I found very useful and is something I'm looking to introduce in a new…
mhep
- 750
- 7
- 22
5
votes
1 answer
Stored Procedure Processing and Error Log
I used to work for a company where they had this 3rd party Data warehouse Solution. Obviously all the objects and tables were hidden in the Supporting database so I don't have clear idea on what exactly happened inside some of the stored procedure.…
mouliin
- 530
- 1
- 4
- 15
4
votes
1 answer
'not exists' seems to be slowing insert
I am trying to run a script that will batch insert over 20 million records into a table 10,000 at a time. At the start of the run it seems to be working fine. Although once a number of records had already been inserted (270,000) the script began to…
mepope
- 43
- 6
4
votes
1 answer
Suppress specific SQL Server log warnings and messages
I want to minimize the output of certain warnings and messages in the SQL Server 2012 logs, such as when an spid is killed. I am unable to find information on suppressing/expanding which messages are actually sent to the error logs. Is this done…
PicoDeGallo
- 1,554
- 1
- 20
- 30
4
votes
1 answer
Change logging level MongoDB
We are experiencing huge logs creation in our MongoDB shard setup. Log settings used are default values -
firstset:PRIMARY> db.getLogComponents()
{
"verbosity" : 0,
"accessControl" : {
"verbosity" : -1
},
"command" : {
…
Vibhav Singh Rohilla
- 199
- 2
- 7
3
votes
1 answer
What is the performance cost of enabling "log_lock_waits" on Postgres?
I am trying to understand what is the performance cost of enabling log_lock_waits on Postgres.
As per this documentation, while log_lock_waits = on:
Controls whether a log message is produced when a session waits longer than deadlock_timeout to…
Sam.E
- 85
- 2
- 7
3
votes
1 answer
Can't create/write to file '/var/log/mariadb/mariadb.log'
I'm troubleshooting a MySQL no-start on CentOS 7 VM. It is a bit unusual to see this since we have not made any configuration changes. The manual start command was taken from systemd logging. The error is the age old:
# /usr/bin/mysqld_safe…
user141074
3
votes
1 answer
PostgreSQL: Log statements which do sequential scans
I use this snippet to detect missing indexes:
https://stackoverflow.com/a/12818168/633961
Example:
SELECT
relname AS TableName,
to_char(seq_scan, '999,999,999,999') AS…
guettli
- 1,591
- 5
- 25
- 51
3
votes
1 answer
See X-Request-ID in error messages of PostgreSQL
In my environment most PostgreSQL queries are generated from http requests.
In my case every http request has a unique header: X-Request-ID
If there is a error or warning in the PostgreSQL logs, I would like to see the related X-Request-ID to see…
guettli
- 1,591
- 5
- 25
- 51
3
votes
3 answers
MySQL general_log only shows a hex number instead of SQL?
When I enable sql logging to table like this:
set global log_output = 'table'
set global general_log = 'on'
Do some queries then look at the log table like this:
select * from mysql.general_log
order by event_time desc
I don't see my sql. I see…
John Little
- 223
- 1
- 3
- 11
3
votes
2 answers
How do I get postgres to log the stored procedures it is running?
I'm not asking how to log what the stored procedure does, I simply want a list of all the stored procedures that are being triggered and run dumped into the statement log.
I've got it logging all the statements with:
log_statement=all
but all that…
boatcoder
- 355
- 4
- 12