Page MenuHomePhabricator

DatabaseProject
ActivePublic

Watchers

  • This project does not have any watchers.
  • View All

Details

Description

Data storage.

Recent Activity

Sep 13 2019

epriestley triaged T13417: "bin/storage upgrade" should test for replication problems before applying migrations as Low priority.
Sep 13 2019, 7:31 PM · Database

Sep 8 2019

epriestley added a revision to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY: D20791: Remove the "ONLY_FULL_GROUP_BY" SQL mode setup warning and change the setup key for "STRICT_ALL_TABLES".
Sep 8 2019, 8:02 PM · Database, Infrastructure
epriestley added a revision to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY: D20790: Weaken the guidance recommending that installs enable "STRICT_ALL_TABLES".
Sep 8 2019, 7:59 PM · Database, Infrastructure
epriestley added a comment to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY.

Vaguely adjacent:

Sep 8 2019, 7:27 PM · Database, Infrastructure

Sep 7 2019

swisspol added a comment to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY.

Now that we are on RDS I can confirm that MySQL also has ONLY_FULL_GROUP_BY enabled by default.

Sep 7 2019, 1:55 AM · Database, Infrastructure

Sep 4 2019

swisspol added a comment to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY.

That actually using MySQL official Docker image.

Sep 4 2019, 3:12 AM · Database, Infrastructure

Sep 3 2019

epriestley added a comment to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY.

There are only 23 occurrences of the string "GROUP BY" in the codebase, and, from inspection, many obviously do not conflict with ONLY_FULL_GROUP_BY.

Sep 3 2019, 11:54 PM · Database, Infrastructure
epriestley added a revision to T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY: D20782: Fix "ONLY_FULL_GROUP_BY" issue in SystemAction queries.
Sep 3 2019, 11:43 PM · Database, Infrastructure
epriestley triaged T13404: Make Phabricator compatible with ONLY_FULL_GROUP_BY as Wishlist priority.
Sep 3 2019, 11:23 PM · Database, Infrastructure
epriestley closed T13403: "mysqli->real_connect()" can fail awkwardly without setting "error_code", plus bonus issues as Resolved.
Sep 3 2019, 7:54 PM · Database, Config
epriestley added a revision to T13403: "mysqli->real_connect()" can fail awkwardly without setting "error_code", plus bonus issues: D20781: Use the "@" operator to silence connection retry messages if initializing the stack with database config optional.
Sep 3 2019, 7:26 PM · Database, Config
epriestley added a revision to T13403: "mysqli->real_connect()" can fail awkwardly without setting "error_code", plus bonus issues: D20780: When "mysqli->real_connect()" fails without setting an error code, recover more gracefully.
Sep 3 2019, 7:23 PM · Database, Config
epriestley added a revision to T13403: "mysqli->real_connect()" can fail awkwardly without setting "error_code", plus bonus issues: D20779: Give "bin/config" a friendlier error message if "local.json" is not writable.
Sep 3 2019, 7:19 PM · Database, Config
epriestley triaged T13403: "mysqli->real_connect()" can fail awkwardly without setting "error_code", plus bonus issues as Low priority.
Sep 3 2019, 7:05 PM · Database, Config

Sep 1 2019

epriestley added a comment to T13400: Evaluate performance impact of performing MySQL dump/restore in parallel.

Anecdata: locally, using 2 subprocesses went twice as fast (~85s -> ~42s). 4 subprocesses chopped another ~20% of the time off (~42s > ~35s). It stopped getting faster at 4. However, the largest table took 24s, so even if this was completely parallelizable we wouldn't expect it to drop lower than that.

Sep 1 2019, 11:19 PM · Infrastructure, Database

Aug 31 2019

epriestley triaged T13400: Evaluate performance impact of performing MySQL dump/restore in parallel as Wishlist priority.
Aug 31 2019, 4:04 PM · Infrastructure, Database

Jun 19 2019

epriestley added a comment to T13305: Migration "20180208.maniphest.02.populate.php" may fail when queueing indexing tasks.

Getting rid of the indirect writes on handle reads would probably be nice eventually, but doesn't directly accomplish anything today.

Jun 19 2019, 5:30 PM · Installing & Upgrading, Database

Jun 18 2019

epriestley closed T13304: Phabricator "Backups" instructions are somewhat out of date as Resolved by committing rP6219d30f6b0b: Recommend dumping database backups with "--compress --output X" instead of "|….
Jun 18 2019, 6:37 PM · Database

Jun 5 2019

epriestley added a revision to T13304: Phabricator "Backups" instructions are somewhat out of date: D20572: Recommend dumping database backups with "--compress --output X" instead of "| gzip > X".
Jun 5 2019, 10:00 PM · Database
epriestley added a revision to T13305: Migration "20180208.maniphest.02.populate.php" may fail when queueing indexing tasks: D20570: Skip loading transaction handles in an old migration.
Jun 5 2019, 6:43 PM · Installing & Upgrading, Database
epriestley added a comment to T13305: Migration "20180208.maniphest.02.populate.php" may fail when queueing indexing tasks.

I applied this change to 20180208.maniphest.02.populate.php:

Jun 5 2019, 5:24 PM · Installing & Upgrading, Database
epriestley created T13305: Migration "20180208.maniphest.02.populate.php" may fail when queueing indexing tasks.
Jun 5 2019, 5:18 PM · Installing & Upgrading, Database
epriestley created T13304: Phabricator "Backups" instructions are somewhat out of date.
Jun 5 2019, 3:26 PM · Database

Apr 15 2019

epriestley closed T8476: Rename `phabricator_repository` database as Wontfix.

This remains desirable, but probably won't happen without a stronger motivator since the patches are somewhat involved.

Apr 15 2019, 4:01 PM · Restricted Project, Database, Diffusion

Jan 18 2019

epriestley closed T13193: Dropping a column which is a component of a UNIQUE KEY has surprising behavior in MariaDB as Resolved.

Nothing really actionable here.

Jan 18 2019, 9:03 PM · Database

Aug 30 2018

epriestley updated the task description for T13193: Dropping a column which is a component of a UNIQUE KEY has surprising behavior in MariaDB.
Aug 30 2018, 1:24 PM · Database
epriestley triaged T13193: Dropping a column which is a component of a UNIQUE KEY has surprising behavior in MariaDB as Low priority.
Aug 30 2018, 1:10 PM · Database
epriestley created T13193: Dropping a column which is a component of a UNIQUE KEY has surprising behavior in MariaDB.
Aug 30 2018, 1:10 PM · Database

Aug 22 2018

jasonyoung added a comment to T6931: Support SSL connections to MySQL.
  • your business faces regulatory/compliance issues which are satisfied by encrypting the connection, even if it provides no direct security benefit.
Aug 22 2018, 3:19 PM · Database

Mar 18 2018

mydeveloperday added a comment to T12994: Add a setup warning if MYSQLI_ASYNC is not defined (support for MySQLi async).

I don't run my Phabricator instance on Ubuntu but instead on RHEL6 (and with PHP7, which I know isn't officially support)

Mar 18 2018, 12:19 PM · Database, Infrastructure

Mar 13 2018

epriestley closed T12994: Add a setup warning if MYSQLI_ASYNC is not defined (support for MySQLi async) as Resolved by committing rP0bf8e33bb6c1: Issue setup guidance recommending MySQLi and MySQL Native Driver.
Mar 13 2018, 7:38 PM · Database, Infrastructure
epriestley added a comment to T12994: Add a setup warning if MYSQLI_ASYNC is not defined (support for MySQLi async).

(I'll follow up in T13102 if there's more to be done here, it's possible that some installs are missing this for reasons other than "Ubuntu + apt get install php5-mysql").

Mar 13 2018, 7:38 PM · Database, Infrastructure
epriestley added a revision to T12994: Add a setup warning if MYSQLI_ASYNC is not defined (support for MySQLi async): D19216: Issue setup guidance recommending MySQLi and MySQL Native Driver.
Mar 13 2018, 7:35 PM · Database, Infrastructure

Sep 20 2017

epriestley created T12994: Add a setup warning if MYSQLI_ASYNC is not defined (support for MySQLi async).
Sep 20 2017, 7:28 PM · Database, Infrastructure

Sep 11 2017

epriestley closed T10773: When the search table is marked as crashed, bin/storage should automatically repair it as Wontfix.

We generally stopped seeing this after moving to InnoDB FULLTEXT, which seems less prone to table crashes than MyISAM FULLTEXT was. See also T12819 for the fate of InnoDB FULLTEXT.

Sep 11 2017, 12:02 PM · Database, Feature Request

Aug 30 2017

20after4 added a comment to T12965: When no "master" database is configured, the ElasticSearch setup check can fatal.

Whoops this is probably my bad :-/

Aug 30 2017, 1:07 PM · Database, Clusters, Search

Aug 17 2017

epriestley added a revision to T12965: When no "master" database is configured, the ElasticSearch setup check can fatal: D18440: Don't fatal in ElasticSearch setup check if no "master" database is configured.
Aug 17 2017, 4:53 PM · Database, Clusters, Search
epriestley created T12965: When no "master" database is configured, the ElasticSearch setup check can fatal.
Aug 17 2017, 4:41 PM · Database, Clusters, Search

Aug 15 2017

epriestley closed T12548: Unable to initialize database with invalid credentials in configuration file as Invalid.

Closing this for lack of feedback, feel free to resurrect it if you get back to it.

Aug 15 2017, 5:34 PM · Database, Bug Report

Jul 9 2017

chad updated the image for Database from Restricted File to F5039270: profile.
Jul 9 2017, 7:30 PM

May 5 2017

epriestley created T12678: Bring sanity to the world of all MySQL data being string-typed.
May 5 2017, 4:11 PM · Database, Infrastructure

Apr 13 2017

epriestley added a comment to T12548: Unable to initialize database with invalid credentials in configuration file.

This could definitely be more clear, but I think this is currently expected -- you still need to have valid configuration even when providing additional administrative credentials.

Apr 13 2017, 1:25 PM · Database, Bug Report
joshuaspence created T12548: Unable to initialize database with invalid credentials in configuration file.
Apr 13 2017, 7:01 AM · Database, Bug Report

Mar 16 2017

chad added a comment to T421: Show it to me Calimonk!.

Do this man

Mar 16 2017, 2:00 AM · newyork, Arcanist (Milestone 1), Restricted Project, Localization, ircbot, External, DeviantArt, Database, Dashboard, Dashboards, Daemons, Conpherence, Calendar, Chatlog, Unknown Object (Project)

Jan 17 2017

Alexmoon2 added projects to T421: Show it to me Calimonk!: Chatlog, Calendar, Conpherence, Daemons, Dashboards, Dashboard, Database, DeviantArt, External, ircbot, Localization, Restricted Project, Arcanist (Milestone 1), newyork.
Jan 17 2017, 9:24 AM · newyork, Arcanist (Milestone 1), Restricted Project, Localization, ircbot, External, DeviantArt, Database, Dashboard, Dashboards, Daemons, Conpherence, Calendar, Chatlog, Unknown Object (Project)

Nov 22 2016

epriestley closed T11672: Evaluate persistent connections from HTTP contexts as Resolved by committing rP8c89fc38fc42: Allow persistent connections to be configured per database host.
Nov 22 2016, 6:57 PM · Restricted Project, Performance, Clusters, Database
epriestley added a revision to T11672: Evaluate persistent connections from HTTP contexts: D16913: Allow persistent connections to be configured per database host.
Nov 22 2016, 2:41 PM · Restricted Project, Performance, Clusters, Database
epriestley closed T10931: Changing mysql.implementation setting doesn't work as Resolved by committing rPbac27fb40363: Remove "mysql.implementation" configuration.
Nov 22 2016, 12:15 PM · Setup, Database, Bug Report
epriestley added a comment to T10931: Changing mysql.implementation setting doesn't work.

I've marked D16909 as fixing this, but it just removes mysql.implementation, and uses the rule "mysqli if available, mysql otherwise".

Nov 22 2016, 1:08 AM · Setup, Database, Bug Report
epriestley added a revision to T10931: Changing mysql.implementation setting doesn't work: D16909: Remove "mysql.implementation" configuration.
Nov 22 2016, 1:05 AM · Setup, Database, Bug Report