airavata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus Christie (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (AIRAVATA-2376) Duplicating experiment records in Experiment statistics and Experiment browse
Date Wed, 14 Jun 2017 15:51:00 GMT

    [ https://issues.apache.org/jira/browse/AIRAVATA-2376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16047902#comment-16047902
] 

Marcus Christie edited comment on AIRAVATA-2376 at 6/14/17 3:50 PM:
--------------------------------------------------------------------

I've got this working now by using the MariaDB jar.  Since [version 1.1.8|https://mariadb.com/kb/en/mariadb/mariadb-java-client-118-changelog/]
the MariaDB JDBC driver defaults to using fractional seconds.  So the solution required two
changes:
* update the column as in the previous comment
* switch to using the MariaDB JDBC jar

Still to do:
* (/) update Ansible scripts to create a airavata-server.properties with mariadb JDBC driver
* (/) also update Ansible scripts to download the MariaDB JDBC driver and remove the MySQL
JDBC driver

----

This is done now and I've merged my branch to develop but I want to test it as part of the
dev migration to Jetstream before being putting this into production.


was (Author: marcuschristie):
I've got this working now by using the MariaDB jar.  Since [version 1.1.8|https://mariadb.com/kb/en/mariadb/mariadb-java-client-118-changelog/]
the MariaDB JDBC driver defaults to using fractional seconds.  So the solution required two
changes:
* update the column as in the previous comment
* switch to using the MariaDB JDBC jar

Still to do:
* (/) update Ansible scripts to create a airavata-server.properties with mariadb JDBC driver
* (/) also update Ansible scripts to download the MariaDB JDBC driver and remove the MySQL
JDBC driver
----

This is done now and I've merged my branch to develop but I want to test it as part of the
dev migration to Jetstream before being putting this into production.

> Duplicating experiment records in Experiment statistics and Experiment browse
> -----------------------------------------------------------------------------
>
>                 Key: AIRAVATA-2376
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-2376
>             Project: Airavata
>          Issue Type: Bug
>          Components: PGA PHP Web Gateway, Registry API
>    Affects Versions: 0.17
>         Environment: https://seagrid.org and all other gateways as well
>            Reporter: Eroma
>            Assignee: Marcus Christie
>            Priority: Critical
>             Fix For: 0.17
>
>
> When experiments are launched there are two records in EXPERIMENT SUMMARY table for LAUNCHED
and EXECUTING state which has the exact same state change time. In PGA however two records
show up for the same experiment and with same status. e.g.: two exact records for a single
experiment. This only appears until the experiment is FAILED or COMPLETED. But both users
and gateway admins notices this and this needs fixing. 
> h3. Resources
> * MySQL JDBC driver configuration:
> ** https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
> ** uses sendFractionalSeconds
> ** added in [MySQL Connector/J 5.1.37|https://docs.oracle.com/cd/E17952_01/connector-j-relnotes-en/news-5-1-37.html]
> * https://issues.apache.org/jira/browse/OPENJPA-2159
> * MariaDB JDBC driver configuration:
> ** https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/
> ** uses useFractionalSeconds
> * MariaDB JDBC driver defaults to useFractionalSeconds as true since 1.1.8
> ** https://mariadb.com/kb/en/mariadb/mariadb-java-client-118-changelog/
> * [MariaDB TIMESTAMP|https://mariadb.com/kb/en/mariadb/timestamp/]
> * [Microseconds in MariaDB|https://mariadb.com/kb/en/mariadb/microseconds-in-mariadb/]
> * How to specify TIMESTAMP precision in JPA annotations?
> ** [Confused why they seem to use scale instead of precision in OpenJPA|https://issues.apache.org/jira/browse/OPENJPA-2555]
> * [Supporting evidence that we need to use MariaDB driver when using MariaDB server|https://issues.alfresco.com/jira/browse/MNT-17613]



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message