No connection to owncloud v9.1.6 after upgrade

nnako · September 16, 2017, 6:29pm

Steps to reproduce

try to access owncloud service via windows client by https://192.168.1.33/index.php -> n.ok
try to access owncloud service via SSH on server -> ok

Expected behaviour

normally, the owncloud service brings forth any page (calendar, documents,... or sometimes the login page)

Actual behaviour

HISTORY

in 2014 I first installed the owncloud server on a RaspberryPi, which worked fine. I kept it quite happily at a very early version v8.0.3 for many months (i.e. some years). As recently some synchronisation problems arose (frequent inaccessibility times and very slow synchronisation), I decided to change the running system and try to upgrade it gradually over v8.0.16, v8.1.12, v8.2.11, v9.0.10 to finally v9.1.6 where I am now. Always doing these steps:

download and untar the respective version onto the Raspberry
copying the old config.php into the new installation
keeping the external storage (USB) containing all the files
change folder owner,...
successfully running the command sudo -u www-data php occ upgrade

The test after each of these update steps was always positive as I could successfully use the client software to access and browse through my files. Synchronisation with the Windows file system worked fine as well. BUT: After some hours / days of normal operation, now there is this behaviour:

NO reaction within the browser after trying with https://192.168.1.33/index.php
the owncloud client v2.3.3 (build 8250), which is running in the background on my Windows system, permanently shows an error message, saying that there is NO CONNECTION to https://192.168.1.33 - error transferring https://192.168.1.33/status.php - server replied: Internal Server Error
using a python script and the occlient module does not succeed as it does before

As all the above effects are related to communication via the HTTP protocol, I guess, there is some problem with the combination owncloud server vs. nginx ( / php )

Server configuration

Operating system: Raspbian (Debian)

Web server: Nginx

Database: Sqlite

PHP version: v5.4.45

ownCloud version: v9.1.6

Updated from an older ownCloud or fresh install: from some older versions (see HISTORY above)

Where did you install ownCloud from: download from owncloud website, and update via SSH on RaspberryPi

Signing status (ownCloud 9.0 and above): SORRY, THERE ARE NO RESULTS, as there is no reaction on HTTP

The content of config/config.php:

<?php
$CONFIG = array (
  'instanceid' => 'ocuxl9zqninv',
  'passwordsalt' => '...SNIP...SNIP...SNIP...',
  'secret' => '...SNIP...SNIP...SNIP...',
  'trusted_domains' =>
  array (
    0 => '192.168.1.33',
    1 => '192.168.2.169',
  ),
  'datadirectory' => '/media/usb1/ownCloud/data',
  'overwrite.cli.url' => 'https://192.168.1.46',
  'dbtype' => 'sqlite3',
  'version' => '9.1.6.2',
  'installed' => true,
  'mail_from_address' => '...SNIP...SNIP...SNIP...',
  'mail_smtpmode' => 'smtp',
  'mail_domain' => 'web.de',
  'mail_smtphost' => 'smtp.web.de',
  'mail_smtpport' => '587',
  'mail_smtpsecure' => 'tls',
  'mail_smtpauthtype' => 'LOGIN',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'trashbin_retention_obligation' => 'auto',
  'integrity.check.disabled' => true,
  'mail_smtpauth' => 1,
  'mail_smtpname' => '...SNIP...SNIP...SNIP...',
  'mail_smtppassword' => '...SNIP...SNIP...SNIP...',
);

sudo -u www-data php occ config:list system results in:

An unhandled exception has been thrown:
exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [14] unable to open database file' in /var/www/owncloud/lib/private/DB/Connection.php:58
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(973): OC\DB\Connection->connect()
#1 /var/www/owncloud/lib/private/DB/Connection.php(209): Doctrine\DBAL\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)
#2 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): OC\DB\Connection->executeUpdate('PRAGMA read_unc...')
#3 /var/www/owncloud/lib/private/DB/Connection.php(141): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#5 /var/www/owncloud/lib/private/DB/ConnectionFactory.php(122): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/owncloud/lib/private/Server.php(414): OC\DB\ConnectionFactory->getConnection('sqlite3', Array)
#7 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#8 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('DatabaseConnect...')
#9 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#10 /var/www/owncloud/lib/private/Server.php(973): OC\ServerContainer->query('DatabaseConnect...')
#11 /var/www/owncloud/lib/private/Server.php(219): OC\Server->getDatabaseConnection()
#12 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#13 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#14 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#15 /var/www/owncloud/lib/private/Server.php(223): OC\ServerContainer->query('OC\\Authenticati...')
#16 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#17 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#18 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#19 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(150): OC\ServerContainer->query('OC\\Authenticati...')
#20 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#21 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#22 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#23 /var/www/owncloud/lib/private/Server.php(238): OC\ServerContainer->query('OC\\Authenticati...')
#24 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#25 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('UserSession')
#26 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('UserSession')
#27 /var/www/owncloud/lib/private/Server.php(850): OC\ServerContainer->query('UserSession')
#28 /var/www/owncloud/lib/private/Server.php(458): OC\Server->getUserSession()
#29 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('AppManager')
#31 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#32 /var/www/owncloud/lib/private/Server.php(1150): OC\ServerContainer->query('AppManager')
#33 /var/www/owncloud/lib/private/legacy/app.php(285): OC\Server->getAppManager()
#34 /var/www/owncloud/lib/private/legacy/app.php(106): OC_App::getEnabledApps()
#35 /var/www/owncloud/lib/base.php(573): OC_App::loadApps(Array)
#36 /var/www/owncloud/lib/base.php(973): OC::init()
#37 /var/www/owncloud/console.php(58): require_once('/var/www/ownclo...')
#38 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#39 {main}

List of activated apps:

I just use the CALENDAR app (which currently seems to have a signature issue), but issuing sudo -u www-data php occ app:list from the SSH command line results in:

An unhandled exception has been thrown:
exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [14] unable to open database file' in /var/www/owncloud/lib/private/DB/Connection.php:58
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(973): OC\DB\Connection->connect()
#1 /var/www/owncloud/lib/private/DB/Connection.php(209): Doctrine\DBAL\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)
#2 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): OC\DB\Connection->executeUpdate('PRAGMA read_unc...')
#3 /var/www/owncloud/lib/private/DB/Connection.php(141): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#5 /var/www/owncloud/lib/private/DB/ConnectionFactory.php(122): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/owncloud/lib/private/Server.php(414): OC\DB\ConnectionFactory->getConnection('sqlite3', Array)
#7 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#8 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('DatabaseConnect...')
#9 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#10 /var/www/owncloud/lib/private/Server.php(973): OC\ServerContainer->query('DatabaseConnect...')
#11 /var/www/owncloud/lib/private/Server.php(219): OC\Server->getDatabaseConnection()
#12 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#13 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#14 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#15 /var/www/owncloud/lib/private/Server.php(223): OC\ServerContainer->query('OC\\Authenticati...')
#16 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#17 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#18 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#19 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(150): OC\ServerContainer->query('OC\\Authenticati...')
#20 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#21 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('OC\\Authenticati...')
#22 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#23 /var/www/owncloud/lib/private/Server.php(238): OC\ServerContainer->query('OC\\Authenticati...')
#24 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#25 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('UserSession')
#26 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('UserSession')
#27 /var/www/owncloud/lib/private/Server.php(850): OC\ServerContainer->query('UserSession')
#28 /var/www/owncloud/lib/private/Server.php(458): OC\Server->getUserSession()
#29 /var/www/owncloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(102): Pimple\Container->offsetGet('AppManager')
#31 /var/www/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#32 /var/www/owncloud/lib/private/Server.php(1150): OC\ServerContainer->query('AppManager')
#33 /var/www/owncloud/lib/private/legacy/app.php(285): OC\Server->getAppManager()
#34 /var/www/owncloud/lib/private/legacy/app.php(106): OC_App::getEnabledApps()
#35 /var/www/owncloud/lib/base.php(573): OC_App::loadApps(Array)
#36 /var/www/owncloud/lib/base.php(973): OC::init()
#37 /var/www/owncloud/console.php(58): require_once('/var/www/ownclo...')
#38 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#39 {main}

Are you using external storage, if yes which one: yes, USB memory stick

Are you using encryption: no

Are you using an external user-backend, if yes which one: no, I'm working just within local LAN

Client configuration

Browser: Firefox

Operating system: Windows 7

Logs

Web server error log

from /var/log/nginx/error.log there are blocks of these strings (every couple of seconds)

2017/09/16 19:53:59 [error] 2317#0: *23071 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [14] unable to open database file' in /var/www/owncloud/lib/private/DB/Connection.php:58
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(973): OC\DB\Connection->connect()
#1 /var/www/owncloud/lib/private/DB/Connection.php(209): Doctrine\DBAL\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)
#2 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): OC\DB\Connection->executeUpdate('PRAGMA read_unc...')
#3 /var/www/owncloud/lib/private/DB/Connection.php(141): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#5 /v...
PHP message: PHP Fatal error:  Uncaught exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [14] unable to open database file' in /var/www/owncloud/lib/private/DB/Connection.php:58
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(973): OC\DB\Connection->connect()
#1 /var/www/owncloud/lib/private/DB/Connection.php(209): Doctrine\DBAL\Connection->executeUpdate('PRAGMA read_unc...', Array, Array)
#2 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): OC\DB\Connection->executeUpdate('PRAGMA read_unc...')
#3 /var/www/owncloud/lib/private/DB/Connection.php(141): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#4 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine

ownCloud log (data/owncloud.log)

...
ud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(996): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO \\\"oc...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(209): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO \\\"oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/AdapterSqlite.php(85): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `*P...', Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(247): OC\\\\DB\\\\AdapterSqlite->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(117): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(162): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/71c7fa30b...', 1)\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(668): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/71c7fa30b...', 1)\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(584): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/02 - GEME...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(584): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/02 - GEME...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/sharedstorage.php(377): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/02 - GEME...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(584): OC\\\\Files\\\\Storage\\\\Shared->acquireLock('BS_CityChurch', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1922): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('BS_CityChurch', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(2028): OC\\\\Files\\\\View->lockPath('\\\/02 - GEMEINDE\\\/...', 1)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1109): OC\\\\Files\\\\View->lockFile('\\\/02 - GEMEINDE\\\/...', 1)\\n#15 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(693): OC\\\\Files\\\\View->basicOperation('unlink', '\\\/02 - GEMEINDE\\\/...', Array)\\n#16 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(333): OC\\\\Files\\\\View->unlink('\\\/02 - GEME{"reqId":"qD4KUnCtPeyR\/2KEMzYu","remoteAddr":"192.168.1.58","app":"PHP","message":"PHP Startup: apc.shm_size now uses M\/G suffixes, please update your ini files at Unknown#0","level":3,"time":"2017-09-12T13:59:59+00:00","method":"GET","url":"\/status.php","user":"--"}
{"reqId":"pVzlOiQHPZjzN9\/91CoU","remoteAddr":"192.168.1.58","app":"PHP","message":"Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'INSERT INTO \"oc_authtoken\"(\"uid\",\"login_name\",\"password\",\"name\",\"token\",\"type\",\"last_activity\") VALUES(?,?,?,?,?,?,?)' with params [\"Hanna\", \"Hanna\", \"5da2f9aecd653068572d37d96599f112|B\\\/Am5Nl4On5ePTYV|22842633bf66f34c7c96c08c6fa6d9ed7ee0c2a1598de0150cae8c73654479b49ff6cf1696406aa67dadb5fee67ecec8993101dd3f98ebcdaaed5b46e0a05122\", \"Mozilla\\\/5.0 (Windows) mirall\\\/2.2.4 (build 6408)\", \"acf446f8802012f09e97dc352bd54a03c4c87562013745075206c6daeb833a09b185af6dd40d787984b6525b566b9a064c9705c82087179d8c6c1f4f21fea20a\", 0, 1505224806]:\n\nSQLSTATE[HY000]: General error: 13 database or disk is full at \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractSQLiteDriver.php#85","level":3,"time":"2017-09-12T14:00:06+00:00","method":"GET","url":"\/ocs\/v1.php\/cloud\/activity?page=0&pagesize=100&format=json","user":"Hanna"}
{"reqId":"tN4HY55dqbdjmF1I706F","remoteAddr":"192.168.1.58","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 503 Doctrine\\\\DBAL\\\\Exception\\\\DriverException: An exception occurred while executing 'INSERT INTO \\\"oc_authtoken\\\"(\\\"uid\\\",\\\"login_name\\\",\\\"password\\\",\\\"name\\\",\\\"token\\\",\\\"type\\\",\\\"last_activity\\\") VALUES(?,?,?,?,?,?,?)' with params [\\\"Hanna\\\", \\\"Hanna\\\", \\\"0c44dd9d1211993975431753d493bcd6|M9VpeXFS5cj6+0Au|9c8176d7c3620b871a019235583556391afd08755e654a77880525a7d23fe0c35680eb4e62b438c84bf4940732109a607a126e236f97cce40a96f64d693b0787\\\", \\\"Mozilla\\\\\\\/5.0 (Windows) mirall\\\\\\\/2.2.4 (build 6408)\\\", \\\"f3b130ac3055e984ed10058c1e23a1436c52bd5bcf1c0baa7bf014c0cba0f9ab32e1e988840e90d9a2144809f84d0416932311ce022c8834c9e9ca56c37f0e07\\\", 0, 1505224830]:\\n\\nSQLSTATE[HY000]: General error: 13 database or disk is full\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\ServiceUnavailable\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(166): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Auth->check(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#1 [internal function]: Sabre\\\\DAV\\\\Auth\\\\Plugin->beforeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(446): Sabre\\\\Event\\\\EventEmitter->emit('beforeMethod', Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(61): Sabre\\\\DAV\\\\Server->exec()\\n#6 \\\/var\\\/www\\\/owncloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/ownclo...')\\n#7 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Auth.php\",\"Line\":153,\"User\":\"Hanna\"}","level":4,"time":"2017-09-12T14:00:30+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/","user":"Hanna"}
{"reqId":"wuxqti5WdtbRewciDEWa","remoteAddr":"192.168.1.58","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 503 Doctrine\\\\DBAL\\\\Exception\\\\DriverException: An exception occurred while executing 'INSERT INTO \\\"oc_authtoken\\\"(\\\"uid\\\",\\\"login_name\\\",\\\"password\\\",\\\"name\\\",\\\"token\\\",\\\"type\\\",\\\"last_activity\\\") VALUES(?,?,?,?,?,?,?)' with params [\\\"Hanna\\\", \\\"Hanna\\\", \\\"4d63fe13dd9be17b1ff98810d43cc4b1|d{"reqId":"ZsVOQ7W9zP4VEUyZsy7a","remoteAddr":"192.168.1.34","app":"PHP","message":"PHP Startup: apc.shm_size now uses M\/G suffixes, please update your ini files at Unknown#0","level":3,"time":"2017-09-12T19:58:29+00:00","method":"GET","url":"\/status.php","user":"--"}

browsing through the 20 MB owncloud log file, it seems that the 16 GB USB storage is full.. . But now, the owncloud server has no chance to react on the respective user when removing some files, as the HTTP is not working. Can I just remove files from the storage device directly? Or would there arise further conflicts concerning the owncloud management of these "missing" files?

Could this shut-off behaviour of owncloud have been caused by a full storage device, anyway? Or would this be a different problem?

Thanks.

nnako · September 17, 2017, 8:33pm

Hi all together,

after moving via SSH into the external USB drive and removing the biggest files / folders, Owncloud started again and tried to synchronize. I just had to remove the files / folders using the web browser interface, as they were still kind of visible via the web browser. After some synchronisation attempts (with some timeouts), the system now runs stable again.

One question: where can I find structure information about where a file is referenced when put into the data folder:

data / <username> / files / <folders> / <file>

I've seen that there is another location where the older versions seem to be placed:

data / <username> / file_versions / <folders> / <file>.v<number>

But this doesn't seem to be the only places within the Owncloud system.

Any pointers to where to find structural information about this subject?

Thanks.

dmitry · September 18, 2017, 8:01am

Hi,

I have searched the documentation and have not found anything about it.

You could just test it by uploading a file and look for it in the tables. But I figure you have already done it

I have found the table oc_filecache, where the filename, location and size is written. Does this helps you?

nnako · September 21, 2017, 2:38pm

After a couple of hours / days, now, my owncloud will not let me in anymore.

It says something about an "internal server error" and gives an issue identification number.

Is there a cookbook describing where I could start looking for the cause? And maybe look for solutions?

Thanks.

tom42 · September 23, 2017, 12:33pm

I think your servers logfiles should tell you more about this internal server error.

nnako · September 27, 2017, 6:44pm

Some investigation has shown that one of my users continued to push further files onto the Owncloud instance. So, the cause for the "internal server error" was the same as before. So I stopped the user from pushing further files (by removing them on his computer) and deleted the files on the owncloud instance again. This time, the system seems to be and stay stable.

One thing, though: The used memory size stays at 13GB (for a total disk space of 16GB), although the actual disk usage will be at 6GB. I tried to clean up the instance by issuing these two commands, but the used disk space doesn't seem to go to normal, again:

sudo -u www-data php occ files:cleanup
sudo -u www-data php occ versions:cleanup

Any hints on how to bring the file size to normal again?

dmitry · September 28, 2017, 7:51am

files clean up only deletes files of users that are no longer in your owncloud. Then they will be moved to the remnants table, and from there you should use the files cleanup command to free the space.