dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Calle,

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@xxxxxxxxx>
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@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
>
> *******************************************
>
>
> _______________________________________________
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org/>