Questions tagged [shutdown]
The shutdown tag has no usage guidance.
52
questions
33
votes
5
answers
99k
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] /...
Tiffany Walker
31
votes
4
answers
79k
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 ...
- 5,967
9
votes
4
answers
5k
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
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 ...
- 545
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
2
answers
16k
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] ...
- 51
5
votes
5
answers
20k
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 ...
- 1,006
5
votes
1
answer
17k
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 ...
- 155
4
votes
1
answer
1k
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 ...
3
votes
1
answer
16k
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?
user3565261
3
votes
1
answer
8k
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-...
- 131
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 ...
- 45
3
votes
1
answer
13k
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 ...
- 3,447
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
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 ...
- 43
2
votes
2
answers
14k
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?
- 33
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,805
2
votes
0
answers
633
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 ...
- 21
2
votes
1
answer
613
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 ...
- 119
1
vote
4
answers
8k
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
897
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
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. ...
- 21
1
vote
1
answer
29
views
Does Docker stop take of care of stopping gossip and drain?
We have a setup where we have 3 cassandra nodes running as a cluster. We are using cassandra docker container with cassandra version 4.1.3.
So, in this scenario what happens when one of the node ...
- 11
1
vote
1
answer
733
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'...
- 125
1
vote
2
answers
1k
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 ...
- 13
1
vote
1
answer
434
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 ...
- 11
1
vote
1
answer
1k
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
1
vote
0
answers
616
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
vote
0
answers
561
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 ...
- 785
1
vote
0
answers
1k
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 ...
- 785
1
vote
1
answer
135
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, ...
- 81
1
vote
1
answer
799
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-...
1
vote
0
answers
644
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 ...
- 2,126
1
vote
0
answers
302
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 ...
- 133
1
vote
1
answer
850
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 ...
- 125
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
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 ?...
0
votes
1
answer
62
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,440
0
votes
1
answer
39
views
Does the order in which vms are shutdown impact the postgresql replication environment?
I have the following environment:
A postgres server (rhel8, postgresql v14) as master and another as standby.
I need to do a maintenance task on the infrastructure and for this reason both vms need to ...
- 149
0
votes
1
answer
547
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....
- 1
0
votes
2
answers
813
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 ...
- 101
0
votes
2
answers
1k
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 ...
- 167
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
/...
- 101
0
votes
1
answer
116
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 ...
0
votes
2
answers
819
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 ...
- 101
0
votes
2
answers
4k
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?
- 57
0
votes
0
answers
75
views
MariaDB always failed shutdown
Versions :
CentOS 7.8
10.4.14-MariaDB
Using MariaDB SPIDER engine for 1 of the table
Variables :
log_error=/var/log/mariadb/mariadb.log
symbolic-links=0
innodb_thread_concurrency=32
...
0
votes
1
answer
103
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, ...
0
votes
1
answer
202
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,440
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? ...
- 185