You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@eagle.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/05/04 00:02:12 UTC
[jira] [Commented] (EAGLE-291) JDBC: Update transactions fail in
PostgreSQL
[ https://issues.apache.org/jira/browse/EAGLE-291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269697#comment-15269697 ]
ASF GitHub Bot commented on EAGLE-291:
--------------------------------------
GitHub user Jashchahal opened a pull request:
https://github.com/apache/incubator-eagle/pull/174
EAGLE-291 : JDBC: Update transactions fail in PostgreSQL
The transactions in Postgres was failing due to insert fail transaction already in progress and we were trying to update if insert fails. Need to rollback the failed insert transaction and then continue with update transaction. Postgres is more strict as compared to MySql, so we need save point so that we can roll it back, if required.
Had to revert changes for EAGLE-270, as @haoch mentioned that we can't compare between mediumtexts, it need to be varchar.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Jashchahal/incubator-eagle master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-eagle/pull/174.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #174
----
commit 002088db65194e6cafc2b637d7aaef89708f4225
Author: Jaspaul <ja...@gmail.com>
Date: 2016-04-06T00:32:26Z
EAGLE-213 Updates fail for MySql
There was a check based on the exception message, which was not correct
for MySql. Changed it to more generic, comparing with "duplicate", it will handle
more broader range now.
commit 085d6b31075f4c9c2a00a071995b65e6ff67ee52
Author: Jaspaul <ja...@gmail.com>
Date: 2016-04-18T17:36:43Z
Merge remote-tracking branch 'upstream/master'
commit 9c9c1ae156b9cf0aedf6e59730d1635b7e1b0b6b
Author: Jaspaul <ja...@gmail.com>
Date: 2016-04-18T17:56:55Z
[EAGLE-270] JDBC: Create table fail for some of the tables
commit 3ed5a8dfc68e353b39b05c9a67fa19e56cc3a9e4
Author: Jaspaul <ja...@gmail.com>
Date: 2016-05-03T21:20:25Z
Merge remote-tracking branch 'upstream/master'
commit 85529dfd7023ba7632123baa13314713605ab480
Author: Jaspaul <ja...@gmail.com>
Date: 2016-05-03T21:43:04Z
EAGLE-291 : JDBC: Update transactions fail in PostgreSQL
----
> JDBC: Update transactions fail in PostgreSQL
> --------------------------------------------
>
> Key: EAGLE-291
> URL: https://issues.apache.org/jira/browse/EAGLE-291
> Project: Eagle
> Issue Type: Bug
> Affects Versions: v0.3.0
> Environment: Linux, PostgreSQL 9.1 as metadata store.
> Reporter: Jaspaul Chahal
> Fix For: v0.4.0
>
>
> When it tries to update some entity, throws the following exception:
> org.apache.torque.TorqueException: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)