[patch_done] PostgreSQL64 + Lazarus 09.30.2+ windows 64 bit

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

elidorio2,

this is strange. I must admit i can't help you any more. :cry:

I changed your thread toppic to clearify the problem more logical.
Let's wait for other Lazarus+PostgreSQL-users who can help and guid you better than me. Contact ism if you doubt. He has mor fpc expierences... Maybe you can help us with futher expiriences.

So we've found and solved a bug with the MSecsToTimeStamp. I small success for Zeos7. 8)

Let's wait for a LCL+PosgreSQL guru. Be patient somtimes it could take some time...

best regards,

EgonHugeist
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Post by elidorio2 »

Hello EgonHugeist,

Please do not leave me, we're getting wool.
Let's try a little more, must be something simple, with postgresql dll.
I know you can, the hardest part you've got.
If we can not resolve this problem, I'll have my Zeos goods leave the project because it must run in win 7 64.
I await your return,

hugs,

Edson
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

With mysql in 64 bit win 7 program crash with 64 bit libmysql.dll

from trunk too (after correction error DateTime)

Lazarus 0.9.30.4 fpc 2.6.0

Need time and step by step tracing

Maybe problem with data types in 64 bit

Image
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

elidorio2,

it wasn't my intention to say we leave you. But we've all our day to day jobs. Actually im bussy with my private work.

possible issues we've to think about concerning this PG exception:

  1. 1. Is it possible that the pglib.dll 64Bit header has changes and we don't know it?

    2. Do we use old integers instead of pointers in our code? Here i've took a look. First impression: No. But still possible.

    3. A code snipped from PG9 64 pgtypes_interval.h:

    Code: Select all

    typedef struct
    %u7b
    #ifdef HAVE_INT64_TIMESTAMP
    	int64		time;			/* all time units other than months and years */
    #else
    	double		time;			/* all time units other than months and years */
    #endif
    	long		month;			/* months and years, after time for alignment */
    %u7d	interval;
    Which means ism is eventually right.

    4. Where, when, why happens this access violocation?

    5. If the integers are right in the plaindriver definitions than which one (2byte smallint/4byte Integer/ 8byte Int64) is in use for which function? As far as i can see (quick look) uses PostgreSQL only 2 and 4 byte integers. But this could be changed too since 64Bit.

    6. Can we keep the olp PG plaindrivers or do we need a new 64Bit one as new protocol.

    OR is it a setting problem on your computer.
My problem is that i don't have Windows64 and actually i broke with lazarus for coding because the debugger is to slow and instable (personal oppinion -> FPC is a terific thing!! And i like it.) or i use wrong settings which i don't know. Looking for such an issue blindy and no possibility for tests must going wrong. So it would be better to get help from others like ism.

Things which where helpful to know (Please answer):
Result of: SizeOf(Integer); -> 4 or 8 byte (like in XE2 64Bit here we've to use the NativeInt for 32Bit integer)
Can you access PG in Win32 with the updated sources?

ism,

a hint or more a feeling (blindy typing now) concerning MySQL64: open MySQLResultSet.pas. Look for a function InternalGetString(ColumIndex: Integer): String;
Set a breakpoint there. Is it possible that the PULong incrementing is correct but the PULong size has changed and we point to the midle of nowhere?

elidorio2, On this post you can see how complex your problem is, Edson and w'll need some time and other users to find out what's going wrong. I wish i could consider you i can do it in a half hour but again i can't test it by my selves. :(

So be patient, don't overhurry and try to help us to help you.

Best regards,

Michael
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

Code: Select all

My problem is that i don't have Windows64
Do you know about Virtualbox ? https://www.virtualbox.org/wiki/Downloads

You can get win 7 64 for test http://www.microsoft.com/windows/busine ... mxid=mscom

and install in Virtualbox for test
Lazarus 1.0.8 fpc 2.6.0
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

ism,

Wonderfull! Started to download all the stuff.
This could solve some problems!

Thank you.
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Post by elidorio2 »

My God!

The problem is complex!
The error when trying to activate hap open the connection.
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

elidorio2,

good news. :bash: Please update your Revision to 1145. :wink:

It was more an minior issue than thought before. We wanted access the plaindrivers on ZDbcXXXConnetion.Close with several functions. But the Plaindriver isn't assigned if the dll's where not found.

Also i've tested the PG Connection in Win64+Lazarus64+FPC64 Bit everythingis fine (didn't open any tables)if the files: :cop:
libeay32.dll, libiconv-2.dll, libintl-8.dll, libpg.dll, ssleay32.dll are in your !Windows\System32! folder at designtime and/or in your application folder at runtime. :cop:

Can you confirm this :?:

And Bad news: selects don't work. Going on...

Now testing MySQL64. Thank ism for that advise. :prog2:

Best regards,

EgonHugeist
Last edited by EgonHugeist on 11.04.2012, 21:39, edited 2 times in total.
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

mysql 5.5 64bit win7 64 lazarus 0.9.30.4

zconnection.connected = true

ok

ztable zquery.active=true

access violation
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

Same with PG...

Hmpf..
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

I try debug in another

Image
Last edited by ism on 11.04.2012, 22:24, edited 3 times in total.
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

in ZDbcMySqlUtils.pas
Lazarus 1.0.8 fpc 2.6.0
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

Image
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

Wasn't that the same behavoir of the wylton thread?
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

Only step by step debug help

How to create visual diagram objects methods in modules ? There are utilities?
Lazarus 1.0.8 fpc 2.6.0
Locked