kingbaseES V7连接启动及问题解决

[kingbase@localhost bin]$isql -USYSTEM -WMANAGER -d TEST
isql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

[kingbase@localhost bin]$ isql -USYSTEM -WMANAGER -d TEST

^C
[kingbase@localhost bin]$
[kingbase@localhost bin]$ logout
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# /etc/init.d/kingbase7d start
can’t source $/bin/functions

[root@localhost ~]# su - kingbase
[kingbase@localhost ~]$
[kingbase@localhost ~]$
[kingbase@localhost ~]$ cd KingbaseES/bin/
[kingbase@localhost bin]$ ./kingbase -D …/data/
看问题！！！
LOG: dumping license information…
LOG: file version: 2.0
LOG: product line: ES
LOG: product version: 7.1.2
LOG: distribution type: EE
LOG: operating system: LNX
LOG: architecture: X64
LOG: floating mode: yes
LOG: base date: 2018-10-31
LOG: valid period: 180 days
LOG: max connections: unlimited
LOG: user information: dzҵ
LOG: trial mode: no
LOG: MAC address checking mode: no
LOG: MAC address:
LOG: IPV4 address checking mode: no
LOG: IPV4 address:
LOG: S/N: c47ee2bd-87546f05-e6037736-0a6a5d64
2018-10-31 11:30:57.236 PDT 1 LOG: could not bind IPv4 socket: Address already in use
2018-10-31 11:30:57.236 PDT 1 HINT: Is another kingbase already running on port 54321? If not, wait a few seconds and retry.
2018-10-31 11:30:57.236 PDT 1 LOG: could not bind IPv6 socket: Address already in use
2018-10-31 11:30:57.236 PDT 1 HINT: Is another kingbase already running on port 54321? If not, wait a few seconds and retry.
2018-10-31 11:30:57.236 PDT 1 WARNING: could not create listen socket for “*”
2018-10-31 11:30:57.236 PDT 1 FATAL: could not create any TCP/IP sockets
端口被使用：
[kingbase@localhost bin]$ ps -ef|grep kingbase
kingbase 10993 1 0 07:10 ? 00:00:00 /home/kingbase/KingbaseES/bin/krms
kingbase 11079 1 0 07:10 ? 00:00:57 /home/kingbase/KingbaseES/jre/bin/java -Djava.util.logging.config.file=/home/kingbase/KingbaseES/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/home/kingbase/KingbaseES/tomcat/endorsed -classpath /home/kingbase/KingbaseES/tomcat/bin/bootstrap.jar -Dcatalina.base=/home/kingbase/KingbaseES/tomcat -Dcatalina.home=/home/kingbase/KingbaseES/tomcat -Djava.io.tmpdir=/home/kingbase/KingbaseES/tomcat/temp org.apache.catalina.startup.Bootstrap start
kingbase 11884 1 2 07:16 ? 00:07:02 /home/kingbase/KingbaseES/bin/kingbase kingbasees_instance1
root 12227 12217 0 08:03 pts/0 00:00:00 su - kingbase
kingbase 12228 12227 0 08:03 pts/0 00:00:00 -bash
root 12329 12313 0 08:06 pts/0 00:00:00 su - kingbase
kingbase 12330 12329 0 08:06 pts/0 00:00:00 -bash
root 13250 12892 0 11:30 pts/1 00:00:00 su - kingbase
kingbase 13251 13250 0 11:30 pts/1 00:00:00 -bash
kingbase 13286 13251 12 11:31 pts/1 00:00:00 ps -ef
kingbase 13287 13251 0 11:31 pts/1 00:00:00 grep kingbase
[kingbase@localhost bin]$
[kingbase@localhost bin]$ kill -9 isql 11884
-bash: kill: isql: arguments must be process or job IDs
[kingbase@localhost bin]$
[kingbase@localhost bin]$ logout
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# ps -ef|grep kingbase
kingbase 10993 1 0 07:10 ? 00:00:00 /home/kingbase/KingbaseES/bin/krms
kingbase 11079 1 0 07:10 ? 00:00:57 /home/kingbase/KingbaseES/jre/bin/java -Djava.util.logging.config.file=/home/kingbase/KingbaseES/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/home/kingbase/KingbaseES/tomcat/endorsed -classpath /home/kingbase/KingbaseES/tomcat/bin/bootstrap.jar -Dcatalina.base=/home/kingbase/KingbaseES/tomcat -Dcatalina.home=/home/kingbase/KingbaseES/tomcat -Djava.io.tmpdir=/home/kingbase/KingbaseES/tomcat/temp org.apache.catalina.startup.Bootstrap start
root 12227 12217 0 08:03 pts/0 00:00:00 su - kingbase
kingbase 12228 12227 0 08:03 pts/0 00:00:00 -bash
root 12329 12313 0 08:06 pts/0 00:00:00 su - kingbase
kingbase 12330 12329 0 08:06 pts/0 00:00:00 -bash
root 13289 12892 0 11:31 pts/1 00:00:00 grep kingbase
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# kill -9 10993
[root@localhost ~]# kill -9 11079
[root@localhost ~]# ps -ef|grep kingbase
root 12227 12217 0 08:03 pts/0 00:00:00 su - kingbase
kingbase 12228 12227 0 08:03 pts/0 00:00:00 -bash
root 12329 12313 0 08:06 pts/0 00:00:00 su - kingbase
kingbase 12330 12329 0 08:06 pts/0 00:00:00 -bash
root 13291 12892 0 11:32 pts/1 00:00:00 grep kingbase
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# /etc/init.d/kingbase7d start

can’t source $/bin/functions

[root@localhost ~]# su - kingbase
[kingbase@localhost ~]$
[kingbase@localhost ~]$
[kingbase@localhost ~]$
[kingbase@localhost ~]$
[kingbase@localhost ~]$ cd KingbaseES/bin/
[kingbase@localhost bin]$
[kingbase@localhost bin]$
[kingbase@localhost bin]$ ./kingbase -D …/data/
LOG: dumping license information…
LOG: file version: 2.0
LOG: product line: ES
LOG: product version: 7.1.2
LOG: distribution type: EE
LOG: operating system: LNX
LOG: architecture: X64
LOG: floating mode: yes
LOG: base date: 2018-10-31
LOG: valid period: 180 days
LOG: max connections: unlimited
LOG: user information: dzҵ
LOG: trial mode: no
LOG: MAC address checking mode: no
LOG: MAC address:
LOG: IPV4 address checking mode: no
LOG: IPV4 address:
LOG: S/N: c47ee2bd-87546f05-e6037736-0a6a5d64
2018-10-31 11:32:37.547 PDT 1 LOG: the encrypt device is opened
2018-10-31 11:32:37.555 PDT [unknown] 2 [unknown]LOG: database system was shut down at 2018-10-31 11:09:31 PDT
2018-10-31 11:32:37.556 PDT [unknown] 2 [unknown]LOG: checkpoint record is at 1/E2D490
2018-10-31 11:32:37.556 PDT [unknown] 2 [unknown]LOG: redo record is at 1/E2D490; undo record is at 0/0; shutdown TRUE
2018-10-31 11:32:37.556 PDT [unknown] 2 [unknown]LOG: next transaction ID: 0/266; next OID: 12112
2018-10-31 11:32:37.556 PDT [unknown] 2 [unknown]LOG: next MultiXactId: 1; next MultiXactOffset: 0
2018-10-31 11:32:37.582 PDT 1 LOG: database system is ready to accept connections
^Csignal_thread returned from sigwait by signal SIGINT : 2
2018-10-31 11:32:40.364 PDT 1 LOG: received fast shutdown request
2018-10-31 11:32:40.364 PDT 1 LOG: aborting any active transactions
2018-10-31 11:32:40.366 PDT [unknown] 2 [unknown]LOG: shutting down
2018-10-31 11:32:40.377 PDT [unknown] 2 [unknown]NOTICE: CheckPoint Start at: 2018-10-31 11:32:40
2018-10-31 11:32:40.386 PDT [unknown] 2 [unknown]NOTICE: CheckPoint Sync Start at: 2018-10-31 11:32:40
2018-10-31 11:32:40.407 PDT [unknown] 2 [unknown]NOTICE: CheckPoint Done at: 2018-10-31 11:32:40
2018-10-31 11:32:40.407 PDT [unknown] 2 [unknown]LOG: database system is shut down
[kingbase@localhost bin]$ ./kingbase -D …/data/ &
[1] 13343
[kingbase@localhost bin]$ LOG: dumping license information…
LOG: file version: 2.0
LOG: product line: ES
LOG: product version: 7.1.2
LOG: distribution type: EE
LOG: operating system: LNX
LOG: architecture: X64
LOG: floating mode: yes
LOG: base date: 2018-10-31
LOG: valid period: 180 days
LOG: max connections: unlimited
LOG: user information: dzҵ
LOG: trial mode: no
LOG: MAC address checking mode: no
LOG: MAC address:
LOG: IPV4 address checking mode: no
LOG: IPV4 address:
LOG: S/N: c47ee2bd-87546f05-e6037736-0a6a5d64
2018-10-31 11:32:43.267 PDT 1 LOG: the encrypt device is opened
2018-10-31 11:32:43.276 PDT [unknown] 2 [unknown]LOG: database system was shut down at 2018-10-31 11:32:40 PDT
2018-10-31 11:32:43.276 PDT [unknown] 2 [unknown]LOG: checkpoint record is at 1/E2D500
2018-10-31 11:32:43.276 PDT [unknown] 2 [unknown]LOG: redo record is at 1/E2D500; undo record is at 0/0; shutdown TRUE
2018-10-31 11:32:43.276 PDT [unknown] 2 [unknown]LOG: next transaction ID: 0/266; next OID: 12112
2018-10-31 11:32:43.276 PDT [unknown] 2 [unknown]LOG: next MultiXactId: 1; next MultiXactOffset: 0
2018-10-31 11:32:43.299 PDT 1 LOG: database system is ready to accept connections

[kingbase@localhost bin]$
[kingbase@localhost bin]$ isql -USYSTEM -WMANAGER -d TEST
2018-10-31 11:32:52.323 PDT [unknown] 5 [unknown]LOG: connection received: host=[local]
2018-10-31 11:32:52.323 PDT [local] TEST 5 SYSTEMLOG: connection authorized: user=SYSTEM database=TEST
2018-10-31 11:32:52.386 PDT [local] TEST 5 SYSTEMLOG: connection authorized: user=SYSTEM database=TEST
Welcome to isql 7.1.2.0935 release 64 bit, the Kingbase interactive terminal.

Type: \h for help with SQL commands
? for help with isql commands
\g or terminate with semicolon to execute query
\q to quit

TEST=#
TEST=#
TEST=#
TEST=# \L
Invalid command \L. Try ? for help.
TEST=#
TEST=# 、
TEST-# \q
2018-10-31 11:33:01.917 PDT [local] TEST 5 SYSTEMLOG: disconnection: session time: 0:00:09.594 user=SYSTEM database=TEST host=[local]
[kingbase@localhost bin]$
[kingbase@localhost bin]$
[kingbase@localhost bin]$
Socket error Event: 32 Error: 10053.
Connection closing…Socket close.

Connection closed by foreign host.

Disconnected from remote host(192.168.240.131:22) at 18:37:00.

Type `help’ to learn how to use Xshell prompt.
[C:~]$
[C:~]$
[C:~]$
[C:~]$ ssh 192.168.240.131

Connecting to 192.168.240.131:22…
Connection established.
To escape to local shell, press ‘Ctrl+Alt+]’.

Last login: Wed Oct 31 11:04:14 2018 from 192.168.240.1
[root@localhost ~]#