Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
We need to get servers setup for D7 upgrade.
DNS (nnewton)vhost filesvhost configurationBZR reposBZR checkoutDBs (nnewton)- Solr (nnewton)
- verify jobs
- deploy jobs
- snapshot to site jobs
files directories
Comment | File | Size | Author |
---|---|---|---|
#12 | duplicates.txt | 12.05 KB | drumm |
Comments
Comment #1
drummWe need a round of staging sites for Drupal.org on Drupal 7, including as many supporting services as possible for Solr, Git, etc. Like the staging sites on scratchvm, these should be automated to deploy anything in BZR and do daily upgrades from snapshots of live sites. This will give us a good view of what would happen if we upgraded today.
The vhosts can probably fit on scratchvm as soon as we get files moved off, if we want them there. Everything else needs a bit of planning to fit in, especially for disk space.
Only one comprehensive set of staging sites needs to exist in the end, either this or *staging.devdrupal.org will eventually go.
Comment #2
webchickCould we get a status update on this issue? The sprint starts in 2 weeks, and this issue has been open for about 3 now. Curious where things are at.
Comment #3
drummUpdated the issue summary, including completed work.
Comment #4
webchickTagging.
Comment #5
dwwcool, great to see progress on this in advance of the sprint. this will help a lot.
minor nit: what's the point of an "infrastructure" issue tag in this issue queue? slightly confused by that...
thanks,
-derek
Comment #5.0
dwwtodo list
Comment #5.1
drummforgot vhost conf
Comment #6
webchickThe point of that tag is so we can do lists like contains both 'Drupal.org D7' AND 'infrastructure', and contains both 'Drupal.org D7' AND 'cleanup', to help organize tasks for teams, regardless in what queue it resides in. While probably almost all "Drupal.org D7, infrastructure" issues will reside in the infrastructure queue, not all "Drupal.org D7" issues in the infrastructure queue will necessarily be part of the infrastructure team's responsibilities.
Comment #7
dwwOkay, fair enough. I could argue your last point, but it's not important. ;) I can play by whatever rules y'all prefer. Tags++, regardless. ;)
Cheers,
-Derek
Comment #7.0
dwwvhosts done
Comment #7.1
drummAdding Solr.
Comment #8
drummWe have a DB server now and things are starting to work. However, the core upgrade to Drupal.org takes 14 hours, and then breaks.
Comment #9
webchickLOL. Well that's no good. :)
Comment #10
drummI filed #1536160: Make update_fix_d7_block_deltas faster and removed the old block variables to reduce the time needed to run an upgrade.
Comment #11
drummWe are running into #966210: DB Case Sensitivity: system_update_7061() fails on inserting files with same name but different case which is blocked by #1237252: DB Case Sensitivity: Allow BINARY attribute in MySQL.
Comment #12
drummIn Drupal 7, the uri column in the new file_managed table needs to be unique. The data is derived from filepath in Drupal 6's files table, which doesn't have this constraint. Drupal.org has 222 duplicates found with
SELECT count(DISTINCT f.fid) c, f.filepath, group_concat(u.nid) FROM files f LEFT JOIN upload u ON u.fid = f.fid GROUP BY cast(f.filepath AS BINARY) HAVING c > 1;
Either Drupal 7 should not have the unique constraint and/or we need to clean up our data.lComment #13
drummThe files are a mess. For example, 484 files have filepath "files/issues/". An example is #629528: Error. The file actually does exist at http://drupal.org/files/issues/Error_3.JPG. There really isn't a good way to clean this up. Doing it well would mean matching up all the files, maybe using file size to help.
We are just going to have to remove the bad data and work on cleaning it up on the live site in the meantime. #1542666: Clean up duplicate files.filepaths
Comment #14
drummRan into #1542854: system_update_7061() converts filepaths too aggressively too.
Comment #15
drummSuccess! update.php has completed once on http://7.devdrupal.org/. (That page WSODs because the home page code isn't D7 yet.)
Comment #16
drummComment #17
Senpai CreditAttribution: Senpai commentedDowngrading the priority and re-assigning to @nnewton for followup of any needed configuration or settings that still might need to be touched.
Comment #18
Senpai CreditAttribution: Senpai commentedComment #19
nnewton CreditAttribution: nnewton commentedClosing this.
Comment #19.0
nnewton CreditAttribution: nnewton commentedA couple things got done.