Skip to main content
22 votes
Accepted

What reasons are there to stop the SQL Server?

Brent listed some invalid reasons for stopping the service, but there are valid reasons too: Restart required by a service pack or other update Certain configuration changes (e.g. service account ...
Aaron Bertrand's user avatar
20 votes

What reasons are there to stop the SQL Server?

Because they think there's a memory problem - SQL Server uses all of the memory available to it, up to its max memory setting (and even beyond.) Unknowing folks go into Task Manager, see SQL Server ...
Brent Ozar's user avatar
14 votes

Error: MySQL shutdown unexpectedly

I came across similar problem and tried this Stack Overflow answer by Fabrizio Valencia. It worked. Stop there! Please do not delete anything! First try to do what I did. OK, none of the listed ...
User_beginner's user avatar
6 votes
Accepted

How to unmount oracle database?

Yes, it's possible. SQL> alter database close; Database altered. SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED SQL> alter database dismount; Database ...
atokpas's user avatar
  • 8,642
6 votes

What steps are necessary to safely restart a machine hosting Microsoft SQL Server?

This is all detailed exhaustively on this page. Start, Stop, Pause, Resume, Restart SQL Server Services Being that your question specifically asks "are there any recommended by Microsoft" I'm ...
Evan Carroll's user avatar
  • 63.7k
5 votes

How to shutdown postgres through psql?

The documentation tells you to send a signal to the master postgres process, or to let pg_ctl do this. In SQL, you can extract the PID of the master process from pg_read_file('postmaster.pid'), but ...
CL.'s user avatar
  • 5,243
4 votes
Accepted

DB Restart Taking too long, site is down

Without seeing any additional information, here is my best guess why MySQL is trying to shutdown for a long time: I suspect mysqld no longer has a socket file. About 1.5 years ago, I answered mysql ...
RolandoMySQLDBA's user avatar
3 votes
Accepted

MySQL customized service script for zip installation

SHUTDOWN MySQL 5.7 now features the SHUTDOWN command, which requiresthe SHUTDOWN privilege. SHUTDOWN METHOD #1: Within mysql client mysql> SHUTDOWN; SHUTDOWN METHOD #2: From OS using mysql ...
RolandoMySQLDBA's user avatar
3 votes

SQL Server service start automatically only after Windows Shutdown, how can I make restart automatically without batch file?

You can set the service property to restart it (service properties --> recovery --> first / second / third failure and have a delay between each restarts e.g. 1 min). You should also, have the service ...
Kin Shah's user avatar
  • 62.3k
3 votes
Accepted

How does Oracle close and unmount a database?

It helps to understand what 'mount mode' means: Before DB is mounted, instance is up (SGA and other memory structures are allocated but DB and its files etc have not been verified yet. In mount mode, ...
Raj's user avatar
  • 912
3 votes
Accepted

Is this way of MySQL shutdown via bat file sufficient to minimise corruption?

If you want to shutdown MySQL effectively, you need to run several things @echo off rem rem Flush Everything and its Grandmother rem echo "Stopping MySQL Service" "C:\host\MariaDB\bin\...
RolandoMySQLDBA's user avatar
3 votes
Accepted

How can I stop Oracle Shutdown command?

It seems like the obvious answer is that you can't stop a shutdown that is happening, but you can do either a shutdown immediate or shutdown abort from a different session if you did a shutdown normal....
Gandolf989's user avatar
  • 1,520
2 votes
Accepted

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

I'm pretty sure the recovery process is done on each database everytime the instance start. (and in other scenario as well, like an AG failover for example) If it was stopped in a clean way, there ...
Dominique Boucher's user avatar
2 votes

My SQL server cannot start after a sudden shutdown

The error message says a system database, model has it's log file broken: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x83635096; actual: 0x83634816). It ...
vonPryz's user avatar
  • 3,081
2 votes
Accepted

Does the order in which vms are shutdown impact the postgresql replication environment?

You can shutdown and restart primary and standby in any order you want; that won't cause a problem. However, you could get into trouble if you keep the standby server down while data modifications ...
Laurenz Albe's user avatar
  • 53.5k
1 vote

Does Docker stop take of care of stopping gossip and drain?

When stopping a container with the docker stop command, Docker sends a TERM signal to the main process in the container then after a grace period (usually 30 seconds), a KILL signal. This sends an ...
Erick Ramirez's user avatar
1 vote
Accepted

Proper *smart* shutdown of PostgreSQL server for PGDG apt packages under Ubuntu/Debian?

In Debian / Ubuntu systems you need to add the option --skip-systemctl-redirect to the pg_ctlcluster command. Otherwise, the call to postgres will go through systemd, which can not handle shutdown ...
Stanislav's user avatar
1 vote

Identify what is shutting down MySQL Server

in the answer below there is a bash statement with a bunch of symbols... that's a pipe bomb, it is literally designed to make a server crash. do not ever run that command on a Linux box!
Terrence Ward's user avatar
1 vote

MariaDB 10.1 shutdown stuck at "Event Scheduler: Purging the queue"

MySQL also have the same problem. I encountered the same problem in MySQl5.7.19. When shutdown a mysql server, it stuck at "Event Scheduler: Purging the queue. 0 events". In MySQL5.7.25 ...
Peanut's user avatar
  • 11
1 vote
Accepted

MySQL keeps shutting down: /usr/sbin/mysqld: unknown variable 'set-variable=key_buffer_size=32M'

in the Module Configuration for mysql you find the path to my.cnf Edit this file and remove the line with key_buffer_size=32M and save it. And then start the server. Webmin information on mysql
nbk's user avatar
  • 8,434
1 vote

Know when MySQL server was slow shutdown?

Priviet Юрий You question puzzled me a bit first. The answer to your question was too easy and this is dangerous... About time - was, is and will be How can I find out if the database "was" ...
shinguz's user avatar
  • 59
1 vote

Audit OSQL command shutting down a SQL Server

As mentioned by Dan Guzman if you are using the T-SQL SHUTDOWN command to shut down SQL Server, you see see the details with username in two places: SQL Server Error Log Date 3/15/2020 7:44:...
SqlWorldWide's user avatar
  • 13.5k
1 vote

How to allow in-progress transactions to complete when shutting down PostgreSQL?

I don't know of a way to do this automatically. You could start a smart shutdown, and then loop through live connections terminating them if they are idle. This would be a bit fragile, as if your ...
jjanes's user avatar
  • 40.2k
1 vote

Getting MySQL start and shutdown time

STARTUP TIME For everyone running MySQL 5.7 SELECT NOW() - INTERVAL variable_value SECOND MySQL_Started FROM performance_schema.global_status WHERE variable_name='Uptime'; For anyone running MySQL ...
RolandoMySQLDBA's user avatar
1 vote

/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that?

Just to add one more possible reason: in my case it was the unattended-upgrades (on Ubuntu) who did the restart of mysql.
Silvan's user avatar
  • 11
1 vote

What reasons are there to stop the SQL Server?

One reason could be is that you bought new hardware and migrated the databases to this new server. You now are shutting down this sql server instance on the old box (together with the box itself) ...
SQLMenace's user avatar
  • 289
1 vote

What reasons are there to stop the SQL Server?

A valid reason is when there is other software running on the same server that needs some of the memory SQL server has, but that only runs a few times a month. For example my wife (an accountant ...
Ian Ringrose's user avatar

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