pokoli
commented
9 years ago Some of the queries running on the mysql database:
MariaDB [owncloud]> show processlist;
+------+----------+-----------+----------+---------+------+-----------+----------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+----------+-----------+----------+---------+------+-----------+----------------------------------------------------------------+----------+
| 475 | root | localhost | owncloud | Query | 0 | NULL | show processlist | 0.000 |
| 1469 | owncloud | localhost | owncloud | Sleep | 0 | | NULL | 0.000 |
| 1504 | owncloud | localhost | owncloud | Query | 0 | query end | UPDATE `oc_filecache` SET `size`='0' WHERE `fileid` = '401205' | 0.000 |
| 1510 | owncloud | localhost | owncloud | Sleep | 0 | | NULL | 0.000 |
| 1589 | owncloud | localhost | owncloud | Sleep | 0 | | NULL | 0.000 |
+------+----------+-----------+----------+---------+------+-----------+----------------------------------------------------------------+----------+
5 rows in set (0.00 sec)
MariaDB [owncloud]> show processlist;
+------+----------+-----------+----------+---------+------+-----------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+----------+-----------+----------+---------+------+-----------+------------------------------------------------------------------------------------------------------+----------+
| 475 | root | localhost | owncloud | Query | 0 | NULL | show processlist | 0.000 |
| 1469 | owncloud | localhost | owncloud | Query | 0 | NULL | commit | 0.000 |
| 1504 | owncloud | localhost | owncloud | Query | 0 | query end | UPDATE `oc_filecache` SET `size`='0' WHERE `fileid` = '401243' | 0.000 |
| 1510 | owncloud | localhost | owncloud | Query | 0 | NULL | commit | 0.000 |
| 1589 | owncloud | localhost | owncloud | Query | 0 | NULL | SELECT `fileid` FROM `oc_filecache` WHERE `storage` = '1' AND `path_hash` = '398a62fde4e7ae45e399ccd | 0.000 |
+------+----------+-----------+----------+---------+------+-----------+------------------------------------------------------------------------------------------------------+----------+
5 rows in set (0.00 sec)
MariaDB [owncloud]> select count(1) from oc_filecache;
+----------+
| count(1) |
+----------+
| 278365 |
+----------+
1 row in set (0.27 sec)
Which it seems to have all the heavy load on the server side.
DeepDiver1975
PVince81
icewind1991
shoeper
I'm using the owncloud app to sync my local files with remote storage.
Steps to reproduce
Expected behaviour
The files should be deleted on the owncloud server without errors.
Actual behaviour
The owncloud server raises timeout errors when deleting the files. I had a timeout of 5 minutes, and modified php-fpm configuration to timeout on 10 and the problem still persits. I belive that 10 minutes to delete a single file is too much and something is wrong.
I can see some deleted files in the deleted files view in the web interface. For example is see that file Imatges/Whatsapp/IMG-20121002-WA0001.jpg is deleted, but as you can see in the log it raises a timeout on the client.
Server configuration
Operating system: Debian 7.8 Web server: Nginx + PHP-FPM Database: MariaDB 5.5.35 PHP version: PHP 5.4.36
ownCloud version: ownCloud 7.0.4 (stable) Updated from an older ownCloud or fresh install: Upgraded from an older version
List of activated apps: Activity, Calendar, Contacts, Deleted Files, Documents, First Run Wizard, PDF Viewer, Pictures, Share Files, Text Editor, Updated, Versions, Video Viewer.
The content of config/config.php:
Are you using external storage, if yes which one: No external storage
Are you using encryption: no
Client configuration
Browser: Firefox 35.0.1 Operating system: Linux Mint Rebeca (Ubuntu 14.04) Mirall version: 1.7.1
Logs
Web server error log
There a lot of entries like this.
And in mirall i see the following output:
ownCloud log (data/owncloud.log)
Nothing relevant on owncloud.log only errors related to mysql restart i have done manually.
Let me know if anything else is required to properly fix the bug.