write down,forget
标签 Tag : error

Hive derby lock及目录权限错误

<Category: Hadoop> Comments Off on Hive derby lock及目录权限错误

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 history file=/tmp/dev/hive_job_log_dev_201107062337_381665684.txt
FAILED: Error in semantic analysis: line 1:83 Exception while processing raw_daily_stats_table: Unable to fetch table raw_daily_stats_table

查看hive配置文件/etc/hive/conf/hive-default.xml,找到你的元数据存放位置

打开hdfs目录发现
/user/hive/warehouse

raw_daily_stats_table 目录的权限成root了,但是我是以dev身份执行的,

执行:

结果发现还是报,神啊

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

打开配置文件/etc/hive/conf/hive-site.xml发现如下节点

然后定位到相应目录

db.lck 干掉, dbex.lck干掉

再跑hadoop相关脚本,ok~

本文来自: Hive derby lock及目录权限错误

The "GenerateResource" task failed unexpectedly.

<Category: 问题> Comments Off on The "GenerateResource" task failed unexpectedly.

Error    9    The “GenerateResource” task failed unexpectedly.
System.TypeInitializationException: The type initializer for ‘Microsoft.Build.Utilities.FileTracker’ threw an exception. —> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Build.Utilities.FileTracker..cctor()
— End of inner exception stack trace —
at Microsoft.Build.Utilities.FileTracker.ForceOutOfProcTracking(ExecutableType toolType, String dllName, String cancelEventName)
at Microsoft.Build.Tasks.GenerateResource.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.ExecuteInstantiatedTask(ITaskExecutionHost taskExecutionHost, TaskLoggingContext taskLoggingContext, TaskHost taskHost, ItemBucket bucket, TaskExecutionMode howToExecuteTask, Boolean& taskResult)    WorkflowMonitor

<?xml version=”1.0″ encoding=”utf-8″?>
<Project DefaultTargets=”Build” xmlns=”http://schemas.microsoft.com/developer/msbuild/2003″ ToolsVersion=”4.0″>
<PropertyGroup>
<TrackFileAccess>false</TrackFileAccess>
….

谁有没有终极解决办法。。。

 –有了–

修改所有Microsoft.Common.targets

 <TrackFileAccess Condition=”‘$(TrackFileAccess)’ == ””>false</TrackFileAccess>

—–

Find the file: C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.Targets

Locate the <GenerateResource> tag at Line 1835 and delete the attributes TrackFileAccess and TrackerLogDirectory

http://social.msdn.microsoft.com/Forums/en/csharpide/thread/88db71cf-a501-428d-91fa-1535d82d8014

http://www.go4answers.com/Example/error-msb4018-generateresource-task-25286.aspx

本文来自: The "GenerateResource" task failed unexpectedly.

errorMSB3323: Unable to find manifest signing certificate in the certificate store.

<Category: .NET> Comments Off on errorMSB3323: Unable to find manifest signing certificate in the certificate store.

CCNET build报的错

D:\WINDOWS\Microsoft.NET\Framework\v3.5\Microsoft.Common.targets (1783,7): errorMSB3323: Unable to find manifest signing certificate in the certificate store.

解决办法,如下,工程属性,singing选项卡,去掉ClickOne的钩即可。

temp

本文来自: errorMSB3323: Unable to find manifest signing certificate in the certificate store.