waltb
New Member
Posts: 8
Raspberry Pi: Yes
|
Post by waltb on Aug 14, 2022 9:22:29 GMT -8
My SkyWeather2.py no longer starts up.
[Update: Turning off MySQL Logging allows SkyWeather2.py to start, minus logging of course.]
When I run MySQL, it seems OK:
MariaDB [SkyWeather2]> show tables; +-----------------------+ | Tables_in_SkyWeather2 | +-----------------------+ | IndoorTHSensors | | PowerSystem | | SystemLog | | WeatherData | +-----------------------+ 4 rows in set (0.001 sec)
But SkyWeather2.py fails with this message:
MySQL Database SkyWeather2 Updates Not Installed. Run this command: sudo mysql -u root -p SkyWeather2 < 27.2.DataBaseUpdate.sql SkyWeather2 Stopped
So when I run sudo mysql -u root -p SkyWeather2 < 27.2.DataBaseUpdate.sql (which I thought I did several months ago), I get this error:
ERROR 1932 (42S02): Table 'SkyWeather2.WeatherData' doesn't exist in engine
(I thought maybe I forgot to do sudo mysql -u root -p SkyWeather2 < 27.3.DataBaseUpdate.sql, but that gives the same error)
Also MariaDB>SHOW COLUMNS FROM WeatherData FROM SkyWeather2; yields the same error.
git pull is up to date, and so are apt-get and pip.
sudo mysql -u root -p WeatherSenseWireless < updateWeatherSenseWireless.sql works fine.
I even rebuilt RTL_433 to see if that was the problem. (A long shot, I know. SDR is its own thing.)
Any ideas? Do I need to remove and reinstall the database? If so, is there a script for that?
Thanks!
|
|
|
Post by SDL on Aug 14, 2022 13:56:54 GMT -8
Hmm. can you check to see if your SD Card is full?
df And post the results. If you are almost out of storage, really strange things happen.
I'm wondering if your database has some how been corrupted?
BP
|
|
kiwx
Junior Member

Posts: 65
|
Post by kiwx on Aug 16, 2022 15:27:51 GMT -8
sounds to me like the mysql datafiles are missing or the permissions have changed. you can look in /var/lib/mysql on linux. Unless you have a backup copy, its probably best to drop and recreate the databases.
|
|