ichenyao 发表于 2012-10-10 00:40

求问,不懂系统日志的意思

日志的英文看得懂,但是不知道在其中具体代表什么意思。

在输入:tail -30 /opt/sybase/ASE-15_0/install/hobo.log后,出现如下日志

00:00000:00001:2012/10/08 16:29:32.39 serverStarted estimating recovery log boundaries for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.42 serverDatabase 'hobo', checkpoint=(724876, 252), first=(724876, 252), last=(4295692172, 253).
00:00000:00001:2012/10/08 16:29:32.42 serverCompleted estimating recovery log boundaries for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.42 serverStarted ANALYSIS pass for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.42 serverCompleted ANALYSIS pass for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.42 serverLog contains all committed transactions until 2012/10/08 02:05:17.35 for database hobo.
00:00000:00001:2012/10/08 16:29:32.42 serverStarted REDO pass for database 'hobo'. The total number of log records to process is 2.
00:00000:00001:2012/10/08 16:29:32.44 serverCompleted REDO pass for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.44 serverRecovery of database 'hobo' will undo incomplete nested top actions.
00:00000:00001:2012/10/08 16:29:32.44 serverStarted recovery checkpoint for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.53 serverCompleted recovery checkpoint for database 'hobo'.
00:00000:00001:2012/10/08 16:29:32.56 serverStarted filling free space info for database 'hobo'.
00:00000:00001:2012/10/08 16:29:33.07 serverCompleted filling free space info for database 'hobo'.
00:00000:00001:2012/10/08 16:29:33.08 serverStarted cleaning up the default data cache for database 'hobo'.
00:00000:00001:2012/10/08 16:29:33.32 serverCompleted cleaning up the default data cache for database 'hobo'.
00:00000:00001:2012/10/08 16:29:33.33 serverChecking external objects.
00:00000:00001:2012/10/08 16:29:33.41 serverThe transaction log in the database 'hobo' will use I/O size of 16 Kb.
00:00000:00001:2012/10/08 16:29:33.67 serverDatabase 'hobo' is now online.
00:00000:00001:2012/10/08 16:29:33.67 serverRecovery has restored the value of 'local async prefetch limit' for '128K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2012/10/08 16:29:33.67 serverRecovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2012/10/08 16:29:33.79 serverRecovery has restored the original size for '128K' pool and '16K' pool in 'default data cache'.
00:00000:00001:2012/10/08 16:29:33.79 serverRecovery complete.
00:00000:00001:2012/10/08 16:29:33.79 serverASE's default unicode sort order is 'binary'.
00:00000:00001:2012/10/08 16:29:33.79 serverASE's default sort order is:
00:00000:00001:2012/10/08 16:29:33.79 server    'utf8_nocase' (ID = 101)
00:00000:00001:2012/10/08 16:29:33.79 serveron top of default character set:
00:00000:00001:2012/10/08 16:29:33.79 server    'utf8' (ID = 190).
00:00000:00001:2012/10/08 16:29:33.79 serverMaster device size: 500 megabytes, or 256000 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00001:2012/10/08 16:29:33.81 kernelWarning: Cannot set console to nonblocking mode, switching to blocking mode.
00:00000:00013:2012/10/08 16:29:33.81 serverStarted Rep Agent on database, 'hobo' (dbid = 4).


尤其是倒数第二句Warning: Cannot set console to nonblocking mode, switching to blocking mode。为什么会出现这条信息,是由于人员误操作吗?
望高手详细解释,谢谢。

wfcjz 发表于 2012-11-25 13:36

这个日志是正常的, Started Rep Agent on database, 'hobo' (dbid = 4).
告诉你hobo库启动正常

ichenyao 发表于 2013-03-11 21:38

回复 2# wfcjz


    谢谢

tomer 发表于 2013-03-13 13:58

回复 2# wfcjz


    请问您对sybase IQ Multiplex 熟吗?
   
1> select server_name ,role from sp_iqmpxinfo()      
2> go
server_name                                                       role            
-----------------------------------------------------------------------------
      
node1                                                         coordinato                                                                        
      
node2                                                            writer                                                                                             
               
node3                                                            writer                                                                                                                        
                  
node4                                                            writer                                                                                                                  


(4 rows affected)

两个问题:
1.node1能否改成IP的形式
2.如果1可以,那么如何实现
谢谢!!

wfcjz 发表于 2013-03-24 13:08

不好意思,sybase IQ不太会,帮不了你,抱歉!

ichenyao 发表于 2013-03-31 22:08

回复 4# tomer


    抱歉,不懂这些

ichenyao 发表于 2013-03-31 22:09

回复 5# wfcjz


    还是谢谢留言
页: [1]
查看完整版本: 求问,不懂系统日志的意思