search

fukamachi / caveman

Lightweight web application framework for Common Lisp.
http://8arrow.org/caveman/
775 stars 63 forks source link

DB Duplicate Error when using lack-session-store-dbi #78

Open monklof opened 8 years ago

monklof commented 8 years ago

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:

stack.txt

fukamachi commented 8 years ago

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.