caveman
caveman copied to clipboard
DB Duplicate Error when using lack-session-store-dbi
I used lack-session-store-dbi to manage the sessions,
(:session
:store (make-dbi-store :connector (lambda ()
(apply #'dbi:connect
(robot-web.db:connection-settings)))))
after starting the server, and after it processed some requests, it begin throwing error DB Error: Duplicate entry '2147483647' for key 'PRIMARY' (Code: 1062)
the session table in my database:
CREATE TABLE `sessions` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`session_data` varchar(2048) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2147483647 DEFAULT CHARSET=utf8
what goes wrong here?
full stacks:
The problem may be resolved in the latest Lack (in https://github.com/fukamachi/lack/commit/9ff8959571f6cacbec4671c372f6327e62455e70). Could you please try it again? Thank you for reporting.