sipcapture / heplify-server

HEP Capture Server for HOMER
https://sipcapture.org
GNU Affero General Public License v3.0
184 stars 85 forks source link

Heplify-server não apresenta os dados #533

Closed izaacmenezes closed 1 year ago

izaacmenezes commented 1 year ago

Boa noite, tudo bem? Estimo que sim;

Estou com uma dificuldade na implantação do hom7-prom-all, os recursos subiram corretamente, entretanto, não está populando os dados no homer-app, ao verificar o log do heplify com docker logs heplify-server, obtenho o erro abaixo, poderiam dar um apoio por gentileza?

Obs: vi em outros problemas que poderia resolver com docker-compose pull && docker-compose up, entretanto, não obtive sucesso

2023/08/28 22:40:00.396894 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396909 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396925 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396940 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396955 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396971 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.396986 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397002 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397017 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397034 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397054 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397076 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397097 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397115 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_call" found for row 2023/08/28 22:40:00.397130 postgres.go:276: ERR pq: no partition of relation "hep_proto_1_ca^C

rita7lopes commented 1 year ago

Olá Izaac, Espero que esteja tudo bem contigo.

Sobre o teu problema, o log indica poderá ter havido uma falha de ligação entre o heplify-server e tudo o resto, gerando o log que vês, indicando a falta da partição "hep_proto_1_call". Para forçar a ligação corretamente, podes fazer um restart do heplify-server?

Obrigada, Rita

izaacmenezes commented 1 year ago

Bom dia, obrigado pelo retorno, eu já havia testado o restart, mas sem sucesso, entretanto testei novamente, segue as evidencias abaixo:

image

Consulta de logs atualizada:

image

lmangani commented 1 year ago

Check out the postgres logs as the issue is most likely originating there.

docker-compose logs --follow db

Make sure you have the correct permissions for writing into folders.

izaacmenezes commented 1 year ago

Segue os dados do DB abaixo:

Observação: Substitui meus IP internos para "gatewaydeenvio";

Attaching to db db | The files belonging to this database system will be owned by user "postgres". db | This user must also own the server process. db | db | The database cluster will be initialized with locale "en_US.utf8". db | The default database encoding has accordingly been set to "UTF8". db | The default text search configuration will be set to "english". db | db | Data page checksums are disabled. db | db | fixing permissions on existing directory /var/lib/postgresql/data ... ok db | creating subdirectories ... ok db | selecting default max_connections ... 100 db | selecting default shared_buffers ... 128MB db | selecting default timezone ... UTC db | selecting dynamic shared memory implementation ... posix db | creating configuration files ... ok db | running bootstrap script ... ok db | sh: locale: not found db | 2023-08-28 20:07:18.000 UTC [31] WARNING: no usable system locales were found db | performing post-bootstrap initialization ... ok db | syncing data to disk ... ok db | db | Success. You can now start the database server using: db | db | pg_ctl -D /var/lib/postgresql/data -l logfile start db | db | db | WARNING: enabling "trust" authentication for local connections db | You can change this by editing pg_hba.conf or using the option -A, or db | --auth-local and --auth-host, the next time you run initdb. db | waiting for server to start....2023-08-28 20:07:19.838 UTC [54] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db | 2023-08-28 20:07:19.859 UTC [55] LOG: database system was shut down at 2023-08-28 20:07:18 UTC db | 2023-08-28 20:07:19.866 UTC [54] LOG: database system is ready to accept connections db | done db | server started db | CREATE DATABASE db | db | db | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-user-db.sh db | CREATE DATABASE db | db | waiting for server to shut down....2023-08-28 20:07:21.297 UTC [54] LOG: received fast shutdown request db | 2023-08-28 20:07:21.298 UTC [54] LOG: aborting any active transactions db | 2023-08-28 20:07:21.300 UTC [54] LOG: background worker "logical replication launcher" (PID 61) exited with exit code 1 db | 2023-08-28 20:07:21.300 UTC [56] LOG: shutting down db | 2023-08-28 20:07:21.354 UTC [54] LOG: database system is shut down db | done db | server stopped db | db | PostgreSQL init process complete; ready for start up. db | db | 2023-08-28 20:07:21.419 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 db | 2023-08-28 20:07:21.419 UTC [1] LOG: listening on IPv6 address "::", port 5432 db | 2023-08-28 20:07:21.429 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db | 2023-08-28 20:07:21.469 UTC [77] LOG: database system was shut down at 2023-08-28 20:07:21 UTC db | 2023-08-28 20:07:21.480 UTC [1] LOG: database system is ready to accept connections db | 2023-08-28 20:07:28.254 UTC [128] ERROR: database "homer_config" already exists db | 2023-08-28 20:07:28.254 UTC [128] STATEMENT: CREATE DATABASE homer_config OWNER root db | 2023-08-28 20:07:28.702 UTC [138] ERROR: database "homer_data" already exists db | 2023-08-28 20:07:28.702 UTC [138] STATEMENT: CREATE DATABASE homer_data db | 2023-08-28 20:07:28.705 UTC [138] ERROR: role "postgres" does not exist db | 2023-08-28 20:07:28.705 UTC [138] STATEMENT: GRANT postgres to homer_user; db | 2023-08-28 20:07:42.823 UTC [238] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.823 UTC [238] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:42.95853+00). db | 2023-08-28 20:07:42.823 UTC [238] CONTEXT: COPY hep_proto_1_call, line 1: "Fx1rl5JVWnD8dFqa@"gatewaydeenvio" 2023-07-09T17:27:42.95853Z {"protocolFamily":2,"protocol":17,"srcIp"..." db | 2023-08-28 20:07:42.823 UTC [238] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.832 UTC [240] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.832 UTC [240] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:42.952697+00). db | 2023-08-28 20:07:42.832 UTC [240] CONTEXT: COPY hep_proto_1_call, line 1: "F1gFaheqZdgq3-49@"gatewaydeenvio" 2023-07-09T17:27:42.952697Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-28 20:07:42.832 UTC [240] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.835 UTC [241] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.835 UTC [241] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:43.684038+00). db | 2023-08-28 20:07:42.835 UTC [241] CONTEXT: COPY hep_proto_1_call, line 1: "funAKdUVyMK9eexJ@"gatewaydeenvio" 2023-07-09T17:27:43.684038Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-28 20:07:42.835 UTC [241] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.837 UTC [239] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.837 UTC [239] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:43.586216+00). db | 2023-08-28 20:07:42.837 UTC [239] CONTEXT: COPY hep_proto_1_call, line 1: "3-rbAWWa7NyD-8-u@"gatewaydeenvio" 2023-07-09T17:27:43.586216Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-28 20:07:42.837 UTC [239] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.849 UTC [242] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.849 UTC [242] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:42.962864+00). db | 2023-08-28 20:07:42.849 UTC [242] CONTEXT: COPY hep_proto_1_call, line 1: "43053b97668a1e51591dfc103be9405f@"gatewaydeenvio" 2023-07-09T17:27:42.962864Z {"protocolFamily":2..." db | 2023-08-28 20:07:42.849 UTC [242] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.852 UTC [239] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.852 UTC [239] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:50.154325+00). db | 2023-08-28 20:07:42.852 UTC [239] CONTEXT: COPY hep_proto_1_call, line 1: "23d9ae500688f6101e05daa15cc12c69@"gatewaydeenvio" 2023-07-09T17:27:50.154325Z {"protocolFamily":2..." db | 2023-08-28 20:07:42.852 UTC [239] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-28 20:07:42.853 UTC [241] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-28 20:07:42.853 UTC [241] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:50.801981+00). db | 2023-08-28 20:07:42.853 UTC [241] CONTEXT: COPY hep_proto_1_call, line 1: "0e48426e11322f35078779cf1b3cf1c4@"gatewaydeenvio" 2023-07-09T17:27:50.801981Z {"protocolFamily":2..."

rita7lopes commented 1 year ago

Olá Izaac,

Os logs aparecem como num sistema funcional. Qual o sistema operativo em que está a correr o docker container? Podes por favor correr o comando abaixo e partilhar o output? ls -lh /docker/homer7-docker-master/heplify-server/hom7-prom-all Para além disso, personalizaste algo no ficheiro docker-compose para o teu sistema?

izaacmenezes commented 1 year ago

Segue a saida do comando abaixo:

image

Não fiz personalizações até o momento

rita7lopes commented 1 year ago

Obrigada. Tudo aparenta estar como o esperado. Algo correu mal provavelmente logo ao inicio pelo que o melhor será fazer um drop geral e tentar de novo. Para isso:

docker-compose down -v
docker-compose up -d
izaacmenezes commented 1 year ago

Saida dos comandos:

image

Log do heplify após:

image

izaacmenezes commented 1 year ago

Executei também o docker ps para caso ajude e tive o retorno abaixo:

image

lmangani commented 1 year ago

docker-compose restart heplify-server

docker-compose logs heplify-server

izaacmenezes commented 1 year ago

erro.txt

Segue a saida do comando, anexei num txt porque ficou um pouco extenso

kYroL01 commented 1 year ago

I still see the same error

heplify-server    | 2023/08/30 14:49:37.162074 postgres.go:283: ERR pq: no partition of relation "hep_proto_1_call" found for row
rita7lopes commented 1 year ago

Izaac, podes por favor enviar o log completo do container potgres:11-alpine? Talvez aconteça algo de errado logo ao início que não estamos a conseguir ver. Para isso copia o container-ID e usa o comando abaixo: /var/lib/docker/containers/<container ID>/<container ID>-json.log

izaacmenezes commented 1 year ago

Segue a o documento gerado abaixo @rita7lopes:

Observação: mascarei meus IP internos para "ipgateway"

errolog.txt

bilalrao12 commented 1 year ago

STEP1:

  1. go in db container: docker exec -it db bash
  2. connect to postgres: psql
  3. switch database: \c homer_data
  4. check if partions are in correct time range: \d+ hep_proto_1_call

If not in range then it will throw this error and will not work.

STEP2: To resolve:

Check if your system time is correct, If not then:

  1. first correct the server time
  2. docker-compose down -v
  3. rm -rf postgres-data (remove this before creating new container)
  4. docker-compose up -d
  5. ingest data and check again

Please try this and share your feedback.

izaacmenezes commented 1 year ago

Olá, segue a saida dos passos enviados:

Step 1:

Step 1

Step 2:

Step 2

Após isso, verifiquei os logs do heplify novamente e recebo ainda o erro abaixo:

image

Observação: os dados continuam não subindo para o homer-app

bilalrao12 commented 1 year ago

Please share complete heplify-server logs and full output of below command (execute on postgres cli) \d+ hep_proto_1_call

izaacmenezes commented 1 year ago

Saida do hep_proto_1_call:

image

Log heplify-server:

Observação: dei uma encurtada no log pela recorrencia da mesma linha

erro.txt

bilalrao12 commented 1 year ago

Please also share latest logs for db(postgres) container as well. Earlier I saw you were getting below error in db logs

239] ERROR: no partition of relation "hep_proto_1_call" found for row �[36mdb |�[0m 2023-08-28 20:07:42.852 UTC [239] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-09 17:27:50.154325+00). �[36mdb |�[0m 2023-08-28 20:07:42.852 UTC [239] CONTEXT: COPY hep_proto_1_call, line 1: "23d9ae500688f6101e05daa15cc12c69@"gatewaydeenvio" 2023-07-09T17:27:50.154325Z {"protocolFamily":2..."

izaacmenezes commented 1 year ago

Segue os dados do DB abaixo:

Observação: Substitui meus IP internos para "ipgateway";

root@HOMERSIP:/docker/homer7-docker-master/heplify-server/hom7-prom-all# docker-compose logs --follow db Attaching to db db | The files belonging to this database system will be owned by user "postgres". db | This user must also own the server process. db | db | The database cluster will be initialized with locale "en_US.utf8". db | The default database encoding has accordingly been set to "UTF8". db | The default text search configuration will be set to "english". db | db | Data page checksums are disabled. db | db | fixing permissions on existing directory /var/lib/postgresql/data ... ok db | creating subdirectories ... ok db | selecting default max_connections ... 100 db | selecting default shared_buffers ... 128MB db | selecting default timezone ... UTC db | selecting dynamic shared memory implementation ... posix db | creating configuration files ... ok db | running bootstrap script ... ok db | sh: locale: not found db | 2023-08-31 20:06:59.890 UTC [31] WARNING: no usable system locales were found db | performing post-bootstrap initialization ... ok db | db | WARNING: enabling "trust" authentication for local connections db | You can change this by editing pg_hba.conf or using the option -A, or db | --auth-local and --auth-host, the next time you run initdb. db | syncing data to disk ... ok db | db | Success. You can now start the database server using: db | db | pg_ctl -D /var/lib/postgresql/data -l logfile start db | db | waiting for server to start....2023-08-31 20:07:01.470 UTC [51] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db | 2023-08-31 20:07:01.496 UTC [52] LOG: database system was shut down at 2023-08-31 20:07:00 UTC db | 2023-08-31 20:07:01.504 UTC [51] LOG: database system is ready to accept connections db | done db | server started db | CREATE DATABASE db | db | db | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-user-db.sh db | CREATE DATABASE db | db | waiting for server to shut down....2023-08-31 20:07:02.535 UTC [51] LOG: received fast shutdown request db | 2023-08-31 20:07:02.536 UTC [51] LOG: aborting any active transactions db | 2023-08-31 20:07:02.537 UTC [51] LOG: background worker "logical replication launcher" (PID 58) exited with exit code 1 db | 2023-08-31 20:07:02.537 UTC [53] LOG: shutting down db | 2023-08-31 20:07:02.551 UTC [51] LOG: database system is shut down db | done db | server stopped db | db | PostgreSQL init process complete; ready for start up. db | db | 2023-08-31 20:07:02.655 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 db | 2023-08-31 20:07:02.655 UTC [1] LOG: listening on IPv6 address "::", port 5432 db | 2023-08-31 20:07:02.664 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db | 2023-08-31 20:07:02.685 UTC [74] LOG: database system was shut down at 2023-08-31 20:07:02 UTC db | 2023-08-31 20:07:02.693 UTC [1] LOG: database system is ready to accept connections db | 2023-08-31 20:07:07.813 UTC [110] ERROR: database "homer_config" already exists db | 2023-08-31 20:07:07.813 UTC [110] STATEMENT: CREATE DATABASE homer_config OWNER root db | 2023-08-31 20:07:10.811 UTC [138] ERROR: database "homer_data" already exists db | 2023-08-31 20:07:10.811 UTC [138] STATEMENT: CREATE DATABASE homer_data db | 2023-08-31 20:07:10.812 UTC [138] ERROR: role "postgres" does not exist db | 2023-08-31 20:07:10.812 UTC [138] STATEMENT: GRANT postgres to homer_user; db | 2023-08-31 20:07:21.951 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.951 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:24.429582+00). db | 2023-08-31 20:07:21.951 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "64e58af561828d7c126585005a27ff1d@ipgateway:5060 2023-07-12T17:27:24.429582Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.951 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.958 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.958 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:24.493357+00). db | 2023-08-31 20:07:21.958 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "115199571fd0ca284525649d23ee8d33@ipgateway:5060 2023-07-12T17:27:24.493357Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.958 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.958 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.958 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:27.295314+00). db | 2023-08-31 20:07:21.958 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "1841961133d8d06869b661a31aeb62fa@ipgateway:5060 2023-07-12T17:27:27.295314Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.958 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.960 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.960 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:28.01009+00). db | 2023-08-31 20:07:21.960 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "26da1e1b60a843aa6cb1d5a15bf335df@ipgateway:5060 2023-07-12T17:27:28.01009Z {"protocolFamily":2,..." db | 2023-08-31 20:07:21.960 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.961 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.961 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:28.293001+00). db | 2023-08-31 20:07:21.961 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "1061c1cc0bdad3550d60d00b430fa218@ipgateway:5060 2023-07-12T17:27:28.293001Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.961 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.965 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.965 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:31.64083+00). db | 2023-08-31 20:07:21.965 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "noDr:IHO5N:8eFkH@ipgateway 2023-07-12T17:27:31.64083Z {"protocolFamily":2,"protocol":17,"srcIp"..." db | 2023-08-31 20:07:21.965 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.966 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.966 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:33.013728+00). db | 2023-08-31 20:07:21.966 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "qhluJDXNbOr2bc48@ipgateway 2023-07-12T17:27:33.013728Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:21.966 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.966 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.966 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:33.525576+00). db | 2023-08-31 20:07:21.966 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "PZYjkepwcEO:CgW7@ipgateway 2023-07-12T17:27:33.525576Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:21.966 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.968 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.968 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:35.870203+00). db | 2023-08-31 20:07:21.968 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "ZNyHtv8xbzic5sKy@ipgateway 2023-07-12T17:27:35.870203Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:21.968 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.972 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.972 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:38.24418+00). db | 2023-08-31 20:07:21.972 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "1RPUJh2lDHYT0vPm@ipgateway 2023-07-12T17:27:38.24418Z {"protocolFamily":2,"protocol":17,"srcIp"..." db | 2023-08-31 20:07:21.972 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.974 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.974 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:38.020928+00). db | 2023-08-31 20:07:21.974 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "05b4bfb76abeee1463b578d11f116bd8@ipgateway:5060 2023-07-12T17:27:38.020928Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.974 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.974 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.974 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:37.259894+00). db | 2023-08-31 20:07:21.974 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "83dLlReSFjmueqK2@ipgateway 2023-07-12T17:27:37.259894Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:21.974 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:21.980 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:21.980 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:42.535591+00). db | 2023-08-31 20:07:21.980 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "721f036f519347dc0495262e0750f64e@ipgateway:5060 2023-07-12T17:27:42.535591Z {"protocolFamily":2..." db | 2023-08-31 20:07:21.980 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:22.037 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:22.037 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:40.924097+00). db | 2023-08-31 20:07:22.037 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "OGZ4upwME6aa-43V@ipgateway 2023-07-12T17:27:40.924097Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:22.037 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:24.548 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:24.548 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:44.123749+00). db | 2023-08-31 20:07:24.548 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "07cb7baa61ff170c09a57b0e6b1c1aa2@ipgateway:5060 2023-07-12T17:27:44.123749Z {"protocolFamily":2..." db | 2023-08-31 20:07:24.548 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.948 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.948 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:46.577132+00). db | 2023-08-31 20:07:25.948 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "Ib-mrwPS8jLV4Wen@ipgateway 2023-07-12T17:27:46.577132Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:25.948 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.948 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.948 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:43.778989+00). db | 2023-08-31 20:07:25.948 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "49fb896a17afdbbc462680fc4c8ba91c@ipgateway:5060 2023-07-12T17:27:43.778989Z {"protocolFamily":2..." db | 2023-08-31 20:07:25.948 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.949 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.949 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:46.555701+00). db | 2023-08-31 20:07:25.949 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "6vtrWg80qBcQGDjP@ipgateway 2023-07-12T17:27:46.555701Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:25.949 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.949 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.949 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:44.679901+00). db | 2023-08-31 20:07:25.949 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "MdM3LDBjvZcuypsp@ipgateway 2023-07-12T17:27:44.679901Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:25.949 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.950 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.950 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:46.622061+00). db | 2023-08-31 20:07:25.950 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "136c407a4bb0910c649561d444d23067@ipgateway:5060 2023-07-12T17:27:46.622061Z {"protocolFamily":2..." db | 2023-08-31 20:07:25.950 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.951 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:25.951 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:49.122583+00). db | 2023-08-31 20:07:25.951 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "4c5f7e8d5ee1b3e4181847b561a057f9@ipgateway:5060 2023-07-12T17:27:49.122583Z {"protocolFamily":2..." db | 2023-08-31 20:07:25.951 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.952 UTC [217] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:25.952 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:34.550546+00). db | 2023-08-31 20:07:25.952 UTC [217] CONTEXT: COPY hep_proto_1_default, line 1: "6766c6be3a3c59c31fb69a6048b14c02@ipgateway:5060 2023-07-12T17:27:34.550546Z {"protocolFamily":2,"p..." db | 2023-08-31 20:07:25.952 UTC [217] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:25.952 UTC [216] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:25.952 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:33.578616+00). db | 2023-08-31 20:07:25.952 UTC [216] CONTEXT: COPY hep_proto_1_default, line 1: "3f5166b904117ca3100b15a3181b9bc5@ipgateway:5060 2023-07-12T17:27:33.578616Z {"protocolFamily":2,"p..." db | 2023-08-31 20:07:25.952 UTC [216] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.948 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.948 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.52491+00). db | 2023-08-31 20:07:29.948 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "75e4d427776cf25f0756efa30aff120c@ipgateway:5060 2023-07-12T17:27:50.52491Z {"protocolFamily":2,..." db | 2023-08-31 20:07:29.948 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.948 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.948 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.551295+00). db | 2023-08-31 20:07:29.948 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "3abf3897537da5aa1a3237992228254d@ipgateway:5060 2023-07-12T17:27:50.551295Z {"protocolFamily":2..." db | 2023-08-31 20:07:29.948 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.950 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.950 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.521789+00). db | 2023-08-31 20:07:29.950 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "0790aa916bf986ef6ed8355537835217@ipgateway:5060 2023-07-12T17:27:50.521789Z {"protocolFamily":2..." db | 2023-08-31 20:07:29.950 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.951 UTC [217] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:29.951 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:52.320612+00). db | 2023-08-31 20:07:29.951 UTC [217] CONTEXT: COPY hep_proto_1_default, line 1: "3f91f75c4e63f7e62a477d841e286e7b@ipgateway:5060 2023-07-12T17:27:52.320612Z {"protocolFamily":2..." db | 2023-08-31 20:07:29.951 UTC [217] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.951 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.951 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.527064+00). db | 2023-08-31 20:07:29.951 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "70ecece56e5345f909824397620b861a@ipgateway:5060 2023-07-12T17:27:50.527064Z {"protocolFamily":2..." db | 2023-08-31 20:07:29.951 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.952 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.952 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.551908+00). db | 2023-08-31 20:07:29.952 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "MX8WBxAO9hsf9GNP@ipgateway 2023-07-12T17:27:50.551908Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:29.952 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.954 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:29.954 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:50.550871+00). db | 2023-08-31 20:07:29.954 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "RoVt8SN7uibr69FN@ipgateway 2023-07-12T17:27:50.550871Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:29.954 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.954 UTC [219] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:29.954 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:52.321505+00). db | 2023-08-31 20:07:29.954 UTC [219] CONTEXT: COPY hep_proto_1_default, line 1: "3f91f75c4e63f7e62a477d841e286e7b@ipgateway:5060 2023-07-12T17:27:52.321505Z {"protocolFamily":2..." db | 2023-08-31 20:07:29.954 UTC [219] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:29.955 UTC [214] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:29.955 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:53.419939+00). db | 2023-08-31 20:07:29.955 UTC [214] CONTEXT: COPY hep_proto_1_default, line 1: "1697a5a92664b4230d6d256c789167b9@ipgateway:5060 2023-07-12T17:27:53.419939Z {"protocolFamily":2,"p..." db | 2023-08-31 20:07:29.955 UTC [214] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.949 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.949 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.518546+00). db | 2023-08-31 20:07:33.949 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "6debbc7366e47c6557180ea6778f6e94@ipgateway:5060 2023-07-12T17:27:54.518546Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.949 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.949 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.949 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.516826+00). db | 2023-08-31 20:07:33.949 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "63236f511cc5a7f22d253a3b4f53a8f6@ipgateway:5060 2023-07-12T17:27:54.516826Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.949 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.950 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.950 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.517361+00). db | 2023-08-31 20:07:33.950 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "6cce457752d0d6b150f851bf075e68aa@ipgateway:5060 2023-07-12T17:27:54.517361Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.950 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.950 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.950 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.538328+00). db | 2023-08-31 20:07:33.950 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "1899f42220fc8dd34df66b1e024f2173@ipgateway:5060 2023-07-12T17:27:54.538328Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.950 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.951 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.951 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.528449+00). db | 2023-08-31 20:07:33.951 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "49053d944653b8901fdd460f4a816268@ipgateway:5060 2023-07-12T17:27:54.528449Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.951 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.952 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:33.952 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.537402+00). db | 2023-08-31 20:07:33.952 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "U-UnuECah-wbltvB@ipgateway 2023-07-12T17:27:54.537402Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:33.952 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.953 UTC [217] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:33.953 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:57.370311+00). db | 2023-08-31 20:07:33.953 UTC [217] CONTEXT: COPY hep_proto_1_default, line 1: "2de7bdeb08e42e5138ae76ed4603d3e3@ipgateway:5060 2023-07-12T17:27:57.370311Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.953 UTC [217] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.953 UTC [214] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:33.953 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.993043+00). db | 2023-08-31 20:07:33.953 UTC [214] CONTEXT: COPY hep_proto_1_default, line 1: "1a4d461e711da8ea148c49315b619587@ipgateway:5060 2023-07-12T17:27:54.993043Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.953 UTC [214] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:33.954 UTC [219] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:07:33.954 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:54.993483+00). db | 2023-08-31 20:07:33.954 UTC [219] CONTEXT: COPY hep_proto_1_default, line 1: "1a4d461e711da8ea148c49315b619587@ipgateway:5060 2023-07-12T17:27:54.993483Z {"protocolFamily":2..." db | 2023-08-31 20:07:33.954 UTC [219] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.950 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.950 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.526153+00). db | 2023-08-31 20:07:37.950 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "kwF3SEv4Lfd5Q2:j@ipgateway 2023-07-12T17:27:58.526153Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:37.950 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.950 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.950 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.525344+00). db | 2023-08-31 20:07:37.950 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "738278a87818a5de6638ad7b171b1839@ipgateway:5060 2023-07-12T17:27:58.525344Z {"protocolFamily":2..." db | 2023-08-31 20:07:37.950 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.951 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.951 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.526248+00). db | 2023-08-31 20:07:37.951 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "mJYw1TdCqLyHVvfX@ipgateway 2023-07-12T17:27:58.526248Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:37.951 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.951 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.951 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.521695+00). db | 2023-08-31 20:07:37.951 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "431565d4733a665944d651040de7e59f@ipgateway:5060 2023-07-12T17:27:58.521695Z {"protocolFamily":2..." db | 2023-08-31 20:07:37.951 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.952 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.952 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.526015+00). db | 2023-08-31 20:07:37.952 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "Lcern6rV2Z7KkogS@ipgateway 2023-07-12T17:27:58.526015Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:37.952 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:37.952 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:37.952 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:27:58.519451+00). db | 2023-08-31 20:07:37.952 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "72c4ad37526bfa4d49fa64a542b25403@ipgateway:5060 2023-07-12T17:27:58.519451Z {"protocolFamily":2..." db | 2023-08-31 20:07:37.952 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.951 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.951 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.515579+00). db | 2023-08-31 20:07:41.951 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "20c52ff95a88980f184f66f94c5a41d1@ipgateway:5060 2023-07-12T17:28:02.515579Z {"protocolFamily":2..." db | 2023-08-31 20:07:41.951 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.951 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.951 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.51575+00). db | 2023-08-31 20:07:41.951 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "20c52ff95a88980f184f66f94c5a41d1@ipgateway:5060 2023-07-12T17:28:02.51575Z {"protocolFamily":2,..." db | 2023-08-31 20:07:41.951 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.951 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.951 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.529253+00). db | 2023-08-31 20:07:41.951 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "76bec25547e815d41fc7ce8a1ecd9569@ipgateway:5060 2023-07-12T17:28:02.529253Z {"protocolFamily":2..." db | 2023-08-31 20:07:41.951 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.952 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.952 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.515919+00). db | 2023-08-31 20:07:41.952 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "20c52ff95a88980f184f66f94c5a41d1@ipgateway:5060 2023-07-12T17:28:02.515919Z {"protocolFamily":2..." db | 2023-08-31 20:07:41.952 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.952 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.952 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.530287+00). db | 2023-08-31 20:07:41.952 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "3d1803760e5e4bd5142455351f3554df@ipgateway:5060 2023-07-12T17:28:02.530287Z {"protocolFamily":2..." db | 2023-08-31 20:07:41.952 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:41.953 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:41.953 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:02.530117+00). db | 2023-08-31 20:07:41.953 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "UhC0lzttkJUGLlkn@ipgateway 2023-07-12T17:28:02.530117Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:41.953 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.951 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.951 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.529265+00). db | 2023-08-31 20:07:45.951 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "2bMicfM-G:kiV1js@ipgateway 2023-07-12T17:28:06.529265Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:45.951 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.952 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.952 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.528837+00). db | 2023-08-31 20:07:45.952 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "jwNqccfk9yl2D-ip@ipgateway 2023-07-12T17:28:06.528837Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:45.952 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.952 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.952 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.529708+00). db | 2023-08-31 20:07:45.952 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "5c2927bc7c82f5191f01f5b7084f3aac@ipgateway:5060 2023-07-12T17:28:06.529708Z {"protocolFamily":2..." db | 2023-08-31 20:07:45.952 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.953 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.953 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.529484+00). db | 2023-08-31 20:07:45.953 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "267edca907641752174fee723889430b@ipgateway:5060 2023-07-12T17:28:06.529484Z {"protocolFamily":2..." db | 2023-08-31 20:07:45.953 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.953 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.953 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.529073+00). db | 2023-08-31 20:07:45.953 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "i5DRDNJgZ9RL1kL8@ipgateway 2023-07-12T17:28:06.529073Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:45.953 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:45.954 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:45.954 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:06.530003+00). db | 2023-08-31 20:07:45.954 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "4a07db022ace18625eb2b1b7530714fd@ipgateway:5060 2023-07-12T17:28:06.530003Z {"protocolFamily":2..." db | 2023-08-31 20:07:45.954 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.954 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.954 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.533236+00). db | 2023-08-31 20:07:49.954 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "7c3745ba792f656a4bf0884927636e8d@ipgateway:5060 2023-07-12T17:28:10.533236Z {"protocolFamily":2..." db | 2023-08-31 20:07:49.954 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.954 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.954 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.522434+00). db | 2023-08-31 20:07:49.954 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "BOWMj82mAdwV8FlO@ipgateway 2023-07-12T17:28:10.522434Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:49.954 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.955 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.955 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.532782+00). db | 2023-08-31 20:07:49.955 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "089mIFsBCEFkoCm2@ipgateway 2023-07-12T17:28:10.532782Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:49.955 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.955 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.955 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.526979+00). db | 2023-08-31 20:07:49.955 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "29bece6d53f7350c63791acc1e75bf47@ipgateway:5060 2023-07-12T17:28:10.526979Z {"protocolFamily":2..." db | 2023-08-31 20:07:49.955 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.955 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.955 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.533315+00). db | 2023-08-31 20:07:49.955 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "263a0a896f954f2860dec38a27b48aed@ipgateway:5060 2023-07-12T17:28:10.533315Z {"protocolFamily":2..." db | 2023-08-31 20:07:49.955 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:49.956 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:49.956 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:10.525578+00). db | 2023-08-31 20:07:49.956 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "jCfvCYh-BZ4AAXSt@ipgateway 2023-07-12T17:28:10.525578Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:49.956 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.953 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.953 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.540161+00). db | 2023-08-31 20:07:53.953 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "41eb13913970ede96759a1431027b5db@ipgateway:5060 2023-07-12T17:28:14.540161Z {"protocolFamily":2..." db | 2023-08-31 20:07:53.953 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.954 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.954 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.513568+00). db | 2023-08-31 20:07:53.954 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "15337e92464945f2495efdda624d399b@ipgateway:5060 2023-07-12T17:28:14.513568Z {"protocolFamily":2..." db | 2023-08-31 20:07:53.954 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.955 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.955 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.541223+00). db | 2023-08-31 20:07:53.955 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "9Jp1YARZHXDbPSjZ@ipgateway 2023-07-12T17:28:14.541223Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:53.955 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.957 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.957 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.542805+00). db | 2023-08-31 20:07:53.957 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "75d9bc520a3c58eb6f9dd98d30dae2e4@ipgateway:5060 2023-07-12T17:28:14.542805Z {"protocolFamily":2..." db | 2023-08-31 20:07:53.957 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.957 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.957 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.542947+00). db | 2023-08-31 20:07:53.957 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "TUenvt1CvS::OG7b@ipgateway 2023-07-12T17:28:14.542947Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:53.957 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:53.957 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:53.957 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:14.540507+00). db | 2023-08-31 20:07:53.957 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "Nxudm4p3HaiBw:Jm@ipgateway 2023-07-12T17:28:14.540507Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:53.957 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.954 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.954 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.542445+00). db | 2023-08-31 20:07:57.954 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "609298b46a41edc94663f7f61b87f895@ipgateway:5060 2023-07-12T17:28:18.542445Z {"protocolFamily":2..." db | 2023-08-31 20:07:57.954 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.956 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.956 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.540997+00). db | 2023-08-31 20:07:57.956 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "wgELFYt6UnFbXoAs@ipgateway 2023-07-12T17:28:18.540997Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:57.956 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.957 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.957 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.543812+00). db | 2023-08-31 20:07:57.957 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "0f43ec9b48483ff05b46ae6b5e29db58@ipgateway:5060 2023-07-12T17:28:18.543812Z {"protocolFamily":2..." db | 2023-08-31 20:07:57.957 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.958 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.958 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.530416+00). db | 2023-08-31 20:07:57.958 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "wRYMaPrALgA7kYrl@ipgateway 2023-07-12T17:28:18.530416Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:57.958 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.959 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.959 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.517316+00). db | 2023-08-31 20:07:57.959 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "nCIfaCygSMAvyu5C@ipgateway 2023-07-12T17:28:18.517316Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:07:57.959 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:07:57.959 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:07:57.959 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:18.548187+00). db | 2023-08-31 20:07:57.959 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "0f43ec9b48483ff05b46ae6b5e29db58@ipgateway:5060 2023-07-12T17:28:18.548187Z {"protocolFamily":2..." db | 2023-08-31 20:07:57.959 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.954 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.954 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.539126+00). db | 2023-08-31 20:08:01.954 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "1cf7f3457caecd184088f5d209d71d6b@ipgateway:5060 2023-07-12T17:28:22.539126Z {"protocolFamily":2..." db | 2023-08-31 20:08:01.954 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.955 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.955 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.539417+00). db | 2023-08-31 20:08:01.955 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "121e883708d041cf763adb1f3283785e@ipgateway:5060 2023-07-12T17:28:22.539417Z {"protocolFamily":2..." db | 2023-08-31 20:08:01.955 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.955 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.955 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.530769+00). db | 2023-08-31 20:08:01.955 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "wRYMaPrALgA7kYrl@ipgateway 2023-07-12T17:28:22.530769Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:01.955 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.956 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.956 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.549432+00). db | 2023-08-31 20:08:01.956 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "vKVF39npQG3peU2s@ipgateway 2023-07-12T17:28:22.549432Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:01.956 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.958 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.958 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.543698+00). db | 2023-08-31 20:08:01.958 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "121e883708d041cf763adb1f3283785e@ipgateway:5060 2023-07-12T17:28:22.543698Z {"protocolFamily":2..." db | 2023-08-31 20:08:01.958 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:01.958 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:01.958 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:22.546462+00). db | 2023-08-31 20:08:01.958 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "1ada1ea037fd2b6874b522af03a40c6b@ipgateway:5060 2023-07-12T17:28:22.546462Z {"protocolFamily":2..." db | 2023-08-31 20:08:01.958 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.954 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.954 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.529623+00). db | 2023-08-31 20:08:05.954 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "bCzJ4hOfOf7dG23W@ipgateway 2023-07-12T17:28:26.529623Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:05.954 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.954 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.954 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.52981+00). db | 2023-08-31 20:08:05.954 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "OEFLXZIZ--oUcpH0@ipgateway 2023-07-12T17:28:26.52981Z {"protocolFamily":2,"protocol":17,"srcIp"..." db | 2023-08-31 20:08:05.954 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.955 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.955 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.528457+00). db | 2023-08-31 20:08:05.955 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "b9kRMpHfEGzC61n4@ipgateway 2023-07-12T17:28:26.528457Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:05.955 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.956 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.956 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.529301+00). db | 2023-08-31 20:08:05.956 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "5UDjnVR5ypHk-3bK@ipgateway 2023-07-12T17:28:26.529301Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:05.956 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.956 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.956 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.529967+00). db | 2023-08-31 20:08:05.956 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "3608f0186d6620173c4daefe1276e353@ipgateway:5060 2023-07-12T17:28:26.529967Z {"protocolFamily":2..." db | 2023-08-31 20:08:05.956 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:05.959 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:05.959 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:26.528746+00). db | 2023-08-31 20:08:05.959 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "641d175f64f8445b06acc8052bf77457@ipgateway:5060 2023-07-12T17:28:26.528746Z {"protocolFamily":2..." db | 2023-08-31 20:08:05.959 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.956 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.956 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.526736+00). db | 2023-08-31 20:08:09.956 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "B7al7x7D1ZjmReP9@ipgateway 2023-07-12T17:28:30.526736Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:09.956 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.956 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.956 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.527282+00). db | 2023-08-31 20:08:09.956 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "733c7683262b3c703ccf730c6c038971@ipgateway:5060 2023-07-12T17:28:30.527282Z {"protocolFamily":2..." db | 2023-08-31 20:08:09.956 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.956 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.956 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.527387+00). db | 2023-08-31 20:08:09.956 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "43e9045009ab662f5a588a25688e22d0@ipgateway:5060 2023-07-12T17:28:30.527387Z {"protocolFamily":2..." db | 2023-08-31 20:08:09.956 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.956 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.956 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.527163+00). db | 2023-08-31 20:08:09.956 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "4e6ef9a56007a3e11b2a16412952594b@ipgateway:5060 2023-07-12T17:28:30.527163Z {"protocolFamily":2..." db | 2023-08-31 20:08:09.956 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.957 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.957 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.527595+00). db | 2023-08-31 20:08:09.957 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "fpVhTO0OurkOdsxv@ipgateway 2023-07-12T17:28:30.527595Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:09.957 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.957 UTC [217] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:09.957 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:33.578942+00). db | 2023-08-31 20:08:09.957 UTC [217] CONTEXT: COPY hep_proto_1_default, line 1: "7216689424c071d96b8e69125638c57a@ipgateway:5060 2023-07-12T17:28:33.578942Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:09.957 UTC [217] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.957 UTC [219] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:09.957 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:33.580422+00). db | 2023-08-31 20:08:09.957 UTC [219] CONTEXT: COPY hep_proto_1_default, line 1: "7e094b7473c1c5e24e17eb50758896e4@ipgateway:5060 2023-07-12T17:28:33.580422Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:09.957 UTC [219] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.958 UTC [215] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:09.958 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:33.692733+00). db | 2023-08-31 20:08:09.958 UTC [215] CONTEXT: COPY hep_proto_1_default, line 1: "222993701f5df20952b160327566f5d7@ipgateway:5060 2023-07-12T17:28:33.692733Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:09.958 UTC [215] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.958 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:09.958 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:30.52822+00). db | 2023-08-31 20:08:09.958 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "6f7f1ae705f3571a3432acc56ac2cd7a@ipgateway:5060 2023-07-12T17:28:30.52822Z {"protocolFamily":2,..." db | 2023-08-31 20:08:09.958 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.959 UTC [218] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:09.959 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:33.58002+00). db | 2023-08-31 20:08:09.959 UTC [218] CONTEXT: COPY hep_proto_1_default, line 1: "7e094b7473c1c5e24e17eb50758896e4@ipgateway:5060 2023-07-12T17:28:33.58002Z {"protocolFamily":2,"pr..." db | 2023-08-31 20:08:09.959 UTC [218] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:09.960 UTC [216] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:09.960 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:33.579515+00). db | 2023-08-31 20:08:09.960 UTC [216] CONTEXT: COPY hep_proto_1_default, line 1: "7216689424c071d96b8e69125638c57a@ipgateway:5060 2023-07-12T17:28:33.579515Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:09.960 UTC [216] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.955 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.955 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.533845+00). db | 2023-08-31 20:08:13.955 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "brJgIo8ZbBWYi6eP@ipgateway 2023-07-12T17:28:34.533845Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:13.955 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.955 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.955 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.53508+00). db | 2023-08-31 20:08:13.955 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "621e0fb43ccb20213a236acf7fcbd918@ipgateway:5060 2023-07-12T17:28:34.53508Z {"protocolFamily":2,..." db | 2023-08-31 20:08:13.955 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.955 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.955 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.5335+00). db | 2023-08-31 20:08:13.955 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "KFMJF9XrL9uQwx-1@ipgateway 2023-07-12T17:28:34.5335Z {"protocolFamily":2,"protocol":17,"srcIp":..." db | 2023-08-31 20:08:13.955 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.955 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.955 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.534675+00). db | 2023-08-31 20:08:13.955 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "VSZ2m9uT5E-9eKTx@ipgateway 2023-07-12T17:28:34.534675Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:13.955 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.956 UTC [219] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.956 UTC [219] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.534343+00). db | 2023-08-31 20:08:13.956 UTC [219] CONTEXT: COPY hep_proto_1_call, line 1: "ePsw6a4ZJoCsRSgV@ipgateway 2023-07-12T17:28:34.534343Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:13.956 UTC [219] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.958 UTC [218] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:13.958 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.551128+00). db | 2023-08-31 20:08:13.958 UTC [218] CONTEXT: COPY hep_proto_1_default, line 1: "58766b9d6a3308e24af2e142462c5e26@ipgateway:5060 2023-07-12T17:28:34.551128Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:13.958 UTC [218] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.958 UTC [215] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:13.958 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:35.538496+00). db | 2023-08-31 20:08:13.958 UTC [215] CONTEXT: COPY hep_proto_1_default, line 1: "55e9758c2e89f2643aa67f7302017d54@ipgateway:5060 2023-07-12T17:28:35.538496Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:13.958 UTC [215] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.959 UTC [218] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:13.959 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.550539+00). db | 2023-08-31 20:08:13.959 UTC [218] CONTEXT: COPY hep_proto_1_default, line 1: "58766b9d6a3308e24af2e142462c5e26@ipgateway:5060 2023-07-12T17:28:34.550539Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:13.959 UTC [218] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.960 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:13.960 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:34.535354+00). db | 2023-08-31 20:08:13.960 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "gyvk1TLgwshKhwoz@ipgateway 2023-07-12T17:28:34.535354Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:13.960 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.960 UTC [217] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:13.960 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:35.538232+00). db | 2023-08-31 20:08:13.960 UTC [217] CONTEXT: COPY hep_proto_1_default, line 1: "77730642716e0ad44f172c9a0d1d17c2@ipgateway:5060 2023-07-12T17:28:35.538232Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:13.960 UTC [217] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:13.962 UTC [214] ERROR: no partition of relation "hep_proto_1_default" found for row db | 2023-08-31 20:08:13.962 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:35.564929+00). db | 2023-08-31 20:08:13.962 UTC [214] CONTEXT: COPY hep_proto_1_default, line 1: "77730642716e0ad44f172c9a0d1d17c2@ipgateway:5060 2023-07-12T17:28:35.564929Z {"protocolFamily":2,"p..." db | 2023-08-31 20:08:13.962 UTC [214] STATEMENT: COPY hep_proto_1_default(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.955 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.955 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.531164+00). db | 2023-08-31 20:08:17.955 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "3e835f3864dfa32f600b0e04278ade85@ipgateway:5060 2023-07-12T17:28:38.531164Z {"protocolFamily":2..." db | 2023-08-31 20:08:17.955 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.956 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.956 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.537734+00). db | 2023-08-31 20:08:17.956 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "gc:zhJ6ecWCVmnoP@ipgateway 2023-07-12T17:28:38.537734Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:17.956 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.956 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.956 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.530202+00). db | 2023-08-31 20:08:17.956 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "5d41847e3d53d71b558745247941a4c8@ipgateway:5060 2023-07-12T17:28:38.530202Z {"protocolFamily":2..." db | 2023-08-31 20:08:17.956 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.957 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.957 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.535973+00). db | 2023-08-31 20:08:17.957 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "4f53bd8c13a8c5fe787f3b087950a958@ipgateway:5060 2023-07-12T17:28:38.535973Z {"protocolFamily":2..." db | 2023-08-31 20:08:17.957 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.957 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.957 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.526939+00). db | 2023-08-31 20:08:17.957 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "64072b576c0c6f1e6cb0ca563c2cc7b0@ipgateway:5060 2023-07-12T17:28:38.526939Z {"protocolFamily":2..." db | 2023-08-31 20:08:17.957 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:17.958 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:17.958 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:38.538215+00). db | 2023-08-31 20:08:17.958 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "vvc0nzGwkJRpnRlE@ipgateway 2023-07-12T17:28:38.538215Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:17.958 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.956 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.956 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.51873+00). db | 2023-08-31 20:08:21.956 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "5eddfde460a4fd1d208734224165d0ba@ipgateway:5060 2023-07-12T17:28:42.51873Z {"protocolFamily":2,..." db | 2023-08-31 20:08:21.956 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.956 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.956 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.533873+00). db | 2023-08-31 20:08:21.956 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "3ffa698a2a50fe9e0a043cda6d64fb9f@ipgateway:5060 2023-07-12T17:28:42.533873Z {"protocolFamily":2..." db | 2023-08-31 20:08:21.956 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.957 UTC [216] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.957 UTC [216] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.533396+00). db | 2023-08-31 20:08:21.957 UTC [216] CONTEXT: COPY hep_proto_1_call, line 1: "SBn:-U5uyXU6XfHr@ipgateway 2023-07-12T17:28:42.533396Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:21.957 UTC [216] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.957 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.957 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.533736+00). db | 2023-08-31 20:08:21.957 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "J6zaQ3Bn1TknKkYe@ipgateway 2023-07-12T17:28:42.533736Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:21.957 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.958 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.958 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.533685+00). db | 2023-08-31 20:08:21.958 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "Y:5i6CopexJtmBIK@ipgateway 2023-07-12T17:28:42.533685Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:21.958 UTC [217] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:21.958 UTC [214] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:21.958 UTC [214] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:42.533786+00). db | 2023-08-31 20:08:21.958 UTC [214] CONTEXT: COPY hep_proto_1_call, line 1: "bw04rQz0Ce4xq9Kb@ipgateway 2023-07-12T17:28:42.533786Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:21.958 UTC [214] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:25.956 UTC [218] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:25.956 UTC [218] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:46.520474+00). db | 2023-08-31 20:08:25.956 UTC [218] CONTEXT: COPY hep_proto_1_call, line 1: "R9ysEK-qHG-jFWh2@ipgateway 2023-07-12T17:28:46.520474Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:25.956 UTC [218] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:25.956 UTC [215] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:25.956 UTC [215] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:46.521187+00). db | 2023-08-31 20:08:25.956 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "U2gjOIBZVa9IB9aa@ipgateway 2023-07-12T17:28:46.521187Z {"protocolFamily":2,"protocol":17,"srcIp..." db | 2023-08-31 20:08:25.956 UTC [215] STATEMENT: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN db | 2023-08-31 20:08:25.957 UTC [217] ERROR: no partition of relation "hep_proto_1_call" found for row db | 2023-08-31 20:08:25.957 UTC [217] DETAIL: Partition key of the failing row contains (create_date) = (2023-07-12 17:28:46.520965+00). db | 2023-08-31 20:08:25.957 UTC [217] CONTEXT: COPY hep_proto_1_call, line 1: "vGn8pYuL5jdyEr2G@ipgateway 2023-07-12T17:28:46.520965Z {"protocolFamily":2,"protocol":17,"srcIp..."

bilalrao12 commented 1 year ago

(create_date) = (2023-07-12 17:28:38.526939+00). db | 2023-08-31 20:08:17.957 UTC [215] CONTEXT: COPY hep_proto_1_call, line 1: "64072b576c0c6f1e6cb0ca563c2cc7b0@ipgateway:5060 2023-07-12T17:28:38.526939Z {"protocolFamily":2..." db | 2023-08-31 20:08:17.957 UTC [215] STATEMENT:

This highlighted time is not falling in call table partioning time range. Also seems you are sending trafic from different server to homer machine. Check if time is synced on all involved machines

izaacmenezes commented 1 year ago

I had a doubt regarding this scope, it's the first time I tried to upload homer-app to docker, I already used it the traditional way;

It may be a layman question, but, you see, when I try to beat the time of the logs of the DB and of my local machine, there is a time disparity, in this case, when a request comes from the other gateway it will obey the time of my Is another gateway or postgre in that project configured to respect the time of the server it is allocated on?

image

lmangani commented 1 year ago

@izaacmenezes please make an effort to use english or most of us won't be able to help you at all

izaacmenezes commented 1 year ago

Sorry @lmangani , I changed the question above to English

bilalrao12 commented 1 year ago

@izaacmenezes again, you have wrong time on your gateway (seems asterisk) server. Please set correct times on your VMs and then it should be all fine.

64072b576c0c6f1e6cb0ca563c2cc7b0@ipgateway:5060 2023-07-12T17:28

izaacmenezes commented 1 year ago

I corrected the time in the database by editing the postgresql.conf file, however, I still get the error mentioned above

image

adubovikov commented 1 year ago

yes, but after you corrected it, please restart postgres and heplify-server

izaacmenezes commented 1 year ago

Já havia reiniciado, permanece a mesma saida

bilalrao12 commented 1 year ago

@izaacmenezes ipgateway and homer setup is on same server?

As I wrote earlier, this ipgtateway server (source of sip traffice) has wrong timestamp.

izaacmenezes commented 1 year ago

this situation is more complicated for me because the final gateways do not belong to my administration, but to suppliers, however, I found a time difference in the SBC server that sends the requests, I will correct it and come back here to let you know if it worked, thanks for everyone's support

izaacmenezes commented 1 year ago

Good afternoon, after adjusting the schedule between SBC and HOMER, it was successful, thank you very much for your support, regards