renaming folders

[archme]

Version: owncloud 4.3.2

On my setup renaming folders cause problems.
Renaming empty folders works fine.
But renaming folders with content make troubles.
And only when changeing a character in the file name from lowercase to uppercase.

Im using sqlite, and get this warning in logs:
PHP Warning: SQLite3::prepare(): Unable to prepare statement: 5, database is locked in /home/www/owncloud/lib/MDB2/Driver/sqlite3.php on line 898

can someone reproduce this behavior,
or is it a setup problem ?

[blizzz]

Works fine with MySQL, so probably something dependent on sqlite. We have another bug with the same error message (#216), not necessarilly related, but maybe.

[archme]

Tried to reproduce with postgresql (9.2.1).
With this DB backend Owncloud is nearly unusable.

To many bugs to list them all.
calender, contacts do not work.
after creating first folder i get:
DB Error: "MDB2 Error: no such field"
Offending command was: DELETE FROM "oc_properties" WHERE "propertypath" = "/Shared"
...

[eMerzh]

@archme the bug with postgresql is corrected ... (#430)

sooo many postgres bug... but none of them are in the issue tracker....

https://github.com/owncloud/core/issues/search?q=postgresql

please help us make OC a better software :)

For the Sqlite problem... are you sure that nothing else has open the db? an editor, another client, another session?

[archme]

@eMerzh, sorry for my "rude" words, i exaggerated.
Not sure how to get the fixed version.
I now used: git clone -b stable45 https://github.com/owncloud/core.git
If this is the right version, i could immediately post a new bug ;)

[eMerzh]

@archme yes it was applied on stable45....(and not yet released in a .X version)
could you do a pull on stable45 ? the patch was applied less than 1 day ago....

and give me the result of

git rev-parse --short HEAD

[archme]

I now test with this command: git clone https://github.com/owncloud/core.git
With this version, the sqlite bug is still there on my setup.
With postgresql it works fine now.

For the Sqlite problem... are you sure that nothing else has open the db? an editor, another client, another session?

lsof /home/www/owncloud/data/owncloud.db
uwsgi 10146 http 10uw REG 8,5 29696 8398802 /home/www/owncloud/data/owncloud.db

ps ax|grep 10146
10146 ? S 0:00 /usr/bin/uwsgi --ini owncloud.example.com.ini

There also exists /home/www/owncloud/data/owncloud.db-journal (also locked by the same PID)
And i have 100% cpu-io-wait, until i kill the PID

[archme]

@eMerzh, did you also test with sqlite backend ?

[eMerzh]

@archme for the fix i was talking about pg...

for your sqlite pbm, i don't know enough the uwsgi way of working... but i think it seems to be one part of the problem....

in sqlite 2 different process cannot use the db at the same time

[jancborchardt]

@archme is this still an issue with the current stable 4.5.7?