DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
···
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
** Affects: dhis2
Importance: Undecided
Status: New
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
Think I agree here. We could skip indexing of non-aggregateable data
elements/attributes per now entirely (including text value type) as we
cannot do analytics on it.
We could look into text indexing (lucene) but that is for later.
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
Impl a fix in trunk (2.23-SNAPSHOT) where data elements and attributes
with value type LONG_TEXT and without option sets are not indexed in the
event analytics tables.
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
java.lang.RuntimeException: Exception during execution
…
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index “in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ” on analytics_event_temp_1980_dvqwq9jgpn8 (“ciWR6s18VWH”)]; ERROR: index row size 3512 exceeds maximum 2712 for index “in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ”
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.
in this case we have refactored much the analytics table generation code,
so back-porting means a completely new fix, so I think we will not this
right now. 2.23 will be out very shortly, hopefully you can upgrade to 2.23
to resolve this.
regards,
Lars
···
On Wed, Apr 13, 2016 at 11:25 AM, Calle Hedberg <calle.hedberg@gmail.com> wrote:
Lars,
Thanks for fixing this - any chance of the fix being backported to 2.22
and/or 2.21?
Regards
Calle
On 12 April 2016 at 18:54, Lars Helge Øverland <lars@dhis2.org> wrote:
Impl a fix in trunk (2.23-SNAPSHOT) where data elements and attributes
with value type LONG_TEXT and without option sets are not indexed in the
event analytics tables.
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails,
returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException:
org.springframework.dao.DataAccessResourceFailureException:
StatementCallback; SQL [create index
"in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on
analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row
size 3512 exceeds maximum 2712 for index
"in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu
14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a
set-length of some part of the string for the purposes of indexing.
Bug description:
DHIS 2.21 when performing an analytics update, analytics fails, returning the error:
-----------------------------------------------------------------------
* ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
...
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ"
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
-----------------------------------------------------------------------
Notes:
This has not been checked on 2.22.
This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8.
Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing.