db, result = query(db, blah)
db, result = query(db, blah)
sv_poses_queue_interval_low
higher might help, which is how often it refreshes what player sees on screen. it is already 1500
ms thosv_snapshot_interval 2
if it is not already, or even 3 or 4 until you feel like prediction is not doing fine anymore.backtrace
#0 0x00007ffff7950203 in ?? () from /lib/x86_64-linux-gnu/libmysqlclient.so.21
#1 0x00007ffff7952121 in mysql_stmt_fetch_column () from /lib/x86_64-linux-gnu/libmysqlclient.so.21
#2 0x00005555555891d3 in CMysqlConnection::IsNull (this=0x7fffe8000b70, Col=1)
at /root/build/ddnet22/ddnet/src/engine/server/databases/mysql.cpp:513
#3 0x0000555555625f56 in CScoreWorker::LoadPlayerData (pSqlServer=0x7fffe8000b70, pGameData=0x555555aef820,
pError=0x7ffff4c59900 "unknown error", ErrorSize=256) at /root/build/ddnet22/ddnet/src/game/server/scoreworker.cpp:241
#4 0x0000555555583315 in CDbConnectionPool::ExecSqlFunc (pConnection=0x7fffe8000b70, pData=0x555555c17390, w=NORMAL)
at /root/build/ddnet22/ddnet/src/engine/server/databases/connection_pool.cpp:460
#5 0x0000555555582815 in CWorker::ProcessQueries (this=0x5555559ff5f0)
at /root/build/ddnet22/ddnet/src/engine/server/databases/connection_pool.cpp:320
#6 0x0000555555582559 in CWorker::Start (pUser=0x5555559ff5f0)
at /root/build/ddnet22/ddnet/src/engine/server/databases/connection_pool.cpp:277
#7 0x00005555556d0857 in thread_run (user=0x5555559fe2d0) at /root/build/ddnet22/ddnet/src/base/system.cpp:820
#8 0x00007ffff6e05ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#9 0x00007ffff6e97850 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
(gdb)
what can i do with that....IsNull
just not initialized when calling mysql_stmt_fetch_column() ?bool CMysqlConnection::IsNull(int Col)
{
Col -= 1;
MYSQL_BIND Bind;
my_bool IsNull;
mem_zero(&Bind, sizeof(Bind));
Bind.buffer_type = MYSQL_TYPE_NULL;
Bind.buffer = nullptr;
Bind.buffer_length = 0;
Bind.length = nullptr;
Bind.is_null = &IsNull;
Bind.is_unsigned = false;
Bind.error = nullptr;
if(mysql_stmt_fetch_column(m_pStmt.get(), &Bind, Col, 0))
{
StoreErrorStmt("fetch_column:null");
dbg_msg("mysql", "error fetching column %s", m_aErrorDetail);
dbg_assert(0, "error in IsNull");
}
return IsNull;
}
Bind.is_null = &IsNull;
will make it be written tomariadb --version
(forgot, just mariadb is enough it's a dropin replacement) (edited)Reading state information... Done
mariadb-server is already the newest version (1:10.6.18-0ubuntu0.22.04.1).
The following packages were automatically installed and are no longer required:
libevent-pthreads-2.1-7 libmecab2 libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
root@vps385544254:~#
how to update the package index on ubuntu
- the file is located under /etc/apt/sources.listhow to update the package index on ubuntu
- the file is located under /etc/apt/sources.list how to update the package index on ubuntu
- the file is located under /etc/apt/sources.list how to update the package index on ubuntu
- the file is located under /etc/apt/sources.list [2025-01-02T16:41:08Z INFO graphics_backend::backend_thread] graphics backend thread exited: dlopen(libvulkan.dylib, 0x0005): tried: 'libvulkan.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OSlibvulkan.dylib' (no such file), '/usr/lib/libvulkan.dylib' (no such file, not in dyld cache), 'libvulkan.dylib' (no such file)
(1)
in the end`
2025-01-02 16:23:56 E storage: could not determine user directory
2025-01-02 16:23:56 E storage: could not determine fallback user directory
2025-01-02 16:23:56 I storage: couldn't open storage.cfg
2025-01-02 16:23:56 I storage: using standard paths
2025-01-02 16:23:56 E storage: cannot add path '$USERDIR' because it could not be determined
2025-01-02 16:23:56 I storage: added path '$DATADIR' ('data')
2025-01-02 16:23:56 I storage: added path '$CURRENTDIR' ('/home/ddnet/DDNet-18.8.2-linux_x86_64')
2025-01-02 16:23:56 I host_lookup: host='localhost' port=0 1
2025-01-02 16:23:56 I host_lookup: host='localhost' port=0 2
2025-01-02 16:23:56 I console: executing 'autoexec_server.cfg'
sv_use_sql 1
add_sqlserver r ddnet_server record ddnet 'thebestpassword' 121.0.0.1 3303
add_sqlserver w ddnet_server record ddnet 'thebestpassword' 121.0.0.1 3303 1
sv_use_sql 1
add_sqlserver r ddnet_server record ddnet 'thebestpassword' 121.0.0.1 3303
add_sqlserver w ddnet_server record ddnet 'thebestpassword' 121.0.0.1 3303 1
record_maps
, record_race
, record_teamrace
, record_points
, record_saves
. (They get automatically created with setupdatabase 1 parameter.record_maps
, record_race
, record_teamrace
, record_points
, record_saves
. (They get automatically created with setupdatabase 1 parameter. record_maps
, record_race
, record_teamrace
, record_points
, record_saves
. (They get automatically created with setupdatabase 1 parameter. /mapinfo 001
not work?dump_sqlservers r
dump_sqlservers w
print the respective database server?dump_sqlservers r
dump_sqlservers w
print the respective database server? dump_sqlservers r
dump_sqlservers w
print the respective database server? /mapinfo
should start working with the r(ead) database already