Access Violation ZEOS 7.3.0-alpha at delete record

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Herbert
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 15.05.2018, 17:24

Access Violation ZEOS 7.3.0-alpha at delete record

Postby Herbert » 15.05.2018, 18:19

Hello,
I'm new in this forum, so I hope this is the correct way to report a problem with ZEOS 7.3.:
First delete record from database is ok, second delete leads to
Access Violation
Press OK to ignore and risk data corruption
Press Abort to kill the program
In debugger I get the message
Exception SIGSEGV at address 1000098EA.
Pressing ok the next message is
EZSQLException - Access Violation - ZDbcUtils.pas - line 384
and
EZDatabaseError - Access Violation - ZAbstractDataset.pas - line 580.
It's possible to avoid the problem by defining a AfterDelete event for TZQuery. There you have to close the query and repeat the select.

My environment:
Windows 10 64k
Lazarus 1.8.2 64k
ZEOS 7.3.0-alpha
MariaDB 10.2.13 64k
In TZConnection I used Protocol mysql because in 7.3 there is no own protocol available for MariaDB.

Is this a known problem and if yes is a solution available?

marsupilami
Gold Boarder
Gold Boarder
Posts: 671
Joined: 17.01.2011, 14:17

Re: Access Violation ZEOS 7.3.0-alpha at delete record

Postby marsupilami » 16.05.2018, 08:40

Hello Herbert,

could you please create a small sample application and a script for a small sample database that demonstrates the problem? This will help us a lot in tracking down the problem.

Using the mysql protocol for MariaDB is correct because Zeos currently has next to no separate code for MariaDB. This might change in the future.

@Egonhuheist: Maybe it makes sense to start a mariadb protocol as an alias for mysql? I seem to remember that you added some code for MariaDB already and that there is a ticket in the tracker that relies on new features of MySQL?

Best regards,

Jan

miab3
Zeos Test Team
Zeos Test Team
Posts: 950
Joined: 11.05.2012, 12:32
Location: Poland

Re: Access Violation ZEOS 7.3.0-alpha at delete record

Postby miab3 » 16.05.2018, 10:31

@Herbert
Herbert wrote:Hello,
My environment:
Windows 10 64k
Lazarus 1.8.2 64k
ZEOS 7.3.0-alpha

And what is the svn version?

Michal

Herbert
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 15.05.2018, 17:24

Re: Access Violation ZEOS 7.3.0-alpha at delete record

Postby Herbert » 16.05.2018, 12:35

Thank you all for your help and quick response.

@Michal
I used ZEOS 7.3.0 4526.
Today I tried to install new version 4573 but I got compile error in package zdbc 7.3:
ZDbcMySqlResultSet.pas(596,112) Error: Incompatible type for arg no. 2: Got "TZMySQLPlainDriver.<procedure variable type of
function:DWord;StdCall>", expected "QWord"

@Jan
I created a small program, only DBGrid and DBNavigator and a database with only two fields index and data. To create the error insert two or more records into the database then delete the records. First delete is ok, second delete crashes. When you activate the event AfterDelete for SQLQ, you can delete all records.

Best regards,
Herbert
You do not have the required permissions to view the files attached to this post.

miab3
Zeos Test Team
Zeos Test Team
Posts: 950
Joined: 11.05.2012, 12:32
Location: Poland

Re: Access Violation ZEOS 7.3.0-alpha at delete record

Postby miab3 » 16.05.2018, 17:33


Herbert
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 15.05.2018, 17:24

Re: Access Violation ZEOS 7.3.0-alpha at delete record

Postby Herbert » 17.05.2018, 23:06

Hello Michal,

When I use the link you provided I now get version 4584. Trying this version I get the same compile error as with version 4573. How can I get your version 4566?

Best regards,
Herbert


Return to “ZeosLib 7.3 Forum”

Who is online

Users browsing this forum: No registered users and 0 guests