问题：数据库连接报错

NISBack.cocatalogdb ERABUE‡H. RARI#.png
RE THE WY HE. FE O NU.png

问题解决：

1、替换数据库：

是在与旧会话相同的位置创建一个新会话
https://imagealchemist.net/fix-a-corrupt-session-file/
1.1 拷贝源文件NIS.cocatalog（整个文件）为NIS_back.cocatalog，
1.2 新建目录NIS，拷贝NIS.cocatalog到新文件，删除，可以打开，但仍然报错
Downloads.png

2、仍然报错：

#NIA, NISERLAXN.png

3、打开后逞着没报错之前手动修复文件错误

4、手动修复文件错误：

您的急救措施是从File 菜单 > Verify Catalog or Session运行验证。浏览到会话数据库文件并打开它。它将发现相同的错误并提供修复它的选项。

  1. 已与数据库建立连接
  2. /Volumes/CHY_2T_NVME/C1/NIS.cocatalog/NIS.cocatalogdb
  5. 数据库连接 好
  8. 验证数据库...Checking database integrity
  9. *** in database main ***
  10. Main freelist: size is 152 but should be 121
  11. row 34 missing from index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  12. row 35 missing from index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  13. row 35 missing from index ZSELECTEDVARIANTS_ZSELECTEDINCOLLECTIONS_INDEX
  14. wrong # of entries in index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  15. wrong # of entries in index ZSELECTEDVARIANTS_ZSELECTEDINCOLLECTIONS_INDEX
  16. Integrity failure
  17. The database failed verification.
  18. The database failed a full verification check.
  21. 数据库验证 失败
  24. 验证数据库...Checking database integrity
  25. *** in database main ***
  26. Main freelist: size is 152 but should be 121
  27. row 34 missing from index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  28. row 35 missing from index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  29. row 35 missing from index ZSELECTEDVARIANTS_ZSELECTEDINCOLLECTIONS_INDEX
  30. wrong # of entries in index ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX
  31. wrong # of entries in index ZSELECTEDVARIANTS_ZSELECTEDINCOLLECTIONS_INDEX
  32. Integrity failure
  33. The database failed verification.
  34. The database failed a full verification check.
  37. 数据库验证 失败
  40. 修复数据库…Creating backup
  41. Commencing database transfer
  42. Transfer in progress
  43. Transfer complete
  44. Backup complete
  45. Fixing: Integrity failure
  46. Preparing to rebuild 
  47. Rebuilding the database
  48. Extracting data from database
  49. Extracting 1 rows for ZDOCUMENTCONTENT
  50. Extracting 1 rows for ZVERSIONINFO
  51. Extracting 45 rows for ZENTITIES
  52. Extracting 1 rows for ZCAPTUREPILOT
  53. Extracting 83 rows for ZCOLLECTION
  54. Extracting 1 rows for ZENABLEDOUTPUTRECIPE
  55. Extracting 0 rows for ZKEYWORD
  56. Extracting 7131 rows for ZIMAGE
  57. Extracting 8864 rows for ZIMAGEINCOLLECTION
  58. Extracting 161 rows for ZIMAGEINCOLLECTIONPROPERTIES
  59. Extracting 16 rows for ZPATHLOCATION
  60. Extracting 404 rows for ZPROCESSHISTORY
  61. Extracting 34 rows for ZSELECTEDVARIANTS
  62. Extracting 0 rows for ZSIDECAR
  63. Extracting 7131 rows for ZVARIANT
  64. Extracting 21624 rows for ZVARIANTLAYER
  65. Extracting 21393 rows for ZVARIANTMETADATA
  66. Extracting 0 rows for ZDOCUMENTSETTING
  67. Extracting auxiliary data
  68. Data extraction complete
  69. Preparing to reconnect with the rebuilt database
  70. Moving the rebuilt database in place
  71. Re-opening the database connection
  72. Database rebuilt OK
  73. Integrity error fixer finished
  74. Fixing Complete
  75. Checking database integrity
  76. Database integrity OK
  77. Checking database structure
  78. Checking database structure: tables
  79. Checking database structure: tables structure
  80. Checking database table 'ZCAPTUREPILOT' structure.
  81. Checking database table 'ZCOLLECTION' structure.
  82. Checking database table 'ZDOCUMENTCONTENT' structure.
  83. Checking database table 'ZDOCUMENTSETTING' structure.
  84. Checking database table 'ZENABLEDOUTPUTRECIPE' structure.
  85. Checking database table 'ZENTITIES' structure.
  86. Checking database table 'ZIMAGE' structure.
  87. Checking database table 'ZIMAGEINCOLLECTION' structure.
  88. Checking database table 'ZIMAGEINCOLLECTIONPROPERTIES' structure.
  89. Checking database table 'ZKEYWORD' structure.
  90. Checking database table 'ZPATHLOCATION' structure.
  91. Checking database table 'ZPROCESSHISTORY' structure.
  92. Checking database table 'ZSELECTEDVARIANTS' structure.
  93. Checking database table 'ZSIDECAR' structure.
  94. Checking database table 'ZVARIANT' structure.
  95. Checking database table 'ZVARIANTLAYER' structure.
  96. Checking database table 'ZVARIANTMETADATA' structure.
  97. Checking database table 'ZVERSIONINFO' structure.
  98. Checking database structure: triggers
  99. Checking database structure: indexes
  100. Database structure OK
  101. Checking database content
  102. Checking document type
  103. Checking document type done
  104. Checking document UUID
  105. Checking document UUID done
  106. Checking document selected collection
  107. Checking document selected collection done
  108. Checking collections locations
  109. Checking collections locations done
  110. Checking Collections relationships
  111. Checking Collections relationships done
  112. Checking Capture Pilot settings
  113. Checking Capture Pilot settings done
  114. Checking layer ordering values
  115. Checking layer ordering values done
  116. Checking layer for missing metadata
  117. Checking layer for missing metadata done
  118. Checking metadata for missing layers
  119. Checking metadata for missing layers done
  120. Checking variant relationships
  121. Checking variant relationships done
  122. Checking image variant relationships
  123. Checking image variant relationships done
  124. Checking variant image relationships
  125. Checking variant image relationships done
  126. Checking local adjustment layer UUIDs
  127. Checking local adjustment layer UUIDs done
  128. Checking style adjustment layer UUIDs
  129. Checking style adjustment layer UUIDs done
  130. Checking validity of variant indices
  131. Checking uniqueness of variant indices
  132. Checking for duplicate catalog folder collections
  133. Checking for duplicate catalog folder collections done
  134. Checking missing catalog folder collections
  135. Checking missing catalog folder collections done
  136. Checking for catalog folder collections without a project
  137. Checking for catalog folder collections without a project done
  138. Checking for mismatched catalog folder <-> image links
  139. Checking for mismatched catalog folder <-> image links done
  140. Checking catalog folder links
  141. Checking catalog folder links done
  142. Checking image relationships
  143. Checking image relationships done
  144. Checking sidecar entities
  145. Checking sidecar entities done
  146. Database content OK
  147. Checking database integrity
  148. Database integrity OK
  149. Checking database structure
  150. Checking database structure: tables
  151. Checking database structure: tables structure
  152. Checking database table 'ZCAPTUREPILOT' structure.
  153. Checking database table 'ZCOLLECTION' structure.
  154. Checking database table 'ZDOCUMENTCONTENT' structure.
  155. Checking database table 'ZDOCUMENTSETTING' structure.
  156. Checking database table 'ZENABLEDOUTPUTRECIPE' structure.
  157. Checking database table 'ZENTITIES' structure.
  158. Checking database table 'ZIMAGE' structure.
  159. Checking database table 'ZIMAGEINCOLLECTION' structure.
  160. Checking database table 'ZIMAGEINCOLLECTIONPROPERTIES' structure.
  161. Checking database table 'ZKEYWORD' structure.
  162. Checking database table 'ZPATHLOCATION' structure.
  163. Checking database table 'ZPROCESSHISTORY' structure.
  164. Checking database table 'ZSELECTEDVARIANTS' structure.
  165. Checking database table 'ZSIDECAR' structure.
  166. Checking database table 'ZVARIANT' structure.
  167. Checking database table 'ZVARIANTLAYER' structure.
  168. Checking database table 'ZVARIANTMETADATA' structure.
  169. Checking database table 'ZVERSIONINFO' structure.
  170. Checking database structure: triggers
  171. Checking database structure: indexes
  172. Database structure OK
  173. Checking database content
  174. Checking document type
  175. Checking document type done
  176. Checking document UUID
  177. Checking document UUID done
  178. Checking document selected collection
  179. Checking document selected collection done
  180. Checking collections locations
  181. Checking collections locations done
  182. Checking Collections relationships
  183. Checking Collections relationships done
  184. Checking Capture Pilot settings
  185. Checking Capture Pilot settings done
  186. Checking layer ordering values
  187. Checking layer ordering values done
  188. Checking layer for missing metadata
  189. Checking layer for missing metadata done
  190. Checking metadata for missing layers
  191. Checking metadata for missing layers done
  192. Checking variant relationships
  193. Checking variant relationships done
  194. Checking image variant relationships
  195. Checking image variant relationships done
  196. Checking variant image relationships
  197. Checking variant image relationships done
  198. Checking local adjustment layer UUIDs
  199. Checking local adjustment layer UUIDs done
  200. Checking style adjustment layer UUIDs
  201. Checking style adjustment layer UUIDs done
  202. Checking validity of variant indices
  203. Checking uniqueness of variant indices
  204. Checking for duplicate catalog folder collections
  205. Checking for duplicate catalog folder collections done
  206. Checking missing catalog folder collections
  207. Checking missing catalog folder collections done
  208. Checking for catalog folder collections without a project
  209. Checking for catalog folder collections without a project done
  210. Checking for mismatched catalog folder <-> image links
  211. Checking for mismatched catalog folder <-> image links done
  212. Checking catalog folder links
  213. Checking catalog folder links done
  214. Checking image relationships
  215. Checking image relationships done
  216. Checking sidecar entities
  217. Checking sidecar entities done
  218. Database content OK
  221. 数据库修复 好