重建索引时报临时空间不足,但还有10G空间.求高手指点.
我把4000万的数据导入了一张新表.
在导入之前.我将所有约束都置失效,
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 DISABLED;
导入成功之后.
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 ENABLED;
打算把所有约束重建起来.
建了很久.都没有反应.查看日志.发现.报.
WARNING: Not enough temp space for parallel index build.
Space required = 7026482 pages; space available = 4954397 pages
临时表空间不足.
我有2个临时表空间.都有.10G.. 空间是足够的.可是为什么还会报.表空间不足了...求高手.帮忙....该如何是好?
数据库也没办法重起!!
报错如下:
19:42:26 WARNING: Not enough temp space for parallel index build.
Space required = 2163756 pages; space available = 2038818 pages.
Partial index build started.
20:34:37 Checkpoint Completed: duration was 0 seconds.
20:34:37 Fri Jun 15 - loguniq 110, logpos 0x3d85018, timestamp: 0xdc40bbc Interval: 1006
20:34:37 Maximum server connections 18
20:34:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 75, Llog used 52
21:54:37 Checkpoint Completed: duration was 1191 seconds.
21:54:37 Fri Jun 15 - loguniq 110, logpos 0x3daf038, timestamp: 0xde1790a Interval: 1007
21:54:37 Maximum server connections 18
21:54:37 Checkpoint Statistics - Avg. Txn Block Time 1192.118, # Txns blocked 3, Plog used 413, Llog used 42
在导入之前.我将所有约束都置失效,
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 DISABLED;
导入成功之后.
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 ENABLED;
打算把所有约束重建起来.
建了很久.都没有反应.查看日志.发现.报.
WARNING: Not enough temp space for parallel index build.
Space required = 7026482 pages; space available = 4954397 pages
临时表空间不足.
我有2个临时表空间.都有.10G.. 空间是足够的.可是为什么还会报.表空间不足了...求高手.帮忙....该如何是好?
数据库也没办法重起!!
报错如下:
19:42:26 WARNING: Not enough temp space for parallel index build.
Space required = 2163756 pages; space available = 2038818 pages.
Partial index build started.
20:34:37 Checkpoint Completed: duration was 0 seconds.
20:34:37 Fri Jun 15 - loguniq 110, logpos 0x3d85018, timestamp: 0xdc40bbc Interval: 1006
20:34:37 Maximum server connections 18
20:34:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 75, Llog used 52
21:54:37 Checkpoint Completed: duration was 1191 seconds.
21:54:37 Fri Jun 15 - loguniq 110, logpos 0x3daf038, timestamp: 0xde1790a Interval: 1007
21:54:37 Maximum server connections 18
21:54:37 Checkpoint Statistics - Avg. Txn Block Time 1192.118, # Txns blocked 3, Plog used 413, Llog used 42
15同行回答
回复 4# filvyo
VCPa scu/shy> onstat -d
IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 2 days 20:12:15 -- 2444392 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
cd5b1e88 1 0x60001 1 1 2048 N B informix rootdbs
cd5b2278 2 0x42001 5 1 2048 N TB informix tempdbs1
cd5b2410 3 0x42001 2 1 2048 N TB informix tempdbs2
cd5b25a8 4 0x40001 3 1 2048 N B informix phydbs
cd5b2740 5 0x40001 4 1 2048 N B informix logdbs
cd5b28d8 6 0x60001 6 9 2048 N B informix workdbs
cd5b2a70 7 0x40001 8 1 2048 N B informix admindbs
cf224e88 8 0x42001 16 1 2048 N TB informix tempdbs3
8 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
cd5b2028 1 1 0 15000 4705 PO-B /dev/vx/rdsk/vgdata/lvrootdbs
cd5b2c08 2 3 20 1024000 1021397 PO-B /dev/vx/rdsk/vgdata/lvtempdbs2
cd5b2df0 3 4 20 1024000 23947 PO-B /dev/vx/rdsk/vgdata/lvphydbs
ce7df028 4 5 20 2048000 1547947 PO-B /dev/vx/rdsk/vgdata/lvlogdbs
ce7df210 5 2 20 1024000 1021397 PO-B /dev/vx/rdsk/vgdata/lvtempdbs1
ce7df3f8 6 6 20 4096000 379324 PO-B /dev/vx/rdsk/vgdata/lvworkdbs1
ce7df5e0 7 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs2
ce7df7c8 8 7 32 1024000 1021825 PO-B /dev/vx/rdsk/vgdata/lvadmin
cf191ca0 9 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs3
cf1d5c98 10 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs4
cf224ca0 11 6 20 4096000 3071997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs5
cf1e0ca0 12 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs6
d04dadf8 13 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs7
d04dbc88 14 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs8
d04d9c88 15 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs9
cfef1d30 16 8 20 1024000 1023947 PO-B /dev/vx/rdsk/vgdata/lvtempdbs3
16 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always收起
VCPa scu/shy> onstat -d
IBM Informix Dynamic Server Version 11.10.FC2 -- On-Line -- Up 2 days 20:12:15 -- 2444392 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
cd5b1e88 1 0x60001 1 1 2048 N B informix rootdbs
cd5b2278 2 0x42001 5 1 2048 N TB informix tempdbs1
cd5b2410 3 0x42001 2 1 2048 N TB informix tempdbs2
cd5b25a8 4 0x40001 3 1 2048 N B informix phydbs
cd5b2740 5 0x40001 4 1 2048 N B informix logdbs
cd5b28d8 6 0x60001 6 9 2048 N B informix workdbs
cd5b2a70 7 0x40001 8 1 2048 N B informix admindbs
cf224e88 8 0x42001 16 1 2048 N TB informix tempdbs3
8 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
cd5b2028 1 1 0 15000 4705 PO-B /dev/vx/rdsk/vgdata/lvrootdbs
cd5b2c08 2 3 20 1024000 1021397 PO-B /dev/vx/rdsk/vgdata/lvtempdbs2
cd5b2df0 3 4 20 1024000 23947 PO-B /dev/vx/rdsk/vgdata/lvphydbs
ce7df028 4 5 20 2048000 1547947 PO-B /dev/vx/rdsk/vgdata/lvlogdbs
ce7df210 5 2 20 1024000 1021397 PO-B /dev/vx/rdsk/vgdata/lvtempdbs1
ce7df3f8 6 6 20 4096000 379324 PO-B /dev/vx/rdsk/vgdata/lvworkdbs1
ce7df5e0 7 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs2
ce7df7c8 8 7 32 1024000 1021825 PO-B /dev/vx/rdsk/vgdata/lvadmin
cf191ca0 9 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs3
cf1d5c98 10 6 20 4096000 511997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs4
cf224ca0 11 6 20 4096000 3071997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs5
cf1e0ca0 12 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs6
d04dadf8 13 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs7
d04dbc88 14 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs8
d04d9c88 15 6 20 4096000 4095997 PO-B /dev/vx/rdsk/vgdata/lvworkdbs9
cfef1d30 16 8 20 1024000 1023947 PO-B /dev/vx/rdsk/vgdata/lvtempdbs3
16 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always收起
浏览468