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.
Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
-
- Fresh Boarder
- Posts: 7
- Joined: 16.07.2024, 18:31
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
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
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
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
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*
- 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.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
-
- Fresh Boarder
- Posts: 7
- Joined: 16.07.2024, 18:31
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
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.
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.
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
What happens, if you compile your code on Linux? Do you get any stack trace?
-
- Fresh Boarder
- Posts: 7
- Joined: 16.07.2024, 18:31
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
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
The error occurs at the time of execution, on Linux both setting the
'interbase' or 'firebird' protocol shows 'Access Violation' in the log
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Erro: ZeosLib 8.0 Access violation AlmaLinux 8.6 Lazarus 2.2.6
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.automacaosamos wrote: ↑08.10.2024, 17:07 compilation is done normally, on Windows using the crossCompiler.
Best regards,
Jan