Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
252
questions
0
votes
2
answers
2k
views
What to do when MySQL is not generating any logs at all on Debian?
The problem I'm having is that MySQL (5.5.46-0+deb7u1) is not generating log files. This on Debian Wheezy.
The my.cfg file has been updated according to the required config for logging ALL queries (...
CommunityBot
- 1
0
votes
1
answer
24
views
MariaDB, where's the GLOBAL general_log file?
SHOW VARIABLES LIKE 'general_log%';
+------------------+------------------+
| Variable_name | Value |
+------------------+------------------+
| general_log | ON |
| ...
- 6,451
0
votes
1
answer
541
views
auto_explain does not log
looks like i do it wrong. I turned auto_explain on with adding next valued to postgresql.conf:
shared_preload_libraries = 'pg_stat_statements,pg_wait_sampling,pg_stat_kcache,auto_explain'
...
CommunityBot
- 1
0
votes
1
answer
1k
views
Unable to show binary logs how to remove logs from mysql?
Server version: 5.1.50-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show binary logs ;
PROBLEM
Data directory is full
I want to remove ...
CommunityBot
- 1
0
votes
2
answers
1k
views
"user does not exist " when calling DBMS_LOGMNR.START_LOGMNR
I have a CDB user called "MYADMIN" and I'm trying to make it connect to log miner.
-- enable calling admin username on CDB
ALTER SESSION set "_ORACLE_SCRIPT"=true
/
-- create ...
0
votes
0
answers
87
views
Mariadb is not truncating even Innodb Undo log Truncate is On
we have configured the below settings in our configuration file.
--innodb_file_per_table=1
--innodb_undo_tablespaces=3
--innodb_undo_directory=/var/lib/mysql/
--innodb_undo_log_truncate=ON
--...
- 782
0
votes
1
answer
225
views
How to delete "SQL Server Agent" logs from "Log File Viewer"?
On "SQL Server 2019" on Windows 2019:
I have opened Microsoft SQL Server Management Studio.
I logged into database server.
I clicked on "SQL Server Agent" and clicked on "...
- 1,906
13
votes
2
answers
7k
views
How do I hide sensitive information like plaintext passwords from the logs?
I do not have access to a Postgres installation, so I cannot check.
I am a security guy, and I'm seeing plaintext passwords in the logs:
create user user1 with password 'PLAINTEXT PASSWORD'
How can ...
- 57k
0
votes
0
answers
189
views
Analyze MariaDB error logs to get information what were happened on server
Can you help me understand what was happen on MariaDB server. I wasn't able to connect to this server because there was 'Too many connections'. This is one of our slave in replication so non of main ...
- 500
0
votes
1
answer
248
views
How is the current sequence number in the control file used during recovery?
During recovery, how is the current sequence number used to determine the redo log files used to re-construct the database as well as the order in which to apply the changes recorded in them?
0
votes
2
answers
791
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 ...
4
votes
1
answer
4k
views
MySQL 8.0.30+: redo_log_capacity vs log_file_size?
Cheers. We're trying to track down the cause of a significant increase in IO load after switching from MySQL 5.7 to 8.0.30, and one issue we've noticed is related to this part of documentation:
The ...
- 15.4k
0
votes
1
answer
272
views
Cassandra has stopped producing log files
I've recently taken up the role of managing a Cassandra Cluster that has been running in production for a few years. This is my first time working with Cassandra so I would appreciate any insights.
It ...
- 3,940
117
votes
5
answers
239k
views
How to safely change MySQL innodb variable 'innodb_log_file_size'?
So I'm fairly new to tuning InnoDB. I'm slowly changing tables (where necessary) from MyIsam to InnoDB. I've got about 100MB in innodb, so I increased the innodb_buffer_pool_size variable to 128MB:
...
- 78.8k
3
votes
1
answer
387
views
PostgreSQL time series table with composite partitions
I am investigating how I might structure a PostgreSQL table to store a large amount of time stamped data that also needs to be portioned by another field.
My expected data structure will be something ...
- 40.6k
3
votes
1
answer
966
views
How to enable authentication logs in Firebird 2.5?
I downloaded Firebird 2.5 from the official website and installed on a Linux machine. The install location is /opt/firebird.
I want to be able to view authentication attempt logs for security reasons (...
0
votes
1
answer
396
views
Database alters MOUNT mode after reboot
We have Oracle XE 10.2.0.1.0 running on CentOS 6.9.
The Database works stable all the time, except the system reboots.
If reboot command is issued in the OS terminal, the Database enters MOUNT mode.
...
2
votes
3
answers
6k
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
...
0
votes
2
answers
906
views
Database returned to CIRCULAR mode but logs are still being archived to old location
my DB2 database (v 9.7) is in Circular mode.
Current Logging Type:Circular
(USEREXIT) = OFF
(LOGRETAIN) = OFF
(LOGARCHMETH1) = OFF
(LOGARCHMETH2) = OFF
(LOGPRIMARY) = 10
(LOGSECOND) = 10
Path to log ...
0
votes
2
answers
1k
views
Lot of log files in $FSLOG generating. How to stop?
I'm using SQL Server 2012 Express Edition and I have a problem with huge amount of files generated in:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\...
- 2,201
0
votes
1
answer
539
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-...
- 2,201
1
vote
3
answers
9k
views
How to change the expiration date of binlog files?
I have a server with Ubuntu 18.04 and MySQL 8.0.11
I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate.
How to change the expiration date of binlog files ?
...
- 1
22
votes
1
answer
58k
views
What exactly are iblog files in mysql
I would like to understand these ibdata files as these play vital role in the crash recovery procedure. I could not find proper resources over the web for this.
- 226
1
vote
0
answers
93
views
SSIS in Azure: operation_messages_scaleout event_messages_scaleout tables not populating
We are running SSIS packages in AZure. I am finding that for some reason we have stopped populating the SSISDB tables (operation_messages_scaleout, event_messages_scaleout). It does appear that the ...
- 11
0
votes
1
answer
258
views
How to log deadlocks for each database separately
I have MariaDB 10.6.5 server with several databases.
I added a line innodb_print_all_deadlocks = 1 to config file.
Now all deadlocks are logged to one file /var/log/mysql/mariadb.err
Is there any way ...
- 1
23
votes
1
answer
25k
views
log_min_duration_statement setting is ignored
I am running Postgresql 9.1 on Ubuntu. Exact Postgresql version is 9.1+129ubuntu1 as my package manager shows.
I have 2 databases that are actively in use and they are used from a remote server.
I ...
- 180k
0
votes
1
answer
310
views
Do we need additional license to dump goldengate trail logs to kafka?
We have a Oracle (12c) GoldenGate license only (we do not have an oracle goldengate for big data).
We need to transfer the gg trail logs to kafka then to hdfs.
Do we need to buy the oracle goldengate ...
- 1,564
14
votes
3
answers
39k
views
How do I output MySQL logs to syslog?
I want to use syslog for logging MySQL(5.1.41) on Ubuntu(10.04 LTS).
I found information that output error log to syslog.
[mysqld_safe]
syslog
But I want to use syslog for logging general logs and ...
- 184k
0
votes
0
answers
155
views
Log files are still created even when general_log is OFF - MySQL (MariaDB)
I have a MySQL server (10.4.21-MariaDB) installed by the XAMPP stack on ubuntu.
I notice in the mysql folder (/opt/lampp/var/mysql) several files:
ip-172-31-14-21.err
ip-172-31-14-21.log
ip-172-31-14-...
- 111
7
votes
3
answers
3k
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 ...
- 101
0
votes
0
answers
267
views
MariaDB rotated logs are empty on CentOS7
I've been having the same problem for a couple of weeks now. I have the following /etc/logrotate.d/mariadb file configuration:
/var/log/mariadb/*.log {
create 600 mysql mysql
...
- 3
0
votes
0
answers
68
views
Postgres connection logged temp file, but no query?
I'm going over some logs for a Postgres database and came across the following logs and I'm at a loss as to what would've caused it.
connection authorized: user=app1 database=pg SSL enabled (protocol=...
- 621
0
votes
1
answer
522
views
SQL Server 2017 freezing during bulk insert of large file into in-memory staging table
Running SQL Server 2017 CU20 Standard on a dedicated Dell PowerEdge with 28 cores and 192GB of RAM.
I have a stored procedure that processes large files (~7GB each) in a loop by bulk inserting them ...
- 909
0
votes
1
answer
264
views
convert RDS csvlog into pgreplay-go compatible for replaying
Before upgrading AWS RDS PostgreSQL version at production, I want to replay 1-hour recorded logs at the test instance.
Unfortunately pgreplay is single-threaded application, limited by single CPU ...
- 101
0
votes
1
answer
200
views
Postgresql log uploading service on Ubuntu Linux
I am trying to create a systemctl service to collect + upload logs for Postgresql 12 on Ubuntu Linux. However, I am expert at none of the two.
While I have set up the server modifying /etc/postgresql/...
- 103
74
votes
6
answers
232k
views
Disable MySQL binary logging with log_bin variable
Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled:
log_bin = /var/log/mysql/mysql-bin.log
When I want to ...
- 88k
0
votes
1
answer
147
views
Mysql falls every day
My database Mysql fallas every day:
Looking at the tail -100 /var/log/mysqld.log
Shows:
2020-08-16 20:56:03 7f787c7fb700 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.
...
- 2,038
1
vote
1
answer
654
views
Clear PostgreSQL logs in AWS Ubuntu Server
I am trying to clear the logs of an postgresql under /var/log/postgresql/ but I am getting error message as below:
/var/log/postgresql$ sudo > postgresql-11-main.log
-bash: postgresql-11-main.log:...
- 54.8k
1
vote
1
answer
967
views
An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action
Background:
I am trying to keep a track record of what users are querying in the database. One option I found is to create a Server and Database Audit Specification. I did not want to include INSERT ...
- 5,791
2
votes
2
answers
7k
views
Stress test MySQL with queries captured with general log in MySQL
Is there any tool available which can do stress testing using the log file created by MySQL general log?
After a lot of search on google I found few stress testing tools which only use some benchmarks ...
- 184k
0
votes
1
answer
566
views
How to monitor for MySQL select queries that return too many records? [closed]
I realize there are simple ways to limit results in SQL. I have a legacy implementation. I would like to get a handle on select queries that return results exceeding some user defined limit. The goal ...
- 184k
1
vote
1
answer
351
views
Why am I able to create MV logs using PK — even though there is no PK?
I have a table that does not have a primary key:
I'm able to create MV logs on the table — without specifying whether to use the primary key or the rowid:
create materialized view log on maximo....
- 1,497
1
vote
0
answers
213
views
User names in postgres docker image logs
I'm looking to get thorough logs of user activity attributable back to users from the official docker image of Postgres. I'm running my docker image like so:
docker run --name pg -e POSTGRES_PASSWORD=...
- 317
5
votes
1
answer
11k
views
Raise NOTICE, Raise INFO not saved to logs in POSTGRES
I searched a lot on google but no solution found, I am not sure what I am missing here.
My intention here is to store the notice , info from this procedure to postgres logs (txt files) that are ...
- 34
1
vote
1
answer
3k
views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
- 184k
1
vote
3
answers
26k
views
DB2 ARCHIVE mode - Can all archive logs be deleted after doing the FULL OFFLINE backup?
I am interested in one thing, if I understood correctly.
DB2 is in Archive mode (online backups are made and archive logs keep coming which is OK).
If I made offline full backup today and I know I ...
0
votes
1
answer
1k
views
MongoDB deleted logs
So I recently realized my /var directory was growing but couldn't find anything using du, then find out about lsof and found the following:
lsof -nP | grep '(deleted)'
mongod 23184 23205 ...
CommunityBot
- 1
0
votes
0
answers
206
views
After a reboot and latest CU for sqlserver 2017 I get this annoying message
After a reboot and latest CU for sqlserver 2017 I get this annoying message (the xxxxx was a number)
SSBDT: Dialog timer delete during registration (did:
xxxxxxxxxxxxxxxxxxxxxxxxxxxx:Initiator, ...
1
vote
3
answers
3k
views
What to do when archive logs are lost/corrupted that are not backed up
All recently generated archive logs were corrupted but datafiles are fine.What if recently generated archives corrupted and the archives backup is not available, so what would be the strategy to ...
- 9,150
0
votes
1
answer
40
views
SQL Backup routine regarding DB Logs
I recently had an incident that got me rethinking my backup plan: One of our MSSQL driven aplications stalled because the log fle had grown too big on the filesystem (it was 50 GBs IIRC).
It turned ...
