dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Hi All,

We are using DHIS2 2.19 and it was working really fine for several months.
We have followed the HISP recommendations for the JVM parameters and the
PostgreSQL memory tunning. We noticed few days ago a slow access to our
DHIS2 server on Amazon from web version as well as from data capture. When
checking the status, the server CPU is constantly running at 100%. We would
like to have your advice on the possible sources of the errors. I note that
Amazon has upgraded the Linux system to a newer version (2016.03). Does
this change have impact on the installation of Tomact and postgreSQL? I am
attaching the DHIS2 log file which is containing several errors.

We are stuck, your help are welcome!

Regards,

Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*

* ERROR 2016-09-12 00:45:52,280 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:45:52,562 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6540])
* ERROR 2016-09-12 00:45:56,789 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:46:09,773 Data value import done, total: 558, import: 0, update: 69 (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* ERROR 2016-09-12 00:46:10,458 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6551])
* ERROR 2016-09-12 00:46:15,648 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6551])
* ERROR 2016-09-12 00:46:42,437 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6546])
* ERROR 2016-09-12 00:46:47,430 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6546])
* INFO  2016-09-12 00:46:49,986 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:56,088 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:46:59,184 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:47:00,903 Data value import done, total: 558, import: 0, update: 97 (DefaultDataValueSetService.java [http-bio-8080-exec-6540])
* ERROR 2016-09-12 00:47:34,676 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:37,250 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:49,313 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6525])
* ERROR 2016-09-12 00:47:52,326 Initialised statement manager (StatementInterceptor.java [http-bio-8080-exec-6525])
* INFO  2016-09-12 00:47:57,969 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:06,793 Data value import done, total: 558, import: 0, update: 207 (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:48:09,247 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:09,247 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:09,248 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:48:11,954 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:49:11,426 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15,672 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15,673 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:15,673 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:18,789 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:49:30,100 Data value import done, total: 420, import: 0, update: 34 (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:17,466 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:22,449 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:22,449 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:22,450 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:25,534 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:50:36,414 Data value import done, total: 420, import: 0, update: 42 (DefaultDataValueSetService.java [http-bio-8080-exec-6544])
* INFO  2016-09-12 00:51:23,647 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6550])
* INFO  2016-09-12 00:51:27,487 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6550])
* INFO  2016-09-12 00:51:27,488 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6550])
* INFO  2016-09-12 00:51:27,488 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6550])
* INFO  2016-09-12 00:51:30,580 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6550])
* INFO  2016-09-12 00:51:45,030 Data value import done, total: 420, import: 0, update: 35 (DefaultDataValueSetService.java [http-bio-8080-exec-6547])
* INFO  2016-09-12 00:52:29,074 Login success for user: 'dhis120asos10', ip: '172.31.14.22' (DefaultUserAuditService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:52:33,309 Import options: [Id scheme: null, data element id scheme: null, org unit id scheme: null, dry run: false, preheat cache: true, async: false, strategy: null, skip check: false] (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:52:33,310 Data value set scheme: null, data element scheme: null, org unit scheme: null (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:52:33,310 Scheme: UID, data element scheme: UID, org unit scheme: UID (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:52:37,909 Importing data values (DefaultDataValueSetService.java [http-bio-8080-exec-6535])
* INFO  2016-09-12 00:52:49,025 Data value import done, total: -®éÜjם~Šæ¡×«jب