Questions tagged [logging]

A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.

Filter by
Sorted by
Tagged with
-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 ...