Questions tagged [logging]
A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.
58
questions
0
votes
1answer
21 views
Cannot get rid of creation of mysql.log
I have these settings in my.cnf:
[mysqld]
...
disable_log_bin
general-log = false
general_log_file = /var/log/mysql/mysqld.general.log
long_query_time = 1
slow_query_log = false
...
0
votes
0answers
13 views
Could not find a login matching the name provided
SQL Server 2016
We had a user on several servers that had sys admin. As a new DBA, I was told by my director to remove the user and create a new one to run jobs and do server linking. I removed the ...
1
vote
0answers
27 views
Best practices for users credentials [closed]
I am designing a C# client to connect to a MySQL DB and am having second thoughts on my design.
The users have credentials in order login in the C# client, so now it is designed like this:
1 - the C# ...
0
votes
0answers
12 views
SSIS Logging vs. SSISDB Catalog Reports
What is the useful functional difference between the SSIS package logging, and the SSISDB Catalog reporting (All Executions/Validations). I appears to be one is canned, the other allows customization? ...
1
vote
0answers
42 views
SQL Server 2017, XEvent: sql_text IS NOT NULL
I'm attempting to use XEvents to find out which queries are causing my templog.ldf file to grow in size. I'm getting events, but I see the sizes of the files haven't changed, and that the sql_text ...
0
votes
1answer
28 views
Massive Transaction Logs - what are my options?
I have a fairly crazy scenario where I am processing ~250 million inserts and 250 million deletes for a table that contains data that is only relevant for the moments that it is in the database. Once ...
0
votes
0answers
135 views
SQL Server database in Recovery mode, how to troubleshoot?
I have a SAP instance running with a 'SQL Server' database that just recently got into recovery mode without a clear reason (no backup or restore was executed).
We noticed that the storage for logs (...
-1
votes
1answer
48 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
20 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
289 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
26 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
48 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
141 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
24 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 ...
1
vote
1answer
106 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
25 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
46 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 ...
1
vote
1answer
2k 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
1k 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
1k 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
125 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
154 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
2k 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
77 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
84 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
49 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
173 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
705 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
1k views
Why is PostgreSQL's auto-explain not working in AWS RDS?
These are my settings:
According to the documentation, as far as I can tell, this combination of settings along with a statement_timeout value of 3600000 should mean that hour-long queries time out, ...
2
votes
1answer
160 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
60 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
34 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
382 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
5k 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
629 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
53 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
2k 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
202 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
1k 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
800 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
737 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
117 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
467 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
7k 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
168 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
132 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
3k 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 ...
