ERROR: Hammertime

Support - Assistance technique
1

Is this familiar to anyone? Getting this error using latest trunk and 2.23

dhis2-database | ERROR: Hammertime!

dhis2-database | STATEMENT: update users set uid=$1, code=$2, created=$3, lastUpdated=$4, creatoruserid=$5, username=$6, password=$7, externalauth=$8, openid=$9, ldapid=$10, passwordLastUpdated=$11, lastLogin=$12, restoreToken=$13, restoreCode=$14, restoreExpiry=$15, selfRegistered=$16, invitation=$17, disabled=$18 where userid=$19

dhis2-database | ERROR: current transaction is aborted, commands ignored until end of transaction block

dhis2-database | STATEMENT: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ ‘^pg_’ OR n.nspname = ‘information_schema’ WHEN true THEN CASE WHEN n.nspname = ‘pg_catalog’ OR n.nspname = ‘information_schema’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TABLE’ WHEN ‘v’ THEN ‘SYSTEM VIEW’ WHEN ‘i’ THEN ‘SYSTEM INDEX’ ELSE NULL END WHEN n.nspname = ‘pg_toast’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TOAST TABLE’ WHEN ‘i’ THEN ‘SYSTEM TOAST INDEX’ ELSE NULL END ELSE CASE c.relkind WHEN ‘r’ THEN ‘TEMPORARY TABLE’ WHEN ‘i’ THEN ‘TEMPORARY INDEX’ WHEN ‘S’ THEN ‘TEMPORARY SEQUENCE’ WHEN ‘v’ THEN ‘TEMPORARY VIEW’ ELSE NULL END END WHEN false THEN CASE c.relkind WHEN ‘r’ THEN ‘TABLE’ WHEN ‘i’ THEN ‘INDEX’ WHEN ‘S’ THEN ‘SEQUENCE’ WHEN ‘v’ THEN ‘VIEW’ WHEN ‘c’ THEN ‘TYPE’ WHEN ‘f’ THEN ‘FOREIGN TABLE’ WHEN ‘m’ THEN ‘MATERIALIZED VIEW’ ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname=‘pg_class’) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname=‘pg_catalog’) WHERE c.relnamespace = n.oid AND c.relname LIKE ‘PROBABLYNOT’ AND (false OR ( c.relkind = ‘r’ AND n.nspname !~ ‘^pg_’ AND n.nspname <> ‘information_schema’ ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME

dhis2-web | * WARN 2016-06-21 18:58:22,978 SQL Error: 0, SQLState: P0001 (SqlExceptionHelper.java [http-apr-8080-exec-10])

dhis2-web | * ERROR 2016-06-21 18:58:22,979 ERROR: Hammertime! (SqlExceptionHelper.java [http-apr-8080-exec-10])

2

Brilliant! :smiley:

It’s familiar to Jason. Are you running tests against the demo/dev databases?

We don’t allow the (admin) password to be changed on those instances. If you see it anywhere else then its an actual problem.

···

On Tue, Jun 21, 2016 at 9:00 PM, Paulo Grácio paulogracio@gmail.com wrote:

Is this familiar to anyone? Getting this error using latest trunk and 2.23

dhis2-database | ERROR: Hammertime!

dhis2-database | STATEMENT: update users set uid=$1, code=$2, created=$3, lastUpdated=$4, creatoruserid=$5, username=$6, password=$7, externalauth=$8, openid=$9, ldapid=$10, passwordLastUpdated=$11, lastLogin=$12, restoreToken=$13, restoreCode=$14, restoreExpiry=$15, selfRegistered=$16, invitation=$17, disabled=$18 where userid=$19

dhis2-database | ERROR: current transaction is aborted, commands ignored until end of transaction block

dhis2-database | STATEMENT: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ ‘^pg_’ OR n.nspname = ‘information_schema’ WHEN true THEN CASE WHEN n.nspname = ‘pg_catalog’ OR n.nspname = ‘information_schema’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TABLE’ WHEN ‘v’ THEN ‘SYSTEM VIEW’ WHEN ‘i’ THEN ‘SYSTEM INDEX’ ELSE NULL END WHEN n.nspname = ‘pg_toast’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TOAST TABLE’ WHEN ‘i’ THEN ‘SYSTEM TOAST INDEX’ ELSE NULL END ELSE CASE c.relkind WHEN ‘r’ THEN ‘TEMPORARY TABLE’ WHEN ‘i’ THEN ‘TEMPORARY INDEX’ WHEN ‘S’ THEN ‘TEMPORARY SEQUENCE’ WHEN ‘v’ THEN ‘TEMPORARY VIEW’ ELSE NULL END END WHEN false THEN CASE c.relkind WHEN ‘r’ THEN ‘TABLE’ WHEN ‘i’ THEN ‘INDEX’ WHEN ‘S’ THEN ‘SEQUENCE’ WHEN ‘v’ THEN ‘VIEW’ WHEN ‘c’ THEN ‘TYPE’ WHEN ‘f’ THEN ‘FOREIGN TABLE’ WHEN ‘m’ THEN ‘MATERIALIZED VIEW’ ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname=‘pg_class’) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname=‘pg_catalog’) WHERE c.relnamespace = n.oid AND c.relname LIKE ‘PROBABLYNOT’ AND (false OR ( c.relkind = ‘r’ AND n.nspname !~ ‘^pg_’ AND n.nspname <> ‘information_schema’ ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME

dhis2-web | * WARN 2016-06-21 18:58:22,978 SQL Error: 0, SQLState: P0001 (SqlExceptionHelper.java [http-apr-8080-exec-10])

dhis2-web | * ERROR 2016-06-21 18:58:22,979 ERROR: Hammertime! (SqlExceptionHelper.java [http-apr-8080-exec-10])

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Regards,

Mark Polak

Software developer, DHIS 2

University of Oslo

http://www.dhis2.org

mark@dhis2.org

3

I’m using sierra-leone database, guess I should ignore it then.

Thanks,

Paulo

···

On Tue, Jun 21, 2016 at 9:00 PM, Paulo Grácio paulogracio@gmail.com wrote:

Is this familiar to anyone? Getting this error using latest trunk and 2.23

dhis2-database | ERROR: Hammertime!

dhis2-database | STATEMENT: update users set uid=$1, code=$2, created=$3, lastUpdated=$4, creatoruserid=$5, username=$6, password=$7, externalauth=$8, openid=$9, ldapid=$10, passwordLastUpdated=$11, lastLogin=$12, restoreToken=$13, restoreCode=$14, restoreExpiry=$15, selfRegistered=$16, invitation=$17, disabled=$18 where userid=$19

dhis2-database | ERROR: current transaction is aborted, commands ignored until end of transaction block

dhis2-database | STATEMENT: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ ‘^pg_’ OR n.nspname = ‘information_schema’ WHEN true THEN CASE WHEN n.nspname = ‘pg_catalog’ OR n.nspname = ‘information_schema’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TABLE’ WHEN ‘v’ THEN ‘SYSTEM VIEW’ WHEN ‘i’ THEN ‘SYSTEM INDEX’ ELSE NULL END WHEN n.nspname = ‘pg_toast’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TOAST TABLE’ WHEN ‘i’ THEN ‘SYSTEM TOAST INDEX’ ELSE NULL END ELSE CASE c.relkind WHEN ‘r’ THEN ‘TEMPORARY TABLE’ WHEN ‘i’ THEN ‘TEMPORARY INDEX’ WHEN ‘S’ THEN ‘TEMPORARY SEQUENCE’ WHEN ‘v’ THEN ‘TEMPORARY VIEW’ ELSE NULL END END WHEN false THEN CASE c.relkind WHEN ‘r’ THEN ‘TABLE’ WHEN ‘i’ THEN ‘INDEX’ WHEN ‘S’ THEN ‘SEQUENCE’ WHEN ‘v’ THEN ‘VIEW’ WHEN ‘c’ THEN ‘TYPE’ WHEN ‘f’ THEN ‘FOREIGN TABLE’ WHEN ‘m’ THEN ‘MATERIALIZED VIEW’ ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname=‘pg_class’) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname=‘pg_catalog’) WHERE c.relnamespace = n.oid AND c.relname LIKE ‘PROBABLYNOT’ AND (false OR ( c.relkind = ‘r’ AND n.nspname !~ ‘^pg_’ AND n.nspname <> ‘information_schema’ ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME

dhis2-web | * WARN 2016-06-21 18:58:22,978 SQL Error: 0, SQLState: P0001 (SqlExceptionHelper.java [http-apr-8080-exec-10])

dhis2-web | * ERROR 2016-06-21 18:58:22,979 ERROR: Hammertime! (SqlExceptionHelper.java [http-apr-8080-exec-10])

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Regards,

Mark Polak

Software developer, DHIS 2

University of Oslo

http://www.dhis2.org

mark@dhis2.org

4

Uhh, yeah, sorry about that Paulo. We have had some issues with people changing the password on the demo servers, so have put some measures in place to prevent this.

If you want to be able to change the password, just execute these command on the database.

DROP TRIGGER IF EXISTS prevent_changing_password ON users;

DROP FUNCTION IF EXISTS cant_touch_this();

Regards,

Jason

···

On Tue, Jun 21, 2016, 21:00 Paulo Grácio paulogracio@gmail.com wrote:

Is this familiar to anyone? Getting this error using latest trunk and 2.23

dhis2-database | ERROR: Hammertime!

dhis2-database | STATEMENT: update users set uid=$1, code=$2, created=$3, lastUpdated=$4, creatoruserid=$5, username=$6, password=$7, externalauth=$8, openid=$9, ldapid=$10, passwordLastUpdated=$11, lastLogin=$12, restoreToken=$13, restoreCode=$14, restoreExpiry=$15, selfRegistered=$16, invitation=$17, disabled=$18 where userid=$19

dhis2-database | ERROR: current transaction is aborted, commands ignored until end of transaction block

dhis2-database | STATEMENT: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ ‘^pg_’ OR n.nspname = ‘information_schema’ WHEN true THEN CASE WHEN n.nspname = ‘pg_catalog’ OR n.nspname = ‘information_schema’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TABLE’ WHEN ‘v’ THEN ‘SYSTEM VIEW’ WHEN ‘i’ THEN ‘SYSTEM INDEX’ ELSE NULL END WHEN n.nspname = ‘pg_toast’ THEN CASE c.relkind WHEN ‘r’ THEN ‘SYSTEM TOAST TABLE’ WHEN ‘i’ THEN ‘SYSTEM TOAST INDEX’ ELSE NULL END ELSE CASE c.relkind WHEN ‘r’ THEN ‘TEMPORARY TABLE’ WHEN ‘i’ THEN ‘TEMPORARY INDEX’ WHEN ‘S’ THEN ‘TEMPORARY SEQUENCE’ WHEN ‘v’ THEN ‘TEMPORARY VIEW’ ELSE NULL END END WHEN false THEN CASE c.relkind WHEN ‘r’ THEN ‘TABLE’ WHEN ‘i’ THEN ‘INDEX’ WHEN ‘S’ THEN ‘SEQUENCE’ WHEN ‘v’ THEN ‘VIEW’ WHEN ‘c’ THEN ‘TYPE’ WHEN ‘f’ THEN ‘FOREIGN TABLE’ WHEN ‘m’ THEN ‘MATERIALIZED VIEW’ ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname=‘pg_class’) LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname=‘pg_catalog’) WHERE c.relnamespace = n.oid AND c.relname LIKE ‘PROBABLYNOT’ AND (false OR ( c.relkind = ‘r’ AND n.nspname !~ ‘^pg_’ AND n.nspname <> ‘information_schema’ ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME

dhis2-web | * WARN 2016-06-21 18:58:22,978 SQL Error: 0, SQLState: P0001 (SqlExceptionHelper.java [http-apr-8080-exec-10])

dhis2-web | * ERROR 2016-06-21 18:58:22,979 ERROR: Hammertime! (SqlExceptionHelper.java [http-apr-8080-exec-10])

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp