[hive]Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)
来源:互联网 发布:微信全屏头像源码 编辑:程序博客网 时间:2024/05/18 12:04
启动hive时,出现以下错误:
root@node3 ~]# hiveLogging initialized using configuration in jar:file:/usr/local/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.propertiesException in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientat org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:497)at org.apache.hadoop.util.RunJar.main(RunJar.java:212)Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientat org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)... 7 moreCaused by: java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:422)at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)... 13 moreCaused by: javax.jdo.JDODataStoreException: Exception thrown obtaining schema column information from datastoreNestedThrowables:java.sql.SQLException: Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)at org.apache.hadoop.hive.metastore.ObjectStore.setMetaStoreSchemaVersion(ObjectStore.java:6773)at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6670)at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6645)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:497)at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:114)at com.sun.proxy.$Proxy6.verifySchema(Unknown Source)at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572)at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)... 18 moreCaused by: java.sql.SQLException: Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2415)at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2313)at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2311)at org.datanucleus.store.rdbms.adapter.BaseDatastoreAdapter.getColumns(BaseDatastoreAdapter.java:1532)at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.refreshTableData(RDBMSSchemaHandler.java:911)at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableInfoForTable(RDBMSSchemaHandler.java:821)at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableInfoForTable(RDBMSSchemaHandler.java:770)at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:206)at org.datanucleus.store.rdbms.RDBMSStoreManager.getColumnInfoForTable(RDBMSStoreManager.java:2378)at org.datanucleus.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:215)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3393)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841)at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605)at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954)at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679)at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2045)at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1365)at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3827)at org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2571)at org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:513)at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:232)at org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1414)at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2218)at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:2065)at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1913)at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:727)... 36 more
解决办法:
需要指定一个mysql的tmpdir
vi /etc/my.cnf[mysqld]tmpdir=/var/lib/mysql
重启mysql即可
0 0
- [hive]Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)
- Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)
- MySQL 诡异报错Can't create/write to file '/tmp/#sql_89b_0.MYI' (Errcode: 177 - File exists)
- /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)
- Mysql 出错,Can't create/write to file C:\WINDOWS\TEMP\#sql_1588_0.MYI(Errcode:13)的解决办法
- mysql> desc tablename; ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI'
- 关于大量数据的查询导致sql报错类似Can’t create/write to file ‘c:\temp/#sql-XXX.MYI′ (Errcode: 13)"的错误
- can't create/write to file '/tmp/#sql_23e6_0MYI'解决方法
- ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)
- mysqldump 备份命令错误 Can't create/write to file '' (Errcode: 13)
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- mysqldump: Got error: 1: Can't create/write to file '/data/export/test.txt' (Errcode: 13)
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- 解决:CentOS下MySQL执行select ... into outfile ...: Can't create/write to file '...' (Errcode: 13)
- Java基础——成员变量、局部变量和静态变量的区别
- matlab2015和vs2013混合编程
- poj 2195 Going Home (费用流/KM)
- 【LeetCode】(113)Path Sum II(Medium)
- HDOJ 3790 最短路径问题 (最短路 && Dijkstra && 双权值)
- [hive]Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)
- SSH整合之架构的历史---用户注册
- Dmidecode命令详解
- 二进制-十进制-十六进制-含义解释
- php:内存回收机制
- python 打开文件,写入文件,关闭文件,读文件,清空文件内容
- 目前为止存在的这些问题
- C++基本知识归纳(1)
- Java 语言中 List、Set 和 Map 的区别