Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [23:36:02] [Plan WebServer Thread-3/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
- com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple; (Message HY004 not found); SQL statement:
- SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple [50004-199]
- at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
- at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
- at com.djrapitops.plan.delivery.rendering.json.graphs.GraphJSONParser.activityGraphsJSONAsMap(GraphJSONParser.java:199) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.generateGraphDataJSONOfType(GraphsJSONHandler.java:102) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.lambda$getResponse$1(GraphsJSONHandler.java:67) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.getResponse(GraphsJSONHandler.java:67) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
- at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
- Caused by: plan.org.h2.jdbc.JdbcSQLNonTransientException: (Message HY004 not found); SQL statement:
- SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple [50004-199]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:502) ~[?:?]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
- at plan.org.h2.message.DbException.get(DbException.java:205) ~[?:?]
- at plan.org.h2.message.DbException.get(DbException.java:181) ~[?:?]
- at plan.org.h2.table.Table.setColumns(Table.java:442) ~[?:?]
- at plan.org.h2.table.TableView.initColumnsAndTables(TableView.java:239) ~[?:?]
- at plan.org.h2.table.TableView.init(TableView.java:112) ~[?:?]
- at plan.org.h2.table.TableView.<init>(TableView.java:71) ~[?:?]
- at plan.org.h2.table.TableView.createTempView(TableView.java:551) ~[?:?]
- at plan.org.h2.command.Parser.readTableFilter(Parser.java:1830) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
- at plan.org.h2.command.Parser.readTableFilter(Parser.java:1819) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
- at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
- at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:760) ~[?:?]
- at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
- at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
- at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
- at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
- ... 21 more
- [23:36:02] [Plan WebServer Thread-4/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
- com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation; (Message 42001 not found); SQL statement:
- SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation [42001-199]
- at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
- at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
- at com.djrapitops.plan.delivery.rendering.json.graphs.GraphJSONParser.geolocationGraphsJSONAsMap(GraphJSONParser.java:236) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.generateGraphDataJSONOfType(GraphsJSONHandler.java:104) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.lambda$getResponse$1(GraphsJSONHandler.java:67) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.getResponse(GraphsJSONHandler.java:67) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
- at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
- Caused by: plan.org.h2.jdbc.JdbcSQLSyntaxErrorException: (Message 42001 not found); SQL statement:
- SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation [42001-199]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[?:?]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
- at plan.org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[?:?]
- at plan.org.h2.command.Parser.getSyntaxError(Parser.java:991) ~[?:?]
- at plan.org.h2.command.Parser.read(Parser.java:4549) ~[?:?]
- at plan.org.h2.command.Parser.readTableFilter(Parser.java:1820) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
- at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
- at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:764) ~[?:?]
- at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
- at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
- at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
- at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
- ... 21 more
- [23:36:02] [Plan WebServer Thread-4/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
- com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation; (Message 42001 not found); SQL statement:
- SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation [42001-199]
- at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
- at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
- at com.djrapitops.plan.delivery.rendering.json.JSONFactory.pingPerGeolocation(JSONFactory.java:223) ~[?:?]
- at com.djrapitops.plan.delivery.rendering.json.ServerTabJSONParser.apply(ServerTabJSONParser.java:33) ~[?:?]
- at com.djrapitops.plan.delivery.rendering.json.ServerTabJSONParser.apply(ServerTabJSONParser.java:27) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.ServerTabJSONHandler.lambda$getResponse$0(ServerTabJSONHandler.java:59) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.json.ServerTabJSONHandler.getResponse(ServerTabJSONHandler.java:59) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
- at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
- at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
- at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
- at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
- Caused by: plan.org.h2.jdbc.JdbcSQLSyntaxErrorException: (Message 42001 not found); SQL statement:
- SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation [42001-199]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[?:?]
- at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
- at plan.org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[?:?]
- at plan.org.h2.command.Parser.getSyntaxError(Parser.java:991) ~[?:?]
- at plan.org.h2.command.Parser.read(Parser.java:4549) ~[?:?]
- at plan.org.h2.command.Parser.readTableFilter(Parser.java:1820) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
- at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
- at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
- at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
- at plan.org.h2.command.Parser.parse(Parser.java:764) ~[?:?]
- at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
- at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
- at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
- at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
- at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
- at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
- ... 22 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement