Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pq: could not resize shared memory segment "/PostgreSQL.1924253841" to 12615680 bytes: No space left on device
- SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
- avg(attrvalue::float) as relativeHumidity
- FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
- $ vim postgres-data/log/postgresql-2019-06-26_162920.log
- .
- .
- 2019-06-26 16:30:53.139 UTC [42] LOG: statement: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800) as time,
- avg(attrvalue::float) as o3
- FROM urbansense.airquality WHERE attrname='O3' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
- 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
- 2019-06-26 16:30:55.752 UTC [39] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
- avg(attrvalue::float) as relativeHumidity
- FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
- 2019-06-26 16:30:55.756 UTC [40] FATAL: terminating connection due to administrator command
- 2019-06-26 16:30:55.756 UTC [40] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
- avg(attrvalue::float) as relativeHumidity
- FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
- 2019-06-26 16:30:55.758 UTC [41] FATAL: terminating connection due to administrator command
- 2019-06-26 16:30:55.758 UTC [41] STATEMENT: SELECT to_timestamp(floor((extract('epoch' from recvtime)/ 1800 )) * 1800)as time,
- avg(attrvalue::float) as relativeHumidity
- FROM urbansense.weather WHERE attrname='relativeHumidity' AND attrvalue<>'null' GROUP BY time ORDER BY time asc;
- 2019-06-26 16:30:55.768 UTC [1] LOG: worker process: parallel worker for PID 39 (PID 40) exited with exit code 1
- 2019-06-26 16:30:55.768 UTC [1] LOG: worker process: parallel worker for PID 39 (PID 41) exited with exit code 1
- version: "3.5"
- services:
- #some containers definitions go here..
- postgres:
- restart: always
- image: postgres:10
- hostname: postgres
- container_name: fiware-postgres
- expose:
- - "5432"
- ports:
- - "5432:5432"
- networks:
- - default
- environment:
- - "POSTGRES_PASSWORD=password"
- - "POSTGRES_USER=postgres"
- - "POSTGRES_DB=postgres"
- volumes:
- - ./postgres-data:/var/lib/postgresql/data
- build:
- context: .
- shm_size: '4gb'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement