search

HiJen / Database_Issues

0 stars 0 forks source link

Got error 168 from storage engine #3

Open HiJen opened 5 years ago

HiJen commented 5 years ago

When I create a table, It doesn't work

[2019-03-30 10:31:51] [HY000][1030] Got error 168 from storage engine
[2019-03-30 10:31:51] [HY000][1030] Got error 168 from storage engine

Any ideas how to fix it? I've tried to google this problem, but couldn't find anything useful.

HiJen commented 5 years ago

[root@my-07-01 data]# chown -R mysql:mysql /mnt/p0/data/ [root@my-07-01 data]# chown -R mysql:mysql /mnt/p1/data/

df -h reboot

HiJen commented 5 years ago

Maybe someday, you have this problem, you can refer to the following

Or indicate that some tables already exist.
Solution: delete the database in the folder under

ib_buffer_pool
ib_logfile0
ib_logfile1
ibdata1
ibtmp1
The name of the machine. The pid
File, and then re-import it.