Questions tagged [error-log]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
20
votes
2answers
86k 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 ...
14
votes
4answers
33k 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 ...
8
votes
3answers
7k 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 ...
8
votes
1answer
1k 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 servers:...
7
votes
2answers
2k views

Unknown,AppDomain 66 (master.sys[runtime].65) is Marked for Unload Due to Memory Pressure

I have noticed this error occasionally in the SQL error log: spid20s,Unknown,AppDomain 79 (master.sys[runtime].78) is marked for unload due to memory pressure. I am using SQL Server 2016, SP1 CU5 (...
6
votes
2answers
5k 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 ...
5
votes
1answer
8k views

How to remove SQL Server Error Logs

I have six error logs plus the current. They are taking up 10G of disk space on my hard drive on my VPS server. Thats about 25% of the server space. The largest file is 6G and growing. How can I ...
5
votes
3answers
1k views

After upgrade to 2016, can't view SQL Server Logs

Just upgraded to SQL Server 2016 from SQL Server 2014 SP1 CU4. This is a clustered instance I am no longer able to use xp_readerrorlog and xp_enumerrorlog Msg 22004, Level 16, State 1, Line 10 ...
5
votes
2answers
28k 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 ...
5
votes
1answer
361 views

HKHostFreezeCkptTrimming on SQL Server 2017

Have a SQL Server 2017 Standard edition box with build 14.0.3045.24 with one memory-optimized table. When our 3rd party backups complete the SQL Server 2017 error log shows several [INFO] messages ...
5
votes
5answers
22k views

SSPI handshake failed with error code 0x8009030c, state 14

DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext ...
5
votes
1answer
2k 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 ...
5
votes
1answer
182 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 ...
5
votes
0answers
2k views

SQL Server 2016 InitializeExternalUserGroupSid failed message on startup

I have a SQL Server 2016 installation that I inherited. It does not use or have R or Machine Learning configured. When it starts, I see these messages in the log: InitializeExternalUserGroupSid ...
4
votes
2answers
2k 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 ...
3
votes
1answer
1k 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 ...
3
votes
2answers
40 views

SQL Server created a new errorlog file but instance and agent were not restarted

One of our jobs failed but the job history had already expired by the time we investigated. We could, however, see that a new log file was created around the time it failed. There was no instance ...
3
votes
1answer
923 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 '...
3
votes
1answer
4k 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 ...
3
votes
1answer
3k views

Postgres 10 shutting down on installation in Ubuntu 14

On trying to install postgres on Ubuntu 14 I am seeing postgres is shutting down. I am seeing the below errors in logs [19043] LOG: listening on IPv4 address "127.0.0.1", port 5432 [19043] LOG: ...
3
votes
3answers
2k 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 ...
3
votes
2answers
1k views

Redirecting MySQL errors and slow logs into another database

I am running a number of MySQL servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into an external database. ...
3
votes
2answers
2k views

SQL Server 2008r2 won't start after windows updates, error log & wmi provider errors

I have a SQL Server 2008 R2 instance on a Windows 2008 R2 box, and windows has not been updated for almost a year (I know), last night windows patches were applied (around a 100 that were pending), ...
3
votes
1answer
8k views

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

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 reset for ...
3
votes
0answers
233 views

Any way to catch when xp_readerrorlog fails? [duplicate]

I'm trying to query the ErrorLog files, but it sometimes fails on some of my servers. For some reason a file go missing from time to time. I do not know why. I do not think that I deleted the file :-)....
3
votes
1answer
6k 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
196 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 ...
2
votes
1answer
2k views

Find out date and or number of error logs xp_readerrorlog

I have some code to help automate checking the error logs daily on our SQL Server. This code calls xp_readerrorlog 0 to check the error log, and xp_readerrorlog 0,1 to check the SQL Server log. ...
2
votes
2answers
12k 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.
2
votes
1answer
350 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 ...
2
votes
2answers
84 views

Login failed errors while DB refresh in progress

We have a 2.5TB refresh in Production, I have automated the refresh of latest production backup to lower environment every Sunday night. And during this activity, SQL error log is filled with ...
2
votes
1answer
99 views

Log report 'bad password', but still grants access

Original symptom: User sa locked out, too many bad attempts. Problem was sudden (no issues before), and pervasive (couple of fails in one day). As this was a new roll out of SQL backend to Sage300, ...
2
votes
1answer
3k 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()), ...
2
votes
1answer
1k 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 'G:\SQL_DATA1\MSSQL10_50....
2
votes
1answer
17k 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 ...
2
votes
1answer
287 views

SQL Server 2019: InitPersistentVersionStore failed after installing CU2

I have installed SQL Server 2019 CU 2 over a vanilla install of SQL Server 2019 RTM. Now I am puzzled by the following messages in the error log at startup: RecoveryUnit::...
2
votes
2answers
2k views

DAC connection error

I'm having a problem connecting using my dedicated admin connection in SQL Server 2014. I just wanted to test it out. I have DAC enabled in sp_configure. I have performed RECONFIGURE. I have ...
2
votes
0answers
384 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 ...
2
votes
0answers
120 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 ...
1
vote
2answers
626 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 ...
1
vote
1answer
65 views

Is “deadlock detected” really an error? Should I be suppressing them after handling them?

A while ago, I spent a nightmarish number of weeks dealing with "deadlock detected" and trying to figure out how to handle it. I ended up finally handling it in such a manner that my code is ...
1
vote
2answers
210 views

SQL Server ERRORLOG way too big

Im running SQL server 2014 on a VPS with 150Gb ssd. Today i found that my hard disk was full 100% and there's a very large file from SQL Server Error log that was 45.7Gb. I tried manually delete the ...
1
vote
2answers
141 views

SQL Server Error Log - Is It / Can It Be Encrypted?

Is it possible for the SQL Server Error Logs to be encrypted? Our SQL Server recently had a memory dump which it threw into the Error Log. While the dump was definitely useful to identify the issue,...
1
vote
1answer
692 views

Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck

oracle not install on centos7 while installation it is stuck at 84% no error msg showing
1
vote
1answer
320 views

Database often becomes unavailable and Mysql has error log

The service is a droplet in DO with Ubuntu 16.04 and apache2 MySql database often becomes unavailable in this server. here is the log from /etc/log/mysql/error.log 2018-08-19T18:39:41.534354Z 0 [...
1
vote
1answer
355 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
4k views

How do you filter SQL error logs to display specific error messages? [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
1answer
2k 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 ...
1
vote
0answers
197 views

SQL Server 2019 and Transparent Data Encryption - Intermittent (silent) Error Log Messages

I recently migrated a SQL Server 2017 TDE database to SQL Server 2019 CU4. I was browsing the Error Log and noticed intermittent messages about An error occurred while processing log encryption. The ...
1
vote
0answers
100 views

Why is failed job not logged in SQL Server Agent Error Log?

I have a failed job which is logged in SQL Server Logs but not logged in SQL Server Agent Error Logs. The job is executed as user: NT SERVICE\SQLSERVERAGENT. Limit size of job history and Remove agent ...