Concrete 5 Killing my server! Please help!
Permalink
OK So i have this site on my server.http://www.cornwallalc.gov.uk.
The problem is that whenever my client edits or updates a file in file manager (i.e changing the title of a document) The site crashes, and in turn crashes my server which hosts over 100 site, which as you can imagine is not good!
Here is a log of what happens
I'm 100% its a MySQL issue, due to a query locking up the service shown below: Problem is i don;t know how to fix it!
Please help me, i'm going insane.
The problem is that whenever my client edits or updates a file in file manager (i.e changing the title of a document) The site crashes, and in turn crashes my server which hosts over 100 site, which as you can imagine is not good!
Here is a log of what happens
I'm 100% its a MySQL issue, due to a query locking up the service shown below: Problem is i don;t know how to fix it!
# User@Host: cnxserv_********[cnxserv_********] @ pipeten127.wiredworkplace.net [213.143.3.127] # Query_time: 170132.152115 Lock_time: 0.001221 Rows_sent: 0 Rows_examined: 628 use cnxserv_calc; SET timestamp=1338548972; SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSetFiles fsf21 on fsf21.fID = f.fID left join FileSetFiles fsf18 on fsf18.fID = f.fID left join FileSetFiles fsf19 on fsf19.fID = f.fID left join FileSetFiles fsf20 on fsf20.fID = f.fID left join FileSetFiles fsf22 on fsf22.fID = f.fID left join FileSetFiles fsf23 on fsf23.fID = f.fID left join FileSetFiles fsf24 on fsf24.fID = f.fID left join FileSetFiles fsf25 on fsf25.fID = f.fID left join FileSetFiles fsf26 on fsf26.fID = f.fID left join FileSetFiles fsf27 on fsf27.fID = f.fID left join FileSetFiles fsf28 on fsf28.fID = f.fID left join FileSetFiles fsf29 on fsf29.fID = f.fID left join FileSetFiles fsf47 on fsf47.fID = f.fID left join FileSetFiles fsf46 on fsf46.fID = f.fID left join FileSetFiles fsf48 on fsf48.fID = f.fID left join FileSetFiles fsf30 on fsf30.fID = f.fID left join FileSetFiles fsf31 on fsf31.fID = f.fID left join FileSetFiles fsf1 on fsf1.fID = f.fID left join FileSetFiles fsf2 on fsf2.fID = f.fID left join FileSetFiles fsf15 on fsf15.fID = f.fID left join FileSetFiles fsf49 on fsf49.fID = f.fID left join FileSetFiles fsf16 on fsf16.fID = f.fID left join FileSetFiles fsf3 on fsf3.fID = f.fID left join FileSetFiles fsf32 on fsf32.fID = f.fID left join FileSetFiles fsf33 on fsf33.fID = f.fID left join FileSetFiles fsf34 on fsf34.fID = f.fID left join FileSetFiles fsf35 on fsf35.fID = f.fID left join FileSetFiles fsf36 on fsf36.fID = f.fID left join FileSetFiles fsf4 on fsf4.fID = f.fID left join FileSetFiles fsf37 on fsf37.fID = f.fID left join FileSetFiles fsf5 on fsf5.fID = f.fID left join FileSetFiles fsf6 on fsf6.fID = f.fID left join FileSetFiles fsf38 on fsf38.fID = f.fID left join FileSetFiles fsf7 on fsf7.fID = f.fID left join FileSetFiles fsf8 on fsf8.fID = f.fID left join FileSetFiles fsf9 on fsf9.fID = f.fID left join FileSetFiles fsf39 on fsf39.fID = f.fID left join FileSetFiles fsf10 on fsf10.fID = f.fID left join FileSetFiles fsf11 on fsf11.fID = f.fID left join FileSetFiles fsf12 on fsf12.fID = f.fID left join FileSetFiles fsf40 on fsf40.fID = f.fID left join FileSetFiles fsf41 on fsf41.fID = f.fID left join FileSetFiles fsf13 on fsf13.fID = f.fID left join FileSetFiles fsf14 on fsf14.fID = f.fID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and (fsf21.fsID=21 OR fsf18.fsID=18 OR fsf19.fsID=19 OR fsf20.fsID=20 OR fsf22.fsID=22 OR fsf23.fsID=23 OR fsf24.fsID=24 OR fsf25.fsID=25 OR fsf26.fsID=26 OR fsf27.fsID=27 OR fsf28.fsID=28 OR fsf29.fsID=29 OR fsf47.fsID=47 OR fsf46.fsID=46 OR fsf48.fsID=48 OR fsf30.fsID=30 OR fsf31.fsID=31 OR fsf1.fsID=1 OR fsf2.fsID=2 OR fsf15.fsID=15 OR fsf49.fsID=49 OR fsf16.fsID=16 OR fsf3.fsID=3 OR fsf32.fsID=32 OR fsf33.fsID=33 OR fsf34.fsID=34 OR fsf35.fsID=35 OR fsf36.fsID=36 OR fsf4.fsID=4 OR fsf37.fsID=37 OR fsf5.fsID=5 OR fsf6.fsID=6 OR fsf38.fsID=38 OR fsf7.fsID=7 OR fsf8.fsID=8 OR fsf9.fsID=9 OR fsf39.fsID=39 OR fsf10.fsID=10 OR fsf11.fsID=11 OR fsf12.fsID=12 OR fsf40.fsID=40 OR fsf41.fsID=41 OR fsf13.fsID=13 OR fsf14.fsID=14) and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 97 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0); /usr/sbin/mysqld, Version: 5.1.49-log (MySQL Community Server (GPL)). started with: Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Please help me, i'm going insane.
It's not localised to one file, It does this pretty much everytime you try to do something in the file manager
Its a monster filter condition for filesets that is being built and run, so I am not surprised it happens for any file.
You need to look for how you have configured the file manager to be overwhelmed by such a massive list of filesets and slim it down.
You need to look for how you have configured the file manager to be overwhelmed by such a massive list of filesets and slim it down.
Looks like the monster query is doing stuff with a monster list of file sets. Maybe the file concerned is in too many file sets or the file manager display is being filtered from too many file sets.
So maybe remove the file from the file sets, or get rid of some of the file sets, or get rid of some of the filtering.
The C5 model that builds this query is:
concrete/models/file_list.php
You will see some familiar SQL snippets in there.