Interbase SS: terminated and bind error
Marco Schlünß
could somebody explain me more about the messages in the server-log?
more and more services at our company are running over the interbase 6
Super Server.
today, we had problems connecting to the db-server. it had terminated
and and was not running anymore.
i restarted it and took a look at the server-log.
during the last weeks, it had serveral problems.
we are using IBPerl V0.8 with DBD::Interbase for Web-Access plus BDE
with Paradox 7 for internal data-input.
so i was wondering, what this messages means and what's wrong with our
machine:
- gds__alloc: memory pool corrupted
- INET/inet_error: read errno = 113
- INET/inet_error: read errno = 104
- INET/inet_error: connect errno = 111
- gds__free: attempt to release bad block
- /usr/interbase/bin/ibguard: bin/ibserver terminated abnormally (-1)
- INET/inet_error: bind errno = 98
here is the complete log, so you can see in which order at what time it
occured:
anke.internal (Client) Wed May 31 13:13:58 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Wed May 31 13:15:43 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Wed May 31 13:16:49 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Wed May 31 13:16:49 2000
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
anke.internal (Server) Fri Jun 2 08:20:32 2000
INET/inet_error: read errno = 104
anke.internal (Server) Tue Jun 6 19:31:06 2000
INET/inet_error: read errno = 104
anke.internal (Server) Tue Jun 6 19:31:06 2000
gds__free: attempt to release bad block
anke.internal (Server) Thu Jun 8 13:40:49 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 12 21:54:10 2000
INET/inet_error: read errno = 32
anke.internal (Server) Wed Jun 14 10:35:16 2000
gds__free: attempt to release bad block
anke.internal (Server) Wed Jun 14 10:35:16 2000
gds__alloc: memory pool corrupted
anke.internal (Server) Wed Jun 14 18:18:14 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 15:34:26 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 16:50:05 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 19:09:56 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 19:26:21 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 20:14:38 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 20:14:53 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 19 20:34:38 2000
INET/inet_error: read errno = 104
anke.internal (Server) Tue Jun 20 10:38:56 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 10:12:53 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 10:22:39 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 15:35:14 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 15:44:43 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 15:45:41 2000
gds__alloc: memory pool corrupted
anke.internal (Client) Wed Jun 21 15:45:41 2000
/usr/interbase/bin/ibguard: bin/ibserver terminated abnormally (-1)
anke.internal (Client) Wed Jun 21 15:45:42 2000
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
anke.internal (Server) Wed Jun 21 15:45:42 2000
INET/inet_error: bind errno = 98
anke.internal (Client) Wed Jun 21 15:45:43 2000
/usr/interbase/bin/ibguard: bin/ibserver terminated due to startup
error (2)
anke.internal (Client) Wed Jun 21 16:06:07 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Wed Jun 21 16:06:08 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Wed Jun 21 16:06:08 2000
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
anke.internal (Server) Wed Jun 21 16:38:39 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 17:05:17 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 17:08:01 2000
INET/inet_error: read errno = 104
anke.internal (Server) Wed Jun 21 17:33:52 2000
INET/inet_error: read errno = 104
anke.internal (Server) Thu Jun 22 11:05:46 2000
INET/inet_error: read errno = 104
anke.internal (Server) Fri Jun 23 15:29:35 2000
INET/inet_error: read errno = 104
anke.internal (Server) Mon Jun 26 14:39:19 2000
gds__free: attempt to release bad block
anke.internal (Server) Tue Jun 27 09:23:01 2000
INET/inet_error: read errno = 113
anke.internal (Server) Wed Jun 28 15:08:28 2000
INET/inet_error: read errno = 104
anke.internal (Server) Thu Jun 29 14:04:49 2000
gds__alloc: memory pool corrupted
anke.internal (Server) Thu Jun 29 14:08:09 2000
INET/inet_error: read errno = 104
anke.internal (Server) Thu Jun 29 14:08:17 2000
gds__free: attempt to release bad block
anke.internal (Server) Fri Jun 30 08:43:10 2000
gds__free: attempt to release bad block
anke.internal (Client) Fri Jun 30 08:43:10 2000
/usr/interbase/bin/ibguard: bin/ibserver terminated abnormally (-1)
anke.internal (Client) Fri Jun 30 08:43:10 2000
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
anke.internal (Server) Fri Jun 30 08:43:11 2000
INET/inet_error: bind errno = 98
anke.internal (Client) Fri Jun 30 08:43:11 2000
/usr/interbase/bin/ibguard: bin/ibserver terminated due to startup
error (2)
anke.internal (Client) Fri Jun 30 09:55:25 2000
INET/inet_error: connect errno = 111
anke.internal (Client) Fri Jun 30 09:55:25 2000
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
any help would be very appriciated,
Marco Schluenss
--
Marco Schluenss m.sch...@asco.de
asco GmbH www.asco.de
Hamburger Str. 273A Tel 0531/58121-0
38114 Braunschweig Fax 0531/58121-21
Victor M. Varela
These are i/o errors, of course, but can anyone explain why these
errors are produced ? We are giving "deadlock" bugs and sometimes
server doesn't answer randomly.
Our environment:
- Apache 1.3.9
- PHP 4.0.1 (same problems with PHP3)
- Linux Redhat 6.2
- 64Mb RAM, AMD K6 450 Mhz proccessor
- now we have only 2 or 3 users.
Last thing, the system is very slow if we compare with PostgresSQL
or MySQL. I don't know why (we have increased the cache size and
it run faster but we want more)
------------------------------------------------------------------------
Victor M. Varela
Consultor, Integracion de Metodologias y Sistemas, S.L.
mailto:vic...@netims.com
Phil Shrimpton
Currently doing some testing with Apache/IBPerl/IB6SS on same machine, but
now want to separate it onto three machines WebServer - Firewall - IBServer.
As IBPerl requires IB Server to be installed, I was wondering if I had to
install the completed IB server on the webserver as well as the IB Server
machine, or can I just install the client libraries. If the later, what are
the client libraries I have to copy.
Many thanks
Phil
Bill Karwin
large if you get rid of the doc directory. About 12MB.
I just saw an advertisement on TV for a California computer parts store
(Fry's Electronics) with a sale on a 48GB hard disk for US $189. That's
less than $0.004 per megabyte. So storage for the entire InterBase
installation costs under a nickel.
Anyway, to answer your question, assuming you're on Linux, I _think_
you'd minimally need:
/usr/interbase/lib/gds.so (~370KB for Superserver's client library)
/usr/interbase/ib_license.dat (165 bytes)
/usr/interbase/interbase.msg (~130KB)
/usr/lib/libgds.so (symbolic links, about 52 bytes)
If you want to build IBPerl from sources, you'll also need:
/usr/interbase/include/ib*.h (~130KB)
I haven't tried this, it's just an educated guess. But it seems like
the minimal client install would take about 1/2 megabyte, or 2 tenths of
one cent of disk space. <g>
Regards,
Bill Karwin
Phil Shrimpton
Hi,
> Is the disk space a big problem? The full InterBase installation is not
> large if you get rid of the doc directory. About 12MB.
No, disk space is not a problem, I am just trying to avoid having two
installations of the server. You don't need to install the full server on a
Windows box to run a Delphi app, so I was trying to do the same on a Linux
box.
> I _think_ you'd minimally need:
>
> /usr/interbase/lib/gds.so (~370KB for Superserver's client library)
> /usr/interbase/ib_license.dat (165 bytes)
> /usr/interbase/interbase.msg (~130KB)
> /usr/lib/libgds.so (symbolic links, about 52 bytes)
>
> If you want to build IBPerl from sources, you'll also need:
> /usr/interbase/include/ib*.h (~130KB)
>
> I haven't tried this, it's just an educated guess. But it seems like
> the minimal client install would take about 1/2 megabyte, or 2 tenths of
> one cent of disk space. <g>
I have removed all files apart from the above and I works, I am going to try
on a clean machine, just to be sure. I might be worth creating an RPM or a
tar ball for just the Linux Client, might be useful especially when using
with linux middleware, so you don't have to install a number of servers just
to access one database.
Cheers
Phil
Bill Karwin
> I am just trying to avoid having two installations of the server.
With all due respect, this is not a goal. Why do you want this? What
is the harm in having multiple copies of InterBase server on your
machines? Is it just for aesthetics?
InterBase is primarily designed as a peer-to-peer, rather than a
client-server, architecture. That means that any installation, when
enabled with software activation keys, can function as either a client
or a server. Reducing the installed files to a minimal client turns it
into a mere client-server architecture. This might be fine for your
current needs, but what about next week? Is it not worth leaving the
installation alone since it doesn't take much disk space? You can
always simply not start ibserver (or comment out the line in
/etc/inetd.conf if you're running Classic) to disable the server
capability.
Regards,
Bill Karwin
Phil Shrimpton
Hi,
> I wrote:
> > I am just trying to avoid having two installations of the server.
>
> With all due respect, this is not a goal. Why do you want this? What
> is the harm in having multiple copies of InterBase server on your
> machines? Is it just for aesthetics?
Yes it is as trivial as that, especially for this little test. But we are
looking at using IB6 to replace some Oracle functionality in a current
system, which has 25 middleware servers, and the system administrators don't
want the full server installation on those, just the client libraries.
> InterBase is primarily designed as a peer-to-peer, rather than a
> client-server, architecture. That means that any installation, when
> enabled with software activation keys, can function as either a client
> or a server.
I agree, but with the removal of the licensing functionality in IB6, you get
the full blown server with every installation.
> Reducing the installed files to a minimal client turns it
> into a mere client-server architecture. This might be fine for your
> current needs, but what about next week?
Not really a problem, we know what machines are servers and what are clients
(Both windows and Linux). If we need to use one of the Linux clients as a
server we will install the server, the same as on windows.
> Is it not worth leaving the
> installation alone since it doesn't take much disk space? You can
> always simply not start ibserver (or comment out the line in
> /etc/inetd.conf if you're running Classic) to disable the server
> capability.
This is what I am currently doing, but the reason I asked the question was
the fact that on the Windows platform you have both a server and client
install, but only a server install for Linux.
Cheers
Phil Shrimpton
------------------------------
Project JEDI DCOM Team Captain
Project JEDI Library Team
<www.delphi-jedi.org>
Registered Linux User #155621
Bill Karwin
> ...the system administrators don't
> want the full server installation on those, just the client libraries.
I'm not questioning your reasons, Phil, but I just wonder if your
sysadms understand that the difference between IB client and full
install is .5MB vs 12MB, while the difference between Oracle client and
full install is ~200MB vs 700MB+.
FWIW, when I was at InterBase we had planned on producing a client-only
install of IB6 on all platforms, for symmetry with the Windows kit if
nothing else. It's much easier to customize an IB installation on
UNIX/Linux than on Windows, because there are no Registry settings or
shared library reference counts to worry about.
Regards,
Bill Karwin
Marco Schlünß
> > here is the complete log, so you can see in which order at what time it
> > occured:
> > anke.internal (Client) Wed May 31 13:13:58 2000
> > INET/inet_error: connect errno = 111
> >
> > anke.internal (Client) Wed May 31 13:15:43 2000
> > INET/inet_error: connect errno = 111
> >
> > anke.internal (Client) Wed May 31 13:16:49 2000
> > INET/inet_error: connect errno = 111
> >
> > anke.internal (Client) Wed May 31 13:16:49 2000
> > /usr/interbase/bin/ibguard: guardian starting bin/ibserver
>
> Three attempts to connect to InterBase failed (ECONNREFUSED, errno 111),
> most likely because it wasn't running. Thereafter IBGuard fires up InterBase.
I get a little bit nervous, if the above log means, the server was down
for a least 3 minutes during the main working hours...
how often is IBGuard checking the IBServer? is it configurable?
> > anke.internal (Server) Tue Jun 6 19:31:06 2000
> > gds__free: attempt to release bad block
>
> The [..] error is specific to InterBase and without the source I can't
> (won't) look any further.
hopefully it'll come out soon or some of the IB-crew could say something
about it.
> It's unfortunately "normal" that InterBase doesn't distinguish between a
> genuine error and expected startup behaviour (nothing else has this problem..
> *sigh*).
[..]
> > anke.internal (Server) Tue Jun 6 19:31:06 2000
> > gds__free: attempt to release bad block
[..]
> Errno 32 == EPIPE (Broken pipe).
[..]
> Oops! InterBase died...
[..]
> .so IBGuard tries to start it up again, only to find that the socket hasn't
> been let go (zombie process?).
[..]
> Errno 2 == ENOENT (No such file or directory).
>
> Cheers..
[..]
ahm, you think we are in big trouble?
Marco Schlünß
> - Apache 1.3.9
> - PHP 4.0.1 (same problems with PHP3)
> - Linux Redhat 6.2
> - 64Mb RAM, AMD K6 450 Mhz proccessor
> - now we have only 2 or 3 users.
is there many traffic on the machine? many connections to the webserver?
i think 64Mb is not that much, and Interbase is a smart server, but
compared to MySQL, it needs more ram.
Alberto
go down many times per day.
The configuration of our server is:
-Apache 1.3.9
-PHP 4.01
-RedHat 6.0
-Interbase Super Server 6.0 beta
Below there's a part of the Interbase Log where there was the errors:
/usr/interbase/bin/ibguard: guardian starting bin/ibserver
xxx.xxx.xxxx (Server) Mon Jul 3 11:48:37 2000
Super Server/main: Bad client socket, send() resulted in SIGPIPE, caught by
server
client exited improperly or crashed ????
xxx.xxx.xxxx (Server) Mon Jul 3 11:48:37 2000
INET/inet_error: send errno = 32
xxx.xxx.xxxx (Server) Mon Jul 3 11:49:38 2000
INET/inet_error: read errno = 110
xxx.xxx.xxxx (Server) Mon Jul 3 12:54:02 2000
INET/inet_error: read errno = 110
xxx.xxx.xxxx (Client) Mon Jul 3 15:43:35 2000
INET/inet_error: read errno = 104
xxx.xxx.xxxx (Client) Mon Jul 3 15:43:36 2000
INET/inet_error: send errno = 32
Can anyone help us ?
Thanks a lot,
Alberto
Ken Rachynski
>full install is ~200MB vs 700MB+.
>
Ah, actually it's more like 120MB vs 1000MB. Heck, a Personal Oracle
installation wants 1GB. I know... I've tried it. Personally, I'll take the
12MB install any day.
--
Ken Rachynski
http://www.telusplanet.net/public/krachyn/
ICQ: 3113514