Questions tagged [log]
The log tag has no usage guidance.
163 questions
0
votes
2
answers
2k
views
How to upgrade MySQL from 8.0 to 8.4?
I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
John John
0
votes
0
answers
46
views
Usage of SparkMetric_CL, SparkListenerEvent_CL and SparkLoggingEvent_CL
I am wondering If can retrieve any information from Azure Log Analytics custom tables (already set) for Azure Databricks. Would like to retrieve information about query and data performance for SQL ...
- 421
0
votes
1
answer
281
views
SQL Trace log showing Revoke Execute from SQLArcExtensionUserRole
Every hour, the SQL trace log gets a dump of all databases getting their Server side Permissions altered, this is the exact text - ALTER ROLE db_backupoperator DROP MEMBER "...
- 186
0
votes
2
answers
909
views
What's inside a redo record in Oracle's Redo log?
While reading the Redo log wiki page, I was confronted with the following statement:
For example, if a user UPDATEs a salary-value in a table containing employee-related data, the DBMS generates a ...
- 131
0
votes
1
answer
541
views
getting the name of the function which caused trigger to activate in postgresql
Is there a way to get name of the function/procedure, which contains query, which caused a TRIGGER to activate?
For example I have function update_user_whatever and it updates user data and I want to ...
- 107
0
votes
1
answer
591
views
Recover deleted redo log files
I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
- 228
1
vote
1
answer
151
views
Cassandra System.Log shows nodtool tpstats output
We have a Docker Cassandra container running 6.8.21. At times when the container is restarted the the Logs show the usual startup activities and all just works well post that.
But on a few occasions ...
- 11
0
votes
1
answer
499
views
mssql 2019 alwayson cluster backup log chain is broken
now i had one mssql 2019 alwayson cluster.i backup database on master node using monthly fullbackup. weekly differential backup. daily log backup. but unfortunately then backup log chain always ...
- 1
1
vote
1
answer
2k
views
How to delete MongoDB log files
We are using MongoDB 4.0.4 version for our project. The database configuration is done as below:
Created a custom database in MongoDB and the service is running in authentication mode.
Using Windows ...
1
vote
4
answers
2k
views
PostgreSQL logging: Statements splits into multiple lines
In PostgreSQL v10 and above, I activated the logging of the statements using the extension pg_stat_statements.
My configuration:
logging_collector = on
log_line_prefix = '%t [%p]: [%l-1] db=%d,user=%u,...
- 29
1
vote
0
answers
41
views
How to solve Log shipping issues when Shadow copy volume-level backups are in place?
How to solve Log shipping issues when Shadow copy volume-level backups are in place? I tried setting up log shipping but it failed each time because the backup chain of the virtual log, the block ...
- 11
0
votes
1
answer
204
views
MariaDB Understanding "Event" Interval
I've created my first EVENT:
ALTER EVENT flush_logs_event
ON SCHEDULE EVERY 6 HOUR
COMMENT 'Rotate /var/log/mysql/master-bin*'
DO FLUSH LOGS;
I changed it from "12" to "6" ...
- 187
0
votes
1
answer
836
views
MariaDB master-bin Log Rotation
I've just setup MariaDB replication with 2 slaves in Debian 11 (Bullseye). I'm a bit alarmed to see the file size reach such a size without log rotation:
-rw-rw---- 1 mysql adm 297394983 Dec 8 05:...
- 187
1
vote
3
answers
1k
views
WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly
My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
1
vote
1
answer
678
views
MariaDB hidden disk usage for log dir
We have a simple master/slave cluster in our environment which is sets up on Ubuntu 20.04 and MariaDB 10.5:
MariaDB [(none)]> SELECT VERSION();
+--------------------------------------------+
| ...
0
votes
0
answers
69
views
Detail about communication packets error log
On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day:
2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading
communication packets
My question is ...
- 139
3
votes
2
answers
562
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 ...
- 2,062
0
votes
1
answer
1k
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
0
answers
26
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
0
answers
2k
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; ...
- 29
1
vote
1
answer
3k
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 ...
- 430
0
votes
1
answer
944
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, ...
- 147
1
vote
1
answer
766
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 ...
- 233
0
votes
1
answer
1k
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....
- 191
0
votes
1
answer
261
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 ...
- 629
1
vote
1
answer
221
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 ...
- 21
1
vote
1
answer
168
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 ...
- 11
0
votes
1
answer
3k
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
/...
- 101
0
votes
1
answer
2k
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 ...
- 884
-1
votes
1
answer
50
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 ...
1
vote
4
answers
5k
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 ...
- 121
3
votes
1
answer
2k
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 ...
- 33
1
vote
1
answer
1k
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:
...
- 270
0
votes
1
answer
2k
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. ...
- 109
3
votes
1
answer
3k
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 ...
- 3,904
7
votes
2
answers
4k
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 ...
- 181
9
votes
2
answers
19k
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 ...
- 103
3
votes
1
answer
33k
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 ...
- 131
1
vote
1
answer
869
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 ...
- 11
14
votes
6
answers
20k
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 ...
- 2,166
0
votes
2
answers
457
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 ...
- 125
2
votes
1
answer
68
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 ...
- 157
3
votes
2
answers
1k
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 ?
- 467
1
vote
3
answers
13k
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 ...
- 11
0
votes
1
answer
460
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
2
answers
629
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 ...
- 163
0
votes
0
answers
46
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
- 252
0
votes
0
answers
2k
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 ...
- 113
1
vote
1
answer
92
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 ...
- 111
2
votes
0
answers
966
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 ...
- 21