Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    3

    Unanswered: please help me ,look at this online.log

    the database is down:
    09:27:01 WARNING: mt_aio_wait: errno == EINVAL
    09:27:01 listener-thread: err = -951: oserr = 2: errstr = ccx99: Incorrect password or user ccx99 is not known on the database server.
    System error = 2.

    internal error (2) in getuserattr()


    restart the database:
    07:58:54 Event alarms enabled. ALARMPROG = '/home/informix/etc/alarmprogram.sh'
    07:58:54 Booting Language <c> from module <>
    07:58:54 Loading Module <CNULL>
    07:58:54 Booting Language <builtin> from module <>
    07:58:54 Loading Module <BUILTINNULL>
    07:58:59 AIX MP latch code enabled
    07:58:59 IBM Informix Dynamic Server Version 9.40.FC6 Software Serial Number AAA#B000000
    07:58:59 (6) connection rejected - no calls allowed for sqlexec
    07:58:59 (7) connection rejected - no calls allowed for sqlexec
    07:58:59 (8) connection rejected - no calls allowed for sqlexec
    07:59:00 (9) connection rejected - no calls allowed for sqlexec
    07:59:00 (10) connection rejected - no calls allowed for sqlexec
    07:59:00 (11) connection rejected - no calls allowed for sqlexec
    07:59:00 (12) connection rejected - no calls allowed for sqlexec
    07:59:00 (13) connection rejected - no calls allowed for sqlexec
    07:59:00 (14) connection rejected - no calls allowed for sqlexec
    07:59:00 (15) connection rejected - no calls allowed for sqlexec
    07:59:00 (16) connection rejected - no calls allowed for sqlexec
    07:59:00 (17) connection rejected - no calls allowed for sqlexec
    07:59:00 (18) connection rejected - no calls allowed for sqlexec
    07:59:00 (19) connection rejected - no calls allowed for sqlexec
    07:59:00 (20) connection rejected - no calls allowed for sqlexec
    07:59:00 (21) connection rejected - no calls allowed for sqlexec
    07:59:00 (22) connection rejected - no calls allowed for sqlexec
    07:59:00 (23) connection rejected - no calls allowed for sqlexec
    07:59:00 (24) connection rejected - no calls allowed for sqlexec
    07:59:00 (25) connection rejected - no calls allowed for sqlexec
    07:59:00 (26) connection rejected - no calls allowed for sqlexec
    07:59:01 (27) connection rejected - no calls allowed for sqlexec
    07:59:01 (28) connection rejected - no calls allowed for sqlexec
    07:59:01 (29) connection rejected - no calls allowed for sqlexec
    07:59:01 (30) connection rejected - no calls allowed for sqlexec
    07:59:01 (31) connection rejected - no calls allowed for sqlexec
    07:59:01 (32) connection rejected - no calls allowed for sqlexec
    07:59:01 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

    07:59:01 (34) connection rejected - no calls allowed for sqlexec
    07:59:01 Physical Recovery Started at Page (2:72374).
    07:59:01 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
    07:59:01 Logical Recovery Started.
    07:59:01 10 recovery worker threads will be started.
    07:59:05 Logical Recovery has reached the transaction cleanup phase.
    07:59:05 Logical Recovery Complete.
    0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

    07:59:06 Dataskip is now OFF for all dbspaces
    07:59:06 (118) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

    07:59:06 (119) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

    07:59:06 (120) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

    07:59:06 (122) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

    07:59:06 (123) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

    07:59:06 (124) connection rejected - no calls allowed for sqlexec
    07:59:06 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.




    what't mean this online.log?
    Thank you !

  2. #2
    Join Date
    Apr 2008
    Location
    belgium, brussels
    Posts
    1
    you started the database quiscent (only dba users are allowed)
    all failed conenctions from your users are added in the online log.

  3. #3
    Join Date
    Apr 2008
    Posts
    3
    Thank nidhogg.I understand your meaning.


    But "09:27:01 WARNING: mt_aio_wait: errno == EINVAL
    09:27:01 listener-thread: err = -951: oserr = 2: errstr = ccx99: Incorrect password or user ccx99 is not known on the database server.
    System error = 2." what's mean this warning?

  4. #4
    Join Date
    Jan 2008
    Posts
    10
    You can use the finderr utility (finderr 951) you obtein an explanation about this error:

    *********************************************
    User username is not known on the database server.

    The database server that you tried to access does not accept either your user ID, the login name that is specified for the desired server host in your ~/.netrc file, or the user name that is specified in the USER clause of a CONNECT statement. If you are explicitly specifying your user name in the ~/.netrc file or in a CONNECT statement, check that the name is correct. If you do not have a valid user ID on the server computer, see your system administrator. This message appears with Version 6.0 and later.



    -951 User is not known on remote host.

    This statement refers to a database on another computer system, but the other system does not accept your account name. You must have a valid login identity on any computer system you access. See your network administrator about getting a login ID. This message appears prior to Version 6.0.

    ***************************************

    It seems there is a problem with the user (ccx99) that is trying to access to the database.

  5. #5
    Join Date
    Apr 2008
    Posts
    3
    Thank Kaugrs.
    I read the the finderr utility (finderr 951) .
    My user "ccx99" have not problem.

    The database is down when i found the warning "WARNING: mt_aio_wait: errno == EINVAL" every time.

    I do not know what cause the database down.
    Sorry,my english is not well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •