flyinweb_cu 发表于 2011-02-17 09:17

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

本帖最后由 flyinweb_cu 于 2011-02-17 09:50 编辑

Informix Dynamic Server 2000 Version 9.21.UC2   for LINUX

逻辑备份出现问题
2011-02-17 09:14:37 1129311291 /home/informix/bin/onbar_d -b -l
2011-02-17 09:14:38 1129311291 Begin backup logical log 149938.
2011-02-17 09:14:38 1129311291 Successfully connected to Storage Manager.
2011-02-17 09:14:38 1129311291 The logical logs are full.ON-Bar may encounter errors writing to
the sysutils database.
2011-02-17 09:14:38 1129311291 SQL   -691Missing key in referenced table for referential constraint (informix.r102_11).
2011-02-17 09:14:38 1129311291 ISAM   -111 ISAM error:no record found.
2011-02-17 09:14:38 1129311291 SQL   -691Missing key in referenced table for referential constraint (informix.r103_16).
2011-02-17 09:14:38 1129311291 ISAM   -111 ISAM error:no record found.
2011-02-17 09:14:38 1129311291 The logical logs are full.ON-Bar may encounter errors writing to
the sysutils database.
2011-02-17 09:14:38 1129311291 SQL   -691Missing key in referenced table for referential constraint (informix.r102_11).
2011-02-17 09:14:38 1129311291 ISAM   -111 ISAM error:no record found.
2011-02-17 09:14:38 1129311291 /home/informix/bin/onbar_d complete, returning 148 (0x94)

可能与先前的日志有关
2011-02-15 09:49:55 1729617294 /home/informix/bin/onbar_d -b -l                                                
2011-02-15 09:49:55 1729617294 Begin backup logical log 147643.                                                
2011-02-15 09:49:55 1729617294 Successfully connected to Storage Manager.                                    
2011-02-15 09:49:55 1729617294 SQL   -271Could not insert new row into the table.                        
2011-02-15 09:49:55 1729617294 ISAM   -131 ISAM error: no free disk space   

请求处理办法

liaosnet 发表于 2011-02-17 10:06

约束问题～

-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 发表于 2011-02-17 11:12

问题已经解决，rootdbs size只剩余13，经查。开发有几个表的索引建在rootdbs，删除了索引重建，逻辑日志备份恢复正常。
页: [1]
查看完整版本: [求助]Missing key in referenced table for referential constraint