defect
minor
#28678
Spalte MACHINE_IP zu kurz in USER_SESSION (bei IPv6)
z.B.:
[2025-06-15 08:09:26] [info] 2025-06-15T08:09:26,844 ERROR [http-nio-8080-exec-36]: com.top_logic.event.bus.Channel - Failed to send event 'com.top_logic.base.bus.UserEvent [user: 'Account(type:tl.accounts:Person, id: Person:4875, name: bhu)', type: loggedIn, machine: '0:0:0:0:0:0:0:1, X-Forwarded-For: 2a02:8071:4481:93e0:801c:9ab5:f32d:66a9']' to receiver 'class com.top_logic.knowledge.monitor.UserMonitor for class com.top_logic.event.bus.Service [namespace: changes, name: user]'.
[2025-06-15 08:09:26] [info] com.top_logic.knowledge.service.KnowledgeBaseException: Database operation failed.
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.DefaultDBContext.commitTransaction(DefaultDBContext.java:861)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.TransactionImpl.internalCommit(TransactionImpl.java:164)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.AbstractTransaction.commit(AbstractTransaction.java:73)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.monitor.UserMonitor.login(UserMonitor.java:209)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.monitor.UserMonitor.receive(UserMonitor.java:120)
[2025-06-15 08:09:26] [info] #011at com.top_logic.event.bus.Channel$1.run(Channel.java:149)
[2025-06-15 08:09:26] [info] #011at com.top_logic.event.bus.Channel$1.run(Channel.java:145)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.thread.ThreadContextManager.inInteractionInternal(ThreadContextManager.java:404)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.thread.ThreadContextManager.inSystemInteractionInternal(ThreadContextManager.java:446)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.thread.ThreadContextManager.inSystemInteraction(ThreadContextManager.java:438)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.thread.ThreadContext.inSystemContext(ThreadContext.java:157)
[2025-06-15 08:09:26] [info] #011at com.top_logic.event.bus.Channel.send(Channel.java:145)
[2025-06-15 08:09:26] [info] #011at com.top_logic.event.bus.Sender.send(Sender.java:77)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.SessionService.sendEvent(SessionService.java:561)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.SessionService.getNewSessionForUser(SessionService.java:413)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.SessionService.login(SessionService.java:365)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.SessionService.loginUser(SessionService.java:361)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.Login.login(Login.java:384)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.Login.login(Login.java:292)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.LoginPageServlet.checkRequest(LoginPageServlet.java:282)
[2025-06-15 08:09:26] [info] #011at com.top_logic.base.accesscontrol.LoginPageServlet.doPost(LoginPageServlet.java:214)
[2025-06-15 08:09:26] [info] #011at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590)
[2025-06-15 08:09:26] [info] #011at com.top_logic.util.NoContextServlet.doService(NoContextServlet.java:100)
[2025-06-15 08:09:26] [info] #011at com.top_logic.util.NoContextServlet.executeInInteraction(NoContextServlet.java:49)
[2025-06-15 08:09:26] [info] #011at com.top_logic.util.NoContextServlet.lambda$service$0(NoContextServlet.java:40)
[2025-06-15 08:09:26] [info] #011at com.top_logic.util.TopLogicServlet.withSessionIdLogMark(TopLogicServlet.java:209)
[2025-06-15 08:09:26] [info] #011at com.top_logic.util.NoContextServlet.service(NoContextServlet.java:39)
[2025-06-15 08:09:26] [info] #011at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.gui.layout.HttpSecureHeaderFilter.doFilter(HttpSecureHeaderFilter.java:135)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
[2025-06-15 08:09:26] [info] #011at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340)
[2025-06-15 08:09:26] [info] #011at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
[2025-06-15 08:09:26] [info] #011at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
[2025-06-15 08:09:26] [info] #011at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
[2025-06-15 08:09:26] [info] #011at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[2025-06-15 08:09:26] [info] #011at java.base/java.lang.Thread.run(Thread.java:1583)
[2025-06-15 08:09:26] [info] Caused by: java.sql.SQLException: Value too long for column "MACHINE_IP VARCHAR_IGNORECASE(64)": "'0:0:0:0:0:0:0:1, X-Forwarded-For: 2a02:8071:4481:93e0:801c:9ab5:f32d:66a9' (73)"; SQL statement:
[2025-06-15 08:09:26] [info] INSERT INTO "USER_SESSION" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","PHYSICAL_RESOURCE","NAME","SESSION_ID","MACHINE_IP","SERVER","LOGIN","LOGOUT") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-224]: INSERT INTO "USER_SESSION" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","PHYSICAL_RESOURCE","NAME","SESSION_ID","MACHINE_IP","SERVER","LOGIN","LOGOUT") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.sql.SQLH.enhanceMessage(SQLH.java:594)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement.enhanceMessage(PrepStmtBasedCompiledStatement.java:144)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement$1.executeBatch(PrepStmtBasedCompiledStatement.java:131)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.DefaultDBAccess.executeInsertBatch(DefaultDBAccess.java:403)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.DefaultDBAccess.insertAll(DefaultDBAccess.java:371)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.VersionedDBAccess.storeAll(VersionedDBAccess.java:505)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.VersionedDBAccess.insertAll(VersionedDBAccess.java:489)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.DefaultDBContext.commitNew(DefaultDBContext.java:537)
[2025-06-15 08:09:26] [info] #011at com.top_logic.knowledge.service.db2.DefaultDBContext.commitTransaction(DefaultDBContext.java:790)
[2025-06-15 08:09:26] [info] #011... 52 more
[2025-06-15 08:09:26] [info] Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "MACHINE_IP VARCHAR_IGNORECASE(64)": "'0:0:0:0:0:0:0:1, X-Forwarded-For: 2a02:8071:4481:93e0:801c:9ab5:f32d:66a9' (73)"; SQL statement:
[2025-06-15 08:09:26] [info] INSERT INTO "USER_SESSION" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","PHYSICAL_RESOURCE","NAME","SESSION_ID","MACHINE_IP","SERVER","LOGIN","LOGOUT") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-224]
[2025-06-15 08:09:26] [info] #011at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.db.sql.AbstractStatementBatch.executeBatch(AbstractStatementBatch.java:46)
[2025-06-15 08:09:26] [info] #011at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement$1.executeBatch(PrepStmtBasedCompiledStatement.java:129)
[2025-06-15 08:09:26] [info] #011... 58 more