[ECODP-dev] 500 error server

[Dimitrios Mexis]

Hi John,

Because we receive 500 server error from ckan on ODP and if you check the
logs under you will see that we have space, we don't have a clue. Can you
help us to unblock the situation ?

In the logs I read message like :
*cursor.execute(statement, parameters)*
*[Wed Apr 03 13:32:59 2013] [error] [client 192.168.35.231]
OperationalError: (OperationalError) could not write block 1 of temporary
file: No space left on device*
*[Wed Apr 03 13:32:59 2013] [error] [client 192.168.35.231] HINT:  Perhaps
out of disk space?*
*[Wed Apr 03 13:32:59 2013] [error] [client 192.168.35.231]  'SELECT
package.id AS package_id, package.name AS package_name, package.title AS
package_title, package.version AS package_version, package.url AS
package_url, package.author AS package_author, package.author_email AS
package_author_email, package.maintainer AS package_maintainer,
package.maintainer_email AS package_maintainer_email, package.notes AS
package_notes, package.license_id AS package_license_id, package.type AS
package_type, package.state AS package_state, package.revision_id AS
package_revision_id \\nFROM package JOIN member ON member.table_id =
package.id JOIN "group" ON "group".id = member.group_id \\nWHERE
package.state = %(state_1)s AND "group".id = %(id_1)s AND member.state =
%(state_2)s AND member.capacity = %(capacity_1)s ORDER BY package.name'
{'state_1': u'active', 'capacity_1': 'public', 'id_1':
u'4d83d427-9629-4bc2-877d-0c3577955b92', 'state_2': 'active'}*
*
*
*but we have space in ODP CKAN backend :*
*[root at ecodp-gr04 ~]# df -h*
*Filesystem            Size  Used Avail Use% Mounted on*
*/dev/mapper/rootvg-root*
*                      5.5G  3.3G  1.9G  64% /*
*/dev/sda1             243M   65M  165M  29% /boot*
*/dev/mapper/rootvg-u01*
*                      504M   17M  462M   4% /u01*
*/dev/mapper/rootvg-oraagent*
*                      2.0G  1.3G  629M  68% /u01/oraagent*
*/dev/mapper/rootvg-var*
*                      8.9G  8.5G     0 100% /var*
*tmpfs                 939M   18M  922M   2% /tmp*
*/dev/mapper/ecodp_uservg-ecodp_users*
*                       15G  1.2G   13G   9% /applications/ecodp/users*

*and in ODP Frontend:*
*[root at ecodp-odp3 sparql]# df -h*
*Filesystem            Size  Used Avail Use% Mounted on*
*/dev/mapper/rootvg-root*
*                      5.5G  4.1G  1.2G  79% /*
*/dev/sda1             243M   65M  165M  29% /boot*
*/dev/mapper/rootvg-u01*
*                      504M   17M  462M   4% /u01*
*/dev/mapper/rootvg-oraagent*
*                      2.0G  1.3G  629M  68% /u01/oraagent*
*/dev/mapper/rootvg-var*
*                      8.9G  589M  7.9G   7% /var*
*tmpfs                 939M  2.1M  937M   1% /tmp*
*/dev/mapper/ecodp_uservg-ecodp_users*
*                       15G   13G  1.9G  88% /applications/ecodp/users*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130403/4b4d5cac/attachment.html>