scoria pack - gameserver freezes

[scr3ative]

My problem is that I launch login server, game server and after like 2-3 hours gameserver freezes, shows as online but doesn't let to connect, needs restarting. It happens even when I test it, like i am the only one connected. Telnet still works, navicat can connect to mysql fine. Do you know what could the problem be? I found one similar problem on google and the problem was with my.cnf not sure though. I use centOS 6.4 mysql 5.5.

 

My.cnf:

 

##  _______________________________________________________________________ 
## / Rackspace MySQL 5.5 Terse Configuration File                          \
## |                                                                       |
## | This is a base configuration file containing the most frequently used |
## | settings with reasonably defined default values for configuring and   |
## | tuning MySQL. Note that these settings can likely be further tuned in |
## | order to get optimum performance from MySQL based upon the database   |
## | configuration and hardware platform.                                  |
## |                                                                       |
## | While the settings provided are likely sufficient for most            |
## | situations, an exhaustive list of settings (with descriptions) can be |
## | found at:                                                             |
## | http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html   |
## |                                                                       |
## | Take care to only add/remove/change a setting if you are comfortable  |
## | doing so! For Rackspace customers, if you have any questions or       |
## | concerns, please contact the MySQL Database Services Team. Be aware   |
## | that some work performed by this team can involve additional billable |
## \ fees.                                                                 /
##  ----------------------------------------------------------------------- 
##         \   ^__^
##          \  (oo)\_______
##             (__)\       )\/\
##                 ||----w |
##                 ||     ||

[mysqld]
## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1

## Cache
thread-cache-size               = 16
table-open-cache                = 4096
table-definition-cache          = 2048
query-cache-size                = 32M 
query-cache-limit               = 1M

## Per-thread Buffers
sort-buffer-size                = 1M
read-buffer-size                = 1M
read-rnd-buffer-size            = 1M
join-buffer-size                = 1M

## Temp Tables
tmp-table-size                  = 128M
max-heap-table-size             = 128M

## Networking
back-log                        = 100
max-connections                 = 300
max-connect-errors              = 10000
max-allowed-packet              = 16M
#interactive-timeout             = 3600
wait-timeout                    = 28800

### Storage Engines
#default-storage-engine         = InnoDB
innodb                          = FORCE

## MyISAM
key-buffer-size                 = 128M
myisam-sort-buffer-size         = 100M

## InnoDB
innodb-buffer-pool-size        = 2G
innodb-log-file-size           = 1G
innodb-log-buffer-size         = 1G
innodb-file-per-table          = 1
innodb-open-files              = 300
innodb_flush_log_at_trx_commit = 2

## Replication
server-id                       = 1
#log-bin                        = /var/log/mysql/bin-log
#relay-log                      = /var/log/mysql/relay-log
relay-log-space-limit           = 16G
expire-logs-days                = 7
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1
#binlog-format                  = STATEMENT
#auto-increment-offset          = 1
#auto-increment-increment       = 2

## Logging
#log-output                      = FILE
#slow-query-log                  = 1
#slow-query-log-file             = /var/log/mysql/slow-log
#log-slow-slave-statements
#long-query-time                 = 2

[mysqld_safe]
log-error                       = /var/log/mysqld.log
open-files-limit                = 65535

[mysql]
no-auto-rehash

 

I start my server with:

cd /folder/folder/folder && ./login_loop.sh &

cd /folder/folder/folder && ./GameServer_loop.sh &

 

Games/login server shows no errors

[Tryskell]

It's because the cow got 5 legs.

 

##         \   ^__^
##          \  (oo)\_______
##             (__)\       )\/\
##                 ||----w |
##                 ||     ||

 

And so far it's a recurrent problem than Frozen had too. You should ask in their forums if they found a solution, speak directly with Nefer or Shyla.

[scr3ative]

ZEN tells me it's my problem

[scr3ative]

Watching via navicat I see that it opens 100 + processes

[Stewie]

It's because the cow got 5 legs.

 

##         \   ^__^
##          \  (oo)\_______
##             (__)\       )\/\
##                 ||----w |
##                 ||     ||

 

And so far it's a recurrent problem than Frozen had too. You should ask in their forums if they found a solution, speak directly with Nefer or Shyla.

 

Ahaha :D

[scr3ative]

I found out that it's not server pack problem. Some guy also uses this pack and has no problems. What else could be the problem then?

After doing some testing, yerstoday I found out that MySQL becomes inactive after 1h, 30 min. Although it can still be connected to, it stops running more processes. Could anyone test their my.cnf please

[Tryskell]

No clue, use another mySQL then.

 

If you added some custom, perhaps an unclosed connection somwhere (scheme buffer, and such).

[scr3ative]

Downloaded fresh pack, same problem. Tried connecting to remote mysql same problem. Also the MySQL reaches 104 process and it freezes, all the processes are sleeping

[Stewie]

Downloaded fresh pack, same problem. Tried connecting to remote mysql same problem. Also the MySQL reaches 104 process and it freezes, all the processes are sleeping

 

I don't know scoria pack - gameserver but you may try this:

server.properties

# Default: 100
MaximumDbConnections = 100

to

# Default: 100
MaximumDbConnections = 1000

[Apache]

Because this bullshit based on Frozen old revs and not supported SQL 5.5.  :poker face:

[scr3ative]

it does support mysql 5.5

Also just found the solution, took about 20 different tests which lasted 2-3 days

[Stewie]

it does support mysql 5.5

Also just found the solution, took about 20 different tests which lasted 2-3 days

 

Can you tell solution to make this post not useless...

[scr3ative]

Will tell the exact solution tommorow/monday changed numerous things so not sure which specific thing helped. Will test them 1 by 1 tommorow. However, I think I know what solved it, but can't say it 100% now.

[Stewie]

Will tell the exact solution tommorow/monday changed numerous things so not sure which specific thing helped. Will test them 1 by 1 tommorow. However, I think I know what solved it, but can't say it 100% now.

 

Is your pack based on L2J?

[SweeTs]

Is your pack based on L2J?

 

Scoria, umm.

[scr3ative]

The problem was due to scoria not closing sleeping connections. When it reaches maximum connections, gameserver stops accepting new connections. How could this be fixed? I am using default scoria pack, no add-ons.

This wait_timeout doesn't seem to close sleeping connections also.

 

Any ideas? For now I increased the connection limit

 

Also these processes don't have any 'state' & 'info'.

Some of these connections time is: 3110