困惑:sessionid在不同的ip上怎么会重复了?
我在维护系统的时候,日志中反映同一个sessionid在很短的时间内在不同ip上出现,感到非常困惑。请问在什么情况下,才可能出现这种现象?
亟盼回复,谢谢。
查询语句:
select distinct a.sessionid, B.sessionid,a.ip,b.ip, a.ltime,b.ltime
from (select * from aemisnewnet..tb_log where operation like '%登陆%') as a
join (select * from aemisnewnet..tb_log where operation like '%登陆%' ) as b
on a.sessionid=b.sessionid and a.ip!=b.ip
order by a.ltime,a.ip
查询结果:(未过滤重复纪录)
f0gsf3yfcaqspg3mstnaaf55
f0gsf3yfcaqspg3mstnaaf55 202.118.69.250 202.118.69.251 2004-09-08 15:35:16.000 2004-09-08 15:42:39.000 f0gsf3yfcaqspg3mstnaaf55
f0gsf3yfcaqspg3mstnaaf55 202.118.69.251 202.118.69.250 2004-09-08 15:42:39.000 2004-09-08 15:35:16.000 rclyza45ohqfy1iye2r5nrei
rclyza45ohqfy1iye2r5nrei 202.118.69.252 202.118.69.250 2004-09-08 15:57:17.000 2004-09-08 16:24:04.000 ctl1kj45u31vfg45b5zw5eup
ctl1kj45u31vfg45b5zw5eup 202.118.69.251 202.118.69.252 2004-09-08 16:00:01.000 2004-09-08 17:03:21.000 una3lrjlablmwt3e1hpcr1vw
una3lrjlablmwt3e1hpcr1vw 202.118.69.254 202.118.69.252 2004-09-08 16:09:49.000 2004-09-08 16:23:17.000 ctl1kj45u31vfg45b5zw5eup
ctl1kj45u31vfg45b5zw5eup 202.118.69.251 202.118.69.252 2004-09-08 16:10:04.000 2004-09-08 17:03:21.000 hbsil4453nekbp32ws0v2b45
hbsil4453nekbp32ws0v2b45 202.118.69.253 202.118.69.252 2004-09-08 16:10:08.000 2004-09-08 16:56:15.000 0pvclv45p5ogsvrhb0pfqp45
0pvclv45p5ogsvrhb0pfqp45 202.118.69.254 202.118.69.253 2004-09-08 16:14:24.000 2004-09-08 16:24:47.000 leepit3rjqitgq2gjg1pdonf
leepit3rjqitgq2gjg1pdonf 202.118.69.252 202.118.69.254 2004-09-08 16:20:54.000 2004-09-08 16:28:22.000 leepit3rjqitgq2gjg1pdonf
leepit3rjqitgq2gjg1pdonf 202.118.69.252 202.118.69.254 2004-09-08 16:20:54.000 2004-09-08 16:28:51.000 una3lrjlablmwt3e1hpcr1vw
una3lrjlablmwt3e1hpcr1vw 202.118.69.252 202.118.69.254 2004-09-08 16:23:17.000 2004-09-08 16:09:49.000 kqzafk45e0ixsm55sdis2r45
kqzafk45e0ixsm55sdis2r45 202.118.69.250 202.118.69.254 2004-09-08 16:23:42.000 2004-09-08 16:31:18.000 rclyza45ohqfy1iye2r5nrei
rclyza45ohqfy1iye2r5nrei 202.118.69.250 202.118.69.252 2004-09-08 16:24:04.000 2004-09-08 15:57:17.000