You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@usergrid.apache.org by J Captain <jc...@gmail.com> on 2016/02/09 20:11:15 UTC
Re: Unable to deploy Usergrid 2.1
Hi,
I am trying to run Usergrid 2.1 code with Cassandra 1.2 and ElesticSearch
1.4. When I start tomcat with ROOT.war I get this error. (why: Keyspace
'Usergrid_Applications' does not exist ) Every where I checked, they are
asking to executing three curl commands for setting up the database,
Setup calls:
PUT http://localhost:8080/system/database/setup
PUT http://localhost:8080/system/database/bootstrap
GET http://localhost:8080/system/superuser/setup
but how can I run them when my tomcat does not start properly? I tried
Usergrid1.0 and it works fine. 1.0 does not try to access these keyspace on
tomcat start up.
I am totally stuck with this issue. Obviously I am missing something.
Please help.
Thanks,
Jigar
Re: Unable to deploy Usergrid 2.1
Posted by J Captain <jc...@gmail.com>.
It worked!!!
Thanks a lot. I don't know how many ours I have spent looking to get rid of
those startup errors. I always assumed that after clean tomcat startup I
have to run the setup.
Thank again.
Jigar Captain
On Fri, Feb 12, 2016 at 11:34 AM, Michael Russo <mi...@gmail.com>
wrote:
> Hi Jigar,
>
> I looked through your log file and it actually looks OK and expected the
> first time the application is running before the database schema has been
> setup. You're seeing those errors because there are threads that will
> start as soon as the application is starts and they try to access the
> database (the threads assume it's already been setup).
>
> *What you should do --->*
>
> 1. Again start tomcat fresh
> 2. After few seconds run the below setup curl commands to initiate the
> database setup:
>
> curl -X PUT "http://localhost:8080/system/database/setup" -u
> superuser:test
> curl -X PUT "http://localhost:8080/system/database/bootstrap" -u
> superuser:test
> curl -X GET "http://localhost:8080/system/superuser/setup" -u
> superuser:test
>
> * note if you've changed the sysadmin username or password, then modify
> the above curl commands to replace superuser:test with <your
> username>:<your password>
>
> After you receive ok responses from these curl commands, you should see
> the errors disappear from the log file.
>
>
> Thanks.
> -Michael
>
>
> On Thu, Feb 11, 2016 at 10:41 AM, J Captain <jc...@gmail.com>
> wrote:
>
>> Hi Michael,
>>
>> I have attached full catalina.out logs for your reference. I am seeing
>> this error while starting tomcat first time after deploying war. Note: I
>> did not get chance to run those setup script as tomcat did not start
>> properly. I am using Usergrid-2.1.0-rc1, cassandra-1.2.19 and
>> elasticsearch-1.7. I also tried same with cassandra-2.2
>>
>> here is snippet of error
>>
>> me.prettyprint.hector.api.exceptions.HInvalidRequestException:
>> InvalidRequestException(why:Keyspace 'Usergrid_Applications' does not exist)
>> at
>> me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:112)
>> at
>> me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:251)
>> at
>> me.prettyprint.cassandra.service.KeyspaceServiceImpl.operateWithFailover(KeyspaceServiceImpl.java:132)
>> at
>> me.prettyprint.cassandra.service.KeyspaceServiceImpl.getSlice(KeyspaceServiceImpl.java:290)
>> at
>> me.prettyprint.cassandra.service.VirtualKeyspaceServiceImpl.getSlice(VirtualKeyspaceServiceImpl.java:133)
>> at
>> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:53)
>> at
>> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:49)
>> at
>> me.prettyprint.cassandra.model.KeyspaceOperationCallback.doInKeyspaceAndMeasure(KeyspaceOperationCallback.java:20)
>> at
>> me.prettyprint.cassandra.model.ExecutingVirtualKeyspace.doExecute(ExecutingVirtualKeyspace.java:53)
>> at
>> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery.execute(ThriftSliceQuery.java:48)
>> at
>> org.apache.usergrid.mq.cassandra.io.AbstractSearch.getQueueBounds(AbstractSearch.java:263)
>> at
>> org.apache.usergrid.mq.cassandra.io.ConsumerTransaction.getResults(ConsumerTransaction.java:213)
>> at
>> org.apache.usergrid.mq.cassandra.QueueManagerImpl.getFromQueue(QueueManagerImpl.java:412)
>> at
>> org.apache.usergrid.batch.service.SchedulerServiceImpl.getJobs(SchedulerServiceImpl.java:168)
>> at
>> org.apache.usergrid.batch.service.JobSchedulerService.runOneIteration(JobSchedulerService.java:118)
>> at
>> com.google.common.util.concurrent.AbstractScheduledService$1$1.run(AbstractScheduledService.java:174)
>> at
>> com.google.common.util.concurrent.Callables$3.run(Callables.java:95)
>> at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> at java.lang.Thread.run(Thread.java:745)
>> Caused by: InvalidRequestException(why:Keyspace 'Usergrid_Applications'
>> does not exist)
>> at
>> org.apache.cassandra.thrift.Cassandra$set_keyspace_result.read(Cassandra.java:5540)
>> at
>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
>> at
>> org.apache.cassandra.thrift.Cassandra$Client.recv_set_keyspace(Cassandra.java:540)
>> at
>> org.apache.cassandra.thrift.Cassandra$Client.set_keyspace(Cassandra.java:527)
>> at
>> me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:110)
>> ... 23 more
>>
>> Thanks,
>> Jigar
>>
>>
>> On Wed, Feb 10, 2016 at 2:09 AM, Michael Russo <mi...@gmail.com>
>> wrote:
>>
>>> Can you provide the full curl commands (omitting any password) that you
>>> executed on the tomcat server? Ensure that the following property is set
>>> as sysadmin privileges are required for the setup:
>>> *usergrid.sysadmin.login.allowed=true*
>>>
>>> What was the http response when running those commands?
>>>
>>> Did you notice anything in the catalina.out logs when you executed the
>>> request? There should be some information if this failed (aside from the
>>> errors containing "why: Keyspace 'Usergrid_Applications' does not exist
>>> ").
>>>
>>> Thanks.
>>> -Michael
>>>
>>> On Tue, Feb 9, 2016 at 11:11 AM, J Captain <jc...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to run Usergrid 2.1 code with Cassandra 1.2 and
>>>> ElesticSearch 1.4. When I start tomcat with ROOT.war I get this error.
>>>> (why: Keyspace 'Usergrid_Applications' does not exist ) Every where I
>>>> checked, they are asking to executing three curl commands for setting up
>>>> the database,
>>>>
>>>> Setup calls:
>>>> PUT http://localhost:8080/system/database/setup
>>>> PUT http://localhost:8080/system/database/bootstrap
>>>> GET http://localhost:8080/system/superuser/setup
>>>>
>>>> but how can I run them when my tomcat does not start properly? I tried
>>>> Usergrid1.0 and it works fine. 1.0 does not try to access these keyspace on
>>>> tomcat start up.
>>>>
>>>> I am totally stuck with this issue. Obviously I am missing something.
>>>> Please help.
>>>>
>>>> Thanks,
>>>> Jigar
>>>>
>>>
>>>
>>
>
Re: Unable to deploy Usergrid 2.1
Posted by Michael Russo <mi...@gmail.com>.
Hi Jigar,
I looked through your log file and it actually looks OK and expected the
first time the application is running before the database schema has been
setup. You're seeing those errors because there are threads that will
start as soon as the application is starts and they try to access the
database (the threads assume it's already been setup).
*What you should do --->*
1. Again start tomcat fresh
2. After few seconds run the below setup curl commands to initiate the
database setup:
curl -X PUT "http://localhost:8080/system/database/setup" -u
superuser:test
curl -X PUT "http://localhost:8080/system/database/bootstrap" -u
superuser:test
curl -X GET "http://localhost:8080/system/superuser/setup" -u
superuser:test
* note if you've changed the sysadmin username or password, then modify the
above curl commands to replace superuser:test with <your username>:<your
password>
After you receive ok responses from these curl commands, you should see the
errors disappear from the log file.
Thanks.
-Michael
On Thu, Feb 11, 2016 at 10:41 AM, J Captain <jc...@gmail.com> wrote:
> Hi Michael,
>
> I have attached full catalina.out logs for your reference. I am seeing
> this error while starting tomcat first time after deploying war. Note: I
> did not get chance to run those setup script as tomcat did not start
> properly. I am using Usergrid-2.1.0-rc1, cassandra-1.2.19 and
> elasticsearch-1.7. I also tried same with cassandra-2.2
>
> here is snippet of error
>
> me.prettyprint.hector.api.exceptions.HInvalidRequestException:
> InvalidRequestException(why:Keyspace 'Usergrid_Applications' does not exist)
> at
> me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:112)
> at
> me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:251)
> at
> me.prettyprint.cassandra.service.KeyspaceServiceImpl.operateWithFailover(KeyspaceServiceImpl.java:132)
> at
> me.prettyprint.cassandra.service.KeyspaceServiceImpl.getSlice(KeyspaceServiceImpl.java:290)
> at
> me.prettyprint.cassandra.service.VirtualKeyspaceServiceImpl.getSlice(VirtualKeyspaceServiceImpl.java:133)
> at
> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:53)
> at
> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:49)
> at
> me.prettyprint.cassandra.model.KeyspaceOperationCallback.doInKeyspaceAndMeasure(KeyspaceOperationCallback.java:20)
> at
> me.prettyprint.cassandra.model.ExecutingVirtualKeyspace.doExecute(ExecutingVirtualKeyspace.java:53)
> at
> me.prettyprint.cassandra.model.thrift.ThriftSliceQuery.execute(ThriftSliceQuery.java:48)
> at
> org.apache.usergrid.mq.cassandra.io.AbstractSearch.getQueueBounds(AbstractSearch.java:263)
> at
> org.apache.usergrid.mq.cassandra.io.ConsumerTransaction.getResults(ConsumerTransaction.java:213)
> at
> org.apache.usergrid.mq.cassandra.QueueManagerImpl.getFromQueue(QueueManagerImpl.java:412)
> at
> org.apache.usergrid.batch.service.SchedulerServiceImpl.getJobs(SchedulerServiceImpl.java:168)
> at
> org.apache.usergrid.batch.service.JobSchedulerService.runOneIteration(JobSchedulerService.java:118)
> at
> com.google.common.util.concurrent.AbstractScheduledService$1$1.run(AbstractScheduledService.java:174)
> at com.google.common.util.concurrent.Callables$3.run(Callables.java:95)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: InvalidRequestException(why:Keyspace 'Usergrid_Applications'
> does not exist)
> at
> org.apache.cassandra.thrift.Cassandra$set_keyspace_result.read(Cassandra.java:5540)
> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
> at
> org.apache.cassandra.thrift.Cassandra$Client.recv_set_keyspace(Cassandra.java:540)
> at
> org.apache.cassandra.thrift.Cassandra$Client.set_keyspace(Cassandra.java:527)
> at
> me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:110)
> ... 23 more
>
> Thanks,
> Jigar
>
>
> On Wed, Feb 10, 2016 at 2:09 AM, Michael Russo <mi...@gmail.com>
> wrote:
>
>> Can you provide the full curl commands (omitting any password) that you
>> executed on the tomcat server? Ensure that the following property is set
>> as sysadmin privileges are required for the setup:
>> *usergrid.sysadmin.login.allowed=true*
>>
>> What was the http response when running those commands?
>>
>> Did you notice anything in the catalina.out logs when you executed the
>> request? There should be some information if this failed (aside from the
>> errors containing "why: Keyspace 'Usergrid_Applications' does not exist
>> ").
>>
>> Thanks.
>> -Michael
>>
>> On Tue, Feb 9, 2016 at 11:11 AM, J Captain <jc...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> I am trying to run Usergrid 2.1 code with Cassandra 1.2 and
>>> ElesticSearch 1.4. When I start tomcat with ROOT.war I get this error.
>>> (why: Keyspace 'Usergrid_Applications' does not exist ) Every where I
>>> checked, they are asking to executing three curl commands for setting up
>>> the database,
>>>
>>> Setup calls:
>>> PUT http://localhost:8080/system/database/setup
>>> PUT http://localhost:8080/system/database/bootstrap
>>> GET http://localhost:8080/system/superuser/setup
>>>
>>> but how can I run them when my tomcat does not start properly? I tried
>>> Usergrid1.0 and it works fine. 1.0 does not try to access these keyspace on
>>> tomcat start up.
>>>
>>> I am totally stuck with this issue. Obviously I am missing something.
>>> Please help.
>>>
>>> Thanks,
>>> Jigar
>>>
>>
>>
>
Re: Unable to deploy Usergrid 2.1
Posted by J Captain <jc...@gmail.com>.
Hi Michael,
I have attached full catalina.out logs for your reference. I am seeing this
error while starting tomcat first time after deploying war. Note: I did not
get chance to run those setup script as tomcat did not start properly. I am
using Usergrid-2.1.0-rc1, cassandra-1.2.19 and elasticsearch-1.7. I also
tried same with cassandra-2.2
here is snippet of error
me.prettyprint.hector.api.exceptions.HInvalidRequestException:
InvalidRequestException(why:Keyspace 'Usergrid_Applications' does not exist)
at
me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:112)
at
me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:251)
at
me.prettyprint.cassandra.service.KeyspaceServiceImpl.operateWithFailover(KeyspaceServiceImpl.java:132)
at
me.prettyprint.cassandra.service.KeyspaceServiceImpl.getSlice(KeyspaceServiceImpl.java:290)
at
me.prettyprint.cassandra.service.VirtualKeyspaceServiceImpl.getSlice(VirtualKeyspaceServiceImpl.java:133)
at
me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:53)
at
me.prettyprint.cassandra.model.thrift.ThriftSliceQuery$1.doInKeyspace(ThriftSliceQuery.java:49)
at
me.prettyprint.cassandra.model.KeyspaceOperationCallback.doInKeyspaceAndMeasure(KeyspaceOperationCallback.java:20)
at
me.prettyprint.cassandra.model.ExecutingVirtualKeyspace.doExecute(ExecutingVirtualKeyspace.java:53)
at
me.prettyprint.cassandra.model.thrift.ThriftSliceQuery.execute(ThriftSliceQuery.java:48)
at
org.apache.usergrid.mq.cassandra.io.AbstractSearch.getQueueBounds(AbstractSearch.java:263)
at
org.apache.usergrid.mq.cassandra.io.ConsumerTransaction.getResults(ConsumerTransaction.java:213)
at
org.apache.usergrid.mq.cassandra.QueueManagerImpl.getFromQueue(QueueManagerImpl.java:412)
at
org.apache.usergrid.batch.service.SchedulerServiceImpl.getJobs(SchedulerServiceImpl.java:168)
at
org.apache.usergrid.batch.service.JobSchedulerService.runOneIteration(JobSchedulerService.java:118)
at
com.google.common.util.concurrent.AbstractScheduledService$1$1.run(AbstractScheduledService.java:174)
at com.google.common.util.concurrent.Callables$3.run(Callables.java:95)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: InvalidRequestException(why:Keyspace 'Usergrid_Applications'
does not exist)
at
org.apache.cassandra.thrift.Cassandra$set_keyspace_result.read(Cassandra.java:5540)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at
org.apache.cassandra.thrift.Cassandra$Client.recv_set_keyspace(Cassandra.java:540)
at
org.apache.cassandra.thrift.Cassandra$Client.set_keyspace(Cassandra.java:527)
at
me.prettyprint.cassandra.connection.client.HThriftClient.getCassandra(HThriftClient.java:110)
... 23 more
Thanks,
Jigar
On Wed, Feb 10, 2016 at 2:09 AM, Michael Russo <mi...@gmail.com>
wrote:
> Can you provide the full curl commands (omitting any password) that you
> executed on the tomcat server? Ensure that the following property is set
> as sysadmin privileges are required for the setup:
> *usergrid.sysadmin.login.allowed=true*
>
> What was the http response when running those commands?
>
> Did you notice anything in the catalina.out logs when you executed the
> request? There should be some information if this failed (aside from the
> errors containing "why: Keyspace 'Usergrid_Applications' does not exist
> ").
>
> Thanks.
> -Michael
>
> On Tue, Feb 9, 2016 at 11:11 AM, J Captain <jc...@gmail.com> wrote:
>
>> Hi,
>>
>> I am trying to run Usergrid 2.1 code with Cassandra 1.2 and ElesticSearch
>> 1.4. When I start tomcat with ROOT.war I get this error. (why: Keyspace
>> 'Usergrid_Applications' does not exist ) Every where I checked, they are
>> asking to executing three curl commands for setting up the database,
>>
>> Setup calls:
>> PUT http://localhost:8080/system/database/setup
>> PUT http://localhost:8080/system/database/bootstrap
>> GET http://localhost:8080/system/superuser/setup
>>
>> but how can I run them when my tomcat does not start properly? I tried
>> Usergrid1.0 and it works fine. 1.0 does not try to access these keyspace on
>> tomcat start up.
>>
>> I am totally stuck with this issue. Obviously I am missing something.
>> Please help.
>>
>> Thanks,
>> Jigar
>>
>
>
Re: Unable to deploy Usergrid 2.1
Posted by Michael Russo <mi...@gmail.com>.
Can you provide the full curl commands (omitting any password) that you
executed on the tomcat server? Ensure that the following property is set
as sysadmin privileges are required for the setup:
*usergrid.sysadmin.login.allowed=true*
What was the http response when running those commands?
Did you notice anything in the catalina.out logs when you executed the
request? There should be some information if this failed (aside from the
errors containing "why: Keyspace 'Usergrid_Applications' does not exist ").
Thanks.
-Michael
On Tue, Feb 9, 2016 at 11:11 AM, J Captain <jc...@gmail.com> wrote:
> Hi,
>
> I am trying to run Usergrid 2.1 code with Cassandra 1.2 and ElesticSearch
> 1.4. When I start tomcat with ROOT.war I get this error. (why: Keyspace
> 'Usergrid_Applications' does not exist ) Every where I checked, they are
> asking to executing three curl commands for setting up the database,
>
> Setup calls:
> PUT http://localhost:8080/system/database/setup
> PUT http://localhost:8080/system/database/bootstrap
> GET http://localhost:8080/system/superuser/setup
>
> but how can I run them when my tomcat does not start properly? I tried
> Usergrid1.0 and it works fine. 1.0 does not try to access these keyspace on
> tomcat start up.
>
> I am totally stuck with this issue. Obviously I am missing something.
> Please help.
>
> Thanks,
> Jigar
>