2016-09-29 14:43:43.481541 | 2016-09-29 14:43:43.480 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L9:   /usr/local/bin/nova-manage db archive_deleted_rows --verbose --max_rows 1000
2016-09-29 14:43:47.614707 | 2016-09-29 14:43:47.614 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2016-09-29 14:43:47.616160 | 2016-09-29 14:43:47.615 |   result = self._query(query)
2016-09-29 14:43:48.134026 | 2016-09-29 14:43:48.132 | +-------------------------+-------------------------+
2016-09-29 14:43:48.137650 | 2016-09-29 14:43:48.136 | | Table                   | Number of Rows Archived |
2016-09-29 14:43:48.138856 | 2016-09-29 14:43:48.138 | +-------------------------+-------------------------+
2016-09-29 14:43:48.140079 | 2016-09-29 14:43:48.139 | | instance_actions_events | 467                     |
2016-09-29 14:43:48.142448 | 2016-09-29 14:43:48.141 | | reservations            | 434                     |
2016-09-29 14:43:48.144929 | 2016-09-29 14:43:48.144 | | virtual_interfaces      | 99                      |
2016-09-29 14:43:48.146298 | 2016-09-29 14:43:48.146 | +-------------------------+-------------------------+
2016-09-29 14:43:48.256767 | 2016-09-29 14:43:48.256 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L10:   [[ 1 -ne 1 ]]
2016-09-29 14:43:48.258370 | 2016-09-29 14:43:48.258 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L8:   for i in '`seq 30`'
2016-09-29 14:43:48.259919 | 2016-09-29 14:43:48.259 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L9:   /usr/local/bin/nova-manage db archive_deleted_rows --verbose --max_rows 1000
2016-09-29 14:43:51.685251 | 2016-09-29 14:43:51.684 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2016-09-29 14:43:51.686852 | 2016-09-29 14:43:51.686 |   result = self._query(query)
2016-09-29 14:43:52.203945 | 2016-09-29 14:43:52.203 | +--------------------------+-------------------------+
2016-09-29 14:43:52.205634 | 2016-09-29 14:43:52.205 | | Table                    | Number of Rows Archived |
2016-09-29 14:43:52.207245 | 2016-09-29 14:43:52.206 | +--------------------------+-------------------------+
2016-09-29 14:43:52.209082 | 2016-09-29 14:43:52.208 | | instance_system_metadata | 452                     |
2016-09-29 14:43:52.210231 | 2016-09-29 14:43:52.209 | | migrations               | 10                      |
2016-09-29 14:43:52.212593 | 2016-09-29 14:43:52.212 | | reservations             | 538                     |
2016-09-29 14:43:52.215769 | 2016-09-29 14:43:52.214 | +--------------------------+-------------------------+
2016-09-29 14:43:52.319183 | 2016-09-29 14:43:52.318 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L10:   [[ 1 -ne 1 ]]
2016-09-29 14:43:52.321799 | 2016-09-29 14:43:52.321 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L8:   for i in '`seq 30`'
2016-09-29 14:43:52.323568 | 2016-09-29 14:43:52.323 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L9:   /usr/local/bin/nova-manage db archive_deleted_rows --verbose --max_rows 1000
2016-09-29 14:43:55.773625 | 2016-09-29 14:43:55.772 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2016-09-29 14:43:55.774335 | 2016-09-29 14:43:55.774 |   result = self._query(query)
2016-09-29 14:43:56.329214 | 2016-09-29 14:43:56.328 | +--------------------------+-------------------------+
2016-09-29 14:43:56.330701 | 2016-09-29 14:43:56.330 | | Table                    | Number of Rows Archived |
2016-09-29 14:43:56.332374 | 2016-09-29 14:43:56.331 | +--------------------------+-------------------------+
2016-09-29 14:43:56.335082 | 2016-09-29 14:43:56.333 | | instance_extra           | 26                      |
2016-09-29 14:43:56.337345 | 2016-09-29 14:43:56.337 | | instance_info_caches     | 158                     |
2016-09-29 14:43:56.340336 | 2016-09-29 14:43:56.339 | | instance_metadata        | 15                      |
2016-09-29 14:43:56.342053 | 2016-09-29 14:43:56.341 | | instance_system_metadata | 801                     |
2016-09-29 14:43:56.343471 | 2016-09-29 14:43:56.343 | +--------------------------+-------------------------+
2016-09-29 14:43:56.443569 | 2016-09-29 14:43:56.442 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L10:   [[ 1 -ne 1 ]]
2016-09-29 14:43:56.445013 | 2016-09-29 14:43:56.444 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L8:   for i in '`seq 30`'
2016-09-29 14:43:56.446528 | 2016-09-29 14:43:56.446 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L9:   /usr/local/bin/nova-manage db archive_deleted_rows --verbose --max_rows 1000
2016-09-29 14:43:59.697815 | 2016-09-29 14:43:59.696 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2016-09-29 14:43:59.699043 | 2016-09-29 14:43:59.698 |   result = self._query(query)
2016-09-29 14:44:00.702051 | 2016-09-29 14:44:00.701 | +----------------------+-------------------------+
2016-09-29 14:44:00.703926 | 2016-09-29 14:44:00.703 | | Table                | Number of Rows Archived |
2016-09-29 14:44:00.705873 | 2016-09-29 14:44:00.705 | +----------------------+-------------------------+
2016-09-29 14:44:00.708232 | 2016-09-29 14:44:00.707 | | agent_builds         | 6                       |
2016-09-29 14:44:00.710881 | 2016-09-29 14:44:00.710 | | block_device_mapping | 174                     |
2016-09-29 14:44:00.712814 | 2016-09-29 14:44:00.712 | | floating_ips         | 6                       |
2016-09-29 14:44:00.714583 | 2016-09-29 14:44:00.713 | | instance_actions     | 412                     |
2016-09-29 14:44:00.716748 | 2016-09-29 14:44:00.716 | | instance_extra       | 132                     |
2016-09-29 14:44:00.719823 | 2016-09-29 14:44:00.718 | | instances            | 158                     |
2016-09-29 14:44:00.720286 | 2016-09-29 14:44:00.719 | | quotas               | 1                       |
2016-09-29 14:44:00.722148 | 2016-09-29 14:44:00.721 | +----------------------+-------------------------+
2016-09-29 14:44:00.838846 | 2016-09-29 14:44:00.838 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L10:   [[ 1 -ne 1 ]]
2016-09-29 14:44:00.841082 | 2016-09-29 14:44:00.839 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L8:   for i in '`seq 30`'
2016-09-29 14:44:00.842608 | 2016-09-29 14:44:00.842 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L9:   /usr/local/bin/nova-manage db archive_deleted_rows --verbose --max_rows 1000
2016-09-29 14:44:04.659098 | 2016-09-29 14:44:04.657 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2016-09-29 14:44:04.660777 | 2016-09-29 14:44:04.660 |   result = self._query(query)
2016-09-29 14:44:05.535438 | 2016-09-29 14:44:05.535 | Nothing was archived.
2016-09-29 14:44:05.647231 | 2016-09-29 14:44:05.646 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L10:   [[ 0 -ne 1 ]]
2016-09-29 14:44:05.649132 | 2016-09-29 14:44:05.648 | + /opt/stack/new/nova/tools/hooks/post_test_hook.sh:archive_deleted_rows:L11:   echo Archiving Complete
2016-09-29 14:44:05.651197 | 2016-09-29 14:44:05.650 | Archiving Complete