[ECODP-dev] 500 error server

Wed Apr 3 15:59:44 UTC 2013

Hi John,

/var folder where postgres data is along with the log file, had no space
left. As you see at the bottom of the email with the df commands.

Every sql query is written in the log file inside the /var folder. I want
to configure the logging of CKAN, not to output so many sql statements in
/var/lib/pgsql/data/pg_log/ folder.
Do I need only to configure postgres for that and restart the server, or
should I do also some manipulation in the configuration on CKAN itself on
FRONTEND ?

I need to know if I have to only tweak the Postgres or the CKAN overrides
this itself.

Regards,
Dimitrios

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

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