The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [shutdown]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
2answers
140 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?
9
votes
3answers
60k 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 ...
0
votes
0answers
26 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 ...
0
votes
1answer
151 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 ...
22
votes
4answers
54k 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 ...
2
votes
1answer
6k 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 ...
0
votes
1answer
471 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
0answers
227 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 ...
2
votes
1answer
757 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-...
1
vote
1answer
76 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
1answer
44 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 ...
0
votes
1answer
49 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
vote
0answers
362 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
0answers
495 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 ...
5
votes
4answers
14k 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
vote
1answer
331 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 ...
2
votes
1answer
7k 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?
1
vote
3answers
8k 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?
9
votes
4answers
3k 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 ...
1
vote
1answer
463 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 ...
2
votes
2answers
739 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. ...
3
votes
1answer
2k 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 ...
1
vote
1answer
345 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-...
28
votes
5answers
88k 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] /...
3
votes
1answer
502 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
0answers
297 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 ...
3
votes
1answer
2k 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 ...
1
vote
0answers
249 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
1answer
2k 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
1answer
806 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
1answer
478 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 ...
0
votes
4answers
2k 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 ...
1
vote
1answer
585 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 ...
8
votes
1answer
663 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 ...
2
votes
3answers
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 ...
0
votes
0answers
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? ...
3
votes
1answer
11k 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 ...