Bug 991245 - show detailed information about state of the installation
Summary: show detailed information about state of the installation
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: general
Version: 0.13
Hardware: Unspecified
OS: Unspecified
medium
unspecified
Target Milestone: 23.0
Assignee: Dan Callaghan
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks: 1168527 1263918
TreeView+ depends on / blocked
 
Reported: 2013-08-01 23:53 UTC by Dan Callaghan
Modified: 2018-02-06 00:41 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-07-07 23:10:57 UTC
Embargoed:


Attachments (Terms of Use)

Description Dan Callaghan 2013-08-01 23:53:47 UTC
At the moment after a system is provisioned for a recipe, the recipe state changes to Running but no other details are recorded against the job. When it hits Anaconda %pre we also record the /start result, but that's it.

Beaker knows much more about the progress of the installation than that. It should make all of that information available in the recipe results, to help users figure out what went wrong if the recipe Aborts during the installation.

Specifically:

* There should be an extra recipe state, Installing (or Provisioning?), while the install is running. The recipe state changes to Running only once the harness has reported in and started the first task.

* The recipe results should have a little expando or some other thing which shows timestamps of which stages the provisioning has reached. The current stages we track are rebooted, Anaconda %pre, and Anaconda %post. Anamon could also be expanded to report more detail. This info should be hidden by default, because if the job has run then users won't care about the install.

* Optionally, it could also show detailed logs of exactly what Beaker is doing for the provision, including netboot configs written and power scripts executed. Right now all the server has is the commands and their status, but beaker-provision could send more detailed info about each command as it runs.

Comment 2 Nick Coghlan 2014-01-23 00:20:18 UTC
We also need to document the new element that Beaker 0.15.3 adds to the recipe result XML:


<installation install_finished="2014-01-22 22:43:15" install_started="2014-01-22 22:35:36" postinstall_finished="2014-01-22 22:44:30"/>

Comment 3 Dan Callaghan 2016-02-19 00:59:29 UTC
The UI side of this bug is covered by the recipe page redesign which we have been working on:

https://beaker-project.org/dev/proposals/job-page-improvements.html

so this bug will just be about the server-side changes needed to make that possible.

The first part is introducing a new table to track installations, which will consolidate a lot of the various pieces that have been tacked onto other tables over the years (the installation progress timestamps on recipe_resource being the main ones):

http://gerrit.beaker-project.org/4684

That patch is complete and ready to be merged, and should be enough to get the UI implementation done.

The remaining piece for this bug is introducing the new Installing status and removing the /start result and the first_task.start() stuff that we currently do to indicate that the recipe has started installing. Those changes are *not* necessary for the UI implementation although they *are* necessary for taskless reservations (bug 1168527). This second piece is not done yet.

Comment 4 Dan Callaghan 2016-04-05 10:38:13 UTC
Need to also find a faster way of doing this migration. What we have now is correct but too slow.

Even in our devel environment, which has only a modest amount of historical data, this query took more than 10 minutes:

        UPDATE command_queue
        INNER JOIN activity ON activity.id = command_queue.id
        INNER JOIN reservation ON reservation.system_id = command_queue.system_id
            AND activity.created >= reservation.start_time
            AND (activity.created <= reservation.finish_time
                 OR reservation.finish_time IS NULL)
        INNER JOIN system_resource ON system_resource.reservation_id = reservation.id
        INNER JOIN recipe_resource ON recipe_resource.id = system_resource.id
        INNER JOIN installation ON installation.recipe_id = recipe_resource.recipe_id
        SET command_queue.installation_id = installation.id
        WHERE callback = 'bkr.server.model.auto_cmd_handler'

Comment 5 Dan Callaghan 2016-04-07 03:34:43 UTC
(In reply to Dan Callaghan from comment #4)

So the problematic part of this query is:

>         INNER JOIN reservation ON reservation.system_id =
> command_queue.system_id
>             AND activity.created >= reservation.start_time
>             AND (activity.created <= reservation.finish_time
>                  OR reservation.finish_time IS NULL)

specifically, the >= <= condition to match up the command queue entry with the reservation during which it occurred.

But that's the one piece we absolutely need in this query, there's no other way I can think of to match up command queue entries with their recipe. (Indeed that is the whole purpose of this bug, to give us a way to do that in future, through the installation table.)

The other contributing factor is that command_queue is one of our biggest tables (> 12 million rows in production), and activity is even bigger (> 32 million rows).

So I think it's unavoidable that we will have to cop the very high cost of this query. The only alternative is that we won't be able to show any kernel options or power commands on the new recipe page for any recipes which ran prior to the upgrade.

What we *can* do is run this query as a kind of "online data migration". It's not creating any schema necessary for the new Beaker code to run, it's just backpopulating data so that Beaker will show accurate info for existing recipes. That means we don't strictly need to run it during an outage, it can be run after the actual schema migrations are completed and Beaker is back up and running.

I am thinking we could introduce a new option to beaker-init for running specific online data migrations, after the schema migrations are done. Something like,

beaker-init --background --online-data-migration=commands-for-recipe-installations

We would need to make the query into batches and also idempotent (not repopulated already populated rows) so that the online migration process could be restarted.

Comment 6 Dan Callaghan 2016-04-11 05:34:39 UTC
(In reply to Dan Callaghan from comment #5)

http://gerrit.beaker-project.org/4795

Comment 7 Dan Callaghan 2016-04-11 07:47:55 UTC
(In reply to Dan Callaghan from comment #3)
> The remaining piece for this bug is introducing the new Installing status
> and removing the /start result and the first_task.start() stuff that we
> currently do to indicate that the recipe has started installing. Those
> changes are *not* necessary for the UI implementation although they *are*
> necessary for taskless reservations (bug 1168527). This second piece is not
> done yet.

http://gerrit.beaker-project.org/4797

Comment 8 Dan Callaghan 2016-04-14 00:15:28 UTC
Need to find and fix these warnings:

2016-04-14 09:46:40,069 alembic.migration INFO Running upgrade 3c5510511fd9 -> 51637c12cbd9, Create installation table
/usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py:324: Warning: Column 'created' cannot be null
  cursor.execute(statement, parameters)
/usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py:324: Warning: Column 'kernel_options' cannot be null
  cursor.execute(statement, parameters)

Comment 9 Dan Callaghan 2016-04-15 01:25:42 UTC
(In reply to Dan Callaghan from comment #8)
> Need to find and fix these warnings:
> 
> 2016-04-14 09:46:40,069 alembic.migration INFO Running upgrade 3c5510511fd9
> -> 51637c12cbd9, Create installation table
> /usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py:324:
> Warning: Column 'created' cannot be null
>   cursor.execute(statement, parameters)

This one would be because we are populating installation.created based on recipe.start_time for guest_resource rows. But for guest recipes, a guest_resource row is always created as soon as the host recipe is scheduled -- even if the host recipe is cancelled or fails/aborts before it ever even starts, meaning that recipe.start_time is NULL.

In that case, strictly speaking installation.created should be set to the timestamp at which the host recipe was provisioned because that is how it will be done for new recipes after this patch. The closest we can probably get is to use reservation.start_time for the host recipe. It will make the query a bit fat but it should still perform fine.

> /usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py:324:
> Warning: Column 'kernel_options' cannot be null
>   cursor.execute(statement, parameters)

Similarly, for guest_resource rows we are just copying kernel_options from recipe.kernel_options but that can be NULL on older rows. We can just COALESCE with empty string.

Comment 10 Dan Callaghan 2016-04-15 03:50:22 UTC
(In reply to Dan Callaghan from comment #9)
> The closest we can probably
> get is to use reservation.start_time for the host recipe.

... except we have 4121 guest recipes where the guest_resource was allocated but the system_resource was not, somehow. Sigh.

Comment 11 Dan Callaghan 2016-04-15 04:05:37 UTC
(In reply to Dan Callaghan from comment #10)
> ... except we have 4121 guest recipes where the guest_resource was allocated
> but the system_resource was not, somehow. Sigh.

For those we will have to just fall back to 1970-01-01 because there is literally no other timestamp we can use. At least it avoids the warning from inserting NULL into a non-NULLable column. For the rest of the rows we can use the host recipe's reservation.start_time.

http://gerrit.beaker-project.org/4810

(In reply to Dan Callaghan from comment #9)
> Similarly, for guest_resource rows we are just copying kernel_options from
> recipe.kernel_options but that can be NULL on older rows. We can just
> COALESCE with empty string.

http://gerrit.beaker-project.org/4809

Comment 12 Dan Callaghan 2016-04-19 05:35:04 UTC
(In reply to Dan Callaghan from comment #7)

One problem with the new Installing status is that beah considers any status aside from Waiting or Running to mean that the recipe is finished. I have a beah patch for that here:

https://gerrit.beaker-project.org/4818

but it means for backwards compatibility with older beah versions we should also ensure that Beaker sets the status to Waiting once the installation is finished and the recipe is waiting for beah to start up and pick up tasks.

Comment 14 Dan Callaghan 2016-04-21 23:55:55 UTC
(In reply to Dan Callaghan from comment #12)
> but it means for backwards compatibility with older beah versions we should
> also ensure that Beaker sets the status to Waiting once the installation is
> finished and the recipe is waiting for beah to start up and pick up tasks.

This is still not working right, causing beah to end recipes with:

2016-04-21 03:29:59,126 backend handle_recipe_exception: INFO The recipe has finished.

Comment 15 Dan Callaghan 2016-04-22 02:11:06 UTC
(In reply to Dan Callaghan from comment #14)

The problem is, this code:

https://git.beaker-project.org/cgit/beaker/tree/Server/bkr/server/model/scheduler.py?id=53d54a5fbd15b282ce3310dfe3e9bf41d1d942c9#n2454

and its corresponding test case:

https://git.beaker-project.org/cgit/beaker/tree/IntegrationTests/src/bkr/inttest/server/test_update_status.py?id=53d54a5fbd15b282ce3310dfe3e9bf41d1d942c9#n153

are assuming that job.update_status() will set the status back to Waiting once the installation.postinstall_finished timestamp has been set. And it would -- except that the job will never be marked dirty and so beakerd will never invoke update_status() on the job.

This is really a flaw in the way that the test cases invoke job.update_status() directly, even if in reality it wouldn't actually happen because the job is not actually dirty.

I am thinking to avoid this in future we might be able to assert in job.update_status() that it was invoked on a job that is actually marked as dirty already.

Comment 16 Dan Callaghan 2016-04-22 03:24:35 UTC
(In reply to Dan Callaghan from comment #15)

https://gerrit.beaker-project.org/4819

Comment 17 Dan Callaghan 2016-04-28 06:09:02 UTC
I forgot one last piece, which was to actually make the Installation tab say that it was installing when the status was Installing. You might say, the entire point of this bug :-)

http://gerrit.beaker-project.org/4848

Comment 20 Dan Callaghan 2016-07-07 23:10:57 UTC
Beaker 23.0 has been released.


Note You need to log in before you can comment on or make changes to this bug.