If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > please help me ,look at this online.log

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-27-08, 20:40
lonelyguy lonelyguy is offline
Registered User
 
Join Date: Apr 2008
Posts: 3
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 !
Reply With Quote
  #2 (permalink)  
Old 04-29-08, 03:33
nidhogg nidhogg is offline
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old 04-29-08, 03:44
lonelyguy lonelyguy is offline
Registered User
 
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?
Reply With Quote
  #4 (permalink)  
Old 04-29-08, 07:25
kaugrs kaugrs is offline
Registered User
 
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.
Reply With Quote
  #5 (permalink)  
Old 04-29-08, 20:55
lonelyguy lonelyguy is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On