View Issue Details

IDProjectCategoryView StatusLast Update
0007832Multi Theft Auto : San AndreasServerpublic2013-10-01 16:25
Reporterdugasz1Assigned Toccw 
PrioritylowSeverityblockReproducibilityalways
Status resolvedResolutionfixed 
PlatformPCOSWindows 7 OS VersionEnterprise SP1
Product Version 
Target Version1.3.5Fixed in Version1.3.5 
Summary0007832: Double dbPoll freeze
Description

When you run a dbQuery and dbPool it and again the server will freeze.

Steps To Reproduce

local login_q = dbQuery(connection, "SELECT FROM accounts WHERE username = ? AND password = ?",userName ,md5(pw) )
local login_r = dbPoll(login_q, -1)
if login_q then
if #login_r == 1 then
outputChatBox("Beléptél"..login_r[1]['id'], thePlayer, 255,0,0)
local characters_q = dbQuery(connection, "SELECT
FROM characters WHERE owner = ?",login_r[1]['id'] )
local characters_r = dbPoll(login_q, -1) --Freeze the server!
end
end

TagsNo tags attached.

Activities

dugasz1

2013-09-21 22:12

viewer   ~~0019372

Forgett:
Server version: 1.3.3

arranTuna

2013-09-21 22:22

manager   ~~0019373

Does it freeze for only 5 seconds if you do dbPoll(login_q, 5000) instead of dbPoll(login_q, -1)?

If that only freezes for 5 seconds it means that a response is never being returned or the query takes so long to complete you think it's frozen.

ccw

2013-09-22 01:40

administrator   ~~0019376

In your example, the second dbPoll should use 'characters_q'.
However, dbPoll should return an error. So the freeze is a server bug.

CWanted

2013-09-22 18:05

updater   ~~0019379

https://code.google.com/p/mtasa-blue/source/detail?r=5835

Issue History

Date Modified Username Field Change