[Plugin] [REL] MySQL Plugin (Now on github!)

What is ORM System?
Reply

Quote:
Originally Posted by Pain123
Посмотреть сообщение
Same shit, just staring at the ocean unfortunately. I can still use commands however.
Reply

Hey guys, I don't know what wrong im doing but im facing this problem from 2 weeks and server is off from 2 weeks too, please help me, its happen every time i start my server. This is the server log :
__________________________________________________ _____
[15:52:28]
[15:52:28] MYSQL ERROR - error :Lost connection to MySQL server during query || callback: LoadRaceRecords
[15:52:28] Error Query - SELECT * FROM `RaceRecords`
__________________________________________________ _____
Reply

Quote:
Originally Posted by Player23
Посмотреть сообщение
Hey guys, I don't know what wrong im doing but im facing this problem from 2 weeks and server is off from 2 weeks too, please help me, its happen every time i start my server. This is the server log :
__________________________________________________ _____
[15:52:28]
[15:52:28] MYSQL ERROR - error :Lost connection to MySQL server during query || callback: LoadRaceRecords
[15:52:28] Error Query - SELECT * FROM `RaceRecords`
__________________________________________________ _____
Are you using mysql_errno to check to see that the connection was successful?
Reply

Yeah.
Reply

When you want to release R33? I'm very waiting this.
Reply

Quote:
Originally Posted by Player23
Посмотреть сообщение
Hey guys, I don't know what wrong im doing but im facing this problem from 2 weeks and server is off from 2 weeks too, please help me, its happen every time i start my server. This is the server log :
__________________________________________________ _____
[15:52:28]
[15:52:28] MYSQL ERROR - error :Lost connection to MySQL server during query || callback: LoadRaceRecords
[15:52:28] Error Query - SELECT * FROM `RaceRecords`
__________________________________________________ _____
What plugin and MySQL server version do you use?

Quote:
Originally Posted by kurta999
Посмотреть сообщение
When you want to release R33? I'm very waiting this.
There are still bugs and things to work on and I'll take as much time as needed. I can't say when it's ready for a release.
Reply

What is different between r7 and r31 ? Which one is better ?
Reply

r33 is better, wait for it.

SPEED, STABILITY, FUNCTIONALITY, LESS CRASHES, r7 has ALOT of crashes.
Reply

Help please guys

Код:
mysql_format( ConnectionHandle, Consulta , #SELECT `ID_User` FROM `Usuarios` WHERE `Nombre` = '%s' LIMIT 1, GetPName( playerid ) );

mysql_format( ConnectionHandle, Consulta, "UPDATE `Usuarios` SET Password='%s', PosX=%.4f, PosY=%.4f, PosZ=%.4f, Ang=%.4f, Vida=%.2f, Chaleco=%.2f WHERE `Nombre` = '%s' AND `ID_User` = '%i';", Informacion[ playerid ][ _Password ], Informacion[ playerid ][ _Pos ][ 0 ],
Informacion[ playerid ][ _Pos ][ 1 ], Informacion[ playerid ][ _Pos ][ 2 ], Informacion[ playerid ][ _Pos ][ 3 ], Informacion[ playerid ][ _Vida ], Informacion[ playerid ][ _Chaleco ], GetPName( playerid ), Informacion[ playerid ][ _pSQLID ] );
Error is

Код:
error 035: argument type mismatch (argument 3)
Reply

Quote:
Originally Posted by BigGroter
Посмотреть сообщение
Okay so.. It's connecting now.
Код:
DEBUG: MySQL has successfuly established a connection with localhost.
However, nothing is really happening while IG. You stare at the ocean but you can still submit commands, so the server isn't dieing, it's just MySQL processing just about nothing, I guess.
MySQL log:
Код:
[01:06:17] [DEBUG] mysql_connect - -
[01:06:17] [DEBUG] CMySQLHandle::Create - creating new connection..
[01:06:17] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[01:06:17] [DEBUG] CMySQLHandle::Create - connection created with ID = 1
[01:06:17] [DEBUG] CMySQLHandle::Connect - connection was successful
[01:06:17] [DEBUG] CMySQLHandle::Connect - auto-reconnect has been enabled
[01:06:17] [DEBUG] mysql_tquery - connection handle: 1
[01:06:17] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Spraypoints`"..
[01:06:17] [DEBUG] mysql_errno - connection handle: 1
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_Test()] - starting query execution
[01:06:17] [DEBUG] mysql_errno - connection handle: 1
[01:06:17] [DEBUG] mysql_tquery - connection handle: 1
[01:06:17] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Factions`"..
[01:06:17] [DEBUG] mysql_tquery - connection handle: 1
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadFactions()] - starting query execution
[01:06:17] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Spraypoints`"..
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadSpraypoints()] - starting query execution
[01:06:17] [DEBUG] mysql_tquery - connection handle: 1
[01:06:17] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Teleports`"..
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadTeleports()] - starting query execution
[01:06:17] [DEBUG] mysql_tquery - connection handle: 1
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_Test()] - query was successful
[01:06:17] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Houses`"..
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadHouses()] - starting query execution
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_Test()] - data being passed to ProcessCallbacks()
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadFactions()] - query was successful
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadFactions()] - data being passed to ProcessCallbacks()
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadTeleports()] - query was successful
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadTeleports()] - data being passed to ProcessCallbacks()
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadHouses()] - query was successful
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadHouses()] - data being passed to ProcessCallbacks()
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadSpraypoints()] - query was successful
[01:06:17] [DEBUG] CMySQLQuery::Execute[thread_LoadSpraypoints()] - data being passed to ProcessCallbacks()
[01:07:04] [DEBUG] mysql_escape_string - connection handle: 1
[01:07:04] [DEBUG] mysql_tquery - connection handle: 1
[01:07:04] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Accounts` WHERE `Username` = 'Test_Test'"..
[01:07:04] [DEBUG] CMySQLQuery::Execute[thread_LoadAccount(d)] - starting query execution
[01:07:04] [DEBUG] CMySQLQuery::Execute[thread_LoadAccount(d)] - query was successful
[01:07:04] [DEBUG] CMySQLQuery::Execute[thread_LoadAccount(d)] - data being passed to ProcessCallbacks()
Help me, please, lol.
Reply

On my server r31 is using 6 threads. r26 is using 8 threads.
r31 is way slower than r26. after I restart my server and 200-300 players are connecting to the server at the same time, the server starts lagging for 2-3 minutes when using r31. with r26 there is no lagging.

Also, this code crashes the server on linux, r26:
Код:
callback|

	new row, rows, fields;

	if(cache_mailbox[playerid])
	{
		cache_set_active(cache_mailbox[playerid]);
		cache_get_data(rows, fields);
	}
	else
	{
		cache_get_data(rows, fields);
		cache_mailbox[playerid] = cache_save();
	}


	if(!rows)
	{
		SendClientMessage(playerid, COLOR_WHITE, "No emails!");
		cache_delete(cache_mailbox[playerid]);
		cache_mailbox[playerid] = 0;
		return 1;
	}
there is where the crash happens.
on windows using r26 there are no crashes.

Here are some logs:
Код:
[Fri Aug 9 17:20:41 EEST 2013] SERVICE STARTUP

Started server on 123.123.123.123:7777, with maxplayers: 500 lanmode is OFF.

*** glibc detected *** /home/my_server/123.123.123.123-7777/samp03svr: double free or corruption (fasttop): 0x08b37a70 ***
======= Backtrace: =========
/lib32/libc.so.6(+0x6efe1)[0xf7513fe1]
/lib32/libc.so.6(+0x70868)[0xf7515868]
/lib32/libc.so.6(cfree+0x6d)[0xf751894d]
/usr/lib32/libstdc++.so.6(_ZdlPv+0x21)[0xf7705a91]
plugins/mysql_r26_static.so(_ZN12CMySQLResultD1Ev+0x126)[0xf71ad426]
plugins/mysql_r26_static.so(_ZN9CCallback16ProcessCallbacksEv+0x7b4)[0xf719fa94]
plugins/mysql_r26_static.so(ProcessTick+0x17)[0xf71b7a37]
/home/my_server/123.123.123.123-7777/samp03svr[0x80c5a32]
/home/my_server/123.123.123.123-7777/samp03svr[0x80b57fc]
/home/my_server/123.123.123.123-7777/samp03svr[0x80b10a3]
/lib32/libc.so.6(__libc_start_main+0xe6)[0xf74bbbd6]
/home/my_server/123.123.123.123-7777/samp03svr[0x804b521]
======= Memory map: ========
08048000-08094000 r-xp 00000000 08:02 11143835 /home/my_server/123.123.123.123-7777/samp03svr
08094000-08098000 rwxp 0004c000 08:02 11143835 /home/my_server/123.123.123.123-7777/samp03svr
08098000-08168000 r-xp 00050000 08:02 11143835 /home/my_server/123.123.123.123-7777/samp03svr
08168000-0818a000 rw-p 0011f000 08:02 11143835 /home/my_server/123.123.123.123-7777/samp03svr
0818a000-08195000 rw-p 00000000 00:00 0 
08a11000-0a4b1000 rw-p 00000000 00:00 0 [heap]
ef14a000-ef8ec000 rw-p 00000000 00:00 0 
ef8ec000-ef8f0000 r-xp 00000000 08:02 27656198 /lib32/libnss_dns-2.11.1.so
ef8f0000-ef8f1000 r--p 00004000 08:02 27656198 /lib32/libnss_dns-2.11.1.so
ef8f1000-ef8f2000 rw-p 00005000 08:02 27656198 /lib32/libnss_dns-2.11.1.so
ef901000-ef902000 ---p 00000000 00:00 0 
ef902000-f172e000 rw-p 00000000 00:00 0 
f172f000-f1c04000 rw-p 00000000 00:00 0 
f1c04000-f1c05000 ---p 00000000 00:00 0 
f1c05000-f2680000 rw-p 00000000 00:00 0 
f2680000-f26cb000 r-xp 00000000 08:02 11146368 /home/my_server/123.123.123.123-7777/plugins/crashdetect.so
f26cb000-f26cd000 rw-p 0004a000 08:02 11146368 /home/my_server/123.123.123.123-7777/plugins/crashdetect.so
f26cd000-f2759000 r-xp 00000000 08:02 11159059 /home/my_server/123.123.123.123-7777/plugins/streamer.so
f2759000-f275a000 rw-p 0008c000 08:02 11159059 /home/my_server/123.123.123.123-7777/plugins/streamer.so
f275a000-f27f8000 rw-p 00000000 00:00 0 
f27f8000-f27f9000 ---p 00000000 00:00 0 
f27f9000-f2ff9000 rw-p 00000000 00:00 0 
f2ff9000-f2ffa000 ---p 00000000 00:00 0 
f2ffa000-f37fa000 rw-p 00000000 00:00 0 
f37fa000-f37fb000 ---p 00000000 00:00 0 
f37fb000-f3ffb000 rw-p 00000000 00:00 0 
f3ffb000-f3ffc000 ---p 00000000 00:00 0 
f3ffc000-f47fc000 rw-p 00000000 00:00 0 
f47fc000-f47fd000 ---p 00000000 00:00 0 
f47fd000-f4ffd000 rw-p 00000000 00:00 0 
f4ffd000-f4ffe000 ---p 00000000 00:00 0 
f4ffe000-f57fe000 rw-p 00000000 00:00 0 
f57fe000-f57ff000 ---p 00000000 00:00 0 
f57ff000-f5fff000 rw-p 00000000 00:00 0 
f5fff000-f6000000 ---p 00000000 00:00 0 
f6000000-f6800000 rw-p 00000000 00:00 0 
f6800000-f6881000 rw-p 00000000 00:00 0 
f6881000-f6900000 ---p 00000000 00:00 0 
f6900000-f6910000 r-xp 00000000 08:02 27656203 /lib32/libresolv-2.11.1.so
f6910000-f6911000 r--p 00010000 08:02 27656203 /lib32/libresolv-2.11.1.so
f6911000-f6912000 rw-p 00011000 08:02 27656203 /lib32/libresolv-2.11.1.so
f6912000-f6914000 rw-p 00000000 00:00 0 
f6914000-f6917000 r-xp 00000000 08:02 11150403 /home/my_server/123.123.123.123-7777/plugins/mapandreas.so
f6917000-f6918000 r--p 00002000 08:02 11150403 /home/my_server/123.123.123.123-7777/plugins/mapandreas.so
f6918000-f6919000 rw-p 00003000 08:02 11150403 /home/my_server/123.123.123.123-7777/plugins/mapandreas.so
f6919000-f6922000 r-xp 00000000 08:02 11146378 /home/my_server/123.123.123.123-7777/plugins/wp.so
f6922000-f6923000 rw-p 00008000 08:02 11146378 /home/my_server/123.123.123.123-7777/plugins/wp.so
f6923000-f692d000 r-xp 00000000 08:02 27656213 /lib32/libnss_files-2.11.1.so
f692d000-f692e000 r--p 00009000 08:02 27656213 /lib32/libnss_files-2.11.1.so
f692e000-f692f000 rw-p 0000a000 08:02 27656213 /lib32/libnss_files-2.11.1.so
f6930000-f693d000 r-xp 00000000 08:02 11159319 /home/my_server/123.123.123.123-7777/plugins/sscanf.so
f693d000-f693e000 rw-p 0000c000 08:02 11159319 /home/my_server/123.123.123.123-7777/plugins/sscanf.so
f693e000-f693f000 ---p 00000000 00:00 0 
f693f000-f713f000 rw-p 00000000 00:00 0 
f713f000-f724e000 r-xp 00000000 08:02 11152309 /home/my_server/123.123.123.123-7777/plugins/mysql_r26_static.so
f724e000-f7368000 rw-p 0010e000 08:02 11152309 /home/my_server/123.123.123.123-7777/plugins/mysql_r26_static.so
f7368000-f74a5000 rw-p 00000000 00:00 0 
f74a5000-f75fe000 r-xp 00000000 08:02 27656214 /lib32/libc-2.11.1.so
f75fe000-f75ff000 ---p 00159000 08:02 27656214 /lib32/libc-2.11.1.so
f75ff000-f7601000 r--p 00159000 08:02 27656214 /lib32/libc-2.11.1.so
f7601000-f7602000 rw-p 0015b000 08:02 27656214 /lib32/libc-2.11.1.so
f7602000-f7605000 rw-p 00000000 00:00 0 
f7605000-f7622000 r-xp 00000000 08:02 18356394 /usr/lib32/libgcc_s.so.1
f7622000-f7623000 r--p 0001c000 08:02 18356394 /usr/lib32/libgcc_s.so.1
f7623000-f7624000 rw-p 0001d000 08:02 18356394 /usr/lib32/libgcc_s.so.1
f7624000-f7648000 r-xp 00000000 08:02 27656197 /lib32/libm-2.11.1.so
f7648000-f7649000 r--p 00023000 08:02 27656197 /lib32/libm-2.11.1.so
f7649000-f764a000 rw-p 00024000 08:02 27656197 /lib32/libm-2.11.1.so
f764a000-f7733000 r-xp 00000000 08:02 18356402 /usr/lib32/libstdc++.so.6.0.13
f7733000-f7737000 r--p 000e9000 08:02 18356402 /usr/lib32/libstdc++.so.6.0.13
f7737000-f7738000 rw-p 000ed000 08:02 18356402 /usr/lib32/libstdc++.so.6.0.13
f7738000-f7740000 rw-p 00000000 00:00 0 
f7740000-f7755000 r-xp 00000000 08:02 27656208 /lib32/libpthread-2.11.1.so
f7755000-f7756000 r--p 00014000 08:02 27656208 /lib32/libpthread-2.11.1.soAborted
[Fri Aug 9 17:21:28 EEST 2013] SERVICE CRASH, waiting 10 seconds
[Fri Aug 9 17:21:38 EEST 2013] SERVICE STARTUP

Started server on 123.123.123.123:7777, with maxplayers: 500 lanmode is OFF.
Reply

Quote:
Originally Posted by im
Посмотреть сообщение
On my server r31 is using 6 threads. r26 is using 8 threads.
r31 is way slower than r26. after I restart my server and 200-300 players are connecting to the server at the same time, the server starts lagging for 2-3 minutes when using r31. with r26 there is no lagging.
Yes, I'm already aware of this and it should be faster now in R33.

Quote:
Originally Posted by im
Посмотреть сообщение
Also, this code crashes the server on linux, r26:
Код:
callback|

	new row, rows, fields;

	if(cache_mailbox[playerid])
	{
		cache_set_active(cache_mailbox[playerid]);
		cache_get_data(rows, fields);
	}
	else
	{
		cache_get_data(rows, fields);
		cache_mailbox[playerid] = cache_save();
	}


	if(!rows)
	{
		SendClientMessage(playerid, COLOR_WHITE, "No emails!");
		cache_delete(cache_mailbox[playerid]);
		cache_mailbox[playerid] = 0;
		return 1;
	}
there is where the crash happens.
on windows using r26 there are no crashes.

Here are some logs:
Код:
[...]
Quote:
Originally Posted by R28 changelog
- fixed bug where saving and deleting the active result in the same callback
would crash the server
Try R28 and see if it still crashes.
Reply

I used R31 and there were no crashes, but it was slower than R26.
R30 should be just as fast as R26, right? Since it can use more than 6 threads.
Reply

No, actually not. The overall code just slowed down with the time.
Reply

I'm getting an error. Tried loads of things and nothing worked so far.

Код:
[17:26:30] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:26:30] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #2006) MySQL server has gone away
[17:26:30] [WARNING] CMySQLQuery::Execute[SendQuery()] - lost connection, reconnecting..
Anybody knows how to fix this?
Reply

Use "127.0.0.1" instead of "localhost".
Reply

Quote:
Originally Posted by Pain123
Посмотреть сообщение
Use "127.0.0.1" instead of "localhost".
Same error.
Reply

Quote:
Originally Posted by Pain123
Посмотреть сообщение
Use "127.0.0.1" instead of "localhost".
When we can expect the R32?
Reply

Quote:
Originally Posted by B-Matt
Посмотреть сообщение
When we can expect the R32?
R33* ... I think maximum one week, depends what is in Pain123's head.
Reply


Forum Jump:


Users browsing this thread: 9 Guest(s)