[MDEV-3167] LP:805930 - Sysbench breaks on multiple table test with MariaDB 5.2.7 + Aria Created: 2011-07-05 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | ||
| Reporter: | Vladimir Cvetkov (Inactive) | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
I run a benchmark test on pitbull.askmonty.org with the following settings:
Sometime after a few minutes of testing, an error occurs and breaks the benchmark. The problem is that the column 'k' does not have a unique constraint. Here is the "show create table sbtest13" output: This error may occur (or may not) randomly after a few minutes of testing and didn't happen on my local computer. The error occurred while testing with 1, 2, 4, 8 and 12 threads during a 10 minute test, and everything was OK with 16, 24, 48, 64 and 128 threads. Considering that pitbull has 12 CPUs with hyperthreading on: 24 virtual CPUs, this could be a clue (or just a coincidence though). Here is an example call to sysbench prepare statement: Here is an example call to sysbench run with 4 threads: |
| Comments |
| Comment by Vladimir Cvetkov (Inactive) [ 2011-07-05 ] |
|
Re: Sysbench breaks on multiple table test with MariaDB 5.2.7 + Aria |
| Comment by Vladimir Cvetkov (Inactive) [ 2011-07-05 ] |
|
The modified oltp.lua script that supports multiple table lock and Aria |
| Comment by Michael Widenius [ 2011-07-24 ] |
|
Re: Sysbench breaks on multiple table test with MariaDB 5.2.7 + Aria |
| Comment by Rasmus Johansson (Inactive) [ 2011-09-02 ] |
|
Launchpad bug id: 805930 |