Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
249
questions
0
votes
1
answer
2k
views
How to restore truncated MySQL table from binary logs?
I have a mysql server and while working on it I accidentlly truncated the wrong table. I do have a mysql dump wich I immediately used to restore my database structure, but I still miss some entries in ...
- 101
1
vote
0
answers
786
views
Oracle Error 12560 generating big sqlnet.log file
I have a Windows 2008 server which have two versions of Oracle: 11.2.0 and 12.1.0
A huge log file is being generated on the following path:
C:\Users\theUser\Oracle\oradiag_theUser\diag\clients\...
- 111
0
votes
1
answer
2k
views
Sql Server log: is 'Backup|Log was backed up' the same as 'BackupDatabase: Log files done'?
One transaction log file is growing and growing for a couple of days and I can't find out why. Now I figured out that either the way the activities are stored in the sql logfile OR the behaviour of ...
- 4,757
0
votes
1
answer
110
views
troubleshooting missing entries using log files
Something somewhere (most likely the app) is causing rows to disappear.
I'd like to find if there is a query that would point me in the right direction as to what's going on.
It looks like my bin log ...
- 185
1
vote
1
answer
2k
views
Increase logging/tracing on Oracle 12c database
I need to connect TLS-secured-ly to an Oracle 12c (from some random Java program, using JDBC connection)
I set up my listener to use TCPS, I made my wallet and everything and still my program is ...
- 113
4
votes
2
answers
2k
views
How is an Active Log different from MinLSN?
MinLSN is the LSN of the oldest uncommitted transaction:
What exactly does Active Log hold?
Isn't it supposed to hold all the uncommitted transactions?
Does it hold any other log records which are ...
- 339
1
vote
1
answer
490
views
automatic innodb redo log archiving
We have an option to do recovery through bin-logs, but we thought recovery through bin-logs is not 99% consistent because there is no LSN(Log Sequence Number)/SCN (System Change Number) in bin-logs (...
- 103
5
votes
1
answer
750
views
When was second log file created for database?
Is it possible to see when a second log file was created for a database and by who? I have found an additional log file that was created for one of our databases in our environment and I'm trying to ...
- 573
0
votes
2
answers
1k
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 (...
- 101
23
votes
3
answers
58k
views
MySQL InnoDB page_cleaner settings might not be optimal
Seeing this note in mysqld.log:
[Note] InnoDB: page_cleaner: 1000ms intended loop took 15888ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
There seems to be ...
- 342
0
votes
2
answers
3k
views
SQL Jobs logging only 2 days
When I righ click the job + view history, I can only see 2 days of logs. I'm sure this is a really noob question but I can't find the answer.
I've been changing values but with no success. The same ...
- 7,374
1
vote
1
answer
1k
views
How I create backup with backup by dump and WAL files in PostgreSQL?
I have a backup and WAL files, I like update my backup with WAL files. Anyone know how to do it?
Thanks
- 25
6
votes
1
answer
3k
views
Azure: Many Failed Login Attempts Logged
I run a SQL Server on an Azure Virtual Machine. I have noticed in the Event Logs of the server lots of failed SQL Login attempts using a ton of different usernames (none of which exist):
Login ...
user73880
0
votes
1
answer
48
views
What could cause a record to appear in the MySQL binary log but not the original table?
I have a web application (CiviCRM) that has the option to enable binary logging, which I've done. We use this software to record donations, including automatic recurring donations. Our payment ...
1
vote
1
answer
1k
views
mysql max_binlog_size is not working
I have a weird problem. I am currently using mysql and have defined 100M of max_binlog_size. However, I have hundreds of files created every day and each file is of no more then 2MB or 3MB each and ...
- 367
1
vote
1
answer
218
views
How to write marker messages into the MySQL general_log?
I'm build a performance testing harness for our distributed web app. I'm using JMeter to drive it by simulating poorly performing parts of the app from the web side. I've set up MySQL to log to the ...
- 113
0
votes
1
answer
981
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 ...
1
vote
0
answers
42
views
Managing logs generated by user
I am developing a web app for my client and there is a section which displays the changes made in the application by any of the user. This section is known as log.It basically stores and displays the ...
2
votes
1
answer
12k
views
could not open log file "/var/log/postgresql-2015-05-24_181212.log": Permission denied
I installed postgresql from source on Ubuntu 14.04 (I also installed from repositories too before, I just want to get a feel for both of them right now, as I will heavily rely on this database). So ...
- 495
0
votes
1
answer
481
views
MySQL database is going down once or twice a week, how do I diagnose?
I have a linode.com account running Ubuntu 12.04 LTS. On my server I have two instances of wordpress running with light traffic (100 to 400 users per day each) and an instance of Sendy (which is ...
- 103
6
votes
2
answers
27k
views
How to enable queries logs in MariaDB
I'm running mysql Ver 15.1 Distrib 5.5.46-MariaDB in CentOS 6.7 server. I'm trying to get queries logged and I'm doing by redirecting log to files as shown below:
#/etc/my.cnf.d/server.cnf
# this is ...
- 1,710
0
votes
0
answers
34
views
Why is the transaction log file not truncated though its simple recovery model? [duplicate]
My database is simple recovery model and when I view the free space in log file it shows 99%. Why doesn't my log file truncate the committed data automatically to free space in ldf file? When I shrink ...
- 471
4
votes
1
answer
206
views
DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)
we have DB2 in archive mode.
archive log files are created and deleted from the disk.
What will happen when archive log file reaches its maximum value for the name (S9999999.LOG) will it start to ...
- 685
2
votes
1
answer
3k
views
Can an active Postgres serverlog be truncated?
Running Postgres 9.1 on Ubuntu 14.10 LTS.
I've got an application running on a machine that's going to run out of diskspace soon. However, the application is in the middle of a crucial run that has ...
- 123
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 ...
- 232
0
votes
3
answers
920
views
Database logs growing during maintenance plan
I have read several threads and sites about SQL logs but I don't feel I have found the answer. Or if I did I did not understand it enough to address my issues. My issue: When I run my SQL maintenance ...
- 1
1
vote
2
answers
10k
views
DB2 ROLLFORWARD option "TO END OF LOGS" - does it read archive logs?
I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find ...
- 685
1
vote
1
answer
6k
views
DB2 ROLLFORWARD ERROR when doing "TO A POINT IN TIME" option
I do restore command of backup image which was made 03.03.2015 at 19:20:
db2 restore database maxdb71 from "/data/archiveBackup" taken at 20150303192002 without prompting;
Then I try to do the ...
- 685
1
vote
1
answer
2k
views
DB2 - question regarding RESTORE OFFLINE backup and Archive Logs
I configured last night DB2 to be in Archive Mode.
I created required offline backup at 23:00 last night.
First online backup will be created at Friday night.
Archive logs now keep coming to the ...
- 685
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 ...
- 15
0
votes
1
answer
266
views
DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?
We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10.
We are interested in next scenario:
If Server1 fails completely and we want to move everything ...
- 685
2
votes
2
answers
802
views
DB2 - Why new multiple C000000x subfolders are created in Archive Log folder?
After switching to Archive mode (from Circular mode to keeping archive logs on the disk) we had C0000000 folder where archive logs were copied.
Now I noticed that folders C0000001, C0000002, C0000003 ...
- 685
1
vote
3
answers
24k
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 ...
- 685
0
votes
2
answers
827
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 ...
- 685
5
votes
1
answer
2k
views
What's the best way to structure logging application data in MySQL
I may be overthinking this but:
I have an API; I want to log calls to the API for stat/debugging purposes. Ideally the speed of reads should be quick but is not essential (as will primarily be read ...
- 225
4
votes
2
answers
57k
views
How to list all past remote login information
Instead of using "Remote Desktop" for connecting to SQL Server, I and my co-workers are using SQL Server Management Studio to apply changes to the remote server (each user has their own credentials).
...
- 141
9
votes
1
answer
19k
views
How to view full blocking postgres queries?
I'm using a statement from this page to view blocking queries in Postgres
SELECT bl.pid AS blocked_pid,
a.usename AS blocked_user,
ka.query ...
- 569
8
votes
2
answers
59k
views
Flush/Clean MySql ib_logfile0 ib_logfile1
Is there a way to flush ib_logfile0 and ib_logfile1 without dumping the tables to a .sql file, deleting, then re-inserting? Somebody entered a couple plain text credit card numbers into the customer ...
- 183
1
vote
0
answers
373
views
Possible to get log file with only statements sent to Postgres from my app (and not from psql prompt)?
I'm using an ORM in my app and would like to see all statements sent to Postgres so that I can figure out exactly what the ORM is doing. In the Postgres config file I added log_statement = 'all' to ...
- 133
4
votes
1
answer
2k
views
Is someone trying to hack into my SQL Server Database?
I was asked by a friend, who isn't technical at all, to help her with her application.
I thought I would just being doing a little C# development and some SQL queries. Turns out it has been a lot ...
1
vote
1
answer
132
views
SQL Server log for revoke statements
I am trying to figure if SQL Server has a feature to log when a user fires statements as revoke, delete from, etc.
It would be great to see which user has fired the command, date and time, and which ...
- 337
1
vote
1
answer
1k
views
xp_logevent Invalid Parameter Type
I'm working with SQL Server 2012 Enterprise Edition SP2 on a Windows 7 32bits.
I have this code inside a stored procedure.
Begin try
-- EXEC CLR Stored Procedure
exec dbo....
- 1,843
1
vote
1
answer
318
views
Upgrading 8.1 to 9.3 - using statement log and WAL to check compatibility?
We're migrating from postgres 8.1 to 9.3, since we need streaming replication badly. All the application developers have deserted the company a long time ago, way before my time here, so there is ...
1
vote
0
answers
104
views
How To Log Select Statements from 1 User On 1 Table Into a Permanent Log Table
We have a centralized authentication library that 100+ applications use to authenticate users. That library has its own DB credentials. It would be extremely useful to log every time that library/user ...
- 188
4
votes
2
answers
23k
views
SQL Server 2008 R2 Log File Location
One of the databases I am going to support does not have a validate log file location. The drive which the log file is pointing to does not exist. But I don't see any error in database error log ...
- 143
2
votes
0
answers
2k
views
Understanding two types of mongodb log entries for bulk inserts
I have an app which does regular (every 2 minutes) bulk inserts to two identical instances of 2.6.4 mongodb on two servers. Both the instances are hosted on 2 Core, 14GB machine and have only one ...
- 253
1
vote
1
answer
3k
views
Insert fail logs
Is there a way to view fail inserts to a SQL Server database? I am seeing that a number of my inserts are failing and I'd like to recover that data if it's possible.
- 161
70
votes
6
answers
205k
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 ...
- 2,328
2
votes
1
answer
407
views
How can I enable logging for a single function in PostgreSQL?
I want to log the whole function runtime for a single particular function in PostgreSQL? Is this possible?
The value of log_min_duration_statement = 3000 in postgresql.conf and I've tried to do:
...
user4584
0
votes
3
answers
3k
views
SQL Log Messages - FILESTREAM and xp_cmdshell
I was perusing the SQL logs today and found the following:
FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
Configuration option '...
- 1,365