[Openbravo-builds] int-checks-pgsql - Build # 4176 - Unstable!

[jen...@ci.openbravo.com]

int-checks-pgsql - Build # 4176 - Unstable:

Check console output at https://ci.openbravo.com/job/int-checks-pgsql/4176/ to view the results.


Committers since last success:

Changes for Build #4176

Asier Lostalé <asier....@openbravo.com> null
fixed bug 40843: update.database fails with PostgreSQL 12

It failed because we made use of pg_attrdef.adsrc which was deprecated for a
long time and has been removed in 12.

Replaced its use by pg_get_expr which is present in all PG supported versions.
src-db/database/lib/dbsourcemanager.jar

Asier Lostalé <asier....@openbravo.com> null
fixed bug 40842: install.source fails with PostgreSQL 12

It was failing on prescript creation as it makes use of two columns that have
been removed in PostgreSQL 12 (pg_attrdef.adsrc, pg_constraint.consrc).

They have been replaced by pg_get_expr and pg_get_constraintdef functions which
are present in all supported PG versions.
src-db/database/model/prescript-PostgreSql.sql




Last 20 lines of the console output:

[...truncated 14357 lines...]
[ "$(jps | grep Bootstrap || true)" != "" ] && echo "Tomcat has fail to stop" && exit 1 || true
[ "$i" != "0" ] && secs=$(echo "$i * 5" | bc) && echo "Waiting for $secs secs for tomcat to stop"

echo
fi

[int-checks-pgsql] $ /bin/bash -xe /tmp/hudson3159823028623622173.sh
++ grep Bootstrap
++ jps
++ true
+ '[' '' '!=' '' ']'
POST BUILD TASK : SUCCESS
END OF POST BUILD TASK : 1
Archiving artifacts
Checking ERROR(?!: Failed to pull)|syntax error at or near|SQL error in query|WARNING in
Recording test results
Build step 'Publish JUnit test result report' changed build result to UNSTABLE
Email was triggered for: Unstable (Test Failures)
Sending email for trigger: Unstable (Test Failures)

[jen...@ci.openbravo.com]

int-checks-pgsql - Build # 4177 - Fixed:

Check console output at https://ci.openbravo.com/job/int-checks-pgsql/4177/ to view the results.

Committers since last success:

Changes for Build #4176

Asier Lostalé <asier....@openbravo.com> null
fixed bug 40843: update.database fails with PostgreSQL 12

It failed because we made use of pg_attrdef.adsrc which was deprecated for a
long time and has been removed in 12.

Replaced its use by pg_get_expr which is present in all PG supported versions.
src-db/database/lib/dbsourcemanager.jar

Asier Lostalé <asier....@openbravo.com> null
fixed bug 40842: install.source fails with PostgreSQL 12

It was failing on prescript creation as it makes use of two columns that have
been removed in PostgreSQL 12 (pg_attrdef.adsrc, pg_constraint.consrc).

They have been replaced by pg_get_expr and pg_get_constraintdef functions which
are present in all supported PG versions.
src-db/database/model/prescript-PostgreSql.sql

Changes for Build #4177

Asier Lostalé <asier....@openbravo.com> null
related to issue 40842: fixes dba_getstandard_search_text

pg_get_constraintdef includes "CHECK()" to check conditions, remove it to keep
backwards compatibility

src-db/database/model/prescript-PostgreSql.sql




Last 20 lines of the console output:

[...truncated 14356 lines...]

[ "$(jps | grep Bootstrap || true)" != "" ] && echo "Tomcat has fail to stop" && exit 1 || true
[ "$i" != "0" ] && secs=$(echo "$i * 5" | bc) && echo "Waiting for $secs secs for tomcat to stop"

echo
fi

[int-checks-pgsql] $ /bin/bash -xe /tmp/hudson952265201964724781.sh
++ jps
++ grep Bootstrap

++ true
+ '[' '' '!=' '' ']'
POST BUILD TASK : SUCCESS
END OF POST BUILD TASK : 1
Archiving artifacts
Checking ERROR(?!: Failed to pull)|syntax error at or near|SQL error in query|WARNING in
Recording test results

Email was triggered for: Fixed
Trigger Success was overridden by another trigger and will not send an email.
Sending email for trigger: Fixed