Jump to content

AsyncSQL: connected to localhost (reconnect 1)


Recommended Posts

Keep in mind: FreeBSD 12.1 64 , mysql 5.6 fresh installed. this problems since day one.

 

CH1 runs well if i open only that channel, but when i attend to open more than one, it closes all auth for even ch1 and none of them are working

ch1 autorun: 

Quote

PUBLIC_IP: xx.xxx.xxx.xxx interface vtnet0
PLAYER_MAX_LEVEL: 127
PK_PROTECT_LEVEL: 1LocaleService locale/romania/locale_string.txt
HOSTNAME: channel1
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "romania" (Path: locale/romania)
Setting DB to locale latin2
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
MAP ALLOW 1
MAP ALLOW 3
MAP ALLOW 7
MAP ALLOW 12
MAP ALLOW 13
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 25
MAP ALLOW 27
MAP ALLOW 28
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 45
MAP ALLOW 47
MAP ALLOW 63
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 66
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 81
MAP ALLOW 201
MAP ALLOW 202
MAP ALLOW 213
MAP ALLOW 217
STATUS_POINT_SET_MAX_VALUE: 90
SHOUT_LIMIT_LEVEL: 15

 

Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

ch1 syserr:

Quote

SYSERR: Apr  5 08:24:28 :: pid_init: 
Start of pid: 1197

 

auth config: i have set "x" so i can hide my id, ip and pass, but they are there in my files

Quote

HOSTNAME: auth
CHANNEL: 1
PORT: 11003
P2P_PORT: 12900
DB_PORT: 15000
DB_ADDR: localhost
TABLE_POSTFIX:
ITEM_ID_RANGE: 000000001 000000002
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
AUTH_SERVER: master
PLAYER_SQL: localhost x x account
COMMON_SQL: localhost x x common
LOG_SQL: localhost x x log
ADMINPAGE_IP: 127.0.0.1
ADMINPAGE_PASSWORD: BULLSHIT
MAINTAIN: 0
TEST_SERVER: 0
PK_SERVER: 0
BIND_IP: xx.xxx.xxx.xxx

 

auth autorun:

Quote

PUBLIC_IP: xx.xxx.xxx.xxx interface vtnet0
HOSTNAME: auth
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "romania" (Path: locale/romania)
Setting DB to locale latin2
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
AUTH_SERVER: I am the master
-----------------------------------------------
TEST_SERVER
-----------------------------------------------

MasterAuth 25
 

 

Output Only CH1 opened PS output and i can login ingame no problems

Quote

# ps
 PID TT  STAT    TIME COMMAND
  23 v0  Is+  0:00.03 sh /etc/rc autoboot
1006 v0  I+   0:00.00 sh /etc/rc autoboot
1007 v0  I+   0:00.01 /usr/sbin/sendmail -L sm-mta -bd -q30m -ODaemonPortOptions=Addr=localhost
1015  0  Ss   0:00.01 -sh (sh)
1114  0  S    0:00.01 ./vrunner --daemon --pid-path=pid.db --file=db
1116  0  S    0:00.83 db
1118  0  S    0:00.00 ./vrunner --daemon --pid-path=pid.auth --file=auth
1120  0  S    0:00.10 auth (game)
1122  0  S    0:00.00 ./vrunner --daemon --pid-path=pid.ch1 --file=ch1
1124  0  S    0:07.00 ch1 (game)
1127  0  S    0:00.00 ./vrunner --daemon --pid-path=pid.s_ch1 --file=s_ch1
1129  0  S    0:06.72 s_ch1 (game)
1132  0  S    0:00.00 ./vrunner --daemon --pid-path=pid.special_ch --file=special_ch
1134  0  S    0:01.96 special_ch (game)
1135  0  R+   0:00.00 ps
# service mysql-server status
mysql is not running.
#
 

 

So, because of my mysql stopping the connection may cause the rest of channels to drop, maybe. and how can i fix my mysql to be up?

 

If anyone can help me with this, add me on discord please  "Revenge Arena#4229".. i'm 28hours awake already pushing on this problem with no solution..

Edited by Shahin
Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

40 minutes ago, tierrilopes said:

You need to check mysql.err and .log, it may have some relevant info explaining its crash

Also (because you said it works fine with just one ch and when the others are turned on it starts that behavior) it can be a shortage of resources issue, in this case a ram bottleneck.

how he said  "it can be a shortage of resources issue, in this case a ram bottleneck." or u can check SWAP memory and if is 1GB u can add 4GB is better ,or if is 100% that can cause mysql crash

Command:

for gigabytes

swapinfo -g

for megabytes

swapinfo -m
Link to comment
Share on other sites

My host is 2Cores 4gb ram.

my.cnf:

Quote

[mysqld]
max_connections = 4000
max_connect_errors=20000
query_cache_type=1
query_cache_limit=20M
query_cache_size=256M
log-slow-queries=slow.log
long_query_time=2
mysql_enable=yes

mysql.err:

Quote

200405 20:35:22 mysqld_safe Logging to '/var/db/mysql/Metin.err'.
200405 20:35:22 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored
Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored
2020-04-05 20:35:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-05 20:35:23 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.47) starting as process 1321 ...
2020-04-05 20:35:23 1321 [Note] Plugin 'FEDERATED' is disabled.
2020-04-05 20:35:23 1321 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-04-05 20:35:23 1321 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-05 20:35:23 1321 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-05 20:35:23 1321 [Note] InnoDB: Memory barrier is not used
2020-04-05 20:35:23 1321 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-05 20:35:23 1321 [Note] InnoDB: Using CPU crc32 instructions
2020-04-05 20:35:23 1321 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-05 20:35:23 1321 [Note] InnoDB: Completed initialization of buffer pool
2020-04-05 20:35:23 1321 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2020-04-05 20:35:23 1321 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2020-04-05 20:35:23 1321 [Note] InnoDB: Database physically writes the file full: wait...
2020-04-05 20:35:23 1321 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2020-04-05 20:35:23 1321 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2020-04-05 20:35:23 1321 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-04-05 20:35:23 1321 [Warning] InnoDB: New log files created, LSN=45781
2020-04-05 20:35:23 1321 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-04-05 20:35:23 1321 [Note] InnoDB: Doublewrite buffer created
2020-04-05 20:35:23 1321 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-05 20:35:23 1321 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-04-05 20:35:23 1321 [Note] InnoDB: Foreign key constraint system tables created
2020-04-05 20:35:23 1321 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-04-05 20:35:23 1321 [Note] InnoDB: Tablespace and datafile system tables created.
2020-04-05 20:35:23 1321 [Note] InnoDB: Waiting for purge to start
2020-04-05 20:35:23 1321 [Note] InnoDB: 5.6.47 started; log sequence number 0
2020-04-05 20:35:23 1321 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2020-04-05 20:35:23 1321 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2020-04-05 20:35:23 1321 [Note] Server hostname (bind-address): '*'; port: 3306
2020-04-05 20:35:23 1321 [Note] IPv6 is available.
2020-04-05 20:35:23 1321 [Note]   - '::' resolves to '::';
2020-04-05 20:35:23 1321 [Note] Server socket created on IP: '::'.
2020-04-05 20:35:23 1321 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2020-04-05 20:35:23 1321 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-04-05 20:35:23 1321 [ERROR] Aborting

2020-04-05 20:35:23 1321 [Note] Binlog end
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'partition'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_METRICS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_CMP'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'INNODB_TRX'
2020-04-05 20:35:23 1321 [Note] Shutting down plugin 'InnoDB'
2020-04-05 20:35:23 1321 [Note] InnoDB: FTS optimize thread exiting.
2020-04-05 20:35:23 1321 [Note] InnoDB: Starting shutdown...
2020-04-05 20:35:24 1321 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'BLACKHOLE'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'ARCHIVE'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MRG_MYISAM'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MyISAM'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'MEMORY'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'CSV'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'sha256_password'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'mysql_old_password'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'mysql_native_password'
2020-04-05 20:35:24 1321 [Note] Shutting down plugin 'binlog'
2020-04-05 20:35:24 1321 [Note] /usr/local/libexec/mysqld: Shutdown complete

200405 20:35:24 mysqld_safe mysqld from pid file /var/db/mysql/Metin.pid ended
 

 

Edited by Shahin
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



  • Similar Content

  • Activity

    1. 3

      Crystal Metinstone

    2. 3

      Feeding game source to LLM

    3. 113

      Ulthar SF V2 (TMP4 Base)

    4. 3

      Feeding game source to LLM

    5. 0

      Target Information System

    6. 3

      Feeding game source to LLM

    7. 2

      anti exp explanation pls

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / 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.