且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

IQ 迁移object导致的血案 - sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 - 2

更新时间:2022-09-06 22:47:55

iqdm.iqmsg 

---------------- 
I. 09/07 14:48:05. 0000000006    O/S Err#: 0, ErrID: 2094 (s_readexception); SQLCode: -1009044, SQLState: 'QSA44', Severity: 23
I. 09/07 14:48:05. 0000000006 [20065]: An IO error was encountered while reading a database page in INVALID_DBSPACE DBSpace. Please check your IQ message file for additional information.
-- (slib/s_blockmap.cxx 5782)
I. 09/07 14:48:05. 0000000006 sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 [An IO error was encountered while reading a database page in INVALID_DBSPACE DBSpace. Please check your IQ message file for additional information.
-- (slib/s_blockmap.cxx 5782) ] runstate=S(1)
I. 09/07 14:48:05. 0000000006 ***Emergency Shutdown***
I. 09/07 14:48:05. 0000000006 Exception Thrown from dblib/db_iqutility.cxx:4513, Err# 46, tid 6 origtid 6
I. 09/07 14:48:05. 0000000006    O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
I. 09/07 14:48:05. 0000000006 [21051]: Secondary server cannot maintain catalog sync.
-- (dblib/db_iqutility.cxx 4513)
....  
I. 09/07 14:48:07. 0000000000 CloseDatabase
Already at oldest change                                     

8. 显然提示是catalog 数据库不同步,需要手工同步并开启。
本文转自ITPUB博客tolywang的博客,原文链接:IQ 迁移object导致的血案 - sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 - 2,如需转载请自行联系原博主。