1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
#!/usr/bin/env python
#
# Public Domain 2014-present MongoDB, Inc.
# Public Domain 2008-2014 WiredTiger, Inc.
#
# This is free and unencumbered software released into the public domain.
#
# Anyone is free to copy, modify, publish, use, compile, sell, or
# distribute this software, either in source code form or as a compiled
# binary, for any purpose, commercial or non-commercial, and by any
# means.
#
# In jurisdictions that recognize copyright laws, the author or authors
# of this software dedicate any and all copyright interest in the
# software to the public domain. We make this dedication for the benefit
# of the public at large and to the detriment of our heirs and
# successors. We intend this dedication to be an overt act of
# relinquishment in perpetuity of all present and future rights to this
# software under copyright law.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
# OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
# ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.
#
# [TEST_TAGS]
# checkpoint:history_store
# [END_TAGS]
#
# test_checkpoint03.py
# Test that checkpoint writes out updates to the history store file.
#
from suite_subprocess import suite_subprocess
import wiredtiger, wttest
from wiredtiger import stat
from wtscenario import make_scenarios
class test_checkpoint03(wttest.WiredTigerTestCase, suite_subprocess):
tablename = 'test_checkpoint03'
conn_config = 'statistics=(all)'
uri = 'table:' + tablename
session_config = 'isolation=snapshot, '
key_format_values = [
('column', dict(key_format='r')),
('integer_row', dict(key_format='i')),
]
scenarios = make_scenarios(key_format_values)
def get_stat(self, stat):
stat_cursor = self.session.open_cursor('statistics:')
val = stat_cursor[stat][2]
stat_cursor.close()
return val
def test_checkpoint_writes_to_hs(self):
# Create a basic table.
self.session.create(self.uri, 'key_format={},value_format=i'.format(self.key_format))
self.session.begin_transaction()
self.conn.set_timestamp('oldest_timestamp=1')
# Insert 3 updates in separate transactions.
cur1 = self.session.open_cursor(self.uri)
cur1[1] = 1
self.session.commit_transaction('commit_timestamp=2')
self.session.begin_transaction()
cur1[1] = 2
self.session.commit_transaction('commit_timestamp=3')
self.session.begin_transaction()
cur1[1] = 3
self.session.commit_transaction('commit_timestamp=4')
# Call checkpoint.
self.session.checkpoint()
# Validate that we wrote to history store, note that the history store statistic is not
# counting how many writes we did, just that we did write. Hence for multiple writes it may
# only increment a single time.
hs_writes = self.get_stat(stat.conn.cache_write_hs)
self.assertGreaterEqual(hs_writes, 1)
# Add a new update.
self.session.begin_transaction()
cur1[1] = 4
self.session.commit_transaction('commit_timestamp=5')
self.session.checkpoint()
# Check that we wrote something to the history store in the last checkpoint we ran, as we
# should've written the previous update.
hs_writes = self.get_stat(stat.conn.cache_write_hs)
self.assertGreaterEqual(hs_writes, 2)
# Close the connection.
self.close_conn()
# Open a new connection and validate that we see the latest update as part of the datafile.
conn2 = self.setUpConnectionOpen('.')
session2 = self.setUpSessionOpen(conn2)
session2.create(self.uri, 'key_format={},value_format=i'.format(self.key_format))
cur2 = session2.open_cursor(self.uri)
cur2.set_key(1)
cur2.search()
self.assertEqual(cur2.get_value(), 4)
if __name__ == '__main__':
wttest.run()
|