iidbms shutdown on his own

Programming and Web Development Forums - DATABASE - Issues relating to INGRES products.

Skip to content

iidbms shutdown on his own

DATABASE
Post a reply

    Sponsored Links

    Next

  • 1. Mutex: DCB iidbdb
    Marty, The tid in this case is the thread id, and can be used in iimonitor to find the session which is holding the mutex. It's likely that the session holding the DCB Mutex might be blocked by something else, and once you find the session you can check that status of that session. John On Aug 28, 7:09 pm, "Martin Bowes" < XXXX@XXXXX.COM > wrote: > Hi everyone, > > I'm running II 9.1.1 (a64.lnx/103)NPTL + patch13001 on Red Hat > Enterprise Linux Server release 5 (Tikanga). > > About once a week my servers freeze up and new connections stall in > Mutex: DCB iidbdb > > This sucks big time. > > I've checked on the Ingres Tech support site and there are three old > bugs listed against the Mutex but none of them seem relevant in this > case. > > Can anyone shed some light on the details shown by show mutex? > > I get... > > show mutex 00002AAAB9806810 > > Mutex at 00002AAAB9806810: Name: DCB iidbdb, EXCL owner: (tid: > 1080768832, pid: 8227) > > Shared: 0 Collisions: 0 Hwm: 0 > > Excl: 15 Collisions: 13 > > The pid=8227 was the DBMS server pid. > > Does the tid tell me anything? > > Martin Bowes
  • 2. [Info-Ingres] parse copy.out output as plain text?
    Hello Zhiliang, You wrote... > I know another way might be that I can create a temporary db and load it with copy.in > script, then export again ... That will be ok if you have a copy of the original copy.out/copy.in scripts generated by copydb. When dealing with character mode be mindful of losing floating point precision and also of timezone and default date format. Paul
  • 3. parse copy.out output as plain text?
    I wish to parse out an Ingres data copy (with sql db_name < copy.out > file; where "copy.out" is generated with "copydb" command). I wonder could someone advice what's the delimiter and line breaks used in such Ingres copy file, so I can write a perl script to convert data into plain text file? I see irregular "^A" and spaces but can't match up where the line breaks should be, or tell what they are. Or the unix terminal is fooling my eyes ;-) Thanks in advance! Zhiliang

iidbms shutdown on his own

Postby Sastien Cottalorda » Sat, 05 Jul 2003 18:08:06 GMT 

Hi all,

Here is my problem:

I run a Ingres II 2.0/9808 (int.lnx/00) server on a Redhat 7.0 system
(kernel 2.2.16-22)
The system runs perfectly since 3 years but since Jun 30 2003, iidbms
shutdown on his own.

I've called the ingres support, and, after checkings, we discover that I've
some tables ~ 2 Go on my disk.
I've then reduce all of them => each is contained in a file < 1Go.
But I encoutered always the same problem.
I've then unloaddb -c my database, destroy, re-create and reload it.
But I encoutered always the same problem.

I've 2 applications (that did not contains even a line referencing iimonitor
or ingstop).
The first one take some ascii files, put them into a table and run
statistics that were put in another tables.
The second one did the same but take his informations throught a TCP socket.
When I run one of them => no problem,
When I run both => iidbms auto-shutdown after 5-10 minutes.

CA support ask me to check in my entire system if someone has made a copy of
iimonitor and "joke" to stop the iidbms server => of course not.

If someone as a clue.

I've put my errlog.log file where you can see the iidbms shutdown and the
start procedure.

Thanks in advance for any kind of help.

Sastien Cottalorda
System Manager
Parkings Publics de Monaco
24 Rue du Gabian
98000 Monaco
Tel: +377 93152077
Fax: +377 92057496
e-mail:  XXXX@XXXXX.COM
Top

Re: iidbms shutdown on his own

Postby Sastien Cottalorda » Sat, 05 Jul 2003 18:12:23 GMT

ontent-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 8Bit

Sastien Cottalorda wrote:


Sorry, Here is the file
Content-Type: text/plain; name="errlog.log_to_send"
Content-Transfer-Encoding: 8Bit
Content-Disposition: attachment; filename="errlog.log_to_send"

o The database may be open by an exclusive (/SOLE) DBMS server.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 18:55:34 2003 E_SC0123_SESSION_INITIATE Error initiating session.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:00:04 2003 E_US0014 Database not available at this time.
o The database may be marked inoperable. This can occur if
CREATEDB failed or CONVTO60 is in progress.
o An exclusive database lock may be held by another session.
o The database may be open by an exclusive (/SOLE) DBMS server.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:00:04 2003 E_SC0123_SESSION_INITIATE Error initiating session.
SIEGE_NE::[1787 , 08cf0ae0]: Thu Jul 3 19:00:04 2003 E_US0014 Database not available at this time.
o The database may be marked inoperable. This can occur if
CREATEDB failed or CONVTO60 is in progress.
o An exclusive database lock may be held by another session.
o The database may be open by an exclusive (/SOLE) DBMS server.
SIEGE_NE::[1787 , 08cf0ae0]: Thu Jul 3 19:00:04 2003 E_SC0123_SESSION_INITIATE Error initiating session.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:39:17 2003 E_PS0501_SESSION_OPEN There were open sessions when trying to shut down the parser facility.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:39:17 2003 E_DM005B_SESSION_OPEN Session(s) are open.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:39:17 2003 E_SC0235_AVERAGE_ROWS On 47425. select/retrieve statements, the average row count returned was 2.
SIEGE_NE::[1787 , 08a34640]: Thu Jul 3 19:39:17 2003 E_SC0127_SERVER_TERMINATE Error terminating Server.
Siege_Ne::[ , ffffffff]: Thu Jul 3 19:40:15 2003 E_GC2002_SHUTDOWN Communication Server normal shutdown.
::[II_ACP , 085b8040]: Thu Jul 3 19:40:15 2003 E_DM9815_ARCH_SHUTDOWN Archiver was told to shut down.

Siege_Ne::[ , 00000000]: Thu Jul 3 19:40:21 2003 E_GC0152_GCN_SHUTDOWN Name Server normal shutdown.
Siege_Ne::[ , 00000000]: Thu Jul 3 19:40:24 2003 E_GC0151_GCN_STARTUP Name Server normal startup.
Siege_Ne::[ , 00000000]: Thu Jul 3 19:40:30 2003 E_GC0152_GCN_SHUTDOWN Name Server normal shutdown.
Siege_Ne::[ , 00000000]: Thu Jul 3 19:40:31 2003 E_GC0151_GCN_STARTUP Name Server normal startup.
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM active_limit = 5
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM connect_limit = 5
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM stack_size = 32768
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM security_auditing = OFF
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM level = C2
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM cp_timer = 0
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PARAM max_tuple_length = 2008
Siege_Ne::[ingres , 00003c75]: Thu Jul 3 19:40:32 2003 E_CL2530_CS_PAR
Top

Re: iidbms shutdown on his own

Postby hgs » Sat, 05 Jul 2003 20:59:34 GMT

As you write the magic word 2Gb i would wonder if any tables has passed 800.000 pages (help
table/iitables) meaning that some tables needs to be spread on more than one location.

If so:
create another location through accessdb and extend your database
(and file/directory-creation before with correct access-modes)

afterwards use "modify to relocate" to extend the table.

Regards

Henrik Georg Sensen, Msk Data Organisator
Phone. +45 3911 1000, Fax +45 3911 1010 or Direct +45 3911 0059
E-mail. XXXX@XXXXX.COM
Http:\\www.maerskdata-organisator.dk



Sastien
Cottalorda To: XXXX@XXXXX.COM
< XXXX@XXXXX.COM cc:
om> Subject: iidbms shutdown on his own
Sent by:


owner-info-ingre
XXXX@XXXXX.COM


04-07-2003 11:08







Hi all,

Here is my problem:

I run a Ingres II 2.0/9808 (int.lnx/00) server on a Redhat 7.0 system
(kernel 2.2.16-22)
The system runs perfectly since 3 years but since Jun 30 2003, iidbms
shutdown on his own.

I've called the ingres support, and, after checkings, we discover that I've
some tables ~ 2 Go on my disk.
I've then reduce all of them => each is contained in a file < 1Go.
But I encoutered always the same problem.
I've then unloaddb -c my database, destroy, re-create and reload it.
But I encoutered always the same problem.

I've 2 applications (that did not contains even a line referencing iimonitor
or ingstop).
The first one take some ascii files, put them into a table and run
statistics that were put in another tables.
The second one did the same but take his informations throught a TCP socket.
When I run one of them => no problem,
When I run both => iidbms auto-shutdown after 5-10 minutes.

CA support ask me to check in my entire system if someone has made a copy of
iimonitor and "joke" to stop the iidbms server => of course not.

If someone as a clue.

I've put my errlog.log file where you can see the iidbms shutdown and the
start procedure.

Thanks in advance for any kind of help.

Sastien Cottalorda
System Manager
Par
Top

RE: iidbms shutdown on his own

Postby Sastien Cottalorda » Sat, 05 Jul 2003 21:48:28 GMT 




That's the strangest thing. I didn't explain why it shutdown without any
error message.


SERVER_CONTROL was set on root and ingres
I've modified ingres password => nothing better
I've made on each file of my system a MD5 checksum and comparate each of
them with iimonitor (someone can have stolen iimonitor and renamed it).
=> I didn't find anything, iimonitor is the only file on my system.


IIGCN use 15460 port and my application (that use sockets, in fact a
software bus) use ports: 10310, 10311, 10320 and 10321


I can modify that kind of socket but I didn't think it'll solve my problem
due to the complete separation between my application ports and ingres
ports.
Perhaps my problem come with ingres parameters. The person I talk to
(support CA) told me that, according to the errlog.log, my ingres server
was configured as default and may be has not a good configuration for the
use I have.

I didn't have an idea about the ingres parameters except basic modifications
in cbf utility.
I know that I've several big table ( ~ 7 000 000 tuples ) and they are
contained in very big files ( ~ 1 Go). As a coincidence, when my
application failed, one of them works with a big table.
CA support recommend me to separate some table into 2 less big files ?????
(I didn't know how to do that => they ask me to refer to the ingres
documentation)



Thanks for your help.

Sastien
Top

Similar Threads:

1.[Info-Ingres] SPAM: Multiple iidbms

2.[Info-ingres] multiple iidbms servers with cache_sharing off sole_server on

3.[Info-Ingres] rcpconfig and iidbms taking 100% CPU 

On Mar 3, 2008, at 2:52 AM, srikanth wrote:

> Hi,
>
>     In Ingres installation (on RHEL 4.0), the processes *rcpconfig*
> and *iidbms* take up to 100% CPU . What could be the reason? In this
> scenario, a max of 20 connections exist to the database with selects
> and updates done simultaneously.
>

Are you sure that it's the real working iidbms?  A spinning
rcpconfig is usually an artifact of a broken installation that
did not shut down properly.  (It's spinning on a test-and-set
lock in a shared memory area.  If that lock gets stuck or
corrupted, you get spinning rcpconfig's and often spinning
csreport's as well.)

What kernel version is this?  I don't follow the various
distribution release versions...

Karl

4.[Info-Ingres] Sole iidbms

5.multiple iidbms servers with cache_sharing off sole_server on 

Does anyone has experience with using multiple iidbms servers
(cache_sharing off, sole_server on) in a single DBMS installation ?

Is this approach advisable ?

Thanks in advance,

Franky Leeuwerck
AP&P

6. [Info-Ingres] Multiple iidbms

7. [Info-ingres] Iidbms crashing SIGBUS/SIGSEGV ; E_DM002B

8. [Info-Ingres] HPUX patch PHKL_34311 - iidbms hanging

Post a reply

Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 11 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group