problem to log-in, php-cgi.exe high cpu-load

Ask all your questions regarding OC 4.x and older. Please read the Support Forum Rules
Forum rules
Before you post; make sure you are using at least PHP Version 5.3.x - Also read How To Solve Problems By Yourself

problem to log-in, php-cgi.exe high cpu-load

Postby Beorn » Wed May 30, 2012 10:32 am

Hi,

i made a fresh install of OC4 and have now an issues when users are loggin in. the password is accepted, but then randomly the browser is hanging/waiting. on the server i see that one of the php-cgi.exe processes is under high load. in the db i can see that since the login of the user the sql-server has 2500 queries/ per second! if i try to catch one of these queries i can see a query:
SELECT source
FROM oc_sharing
WHERE target = '\\'
AND uid_shared_with
IN (
'user', 'user@doc-readers', 'public'
)
LIMIT 1
the status of the query jumps from "init" to "preparing" to "writing to net"

If I kill the php-cgi process, the browser drops an error but the login completes after reloading the page.

Any hints for me how narrow the problem down or to fix it?

kind regards
Beorn
Beorn
Beginner
 
Posts: 14
Joined: Sun May 13, 2012 7:43 am

Re: problem to log-in, php-cgi.exe high cpu-load

Postby sepbav » Thu May 31, 2012 10:06 pm

Hi there,

I stumbled upon the same problem. I'm running MySql on a Windows Server, in case that matters.
To be more precise, this exact behaviour happened each time after I
1. logged in
2. uploaded a file
3. switched to another app
4. switched back to "files"
--> blank page hanging with infinite queries against the mysql db.

The solution is fairly simple: disable the app that's the culprit: Sharing.

How/where can I file a bug report on this?

Regards,
Tom
sepbav
Newbie
 
Posts: 1
Joined: Thu May 31, 2012 10:02 pm


Return to OwnCloud Community Edition 4.x and older

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 11 guests