stonedb
stonedb copied to clipboard
bug: There was a crash during the stress test
Have you read the Contributing Guidelines on issues?
- [X] I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- [X] I confirm there is no existing issue for this
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?
- [ ] Yes, I will!
[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
@shangyanwen you can enable the coredump, then gets the coredump file to help identify the root cause of crash.