Skip to content

[BUG] sysbench flaky #530

@nautaa

Description

@nautaa

Describe the bug
A clear and concise description of what the bug is.

add some observer.log to debug at first.

Run cd test/sysbench
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 10
Initializing random number generator from current time


Initializing worker threads...

Threads started!

FATAL: mysql_store_result() returned error 2013 (Lost connection to MySQL server during query)
(last message repeated 1 times)
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT * FROM sbtest1 WHERE k=4[7](https://github.com/oceanbase/miniob/actions/runs/13941989095/job/39020571510?pr=528#step:9:8)77'
FATAL: mysql_store_result() returned error 2013 (Lost connection to MySQL server during query)
(last message repeated 1 times)
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT * FROM sbtest1 WHERE k=4995'
FATAL: mysql_store_result() returned error 2013 (Lost connection to MySQL server during query)
(last message repeated 1 times)
FATAL: `thread_run' function failed: ./miniob_select.lua:31: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
FATAL: `thread_run' function failed: ./miniob_select.lua:31: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
FATAL: `thread_run' function failed: ./miniob_select.lua:31: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
(last message repeated 2 times)
FATAL: mysql_store_result() returned error 2013 (Lost connection to MySQL server during query)
(last message repeated 1 times)
FATAL: `thread_run' function failed: ./miniob_select.lua:31: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
(last message repeated 2 times)
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT * FROM sbtest1 WHERE k=537[8](https://github.com/oceanbase/miniob/actions/runs/13941989095/job/39020571510?pr=528#step:9:9)'
FATAL: `thread_run' function failed: ./miniob_select.lua:31: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
Error: Process completed with exit code 1.

ref: https://github.com/oceanbase/miniob/actions/runs/13941989095/job/39020571510?pr=528

** Environment**
Environment Details sometimes important

  • OS Version:
  • CPU Arch(x86/arm):
  • Compiler:
  • Others:

Fast Reproduce Steps(Required)
Steps to reproduce the behavior:

Expected behavior
A clear and concise description of what you expected to happen.

Actual Behavior
What is the result? picture is allowed

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions