defect
minor
#28678
MACHINE_IP column too short in USER_SESSION (for IPv6)
e.g.:
[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: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: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