Question

使用产品：iserver Linux64
数据类型：webGis
问题详细描述：之前都一直正常运行，现在启动了一堆错误，现在把错误放上来，帮忙看看，非常感谢：iserver.log

catalina.2021-12-02.log ，
iserver.log
2021-12-2 09:36:31 - ERROR - 数据源（172.16.255.17:3306_root）连接失败
2021-12-2 09:39:24 - ERROR - 数据源（supermap）连接失败
2021-12-2 09:42:17 - ERROR - 数据源（supermap）连接失败
2021-12-2 09:43:43 - ERROR - 数据源（172.16.255.17:3306_root）连接失败
2021-12-2 09:48:02 - ERROR - 数据源（supermap）连接失败
2021-12-2 09:50:55 - ERROR - 数据源（supermap）连接失败
2021-12-2 09:52:21 - ERROR - 数据源（172.16.255.17:3306_root）连接失败
2021-12-2 09:52:33 - ERROR - 启动服务失败。
2021-12-2 09:52:33 - ERROR - 启动服务失败。
java.lang.IllegalStateException: org.sqlite.SQLiteException: [SQLITE_BUSY]  The database file is locked (database is locked)
        at com.supermap.server.impl.RequestPerformanceRecordDAO.a(SourceFile:129)
        at com.supermap.server.impl.RequestPerformanceRecordDAO.<init>(SourceFile:59)
        at com.supermap.server.host.webapp.ApplicationFilter.a(SourceFile:179)
        at com.supermap.server.host.webapp.ApplicationFilter.a(SourceFile:80)
        at com.supermap.server.host.webapp.ApplicationFilter$1.call(SourceFile:123)
        at com.supermap.server.host.webapp.ApplicationFilter$1.call(SourceFile:120)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.supermap.services.util.DelegatingErrorHandlingCallable$ReflectInvoker.a(SourceFile:177)
        at com.supermap.services.util.DelegatingErrorHandlingCallable.invokeQuietly(SourceFile:102)
        at com.supermap.server.host.webapp.ApplicationFilter.init(SourceFile:158)
        at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:283)
        at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:264)
        at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:108)
        at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4546)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5191)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1859)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.sqlite.SQLiteException: [SQLITE_BUSY]  The database file is locked (database is locked)
        at org.sqlite.core.DB.newSQLException(DB.java:941)
        at org.sqlite.core.DB.newSQLException(DB.java:953)
        at org.sqlite.core.DB.throwex(DB.java:918)
        at org.sqlite.core.NativeDB._exec_utf8(Native Method)
        at org.sqlite.core.NativeDB._exec(NativeDB.java:94)
        at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:109)
        at com.supermap.server.impl.RequestPerformanceRecordDAOInitializer.init(SourceFile:36)
        at com.supermap.server.impl.RequestPerformanceRecordDAO.a(SourceFile:127)
        ... 28 more
2021-12-2 09:53:48 - ERROR - 数据源（supermap）连接失败：：

Answer 1

您这个提示的是sqlite数据库被锁定，建议您先检查当前iServer的进程，然后全部kill掉；或者您多执行几次./shutdown.sh，找到提示“拒绝连接”后，您再重新启动iServer看是否能正常访问。

Comments

数据源（172.******:3306_root）连接失败   

数据库连接在哪儿看

Answer 2

你好，查看你的报错信息有两种：

第一，数据源连接失败，查看你的数据库是否正常连接，能否在桌面打开这个数据库里面的数据；

第二，[SQLITE_BUSY]  The database file is locked (database is locked)，当SuperMap iServer尚未完全关闭时又重新启动SuperMap iServer会出现sqlite库被锁定的现象，这是由于SuperMap iServer守护进程仍有驻留，
Linux环境：
先使用ps -ef | grep iserver命令查看SuperMap iServer进程，再kill掉该进程后重启SuperMap iServer

Comments

非常感谢。

数据库连接的 配置文件在哪儿看

---

查看你的数据库是否正在运行的状态，用其他第三方软件去链接看看是否正常，用idesktop试试能否打开这个份数据。

---

数据库不在了，现在想修改下，数据库连接，要去哪个配置文件里面改

---

数据库不在了的话，就读不到里面的数据，所以才会一直报错，你可以直接删除这个对应的服务，后续如果制作了其他数据再重新发布即可。

---

感谢。

如何删除对应的服务： 接删除这个对应的服务

---

从哪删除呀？

Answer 3

catalina.2021-12-02.log

03-Dec-2021 09:52:01.731 信息 [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance.
02-Dec-2021 09:52:01.733 信息 [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8090"]
02-Dec-2021 09:52:01.733 信息 [main] org.apache.catalina.core.StandardService.stopInternal 正在停止服务[Catalina]
02-Dec-2021 09:52:01.759 信息 [main] org.apache.coyote.AbstractProtocol.stop 正在停止ProtocolHandler ["http-nio-8090"]
02-Dec-2021 09:52:01.760 信息 [main] org.apache.coyote.AbstractProtocol.destroy 正在摧毁协议处理器 ["http-nio-8090"]
02-Dec-2021 09:52:13.002 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.服务器版本:     Apache Tomcat/8.5.50
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器构建:            Dec 7 2019 19:19:46 UTC
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器版本号(：8.5.50.0
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS.版本:               3.10.0-1160.6.1.el7.x86_64
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 架构:                  amd64
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java 环境变量:         /home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/support/jre
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM 版本:              1.8.0_202-b08
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM.供应商:            Oracle Corporation
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /home/SuperMap/supermap-iserver-10.0.1-linux64-deploy
02-Dec-2021 09:52:13.006 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /home/SuperMap/supermap-iserver-10.0.1-linux64-deploy
02-Dec-2021 09:52:13.007 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/temp
02-Dec-2021 09:52:13.007 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/bin:/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/support/objectsjava/bin:/lib::/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
02-Dec-2021 09:52:13.076 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["http-nio-8090"]
02-Dec-2021 09:52:13.082 严重 [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[HTTP/1.1-8090]]
        org.apache.catalina.LifecycleException: Protocol handler initialization failed
                at org.apache.catalina.connector.Connector.initInternal(Connector.java:995)
                at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
                at org.apache.catalina.core.StandardService.initInternal(StandardService.java:552)
                at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
                at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:848)
                at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
                at org.apache.catalina.startup.Catalina.load(Catalina.java:639)
                at org.apache.catalina.startup.Catalina.load(Catalina.java:662)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.lang.reflect.Method.invoke(Method.java:498)
                at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:303)
                at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
        Caused by: java.net.BindException: 地址已在使用
                at sun.nio.ch.Net.bind0(Native Method)
02-Dec-2021 09:52:13.083 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 443 ms
02-Dec-2021 09:52:13.102 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
02-Dec-2021 09:52:13.103 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.50
02-Dec-2021 09:52:13.115 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#iClient.xml]
02-Dec-2021 09:52:13.390 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor 部署描述符[/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#iClient.xml]的部署已在[273]ms内完成
02-Dec-2021 09:52:13.390 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#iClient#for3D.xml]
02-Dec-2021 09:52:13.403 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor 部署描述符[/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#iClient#for3D.xml]的部署已在[13]ms内完成
02-Dec-2021 09:52:13.403 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#help.xml]
02-Dec-2021 09:52:13.424 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor 部署描述符[/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/conf/Catalina/localhost/iserver#help.xml]的部署已在[21]ms内完成
02-Dec-2021 09:52:13.425 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory 把web 应用程序部署到目录 [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/webapps/ROOT]
02-Dec-2021 09:52:13.436 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/webapps/ROOT] has finished in [11] ms
02-Dec-2021 09:52:13.436 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory 把web 应用程序部署到目录 [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/webapps/iserver]
02-Dec-2021 09:52:33.790 严重 [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal 一个或多个筛选器启动失败。完整的详细信息将在相应的容器日志文件中找到
02-Dec-2021 09:52:33.790 严重 [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/iserver] startup failed due to previous errors
02-Dec-2021 09:52:33.814 警告 [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc Web应用程序 [iserver] 注册了JDBC驱动程序 [org.sqlite.JDBC]，但在Web应用程序停止时无法注销它。 为防止内存泄漏，JDBC驱动程序已被强制取消注册。
02-Dec-2021 09:52:33.831 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/SuperMap/supermap-iserver-10.0.1-linux64-deploy/webapps/iserver] has finished in [20,395] ms
02-Dec-2021 09:52:33.841 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 20758 ms