Questions tagged [log]
The log tag has no usage guidance.
155
questions
2
votes
2answers
44 views
In SQL Server, what's the impact of a checkpoint to log records in log buffer?
Does checkpoint operations flush everything in the log buffer to log file? Or just the log records relating to the dirty pages that are about to be flushed? I found some inconsistent description about ...
0
votes
1answer
47 views
Mysql on Ubuntu crashing periodically [duplicate]
I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day .
Here is the logs that I found in /var/log/mysql/error.log:
2021-02-23T08:35:08.249856Z 18 [Note] ...
1
vote
0answers
15 views
UNIX timestamp using for storing logs
Would it be feasible to use UNIX timestamp as a primary key to store log records/analytics data of users?
Will there be inconsistencies if a RDBMS is used to store log data?
0
votes
0answers
140 views
Oracle 19c with SAP System - ORA-12154: TNS:could not resolve the connect identifier specified For Physical Standby
Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side.
Outputs from primary side:
SQL> select status, error from v$archive_dest where dest_id=2; ...
0
votes
1answer
61 views
Why a job of dbms_job is BROKEN
I have Oracle job that uses dbms_job package. I see that it becomes BROKEN:
Select job,what,BROKEN from dba_jobs;
-------- ------------ -----------
1 statspack.snap; Y
I would like to know the ...
0
votes
1answer
41 views
How to use wal_level in Postgres to set the recovery mode to simple for a database like how Microsoft SQL Server does it?
In Microsoft SQL Server, ALTER DATABASE CURRENT SET RECOVERY SIMPLE WITH NO_WAIT; will set the recovery mode for a database to simple, so the transaction log file space can be re-used.
In Postgres, ...
1
vote
1answer
36 views
Does logging affect query performance
I want to benchmark the performance of MySQL, I want to know if logging affect performance.
MySQL has logs: general-log, binlog, errlog, redo log. Do these logging behaviors affect performance? For ...
0
votes
1answer
202 views
mysql (mariadb) won't start after power outage (MacOS)
/var/log/system.log says (over and over)
Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1
Oct 13 19:34:01 Data-Server com.apple.xpc....
0
votes
0answers
56 views
postgresql log is not work
My postgresql log on Windows appears to be not working.
I followed this postrge quey logging for windows question/answer and my query is not recorded.
2020-09-22 09:38:37.823 KST [20060] 로그: DB ...
0
votes
1answer
28 views
Where to find the whole log of a maintenance plan package job that failed with error?
I have a maintenance plan that runs on SQL Server agent as a the job and finishes with error. However the error is not visible in job history in SSMS, the text of Message is seemingly truncated. How ...
1
vote
1answer
57 views
Is there a way to hide mysql innodb cluster queries from general_log?
When I start my innodb cluster I get many lines of cluster related logs in the mysql general_log file like below, how can I hide these from the log?
2020-06-26T14:40:43.719029Z 31774 Connect ...
1
vote
1answer
43 views
Sql Server Backup - Log shipping vs VM snapshot
Setup
I have Sql Server Standard running on an AWS VM
For one of my DBs on this server, I perform:
1x daily backup
And ship logs every 15mins to another DB Server VM, dedicated to log shipping ...
0
votes
1answer
506 views
Know when MySQL server was slow shutdown? [closed]
I use MySQL 8.0.
How I can know when MySQL server was slow shutdown?
I start mysql server
/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --user=mysql
I shutdown mysql server
/...
0
votes
1answer
82 views
Rotate MySQL log files
I want to daily rotate MySQL log files on Windows. I want to keep the files, I don't want to use tables instead.
There are 3 log files: general.log slow-queries.log and error.log
I can do it easily ...
-1
votes
1answer
47 views
SQL Transaction Log [closed]
Is there a tool that allows us to have a log of all transactions executed by the sql server?
I am currently using the data profiler but it causes many crashes to the server.
I need a tool to record ...
0
votes
3answers
814 views
PostgreSQL will stop logging when logrotate rotate postgresql log file
I have installed
PostgreSQL 10.6 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.2.1 20180905 (Red Hat 8.2.1-3), 64-bit
And configured:
log_filename = 'postgresql.log'
But I would like to ...
3
votes
1answer
577 views
log_reuse_Wait_desc always return LOG_BACKUP even right after log backup
We are using SQL Server 2012 standard Edition (SP4)- 11.0.700.0(x64) (Build 14393)(HYpervisor).
Data File Size = 171 GB
Log File Size = 106 GB
When I queried sys.databases to see the ...
1
vote
1answer
633 views
MongoDB Server Log to file and rsyslog
I have to forward my logs to rsyslog via UDP, but due to the volatile nature of UDP and rsyslog I would like to also log to a file. However, AFAICT MongoDB only allows one target for its logs:
...
0
votes
1answer
899 views
Hard Disk is full of Sql server logs [closed]
SQL server created a lot of SQLDump.txt files in log folder I'm using SQL server 2017, but I have two databases in My SQL server. I find out my problem isn't about to shrink Ldf file I checked it out. ...
3
votes
1answer
1k views
Log for database tempdb is not available
I have been struggling with this issue from so many months now, I am saying its not a database issue and assigning this case to Storage and Operating system team and they are assigning it to me ...
7
votes
2answers
3k views
Why is my log file so massive? 22gb. I am running log backups
I can't seem to figure out the answer. I've seen multiple answers like this:
Why Does the Transaction Log Keep Growing or Run Out of Space?
and everyone talks about running back ups on your log file ...
2
votes
1answer
2k views
My disk is full of binlog files
I just realized that my server is growing by 2 GB per day, which is not normal.
I looked at my folder and the folder / var / lib / mysql reached 26 GB
Normally it should be about 4 GB
A month ago I ...
2
votes
1answer
6k views
Find queries executed by an user in sql server
I want to find all the queries executed by an particular user in a database over a period of time.
I learnt about trace and XEvents, but these are not setup yet, Will i be still able to get the ...
0
votes
1answer
286 views
PostgreSQL's PGP_SYM_ENCRYPT log security
In one of our project, I tried to use PostgreSQL's security extension pgcrypto. I found that is function, PGP_SYM_ENCRYPT is quite handy. Using this function enable me to query encrypted data with ...
10
votes
4answers
6k views
Disable Binary Logs in MySQL 8.0
How can I disable binary logging on MySQL 8.0?
I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in ...
0
votes
2answers
127 views
Keep a history of transactions for easy rollback
Is there a database (either SQL or NoSQL) which allows you to keep a history or log of all past transactions so that you can easily rollback to any given point in time (similar to how git manages a ...
2
votes
1answer
64 views
Which database transaction log will increase?
I found a query miss written in one of our databases like this
Use database2
go
delete database1.dbo.table1
from table1 as t1
join table2 on t1.column1 = t2.column2 and t2.column3 = 1
I am having a ...
2
votes
2answers
623 views
When mysql innodb undo log write and fsync to disk?
Before transaction commit , every dml operation will modify innodb page which will flush to disk and generate undo log , so when the undo log write and fsync to disk to ensure rollback ?
0
votes
3answers
5k views
Rotation of bin.log file
I am trying to change the binary log rotation from days to hours. By default there is an option only for days in the MySQL config file: expire_logs_days.
Is there any way to change the binary log ...
0
votes
1answer
137 views
how to shrink(and also reduce size on disk) a very big log file in SQL server 2016 [duplicate]
I have a datawarehouse with database log of 800 GB.now I want to shrink it or reduce the disk space occupied by Log.ldf file. I tried to shrink file in several ways - took full backup , performned ...
0
votes
2answers
416 views
Mysql 5.6 general log file output not showing unix timestamp
Mysql 5.6 general log file output not showing unix timestamp, so i wonder if there an option that i can execute to enable unix timestamp while logging general queries ?
UPDATE : Here is example for ...
0
votes
0answers
33 views
How to restore a mysql database
I have to re-build a mysql database (some tables were truncated), Is it possible? What logs do I need?
My mysql is 5.7 running on ubuntu 18.4
0
votes
0answers
603 views
SSIS: Using Event Viewer to Trace Errors of A Package
Overview
A package was developed due to a planned database server migration, and other teams with a dependency on legacy cross-database queries. There is a policy of not having Linked Servers, so an ...
1
vote
1answer
83 views
Is there a way to check which computer or IP used a particular script?
As the Title suggest, is there a way to check what IP used a particular SQL Script?
The scenario is, there is a recreation script in a email and we hypothesize that somehow, that recreation script ...
2
votes
0answers
421 views
What are the .pgAdmin4.2123502176.addr and .log files?
I recently installed pgAdmin4 on Win 10 64-bit. At the top of my main User directory it makes two tiny files, .pgAdmin4.2123502176.addr and .pgAdmin4.2123502176.log. (I'm assuming the numbers change ...
2
votes
0answers
567 views
SSIS Script Component Not Logging
How can I log from within an SSIS Script Component?
I am using the below code, which I believe should work.
public override void PreExecute()
{
this.Log("Entering PreExecute()", 0, new byte[0]);
...
0
votes
1answer
476 views
Log Shipping failover when Primary is not accessible
Log Shipping Fail-over
I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible.
My Steps for fail-over will be
Copy and ...
0
votes
2answers
3k views
Mongodb how to cancel a --fork without mongod service 'option'
I am currently having issues with sudo service mongod start/stop/etc so instead I have been running mongo with sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all --logpath /var/log/...
2
votes
1answer
65 views
How do I stop psql from displaying executed SQL?
When I execute SQL, I see the query echoed back at me.
=# \d
LOG: statement: SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' ...
0
votes
3answers
159 views
Get the last statement execution date on an MSSQL Database
In an MSSQL Database, I am trying to know when was the last statement executed for that database.
So, is there any log that I can use to see the required activity records (could be the Transaction ...
1
vote
1answer
1k views
Out of memory in MySQL error log
What should I check to solve this error that appears in the error log?
Do I need to add RAM to the server or adjust some configuration variable?
I copy part of the log:
180102 10:45:53 InnoDB: ...
1
vote
0answers
588 views
MySQL shutting down automatically
I have a LEMP server in a Ubuntu instance and my MySQL are shutting down automatically... I have no idea what's happening.
I had to manually restart it to keep the site online
Here is my mysql log
...
0
votes
1answer
1k views
Show recent select queries on Firebird database file
Is there a way to log or query the n recent SELECT queries to an FDB database file? I have already tried using the MON$ and RDB$ tables but I didn't find anything useful.
0
votes
2answers
350 views
Transaction Log file size for Index reorg
I have a DB that is 100GB. It's fixed this way on purpose. It won't exceed this. I have two indices. One with a single value. One with three values.
I'm not a DBA. I'm a guy who's been tasked with ...
-1
votes
1answer
75 views
DST Back up plan
Back up schedule for log backup (using Ola's scripts) as follows:
Start Time - 2AM
End Time - 11.59.59PM
Interval - Every 15 minutes.
On November 5th, all the back ups went as detailed above. ...
5
votes
2answers
4k views
PostgreSQL checkpoint log explained
I know what PostgreSQL checkpoint is and when it is happening.
I need some additional information about the logs produced by the log_checkpoints = on parameter, so please explain some points of it to ...
0
votes
1answer
722 views
Trying to make sense of the InnoDB log file stats
I've been reading the high performance mysql book by Baron Schwartz and after reading about how important it is to set the log file size correctly, I thought I'd take a look at one of our servers at ...
2
votes
2answers
687 views
Can't Restore Database Because of Rogue Log File
Someone, somehow, made a database disappear from SQL Server 2008 R2. I'm assuming it was dropped, because it doesn't show in SSMS in the Object Explorer's list of databases. Let's call the database "...
2
votes
3answers
2k views
MySQL slow query log to identify queries that scan tables
MySQL seems not to have setting to show you queries that use SOME indexes but still also do table scans
We have some badly performing queries and were hoping to find them systematically but the ...
3
votes
1answer
4k views
SQL Agent Job Logs - Can't get the Error Log
I've some logs that I want to extract to a report in order to get the SQL_Agent_Jobs status that runs during the night. If the Job fails then I want to receive the Error Log in a table. I am trying to ...
