Conecction and Mysql Config - Start UP

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Conecction and Mysql Config - Start UP

Post by sherlockholmes »

I'm having some internal errors in the console only ... causing large logs and some "Lag" or people who can no longer loging time 5 minutes and you can try again without problem.

sometimes the npc lock and return to work, it's like I'm missing something or memory settings this misplaced
My dedicated have 8 cores and 24 gb ram , whit exelent latency...
Configs :
PD : i use Java jdk 8 in debian

Code: Select all

 #!/bin/bash # exit codes of GameServer:#  0 normal shutdown#  2 reboot attempt while :; do    [ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"    [ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"    java -server -Dfile.encoding=UTF-8 -Xms2048m -Xmx12288m  -cp config/xml:./../libs/****-1.9.5.jar:./../libs/*:reunion-core.jar com.****.**** l2r.gameserver.GameServer > log/stdout.log 2>&1    [ $? -ne 2 ] && break#   /etc/init.d/mysql restart    sleep 10done 
Clientpacket

Code: Select all

# ---------------------------------------------------------------------------# Client packet queue tuning settings# --------------------------------------------------------------------------- # Queue size, do not set it too low !# 0 - use value MaxReadPerPass + 2 (from mmo.properties)# Default: 0ClientPacketQueueSize = 80 # Maximum number of packets in burst.# Execution will be aborted and thread released if more packets executed in raw.# 0 - use value MaxReadPerPass + 1 (from mmo.properties)# Default: 0ClientPacketQueueMaxBurstSize = 70 # Maximum number of packets per second.# Flood detector will be triggered if more packets received.# After triggering all incoming packets will be dropped until flooding stopped.# Default: 80ClientPacketQueueMaxPacketsPerSecond = 160 # Average number of packets per second calculated during this interval.# Using larger value decrease number of false kicks, but slower reaction to flood.# Avoid using too low or too high values, recommended between 3 and 10.# Default: 5ClientPacketQueueMeasureInterval = 15 # Maximum average number of packets per second during measure interval.# Flood detector will be triggered if more packets received.# After triggering all incoming packets will be dropped until flooding stopped.# Default: 40ClientPacketQueueMaxAveragePacketsPerSecond = 120 # Maximum number of flood triggers per minute.# Client will be kicked if more floods detected.# Default: 2ClientPacketQueueMaxFloodsPerMin = 5 # Maximum number of queue overflows per minute.# After overflow all incoming packets from client are dropped until queue is flushed.# Client will be kicked if more queue overflows detected.# Default: 1ClientPacketQueueMaxOverflowsPerMin = 10 # Maximum number of buffer underflows per minute.# Client will be kicked if more underflow exceptions detected.# Default: 1ClientPacketQueueMaxUnderflowsPerMin = 10 # Maximum number of unknown packets per minute.# Client will be kicked if more unknown packets received.# Default: 5ClientPacketQueueMaxUnknownPerMin = 5
And last My.ini (Debian Whit Java 8)

Code: Select all

#port            = 3306socket          = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs# The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed.[mysqld_safe]socket          = /var/run/mysqld/mysqld.socknice            = 0open-files-limit = 8192 [mysqld]## * Basic Settings#user            = mysqlpid-file        = /var/run/mysqld/mysqld.pidsocket          = /var/run/mysqld/mysqld.sockport            = 3306basedir         = /usrdatadir         = /var/lib/mysqltmpdir          = /tmplanguage        = /usr/share/mysql/englishskip-external-locking## Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.bind-address            = 0 # The default storage   engine that will be used when create new tables whendefault-storage-engine= INNODB # Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections = 1200 table_cache = 2500query_cache_size = 16Mquery_cache_type = 1tmp_table_size = 64Mquery_cache_limit=10Mmax_heap_table_size = 64M memlockthread_concurrency = 8thread_cache_size = 200log_slow_queriesthread_concurrency = 8max_allowed_packet = 32Mread_buffer_size = 128Kread_rnd_buffer_size = 32Mjoin_buffer_size = 8Msort_buffer_size = 16Mtransaction_isolation = READ-COMMITTED # #*** INNODB Specific options ***innodb_additional_mem_pool_size =32Minnodb_buffer_pool_size = 4096Minnodb_data_file_path = ibdata1:10M:autoextendinnodb_flush_log_at_trx_commit = 2innodb_log_buffer_size= 32Minnodb_max_dirty_pages_pct = 90innodb_thread_concurrency = 8innodb_file_per_table = 1innodb_open_files = 2000innodb_file_io_threads = 4innodb_support_xa = 0innodb_lock_wait_timeout = 160innodb_file_per_table = 1
And errors
[05:15:27] ERROR: Could not update item Greater CP Potion(20353)[269348578] in DB: Reason: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
I need to configure?
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Conecction and Mysql Config - Start UP

Post by Zealar »

Try with default settings. For how much online speak here? Also do you got npc buffer and if yes which one?
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

l2jserver buffer, and server have 500 online + 300 stores so so...works, but collapses moments in console... appear errors and bigs logs , and lags ^^ ingame
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

This problems appear for example :

Code: Select all

[08:32:21] WARN: Could not store char item reuse data:  com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections    at sun.reflect.GeneratedConstructorAccessor105.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.Util.getInstance(Util.java:383)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4726)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1340)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)    at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)    at java.sql.DriverManager.getConnection(DriverManager.java:664)    at java.sql.DriverManager.getConnection(DriverManager.java:208)    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)    at l2r.util.dbutils.BasicDataSource.getConnection(BasicDataSource.java:78)    at l2r.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:59)    at l2r.gameserver.model.actor.instance.L2PcInstance.storeItemReuseDelay(L2PcInstance.java:8259)    at l2r.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7988)    at l2r.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:8016)    at l2r.gameserver.model.actor.instance.L2PcInstance.deleteMe(L2PcInstance.java:12012)    at l2r.gameserver.Shutdown.disconnectAllCharacters(Shutdown.java:638)    at l2r.gameserver.Shutdown.run(Shutdown.java:226) 

Code: Select all

[08:29:45] ERROR: Could not restore Recommendations for player: 268598815 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections    at sun.reflect.GeneratedConstructorAccessor105.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.Util.getInstance(Util.java:383)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4726)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1340)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)    at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)    at java.sql.DriverManager.getConnection(DriverManager.java:664)    at java.sql.DriverManager.getConnection(DriverManager.java:208)    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)    at l2r.util.dbutils.BasicDataSource.getConnection(BasicDataSource.java:78)    at l2r.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:59)    at l2r.gameserver.model.actor.instance.L2PcInstance.loadRecommendations(L2PcInstance.java:14932)    at l2r.gameserver.model.actor.instance.L2PcInstance.checkRecoBonusTask(L2PcInstance.java:15001)    at l2r.gameserver.network.clientpackets.EnterWorld.runImpl(EnterWorld.java:369)    at l2r.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:73)    at l2r.gameserver.network.L2GameClient.run(L2GameClient.java:1126)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)    at java.lang.Thread.run(Thread.java:745) 

Code: Select all

[08:29:35] WARN: Could not restore L2PcInstance:Dastan[268583001] zone restart time: Too many connections com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections    at sun.reflect.GeneratedConstructorAccessor105.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.Util.getInstance(Util.java:383)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4726)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1340)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)    at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)    at java.sql.DriverManager.getConnection(DriverManager.java:664)    at java.sql.DriverManager.getConnection(DriverManager.java:208)    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)    at l2r.util.dbutils.BasicDataSource.getConnection(BasicDataSource.java:78)    at l2r.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:59)    at l2r.gameserver.model.actor.instance.L2PcInstance.restoreZoneRestartLimitTime(L2PcInstance.java:3063)    at l2r.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7711)    at l2r.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1152)    at l2r.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:596)    at l2r.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:138)    at l2r.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:73)    at l2r.gameserver.network.L2GameClient.run(L2GameClient.java:1126)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)    at java.lang.Thread.run(Thread.java:745) 
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Conecction and Mysql Config - Start UP

Post by Zealar »

Integrate buffer ? Or take some from forum coz there is one with mysql problems.

What about that value in Server settings.

# Default: 100
MaximumDbConnections = 100
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: Conecction and Mysql Config - Start UP

Post by UnAfraid »

max_connections = 1200
i've never used that many connections even with 3 game servers running on same dedicated server under same mysql server..
i have max_connections = 600 for 3 game servers!
Image
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

i have MaximumDbConnections = 100 this
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Conecction and Mysql Config - Start UP

Post by Zealar »

sherlockholmes wrote:i have MaximumDbConnections = 100 this
Try with 300
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

Check

Code: Select all

# ---------------------------------------------------------------------------# Game Server Settings# ---------------------------------------------------------------------------# This is the server configuration file. Here you can set up the connection information for your server.# This was written with the assumption that you are behind a router.# Dumbed Down Definitions...# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # ---------------------------------------------------------------------------# Networking# ---------------------------------------------------------------------------  # Enables automatic port mapping for game server. # If you have a router game server will request for port forwarding. # Default: True EnableUPnP = false # Where's the Login server this gameserver should connect to# WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u># WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u># Default: 127.0.0.1LoginHost = 127.0.0.1 # TCP port the login server listen to for gameserver connection requests# Default: 9014LoginPort = 9014 # Bind address for gameserver. You should not need to change it in most cases.# WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u># WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u># Default: * (0.0.0.0)GameserverHostname = * # Default: 7777GameserverPort = 7777 # ---------------------------------------------------------------------------# Database# --------------------------------------------------------------------------- # Specify the appropriate driver and url for the database you're using.# Examples:# Driver = com.mysql.jdbc.Driver (default)# Driver = org.hsqldb.jdbcDriver# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriverDriver = com.mysql.jdbc.Driver# Database URL# URL = jdbc:mysql://localhost/l2jreuniongs (default)# URL = jdbc:hsqldb:hsql://localhost/l2jreuniongs# URL = jdbc:sqlserver://localhost/database = l2reuniongs/user = sa/password = URL = jdbc:mysql://localhost/l2reuniongs# Database user info (default is "root" but it's not recommended)Login =# Database connection passwordPassword = # Default: 100MaximumDbConnections = 300 # Default: 0MaximumDbIdleTime = 0 # Check interval of inactive connections, default is 60 (1 minute)# Assuming a stable connection to the database and the correct Preset MaxIdleConnectionTimeout, can be set -1 (not checked)IdleConnectionTestPeriod = 60 # ---------------------------------------------------------------------------# Misc Server Settings# --------------------------------------------------------------------------- # This is the server ID that the Game Server will request.# Example: 1 = Bartz# Default: 1RequestServerID = 1 # True = The Login Server will give an other ID to the server if the requested ID is already reserved.# Default: TrueAcceptAlternateID = False # Datapack root directory.# Defaults to current directory from which the server is started unless the below line is uncommented.# WARNING: <u><b><font color="red">If the specified path is invalid, it will lead to multiple errors!</font></b></u>#Default: .DatapackRoot = . # Define how many players are allowed to play simultaneously on your server.# Default: 100MaximumOnlineUsers = 1000 # Numbers of protocol revisions that server allows to connect.# Delimiter is ;# WARNING: <u><b><font color="red">Changing the protocol revision may result in incompatible communication and many errors in game!</font></b></u># Default: 267;268;271;273AllowedProtocolRevisions = 267;268;271;273  # ---------------------------------------------------------------------------# Misc Player Settings# --------------------------------------------------------------------------- # Character name template.# Examples:# CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]*# The above setting will allow names with first capital letter, next three small letters,# and any letter (case insensitive) or number, like OmfgWTF1# CnameTemplate = [A-Z][a-z]*# The above setting will allow names only of letters with first one capital, like Omfgwtf# Default .* (allows any symbol)CnameTemplate = .* # This setting restricts names players can give to their pets.# See CnameTemplate for detailsPetNameTemplate = .* # This setting restricts clan/subpledge names players can set.# See CnameTemplate for detailsClanNameTemplate = .* # Maximum number of characters per account.# Default: 7 (client limit)CharMaxNumber = 7
and now change mysql max conect 1800 to 800
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Conecction and Mysql Config - Start UP

Post by Zealar »

Seems fine test will give the best answer.
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

PRoblem Persist.. Any solution ?
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: Conecction and Mysql Config - Start UP

Post by Zealar »

Use some java profiler to see what eat your mysql.
User avatar
Aikimaniac
L2j Inner Circle
L2j Inner Circle
Posts: 3048
Joined: Sun Aug 07, 2005 11:42 pm
Location: Slovakia

Re: Conecction and Mysql Config - Start UP

Post by Aikimaniac »

sherlockholmes wrote:PRoblem Persist.. Any solution ?
What are your box with DB specs (Any RAID in use?) and do you have DB and gameserver on same box ?
Image
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

Same Raid.
Software RAID 1
2x 2,000 GB SATA II
AMD Opteron™
(8 Cores, 8x 2.3 GHz)
and i use on same box. I think is mysql problem. I change 1 o 2 variables and server crash. Example : Conection max on mysql server crash.
User avatar
sherlockholmes
Posts: 140
Joined: Sun Sep 26, 2010 8:33 pm
Location: argentina

Re: Conecction and Mysql Config - Start UP

Post by sherlockholmes »

Code: Select all

Caused by: java.net.SocketException: Too many open files    at java.net.Socket.createImpl(Socket.java:460)    at java.net.Socket.<init>(Socket.java:431)    at java.net.Socket.<init>(Socket.java:244)    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)    ... 21 morejava.io.IOException: Too many open files    at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)    at sun.nio.ch.ServerSocketChannelImpl.accept(ServerSocketChannelImpl.java:241)    at org.mmocore.network.SelectorThread.acceptConnection(SelectorThread.java:256)    at org.mmocore.network.SelectorThread.run(SelectorThread.java:181)java.io.IOException: Too many open files    at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)    at sun.nio.ch.ServerSocketChannelImpl.accept(ServerSocketChannelImpl.java:241)    at org.mmocore.network.SelectorThread.acceptConnection(SelectorThread.java:256)    at org.mmocore.network.SelectorThread.run(SelectorThread.java:181)java.io.IOException: Too many open files    at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)    at sun.nio.ch.ServerSocketChannelImpl.accept(ServerSocketChannelImpl.java:241)    at org.mmocore.network.SelectorThread.acceptConnection(SelectorThread.java:256)    at org.mmocore.network.SelectorThread.run(SelectorThread.java:181)

Code: Select all

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.    at sun.reflect.GeneratedConstructorAccessor159.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2504)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)    at sun.reflect.GeneratedConstructorAccessor106.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)    at java.sql.DriverManager.getConnection(DriverManager.java:664)    at java.sql.DriverManager.getConnection(DriverManager.java:208)    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)    at l2r.util.dbutils.BasicDataSource.getConnection(BasicDataSource.java:78)    at l2r.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:59)    at l2r.gameserver.LoginServerThread.getCharsOnServer(LoginServerThread.java:579)    at l2r.gameserver.LoginServerThread.run(LoginServerThread.java:344)Caused by: java.net.SocketException: Too many open files    at java.net.Socket.createImpl(Socket.java:460)    at java.net.Socket.<init>(Socket.java:431)    at java.net.Socket.<init>(Socket.java:244)    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)    ... 21 more
Post Reply