Re: [BUGS] SOLVED: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Il 06/02/2013 21:52, Dave Page ha scritto: Excellent news! So the moral of the story is: Avoid using any computer that has had McAfee software anywhere near it. you bet! a typical case of a medicine that is worse than the illness it should cure. A particularly well fit metaphor since we are talking of an antivirus -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] SOLVED: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
On Wed, Feb 6, 2013 at 8:36 PM, Ivano Luberti wrote:
> With a little bit of more drama.
>
> The good news is that the 9.2 installer has been able to successfully
> complete installation.
> The bad news is that 8.4.15 installer keep failing and with the same message
> error.
> I searched the registry again with regedit and found another occurence of
> the same registry key under
>
> HKEY_CLASSES_ROOT\Wow6432node\CLSID\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}\InprocServer32
>
> still linked to McAfee.
> I had to change ownership also in this case to modify its value
> But now 8.4.15 can run like an horse at Kentucky Derby
>
> I believe that the last issue was due to the fact that 9.2 installer is a
> 64bit software while 8.4.15 is a 32bit application.
Excellent news! So the moral of the story is: Avoid using any computer
that has had McAfee software anywhere near it.
> Dave, thanks again for your help.
You're welcome.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7750: pid file conflict in RedHat
Hi,
On Mon, 2012-12-10 at 18:41 +, postg...@tbruce.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7750
> Logged by: Timothy J Bruce
> Email address: postg...@tbruce.com
> PostgreSQL version: 9.1.6
> Operating system: RedHat v6.2
> Description:
>
> In line 238 of the rpm based init.d script, the pid file is called
> specifically with a qualified path ("status -p
> /var/run/postmaster-9.1.pid"), even though line 70 specifies a variable to
> point to the pid file (pidfile="/var/run/postmaster-9.1.pid").
>
> This is with rpm version of postgres 9.1.4 and 9.1.6 (we haven't tested
> 9.1.7 at this time).
I committed this to 9.1.8 and 9.2.3. They will be available in Friday's
releases.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
signature.asc
Description: This is a digitally signed message part
[BUGS] SOLVED: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
With a little bit of more drama.
The good news is that the 9.2 installer has been able to successfully
complete installation.
The bad news is that 8.4.15 installer keep failing and with the same
message error.
I searched the registry again with regedit and found another occurence
of the same registry key under
HKEY_CLASSES_ROOT\Wow6432node\CLSID\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}\InprocServer32
still linked to McAfee.
I had to change ownership also in this case to modify its value
But now 8.4.15 can run like an horse at Kentucky Derby
I believe that the last issue was due to the fact that 9.2 installer is
a 64bit software while 8.4.15 is a 32bit application.
Dave, thanks again for your help.
Il 06/02/2013 18:33, Dave Page ha scritto:
On Wed, Feb 6, 2013 at 5:30 PM, Ivano Luberti wrote:
Found the solution for modifyng the registry key here
http://www.mydigitallife.info/grant-read-write-full-control-permissions-on-registry-keys-fix-cannot-import-and-access-denied-error-in-regedit/
Oh, OK - so you didn't have permissions to edit that section of the
registry, but you can modify the ACL? Cool.
So, does cscript (and thus hopefully the installer) work now?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Re: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Ivano Luberti wrote on 06.02.2013 18:17: Unfortunately the fix doesn't work because it seems the registry key is protected even form administrator user modifications. Even if you run regedit from a command prompt started as Administrator? yes :-( Probably the security settings for the corresponding registry key were changed. But as you have an Administrator access, you should be able to reset the security settings. In order to do that you need to run regedt32.exe (not regedit.exe) Once you have found the key in question, you can right click and then choose "Security". You'll get more or less the same dialog that is used to control file-system security. Then give the Administrator the priviliges to delete/change those keys and you should be fine. (Not sure if this still works the same under Windows 7 though). Regards Thomas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
On Wed, Feb 6, 2013 at 5:30 PM, Ivano Luberti wrote: > Found the solution for modifyng the registry key here > > http://www.mydigitallife.info/grant-read-write-full-control-permissions-on-registry-keys-fix-cannot-import-and-access-denied-error-in-regedit/ Oh, OK - so you didn't have permissions to edit that section of the registry, but you can modify the ACL? Cool. So, does cscript (and thus hopefully the installer) work now? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Found the solution for modifyng the registry key here http://www.mydigitallife.info/grant-read-write-full-control-permissions-on-registry-keys-fix-cannot-import-and-access-denied-error-in-regedit/ Il 06/02/2013 18:17, Ivano Luberti ha scritto: Il 06/02/2013 18:10, Dave Page ha scritto: On Wed, Feb 6, 2013 at 5:07 PM, Ivano Luberti wrote: Yes the problem is exaclty that: I had MCAfee installed when the laptop was shipped. I promptly uninstalled it but it seems there are still traces of it. Oh, urgh. correct analysis :-) Unfortunately the fix doesn't work because it seems the registry key is protected even form administrator user modifications. Even if you run regedit from a command prompt started as Administrator? yes :-( -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Il 06/02/2013 18:10, Dave Page ha scritto: On Wed, Feb 6, 2013 at 5:07 PM, Ivano Luberti wrote: Yes the problem is exaclty that: I had MCAfee installed when the laptop was shipped. I promptly uninstalled it but it seems there are still traces of it. Oh, urgh. correct analysis :-) Unfortunately the fix doesn't work because it seems the registry key is protected even form administrator user modifications. Even if you run regedit from a command prompt started as Administrator? yes :-( -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
On Wed, Feb 6, 2013 at 5:07 PM, Ivano Luberti wrote: > Yes the problem is exaclty that: I had MCAfee installed when the laptop was > shipped. > I promptly uninstalled it but it seems there are still traces of it. Oh, urgh. > Unfortunately the fix doesn't work because it seems the registry key is > protected even form administrator user modifications. Even if you run regedit from a command prompt started as Administrator? > I'm searching a workaround to update the registry. > Thanks for now: you are doing a great job, Dave. You're welcome - glad to be of help. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Yes the problem is exaclty that: I had MCAfee installed when the laptop was shipped. I promptly uninstalled it but it seems there are still traces of it. Unfortunately the fix doesn't work because it seems the registry key is protected even form administrator user modifications. I'm searching a workaround to update the registry. Thanks for now: you are doing a great job, Dave. Il 06/02/2013 16:40, Dave Page ha scritto: On Wed, Feb 6, 2013 at 3:03 PM, Ivano Luberti wrote: Thanks Dave, I have followe your instructions and the result is really weird. The script doesn't run and error message is that VBScript interpreter cannot be found. At the same time .vbs files are recognized as associated with WScript.exe OK, so there definitely is something messed up with your script interpreter. I believe you said you already tried re-registering vbscript.dll, so something else seems to be preventing things from working. I wonder if these would help in tracking down and fixing the issue? http://www.sevenforums.com/windows-updates-activation/196011-cscript-error-cant-find-script-engine-vbscript-alternate-solution.html http://social.microsoft.com/Forums/eu/genuinevista/thread/1b7332ba-d1f7-455f-b523-1dc45bc2b939 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] A bug in documentation for the Query Tool PostgreSQL Version 9.2.2, Win x86-64
Thanks - I've committed a fix for this. On Wed, Feb 6, 2013 at 3:15 PM, Jozef Hlavaty wrote: > Dear Sir/Madam, > > Firstly let me congratulate all responsible for delivering us such a fine > piece of software. I take > my hat off to you all. > I've donwloaded and installed PostgreSQL Version 9.2.2, Windows x86-64bit > version ad would like to report a bug in documentation for the Query Tool. > The path to the page which I believe contains the bug: > mk:@MSITStore > :C:\Program%20Files\PostgreSQL\9.2\pgAdmin%20III\docs\en_US\pgadmin3.chm::/query.html > > In the section with code formatting commands the last two lines read: > Shift the selected text to upper case by pressing Control+Shift+U. > Shift the selected text to lower case by pressing Control+U. > > In fact they the shortcuts should be swapped: > > Shift the selected text to upper case by pressing Control+U. > Shift the selected text to lower case by pressing Control+Shift+U. > > Thanks and Regards, > Jozef > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: [BUGS] Bug #7728
Hi On Wed, Feb 6, 2013 at 12:39 AM, William Goh wrote: > Dear EnterpriseDB, > > I am trying to install PostgreSQL 9.2.2 on my mac 10.5.8. However, I have > encountered the same error posted in this thread: > http://www.postgresql.org/message-id/CA+RD+ki0F9m5hOo-pxCVKoFO9AqHfPxVRthF49b4pBn=hzt...@mail.gmail.com > I was wondering if there is any way to get around this error and > successfully install postgresql on my computer. You can either use the 9.1 installer which should work on OS X 10.5, or use an alternate distribution, such as MacPorts, which will compile the server for your version of OS X. Unfortunately it's hard for us to build releases that continue to support older versions of OS X, as when we buy new build machines they won't run older versions of OS X, and the modern versions of OS X don't support compiling code for much older versions (they only supplied SDKs for 10.7 and 10.8 with the last version of XCode I got for example). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] A bug in documentation for the Query Tool PostgreSQL Version 9.2.2, Win x86-64
Dear Sir/Madam, Firstly let me congratulate all responsible for delivering us such a fine piece of software. I take my hat off to you all. I've donwloaded and installed PostgreSQL Version 9.2.2, Windows x86-64bit version ad would like to report a bug in documentation for the Query Tool. The path to the page which I believe contains the bug: mk:@MSITStore:C:\Program%20Files\PostgreSQL\9.2\pgAdmin%20III\docs\en_US\pgadmin3.chm::/query.html In the section with code formatting commands the last two lines read: Shift the selected text to upper case by pressing Control+Shift+U. Shift the selected text to lower case by pressing Control+U. In fact they the shortcuts should be swapped: Shift the selected text to upper case by pressing Control+U. Shift the selected text to lower case by pressing Control+Shift+U. Thanks and Regards, Jozef
Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.
Kevin - Here is the plan *after *we clustered on the PK index..it was probably that way before the bloat, but I don't know. Aggregate (cost=514557.38..514557.40 rows=1 width=12) (actual time=8823.973..8823.974 rows=1 loops=1) -> HashAggregate (cost=471029.03..492793.20 rows=1243667 width=53) (actual time=8725.324..8789.926 rows=159369 loops=1)" -> Seq Scan on stream_file sf (cost=0.00..315570.68 rows=12436668 width=53) (actual time=0.013..1152.600 rows=12436753 loops=1) Total runtime: 8838.395 ms" I guess the statistics should reflect the true costs. So if the "bloated" statistics are representative of the true cost, I'm all for them. We are clustering the database as we speak, so I can't force a hash aggregate to see if that is the right choice or not. Thanks and Regards, James Skaggs IT/FIS Longmont SeaTel: 8 684 1048 General: +1 612 367 6224 On Tue, Feb 5, 2013 at 4:12 PM, Kevin Grittner wrote: > James R Skaggs wrote: > > > Agreed, we shouldn't have so many dead rows. Our autovacuum is > > set on but has default parameters. We are clustering today. > > This, of course, means downtime and inconvenience to the users. > > Right, which is why it's important to figure out why the bloat > happened. Sometimes it is unavoidable, like when you delete 90% of > the rows in your table or a long-lived "idle in transaction" > connection prevents autovacuum from being able to do its work > normally. To prevent further downtime it is important to figure > out what happened and make appropriate changes to your monitoring > or vacuuming. > > > Here is the troublesome query: > > > >> select > >>sum(case when t1.cdlc < 0 then 0 else t1.cdlc end) as code_line_cnt, > >>sum(case when t1.cmlc < 0 then 0 else t1.cmlc end) as > comment_line_cnt, > >>sum(case when t1.bllc < 0 then 0 else t1.bllc end) as blank_line_cnt > >> from > >>( select > >>max(sf.current_code_line_count) as cdlc, > >>max(sf.current_comment_line_count) as cmlc, > >>max(sf.current_blank_line_count) as bllc > >> from > >>stream_file sf > >> group by sf.file_path_id, sf.current_source_md5 > >>) as t1; > > Well, I don't see that the planner has a lot of choice there > besides whether to use a sort or a hash to do the inner > aggregation. Are you saying that prior to the bloat it used a hash > aggregation, and that was faster? And that you feel that it should > be using that even with the bloat? That the dead rows seem to be > getting included in the statistics, driving to the slower plan, and > you feel they should be omitted? > > Note that I'm not aruing one way or another on these points at the > moment; I'm just trying to understand your point clearly. > > -Kevin >
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
On Wed, Feb 6, 2013 at 3:03 PM, Ivano Luberti wrote: > Thanks Dave, I have followe your instructions and the result is really > weird. > The script doesn't run and error message is that VBScript interpreter cannot > be found. > At the same time .vbs files are recognized as associated with WScript.exe OK, so there definitely is something messed up with your script interpreter. I believe you said you already tried re-registering vbscript.dll, so something else seems to be preventing things from working. I wonder if these would help in tracking down and fixing the issue? http://www.sevenforums.com/windows-updates-activation/196011-cscript-error-cant-find-script-engine-vbscript-alternate-solution.html http://social.microsoft.com/Forums/eu/genuinevista/thread/1b7332ba-d1f7-455f-b523-1dc45bc2b939 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Thanks Dave, I have followe your instructions and the result is really weird. The script doesn't run and error message is that VBScript interpreter cannot be found. At the same time .vbs files are recognized as associated with WScript.exe In detail: I copied your file on my desktop. I renamed it with the .vbs extension. Then I opened the cmd prompt both normally and as an administrator. Here you can find the output (in italian but I think i understandable): Normal running: --- Microsoft Windows [Versione 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Tutti i diritti riservati. C:\Users\luberti>cd desktop C:\Users\luberti\Desktop>assoc .vbs .vbs=VBSFile C:\Users\luberti\Desktop>ftype VBSFile VBSFile="%SystemRoot%\System32\WScript.exe" "%1" %* C:\Users\luberti\Desktop>cscript //nologo prerun_checks.vbs Errore CScript: Impossibile trovare l'interprete di script "VBScript" per lo scr ipt "C:\Users\luberti\Desktop\prerun_checks.vbs". Running as an administrator: -- Microsoft Windows [Versione 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Tutti i diritti riservati. C:\Windows\system32>cd .. C:\Windows>cd .. C:\>cd Users\luberti\Desktop C:\Users\luberti\Desktop>assoc .vbs .vbs=VBSFile C:\Users\luberti\Desktop>ftype VBSFile VBSFile="%SystemRoot%\System32\WScript.exe" "%1" %* C:\Users\luberti\Desktop>cscript //nologo prerun_checks.vbs Errore CScript: Impossibile trovare l'interprete di script "VBScript" per lo scr ipt "C:\Users\luberti\Desktop\prerun_checks.vbs". C:\Users\luberti\Desktop> -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
On Tue, Feb 5, 2013 at 8:41 PM, Ivano Luberti wrote: > > It look exactly like that and I run the installer as an administrator. > I don't want to mix two different issues here but I also tried to install > 9.2.2-1 and I get a > "Unable to write inside TEMP environment variable path" > error message > And in the TEMP dir I find a bitrock_installer file with the following > content Actually, that almost certainly is the same problem - it's just that the 9.2 installer has been modified to try to identify the issue much earlier and more reliably. It's essentially running the attached script under cscript. If you save it to disk (and rename to prerun_checks.vbs) and then try running it, you should see something like this: C:\>cscript //nologo z:\dpage\prerun_checks.vbs The scripting host appears to be functional. Please try running it in a regular command prompt, and one opened using the "Run As Administrator" option. If you see something different from the message above it may help to remove the "On Error Resume Next" lines from the script and run it again. That should give additional error detail that the installer wouldn't be able to interpret easily. Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company prerun_checks.xxx Description: Binary data -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
