View Issue Details

IDProjectCategoryView StatusLast Update
0009520Multi Theft Auto : San AndreasServerpublic2017-01-18 11:17
ReporteremilevirusAssigned Toccw 
PrioritynormalSeverityminorReproducibilitysometimes
Status resolvedResolutionfixed 
PlatformLinuxOSUbuntuOS Version16.04
Product Version 
Target Version1.5.4Fixed in Version1.5.4 
Summary0009520: SQLite or MySQL make the server freeze if the connection is lost
Description

SQLite or MySQL make the server freeze if the connection is lost or server is under heavy load. It freezes until we restart the server. There is no way to stop the query.

Here's debug lines:
WARNING: Unknown:?? dbPoll is waiting a long time (60 seconds so far). [Query: SELECT serial ,added_ip ,added_date ,auth_who ,auth_date ,last_login_ip ,last_login_date ,last_login_http_date FROM serialusage WHERE userid=1836]
WARNING: Unknown:?? dbPoll is waiting a long time (180 seconds so far). [Query: SELECT serial ,added_ip ,added_date ,auth_who ,auth_date ,last_login_ip ,last_login_date ,last_login_http_date FROM serialusage WHERE userid=1836]
etc. until we restart the server

Steps To Reproduce
  1. Get a SQL server
  2. Make it disconnect while a query is being executed
  3. Server freezes
Additional Information

Server R6 (build 10962)

TagsNo tags attached.

Activities

qaisjp

2017-01-06 15:04

administrator   ~~0025604

Last edited: 2017-01-06 15:05

View 2 revisions

Please can we see the code associated with the following query:

WARNING: Unknown:?? dbPoll is waiting a long time (180 seconds so far). [Query: SELECT serial ,added_ip ,added_date ,auth_who ,auth_date ,last_login_ip ,last_login_date ,last_login_http_date FROM serialusage WHERE userid=1836]

Particularly your usage of dbPoll.

ccw

2017-01-06 16:01

administrator   ~~0025605

serialusage is an internal MTA table

arranTuna

2017-01-06 17:17

manager   ~~0025606

Judging by "Unknown:??" in the debug message, this isn't a script, but why would MTA ever lose connection to it's own sqlite files? Probably something up with your system configuration for this to happen.

ccw

2017-01-06 17:23

administrator   ~~0025607

sqlite and mysql share the same queue, so I think the mysql bug is affecting sqlite operations as well.

emilevirus

2017-01-07 00:25

viewer   ~~0025608

It just happened again, but this time with no query showing at all:
WARNING: Unknown:?? dbPoll is waiting a long time (60 seconds so far). [Query: ]

arranTuna

2017-01-18 11:17

manager   ~~0025635

https://github.com/multitheftauto/mtasa-blue/commit/58e993de158a9f1ae4341df4a9af023708e3cbb6

Issue History

Date Modified Username Field Change