Questions tagged [logging]
A time-ordered, human-readable archive of activity. For questions about the database transaction log, use the transaction-log tag instead.
68
questions
0
votes
0answers
21 views
Logging changes of read only table
I have table (plots) with data witch read only access.
In QGIS there is tool which transforms "normal" table into one which logs changes.
Tool generates SQL like this:
ALTER TABLE public....
-1
votes
0answers
18 views
Why does setting “log_error_verbosity” to “verbose” cause *nothing* to be logged?
For a long time now, I've been fighting with my PostgreSQL (12.4) to get it to log the fields "detail", "hint", "internal_query" and "context". They are always ...
-2
votes
0answers
11 views
In the CSVlog mode, is there some way to make PostgreSQL log a custom string bases on some kind of SQL session variable or similar? [duplicate]
I have instructed PostgreSQL to csvlog its errors/notices. Then my script reads these files and put them back into a database table, then deletes the log file. This part is all working and stable.
My ...
-2
votes
2answers
35 views
How to find out WHERE a PG error/warning/log happened?
I have PostgreSQL CSV-log its "errors" according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
It doesn't include the file ...
0
votes
1answer
18 views
Configuring 2017 SQL Server SSISDB Server-wide Default Logging Level does not seem to work
Using SSMS, I have changed the SSIS Catalog Logging Level from Basic to Performance to a Custom Logging Level in a 2017 SQL Server Instance and then I run the report: "All Executions". It ...
-1
votes
1answer
31 views
How do I log the actual script's name in csvlog? [duplicate]
I have PostgreSQL CSV-log its errors according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
Sadly, from what I can tell, it neither ...
-2
votes
1answer
40 views
What should I do about PostgreSQL logging so much “weird noise” in its own log?
PostgreSQL 12.4 on Windows 10 Pro 2004.
With the default configuration file, I start PostgreSQL with pg_ctl and the "-l PostgreSQL.txt" option.
It logs to that file. Looking in it, I'm ...
0
votes
2answers
29 views
How do I get access logs from SQL Server database
I am in the process of carrying out system reviews for some systems powered by SQL Server. IS there a way of getting the access logs to these systems databases spanning a period of 6 months starting ...
0
votes
2answers
51 views
How can I force the MySQL client to output to stdout or a log file when importing a SQL file?
Let's say I am importing a small SQL file using the MySQL client like so:
mysql < 10k-file.sql
The mysql client does not output anything. How can I force it to show how many rows are affected for ...
0
votes
0answers
5 views
logging message offset in librdkafka
"node-rdkafka": "^2.7.4"
My producer end is publishing messages to a kafka broker using a HighlevelProducer . The callback function in the producer.Produce() contains error and ...
1
vote
2answers
35 views
Non-deterministic functions and row-based binary logging (MySQL)
Newbie questions. I'm working on a MySQL project that will use only row-level binary logging. There will be no replication. Since logging is row-level, does it even matter if a function is ...
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
182 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
31 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
14 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
59 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
29 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
225 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
22 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
627 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 ...
1
vote
0answers
67 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 ...
1
vote
1answer
212 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
26 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
120 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
28 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
58 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
3k 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 ...
1
vote
1answer
149 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
163 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
3k 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
104 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
20 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
58 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
254 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
782 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 ...
1
vote
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
181 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
66 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
40 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
427 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 ...
2
votes
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
782 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
54 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:
#---------...
