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,如需转载请自行联系原作者
目录
相关文章
|
1月前
|
SQL 关系型数据库 数据库
postgresql报:ERROR: column “i“ of relation “test“ does not exist LINE 1: UPDATE怎么解决?
解决“ERROR: column "i" of relation "test" does not exist”错误的关键在于核实列名的准确性,修正更新语句,确保列名的引用正确无误,并考虑到任何可能影响列名引用的表别名、大小写、特殊字符或动态SQL生成等因素。通过上述步骤,你应该能有效定位并解决问题,保证SQL语句的正确执行。
203 0
|
12月前
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
298 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
222 0
|
SQL 关系型数据库 MySQL
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
726 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
1143 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'
280 0
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'