












1




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 1500ms 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 to








mariadb --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.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 




- if you're just using docker to build the server, i'd consider it okay'ish









ideally you would never need to go inside a container

how to update the package index on ubuntu - the file is located under /etc/apt/sources.list 















































































































































































if you are talking about aiming, not spectating



























[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
1045): Access denied>
Jan 02 19:56:48 vps385544254.lowhosting.org DDNet-Server[20131]: 2025-01-02 19:56:48 I sql: [6] show top5 failed on all databases































