Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
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
Post Reply
automacaosamos
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 16.07.2024, 18:31

Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by automacaosamos »

It works normally on Windows,
but when I compile for Linux when accessing the database I get the message: Access violation

What would be the solution?

Thanks.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1944
Joined: 17.01.2011, 14:17

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by marsupilami »

Hello,

unfortunately my crystal ball is still in the workshop for repair. So, there are some questions:
- Which version of FPC do you use? AlmaLinux 8.6 is deprecated and Lazarus 2.2.6 is old too.
- Which database do you work with? PostgreSQL? MariaDB? Firebird? MS SQL Server? SQLIte? Something else?
- Which version of the database system do you use?
- What do you try to do when you get the access violation?
- Maybe you could share a sample project that shows the probelm.

Best regards,

Jan
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 787
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by aehimself »

In my experience, access violations occur with Zeos in two occasions:
- Outdated driver and/or incorrect multithreaded usage. I'm looking at you, Oracle...
- There is a bug in Zeos. Can happen, but as Zeos 8 runs rock solid in my applications for a looooong time now I'd say it's less likely.

As Jan already mentioned, no information was provided so we can not even guess where / why it happens.

A stack trace would be a nice place to start :)

Edit: two occasions excluding user errors*
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
automacaosamos
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 16.07.2024, 18:31

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by automacaosamos »

For testing I installed AlmaLinux 9.4, generated a code in Linux CrossCompile on Windows.
and I'm finding "Access Violation" with Lazarus 3.99, Firebird 3.0, ZeosLib 8.0 Putting the word 'interbase' in the protocol works on Windows. but it doesn't work on Linux.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1944
Joined: 17.01.2011, 14:17

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by marsupilami »

What happens, if you compile your code on Linux? Do you get any stack trace?
automacaosamos
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 16.07.2024, 18:31

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by automacaosamos »

compilation is done normally, on Windows using the crossCompiler.
The error occurs at the time of execution, on Linux both setting the
'interbase' or 'firebird' protocol shows 'Access Violation' in the log
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1944
Joined: 17.01.2011, 14:17

Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6

Post by marsupilami »

automacaosamos wrote: 08.10.2024, 17:07 compilation is done normally, on Windows using the crossCompiler.
Ok - in that case I will rephrase my request: Please use the native linux compiler and check what happens. If you still have a problem then, please provide a minimum working example that shows the problem.

Best regards,

Jan
Post Reply