2022 Developer Survey is open! Take survey.

Questions tagged [shutdown]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
43 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: ...
user avatar
1 vote
0 answers
71 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'...
user avatar
  • 121
0 votes
1 answer
65 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....
user avatar
0 votes
1 answer
165 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 ...
user avatar
1 vote
0 answers
112 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 ...
user avatar
  • 11
-1 votes
1 answer
30 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?...
user avatar
  • 1,163
0 votes
0 answers
628 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 ...
user avatar
1 vote
1 answer
429 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 ...
user avatar
0 votes
1 answer
1k 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 /...
user avatar
0 votes
1 answer
81 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 ...
user avatar
4 votes
2 answers
6k 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] ...
user avatar
0 votes
1 answer
41 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, ...
user avatar
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]...
user avatar
  • 111
1 vote
0 answers
198 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 ...
user avatar
  • 767
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 ?...
user avatar
1 vote
0 answers
676 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 ...
user avatar
  • 767
2 votes
1 answer
5k 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-...
user avatar
0 votes
2 answers
234 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 ...
user avatar
1 vote
1 answer
127 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, ...
user avatar
0 votes
2 answers
2k 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?
user avatar
0 votes
1 answer
58 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-...
user avatar
  • 1,360
1 vote
0 answers
654 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 ...
user avatar
2 votes
0 answers
602 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 ...
user avatar
2 votes
1 answer
13k 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
13k 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 ...
user avatar
  • 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 ...
user avatar
  • 193
1 vote
1 answer
764 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 ...
user avatar
  • 335
1 vote
1 answer
771 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-...
user avatar
4 votes
1 answer
699 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 ...
user avatar
1 vote
0 answers
577 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 ...
user avatar
  • 1,920
2 votes
2 answers
12k 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?
user avatar
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 ...
user avatar
  • 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 ...
user avatar
2 votes
2 answers
1k 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. ...
user avatar
1 vote
1 answer
364 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 ...
user avatar
0 votes
1 answer
184 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 ...
user avatar
  • 1,360
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. ...
user avatar
1 vote
0 answers
288 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 ...
user avatar
1 vote
1 answer
828 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 ...
user avatar
2 votes
1 answer
554 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 ...
user avatar
1 vote
4 answers
4k 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 ...
user avatar
  • 11
1 vote
1 answer
721 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 ...
user avatar
  • 113
29 votes
4 answers
74k 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 183
5 votes
5 answers
18k 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 ...
user avatar
  • 976
33 votes
5 answers
96k 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? ...
user avatar
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 ...
user avatar
3 votes
1 answer
12k views

How to properly stop MySQL server on Mac OS X?

I installed MySQL Community Server following instructions at http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html with the Startup Item and the MySQL Preference Pane. I can stop the ...
user avatar
  • 3,167