-
I encounter a failure during import (rank 11) pointing to a PL/SQL function. In order to debug further I'd like to see what the current place that has been indexed is. Or at list of places because the indexing (of course) runs multi threaded. Can the indexing run in debug mode, or is there a single line that could print the current place_id?
select rank_address, indexed_status, count(*) from placex group by rank_address, indexed_status order by rank_address;
rank_address | indexed_status | count
--------------+----------------+-----------
0 | 0 | 6757
0 | 2 | 3017
0 | 1 | 8987951
4 | 0 | 218
5 | 0 | 15
6 | 0 | 128
8 | 0 | 2784
10 | 0 | 3562
11 | 1 | 20908
11 | 0 | 3987
12 | 1 | 1354
12 | 0 | 32699
12 | 2 | 6555
14 | 2 | 1454
14 | 0 | 37536
14 | 1 | 1578
16 | 1 | 1416629
16 | 0 | 206874
16 | 2 | 206223
18 | 0 | 78169
18 | 2 | 3551
18 | 1 | 502
20 | 0 | 129429
20 | 1 | 2714155
20 | 2 | 64898
22 | 2 | 21616
22 | 1 | 1481479
22 | 0 | 44985
24 | 0 | 6988
25 | 0 | 64183
25 | 2 | 10588
25 | 1 | 1749563
26 | 1 | 100433113
27 | 1 | 4127632
30 | 1 | 178907621
30 | 2 | 1 |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
I would have expected that the place_id can be found in the corresponding error message in the PostgreSQL logs. If that is not the case and the error is reproducable, restart indexing with:
You get very verbose output including the place_id of each place being indexed. |
Beta Was this translation helpful? Give feedback.
I would have expected that the place_id can be found in the corresponding error message in the PostgreSQL logs.
If that is not the case and the error is reproducable, restart indexing with:
You get very verbose output including the place_id of each place being indexed.