Feedback-ID: i6d194797:Fastmail
Message-ID: <009d1bdd-0e93-4e36-9d2c-aa02dfd5e015@fastmail.com.au>
Date: Mon, 2 Oct 2023 13:36:06 +1100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Unexpected termination looping over table.
Content-Language: en-AU
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@lists.postgresql.org
References: <7250ba53-f3b1-4e7a-a21d-3d9132772bbc@fastmail.com.au>
 <1899612.1696208945@sss.pgh.pa.us>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
In-Reply-To: <1899612.1696208945@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/009d1bdd-0e93-4e36-9d2c-aa02dfd5e015%40fastmail.com.au>
Precedence: bulk

On 2/10/23 12:09, Tom Lane wrote:
> Matt Gibbins <matt_gibbins@fastmail.com.au> writes:
>> Have encountered an intriguing issue processing a table with a large
>> number of rows. The process is to loop over the table processing each
>> row executing the Apache AGE cypher function over each row
>> individually.The looping is necessary because of encountering a limit on
>> the number of rows that the cypher function would process.
>> The process terminates unexpectedly with the following message. Notable
>> that it runs for quite some time before termination.:
>> SQL Error [42703]: ERROR: could not find rte for
>> a01a724103fbb3d059b8387bf043dbc8
>>     Where: PL/pgSQL function
>> analysis.create_trips(text,text,text,text,text,text,integer,text,integer)
>> line 5 at EXECUTE
> There is no occurrence of "could not find rte" anywhere in the
> core Postgres source code.  I surmise that you're using some
> extension that isn't happy.
>
> 			regards, tom lane

Tom

Thanks for your response. I am using the Apache AGE extension which 
enables graph data processing on PostgreSQL.

https://age.apache.org/

I'll enquire with the Apache AGE list for an answer.

Regards

Matt.