[2020-Apr-10 09:29:34.426] 2117 - [info] "config: reading Wt config file: /etc/wt/wt_config.xml (location = '/home/filippo/Documents/Qt_Projects/build-WtTestAuth-Desktop_Qt_5_14_2_GCC_64bit-Debug/WtTestAuth')"
[2020-Apr-10 09:29:34.429] 2117 - [info] "Auth.GoogleService: not configured: OAuth: no 'google-oauth2-redirect-endpoint' property configured at
0x7f09c12e7d31 (Wt::WException::WException(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x41)
0x7f09c11f02b0 (Wt::Auth::OAuthService::configurationProperty(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) [clone .cold]+0xf0)
0x7f09c14c4621 (Wt::Auth::GoogleService::configured()+0xc1)
0x56404ea9a9f2 (Session::configureAuth()+0x1bc)
0x56404ea60459 (main+0x130)
0x7f09c08921e3 (__libc_start_main+0xf3)
0x56404ea3c92e (_start+0x2e)
"
[2020-Apr-10 09:29:34.430] 2117 - [info] "Auth.FacebookService: not configured: OAuth: no 'facebook-oauth2-redirect-endpoint' property configured at
0x7f09c12e7d31 (Wt::WException::WException(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x41)
0x7f09c11f02b0 (Wt::Auth::OAuthService::configurationProperty(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) [clone .cold]+0xf0)
0x7f09c14c14bf (Wt::Auth::FacebookService::configured()+0xaf)
0x56404ea9aa4c (Session::configureAuth()+0x216)
0x56404ea60459 (main+0x130)
0x7f09c08921e3 (__libc_start_main+0xf3)
0x56404ea3c92e (_start+0x2e)
"
[2020-Apr-10 09:29:34.430] 2117 - [info] "WServer/wthttp: initializing built-in wthttpd"
[2020-Apr-10 09:29:34.432] 2117 - [info] "wthttp: started server: http://0.0.0.0:25565"
[2020-Apr-10 09:29:49.856] 2117 - [info] "Wt: session created (#sessions = 1)"
[2020-Apr-10 09:29:49.856] 2117 [/ x4oHz0fv6SjNQM7n] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:29:49.867] "GET / HTTP/1.1" 200 2285
[2020-Apr-10 09:29:49.867] 2117 - [info] "WebRequest: took 43.131 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: rollback transaction
Sqlite3: create table "items" (
  "id" integer primary key autoincrement,
  "version" integer not null,
  "type" text not null,
  "color" text not null,
  "size" text not null,
  "user_id" bigint,
  constraint "fk_items_user" foreign key ("user_id") references "user" ("id") deferrable initially deferred
): table "items" already exists at
0x7f09c0e93bb2 (Wt::Dbo::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x42)
0x7f09c0dc962e (Wt::Dbo::backend::Sqlite3Exception::Sqlite3Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x3e)
0x7f09c0dc7150 (Wt::Dbo::backend::Sqlite3::prepareStatement(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) [clone .cold]+0x7e)
0x7f09c0eba39b (Wt::Dbo::SqlConnection::executeSql(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x2b)
0x7f09c0eae2f4 (Wt::Dbo::Session::executeSql(std::__cxx11::basic_stringstream<char, std::char_traits<char>, std::allocator<char> >&, std::ostream*)+0x144)
0x7f09c0eb1c73 (Wt::Dbo::Session::createTable(Wt::Dbo::Impl::MappingInfo*, std::set<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::less<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > >&, std::ostream*, bool)+0x9f3)
0x7f09c0eb6e9c (Wt::Dbo::Session::createTables()+0x8c)
0x56404ea9ae0c (Session::Session(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x1e6)
0x56404ead27ce (AuthApplication::AuthApplication(Wt::WEnvironment const&)+0xa8)
0x56404ea60a5e (std::unique_ptr<AuthApplication, std::default_delete<AuthApplication> > Wt::cpp14::make_unique<AuthApplication, Wt::WEnvironment const&>(Wt::WEnvironment const&)+0x3d)
0x56404ea602ef (createApplication(Wt::WEnvironment const&)+0x36)
0x56404ea60e0d (std::_Function_handler<std::unique_ptr<Wt::WApplication, std::default_delete<Wt::WApplication> > (Wt::WEnvironment const&), std::unique_ptr<Wt::WApplication, std::default_delete<Wt::WApplication> > (*)(Wt::WEnvironment const&)>::_M_invoke(std::_Any_data const&, Wt::WEnvironment const&)+0x52)
0x7f09c165254d (Wt::WebController::doCreateApplication(Wt::WebSession*)+0x7d)
0x7f09c1660273 (Wt::WebSession::start(Wt::WebResponse*)+0x33)
0x7f09c1669ad4 (Wt::WebSession::handleRequest(Wt::WebSession::Handler&)+0x25f4)
0x7f09c165653c (Wt::WebController::handleRequest(Wt::WebRequest*)+0x89c)
0x7f09c0fb69ac (boost::asio::detail::completion_handler<std::_Bind<void (Wt::WebController::*(Wt::WebController*, http::server::HTTPRequest*))(Wt::WebRequest*)> >::do_complete(void*, boost::asio::detail::scheduler_operation*, boost::system::error_code const&, unsigned long)+0x6c)
0x7f09c13432dd (boost::asio::detail::scheduler::run(boost::system::error_code&)+0x4bd)
0x7f09c133e05f (Wt::WIOService::run()+0x4f)
0x7f09c0c9df74 (std::error_code::default_error_condition() const+0x34)
0x7f09bff97669 (start_thread+0xd9)
0x7f09c098d323 (clone+0x43)

Using existing database
10.0.2.2 - - [2020-Apr-10 09:29:50.171] "GET /?wtd=x4oHz0fv6SjNQM7n&request=style&page=1 HTTP/1.1" 200 104
[2020-Apr-10 09:29:50.171] 2117 - [info] "WebRequest: took 275.697 ms"
[2020-Apr-10 09:29:50.175] 2117 - [info] "Wt: session created (#sessions = 2)"
[2020-Apr-10 09:29:50.175] 2117 [/ eBQsDEEfVjpciVgA] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:29:50.176] "GET /resources/themes/bootstrap/2/bootstrap.css HTTP/1.1" 200 2320
[2020-Apr-10 09:29:50.176] 2117 - [info] "WebRequest: took 0.913 ms"
10.0.2.2 - - [2020-Apr-10 09:29:50.197] "GET /?wtd=x4oHz0fv6SjNQM7n&sid=1937065111&webGL=true&scrW=1600&scrH=900&tz=120&tzS=Europe%2FRome&htmlHistory=true&deployPath=%2F&request=script&rand=2756355346 HTTP/1.1" 200 39755
[2020-Apr-10 09:29:50.197] 2117 - [info] "WebRequest: took 237.826 ms"
[2020-Apr-10 09:29:50.197] 2117 - [info] "Wt: session created (#sessions = 3)"
[2020-Apr-10 09:29:50.197] 2117 - [info] "Wt: session created (#sessions = 4)"
[2020-Apr-10 09:29:50.197] 2117 [/ 5ceAxfpsIfm59YbH] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
[2020-Apr-10 09:29:50.197] 2117 [/ VwkCjuf9ajFDczdF] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:29:50.198] "GET /css/style.css HTTP/1.1" 200 2299
10.0.2.2 - - [2020-Apr-10 09:29:50.198] "GET /resources/themes/bootstrap/2/wt.css HTTP/1.1" 200 2320
[2020-Apr-10 09:29:50.198] 2117 - [info] "WebRequest: took 0.73 ms"
[2020-Apr-10 09:29:50.198] 2117 - [info] "WebRequest: took 0.793 ms"
[2020-Apr-10 09:29:50.198] 2117 - [info] "Wt: session created (#sessions = 5)"
[2020-Apr-10 09:29:50.198] 2117 [/ BrfTTAXsIrIAaoX1] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:29:50.199] "GET /resources/moz-transitions.css HTTP/1.1" 200 2306
[2020-Apr-10 09:29:50.199] 2117 - [info] "WebRequest: took 2.037 ms"
[2020-Apr-10 09:29:50.219] 2117 - [info] "Wt: session created (#sessions = 6)"
[2020-Apr-10 09:29:50.221] 2117 [/ x2uX23GfweFTRFcj] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:29:50.224] "GET /favicon.ico HTTP/1.1" 200 2294
[2020-Apr-10 09:29:50.224] 2117 - [info] "WebRequest: took 4.854 ms"
10.0.2.2 - - [2020-Apr-10 09:29:50.351] "POST /?wtd=x4oHz0fv6SjNQM7n HTTP/1.1" 200 467
[2020-Apr-10 09:29:50.351] 2117 - [info] "WebRequest: took 0.441 ms"
[2020-Apr-10 09:29:59.468] 2117 [/ 5ceAxfpsIfm59YbH] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:29:59.468] 2117 [/ BrfTTAXsIrIAaoX1] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:29:59.468] 2117 [/ VwkCjuf9ajFDczdF] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:29:59.468] 2117 [/ eBQsDEEfVjpciVgA] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:29:59.468] 2117 [/ x2uX23GfweFTRFcj] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:29:59.468] 2117 [/ 5ceAxfpsIfm59YbH] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:29:59.468] 2117 [/ BrfTTAXsIrIAaoX1] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:29:59.468] 2117 [/ VwkCjuf9ajFDczdF] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:29:59.468] 2117 [/ eBQsDEEfVjpciVgA] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:29:59.468] 2117 [/ x2uX23GfweFTRFcj] [info] "Wt: session destroyed (#sessions = 1)"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select u."id" as col0, u."version" as col1, u."user_id" as col2, u."password_hash" as col3, u."password_method" as col4, u."password_salt" as col5, u."status" as col6, u."failed_login_attempts" as col7, u."last_login_attempt" as col8, u."email" as col9, u."unverified_email" as col10, u."email_token" as col11, u."email_token_expires" as col12, u."email_token_role" as col13 from "auth_info" u join "auth_identity" i on u.id = i."auth_info_id" where (i."provider" = ?) and (i."identity" = ?)
Dbo.backend.Sqlite3: select "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "id" = ?
Dbo.backend.Sqlite3: select "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "id" = ?
Dbo.backend.Sqlite3: update "auth_info" set "version" = ?, "user_id" = ?, "password_hash" = ?, "password_method" = ?, "password_salt" = ?, "status" = ?, "failed_login_attempts" = ?, "last_login_attempt" = ?, "email" = ?, "unverified_email" = ?, "email_token" = ?, "email_token_expires" = ?, "email_token_role" = ? where "id" = ? and "version" = ?
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and ("provider" = ?)
Dbo.backend.Sqlite3: commit transaction
[2020-Apr-10 09:29:59.861] 2117 [/ x4oHz0fv6SjNQM7n] [notice] "User 1 (Filippo) logged in."
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and ("provider" = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "version", "sezione_cai", "paese_residenza", "provincia", "telefono", "donati", "ricevuti" from "user" where "id" = ?
Dbo.backend.Sqlite3: commit transaction
[2020-Apr-10 09:29:59.862] 2117 [/ EFDOtKSPpMDw7pXf] [info] "Wt: new session id for x4oHz0fv6SjNQM7n"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and ("provider" = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:29:59.863] "POST /?wtd=x4oHz0fv6SjNQM7n HTTP/1.1" 200 6971
[2020-Apr-10 09:29:59.863] 2117 - [info] "WebRequest: took 62.435 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: SELECT COUNT() as col0 FROM items
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 0 OF 4 ITEMS 10 OF 40

Dbo.backend.Sqlite3: select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:30:06.931] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 7104
[2020-Apr-10 09:30:06.931] 2117 - [info] "WebRequest: took 5.155 ms"
10.0.2.2 - - [2020-Apr-10 09:30:06.964] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:06.964] 2117 - [info] "WebRequest: took 0.524 ms"
10.0.2.2 - - [2020-Apr-10 09:30:07.496] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 136
[2020-Apr-10 09:30:07.496] 2117 - [info] "WebRequest: took 0.585 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 1 OF 4 ITEMS 10 OF 40

Dbo.backend.Sqlite3: select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:30:08.518] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 1082
[2020-Apr-10 09:30:08.518] 2117 - [info] "WebRequest: took 2.704 ms"
10.0.2.2 - - [2020-Apr-10 09:30:08.529] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:08.529] 2117 - [info] "WebRequest: took 0.391 ms"
10.0.2.2 - - [2020-Apr-10 09:30:08.533] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:08.533] 2117 - [info] "WebRequest: took 0.474 ms"
10.0.2.2 - - [2020-Apr-10 09:30:09.078] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 136
[2020-Apr-10 09:30:09.078] 2117 - [info] "WebRequest: took 0.956 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 2 OF 4 ITEMS 10 OF 40

Dbo.backend.Sqlite3: select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:30:09.831] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 1008
[2020-Apr-10 09:30:09.831] 2117 - [info] "WebRequest: took 3.051 ms"
10.0.2.2 - - [2020-Apr-10 09:30:09.841] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:09.841] 2117 - [info] "WebRequest: took 0.496 ms"
10.0.2.2 - - [2020-Apr-10 09:30:09.846] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:09.846] 2117 - [info] "WebRequest: took 0.433 ms"
10.0.2.2 - - [2020-Apr-10 09:30:10.393] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 136
[2020-Apr-10 09:30:10.393] 2117 - [info] "WebRequest: took 1.065 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 3 OF 4 ITEMS 10 OF 40

Dbo.backend.Sqlite3: select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:30:10.840] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 1057
[2020-Apr-10 09:30:10.840] 2117 - [info] "WebRequest: took 3.016 ms"
10.0.2.2 - - [2020-Apr-10 09:30:10.852] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:10.852] 2117 - [info] "WebRequest: took 0.608 ms"
10.0.2.2 - - [2020-Apr-10 09:30:10.859] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:10.859] 2117 - [info] "WebRequest: took 0.498 ms"
10.0.2.2 - - [2020-Apr-10 09:30:11.398] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 136
[2020-Apr-10 09:30:11.398] 2117 - [info] "WebRequest: took 0.519 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 2 OF 4 ITEMS 10 OF 40

Dbo.backend.Sqlite3: select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select "id", "version", "user_id", "password_hash", "password_method", "password_salt", "status", "failed_login_attempts", "last_login_attempt", "email", "unverified_email", "email_token", "email_token_expires", "email_token_role" from "auth_info" where "user_id" = ?
Dbo.backend.Sqlite3: select "id", "version", "auth_info_id", "provider", "identity" from "auth_identity"  where ("auth_info_id" = ?) and (provider = ?)
Dbo.backend.Sqlite3: commit transaction
10.0.2.2 - - [2020-Apr-10 09:30:12.056] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 1046
[2020-Apr-10 09:30:12.056] 2117 - [info] "WebRequest: took 2.779 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.066] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:12.066] 2117 - [info] "WebRequest: took 0.393 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.070] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 50
[2020-Apr-10 09:30:12.070] 2117 - [info] "WebRequest: took 0.717 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: select count(1) from (select "id", "version", "type", "color", "size", "user_id" from "items"  order by type limit ? offset ?)
Dbo.backend.Sqlite3: commit transaction


LOADING PAGE 1 OF 4 ITEMS 10 OF 40

[2020-Apr-10 09:30:12.487] 2117 [/ EFDOtKSPpMDw7pXf] [error] "Wt: fatal error: collection< ptr<C> >::iterator::operator* : read beyond end. at
0x7f09c0e93bb2 (Wt::Dbo::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x42)
0x56404ea41af8 (Wt::Dbo::collection<Wt::Dbo::ptr<ExchangeableItem> >::iterator::operator*()+0xb6)
0x56404ea6d45f (CustomModel::data(Wt::WModelIndex const&, Wt::ItemDataRole) const+0x29f)
0x7f09c139a086 (Wt::WModelIndex::data(Wt::ItemDataRole) const+0x36)
0x7f09c135288e (Wt::WItemDelegate::update(Wt::WWidget*, Wt::WModelIndex const&, Wt::WFlags<Wt::ViewItemRenderFlag>)+0x58e)
0x7f09c143a9b4 (Wt::WTableView::renderWidget(Wt::WWidget*, Wt::WModelIndex const&)+0xb4)
0x7f09c143be2c (Wt::WTableView::renderTable(int, int, int, int)+0x75c)
0x7f09c143e36b (Wt::WTableView::rerenderData()+0x5b)
0x7f09c1443da8 (Wt::WTableView::render(Wt::WFlags<Wt::RenderFlag>)+0x348)
0x7f09c12b3726 (Wt::WCompositeWidget::getSDomChanges(std::vector<Wt::DomElement*, std::allocator<Wt::DomElement*> >&, Wt::WApplication*)+0x96)
0x7f09c1677f94 (Wt::WebRenderer::collectChanges(std::vector<Wt::DomElement*, std::allocator<Wt::DomElement*> >&)+0x3e4)
0x7f09c16784d8 (Wt::WebRenderer::collectJS(Wt::WStringStream*)+0x58)
0x7f09c167a8f7 (Wt::WebRenderer::collectJavaScriptUpdate(Wt::WStringStream&)+0x147)
0x7f09c167af2e (Wt::WebRenderer::collectJavaScript()+0x15e)
0x7f09c167c730 (Wt::WebRenderer::serveJavaScriptUpdate(Wt::WebResponse&)+0x100)
0x7f09c1663b60 (Wt::WebSession::serveResponse(Wt::WebSession::Handler&)+0xe0)
0x7f09c1663d56 (Wt::WebSession::render(Wt::WebSession::Handler&)+0xe6)
0x7f09c166c543 (Wt::WebSession::notify(Wt::WEvent const&)+0x7c3)
0x7f09c1668acf (Wt::WebSession::handleRequest(Wt::WebSession::Handler&)+0x15ef)
0x7f09c165653c (Wt::WebController::handleRequest(Wt::WebRequest*)+0x89c)
0x7f09c0fb69ac (boost::asio::detail::completion_handler<std::_Bind<void (Wt::WebController::*(Wt::WebController*, http::server::HTTPRequest*))(Wt::WebRequest*)> >::do_complete(void*, boost::asio::detail::scheduler_operation*, boost::system::error_code const&, unsigned long)+0x6c)
0x7f09c13432dd (boost::asio::detail::scheduler::run(boost::system::error_code&)+0x4bd)
0x7f09c133e05f (Wt::WIOService::run()+0x4f)
0x7f09c0c9df74 (std::error_code::default_error_condition() const+0x34)
0x7f09bff97669 (start_thread+0xd9)
0x7f09c098d323 (clone+0x43)
"10.0.2.2 - - [2020-Apr-10 09:30:12.487] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 20

[2020-Apr-10 09:30:12.487] 2117 - [info] "WebRequest: took 91.224 ms"
[2020-Apr-10 09:30:12.487] 2117 - [info] "WebController: Removing session EFDOtKSPpMDw7pXf"
[2020-Apr-10 09:30:12.488] 2117 [/ EFDOtKSPpMDw7pXf] [info] "Wt: session destroyed (#sessions = 0)"
[2020-Apr-10 09:30:12.613] 2117 - [info] "Wt: session created (#sessions = 1)"
[2020-Apr-10 09:30:12.613] 2117 [/ Zm4jDouwuqV0czNL] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
[2020-Apr-10 09:30:12.613] 2117 [/ Zm4jDouwuqV0czNL] [info] "Wt: signal from dead session, sending reload."
[2020-Apr-10 09:30:12.613] 2117 - [info] "WebController: Removing session Zm4jDouwuqV0czNL"
[2020-Apr-10 09:30:12.613] 2117 [/ Zm4jDouwuqV0czNL] [info] "Wt: session destroyed (#sessions = 0)"
10.0.2.2 - - [2020-Apr-10 09:30:12.614] "POST /searchitem?wtd=EFDOtKSPpMDw7pXf HTTP/1.1" 200 76
[2020-Apr-10 09:30:12.614] 2117 - [info] "WebRequest: took 0.575 ms"
[2020-Apr-10 09:30:12.623] 2117 - [info] "Wt: session created (#sessions = 1)"
[2020-Apr-10 09:30:12.623] 2117 [/ ZlJw3dw9AawAmw2J] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:30:12.624] "GET /searchitem HTTP/1.1" 200 2290
[2020-Apr-10 09:30:12.624] 2117 - [info] "WebRequest: took 0.63 ms"
Dbo.backend.Sqlite3: begin transaction
Dbo.backend.Sqlite3: rollback transaction
Sqlite3: create table "items" (
  "id" integer primary key autoincrement,
  "version" integer not null,
  "type" text not null,
  "color" text not null,
  "size" text not null,
  "user_id" bigint,
  constraint "fk_items_user" foreign key ("user_id") references "user" ("id") deferrable initially deferred
): table "items" already exists at
0x7f09c0e93bb2 (Wt::Dbo::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x42)
0x7f09c0dc962e (Wt::Dbo::backend::Sqlite3Exception::Sqlite3Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x3e)
0x7f09c0dc7150 (Wt::Dbo::backend::Sqlite3::prepareStatement(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) [clone .cold]+0x7e)
0x7f09c0eba39b (Wt::Dbo::SqlConnection::executeSql(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x2b)
0x7f09c0eae2f4 (Wt::Dbo::Session::executeSql(std::__cxx11::basic_stringstream<char, std::char_traits<char>, std::allocator<char> >&, std::ostream*)+0x144)
0x7f09c0eb1c73 (Wt::Dbo::Session::createTable(Wt::Dbo::Impl::MappingInfo*, std::set<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::less<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > >&, std::ostream*, bool)+0x9f3)
0x7f09c0eb6e9c (Wt::Dbo::Session::createTables()+0x8c)
0x56404ea9ae0c (Session::Session(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x1e6)
0x56404ead27ce (AuthApplication::AuthApplication(Wt::WEnvironment const&)+0xa8)
0x56404ea60a5e (std::unique_ptr<AuthApplication, std::default_delete<AuthApplication> > Wt::cpp14::make_unique<AuthApplication, Wt::WEnvironment const&>(Wt::WEnvironment const&)+0x3d)
0x56404ea602ef (createApplication(Wt::WEnvironment const&)+0x36)
0x56404ea60e0d (std::_Function_handler<std::unique_ptr<Wt::WApplication, std::default_delete<Wt::WApplication> > (Wt::WEnvironment const&), std::unique_ptr<Wt::WApplication, std::default_delete<Wt::WApplication> > (*)(Wt::WEnvironment const&)>::_M_invoke(std::_Any_data const&, Wt::WEnvironment const&)+0x52)
0x7f09c165254d (Wt::WebController::doCreateApplication(Wt::WebSession*)+0x7d)
0x7f09c1660273 (Wt::WebSession::start(Wt::WebResponse*)+0x33)
0x7f09c1669ad4 (Wt::WebSession::handleRequest(Wt::WebSession::Handler&)+0x25f4)
0x7f09c165653c (Wt::WebController::handleRequest(Wt::WebRequest*)+0x89c)
0x7f09c0fb69ac (boost::asio::detail::completion_handler<std::_Bind<void (Wt::WebController::*(Wt::WebController*, http::server::HTTPRequest*))(Wt::WebRequest*)> >::do_complete(void*, boost::asio::detail::scheduler_operation*, boost::system::error_code const&, unsigned long)+0x6c)
0x7f09c13432dd (boost::asio::detail::scheduler::run(boost::system::error_code&)+0x4bd)
0x7f09c133e05f (Wt::WIOService::run()+0x4f)
0x7f09c0c9df74 (std::error_code::default_error_condition() const+0x34)
0x7f09bff97669 (start_thread+0xd9)
0x7f09c098d323 (clone+0x43)

Using existing database
10.0.2.2 - - [2020-Apr-10 09:30:12.671] "GET /searchitem?wtd=ZlJw3dw9AawAmw2J&request=style&page=1 HTTP/1.1" 200 104
[2020-Apr-10 09:30:12.671] 2117 - [info] "WebRequest: took 32.088 ms"
[2020-Apr-10 09:30:12.675] 2117 - [info] "Wt: session created (#sessions = 2)"
[2020-Apr-10 09:30:12.676] 2117 [/ MLqIeno5eAMiEaGu] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:30:12.676] "GET /resources/themes/bootstrap/2/bootstrap.css HTTP/1.1" 200 2319
[2020-Apr-10 09:30:12.677] 2117 - [info] "WebRequest: took 1.093 ms"
[2020-Apr-10 09:30:12.678] 2117 - [info] "Wt: session created (#sessions = 3)"
[2020-Apr-10 09:30:12.678] 2117 - [info] "Wt: session created (#sessions = 4)"
[2020-Apr-10 09:30:12.678] 2117 - [info] "Wt: session created (#sessions = 5)"
[2020-Apr-10 09:30:12.678] 2117 [/ MKcbM95VeYGj1PKp] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
[2020-Apr-10 09:30:12.678] 2117 [/ yNgLeETb2yzlmw48] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
[2020-Apr-10 09:30:12.678] 2117 [/ 2iZqS1ozUkw0IECe] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:30:12.678] "GET /resources/themes/bootstrap/2/wt.css HTTP/1.1" 200 2321
[2020-Apr-10 09:30:12.678] 2117 - [info] "WebRequest: took 0.935 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.679] "GET /resources/moz-transitions.css HTTP/1.1" 200 2308
[2020-Apr-10 09:30:12.679] 2117 - [info] "WebRequest: took 1.879 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.680] "GET /css/style.css HTTP/1.1" 200 2299
[2020-Apr-10 09:30:12.680] 2117 - [info] "WebRequest: took 2.253 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.678] "GET /searchitem?wtd=ZlJw3dw9AawAmw2J&sid=23916334&webGL=true&scrW=1600&scrH=900&tz=120&tzS=Europe%2FRome&htmlHistory=true&deployPath=%2F&request=script&rand=26733113 HTTP/1.1" 200 39759
[2020-Apr-10 09:30:12.680] 2117 - [info] "WebRequest: took 19.353 ms"
[2020-Apr-10 09:30:12.698] 2117 - [info] "Wt: session created (#sessions = 6)"
[2020-Apr-10 09:30:12.699] 2117 [/ eQx2775l52GUh0Hz] [info] "WEnvironment: UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
10.0.2.2 - - [2020-Apr-10 09:30:12.699] "GET /favicon.ico HTTP/1.1" 200 2293
[2020-Apr-10 09:30:12.699] 2117 - [info] "WebRequest: took 2.181 ms"
10.0.2.2 - - [2020-Apr-10 09:30:12.791] "POST /?wtd=ZlJw3dw9AawAmw2J HTTP/1.1" 200 466
[2020-Apr-10 09:30:12.791] 2117 - [info] "WebRequest: took 0.528 ms"
[2020-Apr-10 09:30:24.505] 2117 [/ 2iZqS1ozUkw0IECe] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:30:24.505] 2117 [/ MKcbM95VeYGj1PKp] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:30:24.505] 2117 [/ MLqIeno5eAMiEaGu] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:30:24.505] 2117 [/ eQx2775l52GUh0Hz] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:30:24.505] 2117 [/ yNgLeETb2yzlmw48] [info] "WebController: timeout: expiring"
[2020-Apr-10 09:30:24.505] 2117 [/ 2iZqS1ozUkw0IECe] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:30:24.505] 2117 [/ MKcbM95VeYGj1PKp] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:30:24.505] 2117 [/ MLqIeno5eAMiEaGu] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:30:24.505] 2117 [/ eQx2775l52GUh0Hz] [info] "Wt: session destroyed (#sessions = 1)"
[2020-Apr-10 09:30:24.505] 2117 [/ yNgLeETb2yzlmw48] [info] "Wt: session destroyed (#sessions = 1)"
^C[2020-Apr-10 09:30:33.484] 2117 - [info] "WebController: shutdown: stopping 1 sessions."
[2020-Apr-10 09:30:33.484] 2117 [/ ZlJw3dw9AawAmw2J] [info] "Wt: session destroyed (#sessions = 0)"
[2020-Apr-10 09:30:33.484] 2117 - [info] "WServer/wthttp: Shutdown: stopping web server."
Press <RETURN> to close this window...