SQLite error?

kp_downarrow · Post by **kp_downarrow** » Fri Apr 13, 2007 9:09 pm

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

Post by **Geesu** » Sat Apr 14, 2007 7:10 am

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

kp_downarrow · Post by **kp_downarrow** » Sat Apr 14, 2007 11:31 am

so its just how it is?

Post by **Geesu** » Sat Apr 14, 2007 1:03 pm

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 · Post by **kp_downarrow** » Sun Apr 15, 2007 2:12 pm

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

Post by **Geesu** » Sun Apr 15, 2007 5:04 pm

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.