-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path20200609-log_crash_pg.txt
67 lines (63 loc) · 2.91 KB
/
20200609-log_crash_pg.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
Idées:
- https://aws.amazon.com/fr/premiumsupport/knowledge-center/diskfull-error-rds-postgresql/ => contient des requêtes pour voir les fichiers temp
- https://stackoverflow.com/questions/21542550/why-does-postgresql-prompt-error-perhaps-out-of-disk-space-while-there-is-enou => montre la cmd SHOW data_directory
Des fichiers temporaires sont créés pour opérations, telles que les order by.
Des tables temporaires sont créées pour les transactions.
Dans le fichier de conf de PG, on peut définir la taille des fichiers temporaires.
Le plus simple est de simplifier, si possible, les query.
{ error: select "avg" from avg_acts('0002-06-02', '2020-06-09') where not "type" = $1 - could not write block 948318 of temporary file: No space left on device
at Connection.parseE (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:581:48)
at Connection.parseMessage (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:380:19)
at Socket.<anonymous> (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:116:22)
at Socket.emit (events.js:198:13)
at Socket.EventEmitter.emit (domain.js:448:20)
at addChunk (_stream_readable.js:288:12)
at readableAddChunk (_stream_readable.js:269:11)
at Socket.Readable.push (_stream_readable.js:224:10)
at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
name: 'error',
length: 167,
severity: 'ERROR',
code: '53100',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: 'SQL function "avg_acts" statement 1',
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'logtape.c',
line: '231',
routine: 'ltsWriteBlock' }
{ error: select "avg" from avg_acts('0020-06-02', '2020-06-09') where not "type" = $1 - could not write block 947631 of temporary file: No space left on device
at Connection.parseE (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:581:48)
at Connection.parseMessage (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:380:19)
at Socket.<anonymous> (/Users/pom/workspace/medle/node_modules/pg/lib/connection.js:116:22)
at Socket.emit (events.js:198:13)
at Socket.EventEmitter.emit (domain.js:448:20)
at addChunk (_stream_readable.js:288:12)
at readableAddChunk (_stream_readable.js:269:11)
at Socket.Readable.push (_stream_readable.js:224:10)
at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
name: 'error',
length: 167,
severity: 'ERROR',
code: '53100',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: 'SQL function "avg_acts" statement 1',
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'logtape.c',
line: '231',
routine: 'ltsWriteBlock' }