I run SQLite as database with SQL Logger. Every time there is a power cut, the database gets corrupted. Is there a difference between SQLite and PostgreSQL regarding how well they handle power cuts/unexpected shoutdowns?
Thanks!
Peter
jay (support) wrote:I have one which is broken and will be replaced, however it is not rare with longer power cuts than a "home" ups can handle in the area.Or get a UPS for your Indigo Server Mac and have it do an orderly shutdown when necessary. That would also protect your Mac hardware.
Sep 8, 2018, 10:27:29 AM
Enabling plugin "SQL Logger 2.0.7"
Starting plugin "SQL Logger 2.0.7" (pid 1792)
Started plugin "SQL Logger 2.0.7"
SQL Logger connected to /Library/Application Support/Perceptive Automation/Indigo 7/Logs/indigo_history.sqlite
SQL Logger updating all device tables
SQL Logger Error exception trying to create table device_history_28446439 ("AIRFOIL_okimac2013")
SQL Logger Error database disk image is malformed
SQL Logger Error exception trying to insert row into table device_history_28446439 ("AIRFOIL_okimac2013")
SQL Logger Error database disk image is malformed
SQL Logger Error INSERT INTO device_history_28446439 ("canconnect", "canremotecontrol", "instancename", "protocolversion", "sourcealbum", "sourceartist", "sourcegroup", "sourceidentifier", "sourcemachinemodel", "sourcemachinename", "sourcemetadataavailable", "sourcename", "sourceplaystatus", "sourceplaystatus_error", "sourceplaystatus_paused", "sourceplaystatus_playing", "sourceplaystatus_stopped", "sourceplaystatus_unavailable", "sourceremotecontrolavailable", "sourcetrackname", "status", "status_connected", "status_disconnected", "status_unavailable") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Error exception trying to create table device_history_1421122410 ("Alexa Den")
SQL Logger Error database disk image is malformed
mundmc wrote:I'm in the weeds here after a similar power loss and database corruption
Is there a QUICK fix to this? Or do I need to go the PostGreSQL route?
Edit/ Update: Restoring from a Time Machine backup did not work. Karl's utility did not work.
Users browsing this forum: No registered users and 5 guests