SQLite error?

[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') );

[Geesu]

http://www.google.com/search?q=sqlite%2 ... S:official

[kp_downarrow]

so its just how it is?

[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?

[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

[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.