ERROR: cancelling statement due to user request when requesting over the api #3657

hh-it-co · 2025-02-20T13:25:31Z

hh-it-co
Feb 20, 2025

When i execute

curl -v "https://nominatim.mydomain.tld/nominatim/search?format=geocodejson&limit=1&addressdetails=1&country=PL&city=Ben&street=Ben+7&postalcode="

if receive

`* Trying 1.2.3.4:443...

Connected to nominatim.mydomain.tld (1.2.3.4) port 443 (#0)
ALPN, offering h2
ALPN, offering http/1.1
successfully set certificate verify locations:
CAfile: /etc/ssl/certs/ca-certificates.crt
CApath: /etc/ssl/certs
TLSv1.3 (OUT), TLS handshake, Client hello (1):
TLSv1.3 (IN), TLS handshake, Server hello (2):
TLSv1.3 (IN), TLS handshake, Encrypted Extensions (8):
TLSv1.3 (IN), TLS handshake, Certificate (11):
TLSv1.3 (IN), TLS handshake, CERT verify (15):
TLSv1.3 (IN), TLS handshake, Finished (20):
TLSv1.3 (OUT), TLS change cipher, Change cipher spec (1):
TLSv1.3 (OUT), TLS handshake, Finished (20):
SSL connection using TLSv1.3 / TLS_AES_256_GCM_SHA384
ALPN, server accepted to use h2
Server certificate:
subject: CN=nominatim.mydomain.tld
start date: Feb 20 07:05:23 2025 GMT
expire date: May 21 07:05:22 2025 GMT
subjectAltName: host "nominatim.mydomain.tld" matched cert's "nominatim.mydomain.tld"
issuer: C=US; O=Let's Encrypt; CN=E5
SSL certificate verify ok.
Using HTTP2, server supports multi-use
Connection state changed (HTTP/2 confirmed)
Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0
Using Stream ID: 1 (easy handle 0x5602cb4e4020)

GET /nominatim/search?format=geocodejson&limit=1&addressdetails=1&country=PL&city=Ben&street=Ben+7&postalcode= HTTP/2
Host: nominatim.mydomain.tld
user-agent: curl/7.74.0
accept: /

Connection state changed (MAX_CONCURRENT_STREAMS == 128)!
< HTTP/2 503
< server: nginx
< date: Thu, 20 Feb 2025 13:20:06 GMT
< content-type: text/plain; charset=utf-8
< content-length: 31
<
Connection #0 to host nominatim.mydomain.tld left intact
Query took too long to process.
`

The postgres-log shows

2025-02-20 13:00:56.790 UTC [13388] www-data@nominatim ERROR: canceling statement due to user request 2025-02-20 13:00:56.790 UTC [13388] www-data@nominatim STATEMENT: SELECT placex.place_id, placex.osm_type, placex.osm_id, placex.name, placex.class, placex.type, placex.address, placex.extratags, placex.housenumber, placex.postcode, placex.country_code, placex.wikipedia, placex.parent_place_id, placex.rank_address, placex.rank_search, placex.linked_place_id, placex.admin_level, ST_AsEWKB(placex.centroid) AS centroid, ST_AsEWKB(ST_Expand(placex.geometry, $1::INTEGER)) AS bbox, placex.importance, $2 + weigh_search(search_name.nameaddress_vector, $3::VARCHAR, $4) + weigh_search(search_name.nameaddress_vector, $5::VARCHAR, $6) AS accuracy FROM placex, search_name WHERE placex.place_id = search_name.place_id AND (search_name.name_vector && $7::INTEGER[]) AND (search_name.nameaddress_vector @> $8::INTEGER[]) AND search_name.country_code IN ($9::VARCHAR) AND placex.linked_place_id IS NULL AND placex.indexed_status = $10::SMALLINT AND (search_name.address_rank >= $11::SMALLINT OR search_name.search_rank >= $11::SMALLINT) LIMIT $12

The api returns http code 503.

I use the api over nginx behind another nginx reverse proxy.

How to debug this?

lonvia · 2025-02-20T13:45:03Z

lonvia
Feb 20, 2025
Maintainer

First of all, make sure that your installation finished properly by running ./nominatim admin --check-database on your server.

If that works out fine, run the query locally: nominatim search --format geocodejson --limit 1 --addressdetails --country PL --city Ben --street 'Ben 7' If the local query is fast, there is an issue with your nginx setup. If it is slow, there is an issue with your database. Run the same command with --format debug and see if that gets you information on where it hangs.

0 replies

hh-it-co · 2025-02-20T14:01:09Z

hh-it-co
Feb 20, 2025
Author

Thanks for the reply. This is my output:

`nominatim@nominatim:$ ./nominatim admin --check-database
bash: ./nominatim: No such file or directory
nominatim@nominatim:$ nominatim admin --check-database
2025-02-20 14:00:00: Using project directory: /srv/nominatim
2025-02-20 14:00:00: Checking database
Checking database connection ... OK
Checking database_version matches Nominatim software version ... OK
Checking for placex table ... OK
Checking for placex content ... OK
Checking that tokenizer works ... OK
Checking for wikipedia/wikidata data ... OK
Checking indexing status ... OK
Checking that database indexes are complete ... OK
Checking that all database indexes are valid ... OK
Checking TIGER external data table. ... not applicable
nominatim@nominatim:$ nominatim search --format geocodejson --limit 1 --addressdetails --country PL --city Ben --street 'Ben 7'
2025-02-20 14:00:15: Using project directory: /srv/nominatim
{
"type": "FeatureCollection",
"geocoding": {
"version": "0.1.0",
"attribution": "Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright",
"licence": "ODbL"
},
"features": []
}
nominatim@nominatim:$ nominatim search --format geocodejson --limit 1 --addressdetails --country PL --city Ben --street 'Ben 7' --format debug
2025-02-20 14:00:26: Using project directory: /srv/nominatim

Debug output for forward_lookup()

Parameters:
phrases: [Phrase(ptype=<PhraseType.STREET: 2>, text='Ben 7'), Phrase(ptype=<PhraseType.CITY: 3>, text='Ben'), Phrase(ptype=<PhraseType.COUNTRY: 7>, text='PL')]
params: SearchDetails(geometry_output=<GeometryFormat.NONE: 0>, address_details=True, linked_places=False, parented_places=False, keywords=False, geometry_simplification=0.0, locales=<nominatim.api.localization.Locales object at 0x7f07a54e2020>, max_results=2, min_rank=26, max_rank=30, layers=<DataLayer.ADDRESS: 1>, countries=[], excluded=[], viewbox=None, bounded_viewbox=False, near=None, near_radius=None, categories=[], viewbox_x2=None)

[2025-02-20 14:00:26.141346]

Analyze query (using ICU tokenizer)

Normalized query:
[Phrase(ptype=<PhraseType.STREET: 2>, text='ben 7'), Phrase(ptype=<PhraseType.CITY: 3>, text='ben'), Phrase(ptype=<PhraseType.COUNTRY: 7>, text='pl')]

Transliterated query:
<ben 7,ben,pl>

[2025-02-20 14:00:26.141750]
| SELECT word.word_id, word.word_token, word.type, word.word, word.info FROM
| word WHERE word.word_token IN (['ben', 'ben 7', '7', 'pl'])

Word tokens:

| type | token | word_token | lookup_word | penalty | count | info |

| WORD | 20738 | ben | bèn | 0.3333333333333333 | 2 | {'count': 2} |
| WORD | 23086142 | ben | bén | 0.3333333333333333 | 1 | {'count': 1} |
| WORD | 31358973 | ben | бењ | 1.0 | 0 | {'count': 0} |
| WORD | 295652 | ben | бен | 1.0 | 1 | {'count': 1} |
| WORD | 983007 | ben | ben | 0.0 | 16 | {'count': 16} |
| PARTIAL | 17380 | ben | ben | 0.3 | 2524 | {'count': 2524} |
| WORD | 122096 | 7 | 7 | 0.7 | 17253 | {'count': 17253} |
| WORD | 2566291 | 7 | sette | 1.5 | 2 | {'count': 2} |
| PARTIAL | 36893 | 7 | 7 | 0.8 | 90648 | {'count': 90648} |
| HOUSENUMBER | 2362146 | 7 | 7 | 0 | 77719 | {'count': 77719, 'lookup': '7'} |
| WORD | 20738 | ben | bèn | 0.3333333333333333 | 2 | {'count': 2} |
| WORD | 23086142 | ben | bén | 0.3333333333333333 | 1 | {'count': 1} |
| WORD | 31358973 | ben | бењ | 1.0 | 0 | {'count': 0} |
| WORD | 295652 | ben | бен | 1.0 | 1 | {'count': 1} |
| WORD | 983007 | ben | ben | 0.0 | 16 | {'count': 16} |
| PARTIAL | 17380 | ben | ben | 0.3 | 2524 | {'count': 2524} |
| COUNTRY | None | pl | pl | 0.0 | 1 | {'internal': 'yes'} |

[2025-02-20 14:00:26.146803]

Compute abstract searches

Assignment:
[0 - 1: PARTIAL][1 - 2: HOUSENUMBER][2 - 3: PARTIAL][3 - 4: COUNTRY] (dir: 1, penalty: 0.1)

first word = name
Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 0.2 | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(name_vector[[P]ben(17380)]) | 7^0 | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |
| | <class 'nominatim.api.search.db_search_lookups.Restrict'>(nameaddress_vector[[P]ben(17380)]) | | | | | | name_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.5) |

Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 0.25 | <class 'nominatim.api.search.db_search_lookups.LookupAny'>(name_vector[[H]7(2362146)]) | | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.5) |
| | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(nameaddress_vector[[P]ben(17380)]) | | | | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |

Assignment:
[0 - 2: PARTIAL][2 - 3: PARTIAL][3 - 4: COUNTRY] (dir: 1, penalty: 0.0)

first word = name
Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 1.3 | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(name_vector[[P]ben(17380),[P]7(36893)]) | | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |
| | <class 'nominatim.api.search.db_search_lookups.Restrict'>(nameaddress_vector[[P]ben(17380)]) | | | | | | |

[2025-02-20 14:00:26.147790]

Execute database searches

Search:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 0.2 | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(name_vector[[P]ben(17380)]) | 7^0 | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |
| | <class 'nominatim.api.search.db_search_lookups.Restrict'>(nameaddress_vector[[P]ben(17380)]) | | | | | | name_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.5) |

Params:
SearchDetails(geometry_output=<GeometryFormat.NONE: 0>, address_details=True, linked_places=False, parented_places=False, keywords=False, geometry_simplification=0.0, locales=<nominatim.api.localization.Locales object at 0x7f07a54e2020>, max_results=2, min_rank=26, max_rank=30, layers=<DataLayer.ADDRESS: 1>, countries=[], excluded=[], viewbox=None, bounded_viewbox=False, near=None, near_radius=None, categories=[], viewbox_x2=None)

[2025-02-20 14:00:26.153612]
| SELECT unsort.place_id, unsort.osm_type, unsort.osm_id, unsort.name,
| unsort.class, unsort.type, unsort.address, unsort.extratags,
| unsort.housenumber, unsort.postcode, unsort.country_code, unsort.wikipedia,
| unsort.parent_place_id, unsort.rank_address, unsort.rank_search,
| unsort.linked_place_id, unsort.admin_level, ST_AsEWKB(unsort.centroid) AS
| centroid, ST_AsEWKB(unsort.bbox) AS bbox, unsort.importance, unsort.accuracy,
| unsort.placex_hnr, unsort.interpol_hnr, unsort.tiger_hnr FROM (SELECT
| anon_1.place_id AS place_id, anon_1.osm_type AS osm_type, anon_1.osm_id AS
| osm_id, anon_1.name AS name, anon_1.class AS class, anon_1.type AS type,
| anon_1.address AS address, anon_1.extratags AS extratags, anon_1.housenumber
| AS housenumber, anon_1.postcode AS postcode, anon_1.country_code AS
| country_code, anon_1.wikipedia AS wikipedia, anon_1.parent_place_id AS
| parent_place_id, anon_1.rank_address AS rank_address, anon_1.rank_search AS
| rank_search, anon_1.linked_place_id AS linked_place_id, anon_1.admin_level AS
| admin_level, anon_1.centroid AS centroid, anon_1.bbox AS bbox,
| anon_1.importance AS importance, anon_1.accuracy AS accuracy, (SELECT
| array_agg(hnr.place_id) AS array_agg_1 FROM placex AS hnr WHERE
| hnr.parent_place_id = anon_1.place_id AND hnr.housenumber ~* ('\m(' || '7' ||
| ')\M')::text AND hnr.linked_place_id IS NULL AND hnr.indexed_status = 0) AS
| placex_hnr, (SELECT array_agg(location_property_osmline.place_id) AS
| array_agg_2 FROM location_property_osmline WHERE
| location_property_osmline.parent_place_id = anon_1.place_id AND 7 BETWEEN
| location_property_osmline.startnumber AND location_property_osmline.endnumber
| AND (7 - location_property_osmline.startnumber) %
| location_property_osmline.step = 0) AS interpol_hnr, CASE WHEN
| (anon_1.country_code = 'us') THEN (SELECT
| array_agg(location_property_tiger.place_id) AS array_agg_3 FROM
| location_property_tiger WHERE location_property_tiger.parent_place_id =
| anon_1.place_id AND 7 BETWEEN location_property_tiger.startnumber AND
| location_property_tiger.endnumber AND (7 -
| location_property_tiger.startnumber) % location_property_tiger.step = 0) END
| AS tiger_hnr FROM (SELECT placex.place_id AS place_id, placex.osm_type AS
| osm_type, placex.osm_id AS osm_id, placex.name AS name, placex.class AS class,
| placex.type AS type, placex.address AS address, placex.extratags AS extratags,
| placex.housenumber AS housenumber, placex.postcode AS postcode,
| placex.country_code AS country_code, placex.wikipedia AS wikipedia,
| placex.parent_place_id AS parent_place_id, placex.rank_address AS
| rank_address, placex.rank_search AS rank_search, placex.linked_place_id AS
| linked_place_id, placex.admin_level AS admin_level, placex.centroid AS
| centroid, ST_Expand(placex.geometry, 0) AS bbox, placex.importance AS
| importance, 0.2 + weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]
| ],[0.3333333333333333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]
| ],[1.0,[295652]]]', 0.6) + weigh_search(search_name.name_vector, '[[0.0,[98300
| 7]],[0.3333333333333333,[20738]],[0.3333333333333333,[23086142]],[1.0,[3135897
| 3]],[1.0,[295652]]]', 0.5) AS accuracy FROM placex, search_name WHERE
| placex.place_id = search_name.place_id AND (search_name.name_vector @>
| [17380]) AND (coalesce(null, search_name.nameaddress_vector) @> [17380]) AND
| search_name.country_code IN (['pl']) AND search_name.address_rank BETWEEN 16
| AND 30 AND (search_name.address_rank < 30 OR placex.housenumber ~* ('\m(' ||
| '7' || ')\M')::text) ORDER BY (0.2 +
| weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]],[0.3333333333333
| 333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],[1.0,[295652]]]'
| , 0.6) + weigh_search(search_name.name_vector, '[[0.0,[983007]],[0.33333333333
| 33333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],[1.0,[295652]]
| ]', 0.5)) - CASE WHEN (search_name.importance > 0) THEN search_name.importance
| ELSE 0.40001 - CAST(search_name.search_rank AS FLOAT) / 75 END, accuracy
| LIMIT 10000) AS anon_1) AS unsort ORDER BY CASE WHEN (unsort.placex_hnr IS NOT
| NULL) THEN 1 WHEN (unsort.interpol_hnr IS NOT NULL) THEN 2 WHEN
| (unsort.tiger_hnr IS NOT NULL) THEN 3 ELSE 4 END, unsort.accuracy LIMIT 2

[2025-02-20 14:00:26.207970]
Results:
TOTAL: 0

Search:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 0.25 | <class 'nominatim.api.search.db_search_lookups.LookupAny'>(name_vector[[H]7(2362146)]) | | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.5) |
| | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(nameaddress_vector[[P]ben(17380)]) | | | | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |

Params:
SearchDetails(geometry_output=<GeometryFormat.NONE: 0>, address_details=True, linked_places=False, parented_places=False, keywords=False, geometry_simplification=0.0, locales=<nominatim.api.localization.Locales object at 0x7f07a54e2020>, max_results=2, min_rank=26, max_rank=30, layers=<DataLayer.ADDRESS: 1>, countries=[], excluded=[], viewbox=None, bounded_viewbox=False, near=None, near_radius=None, categories=[], viewbox_x2=None)

[2025-02-20 14:00:26.210038]
| SELECT placex.place_id, placex.osm_type, placex.osm_id, placex.name,
| placex.class, placex.type, placex.address, placex.extratags,
| placex.housenumber, placex.postcode, placex.country_code, placex.wikipedia,
| placex.parent_place_id, placex.rank_address, placex.rank_search,
| placex.linked_place_id, placex.admin_level, ST_AsEWKB(placex.centroid) AS
| centroid, ST_AsEWKB(ST_Expand(placex.geometry, 0)) AS bbox, placex.importance,
| 0.25 + weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]],[0.333333
| 3333333333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],[1.0,[295
| 652]]]', 0.5) + weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]],
| [0.3333333333333333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],
| [1.0,[295652]]]', 0.6) AS accuracy FROM placex, search_name WHERE
| placex.place_id = search_name.place_id AND (search_name.name_vector &&
| [2362146]) AND (search_name.nameaddress_vector @> [17380]) AND
| search_name.country_code IN (['pl']) AND placex.linked_place_id IS NULL AND
| placex.indexed_status = 0 AND (search_name.address_rank >= 26 OR
| search_name.search_rank >= 26) AND (coalesce(NULL, placex.rank_address)
| BETWEEN 1 AND 29 OR (placex.rank_address = 30 AND (placex.housenumber IS NOT
| NULL OR placex.name ? 'addr:housename')) OR placex.class IN ([]) AND
| coalesce(NULL, placex.rank_address) = 0) LIMIT 2

[2025-02-20 14:00:27.802195]
Results:
TOTAL: 0

Search:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| 1.3 | <class 'nominatim.api.search.db_search_lookups.LookupAll'>(name_vector[[P]ben(17380),[P]7(36893)]) | | | pl^0.0 | | | nameaddress_vector([[W]ben(983007)]^0,[[W]bèn(20738)]^0.333,[[W]bén(23086142)]^0.333,[[W]бењ(31358973)]^1,[[W]бен(29565...,def=0.6) |
| | <class 'nominatim.api.search.db_search_lookups.Restrict'>(nameaddress_vector[[P]ben(17380)]) | | | | | | |

Params:
SearchDetails(geometry_output=<GeometryFormat.NONE: 0>, address_details=True, linked_places=False, parented_places=False, keywords=False, geometry_simplification=0.0, locales=<nominatim.api.localization.Locales object at 0x7f07a54e2020>, max_results=2, min_rank=26, max_rank=30, layers=<DataLayer.ADDRESS: 1>, countries=[], excluded=[], viewbox=None, bounded_viewbox=False, near=None, near_radius=None, categories=[], viewbox_x2=None)

[2025-02-20 14:00:27.804390]
| SELECT placex.place_id, placex.osm_type, placex.osm_id, placex.name,
| placex.class, placex.type, placex.address, placex.extratags,
| placex.housenumber, placex.postcode, placex.country_code, placex.wikipedia,
| placex.parent_place_id, placex.rank_address, placex.rank_search,
| placex.linked_place_id, placex.admin_level, ST_AsEWKB(placex.centroid) AS
| centroid, ST_AsEWKB(ST_Expand(placex.geometry, 0)) AS bbox, placex.importance,
| 1.3 + weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]],[0.3333333
| 333333333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],[1.0,[2956
| 52]]]', 0.6) AS accuracy FROM placex, search_name WHERE placex.place_id =
| search_name.place_id AND (search_name.name_vector @> [17380, 36893]) AND
| (coalesce(null, search_name.nameaddress_vector) @> [17380]) AND
| search_name.country_code IN (['pl']) AND placex.linked_place_id IS NULL AND
| placex.indexed_status = 0 AND (search_name.address_rank >= 26 OR
| search_name.search_rank >= 26) AND (coalesce(NULL, placex.rank_address)
| BETWEEN 1 AND 29 OR (placex.rank_address = 30 AND (placex.housenumber IS NOT
| NULL OR placex.name ? 'addr:housename')) OR placex.class IN ([]) AND
| coalesce(NULL, placex.rank_address) = 0) ORDER BY (1.3 +
| weigh_search(search_name.nameaddress_vector, '[[0.0,[983007]],[0.3333333333333
| 333,[20738]],[0.3333333333333333,[23086142]],[1.0,[31358973]],[1.0,[295652]]]'
| , 0.6)) - CASE WHEN (search_name.importance > 0) THEN search_name.importance
| ELSE 0.40001 - CAST(search_name.search_rank AS FLOAT) / 75 END, accuracy
| LIMIT 2

[2025-02-20 14:00:27.812710]
Results:
TOTAL: 0

[2025-02-20 14:00:27.812733]
Preliminary Results:
TOTAL: 0

[2025-02-20 14:00:27.812887]
Results after reranking:
TOTAL: 0

[2025-02-20 14:00:27.812896]
Final Results:
TOTAL: 0
`

1 reply

lonvia Feb 20, 2025
Maintainer

1.7s for a complicated query without a result is not unheard of. You need to configure longer timeouts in your setup.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

ERROR: cancelling statement due to user request when requesting over the api #3657

Uh oh!

{{title}}

Uh oh!

Replies: 2 comments 1 reply

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

ERROR: cancelling statement due to user request when requesting over the api #3657

Uh oh!

hh-it-co Feb 20, 2025

Replies: 2 comments · 1 reply

Uh oh!

lonvia Feb 20, 2025 Maintainer

Uh oh!

hh-it-co Feb 20, 2025 Author

Debug output for forward_lookup()

Analyze query (using ICU tokenizer)

Word tokens:

| type | token | word_token | lookup_word | penalty | count | info |

Compute abstract searches

first word = name Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

first word = name Searches for assignment:

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

Execute database searches

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

| Penalty | Lookups | Housenr | Postcode | Countries | Qualifier | Catgeory | Rankings |

Uh oh!

lonvia Feb 20, 2025 Maintainer

hh-it-co
Feb 20, 2025

Replies: 2 comments 1 reply

lonvia
Feb 20, 2025
Maintainer

hh-it-co
Feb 20, 2025
Author

first word = name
Searches for assignment:

first word = name
Searches for assignment:

lonvia Feb 20, 2025
Maintainer