Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The tag has no usage guidance.

0
votes
0answers
18 views

log rotate error in /var/log/messeges

i have a server with CentOS 6 as Os and DB2(10.5.0.5) database. i saw that our monitoring agents get connection but they dont close it. then i checked /var/log/messeges and saw this error: Nov 18 ...
2
votes
1answer
53 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 ...
1
vote
2answers
42 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
40 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
53 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
38 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
23 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
54 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 ...
0
votes
0answers
16 views

Postgresql - limit size of logged message

I'm trying to overcome a problem with unreadable postgres log. There is a database that contains (unfortunately) files in column with datatype bytea (bad application design, lot of time to rework to ...
1
vote
1answer
70 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
78 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
127 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
0answers
31 views

Network ACL - Which log to check what CN is the DB blocking

Pulling my hair on this issue. Getting ACL error (ORA-24247: network access denied by access control list (ACL)). Followed Oracle advised steps and also listed on many helpful blogs to add the ...
0
votes
1answer
127 views

Log Shipping failover when Primary is not accessible

Log Shipping Failover 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 failover will be 1) Copy ...
0
votes
2answers
448 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
50 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
56 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 ...
0
votes
1answer
250 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
215 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
290 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
114 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
63 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. ...
1
vote
2answers
723 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
124 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
174 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 "...
1
vote
3answers
671 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
167 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 ...
0
votes
1answer
200 views

LSN numbers query regarding Differential backups

We have the following backup regime in place which I am not 100% sure about. Full backup each night at 18:00 taking approx. 6 hours Transaction log backup upon completion of full generally about 10 ...
0
votes
1answer
6k views

Mariadb default logs location & --log-error

I am using mariadb and I to investigate some issue I wanted to check the logs. To my surprise, log file is not generated for mariadb. I suspect this cannot be the case so I am doubting my search ...
3
votes
2answers
4k views

Mariadb - Variable 'innodb_log_file_size' is a read only variable

Im using mariadb 10.0.29, I need to change the innodb file size to 256M, default size 50M, My config file is located on /etc/mysql/mariadb.conf.d/50-server.cnf I have added the below line, but it ...
1
vote
1answer
49 views

Logging remote transactions in mariadb

I know how to log all queries to a file in mariadb, is there a way for me to log only remote transactions? I've got a situation where I have a server with black-box software that does a lot of work ...
3
votes
1answer
549 views

Access Control not logging successful logins on MongoDB 3.4 Community

After adjust the verbosity of the parameter "accessControl" with the command: db.setLogLevel(5,"accessControl") The log file still not login successful login. On mongo 3.2: 2017-04-20T15:56:06.661+...
0
votes
0answers
37 views

How to log who has connected to a Postgresql (PostGIS) database?

I manage a cloud server with a PostGIS instance accessed by about 10 remote workers across the UK. I work with it through pgAdmin. To see who is connected at anyone time I use; SELECT usesysid, ...
1
vote
1answer
1k views

Mysql innodb_log_buffer_size change

I'm new to Mysql, and i'm reading this in a book: "A large log buffer allows large transactions to run without a need to write the log to disk before the transactions commit. Thus, if you have big ...
1
vote
1answer
83 views

Want to write a trigger after UPDATE

I have writen a trigger which will log every data updation and will log previous_value, new_value, field_name and many more. But the problem is i have 77 fields in my table. So, it's difficult to ...
1
vote
1answer
345 views

Change file types from rows data to log

I am looking for small advice. My database has 12 log files and x_log11 is showing file type as Rows data instead of Log and file group as primary. I am using SQL 2014. I need to change it from rows ...
1
vote
1answer
48 views

InnoDB MySQL account usage history

I would like to view the account usage history. I know it can be viewed via my.cnf through the general query log. But it will slow down the usage of the DB significantly. Is there a way to mitigate ...
-1
votes
1answer
37 views

Transaction log movement with no down time [closed]

If I were to create a secondary file to handle log overflow and then delete the first file what will happen?
1
vote
3answers
92 views

How to track only the tables used by app

I have a very messed up database with lot of tables that are really not used by the app so I'm tracking all the used tables with the general_log. I'm making the request to the app and with tail -f /...
3
votes
1answer
318 views

Why is Postgres not respecting my log file name convention dictated by “log_filename”?

I’m using Postgres 9.5 on Ubuntu 14.04. I have these settings set in my /etc/postgresql/9.5/main/postgresql.conf file log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, ...
1
vote
4answers
3k views

In Postgres, set log_rotation_size but my logs are still not rotating

I’m using Postgres 9.5 on Ubuntu 14.04. I wanted to rotate my logs whenever they reach a certain size. So I edited /etc/postgresql/9.5/main/postgresql.conf and set this log_rotation_size = 50MB ...
0
votes
1answer
2k views

How do I limit the size of my Postgres log?

I’m using Postgres 9.5 on Ubuntu 14.04. I notice I’m generating a lot of Postgres logs in /var/log/postgresql/postgresql-9.5-main.log . I would like to limit the size of this file, and doing some ...
0
votes
0answers
46 views

Is logging a good use case for a key:value document store like MongoDB?

I use Windows 2012r2 IIS for several projects. ODBC logging works but it slows things down. However, ODBC logging pays off when we need to audit the visits. SQL is easy to use. I know of no ...
0
votes
1answer
34 views

backup of databases - consistently back up databases with control of log truncates

My question is how can I back up my database by controlling the log truncates? I need to perform a testing with VEBF (Veeam Endpoint Backup FREE). A test case that I have to make now is that I have ...
1
vote
1answer
2k views

How do I determine the cause of high MySQL Aborted_connects count?

I have a MySQL 5.6 server that feeds to 6 web servers and a slave read-only mysql 5.6 server. These are the only clients with the exception of a monitoring software. If any were failing to work, I'd ...
0
votes
0answers
239 views

ib_logfiles out of sync

I'm doing the following: Stop mariadb Take a backup of the datadir (tar cfz backup.tgz /var/lib/mysql) Delete/recreate the VM Stop mariadb Replace the existing datadir with the backup I'd taken ...
3
votes
1answer
72 views

Why can't I shrink my logfile below to the requested value?

Experimenting VLFs behaviors with my test lab. Firsty, I have created two databases (BASE2 & BASE3) with different log files size (1024 & 2048 MO) : Secondly, I'am running the following ...
1
vote
1answer
341 views

Log file increases while differential backup is in progress

Database server: Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 Database Size: 500+ GB We have a staging history database which stores what so ever operation(Insert, update, delete) is done on live ...
3
votes
2answers
680 views

How to rotate trace logs in SQL Server

We are using 4032 & 3605 trace flags in SQL Server 2012 to get the expected log output. Now, we would like to rotate the log files on daily basis to archive it in Amazon Glacier storage facility. ...
1
vote
1answer
521 views

what does that mean? COMMAND [PeriodicTaskRunner] task: UnusedLockCleaner took: 273ms

With mloginfo I found a strange log entry. Didn't find anything about it in MongoDB docs and other related sites. $ mloginfo mongodb.log --distinct source: mongodb.log host: example ...