Hey guys!, i just started working with my RAE and the first thing i tried was to upgrade it to the lates version.
I was able to register it and tried then to upgrade through SSH using the guide in the getting started docs
However after the file was downloaded RAE restarted i lost access to it over wifi, i was able to SSH into it this time using the USB-C interface and noticed that the wifi interface was off, but it was worse, the robothub service is just not running ![](https://i.imgur.com/geqitDch.png)
The issue seems to be due to some SQL tables not being installed
![](https://i.imgur.com/4hmbyLmh.jpg)
Heres the full log output:
root@rae:~# robothub-ctl logs
41 02:34:56 I root/agent : cors: false
41 02:34:56 I root/agent : changing ownership of '/home/robothub'
41 02:35:08 I root/agent : directory structure created
{
"foldersToPrepare": [
"/home/robothub/data/detections",
"/home/robothub/data/logs",
"/home/robothub/data/sources",
"/home/robothub/data",
"/run/robothub",
"/run/robothub/agent",
"/home/robothub/data/tunnel"
]
}
41 02:35:08 I root/agent : unique machine id: 4d66dbd19a6d2e83a8de542f533de9aea95c2e9f33cff9d639df020530de3d19
41 02:35:08 I root/agent : rootless process spawned
Started RobotHub Agent.
41 02:35:10 I logger : NODE_ENV: production
41 02:35:10 I logger : loading bootstrap configuration from "/etc/robothub-agent/agent.toml"
41 02:35:11 I user/agent : initializing unprivileged process
41 02:35:11 I user/agent : dropping privileges...
41 02:35:11 I user/agent : rootless PID: 2003
41 02:35:11 I user/agent : member of groups (for device access): dialout, plugdev
41 02:35:11 I user/agent : reloading configuration...
41 02:35:11 I user/agent : loading bootstrap configuration from "/etc/robothub-agent/agent.toml"
[2024-02-10 02:35:11.508] [warning] USB protocol not available - If running in a container, make sure that the following is set: "-v /dev/bus/usb:/dev/bus/usb --device-cgroup-rule='c 189:* rmw'"
41 02:35:12 I user/agent : imported entrypoint
41 02:35:12 I user/agent : imported local broker
41 02:35:12 E user/agent : failed to initialize context
{
"error": {
"code": "SQLITE_ERROR",
"message": "table devices_status has no column named bootloader_version",
"name": "SqliteError",
"stack": "SqliteError: table devices_status has no column named bootloader_version\n at Database.prepare (file:///usr/libexec/robothub/robothub-agent.mjs:196509:26)\n at new AgentDevicesStatus (file:///usr/libexec/robothub/robothub-agent.mjs:157625:28)\n at databaseBuilder (file:///usr/libexec/robothub/robothub-agent.mjs:198569:23)\n at initializeContext (file:///usr/libexec/robothub/robothub-agent.mjs:233984:22)\n at file:///usr/libexec/robothub/robothub-agent.mjs:234075:45\n at file:///usr/libexec/robothub/robothub-agent.mjs:26737:16"
}
}
41 02:35:12 E user/agent : init crashed!
{
"error": {
"cause": {
"code": "SQLITE_ERROR",
"message": "table devices_status has no column named bootloader_version",
"name": "SqliteError",
"stack": "SqliteError: table devices_status has no column named bootloader_version\n at Database.prepare (file:///usr/libexec/robothub/robothub-agent.mjs:196509:26)\n at new AgentDevicesStatus (file:///usr/libexec/robothub/robothub-agent.mjs:157625:28)\n at databaseBuilder (file:///usr/libexec/robothub/robothub-agent.mjs:198569:23)\n at initializeContext (file:///usr/libexec/robothub/robothub-agent.mjs:233984:22)\n at file:///usr/libexec/robothub/robothub-agent.mjs:234075:45\n at file:///usr/libexec/robothub/robothub-agent.mjs:26737:16"
},
"message": "Unable to initialize configuration!",
"name": "Error",
"stack": "Error: Unable to initialize configuration!\n at initializeContext (file:///usr/libexec/robothub/robothub-agent.mjs:234040:11)\n at file:///usr/libexec/robothub/robothub-agent.mjs:234075:45\n at file:///usr/libexec/robothub/robothub-agent.mjs:26737:16"
}
}
41 02:35:12 I root/agent : rootless process exited with [object Object]
I have tried resetting the device, but no luck.
I can enable the interface and get internet access and i have tried to reinstall various versions of the agent, but the issue remains
Any ideas about how to fix this issue? any help will be greatly appreciated.