OpenBMP / obmp-psql

New OpenBMP PostgreSQL consumer and database
BSD 3-Clause "New" or "Revised" License
6 stars 9 forks source link

Problem inserting into l3vpn_rib #16

Open majlsfiles opened 10 months ago

majlsfiles commented 10 months ago

Can you please help me with debugging. I can't get l3vpn_rib to be inserted.

I see a lot of similar errors

{"log":"2024-01-04 09:54:24.730 UTC [205] ERROR: current transaction is aborted, commands ignored until end of transaction block\n","stream":"stderr","time":"2024-01-04T09:54:24.730506627Z"} {"log":"2024-01-04 09:54:24.730 UTC [205] STATEMENT: INSERT INTO l3vpn_rib (hash_id,peer_hash_id,base_attr_hash_id,isIPv4,origin_as,prefix,prefix_len,timestamp,isWithdrawn,path_id,labels,isPrePolicy,isAdjRibIn,rd,ext_community_list) VALUES ('a113b06cda889e1a243a8a707f49e03c'::uuid,'5f56e088717d94f3639de1cdb3446dd7'::uuid,'c99f55c5a173dbec748e36e6683612b1'::uuid,true::boolean,65001,'10.225.1.158/32'::inet,32,'2024-01-04 09:54:24.084116'::timestamp,false,0,'25248',true::boolean,true::boolean,'32121:32356','{\"rt=32121:32356\"}'::varchar[]),('25972bdc71a57cd6be36ad89a04d1a21'::uuid,'5f56e088717d94f3639de1cdb3446dd7'::uuid,'c99f55c5a173dbec748e36e6683612b1'::uuid,true::boolean,65001,'0.0.0.0/232'::inet,232,'2024-01-04 09:54:24.084116'::timestamp,false,0,'0,',true::boolean,true::boolean,':','{\"rt=32121:32356\"}'::varchar[]) ON CONFLICT (peer_hash_id,hash_id) DO UPDATE SET timestamp=excluded.timestamp,base_attr_hash_id=CASE excluded.isWithdrawn WHEN true THEN l3vpn_rib.base_attr_hash_id ELSE excluded.base_attr_hash_id END,origin_as=CASE excluded.isWithdrawn WHEN true THEN l3vpn_rib.origin_as ELSE excluded.origin_as END,isWithdrawn=excluded.isWithdrawn,path_id=excluded.path_id, labels=excluded.labels,isPrePolicy=excluded.isPrePolicy, isAdjRibIn=excluded.isAdjRibIn,rd=excluded.rd,ext_community_list=excluded.ext_community_list \n","stream":"stderr","time":"2024-01-04T09:54:24.730520027Z"}

When restarting postgres first message is:

{"log":"2024-01-05 08:31:43.547 UTC [145] ERROR: invalid input syntax for type inet: \"0.0.0.0/232\" at character 553\n","stream":"stderr","time":"2024-01-05T08:31:43.547625954Z"}

I guess the problem is with prefix "232".