[ECODP-dev] 500 error server

[Dimitrios Mexis]

Update status:

Hi John,

CKAN is back, problem was not on TEMP, but on /VAR folder.

Can we configure the excess logging of CKAN with sql queries ?

Regards
Dimitrios

On Wed, Apr 3, 2013 at 1:39 PM, Dimitrios Mexis <
dimitrios.mexis at tenforce.com> wrote:

> 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/c2835ed6/attachment.html>