printnanny-cloud-nats.service fails to start with Error: Record not found

[leigh-johnson]

Describe the bug

Looks like we're failing to start printnanny-cloud-nats.service in v0.6.2, with error:

Error: Record not found

To Reproduce

What are the steps to reproduce the issue?

1. sudo -u printnanny /usr/bin/printnanny -vv nats-cloud-worker

Issue.txt

-----------------------
Build Info:  |
-----------------------
IMAGE_NAME = printnanny-release-image-raspberrypi4-64-20230202052633
DISTRO_PRETTY = PrintNanny Linux 0.6.2 (Feldspar)
VARIANT_NAME = PrintNanny OS Core
VARIANT_ID = core
DISTRO = printnanny
DISTRO_NAME = PrintNanny Linux
DISTRO_VERSION = 0.6.2
DISTRO_CODENAME = Feldspar
ID_LIKE = BitsyLinux
HOME_URL = https://printnanny.ai
BUG_REPORT_URL = https://github.com/bitsy-ai/printnanny-os/issues
YOCTO_VERSION = 4.1.2
YOCTO_CODENAME = Langdale
MACHINE = raspberrypi4-64
TUNE_PKGARCH = cortexa72
-----------------------
Layer Revisions:      |
-----------------------
meta              = langdale:f59aa3752dbc5552469207894bea9c01bd68fb6e
meta-poky         = langdale:f59aa3752dbc5552469207894bea9c01bd68fb6e
meta-yocto-bsp    = langdale:f59aa3752dbc5552469207894bea9c01bd68fb6e
meta-raspberrypi  = langdale-libcamera-fix:99f5a91d9d4b34ff8c214cf61cd12f375da1a76a
meta-oe           = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-python       = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-multimedia   = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-bitsy        = main:3483ea5157e7d612154d7cda67715c11056ddabf
meta-neural-network = mickledore:f19fa74c2f4c868eda1c48d709b66848f9cca5e8
meta-printnanny   = main:3483ea5157e7d612154d7cda67715c11056ddabf
meta-networking   = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-filesystems  = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-initramfs    = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-webserver    = langdale:f8cb46d803190bb02085c8a7d20957a71d32f311
meta-swupdate     = mickledore:c47a10be18412919f4c7041be05509ba97ac79f4
meta-microcontroller = mickledore:a848733698649628d0c3e34ae04ced0ee6ce3aee

[leigh-johnson]

Update: now seeing the following error in a v0.6.3 dev build. Looks like we're not creating the organization-level unit.

Error: error in response: status code: 500 Internal Server Error content: {"error_uuid": "21796a14ef0b4d37965f21f96fe2fd83", "error": "null value in column \"organization_id\" violates not-null constraint\nDETAIL:  Failing row contains (28, null, {}, null, null, 84, hopeful-salamander-from-hell, null, null, null, null, null, null, f).\n"}

[leigh-johnson]

Also maybe I need to apply a PG filter to the nats app name generator :joy: hopeful-salamander-from-hell

[leigh-johnson]

:+1: A fix for this will be released with v0.6.3

[2023-02-03T01:39:59Z INFO  printnanny_edge_db::cloud] printnanny_edge_db::cloud::Pi with id=1 updated
[2023-02-03T01:39:59Z INFO  printnanny_edge_db::nats_app] printnanny_edge_db::nats_app::NatsApp attempting to insert row: NatsApp {
        id: 29,
        app_name: "raccoon-of-pastoral-weather",
        pi_id: 84,
        organization_id: 10,
        organization_name: "mighty-accomplished-cheetah",
        nats_server_uri: "nats://nats.live.printnanny.ai:4222",
        nats_ws_uri: "wss://nats.live.printnanny.ai:8443",
        mqtt_broker_host: "mqtt.live.printnanny.ai",
        mqtt_broker_port: 1883,
    }
[2023-02-03T01:39:59Z INFO  printnanny_edge_db::nats_app] printnanny_edge_db::nats_app::NatsApp created 1