Questions tagged [logging]
A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.
52
questions
-1
votes
1answer
45 views
Login failed for user 'sa' State: 8, in short time
I have setup SQL Server on server Customer.
Recently, log files in SQL Server increase continuously. I checked the content of those logs - see here:
In my application I use an account for connecting ...
0
votes
2answers
17 views
Logging user's id with the query he executed
So, I am trying to log not just the postgres user but his ID from my table (for example) Person (person_id) when he calls functions.
So far, from what I can tell I can get almost every information I ...
1
vote
1answer
104 views
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 ...
0
votes
0answers
15 views
Pentaho PDI (Kettle) slowing down as logging tables fill
We are currently running Kettle in AWS with Postgres as a logging database. ETLS were quick initially, but slowed over time. After noticing that the processing of the actual ETLs was fast, but that ...
1
vote
0answers
34 views
How to switch off statement logging from a trigger in PostgreSQL
I just spent ages working out how to record messages from triggers into a log file. And then nearly as long working out where the logs files were being created.
Anyway, I added this line to my ...
0
votes
1answer
80 views
Disable log ERROR: duplicate key value violates unique constraint
Running Postgresql in a better ask for forgiveness than permission mode during the inserts.
Works great, only problem: The logs are flooded with the following message
duplicate key value violates ...
0
votes
0answers
23 views
How to Track Table Usage
I need to track usage for 1 table, and log how this table is accessed (select, insert, etc.) and by which logins
What is the proper way to do it using SQL Server Audit and Extended Events ?
If there ...
0
votes
1answer
20 views
how can I divide log files for specific DB queries?
Currently my db has a couple of triggers for some (not all) tables that get executed when a specific number of columns has been updated. I keep track if the triggers for those rows on a boolean column ...
0
votes
0answers
16 views
aurora postgresql logs
We are in the process of sending logs of Aurora PostgreSQL to a SIEM log management solution.
However, there doesn't seem to be a option to publish Aurora PostgreSQL to Cloudwatch log group. Is there ...
1
vote
1answer
76 views
Writing MongoDB logs to a remote logging server
I am trying to forward MongoDB logs from several remote servers to a central logging server. To do this, I changed my mongod.conf files to use syslog like so:
systemLog:
destination: syslog
...
1
vote
0answers
23 views
How to measure durations (import, update) in Postgres DB?
we have a Postgres database which receives data by an extern web client. We would like to measure the duration of the UPDATE, INSERT and DELETE processes on our tables.
Until now, we used the ...
0
votes
2answers
42 views
PostgreSQL failsafe start after disk crash
We use PostgreSQL to store logs.
A disk crashed and some files in the file system were corrupt.
I read this: https://wiki.postgresql.org/wiki/Corruption
But this page does not solve my needs.
I ...
0
votes
1answer
984 views
Does SQL server log when and who enabled / disabled jobs by default?
Is there any default logging or history of when a SQL job was enabled or disabled?
1
vote
1answer
657 views
Why mongodb logs commands in the log file and how to avoid that?
OS: Windows 10/ Server 2012
Mongodb verison : 3.4.9
I have set the mongod --logPath and --quiet command line parameter
The logs are just growing beyond 100mb and not rotating. Seeing the logs I see ...
1
vote
1answer
813 views
Find SSIS package which calls stored procedure
We are trying to catch errors into an Error Log Table, similar to below.
We have many Master SSIS packages, calling many stored procedures.
Following code will log into the Error Log Table. Is there ...
0
votes
1answer
101 views
Is it possible to audit query results in SQL Server?
I want to find out if it is possible to audit the results of any query that gets executed on an instance of SQL Server. We currently have C2 auditing enabled, but this only showed what query was ...
-2
votes
1answer
142 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 ...
1
vote
1answer
1k views
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 ...
1
vote
3answers
76 views
Want to get executed query users log in SQL-server
Yesterday one of my team members has truncated a few tables, but who have truncated those tables is still a mystery.
Can I have user based query log with the timing of execution? Or something where I ...
1
vote
1answer
65 views
MongoDB as a log storage. Choosing shard key
I'm designing a log storage system based on MongoDB.
I want to shard a log collection to increase ingestion and capacity (distribute writes to several machines) while allow fast search.
I should be ...
0
votes
1answer
19 views
VoltDB Logging Level
How much (estimated percentage) is going to worsen the response-time of the database if the logging level is lowered to "DEBUG". ?
2
votes
1answer
47 views
Replication with encrypted columns, does the 2nd server have to have the same master key and symmetric key or is it done automatically?
I have two questions actually:
If you set up a table with encrypted columns and replicate it to another server does the other server have to have the same master key and symmetric key or is it ...
2
votes
1answer
141 views
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, ...
0
votes
1answer
613 views
MariaDB Fails to log in error log
I am using MariaDB Version 5.5.56
The database was restarted 2 days ago but I am not seeing any log entries in the error log except an error importing from a dmp file. The data seems complete and all ...
0
votes
1answer
893 views
Why is PostgreSQL's auto-explain not working in AWS RDS?
These are my settings: https://collabshot.com/show/6b9f6c
According to the documentation, as far as I can tell, this combination of settings along with a statement_timeout value of 3600000 should ...
1
vote
1answer
135 views
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 ...
1
vote
2answers
56 views
Can I log psql time and statements to a text file (without the data)?
I am currently comparing performance of PostgreSQL with several other SQL systems. I am aware of the \timing option to turn on timing queries. However, I would very much like to automate the process ...
0
votes
2answers
31 views
What option we can disable temporary in PostgreSQL make database update faster
I want to update 3 million records within some seconds. i have tried doing below things
ALTER TABLE imagingresourceplanning.opnav_fact_revenue_costs SET UNLOGGED ;
ALTER TABLE ...
4
votes
1answer
339 views
'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 ...
1
vote
1answer
4k views
How to disable MySQL error logging?
My error file(/var/log/mysql/error.log) is increased rapidly（10% of disk usage per hour） with only this entry:
[ERROR] Error in accept: Bad file descriptor
and we can only shutdown the server down ...
1
vote
1answer
491 views
How to resolve Error 600122, severity 11, state 1 was raised
My SQL Server 2008 R2 keeps recording these error in the SQL Server log:
Error 600122, severity 11, state 1 was raised, but no message with that error number was found in sys.messages. If error is ...
2
votes
0answers
50 views
Logging multiple error message in the TRY…CATCH when doing BACKUP DATABASE [duplicate]
When I try below:
backup database not_existing_db to disk = 'E:\Backup\not_existing_db.bak'
SSMS shows two error messages:
Msg 911, Level 16, State 11, Line 22
Database 'not_existing_db' does not ...
5
votes
3answers
1k views
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 ...
1
vote
2answers
1k views
Postgres log query and command tag to CSV
I am trying to log executed queries into a csv file.
My main objective is to log the command tag and query. For that I enabled logging in the postgresql.conf, my configs are the following:
#---------...
1
vote
1answer
193 views
troubleshooting login failure when AD group seems to be fine
I am using the procedure xp_logininfo to find out what groups a user belongs to.
I have created an AD group called SQLDBA, and added myself to it,
then created a login and granted sysadmin to the ...
0
votes
1answer
836 views
Having issues with postgresql, what should I log?
Here's the error message I am receiving.
could not translate host name "localhost" to address: hostname nor servname provided, or not known
From my searching, it seems like postgresql has crashed ...
1
vote
2answers
736 views
Adding logging statements at start and end of all stored procedures
I would like to capture stored procedure execution details which would require altering existing procedures to perform an INSERT at the start and an UPDATE at the end.
I recall finding a blog article ...
4
votes
1answer
652 views
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 ...
1
vote
0answers
97 views
How is MySQL encoding the general.log
My MySQL 5.7 is running on UTF8
mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+--------------...
2
votes
0answers
423 views
Amount by which to increase checkpoint_segments (postgresql)
In my postgresql log, I see statements such as checkpoints are occurring too frequently (26 seconds apart). Currently in the conf, checkpoint_segments are 32, checkpoint_timeout is 15 mins and ...
5
votes
1answer
6k views
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 ...
0
votes
1answer
151 views
WAL log entry for CREATE TABLE statement
In postgresql, for queries like INSERT/UPDATE/DELETE, a WAL record with required information about the tuples is created in the WAL buffer, before doing the required changes in the data buffer. Is it ...
1
vote
1answer
119 views
avoid sys user, disable oracle log
Hi and thanks for reading,
I'm really new to oracle, I have an oracle database, and it needs to have a permanent log, not even the sys user should be able to modify it or disable it. I read all the ...
2
votes
2answers
2k views
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 ...
3
votes
1answer
4k views
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" :...
0
votes
1answer
1k views
Clean up log files
We had a disk alert pop up today on a SQL 2014 Enterprise Server telling us a drive was getting full on one of our servers. On investigation we found that the majority of the space was being used by ...
2
votes
2answers
1k views
MySQL doesn't log queries anymore
Some time ago I updated my MySQL server to the v5.6:
SELECT VERSION();
5.6.30-0ubuntu0.14.04.1
Now the query logging isn't working though the configs in the /etc/mysql/my.cnf seem to be correct:
[...
0
votes
1answer
65 views
Redo/Noredo in Oracle
I have an Oracle 11.2.0.3 about 700GB in size running in noarchivelog mode in a pretty slow storage setup. It barely gives IOPS and there is resource crunch in terms of hardware resources. The ...
1
vote
2answers
548 views
Database logging optimization and maintenance in SQL Server
One of the Web applications I am working on, uses NLog to log debug and error context information in the database. Basically, it performs a moderate number of inserts (I appreciate some tens of ...
3
votes
1answer
3k views
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 ...
