search

rszimm / sprinklers_pi

Sprinkling System Control Program for the Raspberry Pi
GNU General Public License v2.0
310 stars 100 forks source link

Viewing logs crashes system on raspberry pi #114

Closed Whytehorse closed 5 years ago

Whytehorse commented 6 years ago

Steps to reproduce:

  1. View logs
  2. Sort by DOW and choose one day in the range(from=to)
  3. Hit refresh, see the graph
  4. System halts and must be rebooted

I saw

2018/05/02 08:23:20 SELECT zone, strftime('%H', date, 'unixepoch') as hour, SUM( duration) FROM zonelog WHERE date BETWEEN 1525219200 AND 1525305600 GROUP BY zon e,hour ORDER BY zone,hour

in the log file.

I saw somewhere there was a problem when reading or writing to SD card too fast causes it to crash?

nhorvath commented 6 years ago

This is more likely a problem with you SD Card failing. I would backup your data ASAP.

On Wed, May 2, 2018 at 12:33 PM, Whytehorse notifications@github.com wrote:

Steps to reproduce:

  1. View logs
  2. Sort by DOW and choose one day in the range(from=to)
  3. Hit refresh, see the graph
  4. System halts and must be rebooted

I saw

2018/05/02 08:23:20 SELECT zone, strftime('%H', date, 'unixepoch') as hour, SUM( duration) FROM zonelog WHERE date BETWEEN 1525219200 AND 1525305600 GROUP BY zon e,hour ORDER BY zone,hour

in the log file.

I saw somewhere there was a problem when reading or writing to SD card too fast causes it to crash?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/rszimm/sprinklers_pi/issues/114, or mute the thread https://github.com/notifications/unsubscribe-auth/AAKE3GhdiZNMeEnq-MUP9sIx-xcsxlHmks5tud_DgaJpZM4Tvxva .