Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
От | Edmund Horner |
---|---|
Тема | Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP |
Дата | |
Msg-id | CAMyN-kCd+h2GJJcF9EedUHCJxExq2HhFLu=dgGHY4a74OmfDew@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP (Craig Ringer <ringerc@ringerc.id.au>) |
Ответы |
Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
|
Список | pgsql-bugs |
On 22 May 2012 18:49, Craig Ringer <ringerc@ringerc.id.au> wrote: > When you shut down the 9.1.3 cluster did you make absolutely certain there > were no postgres.exe processes lurking around when you tested? Given the > incredible thouroughness of your report I imagine you did, but it's worth > checking, as a lingering `postgres.exe' could (I imagine) cause such an > issue. Not that it should ever happen. Yes, I ensured there were no postgres.exe processes running before running up_upgrade. On a related note, postgres.exe processes DO remaining running after pg_upgrade fails with this error. Not sure if they're from the old or new binaries. I generally terminate them and recreate the destination cluster between retries. Additionally, the old cluster needs to be cycled: start it, and then stop it; because the next pg_upgrade run thinks a postgres.exe could still be using it. pg_ctl start also prints a warning about this but starts anyway. > Do you have the option of re-trying with your AV disabled or removed? At work I can't tamper with the AV, but I can run pg_upgrade in a directory that is excluded from AV (the c:\ccviews directory used by Clearcase!). The log files are created there, and there is no AV activity on them according to Filemon. There is still a SHARING VIOLATION on pg_upgrade_utility.log, though: 9 3:47:42 p.m. pg_upgrade.exe:97760 OPEN C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS Options: Open Access: 00000081 10 3:47:42 p.m. pg_upgrade.exe:97760 QUERY INFORMATION C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS Length: 179 27 3:47:42 p.m. pg_upgrade.exe:97760 OPEN C:\ccviews\pg_upgrade_utility.log SUCCESS Options: OpenIf Access: 00120196 28 3:47:42 p.m. pg_upgrade.exe:97760 QUERY INFORMATION C:\ccviews\pg_upgrade_utility.log SUCCESS Length: 179 29 3:47:42 p.m. pg_upgrade.exe:97760 QUERY INFORMATION C:\ccviews\pg_upgrade_utility.log SUCCESS Length: 179 30 3:47:42 p.m. pg_upgrade.exe:97760 WRITE C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 179 Length: 179 31 3:47:42 p.m. pg_upgrade.exe:97760 CLOSE C:\ccviews\pg_upgrade_utility.log SUCCESS 101 3:47:45 p.m. cmd.exe:99028 OPEN C:\ccviews\pg_upgrade_utility.log SUCCESS Options: Open Access: 0012019F 102 3:47:45 p.m. cmd.exe:99028 QUERY INFORMATION C:\ccviews\pg_upgrade_utility.log SUCCESS Length: 358 103 3:47:45 p.m. cmd.exe:99028 QUERY INFORMATION C:\ccviews\pg_upgrade_utility.log SUCCESS Length: 358 104 3:47:45 p.m. cmd.exe:99028 READ C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 357 Length: 1 109 3:47:45 p.m. pg_ctl.exe:98832 WRITE C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 358 Length: 30 110 3:47:45 p.m. pg_ctl.exe:98832 WRITE C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 388 Length: 1 133 3:47:45 p.m. svchost.exe:560 QUERY INFORMATION C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS Attributes: A 134 3:47:45 p.m. svchost.exe:560 OPEN C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS Options: Open Access: 00020088 135 3:47:45 p.m. svchost.exe:560 QUERY INFORMATION C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS FileInternalInformation 136 3:47:45 p.m. svchost.exe:560 CLOSE C:\CCVIEWS\PG_UPGRADE_UTILITY.LOG SUCCESS 141 3:47:47 p.m. pg_ctl.exe:98832 WRITE C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 389 Length: 7 142 3:47:47 p.m. pg_ctl.exe:98832 WRITE C:\ccviews\pg_upgrade_utility.log SUCCESS Offset: 396 Length: 16 183 3:48:01 p.m. cmd.exe:99396 OPEN C:\ccviews\pg_upgrade_utility.log SHARING VIOLATION Options: Open Access: 0012019F 184 3:48:01 p.m. cmd.exe:99396 OPEN C:\ccviews\pg_upgrade_utility.log SHARING VIOLATION Options: OpenIf Access: 00120196 195 3:48:02 p.m. cmd.exe:97484 OPEN C:\ccviews\pg_upgrade_utility.log SHARING VIOLATION Options: Open Access: 0012019F 196 3:48:02 p.m. cmd.exe:97484 OPEN C:\ccviews\pg_upgrade_utility.log SHARING VIOLATION Options: OpenIf Access: 00120196
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Pavel StehuleДата:
Сообщение: Re: BUG #6626: union all with values of type "unknown"
Следующее
От: Andres FreundДата:
Сообщение: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids