API tools faq
paste
Guest User

docker logs

a guest
Mar 26th, 2026
61
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.76 KB | None | 0 0
raw download clone embed print report
  1. [ix-postgres-main] - [2026-03-27 01:46:53] - Starting entrypoint with migration and upgrade handling
  2. [ix-postgres-main] - [2026-03-27 01:46:53] - No migration needed from old data location.
  3. [ix-postgres-main] - [2026-03-27 01:46:53] - Checking directory [/var/lib/postgresql/15/docker]
  4. [ix-postgres-main] - [2026-03-27 01:46:53] - - Found database: PostgreSQL [15]
  5. [ix-postgres-main] - [2026-03-27 01:46:53] - Using highest version found: PostgreSQL [15] at [/var/lib/postgresql/15/docker]
  6. [ix-postgres-main] - [2026-03-27 01:46:53] - Starting timezone migration for /var/lib/postgresql/15/docker
  7. [ix-postgres-main] - [2026-03-27 01:46:53] - Parameter [timezone] is already canonical - [Europe/Berlin]
  8. [ix-postgres-main] - [2026-03-27 01:46:53] - Parameter [log_timezone] is already canonical - [Europe/Berlin]
  9. [ix-postgres-main] - [2026-03-27 01:46:53] - Timezone migration complete
  10. [ix-postgres-main] - [2026-03-27 01:46:53] - Current version: 15
  11. [ix-postgres-main] - [2026-03-27 01:46:53] - Target version: 18
  12. [ix-postgres-upgrade] - [2026-03-27 01:46:53] - Starting upgrade from PostgreSQL [15] to [18]
  13.  
  14.  
  15.  
  16.  
  17. [ix-postgres-upgrade] - [2026-03-27 01:46:53] - Initializing new data directory: /var/lib/postgresql/18/docker
  18. [ix-postgres-upgrade] - [2026-03-27 01:46:53] - Old cluster has checksums disabled
  19. [ix-postgres-upgrade] - [2026-03-27 01:46:53] - Using docker_init_database_dir from upstream entrypoint with PostgreSQL [18] binaries
  20.  
  21.  
  22. [ix-postgres-upgrade] - [2026-03-27 01:46:53] - Using initdb from [/usr/lib/postgresql/18/bin/initdb]
  23. The files belonging to this database system will be owned by user "postgres".
  24. This user must also own the server process.
  25.  
  26. The database cluster will be initialized with locale "en_US.utf8".
  27. The default database encoding has accordingly been set to "UTF8".
  28. The default text search configuration will be set to "english".
  29.  
  30. Data page checksums are disabled.
  31.  
  32. fixing permissions on existing directory /var/lib/postgresql/18/docker ... ok
  33. creating subdirectories ... ok
  34. selecting dynamic shared memory implementation ... posix
  35. selecting default "max_connections" ... 100
  36. selecting default "shared_buffers" ... 128MB
  37. selecting default time zone ... Europe/Berlin
  38. creating configuration files ... ok
  39. running bootstrap script ... ok
  40. performing post-bootstrap initialization ... ok
  41. syncing data to disk ... ok
  42.  
  43.  
  44. Success. You can now start the database server using:
  45.  
  46. pg_ctl -D /var/lib/postgresql/18/docker -l logfile start
  47.  
  48. initdb: warning: enabling "trust" authentication for local connections
  49. initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
  50.  
  51.  
  52. [ix-postgres-upgrade] - [2026-03-27 01:46:55] - Creating backup: /var/lib/postgresql/backups/pre-upgrade-15-to-18-20260327014655.tar.zst (1.1G)
  53. [ix-postgres-upgrade] - [2026-03-27 01:46:55] - This may take a while depending on database size...
  54. [ix-postgres-upgrade] - [2026-03-27 01:47:02] - Backup secured with 600 permissions
  55. [ix-postgres-upgrade] - [2026-03-27 01:47:02] - Running initial compatibility check...
  56. Performing Consistency Checks
  57. -----------------------------
  58. Checking cluster versions ok
  59. WARNING: database "template1" has a collation version mismatch
  60. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  61. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  62. WARNING: database "template1" has a collation version mismatch
  63. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  64. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  65. Checking database connection settings ok
  66. WARNING: database "template1" has a collation version mismatch
  67. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  68. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  69. WARNING: database "template1" has a collation version mismatch
  70. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  71. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  72. WARNING: database "template1" has a collation version mismatch
  73. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  74. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  75. WARNING: database "postgres" has a collation version mismatch
  76. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  77. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  78. WARNING: database "immich" has a collation version mismatch
  79. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  80. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  81. WARNING: database "template1" has a collation version mismatch
  82. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  83. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  84. WARNING: database "template1" has a collation version mismatch
  85. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  86. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  87. WARNING: database "postgres" has a collation version mismatch
  88. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  89. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  90. WARNING: database "immich" has a collation version mismatch
  91. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  92. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  93. WARNING: database "template1" has a collation version mismatch
  94. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  95. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  96. Checking database user is the install user ok
  97. WARNING: database "template1" has a collation version mismatch
  98. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  99. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  100. Checking for prepared transactions ok
  101. Checking for contrib/isn with bigint-passing mismatch ok
  102. WARNING: database "template1" has a collation version mismatch
  103. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  104. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  105. WARNING: database "postgres" has a collation version mismatch
  106. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  107. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  108. WARNING: database "immich" has a collation version mismatch
  109. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  110. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  111. Checking data type usage ok
  112. WARNING: database "template1" has a collation version mismatch
  113. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  114. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  115. WARNING: database "postgres" has a collation version mismatch
  116. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  117. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  118. WARNING: database "immich" has a collation version mismatch
  119. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  120. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  121. Checking for not-null constraint inconsistencies ok
  122. Checking for presence of required libraries fatal
  123.  
  124. Your installation references loadable libraries that are missing from the
  125. new installation. You can add these libraries to the new installation,
  126. or remove the functions using them from the old installation. A list of
  127. problem libraries is in the file:
  128. /var/lib/postgresql/18/docker/pg_upgrade_output.d/20260327T014702.674/loadable_libraries.txt
  129. Failure, exiting
  130. [ix-postgres-upgrade] - [2026-03-27 01:47:03] - Checking loadable libraries from pg_upgrade output...
  131. [ix-postgres-upgrade] - [2026-03-27 01:47:03] - Detected libraries requiring shared_preload_libraries: vchord
  132. [ix-postgres-upgrade] - [2026-03-27 01:47:03] - Retrying compatibility check with shared_preload_libraries options...
  133. Performing Consistency Checks
  134. -----------------------------
  135. Checking cluster versions ok
  136. WARNING: database "template1" has a collation version mismatch
  137. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  138. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  139. WARNING: database "template1" has a collation version mismatch
  140. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  141. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  142. Checking database connection settings ok
  143. WARNING: database "template1" has a collation version mismatch
  144. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  145. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  146. WARNING: database "template1" has a collation version mismatch
  147. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  148. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  149. WARNING: database "template1" has a collation version mismatch
  150. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  151. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  152. WARNING: database "postgres" has a collation version mismatch
  153. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  154. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  155. WARNING: database "immich" has a collation version mismatch
  156. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  157. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  158. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  159. DETAIL: "vchordrq" is a reserved prefix.
  160. WARNING: database "template1" has a collation version mismatch
  161. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  162. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  163. WARNING: database "template1" has a collation version mismatch
  164. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  165. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  166. WARNING: database "postgres" has a collation version mismatch
  167. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  168. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  169. WARNING: database "immich" has a collation version mismatch
  170. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  171. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  172. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  173. DETAIL: "vchordrq" is a reserved prefix.
  174. WARNING: database "template1" has a collation version mismatch
  175. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  176. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  177. Checking database user is the install user ok
  178. WARNING: database "template1" has a collation version mismatch
  179. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  180. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  181. Checking for prepared transactions ok
  182. Checking for contrib/isn with bigint-passing mismatch ok
  183. WARNING: database "template1" has a collation version mismatch
  184. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  185. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  186. WARNING: database "postgres" has a collation version mismatch
  187. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  188. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  189. WARNING: database "immich" has a collation version mismatch
  190. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  191. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  192. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  193. DETAIL: "vchordrq" is a reserved prefix.
  194. Checking data type usage ok
  195. WARNING: database "template1" has a collation version mismatch
  196. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  197. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  198. WARNING: database "postgres" has a collation version mismatch
  199. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  200. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  201. WARNING: database "immich" has a collation version mismatch
  202. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  203. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  204. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  205. DETAIL: "vchordrq" is a reserved prefix.
  206. Checking for not-null constraint inconsistencies ok
  207. Checking for presence of required libraries ok
  208. Checking database user is the install user ok
  209. Checking for prepared transactions ok
  210. Checking for new cluster tablespace directories ok
  211.  
  212. *Clusters are compatible*
  213. [ix-postgres-upgrade] - [2026-03-27 01:47:04] - Compatibility check passed after retry
  214. [ix-postgres-upgrade] - [2026-03-27 01:47:04] - Compatibility check passed
  215. [ix-postgres-upgrade] - [2026-03-27 01:47:04] - Performing upgrade...
  216. [ix-postgres-upgrade] - [2026-03-27 01:47:04] - SQL scripts will be created in: /var/lib/postgresql/pg_upgrade_work
  217. [ix-postgres-upgrade] - [2026-03-27 01:47:04] - Using shared_preload_libraries options: -c shared_preload_libraries='vchord'
  218. Performing Consistency Checks
  219. -----------------------------
  220. Checking cluster versions ok
  221. WARNING: database "template1" has a collation version mismatch
  222. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  223. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  224. WARNING: database "template1" has a collation version mismatch
  225. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  226. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  227. Checking database connection settings ok
  228. WARNING: database "template1" has a collation version mismatch
  229. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  230. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  231. WARNING: database "template1" has a collation version mismatch
  232. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  233. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  234. WARNING: database "template1" has a collation version mismatch
  235. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  236. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  237. WARNING: database "postgres" has a collation version mismatch
  238. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  239. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  240. WARNING: database "immich" has a collation version mismatch
  241. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  242. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  243. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  244. DETAIL: "vchordrq" is a reserved prefix.
  245. WARNING: database "template1" has a collation version mismatch
  246. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  247. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  248. WARNING: database "template1" has a collation version mismatch
  249. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  250. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  251. WARNING: database "postgres" has a collation version mismatch
  252. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  253. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  254. WARNING: database "immich" has a collation version mismatch
  255. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  256. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  257. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  258. DETAIL: "vchordrq" is a reserved prefix.
  259. WARNING: database "template1" has a collation version mismatch
  260. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  261. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  262. Checking database user is the install user ok
  263. WARNING: database "template1" has a collation version mismatch
  264. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  265. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  266. Checking for prepared transactions ok
  267. Checking for contrib/isn with bigint-passing mismatch ok
  268. WARNING: database "template1" has a collation version mismatch
  269. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  270. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  271. WARNING: database "postgres" has a collation version mismatch
  272. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  273. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  274. WARNING: database "immich" has a collation version mismatch
  275. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  276. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  277. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  278. DETAIL: "vchordrq" is a reserved prefix.
  279. Checking data type usage ok
  280. WARNING: database "template1" has a collation version mismatch
  281. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  282. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  283. WARNING: database "postgres" has a collation version mismatch
  284. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  285. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  286. WARNING: database "immich" has a collation version mismatch
  287. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  288. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  289. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  290. DETAIL: "vchordrq" is a reserved prefix.
  291. Checking for not-null constraint inconsistencies ok
  292. Creating dump of global objects ok
  293. Creating dump of database schemas ok
  294. Checking for presence of required libraries ok
  295. Checking database user is the install user ok
  296. Checking for prepared transactions ok
  297. Checking for new cluster tablespace directories ok
  298.  
  299. If pg_upgrade fails after this point, you must re-initdb the
  300. new cluster before continuing.
  301.  
  302. Performing Upgrade
  303. ------------------
  304. Setting locale and encoding for new cluster ok
  305. Analyzing all rows in the new cluster ok
  306. Freezing all rows in the new cluster ok
  307. Deleting files from new pg_xact ok
  308. Copying old pg_xact to new server ok
  309. Setting oldest XID for new cluster ok
  310. Setting next transaction ID and epoch for new cluster ok
  311. Deleting files from new pg_multixact/offsets ok
  312. Copying old pg_multixact/offsets to new server ok
  313. Deleting files from new pg_multixact/members ok
  314. Copying old pg_multixact/members to new server ok
  315. Setting next multixact ID and offset for new cluster ok
  316. Resetting WAL archives ok
  317. Setting frozenxid and minmxid counters in new cluster ok
  318. Restoring global objects in the new cluster ok
  319. Restoring database schemas in the new cluster
  320. *failure*
  321.  
  322. Consult the last few lines of "/var/lib/postgresql/18/docker/pg_upgrade_output.d/20260327T014704.311/log/pg_upgrade_dump_16384.log" for
  323. the probable cause of the failure.
  324. Failure, exiting
  325. [ix-postgres-upgrade] - [2026-03-27 01:47:08] - ERROR: Upgrade failed
  326. [ix-postgres-upgrade] - [2026-03-27 01:47:08] - Cleaning up new version directory [/var/lib/postgresql/18]
  327. [ix-postgres-main] - [2026-03-27 01:47:08] - ERROR: Upgrade failed
  328. [ix-postgres-main] - [2026-03-27 01:47:09] - Starting entrypoint with migration and upgrade handling
  329. [ix-postgres-main] - [2026-03-27 01:47:09] - No migration needed from old data location.
  330. [ix-postgres-main] - [2026-03-27 01:47:09] - Checking directory [/var/lib/postgresql/15/docker]
  331. [ix-postgres-main] - [2026-03-27 01:47:09] - - Found database: PostgreSQL [15]
  332. [ix-postgres-main] - [2026-03-27 01:47:09] - Using highest version found: PostgreSQL [15] at [/var/lib/postgresql/15/docker]
  333. [ix-postgres-main] - [2026-03-27 01:47:09] - Starting timezone migration for /var/lib/postgresql/15/docker
  334. [ix-postgres-main] - [2026-03-27 01:47:10] - Parameter [timezone] is already canonical - [Europe/Berlin]
  335. [ix-postgres-main] - [2026-03-27 01:47:10] - Parameter [log_timezone] is already canonical - [Europe/Berlin]
  336. [ix-postgres-main] - [2026-03-27 01:47:10] - Timezone migration complete
  337. [ix-postgres-main] - [2026-03-27 01:47:10] - Current version: 15
  338. [ix-postgres-main] - [2026-03-27 01:47:10] - Target version: 18
  339. [ix-postgres-upgrade] - [2026-03-27 01:47:10] - Starting upgrade from PostgreSQL [15] to [18]
  340.  
  341.  
  342.  
  343.  
  344. [ix-postgres-upgrade] - [2026-03-27 01:47:10] - Initializing new data directory: /var/lib/postgresql/18/docker
  345. [ix-postgres-upgrade] - [2026-03-27 01:47:10] - Old cluster has checksums disabled
  346. [ix-postgres-upgrade] - [2026-03-27 01:47:10] - Using docker_init_database_dir from upstream entrypoint with PostgreSQL [18] binaries
  347.  
  348.  
  349. [ix-postgres-upgrade] - [2026-03-27 01:47:10] - Using initdb from [/usr/lib/postgresql/18/bin/initdb]
  350. The files belonging to this database system will be owned by user "postgres".
  351. This user must also own the server process.
  352.  
  353. The database cluster will be initialized with locale "en_US.utf8".
  354. The default database encoding has accordingly been set to "UTF8".
  355. The default text search configuration will be set to "english".
  356.  
  357. Data page checksums are disabled.
  358.  
  359. fixing permissions on existing directory /var/lib/postgresql/18/docker ... ok
  360. creating subdirectories ... ok
  361. selecting dynamic shared memory implementation ... posix
  362. selecting default "max_connections" ... 100
  363. selecting default "shared_buffers" ... 128MB
  364. selecting default time zone ... Europe/Berlin
  365. creating configuration files ... ok
  366. running bootstrap script ... ok
  367. performing post-bootstrap initialization ... ok
  368. syncing data to disk ... ok
  369.  
  370.  
  371. initdb: warning: enabling "trust" authentication for local connections
  372. initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
  373. Success. You can now start the database server using:
  374.  
  375. pg_ctl -D /var/lib/postgresql/18/docker -l logfile start
  376.  
  377.  
  378.  
  379. [ix-postgres-upgrade] - [2026-03-27 01:47:11] - Creating backup: /var/lib/postgresql/backups/pre-upgrade-15-to-18-20260327014711.tar.zst (1.1G)
  380. [ix-postgres-upgrade] - [2026-03-27 01:47:11] - This may take a while depending on database size...
  381. [ix-postgres-upgrade] - [2026-03-27 01:47:18] - Backup secured with 600 permissions
  382. [ix-postgres-upgrade] - [2026-03-27 01:47:18] - Running initial compatibility check...
  383. Performing Consistency Checks
  384. -----------------------------
  385. Checking cluster versions ok
  386. WARNING: database "template1" has a collation version mismatch
  387. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  388. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  389. WARNING: database "template1" has a collation version mismatch
  390. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  391. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  392. Checking database connection settings ok
  393. WARNING: database "template1" has a collation version mismatch
  394. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  395. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  396. WARNING: database "template1" has a collation version mismatch
  397. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  398. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  399. WARNING: database "template1" has a collation version mismatch
  400. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  401. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  402. WARNING: database "postgres" has a collation version mismatch
  403. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  404. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  405. WARNING: database "immich" has a collation version mismatch
  406. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  407. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  408. WARNING: database "template1" has a collation version mismatch
  409. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  410. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  411. WARNING: database "template1" has a collation version mismatch
  412. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  413. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  414. WARNING: database "postgres" has a collation version mismatch
  415. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  416. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  417. WARNING: database "immich" has a collation version mismatch
  418. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  419. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  420. WARNING: database "template1" has a collation version mismatch
  421. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  422. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  423. Checking database user is the install user ok
  424. WARNING: database "template1" has a collation version mismatch
  425. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  426. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  427. Checking for prepared transactions ok
  428. Checking for contrib/isn with bigint-passing mismatch ok
  429. WARNING: database "template1" has a collation version mismatch
  430. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  431. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  432. WARNING: database "postgres" has a collation version mismatch
  433. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  434. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  435. WARNING: database "immich" has a collation version mismatch
  436. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  437. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  438. Checking data type usage ok
  439. WARNING: database "template1" has a collation version mismatch
  440. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  441. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  442. WARNING: database "postgres" has a collation version mismatch
  443. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  444. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  445. WARNING: database "immich" has a collation version mismatch
  446. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  447. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  448. Checking for not-null constraint inconsistencies ok
  449. Checking for presence of required libraries fatal
  450.  
  451. Your installation references loadable libraries that are missing from the
  452. new installation. You can add these libraries to the new installation,
  453. or remove the functions using them from the old installation. A list of
  454. problem libraries is in the file:
  455. /var/lib/postgresql/18/docker/pg_upgrade_output.d/20260327T014718.990/loadable_libraries.txt
  456. Failure, exiting
  457. [ix-postgres-upgrade] - [2026-03-27 01:47:19] - Checking loadable libraries from pg_upgrade output...
  458. [ix-postgres-upgrade] - [2026-03-27 01:47:19] - Detected libraries requiring shared_preload_libraries: vchord
  459. [ix-postgres-upgrade] - [2026-03-27 01:47:19] - Retrying compatibility check with shared_preload_libraries options...
  460. Performing Consistency Checks
  461. -----------------------------
  462. Checking cluster versions ok
  463. WARNING: database "template1" has a collation version mismatch
  464. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  465. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  466. WARNING: database "template1" has a collation version mismatch
  467. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  468. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  469. Checking database connection settings ok
  470. WARNING: database "template1" has a collation version mismatch
  471. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  472. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  473. WARNING: database "template1" has a collation version mismatch
  474. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  475. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  476. WARNING: database "template1" has a collation version mismatch
  477. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  478. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  479. WARNING: database "postgres" has a collation version mismatch
  480. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  481. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  482. WARNING: database "immich" has a collation version mismatch
  483. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  484. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  485. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  486. DETAIL: "vchordrq" is a reserved prefix.
  487. WARNING: database "template1" has a collation version mismatch
  488. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  489. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  490. WARNING: database "template1" has a collation version mismatch
  491. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  492. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  493. WARNING: database "postgres" has a collation version mismatch
  494. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  495. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  496. WARNING: database "immich" has a collation version mismatch
  497. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  498. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  499. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  500. DETAIL: "vchordrq" is a reserved prefix.
  501. WARNING: database "template1" has a collation version mismatch
  502. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  503. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  504. Checking database user is the install user ok
  505. WARNING: database "template1" has a collation version mismatch
  506. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  507. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  508. Checking for prepared transactions ok
  509. Checking for contrib/isn with bigint-passing mismatch ok
  510. WARNING: database "template1" has a collation version mismatch
  511. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  512. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  513. WARNING: database "postgres" has a collation version mismatch
  514. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  515. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  516. WARNING: database "immich" has a collation version mismatch
  517. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  518. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  519. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  520. DETAIL: "vchordrq" is a reserved prefix.
  521. Checking data type usage ok
  522. WARNING: database "template1" has a collation version mismatch
  523. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  524. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  525. WARNING: database "postgres" has a collation version mismatch
  526. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  527. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  528. WARNING: database "immich" has a collation version mismatch
  529. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  530. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  531. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  532. DETAIL: "vchordrq" is a reserved prefix.
  533. Checking for not-null constraint inconsistencies ok
  534. Checking for presence of required libraries ok
  535. Checking database user is the install user ok
  536. Checking for prepared transactions ok
  537. Checking for new cluster tablespace directories ok
  538.  
  539. *Clusters are compatible*
  540. [ix-postgres-upgrade] - [2026-03-27 01:47:20] - Compatibility check passed after retry
  541. [ix-postgres-upgrade] - [2026-03-27 01:47:20] - Compatibility check passed
  542. [ix-postgres-upgrade] - [2026-03-27 01:47:20] - Performing upgrade...
  543. [ix-postgres-upgrade] - [2026-03-27 01:47:20] - SQL scripts will be created in: /var/lib/postgresql/pg_upgrade_work
  544. [ix-postgres-upgrade] - [2026-03-27 01:47:20] - Using shared_preload_libraries options: -c shared_preload_libraries='vchord'
  545. Performing Consistency Checks
  546. -----------------------------
  547. Checking cluster versions ok
  548. WARNING: database "template1" has a collation version mismatch
  549. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  550. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  551. WARNING: database "template1" has a collation version mismatch
  552. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  553. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  554. Checking database connection settings ok
  555. WARNING: database "template1" has a collation version mismatch
  556. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  557. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  558. WARNING: database "template1" has a collation version mismatch
  559. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  560. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  561. WARNING: database "template1" has a collation version mismatch
  562. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  563. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  564. WARNING: database "postgres" has a collation version mismatch
  565. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  566. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  567. WARNING: database "immich" has a collation version mismatch
  568. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  569. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  570. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  571. DETAIL: "vchordrq" is a reserved prefix.
  572. WARNING: database "template1" has a collation version mismatch
  573. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  574. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  575. WARNING: database "template1" has a collation version mismatch
  576. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  577. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  578. WARNING: database "postgres" has a collation version mismatch
  579. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  580. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  581. WARNING: database "immich" has a collation version mismatch
  582. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  583. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  584. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  585. DETAIL: "vchordrq" is a reserved prefix.
  586. WARNING: database "template1" has a collation version mismatch
  587. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  588. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  589. Checking database user is the install user ok
  590. WARNING: database "template1" has a collation version mismatch
  591. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  592. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  593. Checking for prepared transactions ok
  594. Checking for contrib/isn with bigint-passing mismatch ok
  595. WARNING: database "template1" has a collation version mismatch
  596. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  597. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  598. WARNING: database "postgres" has a collation version mismatch
  599. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  600. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  601. WARNING: database "immich" has a collation version mismatch
  602. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  603. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  604. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  605. DETAIL: "vchordrq" is a reserved prefix.
  606. Checking data type usage ok
  607. WARNING: database "template1" has a collation version mismatch
  608. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  609. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  610. WARNING: database "postgres" has a collation version mismatch
  611. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  612. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  613. WARNING: database "immich" has a collation version mismatch
  614. DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
  615. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
  616. WARNING: invalid configuration parameter name "vchordrq.prewarm_dim"
  617. DETAIL: "vchordrq" is a reserved prefix.
  618. Checking for not-null constraint inconsistencies ok
  619. Creating dump of global objects ok
  620. Creating dump of database schemas ok
  621. Checking for presence of required libraries ok
  622. Checking database user is the install user ok
  623. Checking for prepared transactions ok
  624. Checking for new cluster tablespace directories ok
  625.  
  626. If pg_upgrade fails after this point, you must re-initdb the
  627. new cluster before continuing.
  628.  
  629. Performing Upgrade
  630. ------------------
  631. Setting locale and encoding for new cluster ok
  632. Analyzing all rows in the new cluster ok
  633. Freezing all rows in the new cluster ok
  634. Deleting files from new pg_xact ok
  635. Copying old pg_xact to new server ok
  636. Setting oldest XID for new cluster ok
  637. Setting next transaction ID and epoch for new cluster ok
  638. Deleting files from new pg_multixact/offsets ok
  639. Copying old pg_multixact/offsets to new server ok
  640. Deleting files from new pg_multixact/members ok
  641. Copying old pg_multixact/members to new server ok
  642. Setting next multixact ID and offset for new cluster ok
  643. Resetting WAL archives ok
  644. Setting frozenxid and minmxid counters in new cluster ok
  645. Restoring global objects in the new cluster ok
  646. Restoring database schemas in the new cluster
  647. *failure*
  648.  
  649. Consult the last few lines of "/var/lib/postgresql/18/docker/pg_upgrade_output.d/20260327T014720.567/log/pg_upgrade_dump_16384.log" for
  650. the probable cause of the failure.
  651. Failure, exiting
  652. [ix-postgres-upgrade] - [2026-03-27 01:47:24] - ERROR: Upgrade failed
  653. [ix-postgres-upgrade] - [2026-03-27 01:47:24] - Cleaning up new version directory [/var/lib/postgresql/18]
  654. [ix-postgres-main] - [2026-03-27 01:47:24] - ERROR: Upgrade failed
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!