Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: QueueSize load in DataSever  (Visto 1748 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline allhoy Posteado: March 10, 2021, 11:52:48 AM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 325
  • Gracias recibida: 4677
  • ru
Does anyone know why such a problem starts?

When the QueueSize starts to take over. There are terrible brakes on opening the game chest. Attempt to log in to the game

And all this comes from the player who gets into the data server with an error


Gracias:


Offline ZabiinoOo #1 Posteado: March 10, 2021, 12:24:40 PM

  • MAESTRO

  • US. DE HONOR

  • LEYENDA

  • Administrador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 7.456
  • Gracias recibida: 136160
  • pe
Do you have some errors? Have you executed the queries that your repack includes? They are mostly located inside the database folder in a "Querys" folder or with a .sql extension. Go to your sql and run them,

On the other hand, if you are having a saturation it may be due to an attack too, that you need to implement protection or look for a company that offers you this protection, greetings!




Prohibido pedir soporte via MP
Leer las reglas de cada seccion
we trust god

Offline lunaticodeveloper #2 Posteado: March 10, 2021, 12:44:58 PM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28190
  • ar
post u error LOG from dataserver , u missed some querys...

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!


Offline allhoy #3 Posteado: March 10, 2021, 01:09:36 PM | Modificado: March 10, 2021, 01:11:48 PM by allhoy

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 325
  • Gracias recibida: 4677
  • ru
This problem appears every night and not all the time. This is not a DoS attack

Who does not know how to solve this problem? Because it is not only appearing on the Louis build it was also noticed that problem on the LTP TEAM

This user had the same problem back in 2017
https://tuservermu.com.ve/index.php?topic=5618.0


Offline lunaticodeveloper #4 Posteado: March 10, 2021, 01:36:46 PM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28190
  • ar
This problem appears every night and not all the time. This is not a DoS attack

Who does not know how to solve this problem? Because it is not only appearing on the Louis build it was also noticed that problem on the LTP TEAM

This user had the same problem back in 2017
https://tuservermu.com.ve/index.php?topic=5618.0

u missed some querys ,SEND U dataserver log my friend.... u have a error on dataserver.

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!


Offline allhoy #5 Posteado: March 10, 2021, 02:17:32 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 325
  • Gracias recibida: 4677
  • ru
This problem appears every night and not all the time. This is not a DoS attack

Who does not know how to solve this problem? Because it is not only appearing on the Louis build it was also noticed that problem on the LTP TEAM

This user had the same problem back in 2017
https://tuservermu.com.ve/index.php?topic=5618.0

Citar
19:05:06 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,416)
19:05:06 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:05:06 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
19:15:03 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,232)
19:15:03 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:15:03 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
19:25:03 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,48)
19:25:03 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:25:03 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
19:35:04 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,0)
19:35:04 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:35:04 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
19:38:21 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,0)
19:38:21 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:38:21 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
19:38:57 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('BlackRose',11,0)
19:38:57 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CustomQuest'. Cannot insert duplicate key in object 'dbo.CustomQuest'.
19:38:57 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
20:07:22 INSERT INTO CustomQuest (Name,quest,monstercount) VALUES ('',5,200)
20:07:22 [QueryManager] State (23000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CustomQuest_Character". The conflict occurred in database "MuOnline", table "dbo.Character", column 'Name'.
20:07:22 [QueryManager] State (01000), Diagnostic: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.


u missed some querys ,SEND U dataserver log my friend.... u have a error on dataserver.


Offline lunaticodeveloper #6 Posteado: March 10, 2021, 02:54:08 PM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28190
  • ar
the problem is u are triying to insert a date what exist on customquest , what server files u are using?

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!


Offline allhoy #7 Posteado: March 10, 2021, 03:19:10 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 325
  • Gracias recibida: 4677
  • ru
This is not the only problem.
Server Files Louis



Offline lunaticodeveloper #8 Posteado: March 10, 2021, 03:20:53 PM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28190
  • ar
check antivity monitor of sql server :) this is a lock for profesional solutions contact me mp :)

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!

Gracias:


Offline samsunggon #9 Posteado: March 11, 2021, 03:08:59 AM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 471
  • Gracias recibida: 2468
  • ph
almost same problem with me.
SSEMU files :D hahahah


DISCORD: valentino1515


Offline allhoy #10 Posteado: March 11, 2021, 07:17:01 AM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 325
  • Gracias recibida: 4677
  • ru
almost same problem with me.
SSEMU files :D hahahah
the worst thing is that no programmer wants to look for solutions to this problem in their server files :)


Offline lunaticodeveloper #11 Posteado: March 11, 2021, 07:46:28 AM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28190
  • ar
This problem not serverfiles in some cases :)

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
0 Replies
719 Views
Last post August 12, 2017, 10:09:55 PM
by maraso
12 Replies
5895 Views
Last post October 29, 2020, 09:15:47 AM
by nanoremondino
0 Replies
650 Views
Last post November 25, 2020, 10:32:36 AM
by spider
2 Replies
1388 Views
Last post December 02, 2020, 11:48:33 PM
by ZabiinoOo
4 Replies
1322 Views
Last post March 14, 2021, 07:04:47 AM
by choosemu