##############################################################################
    #
    # Qube Release Notes
    #
    ##############################################################################

     

    ##############################################################################
    @RELEASE: 7.5-2

    ==== CL 23290 ====
    @CHANGE: support Apple-provided Python 3.8, instead of Home Brew version

    ==== CL 23262 ====
    @CHANGE: postgresql startup scripts no longer control where the logs go (now it's specified in postgresql.conf)

    JIRA: QUBE-3888

    ==== CL 23261 ====
    @NEW: Add Qube-custom logging parameters to postgresql.conf. Now PGSQL logs are written to DATADIR/pg_log/pgsql.log on ALL platforms.

    Formerly, log wasn't written to a file on Windows.

    JIRA: QUBE-3888

    ==== CL 23260 ====
    @FIX: some parsing issues in configure_postgresql_conf.py script

    * bug where commented out parameters would end up in the end section of the postgresql.conf file, unless the commented out value exactly matches our value

    * fixed regex to match better (had issues with params with empty value '', and with whitespace)

    ==== CL 23259 ====
    @UPDATE: add signal handler for segfault in QbPreForkDaemon to print stack trace upon the said signal

    ==== CL 23258 ====
    @FIX: a couple of issues with python scripts that export MySQL data and import it into PostgreSQL

    * export script: quoting issue with the path to MySQL executable
    * import script: jobid data must be imported before job data to satisfy a constraint added since 7.5-0

    ZD: 21118

    ==== CL 23253 ====
    @FIX:binarySort Python 3 compatibility

    ==== CL 23227 ====
    @FIX: proxy program (proxy.exe) crashing under certain Windows environments

    ZD: 21090

    ==== CL 23203 ====
    @UPDATE:Edits for database_checks.py

    ==== CL 23201 ====
    @FIX:Encoding xdrlib integers 128 and greater

    ==== CL 23190 ====
    @NEW:Add Media Encoder jobtype and serverBackend base class

    ==== CL 23163 ====
    @CHANGE: make sure that the "pfx" db is created with its Encoding set to 'UTF8'

    JIRA: QUBE-3865

    ==== CL 23160 ====
    @NEW: Adding back the slotcount_fact table as well as the cached "data subset" tables to the Data Warehouse (dwh)

    JIRA: QUBE-3867
    ZD: 20996

    * Add back, to dwh, the slotcount_fact table and all releated .sql scripts:
    create_hostState_dim.sql
    create_slotCount_fact.sql
    create_worker_dim.sql
    populate_slotCount.sql
    regular_slotCount.sql

    * Also add upgrade_scripts/upgrade_v2.sql, and updated datawarehouse_version to 2.

    In upgrade_v2.sql, reimplemented the PFX_CREATE_DATASUBSET_TABLE function (that was available in our MySQL dwh), and also added commands to source the create*.sql and populate_slotCount.sql files mentioned above to build the necessary tables.

    * Add back cron jobs (Linux, macOS) and scheduledTask (Windows) that periodically run the regular_slotCount.sql collector, and build the "data subset" tables that contain data for a limited time-range (12hr, 36hr, 7day, 3wk, and 3mo) for faster preset queries for charting:

    Linux: qube/etc/cron.d/com.pipelinefx.DataWarehouse.cron

    macOS: add back qube/datawh/data_collectors/osx*.sh scripts in the data_collectors subdir, and their corresponding macOS cron drivers, qube/etc/com.pipelinefx.DataWarehouse.*.plist, qube/pkg/supepkg.pl and qubepkg.pm to package them up into the supervisor installer

    Windows: changes made to qubemsi.pm and rrd_tables.bat to install and enable the scheduledTasks when the supervisor MSI installer is run

    ==== CL 23146 ====
    @FIX: Python API: qb.rangepartition(), and consequently qb.genpartions(), broken with python3, returning an empty list to valid input.

    ZD: 20992
    JIRA: QUBE-3863

    ##############################################################################

    • No labels