[ECODP-dev] 500 error server

Wed Apr 3 12:37:45 UTC 2013

Hi John,

As I understand this is something to be configured in Postgres.

Do we need to tweak this file:
*/applications/ecodp/users/ecodp/ckan/etc/ecodp/ecodp.ini
 *?

Cheers,
Dimitrios

On Wed, Apr 3, 2013 at 2:18 PM, John Glover <john.glover at okfn.org> wrote:

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