Jump to content

Issue with 2 servers

Closed 1.0.14

iMonkey
iMonkey

Posted (edited)

I acknowledge I need to update for the additional stat tracking but I have a pretty major issue. I'm running 2 rust servers on a dedicated server, so same IP just different ports. They both connect to a remote SQL db also on a private dedi.

When 1 server is running, everythings smooth sailing.

When both are running, I start getting the following in both consoles and eventually one of the servers locks up:

ExType: MySqlException
MySql handle raised an exception (SocketException: Operation on non-blocking socket would block)
  at System.Net.Sockets.Socket.Receive (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <14e3453b740b4bd690e8d4e5a013a715>:0 
  at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x0009b] in <14e3453b740b4bd690e8d4e5a013a715>:0

The server ip is on the sql access list and again has no issue when its only one or the other server running. During time periods where these errors are reporting to the console, the actual stat tracking falls quite behind too, missing a lot of stuff that's occurred during. I've tried with both the same and different sql accounts.

Edited by iMonkey
Billy Joe

Posted

hmm thats odd, are they both applying to the same table?

iMonkey

Posted

they are not, prefixes are vanilla_ and 5x_

been stumped on it for a while, its behaving like the mysqld on my other dedi has a connection limit, but i'm not aware of any such limitations set. still digging into that angle. 

Billy Joe

Posted

Yeah thats verry odd, I know one big server is running the plugin with like 5-6 servers and haven't heard any issues from them. Could be infact a connection lock or something like that.

Tjbenck

Posted

I'm receiving the similar issue. The only difference is I'm trying to pull stats from a single dedicated server and have also added the server ip on the sql access list.
console returns
 

ExType: MySqlException 

Failed to initialize plugin 'BetterStatistics v1.0.17' (SocketException: Operation on non-blocking socket would block)
  at System.Net.Sockets.Socket.Receive (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <14e3453b740b4bd690e8d4e5a013a715>:0 
  at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x0009b] in <14e3453b740b4bd690e8d4e5a013a715>:0

Billy Joe

Posted

Changed Status from Pending to Closed

1.4m

Downloads

Total number of downloads.

6.9k

Customers

Total customers served.

102.3k

Files Sold

Total number of files sold.

2m

Payments Processed

Total payments processed.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.