Yardım [1] + Segmentation fault ./db (core dumped) hatasını çözemedim

Konu sahibi bu konuda soru soruyor. Sorusu ile ilgili bilgisi olanların yanıtlamasını bekliyor.

madpartici

Çaylak Üye
Üye
Mesaj
9
Çözümler
1
Beğeni
6
Puan
13
Ticaret Puanı
0
iyi akşamlar,
eğitim serisinin 5.bölümünde 18.30 dakika civarında ./db & sleep 5 komutu sonrası segmentiation fault db core dumped hatasını çözemedim,videoda da hata oluyor ve main.cpp dosyasından gösterilen kodları silince sorun çözülüyor,bende aynı yolu izleyerek adım adım sildim ve denedim okuttum tekrar aynı hata çıktı, silerken yanlışlık yaptığımı düşünerek github üzerinden hazır olan main.cpp yi indirip tekrar denedim ve gene aynı hatayı aldım.tıkanmış durumdayım en son çare olarak buraya yazdım, yardımlarınızı bekliyorum.

error log dosyalarını temizleyip aynı işlemleri tekrarlayıp alınan hataları yazıyorum:
syserr:
syserr:

SYSERR: Apr 21 23:27:43 :: pid_init:

Start of pid: 1282

syslog:
syslog:

SYSERR: Apr 21 23:27:43 :: pid_init:

Start of pid: 1282



Apr 21 23:27:43 :: connecting to MySQL server (player)

Apr 21 23:27:43 :: CREATING DIRECT_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING MAIN_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING ASYNC_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: OK

Apr 21 23:27:43 :: connecting to MySQL server (account)

Apr 21 23:27:43 :: CREATING DIRECT_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING MAIN_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING ASYNC_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: OK

Apr 21 23:27:43 :: connecting to MySQL server (common)

Apr 21 23:27:43 :: CREATING DIRECT_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING MAIN_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: CREATING ASYNC_SQL

Apr 21 23:27:43 :: AsyncSQL: locale euckr

Apr 21 23:27:43 :: OK

Apr 21 23:27:43 :: ClientManager initialization..

Apr 21 23:27:43 :: InitializeLocalization() - LoadLocaleTable(count:13)

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24

Apr 21 23:27:43 :: locale[LOCALE] = turkey

Apr 21 23:27:43 :: Changed g_stLocale euckr to euckr

Apr 21 23:27:43 :: before call SetLocale: latin5

Apr 21 23:27:43 :: SetLocale start

Apr 21 23:27:43 :: --mysql_set_character_set(latin5)

Apr 21 23:27:43 :: --mysql_set_character_set(latin5)

Apr 21 23:27:43 :: --mysql_set_character_set(latin5)


yardımlarınız ve ilginiz için şimdiden teşekkürler.
 
En son bir moderatör tarafından düzenlenmiş:
db/src/DBManager.cpp dosyasında şu kodların
C++:
    for (int n = 0; n < SQL_MAX_NUM; ++n)
    {
        m_mainSQL[n]->SetLocale(stLocale);
        m_directSQL[n]->SetLocale(stLocale);
        m_asyncSQL[n]->SetLocale(stLocale);

Altına şunu ekleyip dener misiniz?
C++:
        sleep(1);
 
C++:
{
    const std::string stLocale(szLocale);
    sys_log(0, "SetLocale start" );
    for (int n = 0; n < SQL_MAX_NUM; ++n)
    {
        m_mainSQL[n]->SetLocale(stLocale);
        m_directSQL[n]->SetLocale(stLocale);
        m_asyncSQL[n]->SetLocale(stLocale);
        sleep(1);
    }
    sys_log(0, "End setlocale %s", szLocale);
}

doğru mu ekledim bilmiyorum ama hala aynı hatayı veriyor. @Whistle
 
Evet doğru gözüküyor. MySQL server çalışıyor dimi?
 
Çok ilginç daha bugün freebsd 13 üzerinde kaynak kodların derlenmesi ve filesin kurulması için videolar hazırladım
freebsd 13 de performans düşüşü var bu arada. bende serveri kapatmak abartısız 5 dakika sürüyordu, 12.2 de 5 saniye sürmüyor..

tabii beta idi ben kullanırken..
 
gdb ile core yi aç, bt full yaz..
@Whistle @Denizeri24
bt yazınca çıkan hata kodları:
C++:
#0  0x2832ce70 in strtoul_l () from /lib/libc.so.7
#1  0x2832d0dd in strtoul () from /lib/libc.so.7
#2  0x080cda6b in mysql_set_character_set ()
#3  0x080d6275 in CAsyncSQL::QueryLocaleSet ()
#4  0x08051083 in CDBManager::SetLocale (this=0x28421000, szLocale=0x2840dd4c "latin5") at DBManager.cpp:174
#5  0x0805da34 in CClientManager::InitializeLocalization (this=0xbfbfe37c) at ClientManager.cpp:3705
#6  0x0805e74d in CClientManager::Initialize (this=0xbfbfe37c) at ClientManager.cpp:109
#7  0x0804fe02 in Start () at Main.cpp:353
#8  0x08050045 in main () at Main.cpp:88

full hali :

Kod:
(gdb) bt full
#0  0x2832ce70 in strtoul_l () from /lib/libc.so.7
No symbol table info available.
#1  0x2832d0dd in strtoul () from /lib/libc.so.7
No symbol table info available.
#2  0x080cda6b in mysql_set_character_set ()
No symbol table info available.
#3  0x080d6275 in CAsyncSQL::QueryLocaleSet ()
No symbol table info available.
#4  0x08051083 in CDBManager::SetLocale (this=0x28421000, szLocale=0x2840dd4c "latin5") at DBManager.cpp:174
        n = 1
        stLocale = {static npos = 4294967295, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>},
    _M_p = 0x2840d04c "latin5"}}
#5  0x0805da34 in CClientManager::InitializeLocalization (this=0xbfbfe37c) at ClientManager.cpp:3705
        locale = {szValue = "turkey\000 10 12 14 16 18 20 22 24", szKey = "LOCALE\000OWER_BY_LEVEL_TYPE7\000\0209(\035"}
        szQuery = "SELECT mValue, mKey FROM locale", '\0' <repeats 11 times>, "\017", '\0' <repeats 19 times>, "\207▒\032▒t▒7\000▒ݿ▒▒߿▒hݿ▒\rZ4(▒ݿ▒▒▒7(\034▒6(▒ݿ▒▒Y4(t▒7(\230ݿ▒▒J4(▒▒29\034▒6(▒ݿ▒\207▒\032▒\200\203\020(▒V\020(▒k5(t▒7(▒▒7(S߿▒▒\0379(▒ݿ▒\000\000\000\000\000\000\000\000▒\0379(▒ݿ▒\000\000\000\000\000\000\000\000X▒\r\b\037\000\000\000l߿▒\000\000\000\000▒▒▒\177"...
        pMsg = (SQLMsg *) 0x2847e250
        row = <value optimized out>
        __FUNCTION__ = "InitializeLocalization"
#6  0x0805e74d in CClientManager::Initialize (this=0xbfbfe37c) at ClientManager.cpp:109
        tmpValue = <value optimized out>
        szBindIP = "\023\000\000\000▒k5(t▒7(\000\000\000\000▒\206\001\000\000\000\000\000t▒7(▒\0379(▒\0379(▒߿▒qU6(\030 9(\000▒H(3\000\000\000t▒7(t▒7(\000\000\000\000▒߿▒▒T6(▒\0379(▒▒7(X▒\r\b`\0209(X▒\r\b▒⿿\b࿿▒\207\n\b▒\0379(▒\0379(\030࿿\005\000\000\000▒⿿"
        iChinaEventServer = <value optimized out>
        __FUNCTION__ = "Initialize"
#7  0x0804fe02 in Start () at Main.cpp:353
        iRetry = 5
        tmpValue = 304
        heart_beat = 10
        szBuf = " \000tin1\000▒▒h\035'(\000▒\020(ѣ\004\b▒I<\a0▒\202\r \223\020(\001\000\000\000\000▒\020(h\035'(▒⿿▒V\020(\000▒\020(x⿿▒῿▒]\017(▒\231\031(\030\000\000\000T▒A(\025\000\000\000▒▒\031(\230῿<⿿ѣ\004\b▒I<\a0▒\202\r \223\020(\001\000\000\000\000▒\020(h\035'(▒⿿▒V\020(\000▒\020(x⿿T⿿`a\017(\225▒\r\b$⿿$⿿\034\000\000\000\n▒\005@\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020((▒@"...
        iDisableHotBackup = -1077941192
        iIDStart = 100
        szAddr = "localhost\000\000\000\000▒\020(4쿿▒뿿▒꿿X㿿▒▒\016(\000▒\020(p\005\000\000▒꿿▒迿▒迿8쿿4쿿"
        szDB = "common\000\000▒⿿\000\000\000\000X㿿(,\b\b\001\000\000\000▒d\017(▒V\020(▒⿿\024㿿▒뿿▒꿿\177\022@(\000▒@(▒▒@("
        szUser = "mt2\000▒I<\a▒V\020(▒⿿▒~\017(\000\220\020(h\035'(▒⿿▒V\020(▒뿿▒V\020(\024㿿Te\017(\204d\020(▒⿿\004㿿"
        szPassword = "8aa9964a\000\000\000\000\a\000\000\000▒V\020(\000\000\000\000\000▒\020(▒⿿\001d\017(\000▒\020(▒\000\000\000l▒A(\017~\017(▒▒@(▒\223\004\bѣ\004\b"
        iPort = 3306
        line = "localhost common mt2 8aa9964a 3306\000\000 \b\200\000\000\000\n\000\000\000p\212 \b\2008\017(▒▒'(▒▒\004\b\000▒A(▒\212 \b@\000\000\000\006\000\000\000p\212 \b\000῿H῿▒}'(\002\000\002\000▒V\020(\000\000\000\000\000▒\020($῿▒Z\017(\201\005\000\000\004\000\000\000p\212 \b\002\000\000\000 \000\000\000p\212 \b\001\000\00---Type <return> to continue, or q <return> to quit---
 
tabii beta idi ben kullanırken..
:eek::eek: Beta’dan kaynaklı olabilir. Ben fazla bi fark göremedim




CONFIG ve conf.txt içeriğini ekleyebilir misiniz?
conf.txt:
C++:
WELCOME_MSG = "DB Server basladi..."

SQL_ACCOUNT = "localhost account mt2 8aa9964a 3306"
SQL_PLAYER = "localhost player mt2 8aa9964a 3306"
SQL_COMMON = "localhost common mt2 8aa9964a 3306"
SQL_HOTBACKUP = "localhost hotbackup mt2 8aa9964a 3306"

TABLE_POSTFIX = " "

BIND_PORT               = 15900
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 = 70

ITEM_ID_RANGE = 2000000000 2100000000

LOCALE = "latin1"

Linkleri görebilmek için giriş yap veya kayıt ol.


bunu uygulayacaksın, düzelir..
deneyeyim bi

Linkleri görebilmek için giriş yap veya kayıt ol.


bunu uygulayacaksın, düzelir..
yok hocam ya gene olmadı...


Kod:
#0  0x080d62d3 in CAsyncSQL2::SetLocale ()
No symbol table info available.
#1  0x08051060 in CDBManager::SetLocale (this=0xbfbfeb68, szLocale=0x2840d06c "latin5") at DBManager.cpp:172
        n = 3
        stLocale = {static npos = 4294967295, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>},
    _M_p = 0x2840d04c "latin5"}}
#2  0x0805da34 in CClientManager::InitializeLocalization (this=0xbfbfe37c) at ClientManager.cpp:3705
        locale = {szValue = "turkey\000 10 12 14 16 18 20 22 24", szKey = "LOCALE\000OWER_BY_LEVEL_TYPE7\000\0209($"}
        szQuery = "SELECT mValue, mKey FROM locale", '\0' <repeats 11 times>, "\017", '\0' <repeats 19 times>, "▒25at▒7\000▒ݿ▒▒߿▒hݿ▒\rZ4(▒ݿ▒▒▒7(\034▒6(▒ݿ▒▒Y4(t▒7(\230ݿ▒▒J4(▒▒36\034▒6(▒ݿ▒▒25a\200\203\020(▒V\020(▒k5(t▒7(▒▒7(S߿▒▒\0379(▒ݿ▒\000\000\000\000\000\000\000\000▒\0379(▒ݿ▒\000\000\000\000\000\000\000\000▒▒\r\b\037\000\000\000l߿▒\000\000\000\000▒▒▒\177"...
        pMsg = (SQLMsg *) 0x2847e250
        row = <value optimized out>
        __FUNCTION__ = "InitializeLocalization"
#3  0x0805e74d in CClientManager::Initialize (this=0xbfbfe37c) at ClientManager.cpp:109
        tmpValue = <value optimized out>
        szBindIP = "\023\000\000\000▒k5(t▒7(\000\000\000\000▒\206\001\000\000\000\000\000t▒7(▒\0379(▒\0379(▒߿▒qU6(\030 9(\000▒H(3\000\000\000t▒7(t▒7(\000\000\000\000▒߿▒▒T6(▒\0379(▒▒7(▒▒\r\b`\0209(▒▒\r\b▒⿿\b࿿▒\207\n\b▒\0379(▒\0379(\030࿿\005\000\000\000▒⿿"
        iChinaEventServer = <value optimized out>
        __FUNCTION__ = "Initialize"
#4  0x0804fe02 in Start () at Main.cpp:353
        iRetry = 5
        tmpValue = 304
        heart_beat = 10
        szBuf = " \000tin5\000▒▒h\035'(\000▒\020(ѣ\004\b▒I<\a0▒\202\r \223\020(\001\000\000\000\000▒\020(h\035'(▒⿿▒V\020(\000▒\020(x⿿▒῿▒]\017(▒\231\031(\030\000\000\000T▒A(\025\000\000\000▒▒\031(\230῿<⿿ѣ\004\b▒I<\a0▒\202\r \223\020(\001\000\000\000\000▒\020(h\035'(▒⿿▒V\020(\000▒\020(x⿿T⿿`a\017(▒\r\b$⿿$⿿\034\000\000\000\n▒\005@\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020(\000▒\020((▒@"...
        iDisableHotBackup = -1077941192
        iIDStart = 100
        szAddr = "localhost\000\000\000\000▒\020(4쿿▒뿿▒꿿X㿿▒▒\016(\000▒\020(p\005\000\000▒꿿▒迿▒迿8쿿4쿿"
        szDB = "common\000\000▒⿿\000\000\000\000X㿿(,\b\b\001\000\000\000▒d\017(▒V\020(▒⿿\024㿿▒뿿▒꿿\177\022@(\000▒@(▒▒@("
        szUser = "mt2\000▒I<\a▒V\020(▒⿿▒~\017(\000\220\020(h\035'(▒⿿▒V\020(▒뿿▒V\020(\024㿿Te\017(\204d\020(▒⿿\004㿿"
        szPassword = "8aa9964a\000\000\000\000\a\000\000\000▒V\020(\000\000\000\000\000▒\020(▒⿿\001d\017(\000▒\020(▒\000\000\000l▒A(\017~\017(▒▒@(▒\223\004\bѣ\004\b"
        iPort = 3306
        line = "localhost common mt2 8aa9964a 3306\000\000 \b\200\000\000\000\n\000\000\000p\212 \b\2008\017(▒▒'(▒▒\004\b\000▒A(▒\212 \b@\000\000\000\006\000\000\000p\212 \b\000῿H῿▒}'(\002\000\002\000▒V\020(\000\000\000\000\000▒\020($῿▒Z\017(\201\005\000\000\004\000\000\000p\212 \b\002\000\000\000 \000\000\000p\212 \b\001\000\000\000\000῿Y\b.(\000\000\000\000@▒&(▒▒-(t▒7(\021\000\000\000\004\000\000\000▒▒-(t▒7(\024\000\000\000$⿿8῿Y\b"...
        __FUNCTION__ = "Start"
#5  0x08050045 in main () at Main.cpp:88
        Config = {<singleton<CConfig>> = {_vptr$singleton = 0x80dcef0, static ms_singleton = 0xbfbfec18}, m_valueMap = {_M_t = {
      _M_impl = {<std::allocator<std::_Rb_tree_node<std::pair<const std::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::basic_string<char, std::char_traits<char>, std::allocator<char> > > > >> = {<__gnu_cxx::new_allocator<std::_Rb_tree_node<std::pair<const std::basic_string<char, std::char_traits<char>, std::a
 
Geri
Üst