[GRASS-dev] [GRASS GIS] #1579: wingrass: errors while a DB is open results in a zombie dbf.exe

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------------+------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Keywords: wingrass, db_driver | Platform: MSWindows XP
      Cpu: x86-32 |
---------------------------------+------------------------------------------
Hi, moving this here from the later comments in #1276.

a G_fatal_error() while a db_driver is open, such as you get when you typo
the name of an attribute column, does not close the db driver, which is
left behind as a zombie process (along with a dependent cmd.exe). This is
a problem as the db driver may be holding a file open, blocking anything
else from working on it or removing it.

db_close_database_shutdown_driver() seems to shut it down properly.

work-around: ctrl-alt-del to the task manager and kill any dbf.exe
processes. the cmd.exe ones will then go away.

maybe this program helps: (lsof for Windows)
   http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs
/en-us/openfiles.mspx

Hamish

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1579&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------------+------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Keywords: wingrass, db_driver | Platform: MSWindows XP
      Cpu: x86-32 |
---------------------------------+------------------------------------------

Comment(by neteler):

A few DBMI related backports have happened over the past few days,
still an issue? How to test it?

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1579#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------------+------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: major | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Keywords: wingrass, db_driver | Platform: MSWindows XP
      Cpu: x86-32 |
---------------------------------+------------------------------------------
Changes (by neteler):

  * priority: critical => major

Comment:

Apparently no longer an issue? Downgrading priority.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1579#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------+------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: major | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Resolution: fixed | Keywords: wingrass, db_driver, dbf
  Platform: MSWindows XP | Cpu: x86-32
---------------------------+------------------------------------------------
Changes (by neteler):

  * keywords: wingrass, db_driver => wingrass, db_driver, dbf
  * status: new => closed
  * resolution: => fixed

Comment:

No response, closing. Feel free to reopen.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1579#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------+------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: reopened
  Priority: major | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Resolution: | Keywords: wingrass, db_driver, dbf
  Platform: MSWindows XP | Cpu: x86-32
---------------------------+------------------------------------------------
Changes (by mmetz):

  * status: closed => reopened
  * resolution: fixed =>

Comment:

Replying to [comment:3 neteler]:
> No response, closing. Feel free to reopen.

Reopened because the fundamental problem persists: subprocesses remain
open after the parent process was terminated. Applies to all branches.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1579#comment:4&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------+------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: reopened
  Priority: major | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Resolution: | Keywords: wingrass, db_driver, dbf
  Platform: MSWindows XP | Cpu: x86-32
---------------------------+------------------------------------------------

Comment(by mmetz):

Replying to [comment:4 mmetz]:
> Replying to [comment:3 neteler]:
> > No response, closing. Feel free to reopen.
>
> Reopened because the fundamental problem persists: subprocesses remain
open after the parent process was terminated. Applies to all branches.

Fixed in r62679-82 (all branches).

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1579#comment:5&gt;
GRASS GIS <http://grass.osgeo.org>

#1579: wingrass: errors while a DB is open results in a zombie dbf.exe
---------------------------+------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: major | Milestone: 6.4.2
Component: Database | Version: svn-releasebranch64
Resolution: fixed | Keywords: wingrass, db_driver, dbf
  Platform: MSWindows XP | Cpu: x86-32
---------------------------+------------------------------------------------
Changes (by martinl):

  * status: reopened => closed
  * resolution: => fixed

Comment:

Replying to [comment:5 mmetz]:
> Replying to [comment:4 mmetz]:
> > Replying to [comment:3 neteler]:
> > > No response, closing. Feel free to reopen.
> >
> > Reopened because the fundamental problem persists: subprocesses remain
open after the parent process was terminated. Applies to all branches.
>
> Fixed in r62679-82 (all branches).

Taking liberty to close the ticket. Feel free to reopen if needed.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1579#comment:6&gt;
GRASS GIS <http://grass.osgeo.org>