关于后台管理页面卡顿以及网络请求延迟性能优化

[gsxgmpkt9020]

看了下服务器后台的java进程,基本上都在睡眠,占用也就几十M.
主机、服务器是同一个局域网的，但是后台比较卡顿，比如加载插件页面至少7-10s。

快速添加一个bgm条目要三四十秒。

还有把条目标记为“在看”直接延迟报错，虽然等了十几秒后还是成功了。

[gsxgmpkt9020]

2024-12-07 15:08:28 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new subject collection for userId=1 and subjectId=1
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [1]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [2]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [3]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [4]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [5]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [6]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [7]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [8]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [9]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [10]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [11]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [12]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [13]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [14]
2024-12-07 15:09:11 [reactor-tcp-nio-4] INFO  r.i.s.c.c.SubjectCollectionImpl - Create new episode collection for userId is [1] and episode id is [15]
2024-12-07 15:09:21 [reactor-tcp-nio-4] ERROR r.i.s.c.GlobalExceptionHandlerConfig - [DuplicateKeyException] executeMany; SQL [INSERT INTO subject_collection (user_id, subject_id, type, main_ep_progress, is_private) VALUES ($1, $2, $3, $4, $5)]; duplicate key value violates unique constraint "user_subject_id_uk"
org.springframework.dao.DuplicateKeyException: executeMany; SQL [INSERT INTO subject_collection (user_id, subject_id, type, main_ep_progress, is_private) VALUES ($1, $2, $3, $4, $5)]; duplicate key value violates unique constraint "user_subject_id_uk"
	at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:235)
	Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: 
Error has been observed at the following site(s):
	*__checkpoint ⇢ run.ikaros.server.security.authentication.basicauth.BasicAuthenticationFilter [DefaultWebFilterChain]
Original Stack Trace:
		at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:235)
		at org.springframework.r2dbc.core.DefaultDatabaseClient.lambda$inConnectionMany$8(DefaultDatabaseClient.java:150)
		at reactor.core.publisher.Flux.lambda$onErrorMap$28(Flux.java:7123)
		at reactor.core.publisher.Flux.lambda$onErrorResume$29(Flux.java:7176)
		at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94)
		at reactor.core.publisher.FluxUsingWhen$UsingWhenSubscriber.deferredError(FluxUsingWhen.java:398)
		at reactor.core.publisher.FluxUsingWhen$RollbackInner.onComplete(FluxUsingWhen.java:475)
		at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onComplete(Operators.java:2205)
		at reactor.core.publisher.MonoIgnoreElements$IgnoreElementsSubscriber.onComplete(MonoIgnoreElements.java:89)
		at reactor.core.publisher.FluxMap$MapSubscriber.onComplete(FluxMap.java:144)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.onComplete(FluxFilter.java:166)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.onComplete(FluxFilter.java:300)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onComplete(FluxMap.java:275)
		at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2547)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.request(FluxMap.java:295)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.request(FluxFilter.java:321)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.request(FluxFilter.java:186)
		at reactor.core.publisher.FluxMap$MapSubscriber.request(FluxMap.java:164)
		at reactor.core.publisher.MonoIgnoreElements$IgnoreElementsSubscriber.onSubscribe(MonoIgnoreElements.java:72)
		at reactor.core.publisher.FluxMap$MapSubscriber.onSubscribe(FluxMap.java:92)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.onSubscribe(FluxFilter.java:85)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.onSubscribe(FluxFilter.java:219)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onSubscribe(FluxMap.java:194)
		at reactor.core.publisher.MonoJust.subscribe(MonoJust.java:55)
		at reactor.core.publisher.MonoDeferContextual.subscribe(MonoDeferContextual.java:55)
		at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64)
		at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:52)
		at reactor.core.publisher.Mono.subscribe(Mono.java:4444)
		at reactor.core.publisher.FluxUsingWhen$UsingWhenSubscriber.onError(FluxUsingWhen.java:364)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.checkTerminated(FluxFlatMap.java:842)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.drainLoop(FluxFlatMap.java:608)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.drain(FluxFlatMap.java:588)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.innerError(FluxFlatMap.java:863)
		at reactor.core.publisher.FluxFlatMap$FlatMapInner.onError(FluxFlatMap.java:990)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onError(FluxHandle.java:212)
		at reactor.core.publisher.MonoFlatMapMany$FlatMapManyInner.onError(MonoFlatMapMany.java:255)
		at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:200)
		at reactor.core.publisher.FluxFilterFuseable$FilterFuseableConditionalSubscriber.onNext(FluxFilterFuseable.java:337)
		at reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at io.r2dbc.postgresql.util.FluxDiscardOnCancel$FluxDiscardOnCancelSubscriber.onNext(FluxDiscardOnCancel.java:91)
		at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.onNext(FluxDoFinally.java:113)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
		at reactor.core.publisher.FluxCreate$BufferAsyncSink.drain(FluxCreate.java:814)
		at reactor.core.publisher.FluxCreate$BufferAsyncSink.next(FluxCreate.java:739)
		at reactor.core.publisher.FluxCreate$SerializedFluxSink.next(FluxCreate.java:161)
		at io.r2dbc.postgresql.client.ReactorNettyClient$Conversation.emit(ReactorNettyClient.java:687)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.emit(ReactorNettyClient.java:939)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:813)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:719)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
		at reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:292)
		at reactor.netty.channel.FluxReceive.onInboundNext(FluxReceive.java:401)
		at reactor.netty.channel.ChannelOperations.onInboundNext(ChannelOperations.java:411)
		at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:113)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
		at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
		at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:333)
		at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:454)
		at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
		at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
		at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
		at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
		at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
		at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
		at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
		at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
		at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
		at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
		at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: io.r2dbc.postgresql.ExceptionFactory$PostgresqlDataIntegrityViolationException: duplicate key value violates unique constraint "user_subject_id_uk"
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:102)
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:65)
	at io.r2dbc.postgresql.ExceptionFactory.handleErrorResponse(ExceptionFactory.java:132)
	at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:178)
	at reactor.core.publisher.FluxFilterFuseable$FilterFuseableConditionalSubscriber.onNext(FluxFilterFuseable.java:337)
	at reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at io.r2dbc.postgresql.util.FluxDiscardOnCancel$FluxDiscardOnCancelSubscriber.onNext(FluxDiscardOnCancel.java:91)
	at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.onNext(FluxDoFinally.java:113)
	at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
	at reactor.core.publisher.FluxCreate$BufferAsyncSink.drain(FluxCreate.java:814)
	at reactor.core.publisher.FluxCreate$BufferAsyncSink.next(FluxCreate.java:739)
	at reactor.core.publisher.FluxCreate$SerializedFluxSink.next(FluxCreate.java:161)
	at io.r2dbc.postgresql.client.ReactorNettyClient$Conversation.emit(ReactorNettyClient.java:687)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.emit(ReactorNettyClient.java:939)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:813)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:719)
	at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
	at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
	at reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:292)
	at reactor.netty.channel.FluxReceive.onInboundNext(FluxReceive.java:401)
	at reactor.netty.channel.ChannelOperations.onInboundNext(ChannelOperations.java:411)
	at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:113)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:333)
	at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:454)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.base/java.lang.Thread.run(Thread.java:840)
2024-12-07 15:09:31 [reactor-tcp-nio-4] ERROR r.i.s.c.GlobalExceptionHandlerConfig - [DuplicateKeyException] executeMany; SQL [INSERT INTO subject_collection (user_id, subject_id, type, main_ep_progress, is_private) VALUES ($1, $2, $3, $4, $5)]; duplicate key value violates unique constraint "user_subject_id_uk"
org.springframework.dao.DuplicateKeyException: executeMany; SQL [INSERT INTO subject_collection (user_id, subject_id, type, main_ep_progress, is_private) VALUES ($1, $2, $3, $4, $5)]; duplicate key value violates unique constraint "user_subject_id_uk"
	at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:235)
	Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: 
Error has been observed at the following site(s):
	*__checkpoint ⇢ run.ikaros.server.security.authentication.basicauth.BasicAuthenticationFilter [DefaultWebFilterChain]
Original Stack Trace:
		at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:235)
		at org.springframework.r2dbc.core.DefaultDatabaseClient.lambda$inConnectionMany$8(DefaultDatabaseClient.java:150)
		at reactor.core.publisher.Flux.lambda$onErrorMap$28(Flux.java:7123)
		at reactor.core.publisher.Flux.lambda$onErrorResume$29(Flux.java:7176)
		at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94)
		at reactor.core.publisher.FluxUsingWhen$UsingWhenSubscriber.deferredError(FluxUsingWhen.java:398)
		at reactor.core.publisher.FluxUsingWhen$RollbackInner.onComplete(FluxUsingWhen.java:475)
		at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onComplete(Operators.java:2205)
		at reactor.core.publisher.MonoIgnoreElements$IgnoreElementsSubscriber.onComplete(MonoIgnoreElements.java:89)
		at reactor.core.publisher.FluxMap$MapSubscriber.onComplete(FluxMap.java:144)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.onComplete(FluxFilter.java:166)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.onComplete(FluxFilter.java:300)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onComplete(FluxMap.java:275)
		at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2547)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.request(FluxMap.java:295)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.request(FluxFilter.java:321)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.request(FluxFilter.java:186)
		at reactor.core.publisher.FluxMap$MapSubscriber.request(FluxMap.java:164)
		at reactor.core.publisher.MonoIgnoreElements$IgnoreElementsSubscriber.onSubscribe(MonoIgnoreElements.java:72)
		at reactor.core.publisher.FluxMap$MapSubscriber.onSubscribe(FluxMap.java:92)
		at reactor.core.publisher.FluxFilter$FilterSubscriber.onSubscribe(FluxFilter.java:85)
		at reactor.core.publisher.FluxFilter$FilterConditionalSubscriber.onSubscribe(FluxFilter.java:219)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onSubscribe(FluxMap.java:194)
		at reactor.core.publisher.MonoJust.subscribe(MonoJust.java:55)
		at reactor.core.publisher.MonoDeferContextual.subscribe(MonoDeferContextual.java:55)
		at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64)
		at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:52)
		at reactor.core.publisher.Mono.subscribe(Mono.java:4444)
		at reactor.core.publisher.FluxUsingWhen$UsingWhenSubscriber.onError(FluxUsingWhen.java:364)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.checkTerminated(FluxFlatMap.java:842)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.drainLoop(FluxFlatMap.java:608)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.drain(FluxFlatMap.java:588)
		at reactor.core.publisher.FluxFlatMap$FlatMapMain.innerError(FluxFlatMap.java:863)
		at reactor.core.publisher.FluxFlatMap$FlatMapInner.onError(FluxFlatMap.java:990)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onError(FluxHandle.java:212)
		at reactor.core.publisher.MonoFlatMapMany$FlatMapManyInner.onError(MonoFlatMapMany.java:255)
		at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:200)
		at reactor.core.publisher.FluxFilterFuseable$FilterFuseableConditionalSubscriber.onNext(FluxFilterFuseable.java:337)
		at reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at io.r2dbc.postgresql.util.FluxDiscardOnCancel$FluxDiscardOnCancelSubscriber.onNext(FluxDiscardOnCancel.java:91)
		at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.onNext(FluxDoFinally.java:113)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
		at reactor.core.publisher.FluxCreate$BufferAsyncSink.drain(FluxCreate.java:814)
		at reactor.core.publisher.FluxCreate$BufferAsyncSink.next(FluxCreate.java:739)
		at reactor.core.publisher.FluxCreate$SerializedFluxSink.next(FluxCreate.java:161)
		at io.r2dbc.postgresql.client.ReactorNettyClient$Conversation.emit(ReactorNettyClient.java:687)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.emit(ReactorNettyClient.java:939)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:813)
		at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:719)
		at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
		at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
		at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
		at reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:292)
		at reactor.netty.channel.FluxReceive.onInboundNext(FluxReceive.java:401)
		at reactor.netty.channel.ChannelOperations.onInboundNext(ChannelOperations.java:411)
		at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:113)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
		at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
		at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:333)
		at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:454)
		at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
		at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
		at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
		at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
		at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
		at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
		at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
		at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
		at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
		at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
		at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
		at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
		at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: io.r2dbc.postgresql.ExceptionFactory$PostgresqlDataIntegrityViolationException: duplicate key value violates unique constraint "user_subject_id_uk"
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:102)
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:65)
	at io.r2dbc.postgresql.ExceptionFactory.handleErrorResponse(ExceptionFactory.java:132)
	at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:178)
	at reactor.core.publisher.FluxFilterFuseable$FilterFuseableConditionalSubscriber.onNext(FluxFilterFuseable.java:337)
	at reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at io.r2dbc.postgresql.util.FluxDiscardOnCancel$FluxDiscardOnCancelSubscriber.onNext(FluxDiscardOnCancel.java:91)
	at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.onNext(FluxDoFinally.java:113)
	at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
	at reactor.core.publisher.FluxCreate$BufferAsyncSink.drain(FluxCreate.java:814)
	at reactor.core.publisher.FluxCreate$BufferAsyncSink.next(FluxCreate.java:739)
	at reactor.core.publisher.FluxCreate$SerializedFluxSink.next(FluxCreate.java:161)
	at io.r2dbc.postgresql.client.ReactorNettyClient$Conversation.emit(ReactorNettyClient.java:687)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.emit(ReactorNettyClient.java:939)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:813)
	at io.r2dbc.postgresql.client.ReactorNettyClient$BackendMessageSubscriber.onNext(ReactorNettyClient.java:719)
	at reactor.core.publisher.FluxHandle$HandleSubscriber.onNext(FluxHandle.java:128)
	at reactor.core.publisher.FluxPeekFuseable$PeekConditionalSubscriber.onNext(FluxPeekFuseable.java:854)
	at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
	at reactor.core.publisher.FluxMap$MapConditionalSubscriber.onNext(FluxMap.java:224)
	at reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:292)
	at reactor.netty.channel.FluxReceive.onInboundNext(FluxReceive.java:401)
	at reactor.netty.channel.ChannelOperations.onInboundNext(ChannelOperations.java:411)
	at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:113)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:333)
	at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:454)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.base/java.lang.Thread.run(Thread.java:840)

似乎是网络延迟导致的duplicate数据

[gsxgmpkt9020]

XML Parsing Error: not well-formed
Location: http://192.168.2.12:9999/apis/setting.ikaros.run/v1alpha1/configmap/setting.server.ikaros.run/data
Line Number 1, Column 1:

exception "org.springframework.security.authentication.AuthenticationCredentialsNotFoundException"
message	"Not Authenticated"

[chivehao]

这是哪个插件的报错？

[gsxgmpkt9020]

Uncaught (in promise) RequiredError: Required parameter name was null or undefined when calling getPlugin.
    zhe http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
    Ve http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
    getPlugin http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
    getPlugin http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
    getPlugin http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
    o http://192.168.2.12:9999/console/assets/index-b58a11ae.js:190
    r http://192.168.2.12:9999/console/assets/index-b58a11ae.js:190
    setup http://192.168.2.12:9999/console/assets/index-b58a11ae.js:190
    ji http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    ko http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    g http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    KC http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    A http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    Le http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    run http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    update http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    j http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    L http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    g http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    Le http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    run http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    update http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    ji http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    Bk http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
index-b58a11ae.js:77:5105
请求参数异常 
Object { stack: "xn@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:72:109730\nvhe@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:1053\nh@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:4265\n", message: "Request failed with status code 400", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…} }
index-b58a11ae.js:77:99848
Object { stack: "xn@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:72:109730\nvhe@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:1053\nh@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:4265\n", message: "Request failed with status code 400", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…} }
index-b58a11ae.js:1:15414
请求参数异常 
Object { stack: "xn@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:72:109730\nvhe@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:1053\nh@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:4265\n", message: "Request failed with status code 400", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…} }
index-b58a11ae.js:77:99848
    <anonymous> http://192.168.2.12:9999/console/assets/index-b58a11ae.js:77
Object { stack: "xn@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:72:109730\nvhe@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:1053\nh@http://192.168.2.12:9999/console/assets/index-b58a11ae.js:74:4265\n", message: "Request failed with status code 400", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…} }
index-b58a11ae.js:1:15414
    aN http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    zc http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1
    ko http://192.168.2.12:9999/console/assets/index-b58a11ae.js:1

[chivehao]

加载插件页是哪个path? /plugins 吗？

条目拉取和收藏慢是因为要请求番组计划，拉取没办法，但是收藏更新后面可以想办法丢给事件监听异步处理

[gsxgmpkt9020]

加载插件页是哪个path? /plugins 吗？

条目拉取和收藏慢是因为要请求番组计划，拉取没办法，但是收藏更新后面可以想办法丢给事件监听异步处理

是的。就是单纯拿它举个例子，并不是只有这个页面很慢

[gsxgmpkt9020]

还有就是最常见的 “API网络错误: Request aborted”， 感觉整个进程都被系统睡眠掉了

[chivehao]

这一般是服务端异常，无法正常接收请求并响应。

[chivehao]

看了下服务器后台的java进程,基本上都在睡眠,占用也就几十M.
主机、服务器是同一个局域网的，但是后台比较卡顿，比如加载插件页面至少7-10s。

快速添加一个bgm条目要三四十秒。

还有把条目标记为“在看”直接延迟报错，虽然等了十几秒后还是成功了。

你确定内存占用才几十MB？我这边内存都占用了500多MB了

[gsxgmpkt9020]

本地电脑

本地电脑是没有网络延迟的，必然不卡，单个Java运行的进程（应该就是IKAROS）16g内存占用600m commit size

600mb才是正常情况，java 程序就这点不好，内存占用很大。

期待以后能有个golang版本，我暂时就主要用本地版就行了。nas就尽量冷备份用，保护磁头延长寿命，小机器就不折腾了

[chivehao]

Ikaros server肯定不止占用几十MB的内存

我是按大小排序的，旧的树莓派还跑操作系统呢。用惯DOCKER的富哥肯定无法想像普通老百姓的内存日常的。

用的是群晖系统，可能是垃圾回收机制比较激进。启动的时候Ikaros server会占用100+M，然后Ikaros server内存就被系统慢慢回收完了

不会用docker，建议可以试试1panel 安装 ikaros? 安装ikaros只需要点点点就行。

[gsxgmpkt9020]

Ikaros server肯定不止占用几十MB的内存

我是按大小排序的，旧的树莓派还跑操作系统呢。用惯DOCKER的富哥肯定无法想像普通老百姓的内存日常的。
用的是群晖系统，可能是垃圾回收机制比较激进。启动的时候Ikaros server会占用100+M，然后Ikaros server内存就被系统慢慢回收完了

不会用docker，建议可以试试1panel 安装 ikaros? 安装ikaros只需要点点点就行。

不是不想用docker，而是没有24h待机的高性能服务器，也不想租VPS。不是工具的问题，是成本的问题 (｡•ˇ‸ˇ•｡)。Docker本身就是给小白运维用的防呆设计

[chivehao]

Ikaros server肯定不止占用几十MB的内存

我是按大小排序的，旧的树莓派还跑操作系统呢。用惯DOCKER的富哥肯定无法想像普通老百姓的内存日常的。
用的是群晖系统，可能是垃圾回收机制比较激进。启动的时候Ikaros server会占用100+M，然后Ikaros server内存就被系统慢慢回收完了

不会用docker，建议可以试试1panel 安装 ikaros? 安装ikaros只需要点点点就行。

不是不想用docker，而是没有24h待机的高性能服务器，也不想租VPS。不是工具的问题，是成本的问题 (｡•ˇ‸ˇ•｡)。Docker本身就是给小白运维用的防呆设计

可以去网店弄个小工控机作为家里的主路由器，我目前用的就是N4500的工控机，装了PVE，虚拟机安装的OpenWRT和一台Ubuntu，ikaros安装在ubuntu里，然后用115网盘存视频，通过alist插件导入ikaros成为附件，弄好后可以直接播放番剧。

[chivehao]

看这是我的PVE截图：

[gsxgmpkt9020]

如果加上内存参数，比如强制持续使用120m内存，怎么设置？

<html>
<body>
<!--StartFragment--><h3 id="ab897a106c6lg" style="box-sizing: border-box; margin: 24px 0px 16px; padding: 0px; font-size: 18px; font-weight: 700; line-height: 24px; user-select: text !important; color: rgb(24, 24, 24); letter-spacing: 0.4px; font-family: help-font, &quot;helvetica neue&quot;, &quot;pingfang SC&quot;, arial, &quot;hiragino sans gb&quot;, &quot;microsoft yahei ui&quot;, &quot;microsoft yahei&quot;, simsun, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><b data-spm-anchor-id="a2c4g.11186623.0.i5.6a9b12e3TmTVZf" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: bolder; user-select: text !important;">堆栈大小典型配置参数</b></h3><section data-tag="table" id="table-p80-cc7-2nq" real-tag="div" class="section table" style="box-sizing: border-box; margin: 0px; padding: 0px; display: block; user-select: text !important; color: rgb(24, 24, 24); font-family: help-font, &quot;helvetica neue&quot;, &quot;pingfang SC&quot;, arial, &quot;hiragino sans gb&quot;, &quot;microsoft yahei ui&quot;, &quot;microsoft yahei&quot;, simsun, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">
配置参数 | 说明 | 示例
-- | -- | --
-Xmx | 设置最大堆大小。 | -Xmx3550m，设置JVM最大可用内存为3550 MB。
-Xms | 设置JVM初始内存。 | -Xms3550m，设置JVM初始内存为3550 MB。此值建议与-Xmx相同，避免每次垃圾回收完成后JVM重新分配内存。
-Xmn | 设置年轻代大小。 | -Xmn2g，设置年轻代大小为2 GB。整个JVM内存大小=年轻代大小+年老代大小+持久代大小。持久代一般固定大小为64 MB，所以增大年轻代后，将会减小年老代大小。此值对系统性能影响较大，Sun官方推荐配置为整个堆的3/8。
-Xss | 设置线程的栈大小。 | -Xss128k，设置每个线程的栈大小为128 KB。说明JDK 5.0版本以后每个线程栈大小为1 MB，JDK 5.0以前版本每个线程栈大小为256 KB。请依据应用的线程所需内存大小进行调整。在相同物理内存下，减小该值可以生成更多的线程。但是操作系统对一个进程内的线程个数有一定的限制，无法无限生成，一般在3000个~5000个。
-XX:NewRatio=n | 设置年轻代和年老代的比值。 | -XX:NewRatio=4，设置年轻代（包括Eden和两个Survivor区）与年老代的比值（除去持久代）。如果设置为4，那么年轻代与年老代所占比值为1:4，年轻代占整个堆栈的1/5。
-XX:SurvivorRatio=n | 年轻代中Eden区与两个Survivor区的比值。 | -XX:SurvivorRatio=4，设置年轻代中Eden区与Survivor区的大小比值。如果设置为4，那么两个Survivor区与一个Eden区的比值为2:4，一个Survivor区占整个年轻代的1/6。
-XX:MaxPermSize=n | 设置持久代大小。 | -XX:MaxPermSize=16m，设置持久代大小为16 MB。
-XX:MaxTenuringThreshold=n | 设置垃圾最大年龄。 | -XX:MaxTenuringThreshold=0，设置垃圾最大年龄。如果设置为0，那么年轻代对象不经过Survivor区，直接进入年老代。对于年老代比较多的应用，提高了效率。如果将此值设置为较大值，那么年轻代对象会在Survivor区进行多次复制，增加了对象在年轻代的存活时间，增加在年轻代即被回收的概率。

</section><!--EndFragment-->
</body>
</html>

[chivehao]

试试加上这个java参数重启：-Xmx256m -Xms256m

[gsxgmpkt9020]

试试加上这个java参数重启：-Xmx256m -Xms256m

您好，我再请教下，FLYWAY相关参数只是“第一次部署迁移数据库到POSTGRESQL”的时候用到，还是说部署迁移完以后，每次重启程序都需要添加（FLYWAY相关参数）、作为“持续的桥梁”？逻辑上来说，数据库迁移应当是一次性、永久性的。

[chivehao]

试试加上这个java参数重启：-Xmx256m -Xms256m

您好，我再请教下，FLYWAY相关参数只是“第一次部署迁移数据库到POSTGRESQL”的时候用到，还是说部署迁移完以后，每次重启程序都需要添加（FLYWAY相关参数）、作为“持续的桥梁”？逻辑上来说，数据库迁移应当是一次性、永久性的。

需要一直加上，flyway会在启动后连接数据库检测SQL的更新版本，建议你可以写个sh脚本或者bat脚本，通过脚本启动才比较方便。

[gsxgmpkt9020]

试试加上这个java参数重启：-Xmx256m -Xms256m

您好，我再请教下，FLYWAY相关参数只是“第一次部署迁移数据库到POSTGRESQL”的时候用到，还是说部署迁移完以后，每次重启程序都需要添加（FLYWAY相关参数）、作为“持续的桥梁”？逻辑上来说，数据库迁移应当是一次性、永久性的。

需要一直加上，flyway会在启动后连接数据库检测SQL的更新版本，建议你可以写个sh脚本或者bat脚本，通过脚本启动才比较方便。

是的，我现在就是用的群晖计划任务设定的开机脚本

[gsxgmpkt9020]

还有就是我用的是nohup参数，没有把它做成系统服务，和这个有没有关系？是不是因为没有守护进程所以被持续回收了内存？

[chivehao]

不太清楚，我觉得可能和这个关系不大

[gsxgmpkt9020]

不太清楚，我觉得可能和这个关系不大

根据监听端口9999，这个java进程只占用20m