dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #44343
[Bug 1567901] [NEW] Analytics Indexing Failure - long text
Public bug reported:
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
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1567901
Title:
Analytics Indexing Failure - long text
Status in DHIS:
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.
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1567901/+subscriptions
Follow ups