At 1:53 PM -0300 4/8/2005, Leandro Pinto Fava wrote:
>Hi,
>
>coincidently I got this error today too. I never seen this error before. It was raised while running a batch process (many inserts using temporary tables).
>
>Some info:
>Ingres II 2.6/0305 (rs4.us5/00) Patch 9695 AIX 5.1
>The database which this batch process was running is a test database. The batch process was running alone at that moment.
>
>SERPENS ::[48036 , 3d37a200]: Fri Apr 8 12:53:19 2005 E_US1265_4709 Database reorganization activity has rendered the query plan invalid. Try again after the db activity is complete. In case of dynamic SQL, the statement must be prepared again.

Before executing a query plan, the tables involved are checked to see
if they have changed. Changed in this case means that either the table
definition changed, or the number of pages (table size) has changed
sufficiently. (I'm not sure what the trigger is.) When this happens,
QEF throws away the query plan and sends the query back through parsing
and optimization again.

If this happens more than N times in a row without a successful
execution, the US1265 message appears. N used to be small, like 3;
I'm fairly sure that it's 10 in 2.6. About the only legitimate reason
for US1265 to appear is if a table in a query is growing rapidly,
or being modified over and over. DB procedures are probably more
sensitive to US1265 since they're one big query plan. If you have
a persistent US1265, I would be very suspicious.

Karl