IQ 遷移object導致的血案 - sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 - 2
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 資料庫不同步,需要手工同步並開啟。
----------------
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部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-2144663/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- IQ 遷移object導致的血案 - sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 - 3ObjectExceptionSQL
- IQ 遷移object導致的血案 - sp_mpxprocesstlvlog exception, SQLSTATE=QSA44 - 1ObjectExceptionSQL
- goldengate命令輸入錯誤導致的血案2Go
- ORACLE 分割槽索引UNUSABLE導致的DML操作失敗引起的血案Oracle索引
- Larabel遷移檔案時報SQLSTATE[42000]錯誤的解決方法SQL
- mysql 目錄遷移導致無法找到relay log 解決辦法。MySql
- Android 巢狀佈局導致的Exception: java.lang.ClassCastExceptionAndroid巢狀ExceptionJavaAST
- truncate操作導致DATA_OBJECT_ID改變Object
- V2P 的遷移
- WSL2遷移
- 【MySQL】AppArmor導致datadir遷移無法啟動&初始化失敗MySqlAPP
- ESXI 遷移至KVM (V2V遷移)
- 分析機構Gartner認為組織加快雲遷移將導致公共雲支出激增
- 11.2使用KEEP池導致ENQ: KO - Fast Object Checkpoint等待ENQASTObject
- Dart 2 Web 應用遷移指南DartWeb
- 控制檔案不一致引發的“血案”
- KVM線上遷移(動態遷移)
- 6- ABC遷移大資料2大資料
- J2EE中間層遷移
- Azure ASM到ARM遷移 (三) Reserved IP的遷移ASM
- Laravel5.4 資料庫遷移錯誤 SQLSTATE [42000] Syntax error or access violation 1071Laravel資料庫SQLError
- virt-v2v工具自動遷移vmware遷移至kvm
- Laravel5.x的php artisan migrate資料庫遷移建立操作報錯SQLSTATE[42000]解決LaravelPHP資料庫SQL
- 【遷移】使用rman遷移資料庫資料庫
- Codable 的遷移方案
- docker 映象的遷移Docker
- Web Server的遷移WebServer
- 資料的遷移
- 【Mysql】JDB2導致磁碟io使用率高 導致mysql延遲過高MySqlDB2
- mongodb資料遷移2種方式比較MongoDB
- 遷移 Vue v2.x 版本到 ViteVueVite
- 遷移公告
- CCU遷移
- 棧遷移
- 【DB2學習】遷移資料之EXPROTDB2
- 專案遷移的思考
- 雲遷移的安全風險
- 清除行遷移的例子