Questions tagged [logging]
A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.
1
vote
1answer
34 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
19 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
32 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
85 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
49 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
150 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
0answers
62 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
74 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
398 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 ...
0
votes
0answers
9 views
Is it possible to log resultsets on the server side?
I've enabled log_statement = 'all' in postgresql.conf but it only logs SQL queries, not their responses. Is there a way to log the returned resultset as well?
1
vote
3answers
73 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
40 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
0answers
181 views
Why mysql logging COMMIT /* implicit, from Xid_log_event */ in General query log file
I have two MySQL servers replicated in Master-Master mode. I have enabled MySQL general query log for future database recovery purpose if any problem occurs in replication. Now when I checked my ...
0
votes
1answer
16 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
44 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
92 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
436 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
581 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
89 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
50 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
29 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
247 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
3k 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
299 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
43 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 ...
4
votes
3answers
696 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
955 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:
#---------...
2
votes
1answer
137 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
353 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
474 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
516 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
78 views
How is MySQL encoding the general.log
My MySQL 5.7 is running on UTF8
mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+--------------...
3
votes
0answers
336 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 ...
3
votes
1answer
4k 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
113 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
100 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 ...
3
votes
2answers
1k 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
951 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
54 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
432 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
2k 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 ...
4
votes
1answer
2k views
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 ...
3
votes
1answer
129 views
mysql custom query logging for inter-software data exchange
Some 2-3 years I had written some triggers (one per table) in SQL server allowing me to log queries in our main software.
ALTER TRIGGER [dbo].[SUIVI_REQUETE_CAT_CATBRUT] ON [dbo].[CAT_CATBRUT] AFTER ...
