Guest User

Untitled

a guest
Jul 17th, 2015
413
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. < 2015-07-17 12:37:03.041 MSK >LOG: received fast shutdown request
  2. < 2015-07-17 12:37:03.041 MSK >LOG: aborting any active transactions
  3. < 2015-07-17 12:37:03.041 MSK >LOG: autovacuum launcher shutting down
  4. < 2015-07-17 12:37:03.043 MSK >LOG: shutting down
  5. < 2015-07-17 12:37:03.049 MSK >LOG: database system is shut down
  6. < 2015-07-17 12:37:04.290 MSK >LOG: database system was shut down at 2015-07-17 12:37:03 MSK
  7. < 2015-07-17 12:37:04.292 MSK >LOG: MultiXact member wraparound protections are now enabled
  8. < 2015-07-17 12:37:04.294 MSK >LOG: database system is ready to accept connections
  9. < 2015-07-17 12:37:04.294 MSK >LOG: autovacuum launcher started
  10. < 2015-07-17 12:39:33.073 MSK >ERROR: database "nominatim" does not exist
  11. < 2015-07-17 12:39:33.073 MSK >STATEMENT: DROP DATABASE nominatim;
  12.  
  13. < 2015-07-17 12:40:04.385 MSK >FATAL: database "nominatim" does not exist
  14. < 2015-07-17 12:40:12.981 MSK >ERROR: role "mqmgr" does not exist
  15. < 2015-07-17 12:40:12.981 MSK >STATEMENT: ALTER TABLE public.us_postcode OWNER TO mqmgr;
  16. < 2015-07-17 12:40:13.265 MSK >ERROR: relation "place" does not exist at character 79
  17. < 2015-07-17 12:40:13.265 MSK >STATEMENT: CREATE TABLE placex (
  18. place_id BIGINT NOT NULL,
  19. partition integer,
  20. LIKE place INCLUDING CONSTRAINTS,
  21. parent_place_id BIGINT,
  22. linked_place_id BIGINT,
  23. rank_address INTEGER,
  24. rank_search INTEGER,
  25. importance FLOAT,
  26. indexed_status INTEGER,
  27. indexed_date TIMESTAMP,
  28. wikipedia TEXT,
  29. geometry_sector INTEGER,
  30. calculated_country_code varchar(2)
  31. ) ;
  32. < 2015-07-17 12:40:13.266 MSK >ERROR: Table 'placex' does not occur in the search_path
  33. < 2015-07-17 12:40:13.266 MSK >CONTEXT: SQL statement "SELECT AddGeometryColumn('','',$1,$2,$3,$4,$5, $6)"
  34. PL/pgSQL function addgeometrycolumn(character varying,character varying,integer,character varying,integer,boolean) line 5 at SQL statement
  35. < 2015-07-17 12:40:13.266 MSK >STATEMENT: SELECT AddGeometryColumn('placex', 'centroid', 4326, 'GEOMETRY', 2);
  36. < 2015-07-17 12:40:13.266 MSK >ERROR: relation "placex" does not exist
  37. < 2015-07-17 12:40:13.266 MSK >STATEMENT: CREATE UNIQUE INDEX idx_place_id ON placex USING BTREE (place_id) ;
  38. < 2015-07-17 12:40:13.267 MSK >ERROR: relation "placex" does not exist
  39. < 2015-07-17 12:40:13.267 MSK >STATEMENT: CREATE INDEX idx_placex_osmid ON placex USING BTREE (osm_type, osm_id) ;
  40. < 2015-07-17 12:40:13.267 MSK >ERROR: relation "placex" does not exist
  41. < 2015-07-17 12:40:13.267 MSK >STATEMENT: CREATE INDEX idx_placex_linked_place_id ON placex USING BTREE (linked_place_id) ;
  42. < 2015-07-17 12:40:13.267 MSK >ERROR: relation "placex" does not exist
  43. < 2015-07-17 12:40:13.267 MSK >STATEMENT: CREATE INDEX idx_placex_rank_search ON placex USING BTREE (rank_search, geometry_sector) ;
  44. < 2015-07-17 12:40:13.267 MSK >ERROR: relation "placex" does not exist
  45. < 2015-07-17 12:40:13.267 MSK >STATEMENT: CREATE INDEX idx_placex_geometry ON placex USING GIST (geometry) ;
  46. < 2015-07-17 12:40:13.267 MSK >ERROR: relation "placex" does not exist
  47. < 2015-07-17 12:40:13.267 MSK >STATEMENT: CREATE INDEX idx_placex_adminname on placex USING BTREE (make_standard_name(name->'name'),rank_search) WHERE osm_type='N' and rank_search < 26;
  48. < 2015-07-17 12:40:13.268 MSK >ERROR: relation "placex" does not exist
  49. < 2015-07-17 12:40:13.268 MSK >STATEMENT: GRANT SELECT on placex to "apache" ;
  50. < 2015-07-17 12:40:13.269 MSK >ERROR: relation "planet_osm_ways" does not exist
  51. < 2015-07-17 12:40:13.269 MSK >STATEMENT: GRANT SELECT ON planet_osm_ways to "apache" ;
  52. < 2015-07-17 12:40:13.269 MSK >ERROR: relation "planet_osm_rels" does not exist
  53. < 2015-07-17 12:40:13.269 MSK >STATEMENT: GRANT SELECT ON planet_osm_rels to "apache" ;
  54. < 2015-07-17 12:40:13.269 MSK >ERROR: relation "placex" does not exist
  55. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE TRIGGER placex_before_insert BEFORE INSERT ON placex
  56. FOR EACH ROW EXECUTE PROCEDURE placex_insert();
  57. < 2015-07-17 12:40:13.270 MSK >ERROR: relation "placex" does not exist
  58. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE TRIGGER placex_before_update BEFORE UPDATE ON placex
  59. FOR EACH ROW EXECUTE PROCEDURE placex_update();
  60. < 2015-07-17 12:40:13.270 MSK >ERROR: relation "placex" does not exist
  61. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE TRIGGER placex_before_delete AFTER DELETE ON placex
  62. FOR EACH ROW EXECUTE PROCEDURE placex_delete();
  63. < 2015-07-17 12:40:13.270 MSK >ERROR: relation "place" does not exist
  64. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE TRIGGER place_before_delete BEFORE DELETE ON place
  65. FOR EACH ROW EXECUTE PROCEDURE place_delete();
  66. < 2015-07-17 12:40:13.270 MSK >ERROR: relation "place" does not exist
  67. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE TRIGGER place_before_insert BEFORE INSERT ON place
  68. FOR EACH ROW EXECUTE PROCEDURE place_insert();
  69. < 2015-07-17 12:40:13.270 MSK >ERROR: index "idx_placex_sector" does not exist
  70. < 2015-07-17 12:40:13.270 MSK >STATEMENT: drop index idx_placex_sector;
  71. < 2015-07-17 12:40:13.270 MSK >ERROR: relation "placex" does not exist
  72. < 2015-07-17 12:40:13.270 MSK >STATEMENT: CREATE INDEX idx_placex_sector ON placex USING BTREE (geometry_sector,rank_address,osm_type,osm_id) ;
  73. < 2015-07-17 12:40:13.271 MSK >ERROR: sequence "seq_postcodes" does not exist
  74. < 2015-07-17 12:40:13.271 MSK >STATEMENT: DROP SEQUENCE seq_postcodes;
  75. < 2015-07-17 12:40:13.271 MSK >ERROR: table "import_polygon_error" does not exist
  76. < 2015-07-17 12:40:13.271 MSK >STATEMENT: drop table import_polygon_error;
  77. < 2015-07-17 12:40:13.279 MSK >ERROR: table "import_polygon_delete" does not exist
  78. < 2015-07-17 12:40:13.279 MSK >STATEMENT: drop table import_polygon_delete;
  79. < 2015-07-17 12:40:13.283 MSK >ERROR: sequence "file" does not exist
  80. < 2015-07-17 12:40:13.283 MSK >STATEMENT: drop sequence file;
  81. < 2015-07-17 14:32:04.051 MSK >LOG: server process (PID 3102) was terminated by signal 9: Killed
  82. < 2015-07-17 14:32:04.054 MSK >DETAIL: Failed process was running: CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF);
  83.  
  84. < 2015-07-17 14:32:04.054 MSK >LOG: terminating any other active server processes
  85. < 2015-07-17 14:32:04.126 MSK >WARNING: terminating connection because of crash of another server process
  86. < 2015-07-17 14:32:04.126 MSK >DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
  87. < 2015-07-17 14:32:04.126 MSK >HINT: In a moment you should be able to reconnect to the database and repeat your command.
  88. < 2015-07-17 14:32:04.128 MSK >WARNING: terminating connection because of crash of another server process
  89. < 2015-07-17 14:32:04.128 MSK >DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
  90. < 2015-07-17 14:32:04.128 MSK >HINT: In a moment you should be able to reconnect to the database and repeat your command.
  91. < 2015-07-17 14:32:04.155 MSK >WARNING: terminating connection because of crash of another server process
  92. < 2015-07-17 14:32:04.155 MSK >DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
  93. < 2015-07-17 14:32:04.155 MSK >HINT: In a moment you should be able to reconnect to the database and repeat your command.
  94. < 2015-07-17 14:32:04.367 MSK >LOG: all server processes terminated; reinitializing
  95. < 2015-07-17 14:32:05.126 MSK >LOG: database system was interrupted; last known up at 2015-07-17 14:26:22 MSK
  96. < 2015-07-17 14:32:05.777 MSK >LOG: database system was not properly shut down; automatic recovery in progress
  97. < 2015-07-17 14:32:05.787 MSK >LOG: redo starts at 20/F0CEE4A8
  98. < 2015-07-17 14:32:41.765 MSK >LOG: unexpected pageaddr 20/5DA9C000 in log segment 000000010000002100000084, offset 11124736
  99. < 2015-07-17 14:32:41.766 MSK >LOG: redo done at 21/84A9BF78
  100. < 2015-07-17 14:32:41.766 MSK >LOG: last completed transaction was at log time 2015-07-17 14:30:05.630652+03
  101. < 2015-07-17 14:32:43.667 MSK >LOG: MultiXact member wraparound protections are now enabled
  102. < 2015-07-17 14:32:43.723 MSK >LOG: database system is ready to accept connections
  103. < 2015-07-17 14:32:43.723 MSK >LOG: autovacuum launcher started
  104. (END)
RAW Paste Data