Anope Bug Tracker - Anope Development (1.9.x series)
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001494||Anope Development (1.9.x series)||IRCD Support||public||2013-03-18 06:59||2013-03-18 19:19|
|Platform||x86_64||OS||Ubuntu Linux||OS Version||12.10|
|Target Version||Fixed in Version|
|Summary||0001494: Upstream timeout when using MySQL with flatfile database on boot.|
|Description||If I enable both the 'db_flatfile' and 'db_sql' modules on boot, Anope takes too long to run through its database tables, resulting in a timeout when trying to connect to its upstream server.|
From what I can tell, it starts the connection to the upstream server first (it opens the socket, but doesn't send anything), then starts to generate tables, etc, and because it takes quite a while, the upstream server considers the incoming connection as not one being registered within the stipulated time frame, and disconnects the connection from Anope before it is able to complete the handshake.
It could just be the size of my database.
I'd suggest changing the sequence within Anope, so that only once all the tables are generated (and data propagated) in MySQL, that it attempt to connect to the upstream server.
|Steps To Reproduce||1) Enable both 'db_flatfile' and 'db_sql' database modules.|
2) Start Anope.
|Additional Information||The disks on the machine are SSD drives, so it can't be a disk IO issue.|
Using latest Anope 1.9.9 GIT.
Using InspIRCd 2.0.10.
|Tags||No tags attached.|
|2013-03-18 06:59||CuttingEdge||New Issue|
|2013-03-18 19:19||Adam||Note Added: 0006406|
|2013-03-18 19:19||Adam||Status||new => resolved|
|2013-03-18 19:19||Adam||Resolution||open => fixed|
|2013-03-18 19:19||Adam||Assigned To||=> Adam|