Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4208

[GSS] (6.3.z) Unable to get log tables precision up to milliseconds when using MariaDB/MySQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.3.4, 6.3.4.GA
    • 6.3.0
    • Business Central
    • None
    • BxMS 6.3 since MariaDB is certified only on it

    • CR1

      BxMS 6.3 does not store milliseconds when using MariaDB for log tables (e.g. NodeInstanceLog - log_date column). Looking in DDLs I see that tables are created as follows:

      create table NodeInstanceLog (
      id bigint not null auto_increment,
      connection varchar(255),
      log_date datetime,
      ...

      According to [1], datetime will not store milliseconds. I have modified it as follows:

      log_date datetime (6)

      However, the value is not store properly. The milliseconds is stored properly and work well if using PostgreSQL for instance.

      [1] https://mariadb.com/kb/en/mariadb/datetime/

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-ajuricic Amana Juricic
              Jozef Marko Jozef Marko (Inactive)
              Jozef Marko Jozef Marko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: