[
https://issues.apache.org/jira/browse/AIRAVATA-2899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16639838#comment-16639838
]
Marcus Christie commented on AIRAVATA-2899:
-------------------------------------------
Ran following in our dev environment:
{noformat}
MariaDB [experiment_catalog]> alter table PROCESS_STATUS modify column
TIME_OF_STATE_CHANGE TIMESTAMP(6) DEFAULT NOW(6) ON UPDATE NOW(6);
Query OK, 61411 rows affected (4.94 sec)
Records: 61411 Duplicates: 0 Warnings: 0
MariaDB [experiment_catalog]> alter table TASK_STATUS modify column
TIME_OF_STATE_CHANGE TIMESTAMP(6) DEFAULT NOW(6) ON UPDATE NOW(6);
Query OK, 182674 rows affected (12.05 sec)
Records: 182674 Duplicates: 0 Warnings: 0
MariaDB [experiment_catalog]> alter table JOB_STATUS modify column
TIME_OF_STATE_CHANGE TIMESTAMP(6) DEFAULT NOW(6) ON UPDATE NOW(6);
Query OK, 26790 rows affected (4.97 sec)
Records: 26790 Duplicates: 0 Warnings: 0
{noformat}
> Enable millisecond precision in PROCESS_STATUS, TASK_STATUS, JOB_STATUS
> -----------------------------------------------------------------------
>
> Key: AIRAVATA-2899
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2899
> Project: Airavata
> Issue Type: Improvement
> Components: Registry API
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
