[求助]Missing key in referenced table for referential constraint

flyinweb_cu

Informix Dynamic Server 2000 Version 9.21.UC2   for LINUX

逻辑备份出现问题
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)

可能与先前的日志有关
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     

请求处理办法

liaosnet

约束问题～

-691
--------------------------------------------------------------------------------

Missing key in referenced table for referential constraint constraint-name.

A referential constraint has been violated. This condition usually occurs when you are trying to insert a value into or update the value of a column that is part of a referential constraint. The value you are trying to enter does not exist in the referenced (parent-key) column. If you are using cascading deletes, database logging must be on.

flyinweb_cu

问题已经解决，rootdbs size只剩余13，经查。开发有几个表的索引建在rootdbs，删除了索引重建，逻辑日志备份恢复正常。