SQLERR in 12.10
Posted in 2014
Folks,
Any comment on the following SQLERR . The instance is just converted from
11.50 FC8 with in-place upgrade.
Thanks
Frank
[informix@nsoopsdba101 etc]$ onstat -version
Program Name: onstat
Build Version: 12.10.FC4W1X1
Build Number: N028
Build Host: lxvm-l172
Build OS: Linux 2.6.18-128.el5
Build Date: Tue Sep 16 15:07:24 CDT 2014
Build Timestamp: 16-Sep-2014.14:53:46UTC-05
GLS Version: glslib-6.00.FC4
[informix@nsoopsdba101 etc]$
21:20:09 IBM Informix Dynamic Server Started.
21:20:09 Requested shared memory segment size rounded from 112316KB to
114076KB
21:20:09 Segment locked: addr=0x44000000, size=116813824
Mon Nov 3 21:20:11 2014
21:20:11 Requested shared memory segment size rounded from 4394676KB to
4394680KB
21:20:11 Segment locked: addr=0x18e7f7000, size=4500152320
21:20:14 Successfully added a bufferpool of page size 2K.
21:20:14 Requested shared memory segment size rounded from 1967996KB to
1968000KB
21:20:14 Segment locked: addr=0x29aba5000, size=2015232000
21:20:15 Successfully added a bufferpool of page size 8K.
21:20:15 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
permissions
21:20:15 Event alarms enabled. ALARMPROG =
'/usr/informix-1210/etc/alarmprogram.sh'
21:20:15 Booting Language <c> from module <>
21:20:15 Loading Module <CNULL>
21:20:15 Booting Language <builtin> from module <>
21:20:15 Loading Module <BUILTINNULL>
21:20:20 Affinitied VP 9 to phys proc 1
21:20:20 Affinitied VP 10 to phys proc 2
21:20:21 Affinitied VP 11 to phys proc 3
21:20:21 Affinitied VP 12 to phys proc 4
21:20:21 Affinitied VP 13 to phys proc 5
21:20:21 Affinitied VP 14 to phys proc 6
21:20:21 Affinitied VP 15 to phys proc 7
21:20:21 Affinitied VP 16 to phys proc 8
21:20:21 Affinitied VP 17 to phys proc 9
21:20:21 Affinitied VP 1 to phys proc 0
21:20:23 Trusted host cache successfully built:/etc/hosts.equiv.
21:20:23 Trusted host cache successfully
built:/usr/informix-1210/etc/hosts.equiv.
21:20:23 CCFLAGS2 value set to 0x200
21:20:23 SQL_FEAT_CTRL value set to 0x8008
21:20:23 SQL_DEF_CTRL value set to 0x4b0
21:20:23 DR: DRAUTO is 0 (Off)
21:20:23 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
21:20:23 Event notification facility epoll enabled.
21:20:23 IBM Informix Dynamic Server Version 12.10.FC4W1X1 Software Serial
Number AAA#B000000
21:20:25 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
21:20:25 Started 2 B-tree scanners.
21:20:25 B-tree scanner threshold set at 50000.
21:20:25 B-tree scanner range scan size set to -1.
21:20:25 B-tree scanner ALICE mode set to 6.
21:20:25 B-tree scanner index compression level set to med.
21:20:25 Physical Recovery Started at Page (63:768776).
21:20:25 Physical Recovery Complete: 6 Pages Examined, 6 Pages Restored.
21:20:25 Logical Recovery Started.
21:20:25 20 recovery worker threads will be started.
21:20:26 Logical Recovery has reached the transaction cleanup phase.
21:20:26 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
21:20:27 Dataskip is now OFF for all dbspaces
21:20:28 listener-thread: err = -27002: oserr = 0: errstr = : No
connections are allowed in quiescent mode.
21:20:28 The following internal statement failed
select g.gd_name, g.gd_id from grid_def g
SQLERR -206 ISAMERR -111
21:20:28 Can not rebuild grid query cache
21:20:28 The following internal statement failed
select a.shard_name, a.shard_id, a.flags, a.db, a.owner, a.table,a.shard_key, a.shard_version_col from shard a, shard_sync b where
a.shard_id = b.shard_id and b.state != 'F' order by a.shard_version desc
SQLERR -206 ISAMERR -111
21:20:29 (31) connection rejected - no calls allowed for sqlexec
21:20:29 Checkpoint Completed: duration was 1 seconds.
21:20:29 Mon Nov 3 - loguniq 145921, logpos 0xe950c0, timestamp:
0x3b1978fe Interval: 352002
21:20:29 Maximum server connections 0
21:20:29 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 68, Llog used 1
21:20:29 On-Line Mode
21:20:29 The following internal statement failed
select db, owner, table from'informix'.timeseries_virtual_tables_tab
SQLERR -206 ISAMERR -111
21:20:29 CDR catalog version mismatch
21:20:30 SCHAPI: Started dbScheduler thread.
21:20:31 Booting Language <spl> from module <>
21:20:31 Loading Module <SPLNULL>
21:20:31 Auto Registration is synced
21:20:31 SCHAPI: Started 2 dbWorker threads.
21:20:32 Defragmenter cleaner thread now running
21:20:32 Defragmenter cleaner thread cleaned:0 partitions
21:21:30 Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
21:21:30 The C Language Module
</usr/informix-1210/extend/ifxmngr/ifxmngr.bld> loaded
--001a113a970ad942290506fb016a