• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Problem with Percona...

Sheratan

Well-known member
#1
I'm trying to learn more about Percona.

Installing Debian 7 with Percona 5.6 in VMWare, i realize I can't restart percona.

Code:
service mysql reload
Works. But everytime I do
Code:
service mysql restart
Percona failed to restart. I had to reboot to make percona up again.

The weird thing is... when I check percona status
Code:
service mysql status
Percona is down. But when I see...
Code:
lsof -i -P
There is mysql runing as mysqd.

Another problem, percona failed to up if I put .cnf from Percona Tools wizard. Even rebooting cannot make percona up.

So... any suggestion?
 

jwright

Active member
#5
Can you give us the output (at least last 100 lines or so) from the log file? I'm not sure where this is on Debian but in CentOS the following command would work (it will probably work for Debian as well):

Code:
cat /var/lib/mysql/`hostname`.err
 

Sheratan

Well-known member
#6
Ooh! I got it.

First, you cannot restart percona from
Code:
service mysql restart
You need to use init.d for it
Code:
/etc/init.d/mysql restart
Second, there is some mistake in Percona Tools Wizard. By default, you got this:
Code:
[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysql/mysql.sock
pid-file                       = /var/lib/mysql/mysql.pid
But the truth is... if you install percona from their official repo, you got this:

Code:
[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysqld/mysqld.sock

[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysqld/mysqld.sock
pid-file                       = /var/lib/mysql/*your_host_name_or_something.pid
Check your PID with:
Code:
ps aux |grep mysql
 

Tracy Perry

Well-known member
#7
:ROFLMAO:

Do you had any problem with percona in centos? Because a lot of people got same problem in debian...
Did you follow ALL the instructions and PIN percona in the /etc/apt/preferences.d
Code:
Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001
The only time I've seen that happen was when it wasn't pinned and the system upgraded/installed the default (shipping) mySQL also and there were some conflicts. And yes, it got me once when I forgot to do it and there was a mySQL update out that aptitude update/aptitude safe-upgrade was ran and picked up and cratered Percona. Once I uninstalled the shipping version, pinned the Percona version and then installed Percona again never had any more problems.

Code:
service mysql restart
works just fine on all 6 of the Debian boxes that I have.
Code:
root@centauri:/etc/apt# service mysql restart
[ ok ] Stopping MySQL (Percona Server): mysqld.
[ ok ] Starting MySQL (Percona Server) database server: mysqld . . ..
[info] Checking for corrupt, not cleanly closed and upgrade needing tables..
 

Sheratan

Well-known member
#8
Did you follow ALL the instructions and PIN percona in the /etc/apt/preferences.d
Code:
Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001
Forgot about it. Thanks for tellling me. :) But I'm not upgrading from stock mysql.

Did I need to reinstall percona again for this Pin?
 

Tracy Perry

Well-known member
#9
Forgot about it. Thanks for tellling me. :) But I'm not upgrading from stock mysql.

Did I need to reinstall percona again for this Pin?
If you are on the stock (shipped with Debian) mySQL then you don't need to do that. If you are running Percona then you need to pin it by creating (in the /etc/apt/preferences.d) a file called 00percona.pref (those are zero's at the lead) and then place the info into that file.
 

Sheratan

Well-known member
#10
Not a problem but makes my spidey sense tingling!

Code:
adminaccount@hostname:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be DOWNGRADED:
  libmysqlclient18.1
0 upgraded, 0 newly installed, 1 downgraded, 0 to remove and 0 not upgraded.
Need to get 946 kB of archives.
After this operation, 1,024 B disk space will be freed.
Latest Debian 7 64, Percona 5.6.15-63.0-log.

Any information about this?