The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
1answer
36 views

is there a way to find out who was spid228 at a given time in the past?

I have a script that reads the error log so that I can see what has been happening within the last day: --create the table CREATE TABLE #Radhe (logdate datetime not null default (getdate()), ...
0
votes
0answers
66 views

Database Recovery Pending

Today I opened Sql Server Management Studio, after logging in as normal one of the DB is marked (Recovery Pending). I tried to recover with the backup file - seemed to work, but would fail as poss ...
1
vote
2answers
26 views

Getting the error log location in an efficient way

I am using this sql to get my error log location: EXEC xp_readerrorlog 0, 1, N'Logging SQL Server messages in file' However, sometimes I have very large log file (about 1gb, and I do not have ...
0
votes
0answers
10 views

Logging connected threads when “to many connections” occured

Can I get information (for example from log file) about threads connected when "too many connections" error occured? Is that possible (MySQL or others)? For example: Application is trying to ...
2
votes
1answer
102 views

Can't recycle the ERRORLOG - error 17049

When we attempted to run sp_cycle_errorlog we get the following: Msg 17049, Level 16, State 1, Procedure sp_cycle_errorlog, Line 9 Unable to cycle error log file from ...
0
votes
0answers
19 views

MySQL 5.6.18 got signal 11

My MySQL Server 5.6.18 got signal 11 today very randomly. Has not happened before. This is the stack trace : stack_bottom = 7fdb9bcb1e0f thread_stack 0x40000 ...
0
votes
0answers
22 views

I am seeing 99 archives of the same SQL Server errorlog

On my dev SQL Server 2014 sp1 instance, I have configured 99 archives of the errorlog. After a bounce, I am seeing 99 archives of the previous errorlog with the same timestamp. This appears to be a ...
1
vote
1answer
131 views

I am getting a failed login message in the SQL Server error logs however, nothing actually failed?

I have a server which runs third party software (called Visualcut) to email Crystal Reports to our users. When I log onto the Visualcut Server, I can open the software and then preview a report. This ...
2
votes
1answer
92 views

How to get all messages raised when a statement fails

Executing the below query will generate two error messages ALTER TABLE [MFClassProperty] DROP CONSTRAINT [FK_MFClassProperty_MFProperty] Error messages are: Msg 3728, Level 16, State 1, Line 3 ...
2
votes
0answers
666 views

SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy

I have an environment with 2 Windows Server 2012 R2 servers, both with SQL Server 2014 Expensive edition. Whenever a change happens in the AGs (such as: AlwaysOn Availability Groups connection with ...
0
votes
0answers
80 views

Got an error reading communication packets

Facing error in MySQL Log which is "Got an error reading communication packets" for multiple IP's. Current MySQL version is 5.0.67 running in Linux Things looked into so far are as follows ...
2
votes
1answer
239 views

How to suppress specific warnings in mysql error log when ignoring a table to replicate

Is there a way to make the mysql error log less chatty with certain warnings? I just threw in the replicate-ignore-table option in my.cnf so our health check table doesn't get replicated. However now ...
0
votes
1answer
56 views

Verbose Oracle RDBMS error log output examples?

I'm working on a project and my boss has asked that I find an actual example of the "verbose" output of an Oracle RDBMS query error. We want to see what they actually look like. I know that there are, ...
0
votes
0answers
71 views

Got an error from unknown thread, /pb2/build/sb_0-13157587-1410170252.03/rpm/BUILD/mysql-5.5.40/mysql-5.5.40/storage/myisam/mi_write.c:226

I am using mysql 5.5.40-log and my default storage engine is Innodb, I found this error in my error log "[ERROR] Got an error from unknown thread, ...
1
vote
0answers
57 views

Unsafe statement written to the binary log using statement format

In MySQL error log I am getting this warning message: [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it ...
1
vote
1answer
57 views

Why do you have to execute a full backup after a new database for trans backup jobs to run [closed]

Playing around on my local sql server at home after an issue occurred at work. We have full backup jobs scheduled on Mondays only. I created a DB on Tuesday (when doffs and trans are scheduled). ...
0
votes
0answers
401 views

Timeout occurred while waiting for latch: class 'ACCESS_METHODS_HOBT_COUNT'

We have a big reporting database on production server, and we have several SSIS jobs running against it. Yesterday almost all this-database-related SSIS jobs stuck and running forever. Also the ...
1
vote
1answer
388 views

How we resolve Mysql Enterprise online backup error with “CORRUPT LOG RECORD FOUND” log error

I have configured my production MySQL database with MySQL Enterprise "online Backup" option. The configuration was went through successfully. When the assigned scheduler is try to take backup then i ...
0
votes
0answers
55 views

Turn off serialization failure logging

Is it possible to turn off serialization failure logging? If so, how? For example, my log is filled with this example: ERROR: could not serialize access due to read/write dependencies among ...
0
votes
1answer
1k views

On not public server: Host name example.com could not be resolved: Name or service not known

This is not a duplicate (please read carefully) Digging in mysql logs of a production server I found a few entries with the error above, all pointing to the same host name. Each entry appears ~30 ...
0
votes
1answer
209 views

How to get something written to MySQL error log without restart

I want to cause the MySQL 5.5 error log to be written to at will without a service stop or start. Note that I do not care what gets written to the error log, as long as something gets written. I ...
3
votes
1answer
10k views

Postgres incomplete startup packet error

I am attempting to install Postgres 9.3 on Ubuntu 14.04 and I am getting an irksome error on startup. Here's what I'm seeing: $ sudo service postgresql restart * Restarting PostgreSQL 9.3 database ...
3
votes
1answer
302 views

How to suppress activation procedure output from the error log?

I found so many below informational messages (bulk messages with no any error) are logged in the SQL Server error log. The activated proc 'x' running on queue 'y' output the following: 'z' I ...
0
votes
1answer
535 views

PostgreSQL: PANIC: heap2_redo: unknown op code 32

I was doing migrations while the server was still accessing the slave DB. I have a master / slave setup. After I restarted the server, I realized I couldn't connect to the SLAVE anymore. I went into ...
1
vote
1answer
4k views

Mirroring SQL error log - Error: 8474, State: 11

I'm getting these errors in SQL error logs: An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far ...
1
vote
1answer
3k views

View permission to SQL Server logs on SSMS GUI

I would like to give a user see SQL Server logs from GUI, not through xp_readerrorlog. I was just wondering if this was possible? Thank you.
8
votes
1answer
789 views

Trace Flag 1222 Not Working?

I have a customer site with two similarly configured 2008r2 SQL Servers "A" and "C". On both servers the trace flags 1204 and 1222 are enabled and DBCC tracestatus shows the following on both ...
0
votes
1answer
377 views

MariaDB Galera cluster nod won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one slave-master node is up and running, but the third node just won't run. The system specs and cluster config are the ...
10
votes
4answers
12k views

Does SQL Server ever delete old error log files?

I know I can cycle the current error log easily by running sp_cycle_errorlog, but I'm wondering if SQL Server will ever delete the old/archived error log files at all. Can't seem to find an answer to ...
4
votes
1answer
677 views

Is there a way to suppress DBCC TRACEON/OFF messages in the Error Log?

We have quite a few dataloading processes that run throughout the day all day long. These processes are setting the 610 flag on for their connection then turning it off when they are done. Because ...
1
vote
1answer
2k views

BACKUP failed to complete the command BACKUP DATABASE

Not sure if this is a false-positive issue or not, but I need quell my curiosity about it. I get the following error message: Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the ...
8
votes
3answers
3k views

Keep getting message: Failed allocate pages: FAIL_PAGE_ALLOCATION 540

I'd appreciate some help with the following, I've done some Googling, but haven't managed to resolve this one. I keep receiving a message in the SQL Log 'Failed allocate pages: FAIL_PAGE_ALLOCATION ...
2
votes
1answer
248 views

SQL Server Error log - strange date

The dates in the SQL Server error log look very strange. A subset for messages between Sep/29/2014 8:00 am and Sep/29/5:40pm show a date of Feb/16/2014. Have you seen this before? Any idea why the ...
1
vote
1answer
200 views

Using file .log.3.gz

I have a file which I need to look at for errors, I got it from someone its extension is mysql.log.3.gz and when I uncompressed it, it has mysql.log.3, It is a log file? And if I open it in text ...
1
vote
1answer
1k views

Is there a better way to filter error logs? [closed]

I find it hard to believe that there aren't better native tools to filter SQL Server Error Logs. Even Windows Logs have better filtering capabilities. I'd like the ability to remove certain events ...
1
vote
0answers
52 views

What to do when the error message is longer than 4000 in T-SQL?

I have a OPENQUERY linking to an Oracle server that is failing. (I can't make any changes on the oracle server) But when it returns the error string it is cut short because it returns the query in ...
3
votes
1answer
4k views

Dropped Database Connections in SQL Server 2008R2

We are having an annoying intermittent problem where database connections from our client application on a variety of stations will get dropped. We have applications that use ODBC, Borland Database ...
2
votes
1answer
144 views

Error Logs various questions

I'm slowly collecting and trying to analyze lot of information on all of our instances (2008R2 SP1). I'm now going through the Error Logs and I've couple of question. There is a lot about error log ...
1
vote
0answers
2k views

SQL Server 2012: Login failed for user. Reason: Failed to open the database configured in the login object

Every so often, my SQL Server 2012 throws the following errors: Error (likely related to the one below): Source: spid99 The client was unable to reuse a session with SPID 99, which had been ...
4
votes
1answer
12k views

MySQL crashes randomly with “Database was not shut down normally” message in log

I am having an issue where, for no apparent reason, my MySQL server crashes and has to restart. Essentially, the error log has entries like this: 131128 12:16:35 mysqld_safe Number of processes ...
1
vote
1answer
1k views

PostgreSQL 8.0 - Windows Server 2008 R2 install - Service won't start

I am trying to install postgreSQL 8.0 on a windows server 2008 R2 machine. After the installation, the service does not start. When I try to start it manually, I get a message saying that the service ...
5
votes
1answer
161 views

SQL Server 2005 not collecting logins in the log file

I am currently running SQL Server 2005 Standard Edition on a Windows 2003 server machine. I have gone to the properties of the server and confirmed that the Login Auditing is set to both failed and ...