stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
862 stars 139 forks source link

bug: There was a crash during the stress test #1158

Open shangyanwen opened 1 year ago

shangyanwen commented 1 year ago

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

Describe the problem

###notes:Using the default Settings on stonedb, run the following script to observe the test results

mysqlslap -a -uroot -p123456 -h192.168.30.51 --create-schema=mysql_slap --iterations=10 --concurrency=8 --number-of-queries=100000 --auto-generate-sql --number-int-cols=5 --number-char-cols=20 --engine=tianmu

error:MySQL server has gone away

Expected behavior

No crash error is reported

How To Reproduce

mysqlslap -a -uroot -p123456 -h192.168.30.51 --create-schema=mysql_slap --iterations=10 --concurrency=8 --number-of-queries=100000 --auto-generate-sql --number-int-cols=5 --number-char-cols=20 --engine=tianmu

Environment

./mysqld  Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow: 
        Repository address: https://github.com/stoneatom/stonedb.git:HEAD
        Branch name: HEAD
        Last commit ID: b44a51ce8
        Last commit time: Date:   Fri Dec 2 16:11:06 2022 +0000
        Build time: Date: Mon Dec  5 06:12:44 UTC 2022

Are you interested in submitting a PR to solve the problem?

shangyanwen commented 1 year ago
[2022-12-23 17:40:21.036765] [51376] [INFO] [transaction.cpp:82] MSG: txn commit, modified tables size in txn: [1].
[2022-12-23 17:40:21.998871] [51930] [WARN] [MYSQL:0] MSG: InnoDB: Buffer pool(s) load completed at 221223 17:40:21
[2022-12-23 17:40:22.004083] [51867] [INFO] [mapped_circular_buffer.h:78] MSG: use delayed buffer file TIANMU_INSERT_BUFFER with size 512MB
[2022-12-23 17:40:22.004139] [51867] [INFO] [mapped_circular_buffer.h:208] MSG: insert buffer address 0x7fd5ac000000
[2022-12-23 17:40:22.004327] [51867] [INFO] [memory_handling_policy.cpp:94] MSG: Adjusted Main Heap size = 67509420032
[2022-12-23 17:40:22.004353] [51867] [INFO] [memory_handling_policy.cpp:95] MSG: Adjusted LT Heap size = 0
[2022-12-23 17:40:22.178670] [51867] [INFO] [engine.cpp:250] MSG: Tianmu engine started. 
[2022-12-23 17:40:22.178700] [51867] [INFO] [engine.cpp:251] MSG: Tianmu data directories:
[2022-12-23 17:40:22.178709] [51867] [INFO] [engine.cpp:252] MSG:   {
[2022-12-23 17:40:22.178717] [51867] [INFO] [engine.cpp:254] MSG:     default
[2022-12-23 17:40:22.178725] [51867] [INFO] [engine.cpp:261] MSG:   }
[2022-12-23 17:40:22.178749] [51867] [INFO] [engine.cpp:263] MSG: Tianmu thread pool for background load, size = 32
[2022-12-23 17:40:22.178758] [51867] [INFO] [engine.cpp:264] MSG: Tianmu thread pool for load, size = 64
[2022-12-23 17:40:22.178766] [51867] [INFO] [engine.cpp:265] MSG: Tianmu thread pool for query, size = 64
[2022-12-23 17:40:22.178899] [51867] [INFO] [ha_tianmu.cpp:2007] MSG: 
-----------------------------------------------------------------------------------------------------------
    ######  ########  #######  ##     ## ######## ######   ######   
   ##    ##    ##    ##     ## ####   ## ##       ##    ## ##    ## 
   ##          ##    ##     ## ## ##  ## ##       ##    ## ##    ## 
    ######     ##    ##     ## ##  ## ## ######   ##    ## ######## 
         ##    ##    ##     ## ##   #### ##       ##    ## ##    ## 
   ##    ##    ##    ##     ## ##    ### ##       ##    ## ##    ## 
    ######     ##     #######  ##     ## ######## ######   ######   
-----------------------------------------------------------------------------------------------------------

[2022-12-23 17:40:22.179234] [51867] [WARN] [MYSQL:0] MSG: Recovering after a crash using /opt/stonedb57/install/data/binlog
[2022-12-23 17:40:22.243893] [51867] [WARN] [MYSQL:0] MSG: Starting crash recovery...
[2022-12-23 17:40:22.243973] [51867] [WARN] [MYSQL:0] MSG: Crash recovery finished.
[2022-12-23 17:40:22.268617] [51867] [WARN] [MYSQL:0] MSG: Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.

# Supplementary error log
RingsC commented 1 year ago

@shangyanwen you can enable the coredump, then gets the coredump file to help identify the root cause of crash.