标签归档:-131

rootdbs空间不足引起的备份失败

症状1:

Informix Dynamic Server 2000 Version 9.21.UC2 for LINUX

2011-02-15 09:49:55 17296 17294 /home/informix/bin/onbar_d -b -l
2011-02-15 09:49:55 17296 17294 Begin backup logical log 147643.
2011-02-15 09:49:55 17296 17294 Successfully connected to Storage Manager.
2011-02-15 09:49:55 17296 17294 SQL -271 Could not insert new row into the table.
2011-02-15 09:49:55 17296 17294 ISAM -131 ISAM error: no free disk space
逻辑备份出现问题
2011-02-17 09:14:37 11293 11291 /home/informix/bin/onbar_d -b -l
2011-02-17 09:14:38 11293 11291 Begin backup logical log 149938.
2011-02-17 09:14:38 11293 11291 Successfully connected to Storage Manager.
2011-02-17 09:14:38 11293 11291 The logical logs are full. ON-Bar may encounter errors writing to the sysutils database.
2011-02-17 09:14:38 11293 11291 SQL -691 Missing key in referenced table for referential constraint (informix.r102_11).
2011-02-17 09:14:38 11293 11291 ISAM -111 ISAM error: no record found.
2011-02-17 09:14:38 11293 11291 SQL -691 Missing key in referenced table for referential constraint (informix.r103_16).
2011-02-17 09:14:38 11293 11291 ISAM -111 ISAM error: no record found.
2011-02-17 09:14:38 11293 11291 The logical logs are full. ON-Bar may encounter errors writing to the sysutils database.
2011-02-17 09:14:38 11293 11291 SQL -691 Missing key in referenced table for referential constraint (informix.r102_11).
2011-02-17 09:14:38 11293 11291 ISAM -111 ISAM error: no record found.
2011-02-17 09:14:38 11293 11291 /home/informix/bin/onbar_d complete, returning 148 (0x94)

经onstat -d 查询,rootdbs空间不足,而rootdbs中有被人创建了其它库表索引(估计语句中没有指定dbspace导致),清理这些索引以增加剩余空间恢复正常备份或者为rootdbs添加chunk亦可 继续阅读