0872 Upgrade Script Produces Paged Output

Bug #1297435 reported by Jason Stephenson on 2014-03-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Undecided
Unassigned

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.

tags: added: pullrequest
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  Edit
Everyone can see this information.

Other bug subscribers