dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #44413
Re: [Bug 1567901] Re: Analytics Indexing Failure - long text
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@xxxxxxxxx> 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.
>
> ** Changed in: dhis2
> Status: New => Fix Committed
>
> --
> 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:
> Fix Committed
>
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
--
*******************************************
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedberg@xxxxxxxxx
Skype: calle_hedberg
*******************************************
Follow ups
References