1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development

Threaded Mode
[Plugin] [REL] MySQL Plugin (Now on github!)
Richie©
Banned
Posts: 368
Threads: 24
Joined: Feb 2012
#1,261

01.08.2013, 21:13
What is ORM System?
Find
Reply
BigGroter
Huge Clucker
****
Posts: 288
Threads: 42
Joined: Jun 2009
Reputation: 0
#1,262

03.08.2013, 13:51
Quote:
Originally Posted by Pain123
Посмотреть сообщение
Same shit, just staring at the ocean unfortunately. I can still use commands however.
Find
Reply
Player23
Big Clucker
***
Posts: 87
Threads: 20
Joined: Apr 2012
Reputation: 0
#1,263

03.08.2013, 19:58
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`
__________________________________________________ _____
Find
Reply
Faskis
Big Clucker
***
Posts: 52
Threads: 3
Joined: Oct 2009
Reputation: 0
#1,264

03.08.2013, 20:32
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?
Find
Reply
Player23
Big Clucker
***
Posts: 87
Threads: 20
Joined: Apr 2012
Reputation: 0
#1,265

03.08.2013, 20:35
Yeah.
Find
Reply
kurta999
High-roller
*****
Posts: 913
Threads: 70
Joined: Apr 2009
Reputation: 0
#1,266

04.08.2013, 14:13
When you want to release R33? I'm very waiting this.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,267

04.08.2013, 17:19
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.
Find
Reply
x96664
Gangsta
****
Posts: 591
Threads: 70
Joined: Jun 2009
Reputation: 0
#1,268

04.08.2013, 20:39
What is different between r7 and r31 ? Which one is better ?
Find
Reply
Kar
Banned
Posts: 2,938
Threads: 162
Joined: May 2010
#1,269

05.08.2013, 04:53
r33 is better, wait for it.

SPEED, STABILITY, FUNCTIONALITY, LESS CRASHES, r7 has ALOT of crashes.
Find
Reply
-[R]hysi-
Huge Clucker
****
Posts: 263
Threads: 34
Joined: Apr 2012
Reputation: 0
#1,270

05.08.2013, 06:30
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)
Find
Reply
BigGroter
Huge Clucker
****
Posts: 288
Threads: 42
Joined: Jun 2009
Reputation: 0
#1,271

05.08.2013, 11:58
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.
Find
Reply
im
Huge Clucker
***
Posts: 213
Threads: 16
Joined: Mar 2012
Reputation: 0
#1,272

09.08.2013, 14:30
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.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,273

09.08.2013, 14:51
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.
Find
Reply
im
Huge Clucker
***
Posts: 213
Threads: 16
Joined: Mar 2012
Reputation: 0
#1,274

09.08.2013, 15:57
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.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,275

09.08.2013, 17:20
No, actually not. The overall code just slowed down with the time.
Find
Reply
Cypress
Gangsta
*****
Posts: 937
Threads: 69
Joined: Dec 2009
Reputation: 0
#1,276

11.08.2013, 14:03
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?
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,277

11.08.2013, 14:38
Use "127.0.0.1" instead of "localhost".
Find
Reply
Cypress
Gangsta
*****
Posts: 937
Threads: 69
Joined: Dec 2009
Reputation: 0
#1,278

11.08.2013, 14:58
Quote:
Originally Posted by Pain123
Посмотреть сообщение
Use "127.0.0.1" instead of "localhost".
Same error.
Find
Reply
B-Matt
Big Clucker
***
Posts: 162
Threads: 5
Joined: Oct 2012
Reputation: 0
#1,279

11.08.2013, 15:00
Quote:
Originally Posted by Pain123
Посмотреть сообщение
Use "127.0.0.1" instead of "localhost".
When we can expect the R32?
Find
Reply
IstuntmanI
High-roller
*****
Posts: 1,801
Threads: 27
Joined: Mar 2009
Reputation: 0
#1,280

11.08.2013, 15:04
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.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 9 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development