|
You last visited: Today at 09:50
Advertisement
d.join verursacht connection refused
Discussion on d.join verursacht connection refused within the Metin2 Private Server forum part of the Metin2 category.
04/11/2014, 14:13
|
#1
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
d.join verursacht connection refused
Hallo,
bin gerade dabei einige sachen auszuprobieren und scheitere schon am "d.join(191)"
wenn ich über eine quest in ein dungeon teleportieren lassen möchte komme ich auf die map(SD3, invoice files), sehe sie kurz und werde dann gekickt
putty zeigt mir daraufhin an
"Assertion failed: (m_pkAttribute != NULL), function Get Attribute, file sectree.cpp, line 199.
conection refused"
die syserr
"SYSERR: Apr 11 11:57:05 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 704098, 464379, 0, 'WARP', 'Pixel MapIdx 71 DestMapIdx1910000 DestX88100
DestY614900 Empire1', '66.12.123.238') errno: 1406)
SYSERR: Apr 11 11:57:07 :: GetServerLocation: location error name mapindex 0 0 x 0 empire 1"
habe schon alles mögliche versucht und nichts hat geholfen
d.new_jump und d.new_jump_all funktioniert bei der map leider auch nicht
|
|
|
04/11/2014, 14:22
|
#2
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
The dungeon map, and the map you teleport from, must be in the same core, and it can't be ch99.
|
|
|
04/11/2014, 14:31
|
#3
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
Quote:
Originally Posted by .Shōgun
The dungeon map, and the map you teleport from, must be in the same core, and it can't be ch99.
|
the maps are in the same core "channel1 core3", the warp works but the core crashes after the warp
|
|
|
04/11/2014, 14:35
|
#4
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
can you show the syslog?
|
|
|
04/11/2014, 14:40
|
#5
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
in the syslog ist the same error
Quote:
SYSERR: Apr 11 15:38:17 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 88085, 615017, 0, 'WARP', 'Pixel MapIdx 200 DestMapIdx2000000 DestX89600 DestY590500 Empire1', '66.12.123.238') errno: 1406)
SYSERR: Apr 11 15:38:18 :: GetServerLocation: location error name mapindex 0 0 x 0 empire 1
SYSERR: Apr 11 15:38:19 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 89600, 590500, 0, 'LOGIN', '66.12.123.238 889729239 1 2000000 300000', '66.12.123.238') errno: 1406)
|
DB syserr
Quote:
SYSERR: Apr 11 15:44:04 :: Process: FDWATCH: peer null in event: ident 28
SYSERR: Apr 11 15:44:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 89600, y = 590500, z = 0, map_index = 2000000, exit_x = 88100, exit_y = 614900, exit_map_index = 200, hp = 5470, mp = 2200, stamina = 1320, random_hp = 3880, random_sp = 1940, playtime = 3770, level = 98, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 889729239, exp = 302984, stat_point = 267, skill_point = 137, sub_skill_point = 89, stat_reset_count = 0, ip = '77.23.169.238', part_main = 40032, part_hair = 5030, last_play = NOW(), skill_group = 1, alignment = 300000, horse_level = 1, horse_riding = 0, horse_hp = 3, horse_hp_droptime = 1397468914, horse_stamina = 4, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0( \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Lost connection to MySQL server during query (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002650, 1, 1, 16, 1, 71010, 0, 0, 1399729552) errno: 2013)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002653, 1, 2, 8, 1, 72018, 0, 46, 79) errno: 2002)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002653, 1, 2, 8, 1, 72018, 0, 46, 79) errno: 2002)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: retrying
|
DB syslog
Quote:
Apr 11 15:44:00 :: [PLAYER_LOAD] ID Pixel pid 1 gold 889729239
Apr 11 15:44:00 :: QID_QUEST 2
Apr 11 15:44:00 :: QUEST_LOAD: count 5 PID 1
Apr 11 15:44:00 :: QID_AFFECT 2
Apr 11 15:44:00 :: AFFECT_LOAD: count 13 PID 1
Apr 11 15:44:00 :: [ 1050] return 0/0/2 async 0/0/0
Apr 11 15:44:04 :: SetPlay off 153142047 pixel123
Apr 11 15:44:04 :: Connection closed. (host: 127.0.0.1)
Apr 11 15:44:04 :: ItemIDRange: returned. 150000001 ~ 160000000
Apr 11 15:44:04 :: ItemIDRange: Build: 150000001 ~ 160000000 start:150000011
SYSERR: Apr 11 15:44:04 :: Process: FDWATCH: peer null in event: ident 28
Apr 11 15:44:05 :: [ 1100] return 0/0/0 async 0/0/0
SYSERR: Apr 11 15:44:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
Apr 11 15:44:09 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0)
Apr 11 15:44:09 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0)
Apr 11 15:44:09 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0)
Apr 11 15:44:09 :: MainLoop exited, Starting cache flushing
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 89600, y = 590500, z = 0, map_index = 2000000, exit_x = 88100, exit_y = 614900, exit_map_index = 200, hp = 5470, mp = 2200, stamina = 1320, random_hp = 3880, random_sp = 1940, playtime = 3770, level = 98, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 889729239, exp = 302984, stat_point = 267, skill_point = 137, sub_skill_point = 89, stat_reset_count = 0, ip = '77.23.169.238', part_main = 40032, part_hair = 5030, last_play = NOW(), skill_group = 1, alignment = 300000, horse_level = 1, horse_riding = 0, horse_hp = 3, horse_hp_droptime = 1397468914, horse_stamina = 4, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0(\0\0\0\0( \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Lost connection to MySQL server during query (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002650, 1, 1, 16, 1, 71010, 0, 0, 1399729552) errno: 2013)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002653, 1, 2, 8, 1, 72018, 0, 46, 79) errno: 2002)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(10002653, 1, 2, 8, 1, 72018, 0, 46, 79) errno: 2002)
SYSERR: Apr 11 15:44:09 :: ChildLoop: AsyncSQL: retrying
Apr 11 15:44:09 :: AsyncSQL: closing mysql connection.
|
|
|
|
04/11/2014, 14:53
|
#6
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
Your mysql server seems to be dying
Paste from /var/db/mysql the error log (usually yourhostname.err) and /etc/my.cnf if you have it
|
|
|
04/11/2014, 15:06
|
#7
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
140411 16:02:09 mysqld_safe mysqld from pid file /var/db/mysql/PIXEL.pid ended
140411 16:02:45 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2014-04-11 16:02:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-04-11 16:02:45 1147 [Note] Plugin 'FEDERATED' is disabled.
2014-04-11 16:02:45 1147 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-04-11 16:02:45 1147 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-11 16:02:45 1147 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-04-11 16:02:45 1147 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-11 16:02:45 1147 [Note] InnoDB: Using CPU crc32 instructions
2014-04-11 16:02:45 1147 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-11 16:02:45 1147 [Note] InnoDB: Completed initialization of buffer pool
2014-04-11 16:02:45 1147 [Note] InnoDB: Highest supported file format is Barracuda.
2014-04-11 16:02:46 1147 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-11 16:02:46 1147 [Note] InnoDB: Waiting for purge to start
2014-04-11 16:02:46 1147 [Note] InnoDB: 5.6.17 started; log sequence number 1658687
Warning: World-writable config file './auto.cnf' is ignored
2014-04-11 16:02:47 1147 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 94411a83-c179-11e3-b079-005056bd67c5.
2014-04-11 16:02:47 1147 [Note] Server hostname (bind-address): '*'; port: 3306
2014-04-11 16:02:47 1147 [Note] IPv6 is available.
2014-04-11 16:02:47 1147 [Note] - '::' resolves to '::';
2014-04-11 16:02:47 1147 [Note] Server socket created on IP: '::'.
2014-04-11 16:02:47 1147 [Note] Event Scheduler: Loaded 0 events
2014-04-11 16:02:47 1147 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.17' socket: '/tmp/mysql.sock' port: 3306 Source distribution
my.cnf doesn't exist
|
|
|
04/11/2014, 15:10
|
#8
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
Your mysql log shows a first start of the server at 16:02 but your syserr above is logged at 15:44, therefore you had no mysql server running then and the problem should be gone now.
Also your server clock is in Eastern Europe time, is that intended?
|
|
|
04/11/2014, 15:22
|
#9
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
no it's not intended
but these are the current error logs, i delete all logs, start the server and warp into the map to force the crash
€:but if the mysql server doesn't runnig before, i wouldn't can logging in
|
|
|
04/11/2014, 15:24
|
#10
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
You didn't show me the syslog from the game core
|
|
|
04/11/2014, 15:32
|
#11
|
elite*gold: 1700
Join Date: Jul 2008
Posts: 2,939
Received Thanks: 1,114
|
in the syslog is the same error
Quote:
SYSERR: Apr 11 15:38:17 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 88085, 615017, 0, 'WARP', 'Pixel MapIdx 200 DestMapIdx2000000 DestX89600 DestY590500 Empire1', '66.12.123.238') errno: 1406)
SYSERR: Apr 11 15:38:18 :: GetServerLocation: location error name mapindex 0 0 x 0 empire 1
SYSERR: Apr 11 15:38:19 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 89600, 590500, 0, 'LOGIN', '66.12.123.238 889729239 1 2000000 300000', '66.12.123.238') errno: 1406)
|
|
|
|
|
Similar Threads
|
Connection Refused .....
02/19/2012 - Metin2 Private Server - 4 Replies
Hey Com
Ich habe ein proplem mit Connection refused
Und zwar Habe ich neue item erstellt und rates über hp geändert dann reboot seitdem geht es nicht mehr aber ich habe schon über 50 items per hand eingefügt da kann ich kein fehler gemacht haben
Was soll ich posten was euch weiter hilft mir zu helfen
mfg
|
Connection Refused
06/28/2011 - Metin2 Private Server - 0 Replies
Hey habe grad auf mein Server ein Reboot durchgeführt und bekam dan den Fehler Connection Refused.
Das kommt dann durchgehend.
habe mal von mein ch1 die syserr kopiert.
Hoffe mir kann da jemand helfen:
SYSERR: Jun 28 13:57:45 :: socket_connect: HOST localhost:39574, could not connect.
SYSERR: Jun 28 13:57:46 :: socket_connect: HOST 217.23.1.10:7120, could not connect.
SYSERR: Jun 28 13:57:48 :: socket_connect: HOST localhost:39574, could not connect.
|
Connection refused
04/10/2011 - Metin2 Private Server - 5 Replies
Hallo Epvpler,
MAP ALLOW 23
MAP ALLOW 24
MAP ALLOW 43
MAP ALLOW 44
MAP ALLOW 107
MAP ALLOW 5
MAP ALLOW 25
MAP ALLOW 45
|
Connection refused
06/14/2010 - Metin2 Private Server - 5 Replies
Hay Leute,
was soll man machen wenn man den zweiten Root zum ersten Mal starten will
und man dann diese Fehlermeldung erhält : Connection Refused ? :confused:
PS: Die Datenbank ist neu aufgesetzt worden
Danke im Voraus
Mit freundlichen Grüßen,
|
connection refused
11/22/2009 - Metin2 Private Server - 1 Replies
also folgendes,wenn ich meins erver starte kommt nahezu ununterbrochen connection refused wo eigentlich connection: timed out kommen müsste...habe server schon mehrmals gestartet aber es geht nich..weiß wer was das ist? danke im vorraus
mfg
|
All times are GMT +2. The time now is 09:50.
|
|