dhis2-devs team mailing list archive

Thread
Date
What is type of this error?

To: DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, dhis-developers@xxxxxxxxxxxxxxxxxxxxx
From: channara rin <rin.channara@xxxxxxxxx>
Date: Tue, 7 Oct 2014 10:06:11 +0700
Hi DHIS2 dev,
when i run "Data Visualizer" to view data with bar chart, i got the error
"ERROR: column "name" doesn not exist" like below:
------------------------------------------------------------------------------------------------
r.java [http-bio-8090-exec-254])
* ERROR 2014-10-07 09:53:51,093 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-254])
* WARN  2014-10-07 09:53:51,249 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-268])
* ERROR 2014-10-07 09:53:51,249 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-268])
* WARN  2014-10-07 09:53:51,405 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-253])
* ERROR 2014-10-07 09:53:51,405 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-253])
* WARN  2014-10-07 09:53:52,107 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-271])
* ERROR 2014-10-07 09:53:52,122 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-271])
* WARN  2014-10-07 09:53:52,122 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-268])
* ERROR 2014-10-07 09:53:52,122 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-268])
* WARN  2014-10-07 09:54:07,411 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-261])
* ERROR 2014-10-07 09:54:07,411 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-261])
* WARN  2014-10-07 09:54:07,473 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-254])
* ERROR 2014-10-07 09:54:07,473 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-254])
Oct 07, 2014 9:54:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=245.5M,
memory.free=2.0M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=99.18%,
memory.used/max=
99.18%, load.process=9.00%, load.system=28.00%,
load.systemAverage=-100.00%, thr
ead.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
exec
utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
exec
utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executo
r.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.s
ize=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cli
entEndpoint.count=0, connection.active.count=0, connection.count=0
* WARN  2014-10-07 09:54:12,356 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-275])
* ERROR 2014-10-07 09:54:12,356 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-275])
* WARN  2014-10-07 09:54:13,183 SQL Error: 0, SQLState: 42703
(SqlExceptionHelpe
r.java [http-bio-8090-exec-276])
* ERROR 2014-10-07 09:54:13,183 ERROR: column "name" does not exist
  Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-276])
Oct 07, 2014 9:54:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.1M,
memory.free=1.4M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=99.44%,
memory.used/max=
99.44%, load.process=6.00%, load.system=9.00%, load.systemAverage=-100.00%,
thre
ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:54:47,191 Time: 4899 micros: Planned query, got: 2
for opt
imal: 2 (Timer.java [http-bio-8090-exec-261])
* INFO  2014-10-07 09:54:47,191 Time: 5940 micros: Analytics SQL: select
"de","q
uarterly","co", sum(value) as value from analytics_2014 where "de" in
('r5lK6gKH
VIk') and "quarterly" in ('2014Q3') and ( "uidlevel4" in ('bnSZVWSL22d') )
group
 by "de","quarterly","co" (Timer.java [SimpleAsyncTaskExecutor-250])
* INFO  2014-10-07 09:54:47,191 Time: 5942 micros: Analytics SQL: select
"de","q
uarterly","co", sum(value) as value from analytics_2014 where "de" in
('fWfA7xwR
TG4') and "quarterly" in ('2014Q3') and ( "uidlevel4" in ('bnSZVWSL22d') )
group
 by "de","quarterly","co" (Timer.java [SimpleAsyncTaskExecutor-249])
* INFO  2014-10-07 09:54:47,191 Time: 13020 micros: Got aggregated values
for qu
ery group (Timer.java [http-bio-8090-exec-261])
* INFO  2014-10-07 09:54:47,191 Time: 13350 micros: Got aggregated values
(Timer
.java [http-bio-8090-exec-261])
Oct 07, 2014 9:55:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=239.0M,
memory.free=8.5M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=96.57%,
memory.used/max=
96.57%, load.process=7.00%, load.system=12.00%,
load.systemAverage=-100.00%, thr
ead.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
exec
utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
exec
utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executo
r.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.s
ize=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cli
entEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:55:29,326 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
* INFO  2014-10-07 09:55:29,326 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
* INFO  2014-10-07 09:55:30,153 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
* INFO  2014-10-07 09:55:30,153 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
Oct 07, 2014 9:55:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=245.7M,
memory.free=1.8M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=99.26%,
memory.used/max=
99.26%, load.process=4.00%, load.system=4.00%, load.systemAverage=-100.00%,
thre
ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:55:44,895 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
* INFO  2014-10-07 09:55:44,895 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])
Oct 07, 2014 9:56:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.7M,
memory.free=817.4K,
memory.total=247.5M, memory.max=247.5M, memory.used/total=99.68%,
memory.used/ma
x=99.68%, load.process=4.00%, load.system=5.00%,
load.systemAverage=-100.00%, th
read.count=58, thread.peakCount=67, event.q.size=0,
executor.q.async.size=0, exe
cutor.q.client.size=0, executor.q.operation.size=0,
executor.q.query.size=0, exe
cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
execut
or.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.
size=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cl
ientEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:56:11,493 'monirath' update
org.hisp.dhis.message.MessageC
onversation, name: Form registered as complete, uid: Y0dztZ4G9h3
(AuditLogUtil.j
ava [http-bio-8090-exec-274])
Oct 07, 2014 9:56:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M,
memory.free=3.9M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=98.41%,
memory.used/max=
98.41%, load.process=4.00%, load.system=7.00%, load.systemAverage=-100.00%,
thre
ad.count=59, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:56:41,102 'monirath' update
org.hisp.dhis.message.MessageC
onversation, name: Form registered as complete, uid: OaNaZJvhc42
(AuditLogUtil.j
ava [http-bio-8090-exec-277])
Oct 07, 2014 9:57:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M,
memory.free=3.9M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=98.42%,
memory.used/max=
98.42%, load.process=6.00%, load.system=7.00%, load.systemAverage=-100.00%,
thre
ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
Oct 07, 2014 9:57:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.5M,
memory.free=998.3K,
memory.total=247.5M, memory.max=247.5M, memory.used/total=99.61%,
memory.used/ma
x=99.61%, load.process=3.00%, load.system=5.00%,
load.systemAverage=-100.00%, th
read.count=59, thread.peakCount=67, event.q.size=0,
executor.q.async.size=0, exe
cutor.q.client.size=0, executor.q.operation.size=0,
executor.q.query.size=0, exe
cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
execut
or.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.
size=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cl
ientEndpoint.count=0, connection.active.count=0, connection.count=0
Oct 07, 2014 9:58:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=241.5M,
memory.free=6.0M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=97.60%,
memory.used/max=
97.60%, load.process=3.00%, load.system=5.00%, load.systemAverage=-100.00%,
thre
ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
Oct 07, 2014 9:58:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.7M,
memory.free=824.1K,
memory.total=247.5M, memory.max=247.5M, memory.used/total=99.67%,
memory.used/ma
x=99.67%, load.process=1.00%, load.system=2.00%,
load.systemAverage=-100.00%, th
read.count=55, thread.peakCount=67, event.q.size=0,
executor.q.async.size=0, exe
cutor.q.client.size=0, executor.q.operation.size=0,
executor.q.query.size=0, exe
cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
execut
or.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.
size=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cl
ientEndpoint.count=0, connection.active.count=0, connection.count=0
Oct 07, 2014 9:59:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M,
memory.free=3.9M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=98.42%,
memory.used/max=
98.42%, load.process=2.00%, load.system=3.00%, load.systemAverage=-100.00%,
thre
ad.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:59:21,657 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:21,657 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:37,632 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:37,632 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:37,850 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:37,850 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:38,490 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:38,505 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
Oct 07, 2014 9:59:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=247.4M,
memory.free=104.1K,
memory.total=247.5M, memory.max=247.5M, memory.used/total=99.96%,
memory.used/ma
x=99.96%, load.process=6.00%, load.system=7.00%,
load.systemAverage=-100.00%, th
read.count=63, thread.peakCount=67, event.q.size=0,
executor.q.async.size=0, exe
cutor.q.client.size=0, executor.q.operation.size=0,
executor.q.query.size=0, exe
cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
execut
or.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.
size=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cl
ientEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 09:59:41,563 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
* INFO  2014-10-07 09:59:41,563 'monirath' update org.hisp.dhis.user.User,
name:
 Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])
Oct 07, 2014 10:00:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=244.1M,
memory.free=3.4M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=98.63%,
memory.used/max=
98.63%, load.process=5.00%, load.system=8.00%, load.systemAverage=-100.00%,
thre
ad.count=61, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executor
.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,
clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
Oct 07, 2014 10:00:38 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.2M,
memory.free=4.3M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=98.28%,
memory.used/max=
98.28%, load.process=3.00%, load.system=23.00%,
load.systemAverage=-100.00%, thr
ead.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0,
exec
utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0,
exec
utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
executo
r.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.s
ize=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cli
entEndpoint.count=0, connection.active.count=0, connection.count=0
* INFO  2014-10-07 10:00:56,568 Time: 169056 micros: Planned query, got: 2
for o
ptimal: 2 (Timer.java [http-bio-8090-exec-281])
* INFO  2014-10-07 10:00:57,239 Time: 671012 micros: Analytics SQL: select
"de",
"quarterly","co", count(value) as value from analytics_2013 where "de" in
('ICeY
pwt7W5t', 'JXDqUWrV5sD') and "quarterly" in ('2013Q4') and ( "uidlevel4" in
('CK
Gb2dyPIJo', 'dOfq5Zel7JX', 'UaUc8I3yulh', 'bnSZVWSL22d', 'wHnxr0phFAW',
'viDS7KX
BI9C', 'kENhsoPS3Qx', 'm4T7WgRZMwU', 'ueuTAu08VFm', 'NcA7HpabeAG',
'pqiEmgwvCBH'
) ) group by "de","quarterly","co" (Timer.java
[SimpleAsyncTaskExecutor-251])
* INFO  2014-10-07 10:00:57,239 Time: 5340 micros: Analytics SQL: select
"de","q
uarterly","co", count(value) as value from analytics_2014 where "de" in
('ICeYpw
t7W5t', 'JXDqUWrV5sD') and "quarterly" in ('2014Q1', '2014Q2', '2014Q3')
and ( "
uidlevel4" in ('CKGb2dyPIJo', 'dOfq5Zel7JX', 'UaUc8I3yulh', 'bnSZVWSL22d',
'wHnx
r0phFAW', 'viDS7KXBI9C', 'kENhsoPS3Qx', 'm4T7WgRZMwU', 'ueuTAu08VFm',
'NcA7Hpabe
AG', 'pqiEmgwvCBH') ) group by "de","quarterly","co" (Timer.java
[SimpleAsyncTas
kExecutor-252])
* INFO  2014-10-07 10:00:57,239 Time: 845567 micros: Got aggregated values
for q
uery group (Timer.java [http-bio-8090-exec-281])
* INFO  2014-10-07 10:00:57,254 Time: 10313 micros: Analytics SQL: select
"de","
quarterly","co", sum(value) as value from analytics_2013 where "de" in
('ASE0LsK
W5yx', 'AdxXFiuT4ds', 'B6p7ZNxgHxX', 'BvQ9ct1BR9i', 'EagukoGVYRx',
'Egvu3JhgZ9r'
, 'Et6FyKI17tb', 'FpXFSK0z1dV', 'Frx2wCQ0RZ2', 'GS1vpkwJyKF',
'GTEDgGAYgi3', 'He
XWKbx3xM5', 'IGCk1kicxd2', 'JxXQqqC6nHJ', 'KmCxPICselB', 'KnC6r5Jx9MH',
'KpXrktb
pIPZ', 'KrF22w0QLOg', 'MLBX3LNp4BW', 'NlOYmuaFXhA', 'ORy65ZftRl7',
'OavkximffAT'
, 'OfN7SyKwl6F', 'Q4fH8Ov0qBt', 'SCUxZJa8s1M', 'SHB83dnAXon',
'SwlzUkEwybz', 'TP
c9REyjhdF', 'VZAOnp7tn2M', 'VedULjSQITK', 'Vm4MXcAtkNn', 'Vx62oP4B62Y',
'Yk37wIK
PeYL', 'Z9xaFOIPis7', 'ZAWQzoSeWeu', 'ZTn7rMjYyjL', 'a4uMRdX4SC5',
'awQjo0yweto'
, 'b9JbYwXroJQ', 'cGIuOhoZLgT', 'e4RYfrqQNtH', 'eKvnnHplSW4',
'eUgwd3eNeBz', 'fW
fA7xwRTG4', 'ftSpVssjwq5', 'gDXNp6PIec6', 'gKwRVc5UoPS', 'gZqMsTLrVYV',
'jNPSW9q
aOqn', 'jjIm1pZDbxJ', 'k13DzYw5tkc', 'k58e28uaZpp', 'knttBc4QYLG',
'lH0abYcMY4y'
, 'lsTdXf9QS9U', 'm1wS2Sxfhms', 'odx86VOvLqu', 'os6Zcumjuwu',
'qGzKX4dceXT', 'r5
lK6gKHVIk', 's1RMwbGvvmv', 'sWhIjX0qBih', 't5twhkjlwat', 'tO3yjpnvgru',
'tUygFmp
vFTR', 'tYH9IFLI1SP', 'tawurdhoN2l', 'ubN8Qd3GaLU', 'wUDSzbKNZjK',
'wbEXAQRyXQk'
, 'x56tt8GvJcm', 'y79651p6nRH', 'yHPDSpuFc8J', 'yxE75KH3smz',
'zH0mWe4ZcsG', 'zZ
ZHoeeYVg0') and "quarterly" in ('2013Q4') and ( "uidlevel4" in
('CKGb2dyPIJo', '
dOfq5Zel7JX', 'UaUc8I3yulh', 'bnSZVWSL22d', 'wHnxr0phFAW', 'viDS7KXBI9C',
'kENhs
oPS3Qx', 'm4T7WgRZMwU', 'ueuTAu08VFm', 'NcA7HpabeAG', 'pqiEmgwvCBH') )
group by
"de","quarterly","co" (Timer.java [SimpleAsyncTaskExecutor-253])
* INFO  2014-10-07 10:00:57,254 Time: 14741 micros: Analytics SQL: select
"de","
quarterly","co", sum(value) as value from analytics_2014 where "de" in
('ASE0LsK
W5yx', 'AdxXFiuT4ds', 'B6p7ZNxgHxX', 'BvQ9ct1BR9i', 'EagukoGVYRx',
'Egvu3JhgZ9r'
, 'Et6FyKI17tb', 'FpXFSK0z1dV', 'Frx2wCQ0RZ2', 'GS1vpkwJyKF',
'GTEDgGAYgi3', 'He
XWKbx3xM5', 'IGCk1kicxd2', 'JxXQqqC6nHJ', 'KmCxPICselB', 'KnC6r5Jx9MH',
'KpXrktb
pIPZ', 'KrF22w0QLOg', 'MLBX3LNp4BW', 'NlOYmuaFXhA', 'ORy65ZftRl7',
'OavkximffAT'
, 'OfN7SyKwl6F', 'Q4fH8Ov0qBt', 'SCUxZJa8s1M', 'SHB83dnAXon',
'SwlzUkEwybz', 'TP
c9REyjhdF', 'VZAOnp7tn2M', 'VedULjSQITK', 'Vm4MXcAtkNn', 'Vx62oP4B62Y',
'Yk37wIK
PeYL', 'Z9xaFOIPis7', 'ZAWQzoSeWeu', 'ZTn7rMjYyjL', 'a4uMRdX4SC5',
'awQjo0yweto'
, 'b9JbYwXroJQ', 'cGIuOhoZLgT', 'e4RYfrqQNtH', 'eKvnnHplSW4',
'eUgwd3eNeBz', 'fW
fA7xwRTG4', 'ftSpVssjwq5', 'gDXNp6PIec6', 'gKwRVc5UoPS', 'gZqMsTLrVYV',
'jNPSW9q
aOqn', 'jjIm1pZDbxJ', 'k13DzYw5tkc', 'k58e28uaZpp', 'knttBc4QYLG',
'lH0abYcMY4y'
, 'lsTdXf9QS9U', 'm1wS2Sxfhms', 'odx86VOvLqu', 'os6Zcumjuwu',
'qGzKX4dceXT', 'r5
lK6gKHVIk', 's1RMwbGvvmv', 'sWhIjX0qBih', 't5twhkjlwat', 'tO3yjpnvgru',
'tUygFmp
vFTR', 'tYH9IFLI1SP', 'tawurdhoN2l', 'ubN8Qd3GaLU', 'wUDSzbKNZjK',
'wbEXAQRyXQk'
, 'x56tt8GvJcm', 'y79651p6nRH', 'yHPDSpuFc8J', 'yxE75KH3smz',
'zH0mWe4ZcsG', 'zZ
ZHoeeYVg0') and "quarterly" in ('2014Q1', '2014Q2', '2014Q3') and (
"uidlevel4"
in ('CKGb2dyPIJo', 'dOfq5Zel7JX', 'UaUc8I3yulh', 'bnSZVWSL22d',
'wHnxr0phFAW', '
viDS7KXBI9C', 'kENhsoPS3Qx', 'm4T7WgRZMwU', 'ueuTAu08VFm', 'NcA7HpabeAG',
'pqiEm
gwvCBH') ) group by "de","quarterly","co" (Timer.java
[SimpleAsyncTaskExecutor-2
54])
* INFO  2014-10-07 10:00:57,270 Time: 867890 micros: Got aggregated values
for q
uery group (Timer.java [http-bio-8090-exec-281])
* INFO  2014-10-07 10:00:57,270 Time: 868337 micros: Got aggregated values
(Time
r.java [http-bio-8090-exec-281])
Oct 07, 2014 10:01:08 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=241.6M,
memory.free=5.9M, me
mory.total=247.5M, memory.max=247.5M, memory.used/total=97.61%,
memory.used/max=
97.61%, load.process=13.00%, load.system=45.00%,
load.systemAverage=-100.00%, th
read.count=56, thread.peakCount=67, event.q.size=0,
executor.q.async.size=0, exe
cutor.q.client.size=0, executor.q.operation.size=0,
executor.q.query.size=0, exe
cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0,
execut
or.q.operation.size=0, executor.q.priorityOperation.size=0,
executor.q.response.
size=0, operations.remote.size=0, operations.running.size=0,
proxy.count=195, cl
ientEndpoint.count=0, connection.active.count=0, connection.count=0

------------------------------------------------------------------------------------------------