Thread: Strange error in Windows 10 Pro
I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg
On 04/20/2018 07:16 PM, Dale Seaburg wrote: > I am attempting to install a fresh copy of > postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? > gets near the end of the install when the message says it is attempting > to start the the database server. There's a long pause, followed by an > error message: "Failed to load SQL modules into the database cluster". > Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone > else seen this before? I have no clue where to look for the issue. You are running as Admin user? > > > As a double-check on a different PC with Windows 10 Pro, I get no error > message, and the database is installed correctly. > > Dale Seaburg > > > > -- Adrian Klaver adrian.klaver@aklaver.com
On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. > Thanks, Adrian, for suggestion(s). > > > On 4/20/2018 9:35 PM, Adrian Klaver wrote: >> On 04/20/2018 07:16 PM, Dale Seaburg wrote: >>> I am attempting to install a fresh copy of >>> postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It >> >> This was downloaded from where? > downloaded from https://www.postgresql.org/download/windows/, selecting > to use the installer pointed to near the beginning of that page. The > actual website that contained the installer file was: > "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611". > >> >>> gets near the end of the install when the message says it is >>> attempting to start the the database server. There's a long pause, >>> followed by an error message: "Failed to load SQL modules into the >>> database cluster". Using File Explorer, i notice the 9.6\base\ folder >>> is empty? Has anyone else seen this before? I have no clue where to >>> look for the issue. >> >> You are running as Admin user? > I can't say that I was. Will check this next time (maybe tomorrow) when > I am customer's site. I didn't even think about right-clicking on the > installer and selecting run-as-admin. I know I did not deliberately use > Admin user on the test PC mentioned below, and it installed with no > problems. >> >>> >>> >>> As a double-check on a different PC with Windows 10 Pro, I get no >>> error message, and the database is installed correctly. >>> >>> Dale Seaburg >>> >>> >>> >>> >> >> > -- Adrian Klaver adrian.klaver@aklaver.com
Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder. I hope tomorrow to visit the customer and try the Admin user method of installing. Dale On 4/20/2018 11:03 PM, Adrian Klaver wrote: > On 04/20/2018 07:52 PM, Dale Seaburg wrote: > > Please also reply to list. > Ccing list to put it front of more eyes. > >> Thanks, Adrian, for suggestion(s). >> >> >> On 4/20/2018 9:35 PM, Adrian Klaver wrote: >>> On 04/20/2018 07:16 PM, Dale Seaburg wrote: >>>> I am attempting to install a fresh copy of >>>> postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 >>>> Pro. It >>> >>> This was downloaded from where? >> downloaded from https://www.postgresql.org/download/windows/, >> selecting to use the installer pointed to near the beginning of that >> page. The actual website that contained the installer file was: >> "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611". >> >>> >>>> gets near the end of the install when the message says it is >>>> attempting to start the the database server. There's a long >>>> pause, followed by an error message: "Failed to load SQL modules >>>> into the database cluster". Using File Explorer, i notice the >>>> 9.6\base\ folder is empty? Has anyone else seen this before? I >>>> have no clue where to look for the issue. >>> >>> You are running as Admin user? >> I can't say that I was. Will check this next time (maybe tomorrow) >> when I am customer's site. I didn't even think about right-clicking >> on the installer and selecting run-as-admin. I know I did not >> deliberately use Admin user on the test PC mentioned below, and it >> installed with no problems. >>> >>>> >>>> >>>> As a double-check on a different PC with Windows 10 Pro, I get no >>>> error message, and the database is installed correctly. >>>> >>>> Dale Seaburg >>>> >>>> >>>> >>>> >>> >>> >> > >
Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the data folder are to be created, or copied into, it leaves an error message as noted previously. The data folder is empty.
It's almost as if the PC is missing a critical .dll needed in the data folder filling function (my guess).
Again, I am at a loss as to what to do.
Dale
Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder.
I hope tomorrow to visit the customer and try the Admin user method of installing.
Dale
On 4/20/2018 11:03 PM, Adrian Klaver wrote:On 04/20/2018 07:52 PM, Dale Seaburg wrote:
Please also reply to list.
Ccing list to put it front of more eyes.Thanks, Adrian, for suggestion(s).
On 4/20/2018 9:35 PM, Adrian Klaver wrote:On 04/20/2018 07:16 PM, Dale Seaburg wrote:downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611".I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It
This was downloaded from where?I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems.gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue.
You are running as Admin user?
As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly.
Dale Seaburg
On 04/21/2018 01:08 PM, Dale Seaburg wrote: > Thanks Adrian for the suggestion of running the installer with Admin > rights. Unfortunately, I get the same results. It appears that all of > the folders within C:\Program Files\PostgreSQL\9.6 path are created, and > populated, BUT, when the items in the *data* folder are to be created, > or copied into, it leaves an error message as noted previously. The > *data* folder is empty. > > It's almost as if the PC is missing a critical .dll needed in the *data* > folder filling function (my guess). > > Again, I am at a loss as to what to do. Have you looked at the system logs e.g. Event Viewer? > > Dale > > > On 4/20/2018 11:13 PM, Dale Seaburg wrote: >> Oops, my mistake. I'll let this serve the list with what I've tried >> so far. Thanks, Adrian for the reminder. >> >> I hope tomorrow to visit the customer and try the Admin user method of >> installing. >> >> Dale >> >> >> On 4/20/2018 11:03 PM, Adrian Klaver wrote: >>> On 04/20/2018 07:52 PM, Dale Seaburg wrote: >>> >>> Please also reply to list. >>> Ccing list to put it front of more eyes. >>> >>>> Thanks, Adrian, for suggestion(s). >>>> >>>> >>>> On 4/20/2018 9:35 PM, Adrian Klaver wrote: >>>>> On 04/20/2018 07:16 PM, Dale Seaburg wrote: >>>>>> I am attempting to install a fresh copy of >>>>>> postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 >>>>>> Pro. It >>>>> >>>>> This was downloaded from where? >>>> downloaded from https://www.postgresql.org/download/windows/, >>>> selecting to use the installer pointed to near the beginning of that >>>> page. The actual website that contained the installer file was: >>>> "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611". >>>> >>>>> >>>>>> gets near the end of the install when the message says it is >>>>>> attempting to start the the database server. There's a long >>>>>> pause, followed by an error message: "Failed to load SQL modules >>>>>> into the database cluster". Using File Explorer, i notice the >>>>>> 9.6\base\ folder is empty? Has anyone else seen this before? I >>>>>> have no clue where to look for the issue. >>>>> >>>>> You are running as Admin user? >>>> I can't say that I was. Will check this next time (maybe tomorrow) >>>> when I am customer's site. I didn't even think about right-clicking >>>> on the installer and selecting run-as-admin. I know I did not >>>> deliberately use Admin user on the test PC mentioned below, and it >>>> installed with no problems. >>>>> >>>>>> >>>>>> >>>>>> As a double-check on a different PC with Windows 10 Pro, I get no >>>>>> error message, and the database is installed correctly. >>>>>> >>>>>> Dale Seaburg >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>> >> >> >> > -- Adrian Klaver adrian.klaver@aklaver.com
On system hard drive search for the file called bitrock_installer_<some_numbers>.log.
You should find it in Users\<your_account>\AppData\Local\Temp.
This log should provide you with more specific details explaining why data folder is empty.
Regards,
Igor
From: Dale Seaburg [mailto:kg5lt@verizon.net]
Sent: Saturday, April 21, 2018 4:09 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Strange error in Windows 10 Pro
WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE risks.
Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the data folder are to be created, or copied into, it leaves an error message as noted previously. The data folder is empty.
It's almost as if the PC is missing a critical .dll needed in the data folder filling function (my guess).
Again, I am at a loss as to what to do.
Dale
On 4/20/2018 11:13 PM, Dale Seaburg wrote:
Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder.
I hope tomorrow to visit the customer and try the Admin user method of installing.
Dale
On 4/20/2018 11:03 PM, Adrian Klaver wrote:On 04/20/2018 07:52 PM, Dale Seaburg wrote:
Please also reply to list.
Ccing list to put it front of more eyes.Thanks, Adrian, for suggestion(s).
On 4/20/2018 9:35 PM, Adrian Klaver wrote:On 04/20/2018 07:16 PM, Dale Seaburg wrote:
I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It
This was downloaded from where?downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611".
gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue.
You are running as Admin user?I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems.
As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly.
Dale Seaburg
Il 21/04/2018 22:35, Adrian Klaver ha scritto: > On 04/21/2018 01:08 PM, Dale Seaburg wrote: >> Thanks Adrian for the suggestion of running the installer with Admin >> rights. Unfortunately, I get the same results. It appears that all >> of the folders within C:\Program Files\PostgreSQL\9.6 path are >> created, and populated, BUT, when the items in the *data* folder are >> to be created, or copied into, it leaves an error message as noted >> previously. The *data* folder is empty. >> >> It's almost as if the PC is missing a critical .dll needed in the >> *data* folder filling function (my guess). >> >> Again, I am at a loss as to what to do. > > Have you looked at the system logs e.g. Event Viewer? If you look in %temp%", there should be one or more files named "bitrock_installer" or something similar (search for "bitrock"), that's the setup log with what's went good and what not. Another hint I had since 9.1 times (it was 2012, I guess) was to avoid installing Postgres under system folders (c:\program files, c:\users, and so on) because in some cases there could be some nasty behaviors... try installing on something like c:\PG96... HTH Cheers, Moreno.-
> On 04/21/2018 01:08 PM, Dale Seaburg wrote:
>> Thanks Adrian for the suggestion of running the installer with Admin
>> rights. Unfortunately, I get the same results. It appears that all
>> of the folders within C:\Program Files\PostgreSQL\9.6 path are
>> created, and populated, BUT, when the items in the *data* folder are
>> to be created, or copied into, it leaves an error message as noted
>> previously. The *data* folder is empty.
Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro.
BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off.
Good Install:
Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data
Executing batch file 'rad0510A.bat'...
processed file: C:\Program Files\PostgreSQL\9.6\data
Successfully processed 1 files; Failed processing 0 files
Bad Install:
Called AclCheck(D:\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data
Executing batch file 'rad6DBC7.bat'...
Notice the last four lines of the Good Install vs the last two lines of the Bad Install. There is no indication of processing, or whether it was successful or not in the bad install.
As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success.
Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install.
Dale
Il 21/04/2018 22:35, Adrian Klaver ha scritto:On 04/21/2018 01:08 PM, Dale Seaburg wrote:Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the *data* folder are to be created, or copied into, it leaves an error message as noted previously. The *data* folder is empty.
It's almost as if the PC is missing a critical .dll needed in the *data* folder filling function (my guess).
Again, I am at a loss as to what to do.
Have you looked at the system logs e.g. Event Viewer?
If you look in %temp%", there should be one or more files named "bitrock_installer" or something similar (search for "bitrock"), that's the setup log with what's went good and what not.
Another hint I had since 9.1 times (it was 2012, I guess) was to avoid installing Postgres under system folders (c:\program files, c:\users, and so on) because in some cases there could be some nasty behaviors... try installing on something like c:\PG96...
HTH
Cheers,
Moreno.-
As you may have noticed in the Bad Install section, the user's name was 'don king' - with an embedded space. I created a new user 'Dale' to test out whether that name might be causing a problem. The new name also failed to complete an install.
Dale
Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro.
BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off.
Good Install:
Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data
Executing batch file 'rad0510A.bat'...
processed file: C:\Program Files\PostgreSQL\9.6\data
Successfully processed 1 files; Failed processing 0 files
Bad Install:
Called AclCheck(D:\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data
Executing batch file 'rad6DBC7.bat'...
On 04/23/2018 07:09 PM, Dale Seaburg wrote: > Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a > few lines of log file where they differ between a good install and a bad > incomplete install. The good install was from my Shop PC with Windows > 10 Pro. > > BTW, I had success with another Dell PC with Win 10 Pro about 4 months > ago. This problem appears to be a one-off. So is the below from the bitrock_installer logs or the Event Viewer logs? Big difference I notice is C:\ vs D:\. Where is D:\? > > Good Install: > /Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)// > //Called IsVistaOrNewer()...// > // 'winmgmts' object initialized...// > // Version:10.// > // MajorVersion:10// > //Executing icacls to ensure the SHOP-PC\Dale account can read the path > C:\Program Files\PostgreSQL\9.6\data// > // Executing batch file 'rad0510A.bat'...// > // processed file: C:\Program Files\PostgreSQL\9.6\data// > //Successfully processed 1 files; Failed processing 0 files/ > > Bad Install: > /Called AclCheck(D:\PostgreSQL\9.6\data)// > //Called IsVistaOrNewer()...// > // 'winmgmts' object initialized...// > // Version:10.// > // MajorVersion:10// > //Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can > read the path D:\PostgreSQL\9.6\data// > // Executing batch file 'rad6DBC7.bat'...// > // > /Notice the last four lines of the *Good Install* vs the last two lines > of the *Bad Install*. There is no indication of processing, or whether > it was successful or not in the bad install. > > As you can see, I even took Igor's suggestion to install in a non-system > (Program Files) path, to no success. > > Again, not sure what to do. Open for suggestions... I'm almost ready > to call Dell and complain about a "bad" Win 10 Pro install. > > Dale -- Adrian Klaver adrian.klaver@aklaver.com
From: Dale Seaburg [mailto:kg5lt@verizon.net]
Sent: Monday, April 23, 2018 10:10 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Strange error in Windows 10 Pro
Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro.
BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off.
Good Install:
Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data
Executing batch file 'rad0510A.bat'...
processed file: C:\Program Files\PostgreSQL\9.6\data
Successfully processed 1 files; Failed processing 0 files
Bad Install:
Called AclCheck(D:\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data
Executing batch file 'rad6DBC7.bat'...
Notice the last four lines of the Good Install vs the last two lines of the Bad Install. There is no indication of processing, or whether it was successful or not in the bad install.
As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success.
Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install.
Dale
Dale,
The problem isn’t in “bad” Win10 Pro install.
The problem is that Win10 on this machine is configured differently from Win10 machine where your install worked fine.
In Windows there is a “default” association between file types/extensions and programs that execute these files by default. Batch files like 'rad6DBC7.bat' shouldn’t have any association, Win OS knows that this type should be executed by OS, like .exe types. But sometimes Windows users change it, and associate .bat files with Notepad (or some other text editor) in order to be able to edit batch scripts. By the way, batch file names are different in “good” and “bad” installations because those are temporary files created by vbs scripts that are running during install.
So, in order to fix this you need to dissociate .bat type/extension from Notepad, or whatever text editor it is associated on the “bad” Windows. If you don’t know where to look for this feature in Win OS, ask someone who’s more familiar with windows environment.
Pretty sure that’s the solution of your problem.
Regards,
Igor Neyman
Just to put a finishing note to this thread: I am placing the blame on the mfg of the PC - was supposed to be a NEW, but had a Reburbished sticker on the bottom of the case. Now, whether it was the PC mfg or Microsoft's fault, I really could care less - the PC became useless for installing PostgreSQL - versions 8.4.5, 9.6.7 or 10.3. The install ALWAYS failed at the very last step - the building of the internal folders, etc of the data folder.
So, in frustration, I have chosen to install 8.4.5 on an older PC running XP. It just works! I don't like it, but I am constrained by the owner's wishes.
Thanks, for offering each of your individual helps.
Regards,
Dale Seaburg
Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the data folder are to be created, or copied into, it leaves an error message as noted previously. The data folder is empty.
It's almost as if the PC is missing a critical .dll needed in the data folder filling function (my guess).
Again, I am at a loss as to what to do.
Dale
On 4/20/2018 11:13 PM, Dale Seaburg wrote:Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder.
I hope tomorrow to visit the customer and try the Admin user method of installing.
Dale
On 4/20/2018 11:03 PM, Adrian Klaver wrote:On 04/20/2018 07:52 PM, Dale Seaburg wrote:
Please also reply to list.
Ccing list to put it front of more eyes.Thanks, Adrian, for suggestion(s).
On 4/20/2018 9:35 PM, Adrian Klaver wrote:On 04/20/2018 07:16 PM, Dale Seaburg wrote:downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611".I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It
This was downloaded from where?I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems.gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue.
You are running as Admin user?
As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly.
Dale Seaburg