 |
|
| Computers Forum Index » Computer - Databases - Informix » create index online... |
|
Page 1 of 1 |
|
| Author |
Message |
| Habichtsberg, Reinhard... |
 Posted: Thu Nov 05, 2009 1:24 pm |
|
|
|
Guest
|
Hi all,
I created a new index ONLINE. Thought that would cause no problems in
production.
However, one program reported errors:
Quote: Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
Date: 04.11.2009 Time: 18:51:54
Program error at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
SYSTEM error number -21523.
Cannot proceed with a dirty/modified table data dictionary entry.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
SYSTEM error number -21523.
Cannot proceed with a dirty/modified table data dictionary entry.
Version of IDS is 11.50.FC5.
Is this a bug or did I understand something wrong?
TIA,
Reinhard. |
|
|
| Back to top |
|
|
|
| Davorin Kremenjas... |
| Posted: Thu Nov 05, 2009 1:24 pm |
|
|
|
Guest
|
On Nov 5, 8:24 am, "Habichtsberg, Reinhard" <RHabichtsb... at (no spam) arz-
emmendingen.de> wrote:
Quote: Hi all,
I created a new index ONLINE. Thought that would cause no problems in
production.
However, one program reported errors:
Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
Date: 04.11.2009 Time: 18:51:54
Program error at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
Hi,
what's your onconfig param AUTO_REPREPARE set to?
If you reconnect your app this should go away, rebuilding an index on
the table changed the table metadata (i.e. version).
HTH
Davorin |
|
|
| Back to top |
|
|
|
| Habichtsberg, Reinhard... |
| Posted: Thu Nov 05, 2009 5:51 pm |
|
|
|
Guest
|
Quote: From: informix-list-bounces at (no spam) iiug.org on Behalf Of Davorin Kremenjas
Sent: Thursday, November 05, 2009 1:09 PM
On Nov 5, 8:24 am, "Habichtsberg, Reinhard" <RHabichtsb... at (no spam) arz-
emmendingen.de> wrote:
Hi all,
I created a new index ONLINE. Thought that would cause no
problems in
production.
However, one program reported errors:
Program stopped at
"/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
Date: 04.11.2009 Time: 18:51:54
Program error at
"/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
Hi,
what's your onconfig param AUTO_REPREPARE set to?
If you reconnect your app this should go away, rebuilding an index on
the table changed the table metadata (i.e. version).
HTH
Davorin
AUTO_REPREPARE is set to "1". In onconfig it is claimed that this should
"Minimizes the occurrence of the -710 error."
The 4gl-program is quite old. Could that be the reason?
Thanks, Reinhard. |
|
|
| Back to top |
|
|
|
| david at (no spam) smooth1.co.uk... |
| Posted: Thu Nov 05, 2009 10:28 pm |
|
|
|
Guest
|
On 5 Nov, 08:24, "Habichtsberg, Reinhard" <RHabichtsb... at (no spam) arz-
emmendingen.de> wrote:
Quote: Hi all,
I created a new index ONLINE. Thought that would cause no problems in
production.
However, one program reported errors:
Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
Date: 04.11.2009 Time: 18:51:54
Program error at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number
464.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
SYSTEM error number -21523.
Cannot proceed with a dirty/modified table data dictionary entry.
SQL statement error number -710.
Table (informix.ap_da_v1) has been dropped, altered or renamed.
SYSTEM error number -21523.
Cannot proceed with a dirty/modified table data dictionary entry.
Version of IDS is 11.50.FC5.
Is this a bug or did I understand something wrong?
TIA,
Reinhard.
What are the sql statements that are producing the -710 errors?
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.sqls.doc/ids_sqs_0441.htm
"the database server does not support any other DDL operations on the
indexed table, until after the specified index has been built without
errors"
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.adref.doc/ids_adr_0026.htm
"By enabling the AUTO_REPREPARE configuration parameter, you can avoid
many -710 errors and reduce the number of reprepare and reoptimize
operations that you must perform manually after the schema of a table
is modified"
It says you can reduce the number of reprepare operations that are
required, not eliminate them completely.
https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/automatic_re_prepare_in_ids
says
"You can still get -710 errors in your applications in one of the
following scenarios:
* The number and type of columns in your SELECT list have changed.
* If you are executing a prepared DDL statement, you might get
-710 errors.
* A rare race condition in the server can lead to a -710 error. |
|
|
| Back to top |
|
|
|
| Andrew Clarke... |
| Posted: Fri Nov 06, 2009 3:41 am |
|
|
|
Guest
|
Quote: "Habichtsberg, Reinhard" wrote
The 4gl-program is quite old. Could that be the reason?
How old is old? I can imagine the very old SDK used in old 4GL is not capable
of playing the re-prepare game. The data structures storing prepared
statements and cursors changed awhile back, perhaps around 4GL version 4.2x,
in concert with the 7 engines if memory serves correctly |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Nov 27, 2009 12:17 am
|
|