Skip to content

Instantly share code, notes, and snippets.

View silvestrelosada's full-sized avatar

Silvestre Losada silvestrelosada

View GitHub Profile
@silvestrelosada
silvestrelosada / first-name-synonyms.csv
Created January 14, 2019 11:02 — forked from harlow/first-name-synonyms.csv
First name synonyms for Elasticsearch synonym filter
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 4 columns, instead of 5. in line 1.
aaron,erin,ron,ronnie
abel,ab,abe,eb,ebbie
abiel,ab
abigail,abby,gail,gail,nabby
abner,ab
abraham,ab,abe
abram,ab
adaline,ada,addy,delia,dell,lena
adelaide,addy,adele,dell,della,heidi
adeline,ada,addy,delia,dell,lena
@silvestrelosada
silvestrelosada / logstash-netscaler.conf
Created December 14, 2018 15:16 — forked from haukurk/logstash-netscaler.conf
Logstash - Netscaler Config
input {
syslog {
type => "netscaler"
port => "5560"
}
}
filter {
# Set tags for ASAs
{
"query": {
"function_score": {
"query": {
"match_all": {
"boost": 0
}
},
"functions": [{
"gauss": {
{
"plan": {
"root": {
"operatorType": "ProduceResults",
"runtime-impl": "INTERPRETED",
"planner-impl": "IDP",
"DbHits": 0,
"Rows": 1,
"version": "CYPHER 3.0",
"KeyNames": "shortestPath, totalWeight",
08:44:14.258 [http-bio-8987-exec-3] DEBUG o.a.h.i.conn.DefaultClientConnection - Sending request: GET /solr/posts_shard5_replica1/select?q=id%3Agoogleplus_20032_z12jufbxtz3iw1z4p04cjnnynnametbivjc&start=0&rows=1&wt=javabin&version=2 HTTP/1.1
08:44:14.258 [http-bio-8987-exec-3] DEBUG org.apache.http.wire - >> "GET /solr/posts_shard5_replica1/select?q=id%3Agoogleplus_20032_z12jufbxtz3iw1z4p04cjnnynnametbivjc&start=0&rows=1&wt=javabin&version=2 HTTP/1.1[\r][\n]"
08:44:14.258 [http-bio-8987-exec-3] DEBUG org.apache.http.wire - >> "User-Agent: Solr[org.apache.solr.client.solrj.impl.HttpSolrServer] 1.0[\r][\n]"
08:44:14.259 [http-bio-8987-exec-3] DEBUG org.apache.http.wire - >> "Host: solr-cluster-1562954327.us-east-1.elb.amazonaws.com:8983[\r][\n]"
08:44:14.259 [http-bio-8987-exec-3] DEBUG org.apache.http.wire - >> "Connection: Keep-Alive[\r][\n]"
08:44:14.259 [http-bio-8987-exec-3] DEBUG org.apache.http.wire - >> "[\r][\n]"
08:44:14.259 [http-bio-8987-exec-3] DEBUG org.apache.http.headers - >> GET /solr/posts_sha
##################### Elasticsearch Configuration Example #####################
# This file contains an overview of various configuration settings,
# targeted at operations staff. Application developers should
# consult the guide at <http://elasticsearch.org/guide>.
#
# The installation procedure is covered at
# <http://elasticsearch.org/guide/en/elasticsearch/reference/current/setup.html>.
#
# Elasticsearch comes with reasonable defaults for most settings,
nominatim=# \d search_name
Table "public.search_name"
Column | Type | Modifiers
--------------------+-------------------------+-----------
place_id | bigint |
search_rank | integer |
address_rank | integer |
importance | double precision |
country_code | character varying(2) |
name_vector | integer[] |
2014-10-24 16:08:56 UTC LOG: received fast shutdown request
2014-10-24 16:08:56 UTC LOG: aborting any active transactions
2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command
2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command
2014-10-24 16:08:56 UTC LOG: autovacuum launcher shutting down
2014-10-24 16:08:56 UTC FATAL: terminating connection due to administrator command
2014-10-24 16:08:56 UTC CONTEXT: SQL statement "update placex set indexed_status = 2 where parent_place_id = OLD.place_id and indexed_status = 0"
PL/pgSQL function placex_delete() line 27 at SQL statement
SQL statement "delete from placex where place_id = OLD.place_id"
PL/pgSQL function placex_update() line 50 at SQL statement
2014-10-30 08:46:16 UTC LOG: duration: 219.276 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130295926 and st_geometrytype(Box2D(geometry)) = 'ST_Polygon'
2014-10-30 08:46:16 UTC LOG: duration: 3.326 ms statement: select place_id,0 as numfeatures,st_area(geometry) as area,ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon from placex where place_id = 130297410 and st_geometrytype(Box2D(geometry)) = 'ST_P