Author Topic: 0.6.9.0 2017-02-06  (Read 2470 times)

Offline Wally73

  • Overlord
  • ******
  • Posts: 260
  • Helpful: +28/-1
  • i'm nuts
0.6.9.0 2017-02-06
« on: 2017-02-06, 01:19:31 AM »
0.6.9.0 2017-02-06
   ***IMPORTANT***
     With the next release (in March), some required changes will be made.
   1) The minimum version of database we support will be raised (MariaDb 10.0/MySQL 5.6).
    Additionally, we now strongly reccommend MariaDb for all users. It has all the features of
    MySQL, plus additional stability and functionality (generally faster). MySQL has changed its
    default settings for a number of features/modes which cause issues with nZEDb, so we will no
    longer be supporting it directly. If you must use MySQL, you are expected to know what you
    are doing and maintain it yourself. Check the comparison docs here:
      https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
      https://mariadb.com/kb/en/mariadb/system-variable-differences-between-mariadb-100-and-mysql-56/
   2) Tables Per Group will become compulsory. Please convert now to avoid problems. The
    .../misc/testing/DB/convert_to_tpg_alt.php script (with the truncate option) is recommended.
Added:

Changed:
   * Updates to readme.md (PR 2366).

Fixed:
   * Check for incompatible tmux versions and abort if installed (PR 2353).
   * Predb page link for predb search (closes issue 2356).
   * Work around to prevent some db versions using auto-increment value on an explicit 0 for
    Categories Other's.
   * Change leftover references to group_id in python scripts and ProcessReleases class.
   * Bad settings data for yydecodepath.
   * Adds releases_groups table to resetdb.php (PR 2365).
   * Fixes typo in ProcessAdditional.php which prevented timeout setting being used correctly (PR 2364).
   * Wrong number of parameters in removeInstallBin function sql query.
   * Bring in b3s3rk's fix, from MGR branch, for the duplicate ReleasesGroups entries.
   * Update threaded.sh for newer fixRelNames params (PR 2376).

Offline david_ritterhous

  • Prolific Indexer
  • ****
  • Posts: 240
  • Helpful: +6/-0
Re: 0.6.9.0 2017-02-06
« Reply #1 on: 2017-02-06, 03:25:38 AM »
TPG did not work well last time I tried.  I index on about 4k groups to see which groups look good.  With that many groups TPG chokes.  This was about 6 months ago when I tested it last so maybe something has changed.

Offline kaibosh

  • Overlord
  • ******
  • Posts: 159
  • Helpful: +18/-0
Re: 0.6.9.0 2017-02-06
« Reply #2 on: 2017-02-06, 10:01:26 AM »
Perhaps it hit the system's open file limit? With 4k groups active, the DB potentially may need to have 32k files open for the CBP(collections, binaries,parts[,part-repair]) tables.

The steps needed to expand this setting for both the OS and the DB daemon are documented (for now) in the fedora wiki install guide. Other distros will be similar.

Once configured you can verify the setting like this:

Code: [Select]
MariaDB [nzedb]> show global variables like "%open_files_limit%";
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 24576 |
+------------------+-------+
1 row in set (0.00 sec)

Offline david_ritterhous

  • Prolific Indexer
  • ****
  • Posts: 240
  • Helpful: +6/-0
Re: 0.6.9.0 2017-02-06
« Reply #3 on: 2017-02-06, 10:49:29 AM »
Ahh, mine shows: 6162

Offline Rawh

  • Newbie
  • *
  • Posts: 2
  • Helpful: +0/-0
Re: 0.6.9.0 2017-02-06
« Reply #4 on: 2017-02-06, 11:22:35 AM »
    For everyone that did the adjustment noted below


   2) Tables Per Group will become compulsory. Please convert now to avoid problems. The
    .../misc/testing/DB/convert_to_tpg_alt.php script (with the truncate option) is recommended.


and ran into the error "Error: You must use .../misc/update/nix/multiprocessing/releases.php since you have enabled TPG!" within their "RELEASES" screen, fix it by doing the following:


  • Go to the directory "/misc/update/nix/screen/threaded"
  • Edit the file called "helper.sh"
  • Comment the following line (put a # infront of it): "$PHP $NZEDB_PATH/update_releases.php 1 false"
  • Type the following line underneith: "$PHP $NZEDB_PATH/nix/multiprocessing/releases.php"
  • Save the file.

Recall the "RELEASES" screen and hit Ctrl+c. Now just wait the 60 seconds from the main "START" screen and the "RELEASES" screen should autostart again.

Enjoy the flashing updates :)

[/list]
« Last Edit: 2017-02-06, 11:24:29 AM by Rawh »