RE: hive0.6 metastore Problem for help

[Chinna Rao Lalam]

Hi,



 Pls check this property " javax.jdo.option.Multithreaded " it is introduced in 
trunk in 0.8 version as part of HIVE-2022  . If the value is true it  will make 
JDO thread safe. Analyze this property can be added to 0.6 version or not if it 
works.



Hope it helps,

Chinna Rao Lalam

________________________________
From: 黄逗 [huangdou...@taobao.com]
Sent: Thursday, November 17, 2011 5:20 PM
To: user@hive.apache.org
Subject: hive0.6 metastore Problem for help

Hello everybody

I had a problem when I used hive0.6 metastore.  Is such

There are a lot of  timing task in my application run at  09 am  to  11am  
every day, i Don't know from when to begin , a task got a exception, and then, 
all of the tasks are exception from this time.

The content of the task is some hive sql like this:
create table tmp_wanyi_mall_guide22
as
 select
    b.cat_id,
    b.seller_id,
    b.value_id,
    b.auction_id
    from
    tmp_wanyi_mall_guide21 a
    join
    (select
    cat_id,seller_id,value_id,auction_id
   from
    tmp_wanyi_mall_guide18_3
)b
    on(a.cat_id=b.cat_id and a.value_id=b.value_id);

and all of the  exception like this:
              FAILED: Error in metadata: javax.jdo.JDODataStoreException: 
Insert of object "org.apache.hadoop.hive.metastore.model.MTable@356b4d6a
" using statement "INSERT INTO `TBLS` 
(`TBL_ID`,`SD_ID`,`RETENTION`,`OWNER`,`VIEW_EXPANDED_TEXT`,`LAST_ACCESS_TIME`,`TBL_TYPE`,`CREA
TE_TIME`,`TBL_NAME`,`VIEW_ORIGINAL_TEXT`,`DB_ID`) VALUES 
(?,?,?,?,?,?,?,?,?,?,?)" failed : Lock wait timeout exceeded; try restartin
g transaction
NestedThrowables:
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.DDLTask


          I hava asked DBA, he said , it happened dead lock on this table 
‘tbls’     , the lock got by a thread and aways don’t  release , and other 
thread are wait for the lock timeout.

        Is anybody met same case with me?  Please Help me,  thanks every much.





________________________________
This email (including any attachments) is confidential and may be legally 
privileged. If you received this email in error, please delete it immediately 
and do not copy it or use it for any purpose or disclose its contents to any 
other person. Thank you.

本电邮(包括任何附件)可能含有机密资料并受法律保护。如您不是正确的收件人，请您立即删除本邮件。请不要将本电邮进行复制并用作任何其他用途、或透露本邮件之内容。谢谢。