0872 Upgrade Script Produces Paged Output

Bug #1297435 reported by Jason Stephenson
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fix Released

Bug Description

In Evergreen master, the 0872.functions.metarecord-deleted-constituents.sql upgrade script includes a select statement that will produce several thousand rows of pageable output.

If you are running this script in the console and not redirecting your output to a file or another process, the upgrade process will halt as it waits for human input to scroll through the results.

The above is no big deal if you're running just this script by itself, but if you've fired off a loop to run a bunch of upgrade scripts at once and walked away from it, you may be in for a surprise when you return.

I suggest wrapping the select arguments in a count() function to ameliorate the above.

Branch to follow once I have the bug number.

Revision history for this message
Jason Stephenson (jstephenson) wrote :
tags: added: pullrequest
Revision history for this message
Ben Shum (bshum) wrote :

Agreed that this would be nicer for those who upgrade. Picked to master, thanks Jason.

Changed in evergreen:
milestone: none → 2.6.0-rc1
status: New → Fix Committed
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.