Details
-
Bug
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
None
-
ALL
Description
Hello,
We have a single replica set with 3 nodes running 3.4.14 with WiredTiger.
After dropping lots of collections frequently, we found
- the file sizeStorer.wt is growing up slowly
- the mem of mongod grow slowly
finally mongod was killed by oom-killer, and sizeStorer.wt grow up to 300MB
Test script
db = db.getSiblingDB("testdb"); |
var count = 0; |
do{ |
col = db.getCollection("sizeStore"); |
col.insert({"name":"aa"}); |
doc=col.findOne();
|
printjson(doc)
|
db.sizeStore.drop();
|
sleep(1);
|
count ++;
|
print("create table count " +count); |
}while(true) |
|
-rw------- 1 Ruby Ruby 49 Feb 25 02:59 WiredTiger
|
-rw------- 1 Ruby Ruby 21 Feb 25 02:59 WiredTiger.lock
|
-rw------- 1 Ruby Ruby 1011 Feb 28 07:20 WiredTiger.turtle
|
-rw------- 1 Ruby Ruby 548864 Feb 28 07:20 WiredTiger.wt
|
-rw------- 1 Ruby Ruby 4096 Feb 26 00:55 WiredTigerLAS.wt
|
-rw------- 1 Ruby Ruby 36864 Feb 27 21:25 _mdb_catalog.wt
|
drwx------ 4 Ruby Ruby 4096 Feb 25 02:59 admin
|
drwx------ 2 Ruby Ruby 4096 Feb 28 07:20 diagnostic.data
|
drwx------ 2 Ruby Ruby 4096 Feb 27 19:36 journal
|
drwx------ 4 Ruby Ruby 4096 Feb 25 02:59 local |
-rw------- 1 Ruby Ruby 5 Feb 26 00:55 mongod.lock
|
-rw------- 1 root root 81 Feb 26 01:58 monitor.sh
|
-rw------- 1 Ruby Ruby 303792128 Feb 28 07:20 sizeStorer.wt
|
-rw------- 1 Ruby Ruby 95 Feb 25 02:59 storage.bson
|
drwx------ 4 Ruby Ruby 4096 Feb 25 10:28 testdb
|
Feb 27 21:24:49 localhost kernel: [239239.871767] Out of memory: Kill process 13316 (mongod) score 863 or sacrifice child
|
Feb 27 21:24:49 localhost kernel: [239239.871801] Killed process 13316 (mongod) total-vm:6096592kB, anon-rss:3286352kB, file-rss:0kB |
Feb 27 21:24:49 localhost kernel: [239239.873442] systemd-journal: page allocation failure: order:0, mode:0x201da
|
Feb 27 21:24:49 localhost kernel: [239239.873445] CPU: 1 PID: 451 Comm: systemd-journal Tainted: G OE ----V------- 3.10.0-327.62.59.83.h128.x86_64 #1 |
Feb 27 21:24:49 localhost kernel: [239239.873446] Hardware name: OpenStack Foundation OpenStack Nova, BIOS rel-1.10.2-0-g5f4c7b1-20181220_000000-szxrtosci10000 04/01/2014 |
Feb 27 21:24:49 localhost kernel: [239239.873447] Call Trace:
|
The above scenario is just a simplification of our business.
In actual business, we create and delete almost 30000 collections per day.
Approximately every 10 days, our business also meet database crash by OOM-killer.
So I would like to know:
How often does Mongodb support DDL operations?
Thanks for your help.