[ECODP-dev] 500 error server

[John Glover]

Hi,

Thanks Dimitrios, that should only require reconfiguring Postgres.

John


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

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