【已完成】SOL数据库，每天会莫名其妙的关闭。

下面是截图的安全内的，运行日志。和运行日志的部分内容。

求助官方人员，大神，坛友们的鼎力相助。

最后一张图是：SOL数据库，每天会莫名其妙的关闭。

您好！服务器命令行执行以下命令查看MySQL错误日志,  截图看一下结果

1. cat /www/server/data/*.err|grep -i -C 10 error

复制代码

Current dir: /www/server/data/
Running threads: 0  Stack size: 262144
Current locks:
lock: 0x35751b0:

lock: 0x348cf70:

lock: 0x349a810:

lock: 0x3439800:

lock: 0x3488f10:

lock: 0x347bc60:

lock: 0x3469320:

lock: 0x3470990:

lock: 0x34526e0:

lock: 0x3449760:

lock: 0x3441390:

lock: 0x1372840:

lock: 0x1372780:

lock: 0x1371a00:

lock: 0x1371940:

lock: 0x1371880:

lock: 0x1371b80:

lock: 0x1370200:

lock: 0x13726c0:

lock: 0x1370800:

lock: 0x1370a40:

lock: 0x1370740:

lock: 0x1370980:

lock: 0x1370680:

lock: 0x13708c0:

lock: 0x1370d40:

lock: 0x1370e00:

lock: 0x1370ec0:

lock: 0x13705c0:

lock: 0x1370380:

lock: 0x1370500:

lock: 0x13702c0:

lock: 0x1370440:

lock: 0x1370b00:

lock: 0x1370bc0:

lock: 0x1370c80:

lock: 0x13723c0:

lock: 0x1372600:

lock: 0x1372540:

lock: 0x1372480:

lock: 0x13720c0:

lock: 0x1372000:

lock: 0x1371f40:

lock: 0x1371e80:

lock: 0x1371dc0:

lock: 0x1372240:

lock: 0x1371d00:

lock: 0x1371c40:

lock: 0x1372300:

lock: 0x1371ac0:

lock: 0x1371700:

lock: 0x13717c0:

lock: 0x1371640:

lock: 0x1371580:

lock: 0x1371280:

lock: 0x13714c0:

lock: 0x1371400:

lock: 0x13711c0:

lock: 0x1371340:

lock: 0x1370f80:

lock: 0x1371040:

lock: 0x1371100:

lock: 0x1372180:


Key caches:
default
Buffer_size:     134217728
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0


handler status:
read_key:            3
read_next:           0
read_rnd             0
read_first:          6
write:               0
delete               0
update:              0

Table status:
Opened tables:         70
Open tables:           63
Open files:            17
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
  <size from="17" to="32" total="128" count="4"/>
  <size from="65" to="80" total="320" count="4"/>
  <size from="81" to="96" total="96" count="1"/>
  <size from="97" to="112" total="112" count="1"/>
  <size from="113" to="128" total="128" count="1"/>
  <size from="33" to="33" total="396" count="12"/>
  <size from="81" to="81" total="2025" count="25"/>
  <size from="97" to="97" total="97" count="1"/>
  <size from="113" to="113" total="452" count="4"/>
  <size from="129" to="129" total="2193" count="17"/>
  <size from="161" to="161" total="1288" count="8"/>
  <size from="209" to="209" total="418" count="2"/>
  <unsorted from="145" to="13105" total="16166" count="6"/>
</sizes>
<total type="fast" count="11" size="784"/>
<total type="rest" count="75" size="23035"/>
<system type="current" size="25464832"/>
<system type="max" size="25464832"/>
<aspace type="total" size="25464832"/>
<aspace type="mprotect" size="25464832"/>
</heap>
<heap nr="1">
<sizes>
  <size from="113" to="128" total="128" count="1"/>
</sizes>
<total type="fast" count="1" size="128"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="2">
<sizes>
  <size from="49" to="49" total="49" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="49"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="3">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="4">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="5">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="6">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="7">
<sizes>
  <size from="97" to="97" total="97" count="1"/>
  <size from="113" to="113" total="113" count="1"/>
  <size from="1761" to="1761" total="1761" count="1"/>
  <unsorted from="8337" to="30849" total="39186" count="2"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="5" size="41157"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="8">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<total type="fast" count="12" size="912"/>
<total type="rest" count="81" size="64241"/>
<total type="mmap" count="53" size="539344896"/>
<system type="current" size="26546176"/>
<system type="max" size="26546176"/>
<aspace type="total" size="26546176"/>
<aspace type="mprotect" size="26546176"/>
</malloc>



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:146
LUA             : init_queue:156
WOC             : NO
Next activation : never

堡塔运维向樛木 发表于 2023-3-5 10:17
您好！服务器命令行执行以下命令查看MySQL错误日志,  截图看一下结果

已经回复了，麻烦看下啦。运维小伙伴

堡塔运维向樛木 发表于 2023-3-5 10:17
您好！服务器命令行执行以下命令查看MySQL错误日志,  截图看一下结果

Current dir: /www/server/data/
Running threads: 0  Stack size: 262144
Current locks:
lock: 0x35751b0:

lock: 0x348cf70:

lock: 0x349a810:

lock: 0x3439800:

lock: 0x3488f10:

lock: 0x347bc60:

lock: 0x3469320:

lock: 0x3470990:

lock: 0x34526e0:

lock: 0x3449760:

lock: 0x3441390:

lock: 0x1372840:

lock: 0x1372780:

lock: 0x1371a00:

lock: 0x1371940:

lock: 0x1371880:

lock: 0x1371b80:

lock: 0x1370200:

lock: 0x13726c0:

lock: 0x1370800:

lock: 0x1370a40:

lock: 0x1370740:

lock: 0x1370980:

lock: 0x1370680:

lock: 0x13708c0:

lock: 0x1370d40:

lock: 0x1370e00:

lock: 0x1370ec0:

lock: 0x13705c0:

lock: 0x1370380:

lock: 0x1370500:

lock: 0x13702c0:

lock: 0x1370440:

lock: 0x1370b00:

lock: 0x1370bc0:

lock: 0x1370c80:

lock: 0x13723c0:

lock: 0x1372600:

lock: 0x1372540:

lock: 0x1372480:

lock: 0x13720c0:

lock: 0x1372000:

lock: 0x1371f40:

lock: 0x1371e80:

lock: 0x1371dc0:

lock: 0x1372240:

lock: 0x1371d00:

lock: 0x1371c40:

lock: 0x1372300:

lock: 0x1371ac0:

lock: 0x1371700:

lock: 0x13717c0:

lock: 0x1371640:

lock: 0x1371580:

lock: 0x1371280:

lock: 0x13714c0:

lock: 0x1371400:

lock: 0x13711c0:

lock: 0x1371340:

lock: 0x1370f80:

lock: 0x1371040:

lock: 0x1371100:

lock: 0x1372180:


Key caches:
default
Buffer_size:     134217728
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0


handler status:
read_key:            3
read_next:           0
read_rnd             0
read_first:          6
write:               0
delete               0
update:              0

Table status:
Opened tables:         70
Open tables:           63
Open files:            17
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
  <size from="17" to="32" total="128" count="4"/>
  <size from="65" to="80" total="320" count="4"/>
  <size from="81" to="96" total="96" count="1"/>
  <size from="97" to="112" total="112" count="1"/>
  <size from="113" to="128" total="128" count="1"/>
  <size from="33" to="33" total="396" count="12"/>
  <size from="81" to="81" total="2025" count="25"/>
  <size from="97" to="97" total="97" count="1"/>
  <size from="113" to="113" total="452" count="4"/>
  <size from="129" to="129" total="2193" count="17"/>
  <size from="161" to="161" total="1288" count="8"/>
  <size from="209" to="209" total="418" count="2"/>
  <unsorted from="145" to="13105" total="16166" count="6"/>
</sizes>
<total type="fast" count="11" size="784"/>
<total type="rest" count="75" size="23035"/>
<system type="current" size="25464832"/>
<system type="max" size="25464832"/>
<aspace type="total" size="25464832"/>
<aspace type="mprotect" size="25464832"/>
</heap>
<heap nr="1">
<sizes>
  <size from="113" to="128" total="128" count="1"/>
</sizes>
<total type="fast" count="1" size="128"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="2">
<sizes>
  <size from="49" to="49" total="49" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="49"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="3">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="4">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="5">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="6">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="7">
<sizes>
  <size from="97" to="97" total="97" count="1"/>
  <size from="113" to="113" total="113" count="1"/>
  <size from="1761" to="1761" total="1761" count="1"/>
  <unsorted from="8337" to="30849" total="39186" count="2"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="5" size="41157"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="8">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<total type="fast" count="12" size="912"/>
<total type="rest" count="81" size="64241"/>
<total type="mmap" count="53" size="539344896"/>
<system type="current" size="26546176"/>
<system type="max" size="26546176"/>
<aspace type="total" size="26546176"/>
<aspace type="mprotect" size="26546176"/>
</malloc>



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:146
LUA             : init_queue:156
WOC             : NO
Next activation : never

宝塔用户_khbtzr 发表于 2023-3-5 11:07
Current dir: /www/server/data/
Running threads: 0  Stack size: 262144
Current locks:

这个是执行我的命令返回的结果吗？

堡塔运维向樛木 发表于 2023-3-5 11:49
这个是执行我的命令返回的结果吗？

下面配图是我复制你给的代码点击运行的

堡塔运维向樛木 发表于 2023-3-5 11:49
这个是执行我的命令返回的结果吗？

下面配图是我复制你给的代码上在服务器里运行的。然后右面文字是我点击数据库日志复制的。（是运行后的日志结果。）所以你问我是不是运行后日志内返回的结果，：应该是的。

宝塔用户_khbtzr 发表于 2023-3-5 12:01
下面配图是我复制你给的代码点击运行的

是的，是你给的代码点击运行的。

您好，请问您的问题是否解决？如果您的问题依旧未得到解决，您可以重新发帖来寻求帮助，这边结束整个帖了，感谢您的支持