Skip site navigation (1) Skip section navigation (2)

Re: Crash on delete record with filter in place

From: Colin Beckingham <colbec(at)start(dot)ca>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Crash on delete record with filter in place
Date: 2011-09-20 14:48:53
Message-ID: 4E78A7D5.3030509@start.ca (view raw or flat)
Thread:
Lists: pgadmin-support
On 09/19/2011 04:53 PM, Colin Beckingham wrote:
>
>
> On 09/19/2011 03:12 PM, Guillaume Lelarge wrote:
>> On Sat, 2011-09-17 at 17:45 -0400, Colin Beckingham wrote:
>>> Using pgadmin 1.15 Dev on Opensuse 11.4, kernel 3.0.
>>>
>>> Viewing the data in a table with full data set visible, select a record
>>> for delete, run delete, record is deleted correctly, pgadmin continues
>>> to run.
>>>
>>> View the data in a table and place a filter to show subset of records.
>>> Attempt to delete a row. This is permitted by the menus. Row is deleted
>>> correctly, however pgadmin immediately crashes both the main and the
>>> view data windows. Data is intact, restarting pgadmin allows to continue
>>> as before.
>>
>> I don't manage to get a reproducible test case. I mean, I do get some
>> crashes, but they are mostly random. Something that would crash pgAdmin
>> once won't work twice. Which doesn't help fixing it.
>>
>>
>
> Well, so far 1.15 has been working well for me. This incident (which I
> managed to repeat several times) was the only time it has let me down.
>
> I tried setting up a simple table to repeat the issue I reported but I
> admit I failed to repeat it. On my small test table with oids in place I
> was able to delete records with no filter in place or with a filter. It
> worked fine.
>
> I am reluctant to attempt a repeat the crash with my other table which
> is important right now - I will try to recreate the crash on a copy
> later. This other table is much larger and more complex.
>
> In my investigation I did seem to find that tables with oids in place
> allowed me to delete a record via the toolbar icon, but the right click
> contextual submenu items remained greyed out. Table without oids on
> select a record or set of records does not activate the delete records
> icon on the toolbar or in the contextual submenu.
>
> An exception to the observation on context submenu in the last para. If
> the data is entered through the insert script, and then you open the
> view data - view all rows, the context menu does not work. However if
> you enter data _into_ the view data table this then activates the
> context menu and you can delete.
>
> More later.

Oki doki, some more information for you.

I have repeated the error, it is now crashing with no filter in place.

Short feedback:
gdb says:
	Program received signal SIGSEGV, Segmentation fault.
0x00007ffff70b34a7 in wxGridCellAttrData::UpdateAttrRows(unsigned long, 
int) ()
    from /usr/lib64/wx-2.8-wxcontainer/libwx_gtk2u_adv-2.8.so.0

Long feedback:
1. using a table with 10,000+ records, with oids, with serial field, and 
about 5 other numeric and text fields. I can send you the entire copy 
version if you would like it
2. no external relations or indexes involved apart from the serial field
3. go into view data, select a record, toolbar icon lights up
4. click toolbar icon, record disappears and pgadmin goes with it.

-- 
---
Colin Beckingham
613-454-5369
http://www.it4gh.com

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-09-20 19:52:26
Subject: Re: Crash on delete record with filter in place
Previous:From: Belbin, PeterDate: 2011-09-20 14:13:10
Subject: possible improvement for column resizing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group