[Pljava-dev] Windows 64bit: Call for further testing

Hi all,

I'm releasing my latest 64bit Windows binary to the general public
for testing. It is currently labelled beta and I do hope it works.
All problems reported by Eric and Jose *should* be fixed.

Please let me know if it works and particularly if it doesn't.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Im getting the same error about PG_MODULE_MAGIC as before.Trying to use loadlibrary64 I get:
"the program cant start because libstdc++6.dll is missing for your computer"
Should I install anything else to try to run the loadlibrary to send you more information?
Erik..you could run pljava finally?
good night guys,jose

> To: pljava-dev at pgfoundry.org
> Date: Mon, 2 May 2011 21:04:10 +0000
> From: johann at 2ndquadrant.com
> Subject: [Pljava-dev] Windows 64bit: Call for further testing
>
> Hi all,
>
> I'm releasing my latest 64bit Windows binary to the general public
> for testing. It is currently labelled beta and I do hope it works.
> All problems reported by Eric and Jose *should* be fixed.
>
> Please let me know if it works and particularly if it doesn't.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110503/a2692c3b/attachment.html>

I am still getting the same problem with DependencyWalker that
IEFRAME.DLL cannot resolve 3 entry points.

Jose, did you install those 4 DLLs I mentioned on Friday?

Cheers, Eric

On 2011-05-02 3:00 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
>
> Im getting the same error about PG_MODULE_MAGIC as before.
> Trying to use loadlibrary64 I get:
>
> "the program cant start because libstdc++6.dll is missing for your
> computer"
>
> Should I install anything else to try to run the loadlibrary to send
> you more information?
>
> Erik..you could run pljava finally?
>
> good night guys,
> jose
>
>
>
> > To: pljava-dev at pgfoundry.org
> > Date: Mon, 2 May 2011 21:04:10 +0000
> > From: johann at 2ndquadrant.com
> > Subject: [Pljava-dev] Windows 64bit: Call for further testing
> >
> > Hi all,
> >
> > I'm releasing my latest 64bit Windows binary to the general public
> > for testing. It is currently labelled beta and I do hope it works.
> > All problems reported by Eric and Jose *should* be fixed.
> >
> > Please let me know if it works and particularly if it doesn't.
> >
> >
> > --
> > Johann Oskarsson http://www.2ndquadrant.com/ |[]
> > PostgreSQL Development, 24x7 Support, Training and Services --+--
> > |
> > Blog: http://my.opera.com/myrkraverk/blog/
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110502/81c938a0/attachment.html>

On Mon, 02 May 2011 22:00:55 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> Im getting the same error about PG_MODULE_MAGIC as before.

Yes, I discovered that the symbol is not exported correctly in the
DLL. I'm not sure but this may actually be a problem with the PG
build system since on the PL/Java side it's just an expanded macro.

Needless to say, I'm working on this now. I only have a few hours
to work on this today so I guess I may not have a new build until
tomorrow.

Eric, how did you install the MSVC DLLs? It should be enough to
just install the redistributables. You should not have had to copy
the DLLs anywhere. If you did anything of the sort, can you let me
know what?

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

On Tue, 03 May 2011 05:25:12 -0000, Johann 'Myrkraverk' Oskarsson
<johann at 2ndquadrant.com> wrote:

> On Mon, 02 May 2011 22:00:55 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
>> Im getting the same error about PG_MODULE_MAGIC as before.

This should be fixed now. Please try the new upload of

BETA-pljava-x86_64-w64-mingw32-pg9.0-1.4.2.tar.gz

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Hi Johann,
maybe Im doing something wrong? now I get:

psql:c:/jaspa4pg/sql/pljavainstall.sql:6: ERROR:? could not find function "java_
call_handler" in file "c:/jaspa4pg/lib/pljava.dll"
psql:c:/jaspa4pg/sql/pljavainstall.sql:8: ERROR:? function sqlj.java_call_handle
r() does not exist
psql:c:/jaspa4pg/sql/pljavainstall.sql:12: ERROR:? could not find function "java
u_call_handler" in file "c:/jaspa4pg/lib/pljava.dll"
psql:c:/jaspa4pg/sql/pljavainstall.sql:14: ERROR:? function sqlj.javau_call_hand
ler() does not exist

Erik,
I didnt put the dlls you told us.
are they nedded for running loadlibrary64 or for running pljava?

I guess its for running loadlibrary64 because we didnt use them if previous pljava version and the computer
does not have them by default but im not sure.

----------------------------------------
> To: pljava-dev at pgfoundry.org
> Date: Tue, 3 May 2011 06:39:06 +0000
> From: johann at 2ndquadrant.com
> Subject: Re: [Pljava-dev] Windows 64bit: Call for further testing
>
> On Tue, 03 May 2011 05:25:12 -0000, Johann 'Myrkraverk' Oskarsson
> wrote:
>
> > On Mon, 02 May 2011 22:00:55 -0000, JOSE CARLOS MARTINEZ LLARIO
> > wrote:
> >
> >> Im getting the same error about PG_MODULE_MAGIC as before.
>
> This should be fixed now. Please try the new upload of
>
> BETA-pljava-x86_64-w64-mingw32-pg9.0-1.4.2.tar.gz
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

Hi Jose,

On Tue, 03 May 2011 12:55:04 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> maybe Im doing something wrong? now I get:
> psql:c:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not find
> function "java_> call_handler" in file "c:/jaspa4pg/lib/pljava.dll"

You're not doing anything wrong. This is my fault, I'm still getting
the hang of the mingw + pgxs build system. I have time to look into
this tomorrow.

Until then, have fun,

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Basically I dropped the files msvcr90.dll, msvcp90.dll, msvcm90.dll and
IEShims into the Postgres/bin directory.

If I do not do this then DependencyWalker cannot find msvcr90.dll.

So just now I did another clean install of postgresql-9.0.4-1-windows_x64

Then I ran vcredist_x64 again and clicked repair.

Finally I dropped pljava.dll into the lib directory of Postgres from
your latest BETA release. Same problem, DependencyWalker cannot find
msvcr90.dll. Also, DependencyWalker still shows the same problem with
IEFRAME.DLL.

What do you suggest I try next?

Cheers, Eric

On 2011-05-02 10:25 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Mon, 02 May 2011 22:00:55 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
>> Im getting the same error about PG_MODULE_MAGIC as before.
>
> Yes, I discovered that the symbol is not exported correctly in the
> DLL. I'm not sure but this may actually be a problem with the PG
> build system since on the PL/Java side it's just an expanded macro.
>
> Needless to say, I'm working on this now. I only have a few hours
> to work on this today so I guess I may not have a new build until
> tomorrow.
>
> Eric, how did you install the MSVC DLLs? It should be enough to
> just install the redistributables. You should not have had to copy
> the DLLs anywhere. If you did anything of the sort, can you let me
> know what?
>
>

Jose, the DLLs I referenced are required to resolve dependency problems
I discovered with DependencyWalker.

Cheers, Eric

On 2011-05-03 5:55 AM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi Johann,
> maybe Im doing something wrong? now I get:
>
> psql:c:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not find function "java_
> call_handler" in file "c:/jaspa4pg/lib/pljava.dll"
> psql:c:/jaspa4pg/sql/pljavainstall.sql:8: ERROR: function sqlj.java_call_handle
> r() does not exist
> psql:c:/jaspa4pg/sql/pljavainstall.sql:12: ERROR: could not find function "java
> u_call_handler" in file "c:/jaspa4pg/lib/pljava.dll"
> psql:c:/jaspa4pg/sql/pljavainstall.sql:14: ERROR: function sqlj.javau_call_hand
> ler() does not exist
>
> Erik,
> I didnt put the dlls you told us.
> are they nedded for running loadlibrary64 or for running pljava?
>
> I guess its for running loadlibrary64 because we didnt use them if previous pljava version and the computer
> does not have them by default but im not sure.
>
> ----------------------------------------
>> To: pljava-dev at pgfoundry.org
>> Date: Tue, 3 May 2011 06:39:06 +0000
>> From: johann at 2ndquadrant.com
>> Subject: Re: [Pljava-dev] Windows 64bit: Call for further testing
>>
>> On Tue, 03 May 2011 05:25:12 -0000, Johann 'Myrkraverk' Oskarsson
>> wrote:
>>
>>> On Mon, 02 May 2011 22:00:55 -0000, JOSE CARLOS MARTINEZ LLARIO
>>> wrote:
>>>
>>>> Im getting the same error about PG_MODULE_MAGIC as before.
>> This should be fixed now. Please try the new upload of
>>
>> BETA-pljava-x86_64-w64-mingw32-pg9.0-1.4.2.tar.gz
>>
>>
>> --
>> Johann Oskarsson http://www.2ndquadrant.com/ |[]
>> PostgreSQL Development, 24x7 Support, Training and Services --+--
>> |
>> Blog: http://my.opera.com/myrkraverk/blog/
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

On Tue, 03 May 2011 14:07:57 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> Jose, the DLLs I referenced are required to resolve dependency problems
> I discovered with DependencyWalker.

Have you tried to run pl/java, just for the heck of it?

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

On 05/03/11 6:49 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Tue, 03 May 2011 12:55:04 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
>> maybe Im doing something wrong? now I get:
>> psql:c:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not find
>> function "java_> call_handler" in file "c:/jaspa4pg/lib/pljava.dll"
>
> You're not doing anything wrong. This is my fault, I'm still getting
> the hang of the mingw + pgxs build system. I have time to look into
> this tomorrow.

may I suggest these builds should be called 'TEST-...' rather than
'BETA-....' ? BETA code is generally assumed to have passed some
reasonable level of unit testing and to be at least basically usable.

OK, after adding the other missing DLLs, when I try to run install.sql I get

ERROR: incompatible library "C:/Program Files
(Open)/Kodak/Intersystem/Postgres/lib/pljava.dll": missing magic block

That is actually something I have not seen before.

DependencyWalker is still complaining about IEFRAME.DLL

Cheers, Eric

On 2011-05-03 8:47 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Tue, 03 May 2011 14:07:57 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Jose, the DLLs I referenced are required to resolve dependency
>> problems I discovered with DependencyWalker.
>
> Have you tried to run pl/java, just for the heck of it?
>
>

On Tue, 03 May 2011 19:32:53 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> OK, after adding the other missing DLLs, when I try to run install.sql I
> get
>
> ERROR: incompatible library "C:/Program Files
> (Open)/Kodak/Intersystem/Postgres/lib/pljava.dll": missing magic block
>
> That is actually something I have not seen before.

This means the server is resolving all dependencies and loading the
DLL. This error is my fault and has been fixed in TEST-build0x-...,
using naming convention based on John's suggestion.

I'm curious to know which or both of the build01 and build02 files
work? I used different methods of symbol exporting for these builds.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Both build01 and build02 seem to work fine for me :-)

Wha-Hoo!

Awesome, you did it Johann - way to go.

DependencyWalker is still complaining about IEFRAME.DLL, but the
important thing is the pljava.dll seems to be working now.

I still have to do further testing with my actual Java code however, but
it's almost bed time so I will have to work on that tomorrow.

Cheers, Eric

On 2011-05-03 10:16 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Tue, 03 May 2011 19:32:53 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> OK, after adding the other missing DLLs, when I try to run
>> install.sql I get
>>
>> ERROR: incompatible library "C:/Program Files
>> (Open)/Kodak/Intersystem/Postgres/lib/pljava.dll": missing magic block
>>
>> That is actually something I have not seen before.
>
> This means the server is resolving all dependencies and loading the
> DLL. This error is my fault and has been fixed in TEST-build0x-...,
> using naming convention based on John's suggestion.
>
> I'm curious to know which or both of the build01 and build02 files
> work? I used different methods of symbol exporting for these builds.
>
>

That is wonderfull!!!!

Pljava is working in my computer too. Thanks a lot Johann you did a very good job!.
I tried build01 and build02. I didnt notice any difference with them.

I didnt add any of the dlls you guys are talking about I guess they are needed just for building not for running pljava or windows 64 have them by default?

I will keep testing just in case.

Erik,
I will test w64,pg32 and pljava32 today again.

Best,

----------------------------------------
> To: pljava-dev at pgfoundry.org
> Date: Wed, 4 May 2011 05:16:13 +0000
> From: johann at 2ndquadrant.com
> Subject: Re: [Pljava-dev] Windows 64bit: Call for further testing
>
> On Tue, 03 May 2011 19:32:53 -0000, Eric Kolotyluk
> wrote:
>
> > OK, after adding the other missing DLLs, when I try to run install.sql I
> > get
> >
> > ERROR: incompatible library "C:/Program Files
> > (Open)/Kodak/Intersystem/Postgres/lib/pljava.dll": missing magic block
> >
> > That is actually something I have not seen before.
>
> This means the server is resolving all dependencies and loading the
> DLL. This error is my fault and has been fixed in TEST-build0x-...,
> using naming convention based on John's suggestion.
>
> I'm curious to know which or both of the build01 and build02 files
> work? I used different methods of symbol exporting for these builds.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

On Wed, 04 May 2011 11:43:21 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> Pljava is working in my computer too. Thanks a lot Johann you did a very
> good job!.
> I tried build01 and build02. I didnt notice any difference with them.

There shouldn't be, they are simply built with two different commands, one
with dllwrap, the other with gcc.

> I didnt add any of the dlls you guys are talking about I guess they are
> needed just for building not for running pljava or windows 64 have them
> by default?

That's good to know. Did you already install the MSVC redistributables
perhaps? If that's needed, it's good to document.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Hi Johann,
I checked it now and yes I have the MS Visual C++ 2008 redistributale x86 9.0 already installed.

That redistributable was installed by Postgres so any postgres windows installation should have it at least with postgres 9 because i checked it.

I uninstalled this redistributable and pljave was still working, maybe the dlls are still in windows dirs.

Cheers,
jose

Going

----------------------------------------
> To: pljava-dev at pgfoundry.org
> Date: Wed, 4 May 2011 14:50:53 +0000
> From: johann at 2ndquadrant.com
> Subject: Re: [Pljava-dev] Windows 64bit: Call for further testing
>
> On Wed, 04 May 2011 11:43:21 -0000, JOSE CARLOS MARTINEZ LLARIO
> wrote:
>
> > Pljava is working in my computer too. Thanks a lot Johann you did a very
> > good job!.
> > I tried build01 and build02. I didnt notice any difference with them.
>
> There shouldn't be, they are simply built with two different commands, one
> with dllwrap, the other with gcc.
>
> > I didnt add any of the dlls you guys are talking about I guess they are
> > needed just for building not for running pljava or windows 64 have them
> > by default?
>
> That's good to know. Did you already install the MSVC redistributables
> perhaps? If that's needed, it's good to document.
>
>
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

On Wed, 04 May 2011 16:20:47 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

>
> Hi Johann,
> I checked it now and yes I have the MS Visual C++ 2008 redistributale
> x86 9.0 already installed.
>
> That redistributable was installed by Postgres so any postgres windows
> installation should have it at least with postgres 9 because i checked
> it.

That's good to know, and hopefully means I do not have to explicitly men-
tion that dependency in installation documents. At least not the generic
ones.

> I uninstalled this redistributable and pljave was still working, maybe
> the dlls are still in windows dirs.

That seems likely because you're able to run both the Postgres server as
well as PL/Java. Or maybe you only uninstalled the 32bit redistributable
and are running 64bit server and PL/Java with the corresponding 64bit re-
distributables?

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/