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

Sebastian Neg neg.sebastian at gmail.com
Thu Apr 14 06:01:06 PDT 2011


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/20110414/cadb507d/attachment-0002.htm>


More information about the Users mailing list