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 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
########################################################################= ######