Repository navigation
Commit 925d859
committed
test: reproduce the RepartitionExec spill pool deadlock with a SQL query
Add the query from issue apache#24883 as a test. It is a grouped
COUNT(DISTINCT) on a Utf8View column, with a 4 MB memory limit, two
partitions and 64-row batches. Those values send `RepartitionExec` into
its spill path.
On the current code, attempt 0 does not complete. The test stops each
attempt after 20 seconds and fails with a message. It makes 12 attempts,
because one attempt that completes is not sufficient for a pass.
The memory limit must be small enough that `RepartitionExec` spills, and
that window is narrow: at 4 MB the inner repartition spills in 10 of 10
runs, and at 6 MB and more it never spills. Thus the test also sums the
`spill_count` metric of the `RepartitionExec` nodes and fails if no
attempt spilled. If a later change stops the query from spilling, the test
says so instead of passing while it covers nothing.
At 4 MB the greedy memory pool sometimes refuses an allocation of the
final aggregate. That is a correct result of the limit and not a fault, so
the test accepts a resources-exhausted error. In 3000 attempts, one
attempt failed in this way.
The module is not compiled with `force_hash_collisions`. That feature makes
every hash 0, so the hash `RepartitionExec` sends all rows to one output
partition. The gate of the distributor channels closes only when each
channel holds data, thus the deadlock cannot occur and the test cannot show
it. The feature also makes the group-by hash table degenerate, which made
one attempt of this query approximately 36 times slower and thus longer
than the limit above.
A sqllogictest file is not suitable for this test. sqllogictest has no
time limit, so a return of the deadlock stops the file until the CI job
reaches its time limit, instead of a quick failure with a message. It also
cannot say "these rows, or this resource error", so it would fail
approximately 1 CI run in 400.
Ref: apache#24883
Co-Authored-By: Claude Opus 5 <[email protected]>
Claude-Session: https://claude.ai/code/session_01RauD5PqPCp4y92RUZUD6C91 parent da89c7c commit 925d859
1 file changed
Lines changed: 154 additions & 0 deletions
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
117 | 117 | | |
118 | 118 | | |
119 | 119 | | |
| 120 | + | |
| 121 | + | |
| 122 | + | |
| 123 | + | |
| 124 | + | |
| 125 | + | |
| 126 | + | |
| 127 | + | |
| 128 | + | |
| 129 | + | |
| 130 | + | |
| 131 | + | |
| 132 | + | |
| 133 | + | |
| 134 | + | |
| 135 | + | |
| 136 | + | |
| 137 | + | |
| 138 | + | |
| 139 | + | |
| 140 | + | |
| 141 | + | |
| 142 | + | |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
| 148 | + | |
| 149 | + | |
| 150 | + | |
| 151 | + | |
| 152 | + | |
| 153 | + | |
| 154 | + | |
| 155 | + | |
| 156 | + | |
| 157 | + | |
| 158 | + | |
| 159 | + | |
| 160 | + | |
| 161 | + | |
| 162 | + | |
| 163 | + | |
| 164 | + | |
| 165 | + | |
| 166 | + | |
| 167 | + | |
| 168 | + | |
| 169 | + | |
| 170 | + | |
| 171 | + | |
| 172 | + | |
| 173 | + | |
| 174 | + | |
| 175 | + | |
| 176 | + | |
| 177 | + | |
| 178 | + | |
| 179 | + | |
| 180 | + | |
| 181 | + | |
| 182 | + | |
| 183 | + | |
| 184 | + | |
| 185 | + | |
| 186 | + | |
| 187 | + | |
| 188 | + | |
| 189 | + | |
| 190 | + | |
| 191 | + | |
| 192 | + | |
| 193 | + | |
| 194 | + | |
| 195 | + | |
| 196 | + | |
| 197 | + | |
| 198 | + | |
| 199 | + | |
| 200 | + | |
| 201 | + | |
| 202 | + | |
| 203 | + | |
| 204 | + | |
| 205 | + | |
| 206 | + | |
| 207 | + | |
| 208 | + | |
| 209 | + | |
| 210 | + | |
| 211 | + | |
| 212 | + | |
| 213 | + | |
| 214 | + | |
| 215 | + | |
| 216 | + | |
| 217 | + | |
| 218 | + | |
| 219 | + | |
| 220 | + | |
| 221 | + | |
| 222 | + | |
| 223 | + | |
| 224 | + | |
| 225 | + | |
| 226 | + | |
| 227 | + | |
| 228 | + | |
| 229 | + | |
| 230 | + | |
| 231 | + | |
| 232 | + | |
| 233 | + | |
| 234 | + | |
| 235 | + | |
| 236 | + | |
| 237 | + | |
| 238 | + | |
| 239 | + | |
| 240 | + | |
| 241 | + | |
| 242 | + | |
| 243 | + | |
| 244 | + | |
| 245 | + | |
| 246 | + | |
| 247 | + | |
| 248 | + | |
| 249 | + | |
| 250 | + | |
| 251 | + | |
| 252 | + | |
| 253 | + | |
| 254 | + | |
| 255 | + | |
| 256 | + | |
| 257 | + | |
| 258 | + | |
| 259 | + | |
| 260 | + | |
| 261 | + | |
| 262 | + | |
| 263 | + | |
| 264 | + | |
| 265 | + | |
| 266 | + | |
| 267 | + | |
| 268 | + | |
| 269 | + | |
| 270 | + | |
| 271 | + | |
| 272 | + | |
| 273 | + | |
0 commit comments