forked from zanfranceschi/rinha-de-backend-2024-q1
-
Notifications
You must be signed in to change notification settings - Fork 0
/
docker-compose.logs
166 lines (166 loc) · 17.4 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
Network rinha-2024q1 Creating
Network rinha-2024q1 Created
Container rinha_db Creating
Container rinha_db Created
Container rinha_api1 Creating
Container rinha_api2 Creating
Container rinha_api1 Created
Container rinha_api2 Created
Container rinha_nginx Creating
Container rinha_nginx Created
Attaching to rinha_api1, rinha_api2, rinha_db, rinha_nginx
rinha_db | The files belonging to this database system will be owned by user "postgres".
rinha_db | This user must also own the server process.
rinha_db |
rinha_db | The database cluster will be initialized with locale "en_US.utf8".
rinha_db | The default database encoding has accordingly been set to "UTF8".
rinha_db | The default text search configuration will be set to "english".
rinha_db |
rinha_db | Data page checksums are disabled.
rinha_db |
rinha_db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
rinha_db | creating subdirectories ... ok
rinha_db | selecting dynamic shared memory implementation ... posix
rinha_db | selecting default max_connections ... 100
rinha_db | selecting default shared_buffers ... 128MB
rinha_nginx | /docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
rinha_nginx | /docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
rinha_nginx | /docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
rinha_nginx | 10-listen-on-ipv6-by-default.sh: info: Getting the checksum of /etc/nginx/conf.d/default.conf
rinha_nginx | 10-listen-on-ipv6-by-default.sh: info: Enabled listen on IPv6 in /etc/nginx/conf.d/default.conf
rinha_nginx | /docker-entrypoint.sh: Sourcing /docker-entrypoint.d/15-local-resolvers.envsh
rinha_nginx | /docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
rinha_nginx | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
rinha_nginx | /docker-entrypoint.sh: Configuration complete; ready for start up
rinha_db | selecting default time zone ... Etc/UTC
rinha_db | creating configuration files ... ok
rinha_db | running bootstrap script ... ok
rinha_db | performing post-bootstrap initialization ... ok
rinha_api1 | Executando o Swoole
rinha_api1 | Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] connection to server at "rinha_db" (172.25.0.2), port 5432 failed: Connection refused
rinha_api1 | Is the server running on that host and accepting TCP/IP connections? in /app/src/ConnectionPool.php:26
rinha_api1 | Stack trace:
rinha_api1 | #0 /app/src/ConnectionPool.php(26): PDO->__construct('pgsql:dbname=ri...', 'root', Object(SensitiveParameterValue), Array)
rinha_api1 | #1 /app/src/Application.php(21): Rinha\ConnectionPool->__construct()
rinha_api1 | #2 /app/src/Application.php(33): Rinha\Application->__construct()
rinha_api1 | #3 /app/index.php(19): Rinha\Application::getInstance()
rinha_api1 | #4 [internal function]: {closure}(Object(Swoole\Http\Request), Object(Swoole\Http\Response))
rinha_api1 | #5 {main}
rinha_api1 | thrown in /app/src/ConnectionPool.php on line 26
rinha_api1 | [2024-02-26 20:40:54 *7.0] ERROR php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] connection to server at "rinha_db" (172.25.0.2), port 5432 failed: Connection refused
rinha_api1 | Is the server running on that host and accepting TCP/IP connections? in /app/src/ConnectionPool.php:26
rinha_api1 | Stack trace:
rinha_api1 | #0 /app/src/ConnectionPool.php(26): PDO->__construct('pgsql:dbname=ri...', 'root', Object(SensitiveParameterValue), Array)
rinha_api1 | #1 /app/src/Application.php(21): Rinha\ConnectionPool->__construct()
rinha_api1 | #2 /app/src/Application.php(33): Rinha\Application->__construct()
rinha_api1 | #3 /app/index.php(19): Rinha\Application::getInstance()
rinha_api1 | #4 [internal function]: {closure}(Object(Swoole\Http\Request), Object(Swoole\Http\Response))
rinha_api1 | #5 {main}
rinha_api1 | thrown in /app/src/ConnectionPool.php on line 26
rinha_nginx | 2024/02/26 20:40:54 [error] 31#31: *1 upstream prematurely closed connection while reading response header from upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.3:8000/clientes/1/extrato", host: "localhost:9999"
rinha_api2 | Executando o Swoole
rinha_api2 | Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] connection to server at "rinha_db" (172.25.0.2), port 5432 failed: Connection refused
rinha_api2 | Is the server running on that host and accepting TCP/IP connections? in /app/src/ConnectionPool.php:26
rinha_api2 | Stack trace:
rinha_api2 | #0 /app/src/ConnectionPool.php(26): PDO->__construct('pgsql:dbname=ri...', 'root', Object(SensitiveParameterValue), Array)
rinha_api2 | #1 /app/src/Application.php(21): Rinha\ConnectionPool->__construct()
rinha_api2 | #2 /app/src/Application.php(33): Rinha\Application->__construct()
rinha_api2 | #3 /app/index.php(19): Rinha\Application::getInstance()
rinha_api2 | #4 [internal function]: {closure}(Object(Swoole\Http\Request), Object(Swoole\Http\Response))
rinha_api2 | #5 {main}
rinha_api2 | thrown in /app/src/ConnectionPool.php on line 26
rinha_api2 | [2024-02-26 20:40:54 *7.0] ERROR php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] connection to server at "rinha_db" (172.25.0.2), port 5432 failed: Connection refused
rinha_api2 | Is the server running on that host and accepting TCP/IP connections? in /app/src/ConnectionPool.php:26
rinha_api2 | Stack trace:
rinha_api2 | #0 /app/src/ConnectionPool.php(26): PDO->__construct('pgsql:dbname=ri...', 'root', Object(SensitiveParameterValue), Array)
rinha_api2 | #1 /app/src/Application.php(21): Rinha\ConnectionPool->__construct()
rinha_api2 | #2 /app/src/Application.php(33): Rinha\Application->__construct()
rinha_api2 | #3 /app/index.php(19): Rinha\Application::getInstance()
rinha_api2 | #4 [internal function]: {closure}(Object(Swoole\Http\Request), Object(Swoole\Http\Response))
rinha_api2 | #5 {main}
rinha_api2 | thrown in /app/src/ConnectionPool.php on line 26
rinha_nginx | 2024/02/26 20:40:54 [error] 31#31: *1 upstream prematurely closed connection while reading response header from upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_db | initdb: warning: enabling "trust" authentication for local connections
rinha_db | 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.
rinha_db | syncing data to disk ... ok
rinha_db |
rinha_db |
rinha_db | Success. You can now start the database server using:
rinha_db |
rinha_db | pg_ctl -D /var/lib/postgresql/data -l logfile start
rinha_db |
rinha_db | waiting for server to start....2024-02-26 20:40:54.914 GMT [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
rinha_db | 2024-02-26 20:40:54.919 GMT [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
rinha_api1 exited with code 255
rinha_db | 2024-02-26 20:40:54.935 GMT [51] LOG: database system was shut down at 2024-02-26 20:40:53 GMT
rinha_db | 2024-02-26 20:40:54.947 GMT [48] LOG: database system is ready to accept connections
rinha_db | done
rinha_db | server started
rinha_api2 exited with code 255
rinha_db | CREATE DATABASE
rinha_db |
rinha_db |
rinha_db | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/ddl.sql
rinha_db | CREATE TABLE
rinha_db | CREATE TABLE
rinha_db |
rinha_db |
rinha_db | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/dml.sql
rinha_db | INSERT 0 5
rinha_nginx | 2024/02/26 20:40:56 [error] 31#31: *4 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_db |
rinha_db |
rinha_db | waiting for server to shut down...2024-02-26 20:40:56.121 GMT [48] LOG: received fast shutdown request
rinha_db | .2024-02-26 20:40:56.124 GMT [48] LOG: aborting any active transactions
rinha_db | 2024-02-26 20:40:56.125 GMT [48] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
rinha_db | 2024-02-26 20:40:56.215 GMT [49] LOG: shutting down
rinha_db | 2024-02-26 20:40:56.218 GMT [49] LOG: checkpoint starting: shutdown immediate
rinha_db | 2024-02-26 20:40:56.697 GMT [49] LOG: checkpoint complete: wrote 939 buffers (5.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.378 s, sync=0.092 s, total=0.483 s; sync files=307, longest=0.068 s, average=0.001 s; distance=4300 kB, estimate=4300 kB; lsn=0/191DD08, redo lsn=0/191DD08
rinha_db | 2024-02-26 20:40:56.702 GMT [48] LOG: database system is shut down
rinha_db | done
rinha_db | server stopped
rinha_db |
rinha_db | PostgreSQL init process complete; ready for start up.
rinha_db |
rinha_db | 2024-02-26 20:40:56.744 GMT [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
rinha_db | 2024-02-26 20:40:56.744 GMT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
rinha_db | 2024-02-26 20:40:56.744 GMT [1] LOG: listening on IPv6 address "::", port 5432
rinha_db | 2024-02-26 20:40:56.821 GMT [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
rinha_db | 2024-02-26 20:40:56.829 GMT [68] LOG: database system was shut down at 2024-02-26 20:40:56 GMT
rinha_db | 2024-02-26 20:40:56.836 GMT [1] LOG: database system is ready to accept connections
rinha_nginx | 2024/02/26 20:40:58 [error] 31#31: *5 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:41:00 [error] 31#31: *6 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:41:02 [error] 31#31: *7 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:41:04 [error] 31#31: *8 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:06 [error] 31#31: *9 upstream timed out (110: Operation timed out) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:24 [error] 31#31: *9 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.3:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:29 [error] 31#31: *12 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:29 [error] 31#31: *12 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:31 [error] 31#31: *14 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:33 [error] 31#31: *15 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:38 [error] 31#31: *16 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.3:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:38 [error] 31#31: *16 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:43 [error] 31#31: *18 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:43 [error] 31#31: *18 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:45 [error] 31#31: *20 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:47 [error] 31#31: *21 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:53 [error] 31#31: *22 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.3:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:53 [error] 31#31: *22 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:58 [error] 31#31: *24 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:42:58 [error] 31#31: *24 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:00 [error] 31#31: *26 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:02 [error] 31#31: *27 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:07 [error] 31#31: *28 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.3:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:07 [error] 31#31: *28 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:12 [error] 31#31: *30 connect() failed (113: Host is unreachable) while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://172.25.0.4:8000/clientes/1/extrato", host: "localhost:9999"
rinha_nginx | 2024/02/26 20:43:12 [error] 31#31: *30 no live upstreams while connecting to upstream, client: 172.25.0.1, server: , request: "GET /clientes/1/extrato HTTP/1.1", upstream: "http://backend/clientes/1/extrato", host: "localhost:9999"
rinha_nginx exited with code 0
rinha_nginx exited with code 0
rinha_db | 2024-02-26 20:43:14.983 GMT [1] LOG: received fast shutdown request
rinha_db | 2024-02-26 20:43:14.987 GMT [1] LOG: aborting any active transactions
rinha_db | 2024-02-26 20:43:14.989 GMT [1] LOG: background worker "logical replication launcher" (PID 71) exited with exit code 1
rinha_db | 2024-02-26 20:43:14.989 GMT [66] LOG: shutting down
rinha_db | 2024-02-26 20:43:14.992 GMT [66] LOG: checkpoint starting: shutdown immediate
rinha_db | 2024-02-26 20:43:15.031 GMT [66] LOG: checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.020 s, total=0.042 s; sync files=12, longest=0.007 s, average=0.002 s; distance=132 kB, estimate=132 kB; lsn=0/193EEB8, redo lsn=0/193EEB8
rinha_db | 2024-02-26 20:43:15.035 GMT [1] LOG: database system is shut down
rinha_db exited with code 0