Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
31 votes
Accepted

Can SQL Server's crash resilience be improved?

I am aware that SQL Server is not designed for such scenarios and the correct solution is to fix the cause of the power loss […] Actually it's designed to deal with power loss, that's why there are ...
Sean Gallardy's user avatar
30 votes

Can SQL Server's crash resilience be improved?

If the tablet has a working battery, you can configure Windows to shut down when the battery power is low. If the tablet has a non-working battery, consider replacing the battery. (I've had laptops ...
Brent Ozar's user avatar
13 votes
Accepted

Mysql Workbench crashing when connecting

Looks like a known issue with it not handling an exception error properly and also the wrong version: https://bugs.mysql.com/bug.php?id=79364 Description: WB 6.3.5 (and also older release like 6.1.7) ...
Ali Razeghi - AWS's user avatar
12 votes
Accepted

Won't start: InnoDB: Corrupted page ... Tablespace was not found

https://dev.mysql.com/doc/refman/5.7/en/repair-table.html says: REPAIR TABLE works for MyISAM, ARCHIVE, and CSV tables. In other words, REPAIR TABLE does nothing for InnoDB. InnoDB has its own ...
Bill Karwin's user avatar
6 votes

Can SQL Server's crash resilience be improved?

Assuming you have a local DB on the forklift rather than a server because of spotty wireless connections? Obviously getting SQL off the forklift would be the preferable solution. Anyway, like Brent ...
Marbry Hardin's user avatar
6 votes
Accepted

PostgreSQL crash due to lack of device space

You cannot know which directory belongs to which database without a look at pg_database or the file for that table (probably /var/lib/pgsql/11/data/global/1262). But you cannot start deleting files or ...
Laurenz Albe's user avatar
  • 52.7k
5 votes

MySQL Crashed - InnoDB

As per your log it shows you have corruption in the InnoDB tablespace. InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-...
Md Haidar Ali Khan's user avatar
5 votes
Accepted

SSMS crashes when attempting to create a database diagram

I've found that the database diagram tool seems to crash if you modify things outside of the diagram. Diagrams appear to remain stable if: The database diagram tool is used to do all of your ...
Paul's user avatar
  • 188
4 votes
Accepted

MySql: Frequent crashes on server with substantial resources

Shutdown the server and tried to move the VM to another drive but it fails with File Error. My latest suspicion is this is being caused by a bad block but running badblocks seemed to trigger a ...
Blag's user avatar
  • 379
3 votes

Mysql Workbench crashing when connecting

If you try to connect directly, it will crash. Below is the solution. Solution: Go to Database -> Manage Connections New -> Enter the connection details Click test connection. It will show a ...
Shadi Alnamrouti's user avatar
3 votes
Accepted

Passing NULL xml value to a certain CLR stored function crashes it when called in a certain way

Overall, no, you did not do anything wrong with your .NET code. There is a minor technical issue, but we will get to that in a moment. I was able to reproduce this (both error and non-error scenarios)...
Solomon Rutzky's user avatar
3 votes

Worker threads issue: How to read this crash dump, and what to do about it?

Community Wiki answer generated from comments on this and the previous question. sp_BlitzErik: Threadpool waits can happen for reasons other than just long running queries. Number of connections, ...
3 votes
Accepted

Database keeps crashing every few hours

That's... The issue wasn't caused by MariaDB it was caused by a python script running on my server that was having memory leaks. Once the memory was completely filled, system decided to kill mysqld ...
lyeaf's user avatar
  • 177
3 votes
Accepted

What will happen when SQL Server log drive is full?

Why it needs to recover in this case? There was an issue undoing a transaction, this leaves the database in an inconsistent state, in fact the database should move to suspect. You can see from the ...
Sean Gallardy's user avatar
2 votes

ERROR 1091 (42000): Can't DROP 'PRIMARY'; on "mysql_upgrade"

I finally figured it out. The main reason for the crashes and the mysql_upgrade error was related to missing and/or corrupted primary keys of the mysql table. There were also a couple missing records ...
hexalys's user avatar
  • 131
2 votes

MySQL crash/restart during mysqldump

It was OOM. The first thing I was suspect was memory. But: VM's dmesg didn't output any messages until I reboot container. Only after that I saw messages, like [0.000000] Out of memory in UB 101: ...
Someone's user avatar
  • 223
2 votes

How to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)

First of all there is a documented bug that has seen the recovery performance of 5.7 degrade, this is discussed here https://bugs.mysql.com/bug.php?id=80788 which seems to have been fixed in 5.7.19 ...
greenweeds's user avatar
2 votes

MongoDB crashes with out-of-memory or is being killed by oom-killer

It turned out that we had a long running daily query and chunks that were moved were still retained in memory as were used by the cursor of the query. In this way with every chunk moved memory with ...
ssasa's user avatar
  • 241
2 votes

Can SQL Server's crash resilience be improved?

The underlying os has to guarantee either a successful write or an error is returned. The os in turn relies on drivers which in turn rely on firmware which relies on the hardware If either the ...
David Williams's user avatar
2 votes
Accepted

postgres cluster: Crash of master crashes the replicas too

This is harmless. That message is sent by the server to the client when a process has crashed and the backend is about to die (quickdie in postgres.c) so that crash recovery can begin. You are only ...
Laurenz Albe's user avatar
  • 52.7k
2 votes

When a thread/process crashes on acquired DB locks, how does DB detects that and releases the lock?

Think of it this way. All the changes in a transaction have a trx_id associated with them. Until there is a COMMIT, any inserts/updates/etc are "pending". After some form of crash, the un-...
Rick James's user avatar
  • 78.3k
2 votes
Accepted

Azure Database for MySQL - Memory keeps increasing then crashes

The quick fix is to lower innodb_buffer_pool_size to, say, 7G. But with 20G of RAM, you should not be running out of RAM. Do you have other applications on the same server? And they are the ones ...
Rick James's user avatar
  • 78.3k
2 votes

After server is restarted, the database and the backups are destroyed by the system crash. What ACID properties are broken in this situation?

After the server is restarted, the database and the backups were destroyed by the crash and the database does no longer exists. If a server failure has destroyed both the database and its backups, ...
Phill  W.'s user avatar
  • 8,795
2 votes

After server is restarted, the database and the backups are destroyed by the system crash. What ACID properties are broken in this situation?

It wouldn't break any ACID properties regarding the single database, because neither the database nor the backups exist after the incident. ACID are are a set of properties regarding transactions: In ...
John K. N.'s user avatar
  • 17.9k
2 votes

Database keeps crashing every few hours

so that's minimum 2000 connections That's probably the problem. 2700 single-row INSERTs per second? Is it "bursty"? Or reasonably steady? How many "clients" are there really? ...
Rick James's user avatar
  • 78.3k
2 votes
Accepted

AlwaysOn proc doesn't stop, but it can't be telnet。SqlDumpExceptionHandler: Process {0} g fatal exception c0000094 EXCEPTION_INT_DIVIDE_BY_ZERO

The error message, EXCEPTION_INT_DIVIDE_BY_ZERO suggests there is a bug in the SQL Server's application code. These aren't usually user-fixable, though sometimes there are work-arounds. Since the ...
vonPryz's user avatar
  • 3,081
1 vote

Can SQL Server's crash resilience be improved?

To expand on the other answers: First, try getting the SQL off the forklift if at all possible. Think recovering from a power loss is bad, try doing it after the laptop got ran over by 7,000+ lbs. ...
GB540's user avatar
  • 111
1 vote

Mysql Workbench crashing when connecting

MySQL Workbench may crash when connecting to databases due to a corrupted User Snippets file. The file may be corrupted if you edit it outside of Workbench. Deleting the snippet file will force MySQL ...
unknownrisk's user avatar
1 vote

Effect of over allocating shared_buffers

Would over-allocating shared_buffers explain the stability problems? E.g., PostgreSQL tries to allocate more buffer than the OS has left, the OS says "nope" and things go south from there. When the ...
Evan Carroll's user avatar
  • 63.4k
1 vote
Accepted

MySQL memory usage slowly increasing then crash - what's causing this?

What else is running on the machine? There seem to be 2 or 3 jumps in memory usage. MySQL (usually) has one jump or gradual rise. Nothing looks wrong in my.cnf. But change innodb_buffer_pool_size ...
Rick James's user avatar
  • 78.3k

Only top scored, non community-wiki answers of a minimum length are eligible