[one-users] Fwd: Error trying to CREATE HOST Error inserting Host Share in DB

Carlos Martín Sánchez cmartin at opennebula.org
Fri Apr 15 06:02:24 PDT 2011


Hi Sebastian,

Could you check that oneadmin can ssh passwordless to localhost?

--
Carlos Martín, MSc
Project Major Contributor
OpenNebula - The Open Source Toolkit for Cloud Computing
www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org


2011/4/14 Sebastian Neg <neg.sebastian at gmail.com>

> Hi Carlos,
> I fixed the problem with the installation of rack (version 1.2.0) instead
> of 1.2.2 and i can crete onehost.
> But the problem now that the status of the host remains unchanged.
>
> [oneadmin at root ~]$ onehost list
>   ID NAME              CLUSTER  RVM   TCPU   FCPU   ACPU    TMEM    FMEM
> STAT
>    1 localhost         default    0      0      0    100      0K      0K
> on
>
> Here is the "oned.log"
> Monitoring host localhost (1)
> Thu Apr 14 13:45:28 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:45:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:45:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:45:38 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:45:45 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:45:50 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:45:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:45:59 2011 [ReM][D]: HostInfo method invoked
> Thu Apr 14 13:46:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:46:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:46:08 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:46:08 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:46:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:46:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:46:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:46:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:47:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:47:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:47:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:47:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:47:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:47:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:47:54 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:47:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:47:58 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:48:01 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:48:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:48:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:48:04 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:48:06 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:48:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:48:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:48:32 2011 [VMM][I]: --Mark--
> Thu Apr 14 13:48:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:48:58 2011 [InM][I]: --Mark--
> Thu Apr 14 13:48:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:49:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:49:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:49:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:49:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:49:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:49:35 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:49:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:49:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:49:58 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:50:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:50:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:50:06 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:50:14 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:50:18 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:50:22 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:50:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:50:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:50:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:50:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:51:01 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:51:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:51:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:51:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:51:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:51:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:51:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:52:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:52:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:52:02 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:52:14 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:52:26 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:52:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:52:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:52:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:52:32 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:52:38 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:52:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:53:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:53:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:53:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:53:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:53:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:53:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:53:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:54:01 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:54:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:54:06 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:54:22 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:54:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:54:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:54:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:54:38 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:54:46 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:54:54 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:54:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:55:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:55:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:55:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:55:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:55:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:55:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:55:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:56:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:56:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:56:10 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:56:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:56:30 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:56:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:56:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:56:50 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:56:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:57:00 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:57:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:57:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:57:10 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:57:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:57:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:57:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:57:50 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:57:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:58:01 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:58:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:58:14 2011 [ReM][D]: ClusterPoolInfo method invoked
> Thu Apr 14 13:58:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:58:31 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:58:32 2011 [VMM][I]: --Mark--
> Thu Apr 14 13:58:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:58:38 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
> Thu Apr 14 13:58:58 2011 [InM][I]: --Mark--
> Thu Apr 14 13:58:58 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:59:02 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:59:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:59:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
> Thu Apr 14 13:59:14 2011 [ReM][D]: UserPoolInfo method invoked
> Thu Apr 14 13:59:26 2011 [ReM][D]: ImagePoolInfo method invoked
> Thu Apr 14 13:59:28 2011 [InM][I]: Monitoring host localhost (1)
> Thu Apr 14 13:59:32 2011 [ReM][D]: HostPoolInfo method invoked
> Thu Apr 14 13:59:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>
>
>
> 2011/4/14 Carlos Martín Sánchez <cmartin at opennebula.org>
>
>> Hi Sebastian,
>>
>> Any other error messages? What about the bootstrapping section of the log?
>> Try that sqlite3 command (assuming you have sqlite set in your oned.conf)
>> in /var/lib/one; or $ONE_LOCATION/var if you installed it in self-contained
>> mode. That's where you'll find the one.db file.
>>
>> On a side note, if you are using localhost as front-end and Host then you
>> can use the tm_nfs drivers, since the FS is shared.
>>
>>
>> Regards,
>> Carlos.
>>
>> --
>> Carlos Martín, MSc
>> Project Major Contributor
>> OpenNebula - The Open Source Toolkit for Cloud Computing
>> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org
>>
>>
>> 2011/4/14 Sebastian Neg <neg.sebastian at gmail.com>
>>
>>> Hi,
>>> I installed Opennebula 2.2 and it works fine.
>>> but when i want to create a host, i get this error:
>>>
>>> [oneadmin at root ~]$ onehost create localhost im_kvm vmm_kvm tm_ssh
>>> Error: [HostAllocate] Error trying to CREATE HOST Error inserting Host in
>>> DB.
>>>
>>> When i try to run this command "sqlite3 one.db ".schema"", i got nothing:
>>> [oneadmin at root ~]$ sqlite3 one.db ".schema"
>>> [oneadmin at root ~]$
>>>
>>> Note: I installed the front-end and the cluster in one machine.
>>>
>>>
>>>
>>> 2011/4/1 Carlos Martín Sánchez <cmartin at opennebula.org>
>>>
>>>> Hi Vivek,
>>>>
>>>> You are installing OpenNebula 2.0, right?
>>>>
>>>> Could you check if there is any error message in oned.log right after
>>>> this message?
>>>> [ONE][I]: Bootstraping OpenNebula database.
>>>>
>>>>
>>>> It may be also helpful if you could send the output of
>>>> $ sqlite3 one.db ".schema"
>>>>
>>>>
>>>> Regards,
>>>> Carlos
>>>> --
>>>> Carlos Martín, MSc
>>>> Project Major Contributor
>>>> OpenNebula - The Open Source Toolkit for Cloud Computing
>>>> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula
>>>> .org
>>>>
>>>>
>>>> On 31 March 2011 16:02, Vivek Shrivastava <shrivastava.vivex at gmail.com>wrote:
>>>>
>>>>>
>>>>>
>>>>> Hello all,
>>>>>
>>>>> I've installed opennebula with the help of express installation, while
>>>>> creating node I'm getting the problem:-
>>>>>
>>>>>
>>>>> oneadmin at oneadmin-desktop:~/Downloads$ onehost create node01 im_kvm
>>>>> vmm_kvm tm_ssh
>>>>> Error: [HostAllocate] Error trying to CREATE HOST Error inserting Host
>>>>> Share in DB.
>>>>>
>>>>> (1)  I made /etc/one chmod 777, so that install.sh can run easily, is
>>>>> this the problem?
>>>>>
>>>>> (2) What should I do to solve above problem?
>>>>>
>>>>> (3) if I want to use kvm with ssh in cluster nodes, is that necessary
>>>>> to configure nfs (in node-install script) ?
>>>>>
>>>>> (4)  in oned.log I got this error:-
>>>>>
>>>>> SQL command was: INSERT INTO host_shares (hid,disk_usage, mem_usage,
>>>>> cpu_usage,max_disk,   max_mem,   max_cpu,free_disk,  free_mem,
>>>>> free_cpu,used_disk,  used_mem,  used_cpu,running_vms) VALUES
>>>>> (0,0,0,0,0,0,0,0,0,0,0,0,0,0), error: table host_shares has no column named
>>>>> free_disk
>>>>>
>>>>> What should I do?
>>>>>
>>>>>
>>>>> Thanks in advance.
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Vivek Shrivastava
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opennebula.org
>>>>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opennebula.org
>>>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20110415/5842ea15/attachment-0003.htm>


More information about the Users mailing list