View Issue Details

IDProjectCategoryView StatusLast Update
0035322LazarusDatabasepublic2019-10-19 13:19
ReporterAnthony WalterAssigned To 
Status newResolutionopen 
PlatformLinuxOSUbuntuOS Version16.04
Product VersionProduct Build 
Target VersionFixed in Version 
Summary0035322: AV errors on Linux with the sqldb package and TSQLQuery with TSQLConnection
DescriptionWhen using the Microsoft SQL server components on Linux and connecting to a remote server I receive intermittent access violation errors when I open a project and change the active property of TSQLQuery or TSQLConnection components.
Steps To ReproduceIn Linux start a new project. Drop TSQLConnection, TSQLTransaction, TSQLQuery, TDataSource, and a TDBGrid on a form. Set them up to connect to a SQL Server instance on a Windows computer. Set them to active and you should have a working program that reads data from a remote SQL database.

Close Lazarus.

Repopen Lazarus.

Change your TSQLQuery Active property to False at design time.

Often, though not always, I receive an access violation and Lazarus begins to misbehave forcing me to close Lazarus.
Additional InformationI've attached a screen shot as well as a stack trace. I've been able to reproduce this on both the trunk and fixes_2_0 svn revisions of Lazarus.

:~$ sudo gdb -batch -ex bt -p 29126

[New LWP 29127]
[New LWP 29128]
[New LWP 29129]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/".
0x00007fb9b9ed374d in poll () at ../sysdeps/unix/syscall-template.S:84
84 ../sysdeps/unix/syscall-template.S: No such file or directory.
#0 0x00007fb9b9ed374d in poll () at ../sysdeps/unix/syscall-template.S:84
0000001 0x00000000004ea81c in GTK2POLLFUNCTION (UFDS=0x3858b80, NFSD=5, TIMEOUT=50) at gtk2/
0000002 0x00007fb9bad9238c in ?? () from /lib/x86_64-linux-gnu/
0000003 0x00007fb9bad92712 in g_main_loop_run () from /lib/x86_64-linux-gnu/
0000004 0x00007fb9bb371b83 in gtk_dialog_run () from /usr/lib/x86_64-linux-gnu/
0000005 0x000000000050c264 in PROMPTUSER (this=0x7fb9bc6fa310, DIALOGCAPTION=0x137b180 "Error", DIALOGMESSAGE=0x7fb994e803d8 "Access violation", DIALOGTYPE=257, BUTTONS=0x7fb9a8943c60, BUTTONCOUNT=1, DEFAULTINDEX=0, ESCAPERESULT=2) at gtk2/
0000006 0x00000000005b982d in PROMPTUSER (DIALOGCAPTION=0x137b180 "Error", DIALOGMESSAGE=0x7fb994e803d8 "Access violation", DIALOGTYPE=257, BUTTONS=0x7fb9a8943c60, BUTTONCOUNT=1, DEFAULTINDEX=0, ESCAPERESULT=2) at include/
0000007 0x000000000057ae91 in MESSAGEDLG (ACAPTION=0x137b180 "Error", AMSG=0x11fdc10 "Access violation", DLGTYPE=MTERROR, BUTTONS=..., HELPCTX=0) at include/
0000008 0x00000000008d5937 in SETROWVALUE (this=0x7fb994a87930, CHECKFOCUS=true, FORCEVALUE=true) at objectinspector.pp:1602
0000009 0x00000000008d65c3 in VALUECHECKBOXCLICK (this=0x7fb994a87930, SENDER=0x7fb994a88d90) at objectinspector.pp:1764
0000010 0x0000000000cc7e33 in SETSTATE (this=0x7fb994a88d90, AVALUE=CBUNCHECKED) at checkboxthemed.pas:475
0000011 0x0000000000cc7d14 in SETCHECKED (this=0x7fb994a88d90, AVALUE=false) at checkboxthemed.pas:460
0000012 0x00000000008d86a5 in SETITEMINDEXANDFOCUS (this=0x7fb994a87930, NEWITEMINDEX=0, WASVALUECLICK=true) at objectinspector.pp:2295
0000013 0x00000000008d8a30 in MOUSEDOWN (this=0x7fb994a87930, BUTTON=MBLEFT, SHIFT=..., X=184, Y=7) at objectinspector.pp:2399
0000014 0x00000000005a1998 in DOMOUSEDOWN (this=0x7fb994a87930, MESSAGE=..., BUTTON=MBLEFT, SHIFT=...) at include/
0000015 0x00000000005a1fd9 in WMLBUTTONDOWN (this=0x7fb994a87930, MESSAGE=...) at include/
0000016 0x0000000000431bca in SYSTEM$_$TOBJECT_$__$$_DISPATCH$formal ()
0000017 0x00007fb994a87930 in ?? ()
0000018 0x00007fff33fc7e10 in ?? ()
0000019 0x0000000000000201 in ?? ()
0000020 0x000000000000002c in ?? ()
0000021 0x00000000016d3900 in .Ld233 ()
0000022 0x00000000016d3228 in VMT_$CONTROLS_$$_TWINCONTROL$indirect ()
0000023 0x00007fff33fc8090 in ?? ()
0000024 0x0000000003c41710 in ?? ()
0000025 0x00007fff33fc80b0 in ?? ()
0000026 0x00007fff33fc8110 in ?? ()
0000027 0x000000000066aee0 in ?? ()
0000028 0x00000000005a18a4 in WNDPROC (this=0x7fb994a87930, THEMESSAGE=...) at include/
0000029 0x0000000000594899 in WNDPROC (this=0x7fb994a87930, MESSAGE=...) at include/
0000030 0x0000000000754322 in DELIVERMESSAGE (TARGET=0x7fb994a87930, AMESSAGE=0) at lclmessageglue.pas:112
0000031 0x000000000065d950 in DELIVERMESSAGE (TARGET=0x7fb994a87930, AMESSAGE=0) at gtk2/
0000032 0x000000000066b8a9 in DELIVERMOUSEDOWNMESSAGE (WIDGET=0x3c287f0, EVENT=0x41f8c30, AWINCONTROL=0x7fb994a87930) at gtk2/
0000033 0x000000000066af18 in GTKMOUSEBTNPRESS (WIDGET=0x3c41710, EVENT=0x41f8c30, DATA=0x7fb994a87930) at gtk2/
TagsNo tags attached.
Fixed in Revision
WidgetsetGTK 2
Attached Files


Anthony Walter

2019-04-04 20:21


sql-linux-av.jpg (1,058,231 bytes)

Juha Manninen

2019-10-19 13:19

developer   ~0118686

I improved the error message in trunk r62091. It now includes the value that triggered an exception.
Please test again.

Issue History

Date Modified Username Field Change
2019-04-04 20:21 Anthony Walter New Issue
2019-04-04 20:21 Anthony Walter File Added: sql-linux-av.jpg
2019-06-19 13:08 Bart Broersma Project Lazarus CCR => Lazarus
2019-10-19 13:19 Juha Manninen Note Added: 0118686