[ECODP-dev] 500 error server

Wed Apr 3 11:39:40 UTC 2013

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>