[ECODP-dev] 500 error server

[John Glover]

Hi Dimitrios,

What sort of configuration? You can either change the log level (debug,
info, warning and error) or disable it.

Cheers,
John


On 3 April 2013 13:44, Dimitrios Mexis <dimitrios.mexis at tenforce.com> wrote:

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