I'm receiving constant errors when trying to connect to a postgres database

[expired user #9233]'s profile image [expired user #9233] posted 9 years ago in General Permalink
date/time          : 2015-09-03, 00:09:03, 99ms
computer name      : HP
user name          : desbest
registered owner   : USer / Hewlett-Packard
operating system   : Windows 8 x64 build 9200
system language    : English
system up time     : 3 days 13 hours
program up time    : 4 minutes 7 seconds
processors         : 4x Intel(R) Core(TM) i3-5010U CPU @ 2.10GHz
physical memory    : 348/8114 MB (free/total)
free disk space    : (C:) 684.57 GB
display mode       : 1366x768, 32 bit
process id         : $5bdc
allocated memory   : 46.91 MB
largest free block : 1.11 GB
executable         : heidisql.exe
exec. date/time    : 2015-08-12 23:56
version            : 9.3.0.4984
compiled with      : Delphi XE5
madExcept version  : 4.0.8.1
callstack crc      : $4cabd7cb, $17692111, $17692111
exception number   : 1
exception class    : EPrivilege
exception message  : Privileged instruction.
main thread ($5794):
00520cfc heidisql.exe System.Classes            TList.Grow
00520dad heidisql.exe System.Classes            TList.Insert
005b26ed heidisql.exe Vcl.Controls              DoAlign
005b2c07 heidisql.exe Vcl.Controls              TWinControl.AlignControls
005b2d3b heidisql.exe Vcl.Controls              TWinControl.AlignControl
005b5a93 heidisql.exe Vcl.Controls              TWinControl.WMSize
005f3191 heidisql.exe Vcl.ComCtrls              TCustomTabControl.WMSize
005affd5 heidisql.exe Vcl.Controls              TControl.WndProc
005b4af5 heidisql.exe Vcl.Controls              TWinControl.WndProc
005b4138 heidisql.exe Vcl.Controls              TWinControl.MainWndProc
0053b624 heidisql.exe System.Classes            StdWndProc
005f3f5b heidisql.exe Vcl.ComCtrls              TPageControl.DeleteTab
005f38d1 heidisql.exe Vcl.ComCtrls              TTabSheet.SetTabShowing
005f3934 heidisql.exe Vcl.ComCtrls              TTabSheet.UpdateTabShowing
005f38e6 heidisql.exe Vcl.ComCtrls              TTabSheet.SetTabVisible
0095f02d heidisql.exe Main            7870 +138 TMainForm.DBtreeFocusChanged
0095f3d6 heidisql.exe Main            7938   +3 TMainForm.ConnectionReady
0083c67f heidisql.exe dbconnection    2118   +5 TDBConnection.DoAfterConnect
0083ac4f heidisql.exe dbconnection    1939  +34 TPgConnection.SetActive
0094e617 heidisql.exe Main            3518   +7 TMainForm.InitConnection
008cc35a heidisql.exe connections      325   +5 Tconnform.btnOpenClick
005b0549 heidisql.exe Vcl.Controls              TControl.DblClick
005b06c4 heidisql.exe Vcl.Controls              TControl.WMLButtonDblClk
0070b07a heidisql.exe VirtualTrees   17157   +2 TBaseVirtualTree.WMLButtonDblClk
007189c8 heidisql.exe VirtualTrees   25260  +19 TBaseVirtualTree.WndProc
005b4138 heidisql.exe Vcl.Controls              TWinControl.MainWndProc
0053b624 heidisql.exe System.Classes            StdWndProc
75caa6db user32.dll                             DispatchMessageW
0068512f heidisql.exe Vcl.Forms                 TApplication.ProcessMessage
00685172 heidisql.exe Vcl.Forms                 TApplication.HandleMessage
006804de heidisql.exe Vcl.Forms                 TCustomForm.ShowModal
00946cab heidisql.exe Main            1913 +101 TMainForm.AfterFormCreate
759f7c02 KERNEL32.DLL                           BaseThreadInitThunk
ansgar's profile image ansgar posted 9 years ago Permalink
You can try the following:
* when the session manager opens up, click "More", then click "Preferences"
* in the first tab ("General"), disable the third checkbox "Restore last used database on startup".

Now see if the crash happens again or not.
[expired user #9233]'s profile image [expired user #9233] posted 9 years ago Permalink
It's fixed now but now I have another error.



Why is it trying to find a table or view called "public" when I edit a database row's field.
[expired user #9233]'s profile image [expired user #9233] posted 9 years ago Permalink
Also I have another error when trying to close the program.

date/time          : 2015-09-05, 08:55:56, 12ms
computer name      : HP
user name          : desbest
registered owner   : USer / Hewlett-Packard
operating system   : Windows 8 x64 build 9200
system language    : English
system up time     : 1 day 19 hours
program up time    : 4 minutes 59 seconds
processors         : 4x Intel(R) Core(TM) i3-5010U CPU @ 2.10GHz
physical memory    : 1412/8114 MB (free/total)
free disk space    : (C:) 687.73 GB
display mode       : 1366x768, 32 bit
process id         : $2fc4
allocated memory   : 99.17 MB
largest free block : 1.39 GB
executable         : heidisql.exe
exec. date/time    : 2015-08-12 23:56
version            : 9.3.0.4984
compiled with      : Delphi XE5
madExcept version  : 4.0.8.1
callstack crc      : $313f90c1, $a1c5460e, $903db895
exception number   : 1
exception class    : EAccessViolation
exception message  : Access violation at address 004084B0 in module 'heidisql.exe'. Read of address 000000D8.
main thread ($ddc):
004084b0 heidisql.exe System           549  +0 TObject.Free
00409846 heidisql.exe System           549  +0 @HandleFinallyInternal
7781d4c8 ntdll.dll                             RtlUnwind
777f07fa ntdll.dll                             KiUserExceptionDispatcher
004097ce heidisql.exe System           549  +0 @HandleFinally
7781d4c8 ntdll.dll                             RtlUnwind
777f07fa ntdll.dll                             KiUserExceptionDispatcher
75d13d8d WS2_32.dll                            closesocket
10004aab libpq.dll                             PQfinish
0083acce heidisql.exe dbconnection    1952 +47 TPgConnection.SetActive
0094727c heidisql.exe Main            2030 +52 TMainForm.ConnectionsNotify
0040c978 heidisql.exe System           549  +0 DynArraySetLength
0085e1aa heidisql.exe dbconnection      38  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.Notify
0085ee1f heidisql.exe dbconnection     728  +0 {System.Generics.Collections}TObjectList<dbconnection.TDBConnection>.Notify
0085e9b8 heidisql.exe dbconnection     728  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.DeleteRange
0085e010 heidisql.exe dbconnection      38  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.SetCount
0067a859 heidisql.exe Vcl.Forms                TCustomForm.DoDestroy
0067a6aa heidisql.exe Vcl.Forms                TCustomForm.Destroy
004a5b2d heidisql.exe madExcept                InterceptClassDestroy
004084b0 heidisql.exe System           549  +0 TObject.Free
00539437 heidisql.exe System.Classes           TComponent.DestroyComponents
00678439 heidisql.exe Vcl.Forms                DoneApplication
0044c109 heidisql.exe System.SysUtils          DoExitProc
00409fe9 heidisql.exe System           549  +0 @Halt0
75b27c02 KERNEL32.DLL                          BaseThreadInitThunk
main thread ($ddc), inner exception level 1:
>> EAccessViolation, Access violation at address 0040CB44 in module 'heidisql.exe'. Write of address 00BB2960
0040cb44 heidisql.exe System          549 +0 @DynArrayClear
0085e9d7 heidisql.exe dbconnection    728 +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.DeleteRange
0085e010 heidisql.exe dbconnection     38 +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.SetCount
0067a859 heidisql.exe Vcl.Forms              TCustomForm.DoDestroy
0067a6aa heidisql.exe Vcl.Forms              TCustomForm.Destroy
004a5b2d heidisql.exe madExcept              InterceptClassDestroy
004084b0 heidisql.exe System          549 +0 TObject.Free
00539437 heidisql.exe System.Classes         TComponent.DestroyComponents
00678439 heidisql.exe Vcl.Forms              DoneApplication
0044c109 heidisql.exe System.SysUtils        DoExitProc
00409fe9 heidisql.exe System          549 +0 @Halt0
75b27c02 KERNEL32.DLL                        BaseThreadInitThunk
main thread ($ddc), inner exception level 2:
>> EAccessViolation, Access violation at address 10004967 in module 'libpq.dll'. Write of address 00190010
10004967 libpq.dll
10004aab libpq.dll                             PQfinish
0083acce heidisql.exe dbconnection    1952 +47 TPgConnection.SetActive
0094727c heidisql.exe Main            2030 +52 TMainForm.ConnectionsNotify
0040c978 heidisql.exe System           549  +0 DynArraySetLength
0085e1aa heidisql.exe dbconnection      38  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.Notify
0085ee1f heidisql.exe dbconnection     728  +0 {System.Generics.Collections}TObjectList<dbconnection.TDBConnection>.Notify
0085e9b8 heidisql.exe dbconnection     728  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.DeleteRange
0085e010 heidisql.exe dbconnection      38  +0 {System.Generics.Collections}TList<dbconnection.TDBConnection>.SetCount
0067a859 heidisql.exe Vcl.Forms                TCustomForm.DoDestroy
0067a6aa heidisql.exe Vcl.Forms                TCustomForm.Destroy
004a5b2d heidisql.exe madExcept                InterceptClassDestroy
004084b0 heidisql.exe System           549  +0 TObject.Free
00539437 heidisql.exe System.Classes           TComponent.DestroyComponents
00678439 heidisql.exe Vcl.Forms                DoneApplication
0044c109 heidisql.exe System.SysUtils          DoExitProc
00409fe9 heidisql.exe System           549  +0 @Halt0
75b27c02 KERNEL32.DLL                          BaseThreadInitThunk
ansgar's profile image ansgar posted 9 years ago Permalink
The crash is happening only in the 32bit version of libpq.dll, when closing a PostgreSQL connection, and so only in the 32bit version of HeidiSQL. Use the 64bit version instead if you can. I don't have a fix for it yet.

That grid editing error should be fixed by me. However, you should not get this error when you edit the table data in the "Data" tab.
[expired user #9233]'s profile image [expired user #9233] posted 9 years ago Permalink
I'm having another error when using the "filter" feature in the data tab.


[expired user #9233]'s profile image [expired user #9233] posted 9 years ago Permalink
Also I'm getting another error when I change a field which is a foreign key or a primary key which links to a foreign key.

date/time          : 2015-09-05, 10:45:41, 326ms
computer name      : HP
user name          : desbest
registered owner   : USer / Hewlett-Packard
operating system   : Windows 8 x64 build 9200
system language    : English
system up time     : 1 day 20 hours
program up time    : 38 seconds
processors         : 4x Intel(R) Core(TM) i3-5010U CPU @ 2.10GHz
physical memory    : 1473/8114 MB (free/total)
free disk space    : (C:) 688.54 GB
display mode       : 1366x768, 32 bit
process id         : $2fe4
allocated memory   : 128.07 MB
largest free block : 1.34 GB
executable         : heidisql.exe
exec. date/time    : 2015-08-12 23:56
version            : 9.3.0.4984
compiled with      : Delphi XE5
madExcept version  : 4.0.8.1
callstack crc      : $4c460500, $2cc3c0a6, $2cc3c0a6
exception number   : 10
exception class    : EAccessViolation
exception message  : Access violation at address 4C460500. Read of address 4C460500.
main thread ($2308):
4c460500 ???
00408ae7 heidisql.exe System         549 +0 @ClassCreate
0040847f heidisql.exe System         549 +0 TObject.Create
005b2ba1 heidisql.exe Vcl.Controls          TWinControl.AlignControls
005b2d3b heidisql.exe Vcl.Controls          TWinControl.AlignControl
005ad7c4 heidisql.exe Vcl.Controls          TControl.RequestAlign
005b5ceb heidisql.exe Vcl.Controls          TWinControl.RequestAlign
005b7ad5 heidisql.exe Vcl.Controls          TWinControl.AdjustSize
005f9d74 heidisql.exe Vcl.ComCtrls          TToolBar.ResizeButtons
005f9b62 heidisql.exe Vcl.ComCtrls          TToolBar.RecreateButtons
005f716c heidisql.exe Vcl.ComCtrls          TToolButton.CMTextChanged
005affd5 heidisql.exe Vcl.Controls          TControl.WndProc
005afc10 heidisql.exe Vcl.Controls          TControl.Perform
005adacd heidisql.exe Vcl.Controls          TControl.SetTextBuf
005ae742 heidisql.exe Vcl.Controls          TControl.SetText
0096bed2 heidisql.exe Main         11623 +4 TMainForm.ApplicationEvents1Idle
0075f2e5 heidisql.exe Vcl.AppEvnts   287 +0 TCustomApplicationEvents.DoIdle
0075fb0e heidisql.exe Vcl.AppEvnts   287 +0 TMultiCaster.DoIdle
00685eb1 heidisql.exe Vcl.Forms             TApplication.Idle
0068517f heidisql.exe Vcl.Forms             TApplication.HandleMessage
006854ad heidisql.exe Vcl.Forms             TApplication.Run
75b27c02 KERNEL32.DLL                       BaseThreadInitThunk
ansgar's profile image ansgar posted 9 years ago Permalink
You misunderstood the filter option. This requires a WHERE filter (without the "WHERE"). It's not a whole SQL query.
[expired user #9233]'s profile image [expired user #9233] posted 9 years ago Permalink
I got the filter option to work. I must have done a syntax error.

Please login to leave a reply, or register at first.