请稍等 ...
×

采纳答案成功！

向帮助你的同学说点啥吧！感谢那些助人为乐的人

请问老师为什么我启动不了

java版本

root@5d69e265694a:/var/lib/dble# java -version
openjdk version "1.8.0_362"
OpenJDK Runtime Environment (build 1.8.0_362-8u372-ga~us1-0ubuntu1~22.04-b09)
OpenJDK 64-Bit Server VM (build 25.362-b09, mixed mode)

JAVA_HOME

root@5d69e265694a:/var/lib/dble# echo $JAVA_HOME
/usr/lib/jvm/java-8-openjdk-amd64

这个是错误日志

STATUS | wrapper  | 2023/05/19 02:46:13 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2023/05/19 02:46:13 | Java Service Wrapper Community Edition 64-bit 3.5.40
STATUS | wrapper  | 2023/05/19 02:46:13 |   Copyright (C) 1999-2019 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2023/05/19 02:46:13 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2023/05/19 02:46:13 |
WARN   | wrapper  | 2023/05/19 02:46:14 | The 'd{MM-dd}-' environment variable was referenced but has not been defined.
STATUS | wrapper  | 2023/05/19 02:46:14 | Launching a JVM...
INFO   | jvm 1    | 2023/05/19 02:46:14 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 02:46:14 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 02:46:15 | Listening for transport dt_socket at address: 8088
INFO   | jvm 1    | 2023/05/19 02:46:16 | WrapperManager: Initializing...
ERROR  | wrapper  | 2023/05/19 02:46:44 | Startup failed: Timed out waiting for a signal from the JVM.
ERROR  | wrapper  | 2023/05/19 02:46:45 | JVM did not exit on request, termination requested.
STATUS | wrapper  | 2023/05/19 02:46:45 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2023/05/19 02:46:45 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 02:46:45 | JVM exited after being requested to terminate.
STATUS | wrapper  | 2023/05/19 02:46:50 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 02:46:50 | Launching a JVM...
INFO   | jvm 2    | 2023/05/19 02:46:51 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 2    | 2023/05/19 02:46:51 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 2    | 2023/05/19 02:46:51 | Listening for transport dt_socket at address: 8088
INFO   | jvm 2    | 2023/05/19 02:46:52 | WrapperManager: Initializing...
STATUS | wrapper  | 2023/05/19 02:47:19 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2023/05/19 02:47:19 | JVM process is gone.
ERROR  | wrapper  | 2023/05/19 02:47:19 | JVM exited unexpectedly.
STATUS | wrapper  | 2023/05/19 02:47:25 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 02:47:25 | Launching a JVM...
INFO   | jvm 3    | 2023/05/19 02:47:25 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 3    | 2023/05/19 02:47:25 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 3    | 2023/05/19 02:47:26 | Listening for transport dt_socket at address: 8088
INFO   | jvm 3    | 2023/05/19 02:47:28 | WrapperManager: Initializing...
STATUS | wrapper  | 2023/05/19 02:48:13 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2023/05/19 02:48:13 | JVM process is gone.
ERROR  | wrapper  | 2023/05/19 02:48:13 | JVM exited unexpectedly.
STATUS | wrapper  | 2023/05/19 02:48:20 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 02:48:20 | Launching a JVM...
INFO   | jvm 4    | 2023/05/19 02:48:20 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 4    | 2023/05/19 02:48:20 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 4    | 2023/05/19 02:48:20 | Listening for transport dt_socket at address: 8088
INFO   | jvm 4    | 2023/05/19 02:48:22 | WrapperManager: Initializing...
STATUS | wrapper  | 2023/05/19 02:48:43 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2023/05/19 02:48:43 | JVM process is gone.
ERROR  | wrapper  | 2023/05/19 02:48:43 | JVM exited unexpectedly.
STATUS | wrapper  | 2023/05/19 02:48:49 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 02:48:49 | Launching a JVM...
INFO   | jvm 5    | 2023/05/19 02:48:49 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 5    | 2023/05/19 02:48:49 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 5    | 2023/05/19 02:48:50 | Listening for transport dt_socket at address: 8088
INFO   | jvm 5    | 2023/05/19 02:48:52 | WrapperManager: Initializing...
STATUS | wrapper  | 2023/05/19 02:49:16 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2023/05/19 02:49:16 | JVM process is gone.
ERROR  | wrapper  | 2023/05/19 02:49:16 | JVM exited unexpectedly.
FATAL  | wrapper  | 2023/05/19 02:49:16 | There were 5 failed launches in a row, each lasting less than 300 seconds.  Giving up.
FATAL  | wrapper  | 2023/05/19 02:49:16 |   There may be a configuration problem: please check the logs.
STATUS | wrapper  | 2023/05/19 02:49:16 | <-- Wrapper Stopped```

------更新-----
这个是db.xml
因为我用的是docker-compose所以ip写的是mysql8的配置

<?xml version="1.0"?>
<!--
  ~ Copyright (C) 2016-2022 ActionTech.
  ~ License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher.
  -->

<dble:db xmlns:dble="http://dble.cloud/" version="4.0">
    <dbGroup name="dbGroup1" rwSplitMode="2" delayThreshold="100">
        <heartbeat>show slave status</heartbeat>
        <dbInstance name="instanceM1" url="mysql8:3306" user="root" password="123456" maxCon="1000" minCon="10"
                    primary="true" readWeight="1" id="xx1">
            <property name="testWhileIdle">true</property>
        </dbInstance>
        <!--<dbInstance name="instanceS1" url="ip3:3306" user="your_user" password="your_psw" maxCon="1000" minCon="10"  readWeight="2" disabled="true">-->
            <!--<property name="testWhileIdle">false</property>-->
        <!--</dbInstance>-->
    </dbGroup>

    <dbGroup name="dbGroup2" rwSplitMode="0" delayThreshold="100" disableHA="true">
        <heartbeat errorRetryCount="1" timeout="10" keepAlive="60">show slave status</heartbeat>
        <dbInstance name="instanceM2" url="mysql8-slave2:3326" user="root" password="123456" maxCon="1000" minCon="10"
                    primary="true">
            <property name="testWhileIdle">true</property>
        </dbInstance>

        <!-- can have multi read instances -->
        <!--<dbInstance name="instanceS2" url="ip4:3306" user="your_user" password="your_psw" maxCon="1000" minCon="10" usingDecrypt="true">-->
            <!--<property name="testWhileIdle">true</property>-->
        <!--</dbInstance>-->
    </dbGroup>
    <!--for clickhouse-->
    <dbGroup name="dbGroup3" rwSplitMode="0" delayThreshold="100" disableHA="true">
        <heartbeat errorRetryCount="1" timeout="10" keepAlive="60">show databases</heartbeat>
        <dbInstance name="instanceM2" url="ip2:9004" user="your_user" password="your_psw" maxCon="1000" minCon="10" databaseType="clickhouse"
                    primary="true">
            <property name="testWhileIdle">true</property>
        </dbInstance>
        <!-- can have multi read instances -->
        <!--<dbInstance name="instanceS2" url="ip4:9004" user="your_user" password="your_psw" maxCon="1000" minCon="10" usingDecrypt="true" databaseType="clickhouse">-->
        <!--<property name="testWhileIdle">true</property>-->
        <!--</dbInstance>-->
    </dbGroup>
</dble:db>

bin/wrapper.log跟新了这个

wrapper.ping.timeout=3600
wrapper.startup.timeout=7200

其他的文件都没改了

---------第二次更新
dble容器连接另外两个数据库容器

图片描述

-------------第三次更新
export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
export PATH=PATH:PATH:PATH:JAVA_HOME/bin (新增了这行)

STATUS | wrapper  | 2023/05/19 10:50:35 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2023/05/19 10:50:35 | Java Service Wrapper Community Edition 64-bit 3.5.40
STATUS | wrapper  | 2023/05/19 10:50:35 |   Copyright (C) 1999-2019 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2023/05/19 10:50:35 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2023/05/19 10:50:35 |
WARN   | wrapper  | 2023/05/19 10:50:36 | The 'd{MM-dd}-' environment variable was referenced but has not been defined.
STATUS | wrapper  | 2023/05/19 10:50:36 | Launching a JVM...
INFO   | jvm 1    | 2023/05/19 10:50:36 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 10:50:36 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 10:50:36 | Listening for transport dt_socket at address: 8088
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | # A fatal error has been detected by the Java Runtime Environment:
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | #  SIGILL (0x4) at pc=0x00007fa8e111831e, pid=509, tid=0x00007fa8f49fe640
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | # JRE version: OpenJDK Runtime Environment (8.0_362-b09) (build 1.8.0_362-8u372-ga~us1-0ubuntu1~22.04-b09)
INFO   | jvm 1    | 2023/05/19 10:50:37 | # Java VM: OpenJDK 64-Bit Server VM (25.362-b09 mixed mode linux-amd64 compressed oops)
INFO   | jvm 1    | 2023/05/19 10:50:37 | # Problematic frame:
INFO   | jvm 1    | 2023/05/19 10:50:37 | # J 38 C1 java.util.Arrays.copyOfRange([CII)[C (63 bytes) @ 0x00007fa8e111831e [0x00007fa8e1118340+0xffffffde]
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | # Core dump written. Default location: /var/lib/dble/core or core.509
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | # An error report file with more information is saved as:
INFO   | jvm 1    | 2023/05/19 10:50:37 | # /var/lib/dble/hs_err_pid509.log
INFO   | jvm 1    | 2023/05/19 10:50:37 | Compiled method (c1)    1307   78       3       java.lang.StringBuilder::toString (17 bytes)
INFO   | jvm 1    | 2023/05/19 10:50:37 |  total in heap  [0x00007fa8e112a150,0x00007fa8e112a550] = 1024
INFO   | jvm 1    | 2023/05/19 10:50:37 |  relocation     [0x00007fa8e112a278,0x00007fa8e112a2b8] = 64
INFO   | jvm 1    | 2023/05/19 10:50:37 |  main code      [0x00007fa8e112a2c0,0x00007fa8e112a420] = 352
INFO   | jvm 1    | 2023/05/19 10:50:37 |  stub code      [0x00007fa8e112a420,0x00007fa8e112a4c8] = 168
INFO   | jvm 1    | 2023/05/19 10:50:37 |  metadata       [0x00007fa8e112a4c8,0x00007fa8e112a4d0] = 8
INFO   | jvm 1    | 2023/05/19 10:50:37 |  scopes data    [0x00007fa8e112a4d0,0x00007fa8e112a4f8] = 40
INFO   | jvm 1    | 2023/05/19 10:50:37 |  scopes pcs     [0x00007fa8e112a4f8,0x00007fa8e112a548] = 80
INFO   | jvm 1    | 2023/05/19 10:50:37 |  dependencies   [0x00007fa8e112a548,0x00007fa8e112a550] = 8
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
INFO   | jvm 1    | 2023/05/19 10:50:37 | # If you would like to submit a bug report, please visit:
INFO   | jvm 1    | 2023/05/19 10:50:37 | #   http://bugreport.java.com/bugreport/crash.jsp
INFO   | jvm 1    | 2023/05/19 10:50:37 | #
STATUS | wrapper  | 2023/05/19 10:50:38 | JVM received a signal UNKNOWN (6).
STATUS | wrapper  | 2023/05/19 10:50:38 | JVM process is gone.
ERROR  | wrapper  | 2023/05/19 10:50:38 | JVM exited while loading the application.
STATUS | wrapper  | 2023/05/19 10:50:44 | JVM process is gone.
STATUS | wrapper  | 2023/05/19 10:50:44 | Launching a JVM...
沉默寡言黄少天丶 2023-05-19 10:59:47
源自：10-6  如何使用dble
491
收起

正在回答 回答被采纳积分+3

5回答

Moody 2023-05-19 17:15:11

url="mysql8-slave2:3326"

配置文件里的端口是不是错了呀

0 回复 有任何疑惑可以回复我~
收起回答
  • 提问者 沉默寡言黄少天丶 #1 
    诶！！！原来在宿主机3326访问是正确的，在dble容器访问mysql8-slave2需要用3306。一直搞错了

这样是不是等他运行就可以了
STATUS | wrapper  | 2023/05/19 09:40:33 | Java Service Wrapper Community Edition 64-bit 3.5.40
STATUS | wrapper  | 2023/05/19 09:40:33 |   Copyright (C) 1999-2019 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2023/05/19 09:40:33 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2023/05/19 09:40:33 |
WARN   | wrapper  | 2023/05/19 09:40:34 | The 'd{MM-dd}-' environment variable was referenced but has not been defined.
STATUS | wrapper  | 2023/05/19 09:40:34 | Launching a JVM...
INFO   | jvm 1    | 2023/05/19 09:40:34 | OpenJDK 64-Bit Server VM warning: UseCMSCompactAtFullCollection is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 09:40:34 | OpenJDK 64-Bit Server VM warning: CMSFullGCsBeforeCompaction is deprecated and will likely be removed in a future release.
INFO   | jvm 1    | 2023/05/19 09:40:35 | Listening for transport dt_socket at address: 8088
    回复 有任何疑惑可以回复我~ 2023-05-19 17:42:53
  • Moody 回复 提问者 沉默寡言黄少天丶 #2 
    好像是起来了，可以用了
    回复 有任何疑惑可以回复我~ 2023-05-19 17:45:05
  • 提问者 沉默寡言黄少天丶 回复 Moody #3 
    老师我改了一下这个是不是因为我内存不够了？
    回复 有任何疑惑可以回复我~ 2023-05-19 18:23:10
点开查看后面1条评论
取消 回复
Moody 2023-05-19 16:20:35

我看你容器的名字，是不是一个是主，一个是备？这节课里面，两个都要是主的

0 回复 有任何疑惑可以回复我~
收起回答
  • 提问者 沉默寡言黄少天丶 #1 
    我这边有3个数据库
mysql8(主库 server-id = 1)
mysql8-slave1（mysql8的备库 server-id = 2）
mysql8-slave2（干净的新数据库，只配置了GTID，server-id = 3）

server-id = 3的配置
[mysqld]
secure_file_priv=/home
gtid_mode=on
enforce-gtid-consistency=true
plugin-load = "rpl_semi_sync_source=semisync_source.so;rpl_semi_sync_replica=semisync_replica.so" rpl-semi-sync-source-enabled = 1 rpl-semi-sync-replica-enabled = 1

mysql> show slave status \G;
Empty set, 1 warning (0.02 sec)

ERROR:
No query specified

--------
mysql8-slave2没有做备库的配置
CHANGE REPLICATION SOURCE TO
  GET_MASTER_PUBLIC_KEY=1,
  SOURCE_HOST = 'mysql8',
  SOURCE_PORT = 3306 ,
  SOURCE_USER = 'root',
  SOURCE_PASSWORD = '123456',
  SOURCE_AUTO_POSITION = 1;
    回复 有任何疑惑可以回复我~ 2023-05-19 16:32:39
取消 回复
Moody 2023-05-19 16:13:48

没看出来问题。。。。你在机器上试试这两个mysql都能连通么？

0 回复 有任何疑惑可以回复我~
收起回答
  • 提问者 沉默寡言黄少天丶 #1 
    宿主机 可以连的 127.0.0.1 直接连 3306 3326
然后在容器可以ping通
    回复 有任何疑惑可以回复我~ 2023-05-19 16:19:44
  • 提问者 沉默寡言黄少天丶 #2 
    我的dble是单独一个docker ubuntu22.04镜像启动的一个容器。安装了
apt-get install -y openjdk-8-jdk
这样安装的java和最新版的dble。
    回复 有任何疑惑可以回复我~ 2023-05-19 16:22:00
  • Moody 回复 提问者 沉默寡言黄少天丶 #3 
    在dble的容器里面也能连通两个数据库吧？
    回复 有任何疑惑可以回复我~ 2023-05-19 16:26:45
点开查看后面1条评论
取消 回复
提问者 沉默寡言黄少天丶 2023-05-19 15:51:20

<?xml version="1.0"?>

<!--

  ~ Copyright (C) 2016-2022 ActionTech.

  ~ License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher.

  -->


<dble:db xmlns:dble="http://dble.cloud/" version="4.0">

    <dbGroup name="dbGroup1" rwSplitMode="2" delayThreshold="100">

        <heartbeat>show slave status</heartbeat>

        <dbInstance name="instanceM1" url="mysql8:3306" user="root" password="123456" maxCon="1000" minCon="10"

                    primary="true" readWeight="1" id="xx1">

            <property name="testWhileIdle">true</property>

        </dbInstance>

        <!--<dbInstance name="instanceS1" url="ip3:3306" user="your_user" password="your_psw" maxCon="1000" minCon="10"  readWeight="2" disabled="true">-->

            <!--<property name="testWhileIdle">false</property>-->

        <!--</dbInstance>-->

    </dbGroup>


    <dbGroup name="dbGroup2" rwSplitMode="0" delayThreshold="100" disableHA="true">

        <heartbeat errorRetryCount="1" timeout="10" keepAlive="60">show slave status</heartbeat>

        <dbInstance name="instanceM2" url="mysql8-slave2:3326" user="root" password="123456" maxCon="1000" minCon="10"

                    primary="true">

            <property name="testWhileIdle">true</property>

        </dbInstance>


        <!-- can have multi read instances -->

        <!--<dbInstance name="instanceS2" url="ip4:3306" user="your_user" password="your_psw" maxCon="1000" minCon="10" usingDecrypt="true">-->

            <!--<property name="testWhileIdle">true</property>-->

        <!--</dbInstance>-->

    </dbGroup>

    <!--for clickhouse-->

    <dbGroup name="dbGroup3" rwSplitMode="0" delayThreshold="100" disableHA="true">

        <heartbeat errorRetryCount="1" timeout="10" keepAlive="60">show databases</heartbeat>

        <dbInstance name="instanceM2" url="ip2:9004" user="your_user" password="your_psw" maxCon="1000" minCon="10" databaseType="clickhouse"

                    primary="true">

            <property name="testWhileIdle">true</property>

        </dbInstance>

        <!-- can have multi read instances -->

        <!--<dbInstance name="instanceS2" url="ip4:9004" user="your_user" password="your_psw" maxCon="1000" minCon="10" usingDecrypt="true" databaseType="clickhouse">-->

        <!--<property name="testWhileIdle">true</property>-->

        <!--</dbInstance>-->

    </dbGroup>

</dble:db>


这个是db.xml 因为我用的是docker 所以ip写的是mysql的配置



0 回复 有任何疑惑可以回复我~
收起回答
取消 回复
Moody 2023-05-19 15:36:32

发下配置文件看看？

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复

相似问题

老师，为什么在get请求时报错，get请求package.json难道也跨域了么？
967 4 7
在线上服务器上，用nodemon启动是成功的，用pm2启动有报错
225 0 4
用代码启动慕课网，没有报错，但没有启动
507 0 3
启动springboot时报错。
1213 1 5
mysql服务启动不正常
713 0 12

登录后可查看更多问答，登录/注册

问题已解决，确定采纳
还有疑问，暂不采纳
高并发，高性能，高可用的MySQL实战
  • 参与学习       781    人
  • 解答问题       186    个

从数据库原理到高性能实战，一次性涵盖

了解课程

本课精华内容

问答

请问老师为什么我启动不了

492 16

如何判定该分库分表？

640 8

innodb一次读多少页

708 7

给时间加索引为什么不走呢

1.0k 6

Postgre与mysql的存储引擎和优化差异

605 6

查看更多本课问答
意见反馈 帮助中心 APP下载
官方微信