51 Star 336 Fork 129

GVPMycatOne / Mycat2

 / 详情

mycat2配置sqlserver报错:com.microsoft.sqlserver.jdbc.SQLServerException: “VARIABLES”附近有语法错误。

待办的
创建于  
2023-12-22 12:46

STATUS | wrapper | 2023/12/22 12:43:34 | Starting the mycat2 service...
STATUS | wrapper | 2023/12/22 12:43:35 | --> Wrapper Started as Service
STATUS | wrapper | 2023/12/22 12:43:35 | Launching a JVM...
INFO | jvm 1 | 2023/12/22 12:43:37 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
INFO | jvm 1 | 2023/12/22 12:43:37 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
INFO | jvm 1 | 2023/12/22 12:43:37 |
INFO | jvm 1 | 2023/12/22 12:43:37 | path:D:\mycat.\conf
INFO | jvm 1 | 2023/12/22 12:43:37 | 2023-12-22 12:43:37,463[INFO]io.mycat.MycatCore.newMycatServer:209start VertxMycatServer
INFO | jvm 1 | 2023/12/22 12:43:38 | 2023-12-22 12:43:38,062[INFO]com.alibaba.druid.pool.DruidDataSource.init:990{dataSource-1} inited
INFO | jvm 1 | 2023/12/22 12:43:38 |
INFO | jvm 1 | 2023/12/22 12:43:38 | WrapperSimpleApp: Encountered an error running main: io.mycat.MycatException: ERROR-CODE: [MYCAT-3036][ERR_INIT_CONFIG] start FileMetadataStorageManager fail
INFO | jvm 1 | 2023/12/22 12:43:38 | io.mycat.MycatException: ERROR-CODE: [MYCAT-3036][ERR_INIT_CONFIG] start FileMetadataStorageManager fail
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.beans.mycat.MycatErrorCode.createMycatException(MycatErrorCode.java:156)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.FileMetadataStorageManager.start(FileMetadataStorageManager.java:211)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.FileMetadataStorageManager.start(FileMetadataStorageManager.java:204)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.MycatCore.startServer(MycatCore.java:216)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.MycatCore.main(MycatCore.java:235)
INFO | jvm 1 | 2023/12/22 12:43:38 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2023/12/22 12:43:38 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO | jvm 1 | 2023/12/22 12:43:38 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2023/12/22 12:43:38 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
INFO | jvm 1 | 2023/12/22 12:43:38 | at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
INFO | jvm 1 | 2023/12/22 12:43:38 | at java.base/java.lang.Thread.run(Thread.java:829)
INFO | jvm 1 | 2023/12/22 12:43:38 | Caused by: io.mycat.MycatException: ERROR-CODE: [MYCAT-3002][ERR_FETCH_METADATA] MetadataManager init fail
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.beans.mycat.MycatErrorCode.createMycatException(MycatErrorCode.java:156)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.MetadataManager.createMetadataManager(MetadataManager.java:131)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.ConfigPrepareExecuter.fullInitBy(ConfigPrepareExecuter.java:217)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.ConfigPrepareExecuter.prepareRuntimeObject(ConfigPrepareExecuter.java:135)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.FileMetadataStorageManager.commitAndSyncDisk(FileMetadataStorageManager.java:271)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.FileMetadataStorageManager$1.commit(FileMetadataStorageManager.java:250)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.config.FileMetadataStorageManager.start(FileMetadataStorageManager.java:209)
INFO | jvm 1 | 2023/12/22 12:43:38 | ... 9 more
INFO | jvm 1 | 2023/12/22 12:43:38 | Caused by: io.mycat.MycatException: com.microsoft.sqlserver.jdbc.SQLServerException: “VARIABLES”附近有语法错误。
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.datasource.jdbc.datasource.DefaultConnection.executeQuery(DefaultConnection.java:93)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.MetadataManager.(MetadataManager.java:166)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.MetadataManager.createMetadataManager(MetadataManager.java:124)
INFO | jvm 1 | 2023/12/22 12:43:38 | ... 14 more
INFO | jvm 1 | 2023/12/22 12:43:38 | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “VARIABLES”附近有语法错误。
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
INFO | jvm 1 | 2023/12/22 12:43:38 | at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:296)
INFO | jvm 1 | 2023/12/22 12:43:38 | at io.mycat.datasource.jdbc.datasource.DefaultConnection.executeQuery(DefaultConnection.java:84)
INFO | jvm 1 | 2023/12/22 12:43:38 | ... 16 more
INFO | jvm 1 | 2023/12/22 12:43:38 | 2023-12-22 12:43:38,294[INFO]io.mycat.replica.heartbeat.HeartbeatFlow.sendDataSourceStatus:66prototypeDs heartStatus DatasourceStatus(status=OK_STATUS, isSlaveBehindMaster=false, dbSynStatus=DB_SYN_NORMAL, master=true)
INFO | wrapper | 2023/12/22 12:43:40 | Waiting to start...
STATUS | wrapper | 2023/12/22 12:43:41 | <-- Wrapper Stopped
ERROR | wrapper | 2023/12/22 12:43:42 | The mycat2 service was launched, but failed to start.

评论 (0)

foxwhy 创建了任务
foxwhy 修改了描述
展开全部操作日志

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(1)
Java
1
https://gitee.com/MycatOne/Mycat2.git
git@gitee.com:MycatOne/Mycat2.git
MycatOne
Mycat2
Mycat2

搜索帮助