Closed Bug 1471610 Opened 6 years ago Closed 6 years ago

push updated bugzilla.mozilla.org live: mozillabteam/release-20180627.1

Categories

(bugzilla.mozilla.org :: Infrastructure, enhancement)

Product:
bugzilla.mozilla.org
Component:
Infrastructure
Version:
Production
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED
Tracking Flags:
Tracking Status
bmo-push accept production

People

(Reporter: dylan, Assigned: bobm)

References

(
URL
)

Details

bug 1467297 : variable masks earlier declaration in Feed.pm in Phabbugz extension bug 1467271 : When making a revision public, make the revision editable only by the bmo-editbugs-team project (editbugs) bug 1456877 : Add a wrapper around libcmark_gfm to Bugzilla bug 1468818 : Re-introduce is_markdown to the longdescs table (schema-only) bug 1469689 : Remove Bugzilla Helper and custom bug entry form links from Browse page bug 1419971 : Add new Developer Tools and WebExtensions products to easy product selector on Browse and Enter Bug pages bug 1469827 : The etiquette check on "Create new a Bugzilla account" lacks a proper label bug 1469920 : Update schema: add a nickname to profiles table and a fulltext index on the profiles realname field bug 1469333 : Check attachment file size client-side and inform user of too large file before uploading it bug 1461379 : API DB Availability Exceptions on recurring BMO scripts bug 1393146 : Automate blocking IPs that bugzilla flags as exceeding rate limits bug 1470275 : Copy Summary button should give some feedback bug 1470343 : GitHub PR diff is not decoded in UTF-8 bug 1470485 : Create new policies using PhabricatorProjectsAllPolicyRule instead of PhabricatorProjectsPolicyRule bug 1469881 : Patches posted by Phabricator to Bugzilla don't list the patch author bug 1457900 : When restricting a revision to a bugzilla group we should tag the revision with the project bug 1471044 : Allow some model classes to have dynamic column names with class method DYNAMIC_COLUMNS bug 1470966 : "Status" column in Phabricator dashboard isn't very useful bug 1452096 : Some custom dropdown UI widgets stay fixed and don't move with scroll bug 1471304 : Block sending mail to hosts that end with .tld or .bugs bug 1457550 : Update scripts/remove-non-public-data.pl suitability for current BMO infrastructure. bug 1469023 : Show "new changes since (datetime)" indicator that links to unread changes/comments { "build" : "https://circleci.com/gh/mozilla-bteam/bmo/10062", "commit" : "5191f5508b12d2e135374a0727e1ed82e8345604", "source" : "https://github.com/mozilla-bteam/bmo", "version" : "20180627.1" }
Summary: push updated bugzilla.mozilla.org live: release-20180627.1 → push updated bugzilla.mozilla.org live: mozillabteam/release-20180627.1
The fact it takes 9 minutes to add is_markdown to longdescs is unacceptable. I'll go back to the drawing board on that, and I'll prepare a release that doesn't include that column.
tracking-bmo-push: verify? → reject
Timings for posterity: 3:16:17 * This is Bugzilla 20180627.1 on perl 5.10.1 * Running on Linux 3.10.0-693.11.6.el7.x86_64 #1 SMP Thu Jan 4 01:06:37 UTC 2018 Checking for Algorithm::BloomFilter (0.02) ok: found v0.02 Checking for Alien::libcmark_gfm (any) ok: found v0.1 Checking for CGI (4.31) ok: found v4.38 Checking for CGI::Compile (any) ok: found v0.22 Checking for CGI::Emulate::PSGI (any) ok: found v0.23 Checking for CPAN::Meta::Prereqs (2.132830) ok: found v2.150005 Checking for CPAN::Meta::Requirements (2.121) ok: found v2.140 Checking for Class::XSAccessor (1.18) ok: found v1.19 Checking for Crypt::CBC (any) ok: found v2.33 Checking for Crypt::DES (any) ok: found v2.07 Checking for Crypt::DES_EDE3 (any) ok: found v0.01 Checking for Crypt::OpenPGP (1.02) ok: found v1.15 Checking for Crypt::SMIME (any) ok: found v0.17 Checking for DBI (1.614) ok: found v1.622 Checking for DBIx::Connector (any) ok: found v0.56 Checking for Daemon::Generic (any) ok: found v0.84 Checking for Data::Password::passwdqc (0.08) ok: found v0.08 Checking for Date::Format (2.23) ok: found v2.23 Checking for DateTime (0.75) ok: found v1.03 Checking for DateTime::TimeZone (2.11) ok: found v2.11 Checking for Devel::NYTProf (6.04) ok: found v6.04 3:16:19 Checking for Digest::SHA (5.47) ok: found v5.47 Checking for Email::Address (any) ok: found v1.908 Checking for Email::MIME (1.904) ok: found v1.937 Checking for Email::Send (1.911) ok: found v2.201 Checking for ExtUtils::MakeMaker (7.22) ok: found v7.22 Checking for FFI::Platypus (any) ok: found v0.48 Checking for File::MimeInfo::Magic (any) ok: found v0.27 Checking for File::Slurp (9999.13) ok: found v9999.19 Checking for File::Slurper (0.012) ok: found v0.012 Checking for Future (0.34) ok: found v0.34 Checking for HTML::Escape (1.10) ok: found v1.10 Checking for HTML::Tree (any) ok: found v5.03 Checking for IO::Async (0.71) ok: found v0.71 Checking for IO::Compress::Gzip (any) ok: found v2.074 Checking for IO::Scalar (any) ok: found v2.111 Checking for IPC::System::Simple (any) ok: found v1.25 Checking for JSON (any) ok: found v2.90 Checking for JSON::MaybeXS (1.003008) ok: found v1.003008 Checking for JSON::XS (2.0) ok: found v3.02 Checking for LWP::Protocol::https (6.07) ok: found v6.07 Checking for LWP::UserAgent (6.26) ok: found v6.26 Checking for List::MoreUtils (0.418) ok: found v0.425 Checking for Log::Dispatch (2.67) ok: found v2.67 Checking for Log::Log4perl (1.49) ok: found v1.49 Checking for Math::Random::ISAAC (v1.0.1) ok: found v1.004 Checking for Module::Metadata (1.000033) ok: found v1.000033 Checking for Module::Runtime (0.014) ok: found v0.014 Checking for Mojolicious (7.71) ok: found v7.81 Checking for Moo (2.002004) ok: found v2.002004 Checking for MooX::StrictConstructor (0.008) ok: found v0.008 Checking for Mozilla::CA (20160104) ok: found v20160104 Checking for Parse::CPAN::Meta (1.44) ok: found v1.4422 Checking for Regexp::Common (any) ok: found v2016060801 Checking for Role::Tiny (2.000003) ok: found v2.000003 Checking for Sereal (4.004) ok: found v4.004 Checking for Sys::Syslog (any) ok: found v0.35 Checking for Taint::Util (0.08) ok: found v0.08 Checking for Template (2.24) ok: found v2.24 Checking for Text::CSV_XS (1.26) ok: found v1.26 Checking for Text::Diff (any) ok: found v1.44 Checking for Throwable (0.200013) ok: found v0.200013 Checking for Tie::IxHash (any) ok: found v1.23 Checking for Type::Tiny (1.000005) ok: found v1.000005 Checking for URI (1.55) ok: found v1.71 Checking for URI::Escape::XS (0.14) ok: found v0.14 Checking for perl (5.010001) ok: found v5.010001 Checking for version (0.87) ok: found v0.9917 Optional features: Feature 'argon2': Support hashing passwords with Argon2 Checking for Crypt::Argon2 (0.004) ok: found v0.004 Feature 'auth_ldap': LDAP Authentication Checking for Net::LDAP (any) not found Feature 'auth_radius': RADIUS Authentication Checking for Authen::Radius (any) not found Feature 'bmo': features that bmo needs Checking for Auth::GoogleAuth (1.01) ok: found v1.01 Checking for Cache::Memcached::Fast (0.17) ok: found v0.23 Checking for Chart::Lines (v2.4.10) ok: found v2.4.10 Checking for Class::Accessor::Fast (any) ok: found v0.34 Checking for Crypt::Argon2 (0.004) ok: found v0.004 Checking for DBD::mysql (4.037) ok: found v4.037 Checking for Daemon::Generic (any) ok: found v0.84 Checking for Email::MIME::Attachment::Stripper (any) ok: found v1.317 Checking for Email::Reply (any) ok: found v1.204 Checking for Encode (2.21) ok: found v2.35 Checking for Encode::Detect (any) ok: found v1.01 Checking for File::Copy::Recursive (any) ok: found v0.38 Checking for File::MimeInfo::Magic (any) ok: found v0.27 Checking for File::Which (any) ok: found v1.21 Checking for GD (1.20) ok: found v2.56 Checking for GD::Barcode::QRcode (any) ok: found v0.01 Checking for GD::Graph (any) ok: found v1.53 Checking for GD::Text (any) ok: found v0.86 Checking for HTML::Parser (3.67) ok: found v3.72 Checking for HTML::Scrubber (any) ok: found v0.15 Checking for IO::Scalar (any) ok: found v2.111 Checking for JSON::RPC (== 1.01) ok: found v1.01 Checking for Linux::Pdeathsig (any) ok: found v0.10 Checking for Linux::Pid (any) ok: found v0.04 Checking for Linux::Smaps (any) not found Checking for MIME::Parser (5.406) ok: found v5.507 Checking for Net::SFTP (any) ok: found v0.10 Checking for PatchReader (v0.9.6) ok: found v0.9.6 Checking for SOAP::Lite (0.712) ok: found v1.20 Checking for Search::Elasticsearch (any) ok: found v5.01 Checking for Template::Plugin::GD::Image (any) ok: found v1.56 Checking for Test::Taint (1.06) ok: found v1.06 Checking for Text::MultiMarkdown (1.000034) ok: found v1.000035 Checking for TheSchwartz (1.10) ok: found v1.12 Checking for URI::Escape (any) ok: found v3.31 Checking for XML::Simple (any) ok: found v2.22 Checking for XML::Twig (any) ok: found v3.49 Checking for XMLRPC::Lite (0.712) ok: found v0.717 Feature 'detect_charset': Automatic charset detection for text attachments Checking for Encode (2.21) ok: found v2.35 Checking for Encode::Detect (any) ok: found v1.01 Feature 'documentation': Documentation Checking for File::Copy::Recursive (any) ok: found v0.38 Checking for File::Which (any) ok: found v1.21 Feature 'elasticsearch': Elasticsearch-powered searches Checking for Search::Elasticsearch (any) ok: found v5.01 Use of uninitialized value in printf at /app/Bugzilla/Install/Requirements.pm line 114. Feature 'extension_push_optional': Checking for Net::SFTP (any) ok: found v0.10 Checking for XML::Simple (any) ok: found v2.22 Feature 'graphical_reports': Graphical Reports Checking for GD (1.20) ok: found v2.56 Checking for GD::Graph (any) ok: found v1.53 Checking for GD::Text (any) ok: found v0.86 Checking for Template::Plugin::GD::Image (any) ok: found v1.56 Feature 'html_desc': More HTML in Product/Group Descriptions Checking for HTML::Parser (3.67) ok: found v3.72 Checking for HTML::Scrubber (any) ok: found v0.15 Feature 'inbound_email': Inbound Email Checking for Email::MIME::Attachment::Stripper (any) ok: found v1.317 Checking for Email::Reply (any) ok: found v1.204 Feature 'jobqueue': Mail Queueing Checking for Daemon::Generic (any) ok: found v0.84 Checking for TheSchwartz (1.10) ok: found v1.12 Feature 'jsonrpc': JSON-RPC Interface Checking for JSON::RPC (== 1.01) ok: found v1.01 Checking for Test::Taint (1.06) ok: found v1.06 Feature 'linux_pdeath': Linux::Pdeathsig for a good parent/child relationships Checking for Linux::Pdeathsig (any) ok: found v0.10 Feature 'linux_pid': Linux::PID for MozReview Checking for Linux::Pid (any) ok: found v0.04 Feature 'linux_smaps': Linux::Smaps for limiting memory usage Checking for Linux::Smaps (any) not found Feature 'markdown': Markdown syntax support for comments Checking for Text::MultiMarkdown (1.000034) ok: found v1.000035 Feature 'memcached': Memcached Support Checking for Cache::Memcached::Fast (0.17) ok: found v0.23 Feature 'mfa': Multi-Factor Authentication Checking for Auth::GoogleAuth (1.01) ok: found v1.01 Checking for GD::Barcode::QRcode (any) ok: found v0.01 Feature 'mod_perl': mod_perl support under Apache Checking for Apache2::SizeLimit (0.96) ok: found v0.96 Checking for Plack::Handler::Apache2 (any) not found Checking for mod_perl2 (1.999022) ok: found v2.000004 Feature 'moving': Move Bugs Between Installations Checking for MIME::Parser (5.406) ok: found v5.507 Checking for XML::Twig (any) ok: found v3.49 Feature 'mysql': MySQL database support Checking for DBD::mysql (4.037) ok: found v4.037 Feature 'new_charts': New Charts Checking for Chart::Lines (v2.4.10) ok: found v2.4.10 Checking for GD (1.20) ok: found v2.56 Feature 'old_charts': Old Charts Checking for Chart::Lines (v2.4.10) ok: found v2.4.10 Checking for GD (1.20) ok: found v2.56 Feature 'oracle': Oracle database support Checking for DBD::Oracle (1.19) not found Feature 'patch_viewer': Patch Viewer Checking for PatchReader (v0.9.6) ok: found v0.9.6 Feature 'pg': Postgres database support Checking for DBD::Pg (v2.19.3) not found Feature 'rest': REST Interface Checking for JSON::RPC (== 1.01) ok: found v1.01 Checking for Test::Taint (1.06) ok: found v1.06 Feature 's3': Amazon S3 Attachment Storage Checking for Class::Accessor::Fast (any) ok: found v0.34 Checking for URI::Escape (any) ok: found v3.31 Checking for XML::Simple (any) ok: found v2.22 Feature 'smtp_auth': SMTP Authentication Checking for Authen::SASL (any) not found Feature 'sqlite': SQLite database support Checking for DBD::SQLite (1.29) found v1.27 Feature 'typesniffer': Sniff MIME type of attachments Checking for File::MimeInfo::Magic (any) ok: found v0.27 Checking for IO::Scalar (any) ok: found v2.111 Feature 'updates': Automatic Update Notifications Checking for XML::Twig (any) ok: found v3.49 Feature 'xmlrpc': XML-RPC Interface Checking for SOAP::Lite (0.712) ok: found v1.20 Checking for Test::Taint (1.06) ok: found v1.06 Checking for XMLRPC::Lite (0.712) ok: found v0.717 Checking for MySQL (5.6.12) ok: found v5.6.35-log Creating /app/conf/env.conf... Creating __lbheartbeat__... Creating js/yui.js... Creating js/yui3.js... Creating skins/yui.css... Creating skins/yui3.css... Creating version.json... 3:16:20 Invalid parameter: mfa_group Invalid parameter: webdotbase 3:16:24 Adding new column 'is_markdown' to the 'longdescs' table... 3:25:22 Adding new column 'nickname' to the 'profiles' table... 3:25:30 Adding new index 'profiles_nickname_idx' to the profiles table ... 3:25:31 Adding new index 'profiles_realname_ft_idx' to the profiles table ... 3:25:43 checksetup.pl complete. real 9m25.288s user 0m1.551s sys 0m0.173s
So it turns out the ALTER TABLE ... ADD defaults to an inplace operation, without locks in mysql 5.6 or newer, so it is safe to deploy this to prod and run the checksetup.pl -n -t at some point of low load (but even if someone hits it, it won't be bad)
tracking-bmo-push: reject → accept
Assignee: nobody → bobm
Status: NEW → RESOLVED
Closed: 6 years ago
tracking-bmo-push: verify? → accept
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.