HTTP Status 500 – Internal Server Error


Type Exception Report

Message Při zpracování se vyskytla výjimka [index.jsp] na řádku [60]

Popis The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: Při zpracování se vyskytla výjimka [index.jsp] na řádku [60]

57:     host = request.getRemoteHost();
58: }
59: 
60: ForbiddenIp.forbidIfSuspicious(ip, host);
61: if(ForbiddenIp.isForbidden(ip)) {
62:     response.sendError(403, "Access denied!" );
63:     MyDb.sqlUpdateDelete("DELETE FROM web_site_ip_visits WHERE remote_addr = '" + ip + "'");


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:610)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:499)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
	org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:65)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
	org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:135)
	org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:58)
	org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)
	org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:233)
	org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
	org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162)
	org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1435)
	db.MyDb.getByQ(MyDb.java:71)
	web.ForbiddenIp.forbidIfSuspicious(ForbiddenIp.java:75)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:261)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:903)
	com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
	com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)
	org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)
	org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:233)
	org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
	org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162)
	org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1435)
	db.MyDb.getByQ(MyDb.java:71)
	web.ForbiddenIp.forbidIfSuspicious(ForbiddenIp.java:75)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:261)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

com.mysql.cj.exceptions.CJException: Data source rejected establishment of connection,  message from server: "Too many connections"
	jdk.internal.reflect.GeneratedConstructorAccessor260.newInstance(Unknown Source)
	java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129)
	com.mysql.cj.protocol.a.NativeProtocol.rejectProtocol(NativeProtocol.java:373)
	com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:502)
	com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:385)
	com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1351)
	com.mysql.cj.NativeSession.connect(NativeSession.java:157)
	com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:847)
	com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
	com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)
	org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)
	org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:233)
	org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
	org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162)
	org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1435)
	db.MyDb.getByQ(MyDb.java:71)
	web.ForbiddenIp.forbidIfSuspicious(ForbiddenIp.java:75)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:261)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Note Celý stack trace zdrojové chyby je dostupný v server logu.


Apache Tomcat/10.0.13