Teamspeak + Mariadb -读取通信数据包时出错

ws51t4hk  于 2022-11-08  发布在  其他
关注(0)|答案(2)|浏览(142)

自从从SQLite切换到MariaDB后，我的TS3服务器上出现了几次崩溃，不幸的是，现在几乎每天都有。有人知道这个错误吗？
日志是针对2022年7月22日19：12：45 34的崩溃。崩溃后3秒的日志显示服务器正常启动，并在一秒内重新连接57个用户。
如果您需要更多的信息，请不要犹豫，问Greetings LFS96
我的Docker版本：

Client: Docker Engine - Community
 Version:           20.10.17
 API version:       1.41
 Go version:        go1.17.11
 Git commit:        100c701
 Built:             Mon Jun  6 23:03:11 2022
 OS/Arch:           linux/amd64
 Context:           default
 Experimental:      true

Server: Docker Engine - Community
 Engine:
  Version:          20.10.17
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.17.11
  Git commit:       a89b842
  Built:            Mon Jun  6 23:01:17 2022
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.6.6
  GitCommit:        10c12954828e7c7c9b6e0ea9b0c02b01407d3ae1
 runc:
  Version:          1.1.2
  GitCommit:        v1.1.2-0-ga916309
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
Docker Compose version v2.6.0

我的Dock合成文件：

version: '3.1'
services:
  teamspeak:
    image: teamspeak:latest
    container_name: teamspeak
    restart: always
    volumes:
      - "***/teamspeak:/var/ts3server/"
      - "***/licensekey.dat:/var/ts3server/licensekey.dat"
    ports:
      - 9987:9987/udp
      - 10011:10011
      - 30033:30033
    environment:
      TS3SERVER_DB_PLUGIN: ts3db_mariadb
      TS3SERVER_DB_SQLCREATEPATH: create_mariadb
      TS3SERVER_DB_HOST: db
      TS3SERVER_DB_USER: root
      TS3SERVER_DB_PASSWORD:*********
      TS3SERVER_DB_NAME: teamspeak
      TS3SERVER_DB_WAITUNTILREADY: 30
      TS3SERVER_LICENSE: accept
      TS3SERVER_DB_CONNECTIONS: 20
    depends_on:
      - db
  db:
    image: mariadb
    container_name: teamspeak-db
    restart: always
    volumes:
      - "***/teamspeak-db:/var/lib/mysql"
    environment:
      MYSQL_ROOT_PASSWORD:**************
      MYSQL_DATABASE: teamspeak

Mariadb的日志：

2022-07-20 07:17:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.8.3+maria~jammy started.
2022-07-20 07:17:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-07-20 07:17:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.8.3+maria~jammy started.
2022-07-20 07:17:49+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2022-07-20  7:17:49 0 [Note] mariadbd (server 10.8.3-MariaDB-1:10.8.3+maria~jammy) starting as process 1 ...
2022-07-20  7:17:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-07-20  7:17:49 0 [Note] InnoDB: Using transactional memory
2022-07-20  7:17:49 0 [Note] InnoDB: Number of transaction pools: 1
2022-07-20  7:17:49 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-07-20  7:17:49 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-07-20  7:17:49 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2022-07-20  7:17:49 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2022-07-20  7:17:49 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-07-20  7:17:49 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-20  7:17:49 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2022-07-20  7:17:49 0 [Note] InnoDB: 128 rollback segments are active.
2022-07-20  7:17:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2022-07-20  7:17:49 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-07-20  7:17:49 0 [Note] InnoDB: log sequence number 221395821; transaction id 52866
2022-07-20  7:17:49 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-07-20  7:17:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-20  7:17:49 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2022-07-20  7:17:49 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-07-20  7:17:49 0 [Note] Server socket created on IP: '::'.
2022-07-20  7:17:49 0 [Note] InnoDB: Buffer pool(s) load completed at 220720  7:17:49
2022-07-20  7:17:49 0 [Note] mariadbd: ready for connections.
Version: '10.8.3-MariaDB-1:10.8.3+maria~jammy'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2022-07-21 17:12:02 23 [Warning] Aborted connection 23 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 22 [Warning] Aborted connection 22 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 21 [Warning] Aborted connection 21 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 19 [Warning] Aborted connection 19 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 20 [Warning] Aborted connection 20 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 17 [Warning] Aborted connection 17 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 18 [Warning] Aborted connection 18 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 14 [Warning] Aborted connection 14 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 16 [Warning] Aborted connection 16 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 15 [Warning] Aborted connection 15 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 13 [Warning] Aborted connection 13 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 12 [Warning] Aborted connection 12 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 11 [Warning] Aborted connection 11 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 7 [Warning] Aborted connection 7 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 4 [Warning] Aborted connection 4 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 5 [Warning] Aborted connection 5 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 6 [Warning] Aborted connection 6 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 8 [Warning] Aborted connection 8 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 9 [Warning] Aborted connection 9 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-21 17:12:02 10 [Warning] Aborted connection 10 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 43 [Warning] Aborted connection 43 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 25 [Warning] Aborted connection 25 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 40 [Warning] Aborted connection 40 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 42 [Warning] Aborted connection 42 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 39 [Warning] Aborted connection 39 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 44 [Warning] Aborted connection 44 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 38 [Warning] Aborted connection 38 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 37 [Warning] Aborted connection 37 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 36 [Warning] Aborted connection 36 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 35 [Warning] Aborted connection 35 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 34 [Warning] Aborted connection 34 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 33 [Warning] Aborted connection 33 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 32 [Warning] Aborted connection 32 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 31 [Warning] Aborted connection 31 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 30 [Warning] Aborted connection 30 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 29 [Warning] Aborted connection 29 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 28 [Warning] Aborted connection 28 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 27 [Warning] Aborted connection 27 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 26 [Warning] Aborted connection 26 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)
2022-07-22 19:12:45 41 [Warning] Aborted connection 41 to db: 'teamspeak' user: 'root' host: '172.31.0.3' (Got an error reading communication packets)

TS3服务器日志：ServerProtector登录失败，是我的密码错误吗？

2022-07-21 17:12:04.820917|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.13.7 (2022-06-20 12:21:53)
2022-07-21 17:12:04.821276|INFO    |ServerLibPriv |   |SystemInformation: Linux 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) x86_64 Binary: 64bit
2022-07-21 17:12:04.821342|INFO    |ServerLibPriv |   |Using hardware aes
2022-07-21 17:12:04.823583|INFO    |DatabaseQuery |   |dbPlugin name:    MariaDB plugin, version 3, (c)TeamSpeak Systems GmbH
2022-07-21 17:12:04.823695|INFO    |DatabaseQuery |   |dbPlugin version: 2
2022-07-21 17:12:04.893830|INFO    |Accounting    |   |Licensing Information
2022-07-21 17:12:04.893950|INFO    |Accounting    |   |licensed to       :***
2022-07-21 17:12:04.894028|INFO    |Accounting    |   |type              : Activation License
2022-07-21 17:12:04.894121|INFO    |Accounting    |   |starting date     :***2022
2022-07-21 17:12:04.894178|INFO    |Accounting    |   |ending date       :***2023
2022-07-21 17:12:04.894214|INFO    |Accounting    |   |max virtualservers: 2
2022-07-21 17:12:04.894376|INFO    |Accounting    |   |max slots         : 128
2022-07-21 17:12:05.701148|INFO    |              |   |Puzzle precompute time: 765
2022-07-21 17:12:05.704537|INFO    |FileManager   |   |listening on 0.0.0.0:30033, [::]:30033
2022-07-21 17:12:05.708987|INFO    |Query         |   |Using a query thread pool size of 2
2022-07-21 17:12:05.865885|INFO    |Query         |   |listening for query on 0.0.0.0:10011, [::]:10011
2022-07-21 17:12:05.866109|INFO    |CIDRManager   |   |updated query_ip_allowlist ips: 127.0.0.1/32, ::1/128, 172.26.0.1/32,
2022-07-21 17:12:37.075323|INFO    |              |   |Increased protection level to: 1
2022-07-21 17:13:42.046104|INFO    |              |   |Decreased protection level to: 0
2022-07-22 07:12:51.343922|INFO    |              |   |myTeamSpeak identifier revocation list was downloaded successfully - all related features are activated
2022-07-22 08:36:08.921909|INFO    |Query         |   |query from 270 172.31.0.4:47086 attempted to login with account "ServerProtector" and failed!
2022-07-22 08:39:00.796296|INFO    |Query         |   |query from 271 172.31.0.4:47164 attempted to login with account "ServerProtector" and failed!
2022-07-22 08:42:00.716925|INFO    |Query         |   |query from 272 172.31.0.4:47226 attempted to login with account "ServerProtector" and failed!
2022-07-22 08:54:04.910678|INFO    |Query         |   |query from 276 172.31.0.4:47466 attempted to login with account "ServerProtector" and failed!
2022-07-22 08:57:04.807830|INFO    |Query         |   |query from 277 172.31.0.4:47598 attempted to login with account "ServerProtector" and failed!
2022-07-22 09:00:04.773872|INFO    |Query         |   |query from 278 172.31.0.4:47942 attempted to login with account "ServerProtector" and failed!
2022-07-22 09:10:46.547001|INFO    |Query         |   |query from 282 172.31.0.4:48804 attempted to login with account "ServerProtector" and failed!
2022-07-22 09:10:50.748387|INFO    |Query         |   |query from 283 172.31.0.4:48814 attempted to login with account "ServerProtector" and failed!
2022-07-22 09:12:04.926808|INFO    |Query         |   |query from 284 172.31.0.4
mariadb

2条答案

按热度按时间
s4chpxco

s4chpxco1#

“读取通信包时出错”最常见的原因是客户端的编码不严谨。如果客户端应用程序在实际关闭连接之前没有通知数据库服务器它打算关闭连接，则服务器只会看到客户端网络连接消失，同时仍在尝试从该连接读取进一步的查询。
由于数据库服务器现在不知道，也无法知道客户端是故意关闭连接，还是实际上是由客户端和服务器之间的网络问题引起的，因此它只能记录错误。
这是由log_warnings级别设置控制的，如果您不想让这些警告垃圾邮件您的数据库错误日志，您可以将警告级别降低为1，因为这些警告仅在级别2和更高级别记录

赞(0）分享  回复(0）举报  2022-11-08
uemypmqf

uemypmqf2#

更新：已解决
Docker中的IP范围已更改，因此IP白名单不再匹配。这导致Teamspeak溢出并崩溃。
通过编辑白名单修复

赞(0）分享  回复(0）举报  2022-11-08
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com