Unable to start mysql 5.7 on linux server
Posted by: suparna kotaru
Date: October 28, 2016 11:20AM

Hello,

I'm having problem in starting the mysql service.... I started the service 16 hours ago still it's showing as starting mysql server... So i tried to remove the mysql package from server to install freshly.. But i also can't remove the package... Below is the output I'm getting when i tried to start the mysql and also when I'm trying to remove package...I have installed mysql using yum.. Your help is much appreciated...

[root@crm-dev lc42276]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: deactivating (stop-sigterm) since Thu 2016-10-27 20:17:05 EDT; 16h ago
Main PID: 4759
CGroup: /system.slice/mysqld.service


Oct 27 20:49:44 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 20:50:51 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 20:51:32 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 20:54:10 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 20:54:24 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 20:56:40 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 21:01:01 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 21:01:55 crm-dev systemd[1]: Starting MySQL Server...
Oct 27 21:06:34 crm-dev systemd[1]: Stopping MySQL Server...
Oct 27 21:22:45 crm-dev systemd[1]: Stopping MySQL Server...

When I tried to stop the service.. It's being static without any result...
[root@crm-dev mysql]# systemctl stop mysqld.service

Removing mysql package...
[root@crm-dev lc42276]# yum remove mysql-server
Loaded plugins: product-id, subscription-manager
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.16-1.el7 will be erased
--> Finished Dependency Resolution


Dependencies Resolved


========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Removing:
mysql-community-server x86_64 5.7.16-1.el7 @mysql57-community 691 M


Transaction Summary
========================================================================================================================================================================
Remove 1 Package


Installed size: 691 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction




^Cerror: %preun(mysql-community-server-5.7.16-1.el7.x86_64) scriptlet failed, signal 2
Error in PREUN scriptlet in rpm package mysql-community-server-5.7.16-1.el7.x86_64

cursor is static from a long time... So i interrupted the process.

Please give me your suggestions to fix this issue.. Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
Unable to start mysql 5.7 on linux server
October 28, 2016 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.