Message-ID: <843591781.8513.1711673095607.JavaMail.confluence@host3.pipelinefx.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8512_1425232117.1711673095606" ------=_Part_8512_1425232117.1711673095606 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Qube 7.5-2 Release Notes

Qube 7.5-2 Release Notes

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

 

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

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

=3D=3D=3D=3D CL 23262 =3D=3D=3D=3D
@CHANGE: postgresql startup scri= pts no longer control where the logs go (now it's specified in postgresql.c= onf)

JIRA: QUBE-3888

=3D=3D=3D=3D CL 23261 =3D=3D=3D=3D
@NEW: Add Qube-custom logging pa= rameters to postgresql.conf. Now PGSQL logs are written to DATADIR/pg_log/p= gsql.log on ALL platforms.

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

JIRA: QUBE-3888

=3D=3D=3D=3D CL 23260 =3D=3D=3D=3D
@FIX: some parsing issues in con= figure_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 ou= r value

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

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

=3D=3D=3D=3D CL 23258 =3D=3D=3D=3D
@FIX: a couple of issues with py= thon 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 con= straint added since 7.5-0

ZD: 21118

=3D=3D=3D=3D CL 23253 =3D=3D=3D=3D
@FIX:binarySort Python 3 compati= bility

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

ZD: 21090

=3D=3D=3D=3D CL 23203 =3D=3D=3D=3D
@UPDATE:Edits for database_check= s.py

=3D=3D=3D=3D CL 23201 =3D=3D=3D=3D
@FIX:Encoding xdrlib integers 12= 8 and greater

=3D=3D=3D=3D CL 23190 =3D=3D=3D=3D
@NEW:Add Media Encoder jobtype a= nd serverBackend base class

=3D=3D=3D=3D CL 23163 =3D=3D=3D=3D
@CHANGE: make sure that the &quo= t;pfx" db is created with its Encoding set to 'UTF8'

JIRA: QUBE-3865

=3D=3D=3D=3D CL 23160 =3D=3D=3D=3D
@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 scrip= ts:
create_hostState_dim.sql
create_slotCount_fact.sql
creat= e_worker_dim.sql
populate_slotCount.sql
regular_slotCount.sql

* Also add upgrade_scripts/upgrade_v2.sql, and updated datawarehouse_ver= sion to 2.

In upgrade_v2.sql, reimplemented the PFX_CREATE_DATASUBSET_TABLE functio= n (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 t= he necessary tables.

* Add back cron jobs (Linux, macOS) and scheduledTask (Windows) that per= iodically 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 pa= ckage them up into the supervisor installer

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

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

ZD: 20992
JIRA: QUBE-3863

########################################################################= ######

------=_Part_8512_1425232117.1711673095606--