Questions tagged [error-log]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
2answers
71 views

which log files can be deleted in sql server

My hard drive is filling up. Is it safe to delete SQL Server dump files and error log files? It looks like files in multiple folders can be deleted. Following are the paths where the log and dump ...
0
votes
3answers
58 views

How to set email alerts for high IO errors (sql server error log)?

The sql server error logs show multiple entries with the following keywords: IO taking longer longer 15 seconds I want to setup email alerts for these errors. I have email alerts configured for ...
-1
votes
1answer
13 views

Error log "[Warning] InnoDB: innodb_open_files=10 is exceeded (10) files stay open)"

I just created a new Digital Ocean VPS, and when looking at my log file it gives me this warning. I'm running a wordpress site. Any ideas what this is? Do I need to increase this, and by how much?
0
votes
0answers
17 views

rotate error log file of MySQL 8.0 server over windows

we have MySQL 8.0 installed over windows and my err log file (.err) is very large (11 GB), so we need to rotate the error loge so it writes to a new file when the current file is 200 MB we tried to ...
0
votes
0answers
21 views

Detail about communication packets error log

On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day: 2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading communication packets My question is ...
0
votes
0answers
317 views

InfluxDB on Raspberry Pi 3 and load issues

first of all, I'm not an database expert at all, but I managed to set up a system fitting my monitoring needs for more than one year now. Unfortunately, now the problem arises. Short summary of my ...
0
votes
1answer
79 views

Index Reorganize fails

I am using the default SQL Server Maintenance task to reorganize index only which was running until I got the below error. Executing the query "ALTER INDEX [PK_abc] ON " failed with the ...
1
vote
1answer
284 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 ...
0
votes
1answer
26 views

How do I make PostgreSQL log the file path and line number of the errors? (If it's even possible at all.)

My postgresql.conf contains this: log_destination = 'csvlog' logging_collector = on log_directory = 'C:\\Users\\John Doe\\Documents\\PostgreSQL logs' log_filename = 'PG_%Y-%m-%d_%H;%M;%S' ...
0
votes
1answer
39 views

MySQL 8.0.20 - Master Replica scheme, errors during replication process

This threads follows a previous one, given at this URL: MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica Replica Server has been configured this way, which ensures a ...
0
votes
1answer
164 views

Always On Instance Service Broker/Database Mirroring transport connection endpoint Error

I have a production instance that has 2 AOG. There is no mirroring configured for both groups. Both groups are also in 'Healthy' state. Upon checking the error log on SQL Server, I noticed that ...
0
votes
1answer
39 views

How to find description of error in error log? [closed]

We have errors like these in our MySQL error log: [ERROR] [MY-010211] [Server] Got error 203 when reading table 'xxx' But I can't find anything about either MY-010211 nor error 203 in the ...
0
votes
1answer
34 views

SQL Server 2019: Rasing errors between 1 and 13000

I've been struggling with a task which requires me to raise a number of errors for testing purposes. Of course the time consuming errors are between 1 and 13000. I've managed to do them, but I need to ...
-1
votes
1answer
36 views

How do I log the actual script's name in csvlog? [duplicate]

I have PostgreSQL CSV-log its errors according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG Sadly, from what I can tell, it neither ...
-1
votes
2answers
63 views

How do I make PostgreSQL not log specific errors?

ERROR: deadlock detected at character 13 My PG log is full of this, but the thing is, I already handle it (after years of frustrations) in my application. I detect them and repeat until they go ...
-2
votes
1answer
200 views

What should I do about PostgreSQL logging so much "weird noise" in its own log?

PostgreSQL 12.4 on Windows 10 Pro 2004. With the default configuration file, I start PostgreSQL with pg_ctl and the "-l PostgreSQL.txt" option. It logs to that file. Looking in it, I'm ...
1
vote
0answers
335 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
2answers
399 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 ...
0
votes
1answer
390 views

MySQL Error Code 3019 (Undo Error Log, no space left)

I'm trying to remove some data to get some extra free space, but running the "DELETE FROM table ..." query gives me this error: Error Code: 3019 Undo Log error: No more space left over in ...
0
votes
1answer
25 views

Mysql falls every day

My database Mysql fallas every day: Looking at the tail -100 /var/log/mysqld.log Shows: 2020-08-16 20:56:03 7f787c7fb700 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table. ...
0
votes
1answer
84 views

Why am i getting "missing right parenthesis" error when i try to LOG ERRORS when loading from an external table?

I've successfully created an error logging table BEGIN DBMS_ERRLOG.create_error_log( dml_table_name => 'enzyme', skip_unsupported => TRUE); END; / desc ERR$_ENZYME; Name ...
0
votes
1answer
30 views

How query errors affect Postgresql DB performance

I have an application stored measurements data in PostgreSQL-12. Couple of processes write data by queries like: INSERT INTO "<measurement>" (<columns>) VALUES (<values>); But for ...
2
votes
1answer
372 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::...
0
votes
1answer
244 views

SQL Server Audit Clutters Error log

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour): Audit: Server Audit: 65976, Initialized and Assigned State: STARTED Audit: ...
5
votes
1answer
12k 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 ...
1
vote
0answers
127 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 ...
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 (...
2
votes
2answers
104 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 ...
0
votes
0answers
61 views

SharePoint changing statistics options daily

SharePoint switches OFF and ON options like AUTO_UPDATE_STATISTICS, AUTO_UPDATE_STATISTICS_ASYNC, AUTO_CREATE_STATISTICS, INCREMENTAL on SharePoint databases daily at 12 AM and that generates lots of ...
2
votes
1answer
101 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, ...
0
votes
0answers
174 views

Ola Hallengren - Parallel Backup Jobs failing on SINGLE_USER DB - 'Database is in transition' [952]

I'm using Ola's DatabasesInParallel option for "multi-threaded" execution. Last night a db was temporarily placed into SINGLE_USER for an application-based archive process and it caused all 5 threads ...
2
votes
0answers
904 views

mysql 8 is failure to start after upgrade from 5.7

I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8. But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
1
vote
1answer
768 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
5
votes
1answer
464 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 ...
1
vote
2answers
163 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,...
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 ...
-1
votes
1answer
334 views

SQL Error Log, how big is too big? [closed]

There are various methods you can use to control SQL error logs files. Related SQL Server : log folder too large While there is never a one size fits all solution in for anything in SQL, After ...
1
vote
1answer
77 views

How to index of filter extended event files in Sql Server

I am collecting errors data using the error_reported event and saving the data on XEL files. The problem is that there are hundreds of thousands of errors over there and querying them can take a lot ...
1
vote
0answers
81 views

How to check the errorlog for important messages

I would like to receive an email every day from each of "my" SQL Servers, with information from the ErrorLog. I would like an easy way to determine if there is any important new information, that I ...
0
votes
1answer
2k views

MySQL ZERO warnings

I'm getting the error below in my MySQL log file. [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with ...
1
vote
1answer
332 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 [...
0
votes
1answer
1k views

length of the result exceeds the > length limit (2GB) of the target large type

Getting the following error message on the Sql Server Error Log: SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (...
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), ...
-1
votes
1answer
128 views

C drive full sql error log huge [closed]

I read a recommendation for setting up a job to run EXEC sp_cycle_errorlog to recycle the SQL Server error log, so that it stops getting so large. Do I need to set up this job for all of the ...
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: ...
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. ...
5
votes
5answers
27k 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
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 ...
3
votes
0answers
238 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 :-)....
0
votes
2answers
2k views

MySQL 5.1.73 change default log location

How do you change the default location of the log_error file? If you point it to a new path, will it automatically move the existing file? Or will it create a new file, and the original file can be ...