Questions tagged [shutdown]
The shutdown tag has no usage guidance.
51
questions
0
votes
0
answers
22
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
198
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
410
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
250
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
573
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
1
vote
0
answers
263
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,213
0
votes
1
answer
874
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 ...
- 149
1
vote
2
answers
790
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
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
99
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
11k
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
0
votes
1
answer
62
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
328
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
887
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-...
- 121
0
votes
2
answers
492
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
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, ...
- 81
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?
- 57
0
votes
1
answer
61
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,408
1
vote
0
answers
694
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
614
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
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?
user3565261
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
817
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
789
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
847
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
616
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,014
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?
- 33
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 ...
- 45
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,713
1
vote
1
answer
410
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
0
votes
1
answer
193
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,408
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
0
answers
300
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
843
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
2
votes
1
answer
576
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
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
850
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 ...
- 5,887
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
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] /...
Tiffany Walker
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? ...
- 175
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