[Pkg-firebird-general] Bug#162908: marked as done (Better ways to
do /etc/init.d/firebird stop [database shutdown])
Debian Bug Tracking System
owner at bugs.debian.org
Fri Oct 21 13:18:33 UTC 2005
Your message dated Fri, 21 Oct 2005 16:05:29 +0300
with message-id <4358E799.2020204 at creditreform.bg>
and subject line Better ways to do /etc/init.d/firebird stop [database shutdown]
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 30 Sep 2002 20:49:24 +0000
>From greg at sente.pl Mon Sep 30 15:49:23 2002
Return-path: <greg at sente.pl>
Received: from sente.pl [195.117.126.124]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 17w7Tl-0004yK-00; Mon, 30 Sep 2002 15:49:21 -0500
Received: from home.sente.pl ([213.77.64.92] helo=localhost.localdomain)
by sente.pl with esmtp (Exim 3.35 #1 (Debian))
id 17w7U7-0005OV-00; Mon, 30 Sep 2002 22:49:43 +0200
Subject: Better ways to do /etc/init.d/firebird stop [database shutdown]
From: Grzegorz Prokopski <greg at sente.pl>
To: Ed Boraas <ed at boraas.ca>
Cc: submit at bugs.debian.org
In-Reply-To: <001a01c2541b$c5bc5720$3d79b9c7 at admin.concordia.ab.ca>
References: <1030224744.24836.8.camel at radium>
<1031123923.1157.25.camel at greg.home.sente.pl>
<001a01c2541b$c5bc5720$3d79b9c7 at admin.concordia.ab.ca>
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable
X-Mailer: Ximian Evolution 1.0.8
Date: 30 Sep 2002 22:49:06 +0200
Message-Id: <1033418947.1484.237.camel at greg.home.sente.pl>
Mime-Version: 1.0
Delivered-To: submit at bugs.debian.org
Package: firebird
Version: 1.0.0-15
Severity: wishlist
W li=B6cie z =B6ro, 04-09-2002, godz. 16:02, Ed Boraas pisze:=20
> Hi, Greg.
> > Why not use gsec -shut to shut down the database server? That should be
> > safe and clean.
> gfix -shut -force 0 /path/to/database
I tried this (sorry it took so long), but there are problems with
this method.
First: How do I know which databases are opened currently?
`ps` doesn't seem to be useful, surely not for super server,
apparently not for classic too (not sure here).
I tested it with isql - by connecting to database (using TCP)
and checking `ps ax |grep firebird` output.
Another ideas that come to my mind:
For classic - I think, I could temporarely disable the service
in inetd, or even better put some small wrapper there, which
would check for ex. existence of a file
/var/lock/firebird_stopping
and would then not allow to run new connections. If the file
doesn't exist - it would just "exec" gds_inet_server.
It would need to be C program for performance reasons.
I could then kill the remaining connections as I do now but
after some period of time ("Stopping server - please wait...").
For super - still no idea.
Suggestions, opinions - are welcomed.
Best regards
Grzegorz B. Prokopski
PS: Please keep Cc:ing debbugs where it makes sense.
---------------------------------------
Received: (at 162908-done) by bugs.debian.org; 21 Oct 2005 13:05:31 +0000
>From divanov at creditreform.bg Fri Oct 21 06:05:31 2005
Return-path: <divanov at creditreform.bg>
Received: from fiona.creditreform.bg [212.36.1.3]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1ESwaR-0008S8-00; Fri, 21 Oct 2005 06:05:31 -0700
Received: from localhost ([127.0.0.1] ident=amavis)
by fiona.creditreform.bg with esmtp (Exim 4.50)
id 1ESwaP-0002Tu-Pz
for 162908-done at bugs.debian.org; Fri, 21 Oct 2005 16:05:29 +0300
Received: from fiona.creditreform.bg ([127.0.0.1])
by localhost (fiona [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
id 09277-01 for <162908-done at bugs.debian.org>;
Fri, 21 Oct 2005 16:05:29 +0300 (EEST)
Received: from pc1.creditreform.bg ([192.168.110.32])
by fiona.creditreform.bg with esmtp (Exim 4.50)
id 1ESwaP-0002Tn-M4
for 162908-done at bugs.debian.org; Fri, 21 Oct 2005 16:05:29 +0300
Message-ID: <4358E799.2020204 at creditreform.bg>
Date: Fri, 21 Oct 2005 16:05:29 +0300
From: Damyan Ivanov <divanov at creditreform.bg>
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: 162908-done at bugs.debian.org
Subject: Re: Better ways to do /etc/init.d/firebird stop [database shutdown]
X-Enigmail-Version: 0.93.0.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";
boundary="------------enigBE33C19EBD3903793DAAF49F"
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at creditreform.bg
Delivered-To: 162908-done at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-2.0 required=4.0 tests=BAYES_01 autolearn=no
version=2.60-bugs.debian.org_2005_01_02
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigBE33C19EBD3903793DAAF49F
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Version: 1.5.2-9
Current firebird2-server-classic packages refuse to remove if there is a
database opened. This is detected by parsing the output of fb_lock_print.
For super-server, I think that nothing can be done and we should rely on the
super-server process to shutdown itself in a safe way.
So, I am closing the bug with the rationale that it is half-fixed and half-wontfix.
dam
--
Damyan Ivanov Creditreform Bulgaria
divanov at creditreform.bg http://www.creditreform.bg/
phone: +359(2)928-2611, 929-3993 fax: +359(2)920-0994
mob. +359(88)856-6067 dam at jabber.minus273.org/Gaim
--------------enigBE33C19EBD3903793DAAF49F
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDWOeZHqjlqpcl9jsRAoY1AJ9RRAVPLmoIz8AfffQ85+J5cVGfCgCfdJ82
Zyc/YFRWLvCruf4F8VwfvaI=
=Xax7
-----END PGP SIGNATURE-----
--------------enigBE33C19EBD3903793DAAF49F--
More information about the Pkg-firebird-general
mailing list