Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. pq: could not resize shared memory segment "/PostgreSQL.1924253841" to 12615680 bytes: No space left on device
  2.  
  3. SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
  4. avg(attrvalue::float) as relativeHumidity
  5. FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
  6.  
  7. $ vim postgres-data/log/postgresql-2019-06-26_162920.log
  8. .
  9. .
  10. 2019-06-26 16:30:53.139 UTC [42] LOG: statement: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800) as time,
  11. avg(attrvalue::float) as o3
  12. FROM urbansense.airquality WHERE attrname='O3' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
  13. 2019-06-26 16:30:55.752 UTC [39] ERROR: could not resize shared memory segment "/PostgreSQL.309696130" to 12615680 bytes: No space left on device
  14. 2019-06-26 16:30:55.752 UTC [39] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
  15. avg(attrvalue::float) as relativeHumidity
  16. FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
  17. 2019-06-26 16:30:55.756 UTC [40] FATAL: terminating connection due to administrator command
  18. 2019-06-26 16:30:55.756 UTC [40] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
  19. avg(attrvalue::float) as relativeHumidity
  20. FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
  21. 2019-06-26 16:30:55.758 UTC [41] FATAL: terminating connection due to administrator command
  22. 2019-06-26 16:30:55.758 UTC [41] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
  23. avg(attrvalue::float) as relativeHumidity
  24. FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
  25. 2019-06-26 16:30:55.768 UTC [1] LOG: worker process: parallel worker for PID 39 (PID 40) exited with exit code 1
  26. 2019-06-26 16:30:55.768 UTC [1] LOG: worker process: parallel worker for PID 39 (PID 41) exited with exit code 1
  27.  
  28. version: "3.5"
  29. services:
  30.  
  31. #some containers definitions go here..
  32.  
  33. postgres:
  34. restart: always
  35. image: postgres:10
  36. hostname: postgres
  37. container_name: fiware-postgres
  38. expose:
  39. - "5432"
  40. ports:
  41. - "5432:5432"
  42. networks:
  43. - default
  44. environment:
  45. - "POSTGRES_PASSWORD=password"
  46. - "POSTGRES_USER=postgres"
  47. - "POSTGRES_DB=postgres"
  48. volumes:
  49. - ./postgres-data:/var/lib/postgresql/data
  50. build:
  51. context: .
  52. shm_size: '4gb'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement