[Info-Ingres] Ingres 6.4(07) urgently required

[james.goodwill at googlemail.com]

Okay, More problem after this change. Extract from errlog.log:


rundbms.opt file looks like this:

-names
-connected_sessions 64
-active_sessions 64
-cursors_per_session 16
-database_count 44
-stack_size 393216
-shared_cache
-fast_commit
-write_behind 4
-qsf.pool_size 10485760
-opf.memory 32000000
-psf.memory 5000000
-opf.active 5

Any ideas?

Thanks again for your help,

James


DB_SVR/ingres/live: cat errlog.log | tail -1000
      ::[3245            , 00788040]:     Terminal: batch
      ::[3245            , 00788040]:     Group Id:
   Role Id:
      ::[3245            , 00788040]:     Application Code: 00000000
Current Facility: OPF (00000004)
      ::[3245            , 00788040]:     Activity: Optimizing Query
      ::[3245            , 00788040]:     Query: select COLUMN_NAME,
COLUMN_DATA
TYPE, COLUMN_LENGTH, COLUMN_SEQUENCE
from IICOLUMNS where TABLE_NAME= ~V order by COLUMN_SEQUENCE
      ::[3245            , 00788040]: Illegal instruction (SIGILL) @
PC 26e900 S
P 809d00 PSR 40901083 G1 30000 o0 29a400
      ::[3245            , 00788040]: Thu Nov 15 15:29:28 2007
E_OP0082_UNEXPECT
ED_EX   consistency check
    - unexpected exception occurred
 Associated error messages which provide more detailed information
about the pro
blem can be found in the INGRES error log, II_CONFIG:errlog.log
      ::[3245            , 00788040]: Fatal error in the following
session:
      ::[3245            , 00788040]: >>>>>Session 00788040<<<<<
      ::[3245            , 00788040]:     DB Name:
datadb                    (Own
ed by: datadbdba                 )
      ::[3245            , 00788040]:     User:
appuser                      (appuser
                  )
      ::[3245            , 00788040]:     Terminal: batch
      ::[3245            , 00788040]:     Group Id:
   Role Id:
      ::[3245            , 00788040]:     Application Code: 00000000
Current Facility: OPF (00000004)
      ::[3245            , 00788040]:     Activity: Optimizing Query
      ::[3245            , 00788040]:     Query: select COLUMN_NAME,
COLUMN_DATA
TYPE, COLUMN_LENGTH, COLUMN_SEQUENCE
from IICOLUMNS where TABLE_NAME= ~V order by COLUMN_SEQUENCE
      ::[3245            , 00788040]: Fatal error in the following
session:
      ::[3245            , 00788040]: >>>>>Session 00788040<<<<<
      ::[3245            , 00788040]:     DB Name:
datadb                    (Own
ed by: datadbdba                 )
      ::[3245            , 00788040]:     User:
appuser                      (appuser
                  )
      ::[3245            , 00788040]:     Terminal: batch
      ::[3245            , 00788040]:     Group Id:
   Role Id:
      ::[3245            , 00788040]:     Application Code: 00000000
Current Facility: OPF (00000004)
      ::[3245            , 00788040]:     Activity: Optimizing Query
      ::[3245            , 00788040]:     Query: select COLUMN_NAME,
COLUMN_DATA
TYPE, COLUMN_LENGTH, COLUMN_SEQUENCE
from IICOLUMNS where TABLE_NAME= ~V order by COLUMN_SEQUENCE
      ::[3245            , 00788040]: Illegal instruction (SIGILL) @
PC 26e900 S
P 809d00 PSR 40901084 G1 30000 o0 29a400
      ::[3245            , 00788040]: Thu Nov 15 15:29:28 2007
E_OP0082_UNEXPECT
ED_EX   consistency check
    - unexpected exception occurred
 Associated error messages which provide more detailed information
about the pro
blem can be found in the INGRES error log, II_CONFIG:errlog.log
      ::[3245            , 00788040]: Fatal error in the following
session:
      ::[3245            , 00788040]: >>>>>Session 00788040<<<<<
      ::[3245            , 00788040]:     DB Name:
datadb                    (Own
ed by: datadbdba                 )
      ::[3245            , 00788040]:     User:
appuser                      (appuser
                  )
      ::[3245            , 00788040]:     Terminal: batch
      ::[3245            , 00788040]:     Group Id:
   Role Id:
      ::[3245            , 00788040]:     Application Code: 00000000
Current Facility: OPF (00000004)
      ::[3245            , 00788040]:     Activity: Optimizing Query
      ::[3245            , 00788040]:     Query: select COLUMN_NAME,
COLUMN_DATA
TYPE, COLUMN_LENGTH, COLUMN_SEQUENCE
from IICOLUMNS where TABLE_NAME= ~V order by COLUMN_SEQUENCE