hive问题Cannot get a connection, pool error Could not create a validated object 的解决办法

川长思鸟来 2022-05-05 15:31 322阅读 0赞

\[hadoop@master hive\_dat\]$ hive  
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties  
Hive history file=/tmp/hadoop/hive\_job\_log\_hadoop\_201212181216\_2004188466.txt  
hive> show tables;  
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.  
NestedThrowables:  
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.  
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask  
hive> select \* from report\_im\_push\_msg\_log limit 10;  
FAILED: Error in semantic analysis: Unable to fetch table report\_im\_push\_msg\_log  
hive> exit;  
\[hadoop@master hive\_dat\]$  
\[hadoop@master hive\_dat\]$ l;l  
\-bash: l: command not found  
\-bash: l: command not found  
\[hadoop@master hive\_dat\]$ ll  
total 2892096  
\-rw-r--r-- 1 hadoop hadoop     195602 Dec 14 00:01 197\_rp-login-20121214-1.log  
\-rw-r--r-- 1 hadoop hadoop    1857051 Dec 14 00:18 199\_rp-login-20121214-1.log  
\-rw-r--r-- 1 hadoop hadoop 2947758976 Aug 27 15:12 applist\_20120802.txt  
\-rw-rw-r-- 1 hadoop hadoop        357 Dec 18 12:16 derby.log  
drwxrwxr-x 2 hadoop hadoop      36864 Dec 18 12:06 getui  
drwxrwxr-x 2 hadoop hadoop       4096 Dec 14 15:56 local\_out.dat  
drwxrwxr-x 5 hadoop hadoop       4096 Dec 18 12:16 metastore\_db  
drwxrwxr-x 2 hadoop hadoop       4096 Dec 14 17:55 package\_name  
\-rw-rw-r-- 1 hadoop hadoop    8728523 Dec 17 11:11 test.dat  
\[hadoop@master hive\_dat\]$  
\[hadoop@master hive\_dat\]$ cd metastore\_db/  
\[hadoop@master metastore\_db\]$ ll  
total 24  
\-rw-rw-r-- 1 hadoop hadoop    4 Dec 18 12:10 dbex.lck  
\-rw-r--r-- 1 root   root     38 Dec 18 12:10 db.lck  
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:30 log  
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:34 seg0  
\-rw-rw-r-- 1 hadoop hadoop  846 Dec 14 15:30 service.properties  
drwxrwxr-x 2 hadoop hadoop 4096 Dec 18 12:16 tmp  
\[hadoop@master metastore\_db\]$ mv dbex.lck 1218dbex.lck  
\[hadoop@master metastore\_db\]$ mv db.lck 1218db.lck  
\[hadoop@master metastore\_db\]$ cd ..  
\[hadoop@master hive\_dat\]$ hive  
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties  
Hive history file=/tmp/hadoop/hive\_job\_log\_hadoop\_201212181217\_369609033.txt  
hive> show tables;  
OK  
app\_list  
report\_cm\_login\_log  
report\_im\_push\_msg\_log  
Time taken: 4.26 seconds  
hive> select \* from report\_im\_push\_msg\_log limit 10;  
OK