Skip to content

Instantly share code, notes, and snippets.

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
19-Jun-2020 12:15:44.880 WARNING [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin [SetPropertiesRule]{Server/Service/Engine/Host/Valve} Setting property 'resolveHosts' to 'false' did not find a matching property.
19-Jun-2020 12:15:44.883 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.32
19-Jun-2020 12:15:44.884 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 20 2018 19:50:35 UTC
19-Jun-2020 12:15:44.884 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.32.0
19-Jun-2020 12:15:44.884 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Mac OS X
19-Jun-2020 12:15:44.884 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.14.6
19-Jun-2020 12:15:44.884 INFO [main] org.apache.cat
Caused by: org.postgresql.util.PSQLException: ERROR: column "server_id" does not exist
Position: 50
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) ~[postgresql-42.2.2.jar:42.2.2]
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) ~[postgresql-42.2.2.jar:42.2.2]
at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source) ~[?:?]
/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/bin/java -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:/Applications/IntelliJ IDEA CE.app/Contents/lib/idea_rt.jar=53395:/Applications/IntelliJ IDEA CE.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath "/Applications/IntelliJ IDEA CE.app/Contents/lib/idea_rt.jar:/Applications/IntelliJ IDEA CE.app/Contents/plugins/junit/lib/junit-rt.jar:/Applications/IntelliJ IDEA CE.app/Contents/plugins/junit/lib/junit5-rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaV
Documentation Link: https://dotcms.com/docs/latest/elasticsearch-examples#FilterDistance
{
"query": {
"filtered": {
"query": {
"match_all": {}
},
"filter": {
"geo_distance": {
"distance": "2000km",
{
"_index": "live_20180213133337",
"_type": "content",
"_id": "f8d60f79-e006-42e0-894f-5d3488b796f6_1",
"_score": 1,
"_source": {
"deleted_dotraw": "false",
"confolder_dotraw": "system_folder",
"live_text": "true",
"ownercanwrite_text": "false",
{"deleted_dotraw":false,"confolder_dotraw":"774df085-8bcb-4f86-8e5d-775dc587b139","fileasset.description_text":"hr-snowflake",
"live_text":"true","ownercanwrite_text":"false","languageid_dotraw":1,"pubdate_dotraw":"Sep 24, 2014 11:53:10 AM",
"languageid":1,"type":"content","shortinode":"7dcda3ebdd3d408bad4d0f2080cf7893","inode":"7dcda3eb-dd3d-408b-ad4d-0f2080cf7893",
"locked_text":"false","path":"/application/themes/one-pager/img/hr-snowflake.png","moddate":"Sep 24, 2014 11:53:10 AM",
"live_dotraw":true,"confolder":"774df085-8bcb-4f86-8e5d-775dc587b139","fileasset.title_text":"hr-snowflake.png",
"permissions":"p654b0931-1027-41f7-ad4d-173115ed8ec1.2p p654b0931-1027-41f7-ad4d-173115ed8ec1.1p ",
"shortid_dotraw":"c038a014cc6f40979a9e28ea792f6da1","conhost":"48190c8c-42c4-46af-8d1a-0cd5db894797","locked":false,
"deleted_text":"false","shortid":"c038a014cc6f40979a9e28ea792f6da1","identifier":"c038a014-cc6f-4097-9a9e-28ea792f6da1",
"ownercanwrite":false,"moduser_dotraw":"dotcms.org.1","fileasset.filename_t