Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
249
questions
2
votes
1
answer
16k
views
How to log ALL queries made by users in SQL Server 2017 Standard? [duplicate]
Is there a possibility to do this? All queries and actions performed in any database need to be logged, because of in house compliance.
I need information (and/or source) if we need MS SQL 2017 ...
- 153
7
votes
3
answers
2k
views
Replay (re-execute) MySQL SELECT queries from a log file
MySQL Benchmarking
I would like to evaluate the performance of a different MySQL instance by re-executing real queries from log files. I am aware of tools like mysqlslap, that produces random and ...
- 221
7
votes
1
answer
2k
views
SQL Server logs "blob data", viewable with journalctl
What does it mean when I run journalctl -u mssql-server.service and it says B blob data,
Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine...
Sep 06 17:34:44 x230 ...
- 62.2k
1
vote
1
answer
131
views
Postgres logging_collector probably blocks auto_explain output
Postgres 10.4
Postgres 9.6
Problem on both versions
I want to collect postgresql slow queries plan, so I added to my postgresql.conf setting from documentation
session_preload_libraries = '...
- 123
2
votes
1
answer
439
views
How to read mysqld.log files? [closed]
can someone tell me how to read the mysqld.log?
I'm curious about the third column.
Because every time i start/stop the mysql it give different output. I hope someone can explain to me :).
Below is ...
- 48
1
vote
2
answers
642
views
Why do uncommitted transactions rollback instead of redo after a crash in ARIES?
Since all actions within a transaction are idempotent in crash recovery algorithms like ARIES that use write-ahead logging why do we rollback after a crash during an uncommitted transaction to get ...
- 449
0
votes
3
answers
164
views
Restore deleted data from a Table which occurred daily
I am not sure whether this is restore data scenario is possible.
Scenario:
I have a table with few 100 data inserts every day.I didn't realize that because of some reason(identified later as a bug in ...
- 1,305
0
votes
0
answers
55
views
Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]
please can anyone help?
I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile.
I want to change this setup as per best practices by adding 3 additional euqally ...
- 39
1
vote
1
answer
786
views
How do I determine the time period to which the SQL Server i/o warning is referring?
SQL Server log shows batches of warnings, of the type:
SQL Server has encountered 18757 occurrence(s) of I/O requests taking
longer than 15 seconds to complete on file [T:\..
SQL Server has ...
- 305
0
votes
2
answers
5k
views
Starting mongod daemon with a config file for a shard
In a Linux machine, I changed the mongod.service file to run a config file I created.
ExecStart=/usr/bin/mongod --config /etc/some_name.conf
When I start mongod with this config file manually, it ...
- 131
1
vote
0
answers
704
views
SQL Server Login auditing capturing Logon events when set to Failed logins only
I have an issue where within my SQL Server 2016 Standard instance, Login auditing is set to Failed logins only but within the ERRORLOG file, it is capturing Both failed and succesful logins. Once I ...
- 1,564
3
votes
1
answer
60
views
Auditing Failed Logins in SQL Server
Are there ways to understand which password entered when connecting to my server ?
- 33
1
vote
1
answer
53
views
Log table that grows like flash [closed]
I have my own app that get low traffic (like 100 ppl per day).
As part of my research I am 'logging' all the queries done to by the server in a table in the database. An example, if user enters home ...
1
vote
1
answer
445
views
Exclude application from postgres logs
Currently on one of our dev servers we log everything what happend in database, but lots of traffic in is generated by patroni cluster and is not needed in further investigation. Is possibile to ...
- 113
1
vote
2
answers
436
views
Is there a way to limit log file usage for a transaction in SQL Server?
This question is a follow up on these two:
Auto rollback Explicit transactions after X amount of time
Database file …_log has a max file size set to x MB. If it runs out of space, the database will ...
- 1,261
2
votes
3
answers
5k
views
MySQL general_log only shows a hex number instead of SQL?
When I enable sql logging to table like this:
set global log_output = 'table'
set global general_log = 'on'
Do some queries then look at the log table like this:
select * from mysql.general_log
...
- 187
1
vote
1
answer
741
views
Change logging level programmatically for multiple jobs
I have multiple Sql Agent jobs, with multiple steps each. For a large subset of these jobs, I want to set the logging levels to PERFORMANCE instead of BASIC -
the logs are taking a lot of log space, ...
- 325
0
votes
1
answer
322
views
ODBC SQL tracer file question marks
I have an MS Access query that connects to an Oracle Express database via an ODBC connection.
I've figured out a way to trace the SQL that is sent from MS Access to the ODBC connection. This is what ...
- 1,447
1
vote
1
answer
102
views
Will logRotate cause any unavailability in MongoDB service?
In another question, I've mentioned that how would I rotate logs in MongoDB Replica Set installed in Windows Server. However, it seems there's no built-in way to get it automatically on Windows - only ...
1
vote
1
answer
2k
views
Get postgresql exact log file name with sql
I get current log file by using SQL without getting in server via ssh. So I use a query like the one below;
SELECT pg_read_binary_file(
concat_ws('/',
current_setting('log_directory'),
'...
- 2,809
0
votes
1
answer
578
views
How to properly debug and inspect SQL Queries in PHP File?
My website AdminPanel has a PHP file which takes almost 30-40 seconds in loading. I doubt the queries which are making the mess, but may be it is the code but the code structure seems perfect. I want ...
- 135
1
vote
1
answer
959
views
Another "log_min_duration_statement is ignored" question
Following the recommendations in log_min_duration_statement setting is ignored I set these two values and then reloaded.
log_min_duration_statement = 2000
log_statement = 'none'
However, I'm still ...
- 606
1
vote
2
answers
2k
views
MySQL Still purging binary logs and ignoring expire_logs_days
We are running mysql v5.6.17 and I cannot find if there is something else that is causing the binary logs to be purged other than the following:
Adding expire_logs_days to the my.ini (and ...
- 13
6
votes
1
answer
7k
views
MySQL audit and general log
May ask for the difference of MySQL Audit log plugin and general log? I looking for any activities done in a MySQL server.
- 105
2
votes
1
answer
3k
views
Log (ldf) file grows continuously
We have a problem with just one of the databases on our SQL2008 Server. For some reason recently the log file is just growing and growing.
The server runs the following backups
Weekly - Full
Daily - ...
- 23
2
votes
1
answer
473
views
What are the three parts of a LSN?
I am curious about what the 3 parts of a Log Sequence Number (LSN) are and how they are generated.
A log sequence number is an ever-increasing, three-part number that uniquely defines the position of ...
- 6,178
4
votes
1
answer
3k
views
Why do I have to backup a transaction log twice for it to shrink?
This question was attempted twice on experts-exchange with no real answer.
I know that I should not shrink the log file - that is not the question.
If you feel like answering that one should not do ...
- 1,365
4
votes
2
answers
12k
views
SQL Server : log folder too large
Please note that I'm not talking about transaction logs. I'm referring to a folder within SQL Server called 'Log' where ErrorLog and SQLDrmp files exists.
Well, the fact is that this folder is ...
- 217
1
vote
1
answer
435
views
How to shrink over sized logs in Database Mirroring? [duplicate]
I've searched the forums here at dba.se and other places on the Net and haven't found a specific answer. I know this question looks similar to many, but the ones that I've found only address how to ...
- 1,365
0
votes
1
answer
376
views
Huge ASPState database log
We're using SqlServer to store users session state of our webapps. We've recently noticed the ASPState.log_ldf file has reached 50GB.
Is it safe to put the web apps down and then drop and recreate ...
- 101
7
votes
2
answers
9k
views
Transaction Log Files Larger Than Data Files [duplicate]
I'm an accidental DBA and need help determining a course of action regarding transaction log files on several databases. I ran Brent Ozar's sp_blitz to see what areas of concern there might be on an ...
- 71
1
vote
1
answer
151
views
Which database type for log analysis?
I am running a database for log analysis. At the moment I use a MySQL database and the table for my analysis looks like this:
UUID
REQUEST_ID
REQUEST_TIMESTAMP
RESPONSE_TIMESTAMP
RUNTIME
SERVER_NAME
...
- 149
0
votes
1
answer
2k
views
SQL Server Log Shipping Alert Job Issue
We have log shipping taking place between server A and server B.
The logs are backed up every 15 minutes on server A.
Over on server B, the logs are copied every 15 minutes successfully.
The logs are ...
- 63
0
votes
1
answer
1k
views
Sybase ASE server request logs
Is it possible to log each SQL query statement received from clients for a Sybase ASE server 15.7 , same as SET general_log = 1; command for mysql.
Thanks
- 121
1
vote
1
answer
214
views
Is it possible to replicate data changes of a database with triggers using binary logs?
I'm tasked to minimize the downtime of the database update. Unfortunately, I cannot use pt-online-schema-change toolkit because some tables in the current database has MySQL triggers that does further ...
- 229
0
votes
0
answers
289
views
What index type to use for a log
I have a table in which I will store messages (as in chat messages).
The table will be appended to a LOT, rows being inserted as messages fly by, much more often than entries will be updated.
Older ...
- 613
1
vote
1
answer
1k
views
SQl Server: Corrupt Logs Files: Why?
I have a SQL Server 2008r2 database server running on Windows Server 2008. On this server every week the log of at least one database throws this error:
Backup detected log corruption in database ...
2
votes
0
answers
751
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 ...
- 1,959
0
votes
1
answer
879
views
controlling postgresql log generation
My disk space fills up daily with postgresql logs. One optimzation solution I'm pursuing is that instead of turning off logs, I should overwrite the original log file (i.e. rotate?) once it hits a ...
- 1,959
1
vote
1
answer
388
views
Logging procedure, package errors to OS's Syslog
Good day,
Setup: Oracle 11G on Solaris 10 x86
We'd like to capture the errors/failures of our nightly scheduled procedures/ packages in the OS's syslog. That log will then be sent to a remote NMS ...
- 125
2
votes
1
answer
679
views
What do the values after `execute fetch from` mean in postgresql query logs?
We've turned on some slow query logging on a postgres 9.1 cluster and see
the following in the logs::
2016-08-08 13:05:51 AEST LOG: duration: 24126.105 ms execute fetch from S_26/C_775: SELECT ...(...
- 123
3
votes
2
answers
2k
views
Logging all changes made to MySQL database
I have a web application setup where there are separate Apache-Wordpress containers for development and production. Database is hosted externally on a virtual host.
When setting up development ...
-1
votes
1
answer
449
views
postgresql reindex frequency and monitoring
What's up guys. I have a couple of tables where i inserting much of data (and almost never deleting). Periodically i see that insert gains ExclusiveLock on index of table. So i guess that sometimes ...
- 49
1
vote
1
answer
2k
views
Postgresql log rotation
In postgresql, I'm using the following configuration to maintain my weekly logs:
log_truncate_on_rotation = on
log_rotation_age = 1d
log_filename = 'postgresql-%a.log'
log_rotation_size = 0 #just ...
- 1,959
1
vote
0
answers
280
views
How to recover LogMiner after its tablespace had been deleted?
Here is my story:
I created separate table space for Log Miner,
create tablespace logminer_ts datafile '/path/to/logminer.dbf' size 50M AUTOEXTEND ON
And moved Log Miner to the created table space:
...
- 874
1
vote
1
answer
3k
views
What to do when the active log directory is full?
Here's my database configuration:
Log file size (4KB) (LOGFILSIZ) = 125000
Number of primary log files (LOGPRIMARY) = 10
Number of secondary log files ...
- 11
3
votes
1
answer
220
views
MySQL binary log reporting execution time as UINT_MAX
Looking through the MySQL Binlogs, I see some data that just does not make sense. There are queries that say they have been running for 4294967295 seconds (which also happens to be UINT_MAX on this ...
- 133
0
votes
1
answer
524
views
Clear out remnant LDF log files of Sharepoint DB not visible on SBS 2008 Domain Server?
Typical ways for dealing with LDF files that take up a lot of space, recommend these processes to shrink/ eliminate the drive space being occupied.
http://www.sharepointboris.net/2008/10/sharepoint-...
- 101
1
vote
1
answer
838
views
Does a read-only MySQL slave need log-bin in addition to relay-bin logs?
I'm running out of disk space on a newly initiated MySQL slave server. The bulk of disk space is in /var/log/mysql where I see both mysql-bin.000XXX and mysql-relay-bin.000XXX logs, each 1.1G.
Does a ...
- 262
1
vote
2
answers
370
views
How to log MySQL downtime
If I wanted to see the date, time and length of downtime on a MySQL instance/database, how would I go about doing that?
For example, if I wanted to see if the MySQL database went down at all last ...
- 99