d.join verursacht connection refused

04/11/2014 14:13 [PixeL]#1

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 :mad:

d.new_jump und d.new_jump_all funktioniert bei der map leider auch nicht

04/11/2014 14:22 .Shōgun#2

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 [PixeL]#3

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 .Shōgun#4

can you show the syslog?

04/11/2014 14:40 [PixeL]#5

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 .Shōgun#6

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 [PixeL]#7

Spoiler

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 .Shōgun#8

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 [PixeL]#9

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 .Shōgun#10

You didn't show me the syslog from the game core

04/11/2014 15:32 [PixeL]#11

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)