[question]Лаги на сервере
14 replies267 viewsCurrently viewing: 1
· 05/28/2009, 07:23 AM
Всем привет, последнее время сервер стал очень сильно лагать онлайн под 100 чел и лагает до ужаса, все замерает и стот гдето 2-3 сек, сервер выдает ошибку:
Код
2009.05.28 05:00:44,167 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 05:20:44,755 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 05:28:49,949 WARNING 680 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 05:40:40,243 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:00:44,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:20:42,868 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:38:47,807 WARNING 687 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:38:56,210 WARNING 688 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:40:40,980 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:59:46,761 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:00:40,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:14:42,781 WARNING 699 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,802 WARNING 700 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,891 WARNING 701 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,045 WARNING 702 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,310 WARNING 703 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,755 WARNING 704 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,638 WARNING 705 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,792 WARNING 706 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 05:20:44,755 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 05:28:49,949 WARNING 680 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 05:40:40,243 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:00:44,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:20:42,868 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:38:47,807 WARNING 687 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:38:56,210 WARNING 688 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:40:40,980 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:59:46,761 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:00:40,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:14:42,781 WARNING 699 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,802 WARNING 700 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,891 WARNING 701 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,045 WARNING 702 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,310 WARNING 703 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,755 WARNING 704 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,638 WARNING 705 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,792 WARNING 706 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
Что это может быть, за чего лаги то? Сервер стоит на Gentoo, конфигурация железки:
Intel Quad Core Xeon 5345, 8GB ECC, SAS 146GB 15k, SAS RAID0 2*73GB 15k
0
· 05/28/2009, 03:01 PM
в базе глянь clan data, серв не может найти данные от клана с id 1
0
· 05/28/2009, 03:20 PM
В том то и прикол что нету такого ИД и близко я уже его пытался и создать, но сервер его при старте удаляет
0
· 05/28/2009, 03:30 PM
GeBrieL1: Всем привет, последнее время сервер стал очень сильно лагать онлайн под 100 чел и лагает до ужаса, все замерает и стот гдето 2-3 сек, сервер выдает ошибку:Код2009.05.28 05:00:44,167 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 05:20:44,755 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 05:28:49,949 WARNING 680 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 05:40:40,243 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:00:44,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:20:42,868 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:38:47,807 WARNING 687 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:38:56,210 WARNING 688 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 06:40:40,980 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 06:59:46,761 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:00:40,794 WARNING 57 net.sf.l2j.gameserver.network.L2GamePacketHandler Client [IP: 62.149.27.6] is trying to connect using Interlude Client
2009.05.28 07:14:42,781 WARNING 699 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,802 WARNING 700 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:42,891 WARNING 701 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,045 WARNING 702 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,310 WARNING 703 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:43,755 WARNING 704 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,638 WARNING 705 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
2009.05.28 07:14:44,792 WARNING 706 net.sf.l2j.gameserver.network.clientpackets.RequestPledgeInfo Clan data for clanId 1 is missing
Что это может быть, за чего лаги то? Сервер стоит на Gentoo, конфигурация железки:
Intel Quad Core Xeon 5345, 8GB ECC, SAS 146GB 15k, SAS RAID0 2*73GB 15k
По этим ошибкам, в базе есть один или несколько чаров у которых в колонке clanId стоит 1
select *
from characters
where clanId = 1;
По лагать - то юзай энтерпрайс, для такой машинки 2к будет бежать....
0
· 05/28/2009, 05:00 PM
када-то и у меня такое было... када я серв делал... причем был токо ГМ чар... и тоже такую ошибку писало.... и ГМ был в клане... но не с id = 1...
0
· 05/28/2009, 08:05 PM
Нету клана с ид1, негде не учаров не в какой таблице, что делать я хз уже лагает всех до ужаса
0
· 05/30/2009, 10:31 AM
Вы попали в самую точку. Это отличная мысль. Готов Вас поддержать.
0
· 06/01/2009, 03:39 PM
я уже для теста кинул такой запрос поудалял все что касалось кланов:
Код
UPDATE characters SET clanid = 0, clan_privs = 0, clan_join_expiry_time = 0, clan_create_expiry_time = 0, title = 'test' WHERE charId > 0;
DELETE FROM clan_data WHERE clan_id > 0;
DELETE FROM clan_privs WHERE clan_id > 0;
DELETE FROM clan_skills WHERE clan_id > 0;
DELETE FROM clan_subpledges WHERE clan_id > 0;
DELETE FROM clan_wars WHERE clan1 > 0;
UPDATE clanhall SET ownerId = 0 WHERE ownerId > 0;
DELETE FROM items WHERE loc = 'CLANWH';
DELETE FROM siege_clans WHERE clan_id > 0;
DELETE FROM clan_data WHERE clan_id > 0;
DELETE FROM clan_privs WHERE clan_id > 0;
DELETE FROM clan_skills WHERE clan_id > 0;
DELETE FROM clan_subpledges WHERE clan_id > 0;
DELETE FROM clan_wars WHERE clan1 > 0;
UPDATE clanhall SET ownerId = 0 WHERE ownerId > 0;
DELETE FROM items WHERE loc = 'CLANWH';
DELETE FROM siege_clans WHERE clan_id > 0;
Такое чуство что кто-то флудит...
0
· 06/02/2009, 03:10 AM
А сервер интерлюд?
Client [IP: 62.149.27.6] is trying to connect using Interlude Client
0
· 06/02/2009, 03:16 AM
Что за сборка ?
0
· 06/08/2009, 05:25 PM
Попробуй вайп кланов сделать!)
0
Войдите или зарегистрируйтесь чтобы ответить