Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

database locked all the time how to fix this

i am seeing the database locked errors all the time with yieldbuddy is there anyway to fix this or is the software just flawed in some way.

would porting it back to mysql get rid of all the database files locking..........here are my log files



Comments

  • [Mon Mar 21 21:56:28 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:28 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:30 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:30 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:36 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to execute statement: database is locked in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:36 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 27, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:39 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:39 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:42 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to execute statement: database is locked in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 8, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:42 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 20, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:46 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:46 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 27, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:48 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to execute statement: database is locked in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 8, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:48 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 20, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:50 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:50 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:52 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:52 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:58 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:56:58 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_relays_firstrow.php on line 27, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:00 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to execute statement: database is locked in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 7, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:00 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_sensors_firstrow.php on line 21, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:08 2016] [error] [client 192.168.1.202] PHP Warning:  SQLite3::query(): Unable to prepare statement: 5, database is locked in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 8, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:08 2016] [error] [client 192.168.1.202] PHP Fatal error:  Call to a member function fetchArray() on a non-object in /var/www/yieldbuddy/www/sql/sql_arduino_firstrow.php on line 20, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:11 2016] [error] [client 192.168.1.202] PHP Notice:  A session had already been started - ignoring session_start() in /var/www/yieldbuddy/www/command.php on line 33, referer: http://192.168.1.254/yieldbuddy/www/overview.php
    [Mon Mar 21 21:57:11 2016] [error] [client 192.168.1.202] PHP Notice:  Undefined index: submit in /var/www/yieldbuddy/www/command.php on line 35, referer: http://192.168.1.254/yieldbuddy/www/overview.php

  • hey mate, did you solved the problem ? 
Sign In or Register to comment.