gentle-television-65093
10/21/2021, 8:18 PMgentle-furniture-19100
10/22/2021, 12:42 PMgentle-furniture-19100
10/22/2021, 12:42 PMshy-policeman-99334
10/22/2021, 5:54 PMmagnificent-dog-78206
10/23/2021, 11:40 PMThe files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
d-transformer_1 | Worker 71 started []
selecting default shared_buffers ... 128MB
selecting default timezone ... UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... sh: locale: not found
2021-10-23 23:19:23.928 UTC [31] WARNING: no usable system locales were found
ok
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start
WARNING: enabling "trust" authentication for local connections
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.
waiting for server to start....2021-10-23 23:19:24.683 UTC [37] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-10-23 23:19:24.745 UTC [38] LOG: database system was shut down at 2021-10-23 23:19:24 UTC
2021-10-23 23:19:24.754 UTC [37] LOG: database system is ready to accept connections
done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
waiting for server to shut down...2021-10-23 23:19:25.109 UTC [37] LOG: received fast shutdown request
.2021-10-23 23:19:25.113 UTC [37] LOG: aborting any active transactions
2021-10-23 23:19:25.114 UTC [37] LOG: background worker "logical replication launcher" (PID 44) exited with exit code 1
2021-10-23 23:19:25.114 UTC [39] LOG: shutting down
2021-10-23 23:19:25.137 UTC [37] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2021-10-23 23:19:25.217 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2021-10-23 23:19:25.217 UTC [1] LOG: listening on IPv6 address "::", port 5432
2021-10-23 23:19:25.223 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-10-23 23:19:25.238 UTC [51] LOG: database system was shut down at 2021-10-23 23:19:25 UTC
2021-10-23 23:19:25.243 UTC [1] LOG: database system is ready to accept connections
2021-10-23 23:19:25.790 UTC [58] LOG: incomplete startup packet
I can see anything logged into my table:
"config": {
"host": "localhost",
"database": "rudder-test",
"user": "manuel",
"password": "",
"port": "5432",
"namespace": "public",
"sslMode": "disable",
"syncFrequency": "30",
"useRudderStorage": false
},
Someone can tell me what im missing, it would me appreciated 🙂
Thanks in advance
Isaëlstrong-lawyer-50831
10/24/2021, 1:29 PMstrong-lawyer-50831
10/24/2021, 1:29 PMstrong-lawyer-50831
10/24/2021, 1:32 PMquick-engineer-78417
10/25/2021, 3:50 AMbored-alligator-84448
10/25/2021, 8:09 AMquick-engineer-78417
10/25/2021, 10:28 AMwide-tailor-71860
10/25/2021, 2:50 PMgorgeous-planet-70689
10/25/2021, 3:59 PMWORKSPACE_TOKEN
in the .env file to match the Token in the top of the app.rudderstack.com page. I’ve created the JS SDK source, used the write key to send events (which show up in the Live Events view).
I have a Postgres Destination setup as well, but the events never populate there (in s3 or pg, nor the live events view).
Looking in the syslog I see this:
Oct 25 15:49:20 ip-172-30-0-18 rudder[28503]: segment 2021/10/25 15:49:20 INFO: response 400 400 Bad Request – Invalid Write Key
Oct 25 15:49:23 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:23.620Z#011INFO#011StatsUpdate:AM: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
Oct 25 15:49:23 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:23.620Z#011INFO#011StatsUpdate:POSTGRES: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
Oct 25 15:49:24 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:24.587Z#011INFO#011Gateway Recv/Ack 934 934
Oct 25 15:49:28 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:28.621Z#011INFO#011StatsUpdate:AM: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
Oct 25 15:49:28 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:28.621Z#011INFO#011StatsUpdate:POSTGRES: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
Oct 25 15:49:30 ip-172-30-0-18 rudder[28503]: segment 2021/10/25 15:49:30 ERROR: 1 messages dropped because they failed to be sent after 10 attempts
Oct 25 15:49:32 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:32.697Z#011INFO#011ProcessorDBRead: Total: 930 Overall:184.083891, Instant(print):230.256644, Instant(call):346.296001
Oct 25 15:49:32 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:32.700Z#011INFO#011JS Call: Total: 249 Overall:439.672326, Instant(print):544.639171, Instant(call):544.639171
Oct 25 15:49:32 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:32.705Z#011INFO#011ProcessorJobs: Total: 930 Overall:461.518209, Instant(print):140.349006, Instant(call):140.349006
Oct 25 15:49:32 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:32.705Z#011INFO#011ProcessorDBWrite: Total: 930 Overall:741.951519, Instant(print):207.559569, Instant(call):207.559569
Oct 25 15:49:33 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:33.621Z#011INFO#011StatsUpdate:AM: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
Oct 25 15:49:33 ip-172-30-0-18 rudder[28503]: 2021-10-25T15:49:33.621Z#011INFO#011StatsUpdate:POSTGRES: Total: 0 Overall:0.000000, Instant(print):0.000000, Instant(call):0.000000
What is this “segment” area? which write key is it referring to??astonishing-gpu-91544
10/27/2021, 5:34 AMgifted-rain-29731
10/27/2021, 7:59 AMripe-traffic-97839
10/27/2021, 9:56 AMdazzling-actor-16535
10/27/2021, 11:36 AMbrave-flag-1315
10/27/2021, 11:38 AMdamp-oxygen-12307
10/27/2021, 2:30 PMdazzling-actor-16535
10/27/2021, 2:48 PMimportant-honey-21473
10/28/2021, 5:30 AMalert-restaurant-13560
10/28/2021, 8:08 AMhelm install rudderstack ./ --set backend.controlPlaneJSON=true --set rudderWorkspaceToken="MYTOKEN"
nice-fireman-66532
10/28/2021, 8:14 AMstocky-elephant-42978
10/28/2021, 8:33 AMclever-flower-16453
10/28/2021, 1:17 PMglamorous-laptop-18482
10/28/2021, 5:30 PMacceptable-belgium-84929
10/28/2021, 5:52 PMtall-gpu-60681
10/28/2021, 7:14 PMsquare-air-64774
10/29/2021, 7:47 AMgorgeous-actor-81555
10/29/2021, 10:34 AM