Page 1 of 1
SQLite error?
Posted: Fri Apr 13, 2007 9:09 pm
by kp_downarrow
L 04/13/2007 - 21:12:25: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/13/2007 - 21:12:25: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/13/2007 - 21:12:25: [war3ft.amxx] [SQLITE] Query statement: INSERT INTO `wc3_player` ( `player_id` , `player_steamid` , `time` ) VALUES ( NULL , 'STEAM_0:1:5347368', julianday('now') );
Posted: Sat Apr 14, 2007 7:10 am
by Geesu
Posted: Sat Apr 14, 2007 11:31 am
by kp_downarrow
so its just how it is?
Posted: Sat Apr 14, 2007 1:03 pm
by Geesu
I dunno I was hoping from Google you could figure it out :/
Does this always occur? Like are you playing for a while then this pops up? Or do you play - then server crash, then start up, and it locks up?
Posted: Sun Apr 15, 2007 2:12 pm
by kp_downarrow
well sense database is locked at every access, maybe a double access is making that problem
it shows up in my logs on sometimes, not every map,
and sometimes happens right after another
L 04/15/2007 - 11:49:31: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:31: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:31: [war3ft.amxx] [SQLITE] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:0:7018210';
L 04/15/2007 - 11:49:32: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:32: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:32: [war3ft.amxx] [SQLITE] Query statement: INSERT INTO `wc3_player` ( `player_id` , `player_steamid` , `time` ) VALUES ( NULL , 'STEAM_0:0:7018210', julianday('now') );
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:0:7018210';
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:33: [war3ft.amxx] [SQLITE] Query statement: INSERT INTO `wc3_player` ( `player_id` , `player_steamid` , `time` ) VALUES ( NULL , 'STEAM_0:0:9184822', julianday('now') );
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Query statement: INSERT INTO `wc3_player` ( `player_id` , `player_steamid` , `time` ) VALUES ( NULL , 'STEAM_0:0:7018210', julianday('now') );
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Error in querying database, location: 1
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:49:34: [war3ft.amxx] [SQLITE] Query statement: INSERT INTO `wc3_player` ( `player_id` , `player_steamid` , `time` ) VALUES ( NULL , 'STEAM_0:0:9184822', julianday('now') );
L 04/15/2007 - 11:50:03: [war3ft.amxx] [SQLITE] Threaded query error, location: 1
L 04/15/2007 - 11:50:03: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:50:03: [war3ft.amxx] [SQLITE] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '3048', '1', '10285');
L 04/15/2007 - 11:50:03: [war3ft.amxx] [SQLITE] Fail state: Query Failed
L 04/15/2007 - 11:50:07: [war3ft.amxx] [SQLITE] Threaded query error, location: 1
L 04/15/2007 - 11:50:07: [war3ft.amxx] [SQLITE] Message: database is locked (5)
L 04/15/2007 - 11:50:07: [war3ft.amxx] [SQLITE] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '3210', '4', '854');
L 04/15/2007 - 11:50:07: [war3ft.amxx] [SQLITE] Fail state: Query Failed
maybe just that one person is causing errors
Posted: Sun Apr 15, 2007 5:04 pm
by Geesu
Interesting I wonder if it has to do with the fact that it is threaded? This problem never came up until I used the threaded one.
