[ECODP-dev] 500 error server

[John Glover]

Hi Dimitrios,

I'm not exactly sure what you are trying to configure, can you provide more
details please. If you want to change the level of verbosity of CKAN's
logging (or disable logging, or log to a different location) you can indeed
edit that file.

John


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

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