Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D7D0D13FA3D3 for ; Mon, 18 Jun 2012 05:21:01 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SgXCk-0007BA-O2 for pgsql-admin@postgresql.org; Mon, 18 Jun 2012 08:21:01 +0000 Received: by pbbrp8 with SMTP id rp8so7917446pbb.19 for ; Mon, 18 Jun 2012 01:20:43 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding :x-gm-message-state; bh=SnXJku2/HUn9sIHzUnxkJmRPhLZFKt73tB/ptI2BKzo=; b=PQJrQYo59lkCXXUnzJkW8ohuNz60y2gsVQY3+ZAHzJ/IbiwhlrfWDSHGg8tnp4h24M bst7N2eisVOI51yHM+Z0q72XvTqaag7fIfFFWcSQLN3REg0VMcEKylaVDrJj6jMlOVKP qXhwB9oPbJUwa9IpC2fy6UI3/33LHzrS1VEcqwETi4hFaZdc4JLejIPTyW8tuBev/LMq QGiAv7jygzFyyk4L66fReyDc4ZpI2/yg8jzuS/MLrvVaaC1PIXUzh+XJvWXWLIIsGmzZ JQJVUD6yXAMwnDx/5nbn+s5+8zSohIuucjZwe38trrBwdCJEmNJaE1JUnf01ydY+PVm9 TAPg== Received: by 10.68.222.163 with SMTP id qn3mr49275304pbc.135.1340007643050; Mon, 18 Jun 2012 01:20:43 -0700 (PDT) Received: from ayaki.localdomain (office1.postnewspapers.com.au. [150.101.171.128]) by mx.google.com with ESMTPS id ms1sm23076021pbb.63.2012.06.18.01.20.40 (version=SSLv3 cipher=OTHER); Mon, 18 Jun 2012 01:20:42 -0700 (PDT) Message-ID: <4FDEE4D5.1040003@ringerc.id.au> Date: Mon, 18 Jun 2012 16:20:37 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 To: "francescoboccacci@libero.it" CC: pgsql-admin@postgresql.org Subject: Re: CEST ERROR: cursor "ogrpglayerreaderxxxxxxxxx" does not exist References: <7768043.1419641340007121291.JavaMail.defaultUser@defaultHost> In-Reply-To: <7768043.1419641340007121291.JavaMail.defaultUser@defaultHost> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQm0XOrxd/r7RdykX1JYrFUN7CFIjkqW8FT4jfeT8swQ7UksOOz2NexsP5ay80o7ZVOHo+G2 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/81 X-Sequence-Number: 39672 On 06/18/2012 04:12 PM, francescoboccacci@libero.it wrote: > Hi all, > i found a lots of ERROR into my postgresql log file as follow: > > 2012-06-10 23:37:17 CEST ERROR: cursor "ogrpglayerreader073a8d30" does not > exist > 2012-06-10 23:37:17 CEST STATEMENT: CLOSE OGRPGLayerReader073A8D30 > 2012-06-10 23:37:23 CEST ERROR: cursor "ogrpglayerreader073a8e78" does not > exist You're running an application against PostgreSQL that's trying to close a cursor that it never created, that is already closed, or that only exists on a different connection. It's an error in your app, not Pg. Pg is just telling you about the error. -- Craig Ringer