Skip to forum content

You are not logged in. Please login or register.

forums.pvpgn.pro → [EN] Tech Support → Bnetd.log - hundreds of daily errors

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 4

1 Topic by Meanski (edited by deathz0r 16.11.2016 17:05)

  • Meanski
  • Meanski
  • Administrator
  • Offline
  • Registered: 07.08.2016
  • Posts: 194

Topic: Bnetd.log - hundreds of daily errors

Hello,

We get hundreds of the following error in our bnetd.log:

Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_526_uid'->'45212'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_525_uid'->'45711'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_524_uid'->'22810'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_523_uid'->'23080'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_522_uid'->'45164'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_521_uid'->'20731'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_520_uid'->'45523'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_519_uid'->'44544'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_518_uid'->'38905'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_517_uid'->'45561'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_516_uid'->'41737'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_515_uid'->'38125'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_514_uid'->'15642'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_513_uid'->'17420'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_512_uid'->'20241'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_511_uid'->'44584'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_510_uid'->'45298'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_509_uid'->'19341'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_508_uid'->'45016'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_507_uid'->'36777'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_506_uid'->'45564'
Nov 16 02:13:15 [error] sql_write_attrs: could not INSERT attribute 'friend_616_uid'->'45887'

Any idea what this could be?

Thanks!

Owner of SlashDiablo - One of the oldest and most well known Diablo II servers
Admin of Resurgence - Vanilla++ mod
Co-Founder of Hellforged - Diablo 09 built on 1.13 engine (current work in progress)
Founder of Diablo2.org - Dedicated Discord server for PvPGN/D2GS questions

Meanski's Website

2 Reply by Fogeeno

  • Fogeeno
  • newbie
  • Offline
  • Registered: 28.08.2016
  • Posts: 13

Re: Bnetd.log - hundreds of daily errors

do you run by mysql? or do you running it plain?

3 Reply by Meanski

  • Meanski
  • Meanski
  • Administrator
  • Offline
  • Registered: 07.08.2016
  • Posts: 194

Re: Bnetd.log - hundreds of daily errors

MySQL, thanks.

Added: 16.11.2016 13:06

Another error we're seeing a lot of:

Nov 16 02:30:44 [error] handle_init_packet: [28] client requested unknown class 0x05 (length 1) (closing connection)
Nov 16 02:31:53 [error] handle_init_packet: [83] client requested unknown class 0x05 (length 1) (closing connection)
Nov 16 02:33:02 [error] handle_init_packet: [101] client requested unknown class 0x50 (length 1) (closing connection)
Nov 16 02:33:02 [error] handle_init_packet: [101] client requested unknown class 0x05 (length 1) (closing connection)
Nov 16 02:36:39 [error] handle_init_packet: [79] client requested unknown class 0x43 (length 1) (closing connection)
Nov 16 02:36:39 [error] handle_init_packet: [79] client requested unknown class 0x05 (length 1) (closing connection)

Owner of SlashDiablo - One of the oldest and most well known Diablo II servers
Admin of Resurgence - Vanilla++ mod
Co-Founder of Hellforged - Diablo 09 built on 1.13 engine (current work in progress)
Founder of Diablo2.org - Dedicated Discord server for PvPGN/D2GS questions

Meanski's Website

4 Reply by HarpyWar

  • HarpyWar
  • HarpyWar
  • Developer
  • Offline
  • Registered: 07.12.2007
  • Posts: 1,937

Re: Bnetd.log - hundreds of daily errors

May be you reach limit of columns in your database. Try manually create a new column `friend_520_uid` in the table `friends`.
Try "check and repair" the table using embedded mysql functionality.

According to the source code you get unknown packets (from unknown clients, bots) in your second post:
https://github.com/pvpgn/pvpgn-server/b … t.cpp#L133
I think these errors can be ignored, and actually it's type can be changed to "warning" instead of "error".

Do not ask for support in PM.

HarpyWar's Website

Posts: 4

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 1 guest, 0 registered users

forums.pvpgn.pro → [EN] Tech Support → Bnetd.log - hundreds of daily errors