Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / Informix [игнор отключен] [закрыт для гостей] / IDS 10.00.TC3TL / 7 сообщений из 7, страница 1 из 1
21.03.2006, 16:16
    #33614832
ontape
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
Win2K SP4
IDS 10.00.TC3TL

Решил посмотреть на генераторы последовательностей

create view dual (x) as
select 1 from "informix".systables x0 where (x0.tabid = 100);

create sequence seq_docid;

Запрос
select seq_docid.nextval from dual

воспроизводимо генерит эксцепшн

В общем, осадочек остался :(

Где что поправить ?

Заранее благодарен.

Exception happened at address=0x004ed780
Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
Attempt to read location 0x64
Register Contents:
EAX=0x00000064 ESI=0x01c30048 EFLAGS=0x00010202
EBX=0x2dfcfb28 EDI=0x00020000 EIP=0x004ed780
ECX=0x2dfccb18 ESP=0x2df3e22c
EDX=0x00000064 EBP=0x2df3e274
Call Stack for thread #44 - sqlexec
0x004ed780 (oninit)_walkvexpr (0x2dfccb18, 0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28) ebp=0x2df3e274
0x004edfd6 (oninit)_walkvexpr (0x2dfcc83c, 0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28) ebp=0x2df3e2dc
0x004ee01f (oninit)_walkvexpr (0x2dfceb38, 0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28) ebp=0x2df3e344
0x004edfd6 (oninit)_walkvexpr (0x2dfcfeac, 0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28) ebp=0x2df3e3ac
0x004ee01f (oninit)_walkvexpr (0x2dfceccc, 0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28) ebp=0x2df3e414
0x004ecc48 (oninit)_walkvcb (0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28, 0x0) ebp=0x2df3e480
0x004eae6e (oninit)_process_view_colltbl_expr (0x2dfcfb28, 0x2dfe5078, 0x2dfcfce8, 0x2df3e550) ebp=0x2df3e4f4
0x004ec4a5 (oninit)_processview (0x2dfcfb28, 0x2, 0x2df3e550, 0x2dfcfce8) ebp=0x2df3e530
0x00722b6e (oninit)_foldviews (0x2dfcfb28, 0x20000, 0x1c30048, 0x2dfcfb28) ebp=0x2df3e56c
0x0047cd64 (oninit)_sqoptim (0x2dfcfb28, 0x0, 0x2dac02e0, 0x2da3e8ce) ebp=0x2df3e6c4
0x004c8f43 (oninit)_bldstructs (0x2dfcfb28, 0x2df3e6f8, 0x0, 0x2) ebp=0x2df3e6e4
0x004c8d7c (oninit)_sqcmd (0x0, 0x0, 0x0, 0x0) ebp=0x2df3e708
0x004c86d2 (oninit)_sq_cmnd (0x2, 0x2df3e7e0, 0x4a2d74, 0x2da68158) ebp=0x2df3e728
0x004c8745 (oninit)_sq_prepare (0x2da68158, 0x0, 0x2, 0x74636f73) ebp=0x2df3e734
0x004a2d74 (oninit)_sqmain (0x2d7fbad2, 0x0, 0x1c30048, 0x0) ebp=0x2df3e7e0
0x00ae93e7 (oninit)_listen_verify (0x0, 0x2d9fdec0, 0x0, 0x61676576) ebp=0x2df3ea54
0x00ae8936 (oninit)_spawn_thread (0x0, 0x0, 0x0, 0x0) ebp=0x2df3efbc
0x00acd914 (oninit)_startup (0xf, 0x2df40518, 0x2dd55fc0, 0x1518) ebp=0x2df3eff8
Frame Pointer is NULL!
Unable to continue stack trace back
14:45:06
14:45:06 IBM Informix Dynamic Server Version 10.00.TC3TL Software Serial Number AAA#B000000

14:45:06 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
14:45:06 Who: Session(5, informix@ontape.card.dnepr.com, 2780, 00000000)
Thread(44, sqlexec, 0, 4)
File: mtex.c Line: 929
14:45:06 Action: Please notify IBM Informix Technical Support.
14:45:06 Stack for thread: 44 sqlexec

base: 0x2df1e000
len: 135168
pc: 0x00ab55dc
tos: 0x2df3d740
state: running
vp: 4

0x00ab4e49 (oninit)_afhandler(0x2, 0x2df3dd44, 0x0, 0x2d864e20)
0x00ab48fe (oninit)_affail_interface(0x2df3dd44, 0x0, 0x2d864e20, 0x0)
0x00ac6ff9 (oninit)_NT_mt_excep_filter(0x2df3de78, 0x1, 0xc3f5d3, 0x2df3de80)
0x00acd927 (oninit)_startup(0xf, 0x2df40518, 0x2dd55fc0, 0x1518)
0x00000000 (*nosymtab*)0x0


14:45:07 See Also: d:\Informix\tmp\af.414f551, shmem.414f551.0

===========------------- - - - - - -
onstat -m:

IBM Informix Dynamic Server Version 10.00.TC3TL -- On-Line -- Up 00:03:29 -- 808640 Kbytes

Message Log File: d:\Informix\log\ol_cardbase.log
14:41:53 Checkpoint Completed: duration was 1 seconds.
14:41:53 Checkpoint loguniq 104, logpos 0x2021018, timestamp: 0x30c8fbe7

14:41:53 Maximum server connections 0
14:41:53 Init operation complete - Mode Online
14:41:53 On-Line Mode
14:42:22 Checkpoint Completed: duration was 0 seconds.
14:42:22 Checkpoint loguniq 104, logpos 0x2022018, timestamp: 0x30c8fbf4

14:42:22 Maximum server connections 0
14:45:06 Assert Failed: NT Exception!
14:45:06 See Also: d:\Informix\tmp\af.414f551
14:45:06 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
14:45:06 IBM Informix Dynamic Server Version 10.00.TC3TL
14:45:06 Who: Session(5, informix@ontape.card.dnepr.com, 2780, 00000000)
Thread(44, sqlexec, 0, 4)
File: mtex.c Line: 929
14:45:06 Action: Please notify IBM Informix Technical Support.
14:45:06 stack trace for pid 1980 written to d:\Informix\tmp\af.414f551
14:45:07 See Also: d:\Informix\tmp\af.414f551, shmem.414f551.0

===========------------- - - - - - -
d:\Informix\bin\onstat -g ath: 44

IBM Informix Dynamic Server Version 10.00.TC3TL -- On-Line -- Up 00:03:29 -- 808640 Kbytes

Threads:
tid tcb rstcb prty status vp-class name
2 2d952148 0 2 sleeping forever 6lio lio vp 0
3 2d979148 0 2 sleeping forever 7pio pio vp 0
4 2d993148 0 2 sleeping forever 8aio aio vp 0
5 2d9ad148 0 2 sleeping forever 9msc msc vp 0
6 2d9e3148 0 2 sleeping forever 10aio aio vp 1
7 2d9fd148 0 2 sleeping forever 11aio aio vp 2
8 2da17148 0 2 sleeping forever 12aio aio vp 3
9 2da313a8 2d7f8018 4 sleeping secs: 1 1cpu main_loop()
10 2d9794c0 0 2 running 13soc soctcppoll
11 2da74b28 0 2 running 14soc soctcpio
12 2da94ad0 0 3 sleeping forever 3cpu soctcplst
13 2d979990 2d7f8520 2 sleeping forever 1cpu flush_sub(0)
14 2d979b50 2d7f8a28 2 sleeping forever 5cpu flush_sub(1)
15 2d979d10 2d7f8f30 2 sleeping forever 5cpu flush_sub(2)
16 2d979ed0 2d7f9438 2 sleeping forever 5cpu flush_sub(3)
17 2d993380 2d7f9940 2 sleeping forever 5cpu flush_sub(4)
18 2d993540 2d7f9e48 2 sleeping forever 5cpu flush_sub(5)
19 2d993700 2d7fa350 2 sleeping forever 5cpu flush_sub(6)
20 2d9938c0 2d7fa858 2 sleeping forever 5cpu flush_sub(7)
21 2d993ad8 0 4 sleeping forever 5cpu kaio
22 2d9e3620 2d7fad60 3 sleeping forever 5cpu aslogflush
23 2d9e3c58 2d7fb268 1 sleeping secs: 33 3cpu btscanner 0
25 2d9fd7e0 0 4 sleeping forever 1cpu kaio
40 2d9fd698 2d7fc180 4 sleeping secs: 1 1cpu onmode_mon
43 2da17380 2d7fbc78 2 cond wait bp_cond 1cpu bf_priosweep()
44 2d9fdec0 2d7fb770 2 running 4cpu sqlexec
45 2d9558b0 0 4 sleeping forever 4cpu kaio

===========------------- - - - - - -
d:\Informix\bin\onstat -g stk 44 light:

IBM Informix Dynamic Server Version 10.00.TC3TL -- On-Line -- Up 00:03:29 -- 808640 Kbytes

Stack for thread: 44 sqlexec
base: 0x2df1e000
len: 135168
pc: 0x00aa5e04
tos: 0x2df3d6c0
state: running
vp: 4

0x0000002c (*nosymtab*)0x2c(0x2df3d760, 0x7c57b3db, 0xe4, 0xa)
0xffffffff (*nosymtab*)0xffffffff

===========------------- - - - - - -
d:\Informix\bin\onstat -g ses 5:

IBM Informix Dynamic Server Version 10.00.TC3TL -- On-Line -- Up 00:03:30 -- 808640 Kbytes

session #RSAM total used dynamic
id user tty pid hostname threads memory memory explain
5 informix ONTAPE 2780 ontape 1 503808 461096 off

tid name rstcb flags curstk status
44 sqlexec 2d7fb770 ---P--- 6464 running

Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
5 V 2dabe020 503808 42712 621 59

name free used name free used
overhead 0 1648 mtmisc 0 176
scb 0 144 opentable 0 16200
filetable 0 2128 misc 0 168
log 0 23928 temprec 0 16200
blob 0 720 keys 0 1696
ralloc 0 347128 gentcb 0 1224
ostcb 0 2544 sort 0 56
sqscb 0 17872 sql 0 40
rdahead 0 160 hashfiletab 0 280
osenv 0 1416 buft_buffer 0 16736
sqtcb 0 6984 fragman 0 2720
sapi 0 32 udr 0 896

sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind directives
2da3e830 2dabf018 0 0 0 2 1

Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
5 SELECT hostcard NL Not Wait 0 0 9.03 Off

Current SQL statement :
select seq_docid.nextval from dual

Last parsed SQL statement :
select seq_docid.nextval from dual

d:\Informix\bin\onstat -c:

IBM Informix Dynamic Server Version 10.00.TC3TL -- On-Line -- Up 00:03:30 -- 808640 Kbytes

Configuration File: d:\Informix/etc/ONCONFIG.ol_cardbase
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH D:\IFMXDATA\ol_cardbase\spin0\rootdbs.dat # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 512000 # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

# Physical Log Configuration
PHYSDBS physdbs # Location (dbspace) of physical log
PHYSFILE 250000 # Physical log file size (Kbytes)

# Logical Log Configuration
LOGFILES 50 # Number of logical log files
LOGSIZE 40000 # Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)

# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment DBCREATE_PERMISSON to
# limit database creation to a specific user. Add a new DBCREATE_PERMISSION
# line for each permitted user.

#DBCREATE_PERMISSION informix

# IFX_EXTEND_ROLE:
# 0 => Disable use of EXTEND role to control who can register
# external routines. This is the default behaviour.
# 1 => Enable use of EXTEND role to control who can register
# external routines.

IFX_EXTEND_ROLE 0 # To control the usage of EXTEND role.

# Diagnostics

MSGPATH d:\Informix\log\ol_cardbase.log # System message log file path
CONSOLE d:\Informix\log\conol_cardbase.log # System console message path

# To automatically backup logical logs, edit alarmprogram.bat and set
# BACKUPLOGS=Y
ALARMPROGRAM d:\Informix\etc\alarmprogram.bat # Alarm program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur
TBLSPACE_STATS 1 # Maintain tblspace statistics


# System Diagnostic Script.
# SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
# c:\informix\etc\evidence.bat.) Set this parameter
# if you want a different Diagnostic Script than
# {INFORMIXDIR}\etc\evidence.bat, which is default.

# System Archive Tape Device

#TAPEDEV \\.\TAPE0 # Tape device path
TAPEDEV nul # Tape device path
#TAPEDEV D:\IFMXBKUP\ol_cardbase\IfmxDATA.bak
TAPEBLK 64 # Tape block size (Kbytes)
TAPESIZE 33554432 # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

#LTAPEDEV nul # Log tape device path
LTAPEDEV D:\IFMXBKUP\ol_cardbase\IfmxLOGS.bak
LTAPEBLK 64 # Log tape block size (Kbytes)
LTAPESIZE 33554432 # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB # Informix Dynamic Server/Optical staging area

# System Configuration

SERVERNUM 0 # Unique id corresponding to a server instance
DBSERVERNAME ol_cardbase # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE onsoctcp,1,,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

VPCLASS cpu,num=4,max=8,aff=1-4
VPCLASS aio,num=4

# Shared Memory Parameters

LOCKS 204800 # Maximum number of locks
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0xC000000L # Shared memory base address
SHMVIRTSIZE 262144 # initial virtual shared memory segment size
SHMADD 65536 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 128 # Stack size (Kbytes)

# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
#
# In case of system configured with CDR, the difference between LTXHWM and
# LTXEHWM should be atleast 30% so that we could minimize log overrun issue.

DYNAMIC_LOGS 2
LTXHWM 50
LTXEHWM 60

# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
# To determine the page size used by Dynamic Server on your platform
# see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND \tmp # DR lost+found file path
DRIDXAUTO 0 # DR automatic index repair. 0=off, 1=on

# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL 0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces

# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
# 0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.

CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default

# Backup/Restore variables
BAR_ACT_LOG d:\Informix\log\bar_ol_cardbase.log #Path of log file for onbar.exe
BAR_DEBUG_LOG d:\Informix\log\bar_ol_cardbase.log #Path of the debug log for onbar.exe
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 15
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH d:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL

RESTARTABLE_RESTORE ON #To support restartable restore..values on/off

# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP temp1,temp2,temp3,temp4 # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR d:\Informix\tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic Server)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session

FILLFACTOR 90 # Fill factor for building indexes

# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DS_NONPDQ_QUERY_MEM 128 # Non PDQ query memory (Kbytes)
DATASKIP # List of dbspaces to skip

# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer

DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)

ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0

SBSPACENAME sbspace # Default sbspace
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME sbspace # Default System sbspace
# Server. This is used primarily for Informix Server
# system statistics collection.

BLOCKTIMEOUT 3600 # Default timeout for system block

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1

ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)

#
# The following are default settings for enabling Java in the database.
#

#VPCLASS jvp,num=1 # Number of JVPs to start with

JVPJAVAHOME d:\Informix\extend\krakatoa\jre # JDK installation root directory
JVPHOME d:\Informix\extend\krakatoa # Krakatoa installation directory

JVPLOGFILE d:\Informix\extend\krakatoa\ol_cardbase_jvp.log # VP log file
JVPPROPFILE d:\Informix\extend\krakatoa\.jvpprops_ol_cardbase # JVP property file

JDKVERSION 1.4 # JDK version supported by this server

# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB \bin\

JVPJAVAVM jsig;dbgmalloc;hpi;jvm;java;net;zip;jpeg

# Classpath to use upon Java VM start-up (use _g version for debugging)
JVPCLASSPATH d:\Informix\extend\krakatoa\krakatoa.jar;d:\Informix\extend\krakatoa\jdbc.jar

#Following parameters are realted to the buffer pool
BUFFERPOOL default,buffers=256000,lrus=127,lru_min_dirty=25.000000,lru_max_dirty=30.000000
BUFFERPOOL size=4K,buffers=128000,lrus=127,lru_min_dirty=25.000000,lru_max_dirty=30.000000

#Create Index Online Shared Memory usage limitation
ONLIDX_MAXMEM 5120 # Per pool per index (Kbytes)

#Timeout for client connection request
LISTEN_TIMEOUT 10 # Timeout (in Seconds)

#Following are the deprecated configuration parameters, instead of these
#use BUFFERPOOL configuration parameter
#BUFFERS, LRUS, LRU_MIN_DIRTY, LRU_MAX_DIRTY
...
Рейтинг: 0 / 0
21.03.2006, 19:32
    #33615462
Выбегалло
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
Воспроизводится на 9.4, не воспроизводится если вместо view использовать "from systables where tabid = 100". Явный баг, af возникает в момент раскручивания view оптимизатором ( _process_view_colltbl_expr ). Засабмитить бы надо, хотя бы в c.d.i

В таком вот аксепте
...
Рейтинг: 0 / 0
22.03.2006, 09:46
    #33616129
ontape
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
Спасибо.
Появится саппорт, сразу же и пожурю :)
...
Рейтинг: 0 / 0
23.03.2006, 21:26
    #33621812
Выбегалло
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
ontapeСпасибо.
Появится саппорт, сразу же и пожурю :)

Кинул в c.d.i. , там иногда народ из саппорта пасется.
...
Рейтинг: 0 / 0
23.03.2006, 23:01
    #33621935
Выбегалло
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
Получил ответ :

Hi,
You are hitting a known problem, bug number 174914.
174914 - SELECTING FROM A SEQUENCE IN A VIEW CAUSES ASSERTION FAILURE
This is fixed in 9.40.UC8.
Nita Dembla
---------

В таком вот аксепте
...
Рейтинг: 0 / 0
24.03.2006, 10:01
    #33622441
ontape
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
Замечательно. А про 10-ку ничего не говорили ?
А то в 10.00.TC4E эта дырка STILL OPEN :(
...
Рейтинг: 0 / 0
24.03.2006, 19:19
    #33624581
Выбегалло
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
IDS 10.00.TC3TL
ontapeЗамечательно. А про 10-ку ничего не говорили ?
А то в 10.00.TC4E эта дырка STILL OPEN :(

а новее нету. так шта не пофиксили еще, значит.
...
Рейтинг: 0 / 0
Форумы / Informix [игнор отключен] [закрыт для гостей] / IDS 10.00.TC3TL / 7 сообщений из 7, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]