Discussion:
[RCU] Duplicated insert's for sessions in log's
Jorge Bastos
2018-10-17 19:04:39 UTC
Permalink
Howdy,



I've seen in the logs this info, and i'd like to know what triggers it.

Would it be the same user logged in more than one place? (well the sessid
should be different for sure)

Was the user that closed the browser and opened it again in the same page?

Another reason?



To handle this what would be the best option, insert it using insert ignore
or replace? Or should it be like this?





Oct 17 18:33:36 fastweb roundcube: <i43tda9m> DB Error: [1062] Duplicate
entry 'i43tda9m0k8a0dukdshmvoettq' for key 'PRIMARY' (SQL Query: INSERT INTO
`session` (`sess_id`, `vars`, `ip`, `changed`) VALUES
('i43tda9m0k8a0dukdshmvoettq',
'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJwdF9QVCI7cmVxdWVzdF90b2tlbnxzOjMyOiJQYVZnYkx
Za2dzQVJTbHlzN2VkT1VWTkJSN3lodFR2NiI7', '148.71.229.58', now())) in
/home/hosting/dbbbbg.pt/webmail/program/lib/Roundcube/rcube_db.php on line
543 (GET
/webmail/?_task=mail&_action=get&_mbox=INBOX&_uid=56841830&_token=d6qQ2Yvet5
ke0DMZEdqWzLZwVemCu2Y5&_part=5&_embed=1&_mimeclass=image)

Loading...