Support Questions
Find answers, ask questions, and share your expertise

Re: Hive does not start on HDP 2.4 sandbox

Explorer

@Timothy Spann

Yes.. mySQLcheck is running...

6045-2016-07-25-2.png

Re: Hive does not start on HDP 2.4 sandbox

Mentor

Check the space for MySQL data directory, check whether MySQL port is being used by something else. check whether permissions have changed

du -hs /path/*
df -hs *
netstat -tulnp / grep 3306
ls -ltra /path

Re: Hive does not start on HDP 2.4 sandbox

Super Guru

@Swati Gupta / @Ebisa Negeri

Can you please try below steps:

# cd /var/lib/mysql
# mkdir bak
# mv ibdata1 bak/.
# mv ib_logfile* bak/.
# cp -a bak/ibdata1 ibdata1
# cp -a bak/ib_logfile* .
# service mysql restart

Reference - http://notesonit.blogspot.hk/2013/05/innodb-unable-to-lock-ibdata1-error-11.html

Re: Hive does not start on HDP 2.4 sandbox

Explorer

I am facing this same problem. Did you find any solution to this problem?

Re: Hive does not start on HDP 2.4 sandbox

Expert Contributor

http://notesonit.blogspot.hk/2013/05/innodb-unable-to-lock-ibdata1-error-11.html , see if the steps in this link work for you. I see that you also got the same error #11 from your logs. put the steps below for convenience

I was able to fix the problem by restoring the permissions on several files (modified from this post): # cd /var/lib/mysql # mkdir bak # mv ibdata1 bak/. # mv ib_logfile* bak/. # cp -a bak/ibdata1 ibdata1 # cp -a bak/ib_logfile* .

# service mysql restart