» Find Revision
L2J Revision Number:4422:
L2JDP Revision Number:7669:
*Hello,
I'm having trouble with ur login, after entering the login and password that happens sometimes appears without
char items or the character will not appear on the screen to select the character.
following errors stdout.log ur login and variablesmy mysql
Code: Select all
Remote ServerDriver = com.mysql.jdbc.Driver# Database URLURL = jdbc:mysql://mysqlx.xxx/l2xxCode: Select all
show variables auto_increment_increment 1auto_increment_offset 1automatic_sp_privileges ONback_log 50basedir /binlog_cache_size 32768bulk_insert_buffer_size 8388608character_set_client utf8character_set_connection utf8character_set_database latin1character_set_filesystem binarycharacter_set_results utf8character_set_server latin1character_set_system utf8character_sets_dir /usr/share/mysql/charsets/collation_connection utf8_general_cicollation_database latin1_swedish_cicollation_server latin1_swedish_cicompletion_type 0concurrent_insert 1connect_timeout 5datadir /var/lib/mysql/date_format %Y-%m-%ddatetime_format %Y-%m-%d %H:%i:%sdefault_week_format 0delay_key_write ONdelayed_insert_limit 100delayed_insert_timeout 300delayed_queue_size 1000div_precision_increment 4keep_files_on_create OFFengine_condition_pushdown OFFexpire_logs_days 0flush OFFflush_time 0ft_boolean_syntax + -><()~*:""&|ft_max_word_len 84ft_min_word_len 4ft_query_expansion_limit 20ft_stopword_file (built-in)group_concat_max_len 1024have_archive YEShave_bdb NOhave_blackhole_engine YEShave_compress YEShave_crypt YEShave_csv YEShave_dynamic_loading YEShave_example_engine YEShave_federated_engine YEShave_geometry YEShave_innodb YEShave_isam NOhave_merge_engine YEShave_ndbcluster DISABLEDhave_openssl DISABLEDhave_ssl DISABLEDhave_query_cache YEShave_raid NOhave_rtree_keys YEShave_symlink YEShostname XXXinit_connect init_file init_slave innodb_additional_mem_pool_size 1048576innodb_autoextend_increment 8innodb_buffer_pool_awe_mem_mb 0innodb_buffer_pool_size 8388608innodb_checksums ONinnodb_commit_concurrency 0innodb_concurrency_tickets 500innodb_data_file_path ibdata1:10M:autoextendinnodb_data_home_dir innodb_doublewrite ONinnodb_fast_shutdown 1innodb_file_io_threads 4innodb_file_per_table OFFinnodb_flush_log_at_trx_commit 1innodb_flush_method innodb_force_recovery 0innodb_lock_wait_timeout 50innodb_locks_unsafe_for_binlog OFFinnodb_log_arch_dir innodb_log_archive OFFinnodb_log_buffer_size 1048576innodb_log_file_size 5242880innodb_log_files_in_group 2innodb_log_group_home_dir ./innodb_max_dirty_pages_pct 90innodb_max_purge_lag 0innodb_mirrored_log_groups 1innodb_open_files 300innodb_rollback_on_timeout OFFinnodb_support_xa ONinnodb_sync_spin_loops 20innodb_table_locks ONinnodb_thread_concurrency 8innodb_thread_sleep_delay 10000interactive_timeout 500join_buffer_size 131072key_buffer_size 2147483648key_cache_age_threshold 300key_cache_block_size 1024key_cache_division_limit 100language /usr/share/mysql/english/large_files_support ONlarge_page_size 0large_pages OFFlc_time_names en_USlicense GPLlocal_infile ONlocked_in_memory OFFlog OFFlog_bin OFFlog_bin_trust_function_creators OFFlog_error log_queries_not_using_indexes OFFlog_slave_updates OFFlog_slow_queries ONlog_warnings 1long_query_time 2low_priority_updates OFFlower_case_file_system OFFlower_case_table_names 0max_allowed_packet 1048576max_binlog_cache_size 4294967295max_binlog_size 1073741824max_connect_errors 10max_connections 1640max_delayed_threads 20max_error_count 64max_heap_table_size 536870912max_insert_delayed_threads 20max_join_size 18446744073709551615max_length_for_sort_data 1024max_prepared_stmt_count 16382max_relay_log_size 0max_seeks_for_key 4294967295max_sort_length 1024max_sp_recursion_depth 0max_tmp_tables 32max_user_connections 0max_write_lock_count 4294967295multi_range_count 256myisam_data_pointer_size 6myisam_max_sort_file_size 2147483647myisam_recover_options OFFmyisam_repair_threads 1myisam_sort_buffer_size 8388608myisam_stats_method nulls_unequalndb_autoincrement_prefetch_sz 32ndb_force_send ONndb_use_exact_count ONndb_use_transactions ONndb_cache_check_time 0ndb_connectstring net_buffer_length 16384net_read_timeout 30net_retry_count 10net_write_timeout 60new OFFold_passwords OFFopen_files_limit 19690optimizer_prune_level 1optimizer_search_depth 62pid_file /var/lib/mysql/mysql5.xxx.com.pidport 3306preload_buffer_size 32768profiling ONprofiling_history_size 15protocol_version 10query_alloc_block_size 8192query_cache_limit 31457280query_cache_min_res_unit 4096query_cache_size 536870912query_cache_type ONquery_cache_wlock_invalidate OFFquery_prealloc_size 8192range_alloc_block_size 2048read_buffer_size 131072read_only OFFread_rnd_buffer_size 262144relay_log_purge ONrelay_log_space_limit 0rpl_recovery_rank 0secure_auth OFFsecure_file_priv server_id 0skip_external_locking ONskip_networking OFFskip_show_database OFFslave_compressed_protocol OFFslave_load_tmpdir /tmp/slave_net_timeout 3600slave_skip_errors OFFslave_transaction_retries 10slow_launch_time 2socket /var/lib/mysql/mysql.socksort_buffer_size 2097144sql_big_selects ONsql_mode sql_notes ONsql_warnings OFFssl_ca ssl_capath ssl_cert ssl_cipher ssl_key storage_engine MyISAMsync_binlog 0sync_frm ONsystem_time_zone BRTtable_cache 9020table_lock_wait_timeout 50table_type MyISAMthread_cache_size 300thread_stack 196608time_format %H:%i:%stime_zone SYSTEMtimed_mutexes OFFtmp_table_size 536870912tmpdir /tmp/transaction_alloc_block_size 8192transaction_prealloc_size 4096tx_isolation REPEATABLE-READupdatable_views_with_limit YESversion 5.0.51a-community-logversion_comment MySQL Community Edition (GPL)version_compile_machine i686version_compile_os redhat-linux-gnu[b]wait_timeout 500[/b] Code: Select all
Nov 12, 2010 12:02:56 AM com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo loadCharacterSelectInfoWARNING: Could not restore char info: Communications link failureThe last packet successfully received from the server was 139,891 milliseconds ago. The last packet sent successfully to the server was 10 milliseconds ago.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 139,891 milliseconds ago. The last packet sent successfully to the server was 10 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3055) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:222) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:57) at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:319)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2502) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2952) ... 11 moreNov 12, 2010 12:02:56 AM com.mchange.v2.c3p0.stmt.GooGooStatementCache checkinStatementINFO: Problem with checked-in Statement, discarding.com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:404) at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1140) at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:613) at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:260) at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:312) at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:704) at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:366) at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246) at com.l2jserver.L2DatabaseFactory.close(L2DatabaseFactory.java:277) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:242) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:57) at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:319)Nov 12, 2010 12:02:56 AM com.l2jserver.L2DatabaseFactory closeWARNING: Failed to close database connection!java.sql.SQLException: An SQLException was provoked by the following failure: java.util.ConcurrentModificationException at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62) at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1271) at com.l2jserver.L2DatabaseFactory.close(L2DatabaseFactory.java:277) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:242) at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:57) at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:319)Caused by: java.util.ConcurrentModificationException at java.util.HashMap$HashIterator.nextEntry(HashMap.java:810) at java.util.HashMap$KeyIterator.next(HashMap.java:845) at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:310) at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:704) at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:366) at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246) ... 4 moreNov 12, 2010 12:03:27 AM com.l2jserver.gameserver.model.itemcontainer.PcInventory restoreVisibleInventoryWARNING: Could not restore inventory: Communications link failure