Questions tagged [logs]
A sequential journal of database write operations that facilitates robust atomic write operations.
249
questions
3
votes
1
answer
4k
views
Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
TL;DR: Un-stoppable, unusable postmaster is being spawned when Postgres is started right after restoring its data directory from a WAL base backup. Why?
Context:
We run postgresql 8.4, on CentOS 6, ...
- 526
2
votes
1
answer
7k
views
log_warnings doesn't seem to work for aborted connections in MySQL 5.1
The docs for 5.1 say that I can set log_warnings = 2 to capture Aborted_connects in the error log. This bug report suggests that this was only merged into 5.5 and 6.0 (and maybe 5.2) but not into 5.1....
- 162
3
votes
1
answer
767
views
Could a large log file be the reason cron job keeps dying?
The log is 15 Gigabytes. I guess I have to back it up and delete. I have enough hard disc space, but did not realize log was so large. And overnight cron jobs suddenly started to die in the middle.
- 133
2
votes
1
answer
190
views
Log file for mysql
I would like to know where will my error logged for mysql server. As of now I just see one log that is in /var/log/mysqld.log. I saw some have .err files too am I missing something here? What would ...
- 969
0
votes
1
answer
999
views
How to troubleshoot/debug Oracle permission problems
An application is connecting to Oracle to do stuff. It's not working but I don't get any ORA errors in the application itself. I'm thinking its a permission problem. So my question is what is the best ...
- 175
3
votes
1
answer
11k
views
Very Large Log Files
I'm running Windows Server 2008 R2 and executed a large query by accident. Next, the sever ran out of hard drive space.
I now have a file in my administrtor documents (log.log) that is over 18GB. I ...
- 31
7
votes
2
answers
4k
views
Investigate peak in MySQL throughput
Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
- 349
1
vote
1
answer
284
views
create more logs in Mysql, pros and cons?
I just install XAMP in my mac and I'm trying to learn by my own, with books, tutorials and you guys. I'm working in the backup part and I saw I have only a LOG "mysql-bin.000001' :
What happen when ...
- 1,999
4
votes
2
answers
3k
views
SQL Server Clustering for HA combined with Log Shipping for DR
Has anyone implemented SQL Server log shipping in a clustered environment? Are there any issues or things to consider when implementing this scenario?
- 41
2
votes
2
answers
4k
views
MySQL flush logs, unknown error
I gave been trying to solve this for few days now, and cant seem to figure this out.
I have been trying to set log rotation for mysql slow using linux logrotate feature, and my script seems to get ...
- 741
2
votes
1
answer
415
views
Initial recovery Postgres with backup in sync commit mode
I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time.
I did the following steps:
Stopped master
Copied all files to Slave
Create recory....
- 567
2
votes
2
answers
5k
views
How do I recreate a deleted logfile on an Oracle database?
For my database assignment we were looking into "database corruption".
I was asked to delete the second redo log file, which I have done with the command: rm log02a.rdo this was in the $HOME/ORADATA/...
- 21
2
votes
1
answer
10k
views
Resolving frequent LGWR switch events recorded in Event log with heavy dblink/materialized view activity - Oracle 11g XE
We use a student information system, PowerSchool, marketed by Pearson. PowerSchool uses Oracle as a backend database, and we have the need to create some of our own reporting views.
Pearson says if ...
- 165
4
votes
1
answer
2k
views
How are binlogs updated for MySQL temporary tables?
If I use CREATE TEMPORARY TABLE, can I write and update this MySQL table and know that none of it will be stored to the binlogs?
If I use data from the temp table to write to a non-temp table, is the
...
- 675
3
votes
2
answers
9k
views
Clearing SQL Server 2005 event log
I need to delete the SQL Server 2005 logs, but can't figure out how to do it. I'm talking about the logs that are found in Management -> SQL Server Logs in SSMS object explorer. I can't seem to ...
- 161
2
votes
1
answer
6k
views
strategy for enabling a general query log on MySQL 5.0.95 with no restart?
I would like to configure a general query log for a busy MySQL 5.0.95 production server without effecting the availability.
Obviously I can set the "log" option in the my.cnf file and restart the ...
- 267
5
votes
3
answers
357
views
Is there a way to query SQL Server 2005/2008 for location of its log files?
I there a way to query SQL Server 2005+ for the file system location of its various log files. By that I mean the text log files, not database transaction log files?
For example my SQL Agent, Error ...
- 1,326
3
votes
2
answers
17k
views
mysql bin-log.index not found
I moved my bin-logs to a different folder:
log-bin = /storage/mysql/bin-log
log-bin-index = /storage/mysql/bin-log.index
When I try to start mysqld I get this:
/usr/libexec/mysqld: File '/storage/...
- 161
2
votes
3
answers
2k
views
do oracle redo logs need to be copied when all other data is copied to a new disks?
I have to migrate all data for an Oracle server from the present SAN to a new SAN. It is an 11g database in production on a Linux server. Database software is on local disk but all data (including ...
1
vote
4
answers
189
views
copy ldf from one server to another
I keep getting "file is open in another program" when i try to copy LDFs from one production to dev. Is there another way to copy these ldfs to dev server?
- 53
3
votes
2
answers
686
views
Shrinking log file
Some of my SQL Server's log files (ldf) are huge, like 5GB. I Found an article about shrinking, but am not sure why the author repeated DBCCSHRINKFILE 6 times.
Can someone please confirm and suggest ...
- 53
2
votes
1
answer
5k
views
mysql error log issue
I have mysql server running successfully.
The error log location is as..
mysql> show variables like '%log_erro%';
+---------------+------------------------+
| Variable_name | Value ...
- 9,627
3
votes
1
answer
10k
views
Mysql master-master replication auto flush old logs
I have mysql-5.1.41 master-master setup running on ubuntu machines and below is the configuration of a master:
skip-host-cache
skip-name-resolve
event_scheduler = ON
max_connections = 500
...
- 165
4
votes
1
answer
15k
views
How to enable MySQL general log?
I would like to enable the MySQL General Log to view all the (slow) queries. I'm using XAMPP as server and have no idea how to enable it. I can't find a good guide on the internet.
Can someone help ...
- 143
2
votes
1
answer
4k
views
Why is mysql logging to syslog?
I have installed Multiple MySQL instances and i have two configuration files one for each one is using default location of /etc/mysql/my.cnf.
other server i have started like
root@ABC-240:/usr/...
- 9,627
3
votes
1
answer
2k
views
How to do MySQL User Accounting
I can't seem to find any information on this anywhere. I found a question here called Monitor MySQL activity per database? but that's not quite the answer either.
I'd like to be able to log the ...
- 241
2
votes
1
answer
546
views
mysql emits BINLOG rows even though binlog_format=STATEMENT
We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)
According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
- 175
3
votes
1
answer
4k
views
What does the base64 BINLOG statements in mysqlbinlog output mean?
I have looked over the mysqlbinlog command as a candidate for rollback method from MySQL 5.5 to MySQL 5.0.
When I ran the command on one of the bin-log files in the MySQL 5.5 server, I've noticed ...
- 175
3
votes
2
answers
2k
views
How do I configure PostgreSQL 8.3 to log bind parameters?
I'm running into some unique constraint problems with my database. I can't reproduce them, but see error messages from our production system:
exception 'UniqueViolation' with message
'SQLSTATE[...
- 133
1
vote
1
answer
393
views
How to keep MySQL general_log after I restart my computer?
I use a statement set global general_log = 'ON' to enable the general_log on my computer.
After I restart or shutdown it, I have to run the statement again.
How can I config MySQL write general log ...
- 256
2
votes
2
answers
2k
views
How to Test Log Shipping
I am evaluating log shipping as a solution to keep a permanent failover copy of our live database. It looks ideal.
We are using Filestream which is part of the reason to use it over mirroring.
I ...
- 2,187
6
votes
3
answers
4k
views
How do I minimise logging during a large insert?
During a nightly scheduled task I am creating a large table from scratch using select into and then adding a clustered index. I would like to minimise the amount of logging during the whole process as ...
- 39.7k
9
votes
3
answers
768
views
Need Help Troubleshooting Sql Server 2005 Deadlock Scenario
I am running into a deadlock scenario where the only participants in the deadlock appear to be a single table and a single stored procedure that deletes from that table. I drew that conclusion based ...
- 93
5
votes
3
answers
4k
views
Log MySQL DB changing queries and users
For security reasons I need a server-side (running Debian 6.0 Squeeze) logging of all queries that may have changed the content of a MySQL DB (v. 5.1) and the user who issued it. I had to rule out
...
- 205
2
votes
2
answers
2k
views
Will improper bin-log purging leads to deletion of mysql database
We had master to master and master to multiple slave environment in one of our client location. In one of the slave Db host we had disk space issue with bin-logs. At first i deleted the bin-log files ...
7
votes
1
answer
1k
views
How long can the log reader agent run for before a restart will do it some good?
As a developer who has for the first time successfully implemented a replication topology for our production database, I'm monitoring it very closely and fretting over potential problems.
I'm pleased ...
- 293
9
votes
3
answers
66k
views
How do I truncate the transaction log in a SQL Server 2008 database?
How do I truncate the transaction log in a SQL Server 2008 database?
What are possible best ways?
I tried this from a blog as follows:
1) From the setting database to simple recovery, shrinking ...
- 203
2
votes
1
answer
1k
views
If archiving is disabled and the last redo log file is full, why LGWR continues by overwriting the first available active file, not inactive file?
I found the following sentence from Oracle documentation.
If archiving is disabled (the database is in NOARCHIVELOG mode), then when the last redo log file is full, LGWR continues by overwriting ...
- 2,602
2
votes
3
answers
3k
views
Undo DDL statement on View in Oracle
I Want to undo DDL changes on View, how to do that?
I have not set utl_file_dir parameter and can't restart the database to set it. So log miner can not be used yes? it needs this parameter... If ...
- 1,707
2
votes
3
answers
2k
views
Oracle get sql redo from log_history
I run into a problem with a customer which had no proper backup.
His last backup (meaning exp-dump) is from 1st Aug 2011.
However he lost due to batch DELETE statements all data.
My plan was now to ...
- 121
4
votes
1
answer
22k
views
PostgreSQL: Change log file location
How can I change the location of the log file in PostgreSQL? Can it be done without stopping the cluster?
- 11.5k
47
votes
6
answers
349k
views
Can I see Historical Queries run on a SQL Server database?
Someone was running a query on our SQL Server database remotely and their system crashed.
They have no backup of that query and want to see what was run on the server.
Is it possible to find this ...
- 573
14
votes
3
answers
38k
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 ...
- 345
18
votes
3
answers
1k
views
How to store 'n' days of web server logs in Sql Server?
For faster reporting and performance analysis, we want to insert our web server logs into Sql Server. This will allow us to see traffic patterns, issues, slowdowns in near real-time.
We have a daemon ...
- 283
6
votes
1
answer
255
views
IIS access log to SQL normalization
I am looking for insert IIS 6.0 access log ( 5 servers, and over 400MB daily ) to SQL database. What scares me is the size. There is a lot of information you are duplicating (i.e. site name, url, ...
- 191
2
votes
3
answers
137
views
Is having a 92MB MDF with a 58MB LDF cobo ok? How do I manage the log to keep things running well?
I have jobs in place to trim tables used for history and logging so to keep them trim. I want to make sure I don't neglect the log file.
How and what can I or should I do to keep the log file in ...
- 2,032
5
votes
1
answer
930
views
whats best practice for Log Truncation in SQL Server?
I have a production DB in SQL server and wanted to put the final touches after the functionality is completed. prior to shipping it out i want to make sure i have some clean up in the SQL server DB ...
- 2,032
117
votes
5
answers
233k
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:
...
- 23.4k
7
votes
2
answers
8k
views
SQL Server 2008 log files have minimum sizes, what gives and how do I make them smaller?
Ok, to start with, I screwed up when I created the databases, using a create script roughly like so: (artificial linebreaks and names/paths for wrapping purposes)
CREATE DATABASE [EXAMPLE] ON ...
- 6,345