forked from zanfranceschi/rinha-de-backend-2024-q1
-
Notifications
You must be signed in to change notification settings - Fork 0
/
docker-compose.logs
500 lines (500 loc) · 29 KB
/
docker-compose.logs
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
Network rinha-nginx-2024q1 Creating
Network rinha-nginx-2024q1 Created
Container zetos-node-db-1 Creating
Container zetos-node-db-1 Created
Container zetos-node-api01-1 Creating
Container zetos-node-api02-1 Creating
Container zetos-node-api01-1 Created
Container zetos-node-api02-1 Created
Container zetos-node-nginx-1 Creating
Container zetos-node-nginx-1 Created
Attaching to api01-1, api02-1, db-1, nginx-1
db-1 | The files belonging to this database system will be owned by user "postgres".
db-1 | This user must also own the server process.
db-1 |
db-1 | The database cluster will be initialized with locale "en_US.utf8".
db-1 | The default database encoding has accordingly been set to "UTF8".
db-1 | The default text search configuration will be set to "english".
db-1 |
db-1 | Data page checksums are disabled.
db-1 |
db-1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
db-1 | creating subdirectories ... ok
db-1 | selecting dynamic shared memory implementation ... posix
db-1 | selecting default max_connections ... 100
db-1 | selecting default shared_buffers ... 128MB
db-1 | selecting default time zone ... Etc/UTC
db-1 | creating configuration files ... ok
db-1 | running bootstrap script ... ok
api01-1 | uws server is listening at http://0.0.0.0:8080 [External: 73db800]
nginx-1 | /docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
nginx-1 | /docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
nginx-1 | /docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
api02-1 | uws server is listening at http://0.0.0.0:8080 [External: 605b580]
nginx-1 | 10-listen-on-ipv6-by-default.sh: info: Getting the checksum of /etc/nginx/conf.d/default.conf
nginx-1 | 10-listen-on-ipv6-by-default.sh: info: Enabled listen on IPv6 in /etc/nginx/conf.d/default.conf
nginx-1 | /docker-entrypoint.sh: Sourcing /docker-entrypoint.d/15-local-resolvers.envsh
nginx-1 | /docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
nginx-1 | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
nginx-1 | /docker-entrypoint.sh: Configuration complete; ready for start up
db-1 | performing post-bootstrap initialization ... ok
db-1 | syncing data to disk ... ok
db-1 |
db-1 |
db-1 | Success. You can now start the database server using:
db-1 |
db-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
db-1 |
db-1 | initdb: warning: enabling "trust" authentication for local connections
db-1 | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
db-1 | waiting for server to start....2024-03-03 06:04:43.730 UTC [48] LOG: starting PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
db-1 | 2024-03-03 06:04:43.734 UTC [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db-1 | 2024-03-03 06:04:43.743 UTC [51] LOG: database system was shut down at 2024-03-03 06:04:42 UTC
db-1 | 2024-03-03 06:04:43.749 UTC [48] LOG: database system is ready to accept connections
db-1 | done
db-1 | server started
db-1 | CREATE DATABASE
db-1 |
db-1 |
db-1 | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/script.sql
db-1 | CREATE TABLE
db-1 | CREATE TABLE
db-1 | CREATE INDEX
db-1 | INSERT 0 5
db-1 |
db-1 |
db-1 | waiting for server to shut down....2024-03-03 06:04:44.062 UTC [48] LOG: received fast shutdown request
db-1 | 2024-03-03 06:04:44.065 UTC [48] LOG: aborting any active transactions
db-1 | 2024-03-03 06:04:44.114 UTC [48] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
db-1 | 2024-03-03 06:04:44.114 UTC [49] LOG: shutting down
db-1 | 2024-03-03 06:04:44.117 UTC [49] LOG: checkpoint starting: shutdown immediate
db-1 | 2024-03-03 06:04:44.641 UTC [49] LOG: checkpoint complete: wrote 941 buffers (5.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.386 s, sync=0.126 s, total=0.527 s; sync files=315, longest=0.058 s, average=0.001 s; distance=4299 kB, estimate=4299 kB; lsn=0/191D700, redo lsn=0/191D700
db-1 | 2024-03-03 06:04:44.646 UTC [48] LOG: database system is shut down
db-1 | done
db-1 | server stopped
db-1 |
db-1 | PostgreSQL init process complete; ready for start up.
db-1 |
db-1 | 2024-03-03 06:04:44.687 UTC [1] LOG: starting PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
db-1 | 2024-03-03 06:04:44.687 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
db-1 | 2024-03-03 06:04:44.687 UTC [1] LOG: listening on IPv6 address "::", port 5432
db-1 | 2024-03-03 06:04:44.693 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db-1 | 2024-03-03 06:04:44.703 UTC [66] LOG: database system was shut down at 2024-03-03 06:04:44 UTC
db-1 | 2024-03-03 06:04:44.707 UTC [67] FATAL: the database system is starting up
api01-1 | caugh !! PostgresError: the database system is starting up
api01-1 | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
api01-1 | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
api01-1 | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
api01-1 | at Socket.emit (node:events:518:28)
api01-1 | at addChunk (node:internal/streams/readable:559:12)
api01-1 | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
api01-1 | at Readable.push (node:internal/streams/readable:390:5)
api01-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
api01-1 | at cachedError (/usr/src/app/node_modules/postgres/cjs/src/query.js:170:23)
api01-1 | at new Query (/usr/src/app/node_modules/postgres/cjs/src/query.js:36:24)
api01-1 | at sql (/usr/src/app/node_modules/postgres/cjs/src/index.js:112:11)
api01-1 | at /usr/src/app/build/db.js:44:34 {
api01-1 | severity_local: 'FATAL',
api01-1 | severity: 'FATAL',
api01-1 | code: '57P03',
api01-1 | file: 'postmaster.c',
api01-1 | line: '2334',
api01-1 | routine: 'ProcessStartupPacket'
api01-1 | }
db-1 | 2024-03-03 06:04:44.711 UTC [1] LOG: database system is ready to accept connections
api02-1 | caugh !! Error: Not Found
api02-1 | at /usr/src/app/build/index.js:71:19
api02-1 | at Generator.next (<anonymous>)
api02-1 | at fulfilled (/usr/src/app/build/index.js:5:58)
api02-1 | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
db-1 | 2024-03-03 06:05:08.415 UTC [84] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:08.415 UTC [84] DETAIL: Failing row contains (1, 100000, -106181, o barato sai caro).
db-1 | 2024-03-03 06:05:08.415 UTC [84] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:09.821 UTC [75] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:09.821 UTC [75] DETAIL: Failing row contains (1, 100000, -104156, o barato sai caro).
db-1 | 2024-03-03 06:05:09.821 UTC [75] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:10.342 UTC [77] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:10.342 UTC [77] DETAIL: Failing row contains (1, 100000, -107568, o barato sai caro).
db-1 | 2024-03-03 06:05:10.342 UTC [77] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:10.495 UTC [80] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:10.495 UTC [80] DETAIL: Failing row contains (1, 100000, -101727, o barato sai caro).
db-1 | 2024-03-03 06:05:10.495 UTC [80] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:12.426 UTC [82] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:12.426 UTC [82] DETAIL: Failing row contains (1, 100000, -105211, o barato sai caro).
db-1 | 2024-03-03 06:05:12.426 UTC [82] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:12.976 UTC [88] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:12.976 UTC [88] DETAIL: Failing row contains (2, 80000, -83906, zan corp ltda).
db-1 | 2024-03-03 06:05:12.976 UTC [88] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.073 UTC [87] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.073 UTC [87] DETAIL: Failing row contains (1, 100000, -101525, o barato sai caro).
db-1 | 2024-03-03 06:05:13.073 UTC [87] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.106 UTC [77] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.106 UTC [77] DETAIL: Failing row contains (2, 80000, -84420, zan corp ltda).
db-1 | 2024-03-03 06:05:13.106 UTC [77] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.138 UTC [74] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.138 UTC [74] DETAIL: Failing row contains (1, 100000, -100492, o barato sai caro).
db-1 | 2024-03-03 06:05:13.138 UTC [74] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.170 UTC [72] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.170 UTC [72] DETAIL: Failing row contains (2, 80000, -83177, zan corp ltda).
db-1 | 2024-03-03 06:05:13.170 UTC [72] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.235 UTC [82] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.235 UTC [82] DETAIL: Failing row contains (1, 100000, -107356, o barato sai caro).
db-1 | 2024-03-03 06:05:13.235 UTC [82] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.395 UTC [75] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.395 UTC [75] DETAIL: Failing row contains (2, 80000, -86967, zan corp ltda).
db-1 | 2024-03-03 06:05:13.395 UTC [75] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.427 UTC [87] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.427 UTC [87] DETAIL: Failing row contains (1, 100000, -105166, o barato sai caro).
db-1 | 2024-03-03 06:05:13.427 UTC [87] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.490 UTC [74] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.490 UTC [74] DETAIL: Failing row contains (2, 80000, -81910, zan corp ltda).
db-1 | 2024-03-03 06:05:13.490 UTC [74] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.672 UTC [76] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.672 UTC [76] DETAIL: Failing row contains (1, 100000, -105814, o barato sai caro).
db-1 | 2024-03-03 06:05:13.672 UTC [76] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.793 UTC [78] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.793 UTC [78] DETAIL: Failing row contains (1, 100000, -102868, o barato sai caro).
db-1 | 2024-03-03 06:05:13.793 UTC [78] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:13.975 UTC [71] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:13.975 UTC [71] DETAIL: Failing row contains (1, 100000, -105129, o barato sai caro).
db-1 | 2024-03-03 06:05:13.975 UTC [71] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.096 UTC [75] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.096 UTC [75] DETAIL: Failing row contains (1, 100000, -105720, o barato sai caro).
db-1 | 2024-03-03 06:05:14.096 UTC [75] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.157 UTC [77] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.157 UTC [77] DETAIL: Failing row contains (1, 100000, -102823, o barato sai caro).
db-1 | 2024-03-03 06:05:14.157 UTC [77] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.369 UTC [88] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.369 UTC [88] DETAIL: Failing row contains (1, 100000, -101313, o barato sai caro).
db-1 | 2024-03-03 06:05:14.369 UTC [88] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.429 UTC [76] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.429 UTC [76] DETAIL: Failing row contains (2, 80000, -82494, zan corp ltda).
db-1 | 2024-03-03 06:05:14.429 UTC [76] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.460 UTC [77] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.460 UTC [77] DETAIL: Failing row contains (1, 100000, -101195, o barato sai caro).
db-1 | 2024-03-03 06:05:14.460 UTC [77] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.546 UTC [85] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.546 UTC [85] DETAIL: Failing row contains (2, 80000, -80371, zan corp ltda).
db-1 | 2024-03-03 06:05:14.546 UTC [85] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.602 UTC [71] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.602 UTC [71] DETAIL: Failing row contains (1, 100000, -104130, o barato sai caro).
db-1 | 2024-03-03 06:05:14.602 UTC [71] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.717 UTC [81] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.717 UTC [81] DETAIL: Failing row contains (1, 100000, -106211, o barato sai caro).
db-1 | 2024-03-03 06:05:14.717 UTC [81] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:14.831 UTC [83] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:14.831 UTC [83] DETAIL: Failing row contains (1, 100000, -104075, o barato sai caro).
db-1 | 2024-03-03 06:05:14.831 UTC [83] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:15.174 UTC [83] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:15.174 UTC [83] DETAIL: Failing row contains (1, 100000, -105101, o barato sai caro).
db-1 | 2024-03-03 06:05:15.174 UTC [83] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:15.235 UTC [72] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:15.235 UTC [72] DETAIL: Failing row contains (2, 80000, -80921, zan corp ltda).
db-1 | 2024-03-03 06:05:15.235 UTC [72] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:15.946 UTC [73] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:15.946 UTC [73] DETAIL: Failing row contains (1, 100000, -102322, o barato sai caro).
db-1 | 2024-03-03 06:05:15.946 UTC [73] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:15.974 UTC [85] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:15.974 UTC [85] DETAIL: Failing row contains (2, 80000, -85953, zan corp ltda).
db-1 | 2024-03-03 06:05:15.974 UTC [85] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:16.379 UTC [87] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:16.379 UTC [87] DETAIL: Failing row contains (2, 80000, -80586, zan corp ltda).
db-1 | 2024-03-03 06:05:16.379 UTC [87] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:16.432 UTC [79] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:16.432 UTC [79] DETAIL: Failing row contains (1, 100000, -101248, o barato sai caro).
db-1 | 2024-03-03 06:05:16.432 UTC [79] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:16.486 UTC [89] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:16.486 UTC [89] DETAIL: Failing row contains (2, 80000, -85201, zan corp ltda).
db-1 | 2024-03-03 06:05:16.486 UTC [89] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:16.538 UTC [76] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:16.538 UTC [76] DETAIL: Failing row contains (2, 80000, -81584, zan corp ltda).
db-1 | 2024-03-03 06:05:16.538 UTC [76] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:16.908 UTC [88] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:16.908 UTC [88] DETAIL: Failing row contains (2, 80000, -80697, zan corp ltda).
db-1 | 2024-03-03 06:05:16.908 UTC [88] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )
db-1 | UPDATE client
db-1 | SET bal = bal - $5
db-1 | WHERE id = $6
db-1 | RETURNING bal, lim
db-1 |
db-1 | 2024-03-03 06:05:17.686 UTC [84] ERROR: new row for relation "client" violates check constraint "balance_limit"
db-1 | 2024-03-03 06:05:17.686 UTC [84] DETAIL: Failing row contains (1, 100000, -106902, o barato sai caro).
db-1 | 2024-03-03 06:05:17.686 UTC [84] STATEMENT: WITH inserted_transaction AS (
db-1 | INSERT INTO transaction (cid, amount, type, descr)
db-1 | VALUES ($1, $2, $3, $4)
db-1 | )