MySQL not working, throwing Got error 28 from storage engine errors

mysql

#1

Mysql not woking and returning exceptions
18/07/18 07:49:23 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.sql.SQLException: Got error 28 from storage engine
java.lang.RuntimeException: java.sql.SQLException: Got error 28 from storage engine
at org.apache.sqoop.manager.CatalogQueryManager.getColumnNames(CatalogQueryManager.java:165)
at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1808)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1662)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
Caused by: java.sql.SQLException: Got error 28 from storage engine
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1614)
at org.apache.sqoop.manager.CatalogQueryManager.getColumnNames(CatalogQueryManager.java:150)
… 11 more


#2

@Neeraj_Wadhwani Can you share the command which you tried?


#3

@annapurna

Everything is failing, altering tables, describe etc. I tried the below one in retail_export database

describe products_replica;


#4

@admins, please help with MySQL on the cluster. it is not working


#5

@Neeraj_Wadhwani To access MYSQL in labs refer below link .