Jump to content
  • 0

[PROBLEM]Syserr


Syreldar

Question

  • Developer

Would appreciate some assistance :)

40k revision:

 

auth:

SYSERR: Apr 15 20:53:14.434429 :: pid_init: 
Start of pid: 2469
 

 

db:

SYSERR: Apr 15 20:53:12 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 15 20:53:12 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "??", "Wildhund", 0, 0, 0, 1, 0, 0, 1, 0,

(it repeats the "Data truncated error" for every mob in my mob_proto.txt)

 

channel1:

SYSERR: Apr 15 20:53:16.444970 :: pid_init: 
Start of pid: 2472
 
 
SYSERR: Apr 15 20:53:24.325560 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327205 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327416 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327519 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327584 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.640284 :: socket_connect: HOST 0:14099, could not connect.

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • Answers 21
  • Created
  • Last Reply

Top Posters For This Question

21 answers to this question

Recommended Posts

  • 0
  • VIP

About the size error, check your db structure:

 

8akcp.png

 

 

Also:
 
socket_connect: HOST 0:14099, could not connect
 
0 is not a valid IP check your database settings in CONFIG

 

 

Link to comment
  • 0
  • Developer

Oh guys i'm so sorry, i've already solved database problem, i just forgot to edit :/

 

But the real problem is this:

 

Channel1:

SYSERR: Apr 15 20:53:16.444970 :: pid_init: 
Start of pid: 2472
 
 
SYSERR: Apr 15 20:53:24.325560 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327205 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327416 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327519 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.327584 :: ForAttrRegionFreeAngle: SECTREE_MANAGER::ForAttrRegion - Unhandled exception. MapIndex: 1
SYSERR: Apr 15 20:53:24.640284 :: socket_connect: HOST 0:14099, could not connect.

 

And the could not connect problem it's due to this problem, i'm pretty sure of it, the ip in database config it's correct and it works on another server that runs on 2089m.

 

I wanted to upgrade that server to 40250 and i've added some my own files that worked perfectly on my testserver, i changed even map folder with mine, wtf is wrong with this problem?

 

conf.txt(db):

WELCOME_MSG = "DB Server has been started"
 
SQL_ACCOUNT = "178.32.42.164 account root *PASSWORD 0"
SQL_PLAYER = "178.32.42.164 player root *PASSWORD 0"
SQL_COMMON = "178.32.42.164 common root *PASSWORD 0"
SQL_HOTBACKUP = "178.32.42.164 hotbackup root *PASSWORD 0" 
 
TABLE_POSTFIX = ""
 
BIND_PORT               = 15000
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 99
PLAYER_DELETE_CHECK_SIMPLE = 1
 
ITEM_ID_RANGE = 2000000000 2100000000
 
MIN_LENGTH_OF_SOCIAL_ID = 6
 
#NAME_COLUMN = "locale_name"
#LOCALE = "italy"
SIMPLE_SOCIALID = 1
 

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

What's in DB_ADDR in channel1?

server's ip.

 

DB_ADDR: 178.32.42.164

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

It should be 127.0.0.1 or are you using an external mysql server?

You're right, i was mistaking, i left that modify for my old testserver that was using an external mysql server.

But this don't solve the problem.

 

I checked Game99's syserr.

 

It says this:

 

SYSERR: Apr 16 15:21:07.702179 :: pid_init: 
Start of pid: 7114
 
SYSERR: Apr 16 15:21:10.141437 :: Show: cannot find sectree by 506781x921383 mapindex 1
SYSERR: Apr 16 15:21:10.141465 :: Show: cannot find sectree by 506896x919815 mapindex 1
SYSERR: Apr 16 15:21:10.141485 :: Show: cannot find sectree by 506873x922693 mapindex 1
SYSERR: Apr 16 15:21:10.141501 :: Show: cannot find sectree by 503999x919800 mapindex 1
SYSERR: Apr 16 15:21:10.141518 :: Show: cannot find sectree by 504039x922681 mapindex 1
SYSERR: Apr 16 15:21:10.141539 :: Show: cannot find sectree by 506898x919967 mapindex 1
SYSERR: Apr 16 15:21:10.141557 :: Show: cannot find sectree by 506877x922521 mapindex 1
SYSERR: Apr 16 15:21:10.141573 :: Show: cannot find sectree by 504163x919799 mapindex 1
SYSERR: Apr 16 15:21:10.141592 :: Show: cannot find sectree by 504218x922677 mapindex 1
SYSERR: Apr 16 15:21:10.141613 :: Show: cannot find sectree by 506899x920135 mapindex 1
SYSERR: Apr 16 15:21:10.141632 :: Show: cannot find sectree by 504323x919808 mapindex 1
SYSERR: Apr 16 15:21:10.141653 :: Show: cannot find sectree by 506900x920304 mapindex 1
SYSERR: Apr 16 15:21:10.141676 :: Show: cannot find sectree by 506881x920473 mapindex 1
SYSERR: Apr 16 15:21:10.141695 :: Show: cannot find sectree by 506899x920674 mapindex 1
SYSERR: Apr 16 15:21:10.141712 :: Show: cannot find sectree by 506884x920820 mapindex 1
SYSERR: Apr 16 15:21:10.141728 :: Show: cannot find sectree by 506886x920973 mapindex 1
SYSERR: Apr 16 15:21:10.141744 :: Show: cannot find sectree by 506868x921131 mapindex 1
SYSERR: Apr 16 15:21:10.141761 :: Show: cannot find sectree by 506726x922696 mapindex 1
SYSERR: Apr 16 15:21:10.141777 :: Show: cannot find sectree by 506876x922381 mapindex 1
SYSERR: Apr 16 15:21:10.141793 :: Show: cannot find sectree by 506897x922221 mapindex 1
SYSERR: Apr 16 15:21:10.141810 :: Show: cannot find sectree by 506898x922060 mapindex 1
SYSERR: Apr 16 15:21:10.141826 :: Show: cannot find sectree by 506892x921873 mapindex 1
SYSERR: Apr 16 15:21:10.141845 :: Show: cannot find sectree by 506881x921667 mapindex 1
SYSERR: Apr 16 15:21:10.141861 :: Show: cannot find sectree by 503992x922508 mapindex 1
SYSERR: Apr 16 15:21:10.141877 :: Show: cannot find sectree by 504492x919823 mapindex 1
SYSERR: Apr 16 15:21:10.141897 :: Show: cannot find sectree by 504638x919817 mapindex 1
SYSERR: Apr 16 15:21:10.141922 :: Show: cannot find sectree by 504826x919821 mapindex 1
SYSERR: Apr 16 15:21:10.141950 :: Show: cannot find sectree by 504999x919831 mapindex 1
SYSERR: Apr 16 15:21:10.141966 :: Show: cannot find sectree by 505153x919810 mapindex 1
SYSERR: Apr 16 15:21:10.141982 :: Show: cannot find sectree by 505307x919814 mapindex 1
SYSERR: Apr 16 15:21:10.141999 :: Show: cannot find sectree by 505441x919826 mapindex 1
SYSERR: Apr 16 15:21:10.142015 :: Show: cannot find sectree by 505585x919816 mapindex 1
SYSERR: Apr 16 15:21:10.142031 :: Show: cannot find sectree by 505751x919837 mapindex 1
SYSERR: Apr 16 15:21:10.142047 :: Show: cannot find sectree by 505903x919811 mapindex 1
SYSERR: Apr 16 15:21:10.142063 :: Show: cannot find sectree by 506069x919830 mapindex 1
SYSERR: Apr 16 15:21:10.142079 :: Show: cannot find sectree by 506213x919820 mapindex 1
SYSERR: Apr 16 15:21:10.142095 :: Show: cannot find sectree by 506422x919827 mapindex 1
SYSERR: Apr 16 15:21:10.142112 :: Show: cannot find sectree by 506654x919827 mapindex 1
SYSERR: Apr 16 15:21:10.142128 :: Show: cannot find sectree by 506577x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142144 :: Show: cannot find sectree by 506409x922690 mapindex 1
SYSERR: Apr 16 15:21:10.142160 :: Show: cannot find sectree by 506246x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142177 :: Show: cannot find sectree by 506041x922695 mapindex 1
SYSERR: Apr 16 15:21:10.142193 :: Show: cannot find sectree by 505885x922671 mapindex 1
SYSERR: Apr 16 15:21:10.142209 :: Show: cannot find sectree by 505714x922689 mapindex 1
SYSERR: Apr 16 15:21:10.142225 :: Show: cannot find sectree by 505502x922677 mapindex 1
SYSERR: Apr 16 15:21:10.142247 :: Show: cannot find sectree by 505291x922672 mapindex 1
SYSERR: Apr 16 15:21:10.142281 :: Show: cannot find sectree by 505089x922668 mapindex 1
SYSERR: Apr 16 15:21:10.142298 :: Show: cannot find sectree by 504908x922698 mapindex 1
SYSERR: Apr 16 15:21:10.142314 :: Show: cannot find sectree by 504730x922685 mapindex 1
SYSERR: Apr 16 15:21:10.142330 :: Show: cannot find sectree by 504392x922683 mapindex 1
SYSERR: Apr 16 15:21:10.142370 :: Show: cannot find sectree by 504557x922699 mapindex 1
SYSERR: Apr 16 15:21:10.142390 :: Show: cannot find sectree by 503980x919951 mapindex 1
SYSERR: Apr 16 15:21:10.142406 :: Show: cannot find sectree by 504014x922342 mapindex 1
SYSERR: Apr 16 15:21:10.142422 :: Show: cannot find sectree by 503997x920115 mapindex 1
SYSERR: Apr 16 15:21:10.142438 :: Show: cannot find sectree by 503963x920269 mapindex 1
SYSERR: Apr 16 15:21:10.142457 :: Show: cannot find sectree by 503961x922166 mapindex 1
SYSERR: Apr 16 15:21:10.142473 :: Show: cannot find sectree by 503998x920423 mapindex 1
SYSERR: Apr 16 15:21:10.142489 :: Show: cannot find sectree by 504003x922011 mapindex 1
SYSERR: Apr 16 15:21:10.142505 :: Show: cannot find sectree by 504013x920620 mapindex 1
SYSERR: Apr 16 15:21:10.142521 :: Show: cannot find sectree by 504006x921809 mapindex 1
SYSERR: Apr 16 15:21:10.142542 :: Show: cannot find sectree by 503962x920789 mapindex 1
SYSERR: Apr 16 15:21:10.142561 :: Show: cannot find sectree by 503931x921662 mapindex 1
SYSERR: Apr 16 15:21:10.142581 :: Show: cannot find sectree by 503948x920923 mapindex 1
SYSERR: Apr 16 15:21:10.142598 :: Show: cannot find sectree by 503940x921527 mapindex 1
SYSERR: Apr 16 15:21:10.142614 :: Show: cannot find sectree by 994112x214380 mapindex 41
SYSERR: Apr 16 15:21:10.142633 :: Show: cannot find sectree by 992254x213259 mapindex 41
SYSERR: Apr 16 15:21:10.142649 :: Show: cannot find sectree by 992685x213252 mapindex 41
SYSERR: Apr 16 15:21:10.142667 :: Show: cannot find sectree by 993079x213246 mapindex 41
SYSERR: Apr 16 15:21:10.142686 :: Show: cannot find sectree by 992308x215351 mapindex 41
SYSERR: Apr 16 15:21:10.142707 :: Show: cannot find sectree by 992672x215333 mapindex 41
SYSERR: Apr 16 15:21:10.142729 :: Show: cannot find sectree by 993042x215326 mapindex 41
SYSERR: Apr 16 15:21:10.142746 :: Show: cannot find sectree by 994215x215061 mapindex 41
SYSERR: Apr 16 15:21:10.142763 :: Show: cannot find sectree by 994196x213760 mapindex 41
SYSERR: Apr 16 15:21:10.142779 :: Show: cannot find sectree by 994799x212818 mapindex 41
SYSERR: Apr 16 15:21:10.142795 :: Show: cannot find sectree by 994568x212822 mapindex 41
SYSERR: Apr 16 15:21:10.142811 :: Show: cannot find sectree by 994343x212822 mapindex 41
SYSERR: Apr 16 15:21:10.142830 :: Show: cannot find sectree by 994113x212830 mapindex 41
SYSERR: Apr 16 15:21:10.142846 :: Show: cannot find sectree by 993874x212855 mapindex 41
SYSERR: Apr 16 15:21:10.142861 :: Show: cannot find sectree by 993644x212885 mapindex 41
SYSERR: Apr 16 15:21:10.142878 :: Show: cannot find sectree by 993400x212891 mapindex 41

 

I'm not an expert in map errors, what's that? :/

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

Channel1 syslog:

Apr 16 15:33:40.128246 :: InputDB::MapLocations 1
Apr 16 15:33:40.128268 :: MapLocation::Insert : 12 0 13099
Apr 16 15:33:40.128291 :: MapLocation::Insert : 81 0 13099
Apr 16 15:33:40.128307 :: MapLocation::Insert : 110 0 13099
Apr 16 15:33:40.128327 :: MapLocation::Insert : 111 0 13099
Apr 16 15:33:40.128342 :: MapLocation::Insert : 113 0 13099
Apr 16 15:33:40.128360 :: MapLocation::Insert : 114 0 13099
Apr 16 15:33:40.128376 :: MapLocation::Insert : 118 0 13099
Apr 16 15:33:40.128390 :: MapLocation::Insert : 119 0 13099
Apr 16 15:33:40.128405 :: MapLocation::Insert : 120 0 13099
Apr 16 15:33:40.128421 :: MapLocation::Insert : 121 0 13099
Apr 16 15:33:40.128439 :: MapLocation::Insert : 122 0 13099
Apr 16 15:33:40.128455 :: MapLocation::Insert : 123 0 13099
Apr 16 15:33:40.128470 :: MapLocation::Insert : 124 0 13099
Apr 16 15:33:40.128488 :: MapLocation::Insert : 125 0 13099
Apr 16 15:33:40.128503 :: MapLocation::Insert : 126 0 13099
Apr 16 15:33:40.128518 :: MapLocation::Insert : 127 0 13099
Apr 16 15:33:40.128533 :: MapLocation::Insert : 128 0 13099
Apr 16 15:33:40.128551 :: MapLocation::Insert : 181 0 13099
Apr 16 15:33:40.128567 :: MapLocation::Insert : 182 0 13099
Apr 16 15:33:40.128581 :: MapLocation::Insert : 183 0 13099
Apr 16 15:33:40.128599 :: MapLocation::Insert : 184 0 13099
Apr 16 15:33:40.128615 :: MapLocation::Insert : 185 0 13099
Apr 16 15:33:40.128629 :: MapLocation::Insert : 186 0 13099
Apr 16 15:33:40.128644 :: MapLocation::Insert : 187 0 13099
Apr 16 15:33:40.128662 :: MapLocation::Insert : 188 0 13099
Apr 16 15:33:40.128678 :: MapLocation::Insert : 189 0 13099
Apr 16 15:33:40.128695 :: MapLocation::Insert : 198 0 13099
Apr 16 15:33:40.128720 :: InputDB:P2P 0:14099
Apr 16 15:33:40.129577 :: SYSTEM: Trying to connect to 0:14099
SYSERR: Apr 16 15:33:40.129694 :: socket_connect: HOST 0:14099, could not connect.
Apr 16 15:33:40.129890 :: P2P Connector opened (host 0)

 

I think i found the problem..

He can't find the server host, it shouldn't be 0 (?)

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

etc/hosts:

# $FreeBSD: release/9.2.0/etc/hosts 109997 2003-01-28 21:29:23Z dbaker $
#
# Host Database
#
# This file should contain the addresses and aliases for local hosts that
# share this file.  Replace 'my.domain' below with the domainname of your
# machine.
#
# In the presence of the domain name service or NIS, this file may
# not be consulted at all; see /etc/nsswitch.conf for the resolution order.
#
#
::1 localhost localhost.my.domain
127.0.0.1 localhost localhost.my.domain
#
# Imaginary network.
#10.0.0.2 myname.my.domain myname
#10.0.0.3 myfriend.my.domain myfriend
#
# According to RFC 1918, you can use the following IP networks for
# private nets which will never be connected to the Internet:
#
# 10.0.0.0 -   10.255.255.255
# 172.16.0.0 -   172.31.255.255
# 192.168.0.0 -   192.168.255.255
#
# In case you want to be able to connect to the Internet, you need
# real official assigned numbers.  Do not try to invent your own network
# numbers but instead get one from your network provider (if any) or
# from your regional registry (ARIN, APNIC, LACNIC, RIPE NCC, or AfriNIC.)
#
 

 

ifconfig:

8aZc9.png

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0

The sectree errors don't matter.

Your db core isn't running.

Did you changed the DB_ADDR to 127.0.0.1  / localhost?

And you should change BIND_PORT = 15000 to BIND_PORT = 14099

Link to comment
  • 0
  • Developer

And you should change BIND_PORT = 15000 to BIND_PORT = 14099

I've already think about this, but can i do it even if 14099 it's already a used port? ( game99's p2p )

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

BIND_PORT ( db ) = 14099

DB_ADDR (every core) = 14099

P2P game new = 15000

 

I practically inverted those two, can i do it?

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

I always receive that error, curious is that if i put in game99 CONFIG:

 

P2P_PORT: 14099
DB_PORT: 14099
 
i receive no error.
 
But if i change one of them i receive the error.

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

did you already try DB_ADDR: localhost ?

 

The default db port is 15000

DB_ADDR is localhost for every core

 

Yes, but i put BIND_PORT = 14099 that should change the db port in 14099.

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment
  • 0
  • Developer

pls i need assistance :/ if i change one of them i get the error, and like now pg crashes at pg selection, server is a dedicate, not hamachi.

 

Situation n*1:

DB_ADDR: localhost
p2p game99: 14099
DB_PORT: 14099[/SPOILER]

 

It's no error but crashes at pg select.

 

Situation n*2:

DB_ADDR: localhost
p2p game99: EVERY_PORT_ !=_14099
DB_PORT: 14099

 

I get that error and crashes at pg select.

 

Situation n*3:

DB_ADDR: localhost
p2p game99: 14099
DB_PORT: EVERY_PORT_ !=_14099

 

I get that error and crashes at pg select.

 

 

I don't know what to do.

👑 Premium International Lua Developer 👑

 My service topic: https://bit.ly/2UPly54

 

Ignorant people have the obligation to compensate their ignorance by paying whoever helps them.

Syreldar

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • 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.