Some of these are valid entries, and the entries with a large nfinstanceid are failing. The last two entries in the below dump work fine, as the key seems to be small enough not to cause the issue. MariaDB [nrf]> select hex(nfinstanceid),nfprofile from nrf.nf_profile_json -> ; +----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | hex(nfinstanceid) | nfprofile | +----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 101041A005A240008042200001DAAC06 | {"nfInstanceId":101041a0-05a2-4000-8042-200001daac06,"updateInfo":595039366267983,"create_time":1712154255,"last_hb_time":1712178255,"client_ip":"16.16.16.4","registerTimestamp":"2024-04-03T14:54:15Z","nfProfileChangesSupportInd":1,"nf_profile":"{"nfInstanceId":"101041a0-05a2-4000-8042-200001daac06","nfType":"UPF","nfStatus":"REGISTERED","heartBeatTimer":600,"plmnList":[{"mcc":"310","mnc":"012"},{"mcc":"311","mnc":"480"}],"sNssais":[{"sst":12,"sd":"010203"}],"nsiList":["slice-instance-1"],"fqdn":"upf1.nokia.com","ipv4Addresses":["33.34.1.1"],"ipv6Addresses":["3ffe::2122:101"],"allowedPlmns":[{"mcc":"310","mnc":"012"},{"mcc":"311","mnc":"480"}],"allowedNssais":[{"sst":12,"sd":"010203"}],"priority":9,"capacity":20,"load":0,"upfInfo":{"sNssaiUpfInfoList":[{"sNssai":{"sst":12,"sd":"010203"},"dnnUpfInfoList":[{"dnn":"apnstaticpccrules"},{"dnn":"apndynamicrulebase"},{"dnn":"apnstaticpccnorules"},{"dnn":"ipd.alcatel.0.1.com"},{"dnn":"ipd.alcatel.0.2.com"},{"dnn":"ipd.alcatel.0.3.com"},{"dnn":"ipd.alcatel.0.4.com"},{"dnn":"ipd.alcatel.1.1.com"},{"dnn":"ipd.alcatel.1.2.com"},{"dnn":"ipd.alcatel.1.3.com"},{"dnn":"ipd.alcatel.1.4.com"},{"dnn":"ipd.alcatel.1.5.com"},{"dnn":"ipd.alcatel.1.6.com"},{"dnn":"ipd.alcatel.1.7.com"},{"dnn":"ipd.alcatel.1.8.com"},{"dnn":"ipd.alcatel-lucent.com"},{"dnn":"apn.1.1.com"},{"dnn":"apn.1.2.com"},{"dnn":"apn.1.3.com"},{"dnn":"apn.1.4.com"},{"dnn":"apn.0.1.com"},{"dnn":"apn.0.2.com"},{"dnn":"apn.0.3.com"},{"dnn":"apn.0.4.com"},{"dnn":"dynamicqfimapping.1.com"},{"dnn":"ipd.nokia.com.mnc010.mcc460.gprs"},{"dnn":"ipd.nokia.1.1.com.mnc010.mcc460.gprs"},{"dnn":"staticrule.nokia.com.mnc010.mcc460.gprs"},{"dnn":"staticrule.cuc.internet.mnc010.mcc460.gprs"},{"dnn":"ims.cuc.mnc010.mcc460.gprs"},{"dnn":"ipd.alcatel.1.1.com.mnc012.mcc310.gprs"},{"dnn":"ipd.alcatel.1.1.com.mnc012.mcc345.gprs"},{"dnn":"ipd.alcatel.1.2.com.mnc012.mcc310.gprs"},{"dnn":"ipd.alcatel.1.2.com.mnc012.mcc345.gprs"},{"dnn":"apn.nonip.1.1.com"},{"dnn":"apn.nonip.1.2.com"},{"dnn":"ipd.alcatel.sccg.scale.0.1.com"},{"dnn":"ipd.alcatel.sccg.scale.0.2.com"},{"dnn":"ipd.alcatel.sccg.scale.0.3.com"},{"dnn":"ipd.alcatel.sccg.scale.0.4.com"},{"dnn":"ipd.alcatel.sccg.scale.0.5.com"},{"dnn":"ipd.alcatel.sccg.scale.0.6.com"},{"dnn":"ipd.alcatel.sccg.scale.0.7.com"},{"dnn":"ipd.alcatel.sccg.scale.0.8.com"},{"dnn":"ipd.alcatel.sccg.scale.0.9.com"},{"dnn":"ipd.alcatel.sccg.scale.0.10.com"}]}]},"recoveryTime":"2024-04-03T14:24:09Z"}"} | | 1116D20A115A1135BC79114DC38E3333 | junk json for big nfinstanceid | | 1116D20A115A1135BC79114DC38E3F11 | {"nfInstanceId":1116d20a-115a-1135-bc79-114dc38e3f11,"updateInfo":594854682650116,"create_time":1712153936,"last_hb_time":1712154116,"client_ip":"11.127.5.7","registerTimestamp":"2024-04-03T14:18:56Z","nf_profile":"{"nfInstanceId":"1116d20a-115a-1135-bc79-114dc38e3f11","nfType":"AMF","nfStatus":"REGISTERED","heartBeatTimer":600,"plmnList":[{"mcc":"310","mnc":"012"}],"sNssais":[{"sst":1,"sd":"D143A5"},{"sst":2,"sd":"ABCDEF"}],"interPlmnFqdn":"smf1.east.mnc012.mcc310.3gppnetwork.org","ipv4Addresses":["11.127.5.7"],"locality":"east","amfInfo":{"amfSetId":"123","amfRegionId":"01","guamiList":[{"plmnId":{"mcc":"310","mnc":"012"},"amfId":"011001"},{"plmnId":{"mcc":"312","mnc":"011"},"amfId":"AF2345"}]},"nfServices":[{"serviceInstanceId":"s1-namf-comm","serviceName":"namf-comm","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-evts","serviceName":"namf-evts","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-mt","serviceName":"namf-mt","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-loc","serviceName":"namf-loc","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50}]}"} | | 301041A008204000860A000006CAAC06 | {"nfInstanceId":301041a0-0820-4000-860a-000006caac06,"updateInfo":594906222281807,"create_time":1712154255,"last_hb_time":1712178255,"client_ip":"16.16.16.3","registerTimestamp":"2024-04-03T14:54:15Z","nfProfileChangesSupportInd":1,"nf_profile":"{"nfInstanceId":"301041a0-0820-4000-860a-000006caac06","nfType":"SMF","nfStatus":"REGISTERED","heartBeatTimer":600,"plmnList":[{"mcc":"460","mnc":"10"}],"sNssais":[{"sst":12,"sd":"010203"}],"nsiList":["slice-instance-1"],"fqdn":"smf1.nokia.com","interPlmnFqdn":"smfC.5gc.mnc10.mcc460.3gppnetwork.org","ipv4Addresses":["16.70.16.16"],"ipv6Addresses":["3ffe::1046:1010"],"priority":9,"capacity":20,"load":0,"smfInfo":{"sNssaiSmfInfoList":[{"sNssai":{"sst":12,"sd":"010203"},"dnnSmfInfoList":[{"dnn":"ims.cuc.mnc010.mcc460.gprs"},{"dnn":"staticrule.cuc.internet.mnc010.mcc460.gprs"},{"dnn":"apnstaticpccrules"},{"dnn":"apndynamicrulebase"},{"dnn":"apnstaticpccnorules"},{"dnn":"ipd.alcatel.0.1.com"},{"dnn":"ipd.alcatel.0.2.com"},{"dnn":"ipd.alcatel.0.3.com"},{"dnn":"ipd.alcatel.0.4.com"},{"dnn":"ipd.alcatel.1.1.com"},{"dnn":"ipd.alcatel.1.2.com"},{"dnn":"ipd.alcatel.1.3.com"},{"dnn":"ipd.alcatel.1.4.com"},{"dnn":"ipd.alcatel.1.5.com"},{"dnn":"ipd.alcatel.1.6.com"},{"dnn":"ipd.alcatel.1.7.com"},{"dnn":"ipd.alcatel.1.8.com"},{"dnn":"ipd.alcatel-lucent.com"},{"dnn":"apn.1.1.com"},{"dnn":"apn.1.2.com"},{"dnn":"apn.1.3.com"},{"dnn":"apn.1.4.com"},{"dnn":"apn.0.1.com"},{"dnn":"apn.0.2.com"},{"dnn":"apn.0.3.com"},{"dnn":"apn.0.4.com"},{"dnn":"apn.nonip.1.1.com"},{"dnn":"apn.nonip.1.2.com"},{"dnn":"dynamicqfimapping.1.com"},{"dnn":"ipd.nokia.com.mnc010.mcc460.gprs"},{"dnn":"ipd.nokia.1.1.com.mnc010.mcc460.gprs"},{"dnn":"staticrule.nokia.com.mnc010.mcc460.gprs"},{"dnn":"ipd.alcatel.1.1.com.mnc012.mcc310.gprs"},{"dnn":"ipd.alcatel.1.1.com.mnc012.mcc345.gprs"},{"dnn":"ipd.alcatel.1.2.com.mnc012.mcc310.gprs"},{"dnn":"ipd.alcatel.1.2.com.mnc012.mcc345.gprs"},{"dnn":"ipd.alcatel.sccg.scale.0.1.com"},{"dnn":"ipd.alcatel.sccg.scale.0.2.com"},{"dnn":"ipd.alcatel.sccg.scale.0.3.com"},{"dnn":"ipd.alcatel.sccg.scale.0.4.com"},{"dnn":"ipd.alcatel.sccg.scale.0.5.com"},{"dnn":"ipd.alcatel.sccg.scale.0.6.com"},{"dnn":"ipd.alcatel.sccg.scale.0.7.com"},{"dnn":"ipd.alcatel.sccg.scale.0.8.com"},{"dnn":"ipd.alcatel.sccg.scale.0.9.com"},{"dnn":"ipd.alcatel.sccg.scale.0.10.com"}]}],"pgwFqdn":"pgw1.alcatel-lucent.com","vsmfSupportInd":true},"recoveryTime":"2024-04-03T14:24:09Z","nfServices":[{"serviceInstanceId":"pdu1","serviceName":"nsmf-pdusession","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.0.2"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"16.70.16.16","transport":"TCP","port":80},{"ipv6Address":"3ffe::1046:1010","transport":"TCP","port":80}],"priority":9,"capacity":20,"load":0}]}"} | | 33333333333300000000000000000000 | This is a dummy json | | 39393939393900000000000000000000 | {"nfInstanceId":1116d20a-115a-1135-bc79-114dc38e3f11,"updateInfo":594854682650116,"create_time":1712153936,"last_hb_time":1712154116,"cli ent_ip":"11.127.5.7","registerTimestamp":"2024-04-03T14:18:56Z","nf_profile":"{"nfInstanceId":"1116d20a-115a-1135-bc79-114dc38e3f11","nfType":"AMF","nfStatus":"REGISTERED","heartBeatTimer":600,"plmnList":[{"mcc":"310","mnc":"012"}],"sNssais":[{"sst":1,"sd":"D143A5"},{"sst":2,"sd":"ABCDEF"}],"interPlmnFqdn":"smf1.east.mnc012.mcc310.3gppnetwork.org","ipv4Addresses":["11.127.5.7"],"locality":"east","amfInfo":{"amfSetId":"123","amfRegionId":"01","guamiList":[{"plmnId":{"mcc":"310","mnc":"012"},"amfId":"011001"},{"plmnId":{"mcc":"312","mnc":"011"},"amfId":"AF2345"}]},"nfServices":[{"serviceInstanceId":"s1-namf-comm","serviceName":"namf-comm","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-evts","serviceName":"namf-evts","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-mt","serviceName":"namf-mt","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50},{"serviceInstanceId":"s1-namf-loc","serviceName":"namf-loc","versions":[{"apiVersionInUri":"v1","apiFullVersion":"1.R15.0.0"}],"scheme":"http","nfServiceStatus":"REGISTERED","ipEndPoints":[{"ipv4Address":"10.10.7.75","transport":"TCP","port":7788}],"priority":10,"capacity":100,"load":50}]}"} | +----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 6 rows in set (0.001 sec)