API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 17th, 2015
600
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.47 KB | None | 0 0
raw download clone embed print report
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!