{"action":"created","issue":{"url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/965","repository_url":"https://api.github.com/repos/openstreetmap/Nominatim","labels_url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/965/labels{/name}","comments_url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/965/comments","events_url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/965/events","html_url":"https://github.com/openstreetmap/Nominatim/issues/965","id":302062217,"number":965,"title":"nominatim indexing problem (nominatim/index.c)","user":{"login":"sporkman","id":510750,"avatar_url":"https://avatars1.githubusercontent.com/u/510750?v=4","gravatar_id":"","url":"https://api.github.com/users/sporkman","html_url":"https://github.com/sporkman","followers_url":"https://api.github.com/users/sporkman/followers","following_url":"https://api.github.com/users/sporkman/following{/other_user}","gists_url":"https://api.github.com/users/sporkman/gists{/gist_id}","starred_url":"https://api.github.com/users/sporkman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sporkman/subscriptions","organizations_url":"https://api.github.com/users/sporkman/orgs","repos_url":"https://api.github.com/users/sporkman/repos","events_url":"https://api.github.com/users/sporkman/events{/privacy}","received_events_url":"https://api.github.com/users/sporkman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-03-04T06:42:25Z","updated_at":"2018-03-05T20:34:37Z","closed_at":null,"author_association":"NONE","body":"During setup on a FreeBSD host, I'm running into an issue that appears to result from the indexing process silently failing (when setup calls the nominatim executable).\r\n\r\nMuch more information is here, including all the debugging, logs, etc. that brought me to the indexing process as the culprit: https://help.openstreetmap.org/questions/62358/local-nominatim-install-lookups-failing\r\n\r\nShort version:\r\n\r\n- some important tables seem empty\r\n- from the setup log, we can see that the indexing step does not fail or bail out, but it also does not seem to do anything (lots of \"Done 0 in 0...\" lines)\r\n- dumping this unindexed db and reloading on a working ubuntu host, running the indexer there, and then bringing the indexed db back to the freebsd host results in a working install\r\n- I also tried a few older versions of the nominatim indexer, same results\r\n- a ktrace of the indexing process shows that it does connect to the db and perform queries\r\n\r\nNot sure how much you wanted copied to this ticket, let me know what other information you want.\r\n\r\nFreeBSD 11.1\r\nPHP 5.6 and PHP 7.0 (tried with both)\r\nPostgreSQL 9.5\r\nPostGIS 2.4.2\r\nclang/LLVM 4.0.0"},"comment":{"url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/comments/370555605","html_url":"https://github.com/openstreetmap/Nominatim/issues/965#issuecomment-370555605","issue_url":"https://api.github.com/repos/openstreetmap/Nominatim/issues/965","id":370555605,"user":{"login":"sporkman","id":510750,"avatar_url":"https://avatars1.githubusercontent.com/u/510750?v=4","gravatar_id":"","url":"https://api.github.com/users/sporkman","html_url":"https://github.com/sporkman","followers_url":"https://api.github.com/users/sporkman/followers","following_url":"https://api.github.com/users/sporkman/following{/other_user}","gists_url":"https://api.github.com/users/sporkman/gists{/gist_id}","starred_url":"https://api.github.com/users/sporkman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sporkman/subscriptions","organizations_url":"https://api.github.com/users/sporkman/orgs","repos_url":"https://api.github.com/users/sporkman/repos","events_url":"https://api.github.com/users/sporkman/events{/privacy}","received_events_url":"https://api.github.com/users/sporkman/received_events","type":"User","site_admin":false},"created_at":"2018-03-05T20:34:37Z","updated_at":"2018-03-05T20:34:37Z","author_association":"NONE","body":"little-endian (amd64).  I grabbed the diff from above, it applied with a fuzz-factor of 3.  It does look like it's checking for gcc and while I think I've convinced cmake to use gcc6 in place of clang (`cmake -DCMAKE_C_COMPILER=/usr/local/bin/gcc -DCMAKE_CXX_COMPILER=/usr/local/bin/g++ ..`), I'm not going to bet my life that it works.\r\n\r\nRegardless, still seeing \"67108864\" (let me know if you want the entire pgsql log).\r\n\r\n```\r\nMar  5 15:19:11 nominatim postgres[35775]: [10-1] LOG:  duration: 1.538 ms  bind index_sectors: select geometry_sector,count(*) from placex where rank_search = $1 and indexed_status > 0 group by geometry_sector order by geometry_sector\r\nMar  5 15:19:11 nominatim postgres[35775]: [10-2] DETAIL:  parameters: $1 = '67108864'\r\nMar  5 15:19:11 nominatim postgres[35775]: [11-1] LOG:  duration: 0.081 ms  execute index_sectors: select geometry_sector,count(*) from placex where rank_search = $1 and indexed_status > 0 group by geometry_sector order by geometry_sector\r\nMar  5 15:19:11 nominatim postgres[35775]: [11-2] DETAIL:  parameters: $1 = '67108864'\r\n```\r\nFor little-endian, do I want byteswap.h included or not?  I'd rather skip all that ifdef stuff and just either include it or not for testing..."}}
{"actor":{"display_login":"sporkman"}}