主页 / user-225410

unknown's questions

Martin Hope
unknown
Asked: 2022-04-13 17:42:07 +0800 CST
  • 0

如何将mongodb当前featureCompatibilityVersion转换为只有版本的变量

而不是像这样打印

db.adminCommand( { getParameter: 1, featureCompatibilityVersion: 1 } )
{ "featureCompatibilityVersion" : { "version" : "4.0" }, "ok" : 1 }

使用 mongo shell 仅将版本分配给变量

fcv_version=$(eval "mongo <connection paramaeter> --eval '<oneliner to get fcv version>')
echo $fcv_version
4.0
mongodb
Martin Hope
unknown
Asked: 2021-08-14 21:40:39 +0800 CST
  • 1

一旦 mongorestore 完成。

大多数情况下，在主节点上完成还原后，其中一个节点将无法捕获主节点，并且该节点变得太陈旧而无法从主节点复制。

这可能是什么原因？

RS:PRIMARY> rs.printReplicationInfo()
configured oplog size:   4096MB
log length start to end: 18196secs (5.05hrs)
oplog first event time:  Sat Aug 14 2021 00:32:18 GMT+*****
oplog last event time:   Sat Aug 14 2021 05:35:34 GMT+*****
now:                     Sat Aug 14 2021 05:35:39 GMT+*****
RS:PRIMARY>

RS:RECOVERING> rs.printReplicationInfo()
configured oplog size:   4096MB
log length start to end: 679secs (0.19hrs)
oplog first event time:  Fri Aug 13 2021 23:38:21 GMT+*****
oplog last event time:   Fri Aug 13 2021 23:49:40 GMT+*****
now:                     Sat Aug 14 2021 05:27:25 GMT+*****
RS:RECOVERING> 

RS:SECONDARY> rs.printReplicationInfo()
configured oplog size:   4096MB
log length start to end: 17892secs (4.97hrs)
oplog first event time:  Sat Aug 14 2021 00:32:19 GMT+*****
oplog last event time:   Sat Aug 14 2021 05:30:31 GMT+*****
now:                     Sat Aug 14 2021 05:30:40 GMT+*****
RS:SECONDARY>
mongodb
Martin Hope
unknown
Asked: 2021-07-18 01:57:57 +0800 CST
  • 0

如果我必须从 rs.status 输出中获得类似于 SQL 语句的东西来打印 mongoDB 中属性的特定值 -

类似于来自 rs.status 的副本集的特定节点的打印运行状况。

select health from rs.status where hostname like 'abc:123'

或使用以下方法打印特定辅助副本节点相对于主节点的滞后时间：

print lagtime from rs.printSlaveReplicationInfo() where hostname like 'abc:123'

针对副本集连接字符串运行的简单查询或 JS 是什么？

mongodb
Martin Hope
unknown
Asked: 2021-07-08 19:46:16 +0800 CST
  • 0

有没有办法根据主机名而不是顺序来调整节点的优先级。

使用序列 -

cfg=rs.conf()
cfg.members[0].priority=100 
cfg.members[1].priority=10
cfg.members[2].priority=10
cfg.members[3].priority=0
cfg.members[4].priority=0
rs.reconfig(cfg)

我需要的是类似的东西，

cfg=rs.conf()
cfg.members[where name like 'abc'].priority=100 
cfg.members[where name like 'pqr'].priority=10
cfg.members[where name like 'xyz'].priority=10
cfg.members[where name like '10.12.13.14'].priority=0
cfg.members[where name like '10.12.13.14'].priority=0
rs.reconfig(cfg)

使用序列更新大量不同集群的副本集将是困难的。

主机名的顺序不是按顺序排列的。因此，如果我需要在维护期间更新具有最高优先级的特定主机，我不能依赖顺序。可能使用java脚本很容易。

mongodb
Martin Hope
unknown
Asked: 2021-07-06 22:24:38 +0800 CST
  • 1

添加第 5 个节点时出错

“我们的副本集配置无效或不包括我们

目前所有 4 个节点都是健康的。

节点 arb1 arb2
rs1 平方米，平方米，平方米 a1

当我尝试添加 a2 时，两个仲裁器都会立即变得不健康，而我的仲裁器本身是健康的，但在副本集中不健康。

节点 arb1 arb2
rs1 平方米，平方米，平方米 a1 a2

副本集中仲裁器错误 -

a1 -"lastHeartbeatMessage" : "Our replica set configuration is invalid or does not include us"

a2 -"lastHeartbeatMessage" : "Couldn't get a connection within the time limit"

在哪里，

m-数据节点

a-仲裁者

mongodb replication
Martin Hope
unknown
Asked: 2021-04-09 22:52:54 +0800 CST
  • 0

将操作系统从 Ubuntu 16 升级到 18 后无法启动 mongod 守护进程

root@dummy2:~# mongod --version
    db version v4.0.4
    git version: f288a3bdf201007f3693c58e140056adf8b04839
    OpenSSL version: OpenSSL 1.1.1  11 Sep 2018
    allocator: tcmalloc
    modules: none
    build environment:
        distmod: ubuntu1804
        distarch: x86_64
        target_arch: x86_64


root@dummy2:~# 
cat /etc/*-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=18.04
DISTRIB_CODENAME=bionic
DISTRIB_DESCRIPTION="Ubuntu 18.04.4 LTS"
NAME="Ubuntu"
VERSION="18.04.4 LTS (Bionic Beaver)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 18.04.4 LTS"
VERSION_ID="18.04"

root@dummy2:~# /usr/bin/mongod --config /etc/mongo/db8303/mongodb.conf &
/usr/lib/x86_64-linux-gnu/libcurl.so.4: version `CURL_OPENSSL_3' not found (required by /usr/bin/mongod)

我在 libcurl 版本的操作系统升级前后看到的差异：

前：

root@dummy2:~# ls -lrt /usr/lib/x86_64-linux-gnu/libcurl*
/usr/lib/x86_64-linux-gnu/libcurl.so.4 -> libcurl.so.4.4.0
/usr/lib/x86_64-linux-gnu/libcurl.so.3 -> libcurl.so.4
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.4 -> libcurl-gnutls.so.4.4.0
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.3 -> libcurl-gnutls.so.4
/usr/lib/x86_64-linux-gnu/libcurl.so.4.4.0
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.4.4.0

后：

root@dummy2:~# ls -lrt /usr/lib/x86_64-linux-gnu/libcurl
/usr/lib/x86_64-linux-gnu/libcurl.so.4 -> libcurl.so.4.5.0
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.4 -> libcurl-gnutls.so.4.5.0
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.3 -> libcurl-gnutls.so.4
/usr/lib/x86_64-linux-gnu/libcurl.so.4.5.0
/usr/lib/x86_64-linux-gnu/libcurl-gnutls.so.4.5.0

有没有人遇到过类似的问题？如何解决这个问题？

mongodb mongodb-4.0
Martin Hope
unknown
Asked: 2021-04-02 04:59:54 +0800 CST
  • 0

我能够从副本集的仲裁节点连接到辅助节点。

mongo -u backup02 -p backup02_password --port 8133 --host p1dummy:8133,p2dummy:8133,drdummy:8133 --authenticationDatabase admin --ssl --sslAllowInvalidCertificates

mongo8133:SECONDARY>

当我尝试使用没有发生的 mongodump 命令连接辅助节点形成仲裁节点时。使用 mongodump 命令，我传递的参数与 mongo 命令相同。我尝试启用详细日志，但这并没有给我完整的日志信息。我可以连接指定 p1dummy 作为参数但是我也应该能够使用连接字符串进行连接，就像我用于 mongo 的主机参数一样：

/usr/bin/mongodump -u backup02 -p backup02_password --port 8133 --host p1dummy:8133,p2dummy:8133,drdummy:8133 --authenticationDatabase admin --out /tmp --db mydbname --ssl --sslAllowInvalidCertificates --excludeCollectionsWithPrefix=system --verbose=5

2021-04-01T12:48:43.899+0000    will listen for SIGTERM, SIGINT, and SIGKILL
2021-04-01T12:48:47.400+0000    Failed: error connecting to db server: no reachable servers
mongodb mongodb-4.0
Martin Hope
unknown
Asked: 2021-03-13 04:28:28 +0800 CST
  • 0

Mongdb 启动警告记录，我在这个论坛上看到很多关于这些警告的问题，但是我想知道这些警告记录在哪里。我可以在 mongod.log 中找到它们。

有人可以分享这些警告日志的路径吗？

MongoDB server version: 3.4.1
Server has startup warnings:
2020-11-19T19:36:51.030-0800 I STORAGE  [initandlisten]
2020-11-19T19:36:51.030-0800 I STORAGE  [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with the WiredTiger storage engine
2020-11-19T19:36:51.030-0800 I STORAGE  [initandlisten] **          See http://dochub.mongodb.org/core/prodnotes-filesystem
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten]
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] ** WARNING: The server is started with the web server interface and access control.
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] **          The web interfaces (rest, httpinterface and/or jsonp) are insecure
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] **          and should be disabled unless required for backward compatibility.
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] ** WARNING: You are running this process as the root user, which is not recommended.
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten]
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten]
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/defrag is 'always'.
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] **        We suggest setting it to 'never'
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten]
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten] ** WARNING: soft rlimits too low. rlimits set to 128538 processes, 500000 files. Number of processes should be at least 250000 : 0.5 times number of files.
2020-11-19T19:44:38.433-0800 I CONTROL  [initandlisten]
mongo7052:SECONDARY>


MongoDB server version: 3.4.1
Server has startup warnings:
2021-02-19T00:04:24.384-0800 I CONTROL  [main] ** WARNING: --rest is specified without --httpinterface,
2021-02-19T00:04:24.384-0800 I CONTROL  [main] **          enabling http interface
2021-02-19T00:04:24.469-0800 I STORAGE  [initandlisten]
2021-02-19T00:04:24.469-0800 I STORAGE  [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with the WiredTiger storage engine
2021-02-19T00:04:24.469-0800 I STORAGE  [initandlisten] **          See http://dochub.mongodb.org/core/prodnotes-filesystem
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten]
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten] ** WARNING: The server is started with the web server interface and access control.
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten] **          The web interfaces (rest, httpinterface and/or jsonp) are insecure
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten] **          and should be disabled unless required for backward compatibility.
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten] ** WARNING: You are running this process as the root user, which is not recommended.
2021-02-19T00:04:27.390-0800 I CONTROL  [initandlisten]
2021-02-19T00:04:27.391-0800 I CONTROL  [initandlisten]
2021-02-19T00:04:27.391-0800 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/defrag is 'always'.
2021-02-19T00:04:27.391-0800 I CONTROL  [initandlisten] **        We suggest setting it to 'never'
2021-02-19T00:04:27.391-0800 I CONTROL  [initandlisten]
mongodb
Martin Hope
unknown
Asked: 2021-03-09 04:21:40 +0800 CST
  • 0

DummyD3 是 3 节点复制集群的 node3。DummyD2 是主要的，DummyD1 是次要的（与主要同步）。

我尝试删除数据路径下的数据，并在第一个在第二个 rsycn 中运行并启动守护进程时从其他辅助节点背靠背两次进行 rsync 以复制更新。

rsync -asvh Dummy1:/mongodb/data/dbinstance/* /mongodb/data/dbinstance
rsync -asvh Dummy1:/mongodb/data/dbinstance/* /mongodb/data/dbinstance
rm /mongodb/data/dbinstance/mongod.lock
rm /mongodb/data/dbinstance/mongod.pid
su - mongoinstance -c "/usr/bin/mongod --config /etc/mongo/dbinstance/mongodb.conf &"

从有问题的节点在屏幕上运行上述命令。

~# mongod --version
db version v4.0.4

我在这里寻找解决方案，如果有人有解决方案来帮助我解决这个问题。

root@DummyD3:~# tail /mongodb/files/errorlogs/dbinstance/mongodb.log 

 mongod(_ZN5mongo15printStackTraceERSo+0x41) [0x55c2e748caa1]
 mongod(+0x23D9CB9) [0x55c2e748bcb9]
 mongod(+0x23DA19D) [0x55c2e748c19d]
 libpthread.so.0(+0x11390) [0x7fa295382390]
 libc.so.6(gsignal+0x38) [0x7fa294fdc428]
 libc.so.6(abort+0x16A) [0x7fa294fde02a]
 mongod(_ZN5mongo32fassertFailedNoTraceWithLocationEiPKcj+0x0) [0x55c2e5ac1ea7]
 mongod(_ZN5mongo17wtRCToStatus_slowEiPKc+0x413) [0x55c2e5bb8eb3]
 mongod(_ZN5mongo18WiredTigerKVEngine15_openWiredTigerERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES8_+0x2D1) [0x55c2e5b90161]
 mongod(_ZN5mongo18WiredTigerKVEngineC1ERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES8_PNS_11ClockSourceES8_mbbbb+0x63F) [0x55c2e5b9611f]
 mongod(+0xAC6149) [0x55c2e5b78149]
 mongod(_ZN5mongo23initializeStorageEngineEPNS_14ServiceContextENS_22StorageEngineInitFlagsE+0x552) [0x55c2e62613a2]
 mongod(+0x993251) [0x55c2e5a45251]
 mongod(_ZN5mongo11mongoDbMainEiPPcS1_+0x10DB) [0x55c2e5b2d94b]
 mongod(main+0x9) [0x55c2e5ac3a39]
 libc.so.6(__libc_start_main+0xF0) [0x7fa294fc7830]
 mongod(_start+0x29) [0x55c2e5b2bab9]
-----  END BACKTRACE  -----
mongodb mongodb-4.0