Closed remixtj closed 8 years ago
@PVince81
{"reqId":"54d88a6000222","app":"hook","message":"error while running hook (\OC\Files\Storage\Shared::setup): An exception occurred while executing 'SELECT
oc_share
.id
,item_type
,item_source
,item_target
,\n\t\t\t\t\t\t\toc_share
.parent
,share_type
,share_with
,uid_owner
,\n\t\t\t\t\t\t\tfile_source
,path
,file_target
,oc_share
.permissions
,stime
,expiration
,token
,storage
,mail_send
FROMoc_share
INNER JOINoc_filecache
ONfile_source
=oc_filecache
.fileid
WHEREfile_target
IS NOT NULL ANDshare_type
IN (?,?,?) ANDshare_with
IN () ANDuid_owner
!= ? ORDER BYoc_share
.id
ASC':\n\nSQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens","level":3,"time":"2015-02-09T10:22:24+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/"}
that one is truely spooky:
{"reqId":"54d88a6000222",
"app":"hook",
"message":"error while running hook (\\OC\\Files\\Storage\\Shared::setup): An exception occurred while executing 'SELECT `oc_share`.`id`, `item_type`, `item_source`, `item_target`,\n\t\t\t\t\t\t\t`oc_share`.`parent`, `share_type`, `share_with`, `uid_owner`,\n\t\t\t\t\t\t\t`file_source`, `path`, `file_target`, `oc_share`.`permissions`, `stime`, `expiration`, `token`, `storage`, `mail_send` FROM `oc_share` INNER JOIN `oc_filecache` ON `file_source` = `oc_filecache`.`fileid` WHERE `file_target` IS NOT NULL AND `share_type` IN (?,?,?) AND `share_with` IN () AND `uid_owner` != ? ORDER BY `oc_share`.`id` ASC':\n\nSQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens",
"level":3,
"time":"2015-02-09T10:22:24+00:00",
"method":"PROPFIND",
"url":"\/remote.php\/webdav\/"}
@DeepDiver1975 possibly fixed in the upcoming 7.0.5. There were some issues with that specific query.
Can we please get rid of all that nightmare share sqls? :imp:
Object store is used exclusively. Even for "fixed" users, after some time the size of the "files" folder gets out of sync.
Possibly a bug in the home object store implementation and/or size propagation ?
CC @butonic
@DeepDiver1975 ref: https://github.com/owncloud/core/pull/13470 for the sharing code fix
I noted that there are several debug notifications on the log for files that are inside the directory that has the size set to -1:
{"reqId":"54d8b281114d1","app":"OC\\Files\\Cache\\Scanner","message":"!!! No reuse of etag for 'Progetto fusioni\/CB_IS\/studio _def' !!! \ncache: Array\n(\n [fileid] => 42453\n [storage] => object::user:2B97A8D9-9921-4128-8231-3538697635B3\n [path] => Progetto fusioni\/CB_IS\/studio _def\n [parent] => 42431\n [name] => studio _def\n [mimetype] => httpd\/unix-directory\n [mimepart] => httpd\n [size] => 2955997\n [mtime] => 1423487594\n [storage_mtime] => 1423487603\n [encrypted] => \n [unencrypted_size] => 0\n [etag] => 54d8b2738e9c1\n [permissions] => 31\n [displayname_owner] => User\n [uid_owner] => 2B97A8D9-9921-4128-8231-3538697635B3\n)\n \ndata: Array\n(\n [mimetype] => httpd\/unix-directory\n [mtime] => 1423487594\n [size] => -1\n [etag] => 54d8b28108d29\n [storage_mtime] => 1423487594\n [permissions] => 31\n [parent] => 42431\n)\n","level":0,"time":"2015-02-09T13:13:37+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/progetto%20fusioni\/Progetto%20fusioni\/CB_IS"}
Don't know if useful, but could be related.
Was this solved/fixed?
I'm not aware of any fix for this.
@remixtj please try again with 8.2.6 or 9.0.3. There were some recent fixes to quota calculation that went wrong in some cases.
If the problem still exists in these versions, please reopen.
This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.
Steps to reproduce
(steps are quite vague, but several users reported this in this way an i've no idea on how to reproduce)
Expected behaviour
Quota should be computed correctly according the rules and directory should show the size of the files that are contained inside.
Actual behaviour
Quota reports "0 of ?", size of the shared directory is "In Progress". On Database i find out this:
The very strange behavior is that, sometimes, without user intervention, the quota is fixed (maybe due to cron execution).
Server configuration
Operating system: Red Hat Enterprise Linux 6.5
Web server: Apache/2.2.15
Database: mysql Ver 14.14 Distrib 5.1.71, for redhat-linux-gnu (x86_64) using readline 5.1
PHP version: PHP 5.4.16 (cli) (built: Feb 4 2014 08:10:51)
ownCloud version: 7.0.3.4
Updated from an older ownCloud or fresh install:
List of activated apps: Enabled:
The content of config/config.php:
Are you using external storage, if yes which one: swift as main storage.
Are you using encryption: no
Client configuration
Browser: Several (IE 10, Firefox 32/35, Chrome)
Operating system: Several (Windows 7, Several linux distributions)
Logs
Web server error log
ownCloud log (data/owncloud.log)
This log has been extracted with
Browser log
nothing relevant.