autotest: Iterate on database retries

Based on observations, change the database retry code.

The _cursor() fix has been proven (by examining failure logs) to be
insufficient.

By examining logs from job_aborter, MySQL can be inaccessible for many
minutes, due to load or whatever:

2018-07-30 15:32:35,246 START ERRORS
2018-07-30 15:36:27,160 END ERRORS

For now, do somewhat aggressive retries and see how it works out in
practice.  Since job_reporter is responsible only for making
Autotest database changes, there's not much harm in making it sleep
and retry a lot if it encounters a database connection error.  Worst
case it sticks around not being able to do anything for a while,
sleeping and not taking up too much resources.  The test will continue
to run under Lucifer, and maybe we'll be able to report back to
Autotest \_()_/

BUG=chromium:863504
TEST=None

Change-Id: I6b41a5e032b73376b83c04ccd793d10c3b95eea0
Reviewed-on: https://chromium-review.googlesource.com/1156044
Commit-Ready: Allen Li <ayatane@chromium.org>
Tested-by: Allen Li <ayatane@chromium.org>
Reviewed-by: Aviv Keshet <akeshet@chromium.org>
2 files changed
tree: c557f63d216c27b23ad8ff9f4deb75e45bcdb3a6
  1. apache/
  2. bin/
  3. cli/
  4. client/
  5. contrib/
  6. database/
  7. docs/
  8. frontend/
  9. leases/
  10. logs/
  11. results/
  12. scheduler/
  13. server/
  14. site_utils/
  15. skylab_migration/
  16. test_suites/
  17. tko/
  18. utils/
  19. venv/
  20. .gitignore
  21. .quickmerge_sentinel
  22. .style.yapf
  23. __init__.py
  24. COMMIT-QUEUE-moblab-pre-cq-only.ini
  25. COMMIT-QUEUE.ini
  26. common.py
  27. global_config.ini
  28. LGPL_LICENSE
  29. LICENSE
  30. metadata.chromium
  31. moblab_config.ini
  32. PRESUBMIT.cfg
  33. README.md
  34. ssp_deploy_config.json
README.md

Autotest: Automated integration testing for Android and Chrome OS Devices

Autotest is a framework for fully automated testing. It was originally designed to test the Linux kernel, and expanded by the Chrome OS team to validate complete system images of Chrome OS and Android.

Autotest is composed of a number of modules that will help you to do stand alone tests or setup a fully automated test grid, depending on what you are up to. A non extensive list of functionality is:

  • A body of code to run tests on the device under test. In this setup, test logic executes on the machine being tested, and results are written to files for later collection from a development machine or lab infrastructure.

  • A body of code to run tests against a remote device under test. In this setup, test logic executes on a development machine or piece of lab infrastructure, and the device under test is controlled remotely via SSH/adb/some combination of the above.

  • Developer tools to execute one or more tests. test_that for Chrome OS and test_droid for Android allow developers to run tests against a device connected to their development machine on their desk. These tools are written so that the same test logic that runs in the lab will run at their desk, reducing the number of configurations under which tests are run.

  • Lab infrastructure to automate the running of tests. This infrastructure is capable of managing and running tests against thousands of devices in various lab environments. This includes code for both synchronous and asynchronous scheduling of tests. Tests are run against this hardware daily to validate every build of Chrome OS.

  • Infrastructure to set up miniature replicas of a full lab. A full lab does entail a certain amount of administrative work which isn't appropriate for a work group interested in automated tests against a small set of devices. Since this scale is common during device bringup, a special setup, called Moblab, allows a natural progressing from desk -> mini lab -> full lab.

Run some autotests

See the guides to test_that and test_droid:

test_droid Basic Usage

test_that Basic Usage

Write some autotests

See the best practices guide, existing tests, and comments in the code.

Autotest Best Practices

Grabbing the latest source

git clone https://chromium.googlesource.com/chromiumos/third_party/autotest

Hacking and submitting patches

See the coding style guide for guidance on submitting patches.

Coding Style

Pre-upload hook dependencies

You need to run utils/build_externals.py to set up the dependencies for pre-upload hook tests.

Setting up Lucifer

Setting up Lucifer