ERROR OGG-01161 Bad column index (15) specified for table

简介:

错误信息:

GGSCI (haitaonode01) 02> info all
Program  Status   Group    Lag at Chkpt  Time Since Chkpt

MANAGER   RUNNING                              
REPLICAT   ABENDED    REPWH5     00:00:04     01:01:19   
GGSCI (haitaonode01) 03> view report repwh5

2017-08-21 17:38:26  ERROR   OGG-01161  Bad column index (15) specified for table UPCENTER.STK_LIST, max columns = 15.
***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
Reading /u01/gglog/wh000088, current RBA 36246367, 0 records
Report at 2017-08-21 17:38:26 (activity since 2017-08-21 17:38:26)


故障原因:

     主库和从UPCENTER.STK_LIST表结构不一至


解决方法:

     在从库UPCENTER.STK_LIST表添加字段,与主库一至就可以了










本文转自 z597011036 51CTO博客,原文链接:http://blog.51cto.com/tongcheng/1958112,如需转载请自行联系原作者
目录
相关文章
|
存储 SQL 关系型数据库
【MySQL异常】Row size too large (> 1982). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNA
【MySQL异常】Row size too large (> 1982). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNA
134 0
|
2月前
|
SQL 容灾 关系型数据库
PSQLException: ERROR: column “xxxxx“ does not exist
PSQLException: ERROR: column “xxxxx“ does not exist
77 0
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘thinkphp.test‘ don‘t exsit
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘thinkphp.test‘ don‘t exsit
319 0
|
关系型数据库 MySQL 数据库
View ‘information_schema.SCHEMATA‘ references invalid table(s) or column(s) or function(s) or define
View ‘information_schema.SCHEMATA‘ references invalid table(s) or column(s) or function(s) or define
228 0
|
SQL 关系型数据库 MySQL
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
732 0
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
|
SQL 关系型数据库 MySQL
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
1186 0
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
|
关系型数据库 MySQL 数据库
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
281 0
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
|
SQL
ORA-02292: integrity constraint (xxxx) violated - child record found
在更新表的主键字段或DELETE数据时,如果遇到ORA-02292: integrity constraint (xxxx) violated - child record found 这个是因为主外键关系,下面借助一个小列子来描述一下这个错误: SQL> create table studen...
2382 0