search

chuot / rdio-scanner

Rdio Scanner is an open source software that ingest and distribute audio files generated by various software-defined radio recorders. Its interface tries to reproduce the user experience of a real police scanner, while adding its own touch.
GNU General Public License v3.0
422 stars 60 forks source link

Write constraint failed error #321

Closed cpg178-kcd closed 1 year ago

cpg178-kcd commented 1 year ago

Recently setup a 2nd server running Rdio and configured a downstream to send the audio files to the main server, occasionally I am getting a controller.ingestcall: systems.write: constraint failed: UNIQUE constraint failed: rdioScannerSystems.id (2067) error.

On this setup I am using the default sql lite DB so my suspicion is that the main RDIO instance is already trying to write something at the same time that the downstream it hits so it errors out, or am I missing something here?

chuot commented 1 year ago

It tries to create a new system with an ID that already exists. Is auto-populate activated on that system or globally?

cpg178-kcd commented 1 year ago

Yes, the error seems to have stopped since the system has been up and running for a few days now. i will close this