Questions tagged [shutdown]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

Troubleshooting why MySQL forcefully shut down

Apologies if this is not the right place to ask this. As of a few days ago my MySQL instance has started shutting down automatically. In the MySQL logs it looks like a graceful shutdown, which makes ...
  • 101
0 votes
1 answer
177 views

mysqld Shutdown every 1 hours

Please help me solve a problem which initiates a mysql shutdown every hour. Naturally the site on the server can't connect to the database and I get a bunch of errors in the site's logs. config: ...
1 vote
0 answers
354 views

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

I've installed PostgreSQL under Ubuntu 20.4 using the PGDG apt repository. Each time I stop the DB server, e.g., with sudo service postgresql stop, the log says 'received fast shutdown request', but I'...
  • 121
0 votes
1 answer
215 views

My SQL server cannot start after a sudden shutdown

Today I found that I could not connect to my SQL server. It was working well yesterday until my computer shut down suddenly. Here is text information. 在 System.Data.SqlClient....
0 votes
2 answers
514 views

Identify what is shutting down MySQL Server

It has been few weeks that MySQL shuts downs "by himself", and I'm not able to identify why. Maybe one of you could help me. Here is the error logs. They're always the same. MySQL seem to be ...
1 vote
0 answers
227 views

Postgres stops about every 2-3 weeks. Says it was shutdown by an admin but I'm the only admin

Postgresql 12.8 on Ubuntu 20.04.1 This system is running a single java application that talks to the database. Only one user can log into the system (expedite) and only that user runs anything. No ...
  • 11
-1 votes
1 answer
31 views

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

If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it will initialize recovery process. What about SQL Server? Does it behave in the same way?...
  • 1,203
0 votes
0 answers
826 views

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

I have read many different questions about slow MariaDB/MySQL shutdown, but I have not found an answer which solves my problem yet. On one of our servers with the highest load, when I issue a stop ...
1 vote
2 answers
688 views

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

My MySQL keep shutdown automatically with this error report: 200405 23:31:39 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in ...
0 votes
1 answer
2k views

Know when MySQL server was slow shutdown? [closed]

I use MySQL 8.0. How I can know when MySQL server was slow shutdown? I start mysql server /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --user=mysql I shutdown mysql server /...
0 votes
1 answer
97 views

Audit OSQL command shutting down a SQL Server

I need to determine when, and by whom, a SQL Server was shutdown using the osql command. The osql command takes user name and password input. Are there any specific Windows Event logs generated to ...
5 votes
2 answers
9k views

Error: MySQL shutdown unexpectedly

Here is the screenshot of my XAMPP Control panel: Here is my Error Log : 2019-11-27 7:54:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-11-27 7:54:14 0 [Note] ...
0 votes
1 answer
56 views

mongodb 2.4.1 instance shutdown without log

I am running mongodb in a replica set of 3 nodes (no sharding). But since 5 days the secondary instance shuts down intermittently, once in 2 days. Log does not indicate any event related to shutdown, ...
1 vote
1 answer
1k views

XAMPP - Error: MySQL shutdown unexpectedly

Last night MySQL Service on my XAMPP local server was running fine. Today... it starts for 10 seconds and then give me following error: 10:14:28 AM [main] Initializing Modules 10:14:28 AM [main]...
  • 111
1 vote
0 answers
296 views

How to recover from a segmentation fault

Postgresql 11 running on a Centros RHEL 7. Suddenly BD crashed and service went down. service postgresql-11.service status Redirecting to /bin/systemctl status postgresql-11.service Segmentation ...
  • 775
0 votes
1 answer
1k views

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

I am using MS SQL Server 2014, When I restart my Pc the SQL Server Service does not start automatically, however, it does after Windows Shutdown and run again, how can I make it restart automatically ?...
1 vote
0 answers
853 views

Postgres service restart in a Master - Replica

Postgres 10 database running on a Centos RHEL 7. This Database is a Master and it has 1 stand_by replica acting as a mirror. Well my intention was to change the wal_level in the configuration from ...
  • 775
2 votes
1 answer
6k views

How to shutdown postgres through psql?

The recommended way to shutdown postgres is to send a signal representing the different shutdown modes (fast, smart, immediate) or using init managers (initd, systemd, etc.) or their equivalent on non-...
0 votes
2 answers
433 views

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

I'm working on automating as much as possible the mechanics of resizing an EBS volume on which we store all databases. We're going to host a large number of large-but-infrequently-used databases on a ...
1 vote
1 answer
131 views

How do we identify service shutdown time in MySQL

How can we identify service shutdown time in MySQL community version 5.7.20. I presume that "statement/sql/shutdown" and "statement/com/Shutdown" are the events that occurs while shutdown a service, ...
0 votes
2 answers
3k views

Getting MySQL start and shutdown time

How to write a trigger that updates a table before startup and shutdown of the database in MySQL 5.7 ? Any suggestions that could be helpful to us?
0 votes
1 answer
59 views

MySQL customized service script for zip installation

We are currently using MySQL 5.7.20 on CentOS and are using zip installation. Since it is a zip installation we do not have service created in /etc/init.d/. Is there any other method for auto-...
  • 1,400
1 vote
0 answers
685 views

MySQL shutting down automatically

I have a LEMP server in a Ubuntu instance and my MySQL are shutting down automatically... I have no idea what's happening. I had to manually restart it to keep the site online Here is my mysql log ...
2 votes
0 answers
610 views

How to properly shutdown Windows while MongoDB is running

I am using Mongodb version 3.2.6 as my application database. MongoDB is installed as a SYSTEM service in Windows and my application runs in Kiosk mode. When shutting the system down by performing a ...
3 votes
1 answer
14k views

How to unmount oracle database?

According to the oracle docs, during shutdown, 3 steps are performed: Close the database. Unmount the database. Shut down the instance. Is it possible to make only first 2 steps?
user avatar
4 votes
1 answer
15k views

DB Restart Taking too long, site is down

I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing. What can I do? I can still access the server via SSH but I cannot connect to ...
  • 145
9 votes
4 answers
4k views

What reasons are there to stop the SQL Server?

All I've read about is how potentially damaging it is to stop SQL Server because it creates a cold cache and sucks up memory. So why would someone want to stop the SQL Server? If you can provide any ...
  • 193
1 vote
1 answer
807 views

How does Oracle close and unmount a database?

I was reading the Oracle 12c concepts manual. Then I realised that something is not "technically" explained. Below is an excerpt of paragraph 13.2.2.2: When a database is closed as part of a ...
  • 335
1 vote
1 answer
781 views

Service mysql shutdown

The mysql service was stopped and in mysql log I saw these warning: 161125 16:41:10 [Warning] IP address 'x.x.x.x' has been resolved to the host name 'x.x.x.x.xxx.xxxxxx.com', which resembles IPv4-...
4 votes
1 answer
812 views

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

I had memory issues with using 32bit Xampp so I have installed 64bit components myself as a new server. Although, I want to make sure I am stopping the MySQL database server properly. Is this a ...
1 vote
0 answers
611 views

MySQL replication just hangs, then Database wont shutdown

I have recently set up some new MySQL Databases on a remote site. They are all 5.5.47, running on Debian Servers. They are set up as one Master with multiple slaves. The Master is itself a slave from ...
  • 1,994
2 votes
2 answers
13k views

How can I stop Oracle Shutdown command?

I used Shutdown normal, instead of Shutdown immediate. Now I want to stop the process, because its taking too long. How can I do it?
3 votes
1 answer
3k views

Oracle crashing on CentOS

Here is alert_XE.log: kkjcre1p: unable to spawn jobq slave process Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc: Process J000 died, see its trace file kkjcre1p: unable to ...
  • 158
3 votes
1 answer
5k views

Unable to shut down MySQL server

I have tried using the system preferences and then shutting down MySQL there, but to no avail. I also tried typing killall -9 and -11. Both failed :(. I also tried /usr/local/mysql/bin/mysqladmin -u ...
2 votes
2 answers
2k views

MySQL server cannot be stopped

I am using Ubuntu release 14.04, MySQL 14.14 Distrib 5.5.43. To reset the MySQL root password, as described in the official MySQL doc How to reset the root password, I need to stop the MySQL server. ...
1 vote
1 answer
401 views

MySQL database got corrupted

It seems that whenever I restart my Windows 7 64bit box MySQL gets corrupted. I just wanted to make this bug known as it's a serious issue. Are there any special settings I need to setup (task ...
0 votes
1 answer
192 views

Cannot shutdown a shutdown connection MySQL Enterprise Monitor

We are facing below errors on MySQL Enterprise Monitor.. While deleting a connection from MySQL Instances it is displaying following error messages. Also it is not deleted event it displays success ...
  • 1,400
1 vote
1 answer
3k views

MySQL Shutdown on Windows

Folks, I am running MySQL on Windows8 for my personal (casual) use. I am trying to determine if there is a way to automatically and cleanly shutdown MySQL whenever I shutdown my Windows8 computer. ...
1 vote
0 answers
298 views

Can MySql cause a Windows server to shutdown unexpectedly?

For the 3rd time, my server where my MySQL instance is running simply shutdown unexpectedly, this time, causing my tables to be corrupt as I had ALTER statements running. While in contact with my ...
1 vote
1 answer
841 views

MySQL/Percona Server is taking long and I'd prefer to skip all this waiting even if it means data loss

Originally posted to https://www.facebook.com/groups/GNUAndLinux/permalink/10155020539805019/ but no replies received. I run Percona Server 5.6.21-70.0-688 x64 on Ubuntu Server 12.04 LTS x64, 64GB ...
2 votes
1 answer
573 views

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database ...
1 vote
4 answers
6k views

How to Identify the user who issued MySQL Shutdown command

We have had several situations when our production MySQL server suddenly became unavailable. The error log just shows "Normal shutdown" followed by the typical shutdown messages. How can I determine ...
  • 11
1 vote
1 answer
826 views

Oracle: force shutdown as root without knowing logins

I am root on a GNU/Linux machine with Oracle 10.2.0.1.0 XE installed. I need to shut down Oracle, but I do not have admin logins to Oracle. How do I as root force Oracle to shutdown? I have a normal ...
  • 113
30 votes
4 answers
76k views

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

Are there any special steps necessary to prevent data corruption when restarting a server hosting an MS SQL Server instance? For example, I recently encountered the recommendation of stopping the SQL ...
9 votes
3 answers
62k views

How to quickly startup/shutdown Oracle 11?

I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine). I need it for C/C++ programs that use the OCI/Pro*C API. I want ...
8 votes
1 answer
1k views

Start/Stop MySQL

I'm seeking help to understand what happens when the following command line is executed: root@prodn$ service mysqld stop Yes, it shuts down the MySQL server so access to it is no longer available ...
  • 183
5 votes
5 answers
19k views

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

One of my databases has been shutting down abnormally, but the log said "normal": 130422 13:23:01 [Note] /usr/libexec/mysqld: Normal shutdown 130422 13:23:01 [Note] Event Scheduler: Killing the ...
  • 996
33 votes
5 answers
97k views

How to properly kill MySQL?

I have CentOS 64bit with CPanel installed and I use: service mysql stop It just keeps ticking periods and never seems like it stops. In the logs it just posts a lot of: 130303 17:42:38 [Warning] /...
user avatar
0 votes
0 answers
64 views

How to properly kill MySQL? [duplicate]

I have CentOS 64bit with CPanel installed and I use service mysql stop However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
2 votes
3 answers
9k views

Instance Startup Modes & Shutdown Modes

So, I know that there are 3 modes of startup modes available for the instance which is NOMOUNT, MOUNT, and OPEN. What I want to know is in NOMOUNT mode it is stated that the instance started but still ...