1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
Need help..
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#1

27.07.2015, 16:12
Hi, ehmm I need help, when i turn on my server , it goes on , loads things from the mysql database and then goes offline..
Could someone help me please?

SERVER LOG:
Код:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[18:09:26] mapname = "San Andreas"  (string)
[18:09:26] language = ""  (string)
[18:09:26] 
[18:09:26] Server Plugins
[18:09:26] --------------
[18:09:26]  Loading plugin: streamer.so
[18:09:26] 

*** Streamer Plugin v2.7.7 by Incognito loaded ***

[18:09:26]   Loaded.
[18:09:26]  Loading plugin: sscanf.so
[18:09:26] 

[18:09:26]  ===============================

[18:09:26]       sscanf plugin loaded.     

[18:09:26]          Version:  2.8.1        

[18:09:26]    © 2012 Alex "******" Cole  

[18:09:26]  ===============================

[18:09:26]   Loaded.
[18:09:26]  Loading plugin: mysql.so
[18:09:26]  >> plugin.mysql: R33 successfully loaded.
[18:09:26]   Loaded.
[18:09:26]  Loading plugin: whirlpool.so
[18:09:26]  
[18:09:26]  ==================
[18:09:26]  
[18:09:26]   Whirlpool loaded
[18:09:26]  
[18:09:26]  ==================
[18:09:26]  
[18:09:26]   Loaded.
[18:09:26]  Loaded 4 plugins.

[18:09:26] 
[18:09:26] Filterscripts
[18:09:26] ---------------
[18:09:26]   Loaded 0 filterscripts.

[18:09:26]  
[18:09:26]  ======================================= 
[18:09:26]  |                                     | 
[18:09:26]  |        YSI version 3.01.0002        | 
[18:09:26]  |        By Alex "******" Cole        | 
[18:09:26]  |                                     | 
[18:09:26]  ======================================= 
[18:09:26]  
[18:09:26] Preparing the gamemode, please wait...
[18:09:26] [MySQL] (Main Pipelines) Connecting to localhost...
[18:09:26] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server!
[18:09:26] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[18:09:26] [LoadCrates] Load Query Sent
[18:09:26] [LoadHouses] Loading data from database...
[18:09:26] [LoadDynamicDoors] Loading data from database...
[18:09:26] [LoadDynamicMapIcons] Loading data from database...
[18:09:26] [LoadMailboxes] Loading data from database...
[18:09:26] [LoadBusinesses] Loading data from database...
[18:09:26] [LoadAuctions] Loading data from database...
[18:09:26] [LoadTxtLabels] Loading data from database...
[18:09:26] [LoadPlants] Loading data from database...
[18:09:26] [SpeedCameras] Loading data from database...
[18:09:26] [LoadPayNSprays] Loading data from database...
[18:09:26] [LoadArrestPoints] Loading data from database...
[18:09:26] [LoadImpoundPoints] Loading data from database...
[18:09:26] [LoadRelayForLifeTeams] Loading data from database...
[18:09:26] [LoadBusinessSales] Loading data from database...
[18:09:26] [LoadTurfWars] 65 turfs loaded.
[18:09:26] [LoadPaintballArenas] 10 paintball arenas loaded.
[18:09:26] [LoadEventPoints] 0 event points loaded.
[18:09:26] [LoadGates] Loading data from database...
[18:09:26] [LoadElevatorStuff] 20 floors loaded.
[18:09:26] [LoadFamilies] Loading data from database...
[18:09:26] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[18:09:26] [MiscLoad] Misc Loaded
[18:09:26] Resetting news...
[18:09:26] Resetting default server variables..
[18:09:26] Adjusted the server time...
[18:09:26] [Streamer] Loading Dynamic Static Vehicles...
[18:09:26] [Streamer] Dynamic Static Vehicles has been loaded.
[18:09:26] [Streamer] Loading Dynamic Pickups...
[18:09:26] [Streamer] Dynamic Pickups has been loaded.
[18:09:26] [Streamer] Loading 3D Text Labels...
[18:09:26] [Streamer] Dynamic 3D Text Labels has been loaded.
[18:09:26] [Streamer] Loading Dynamic Buttons...
[18:09:26] [Streamer] Dynamic Buttons has been loaded.
[18:09:26] [Streamer] Loading Dynamic Objects...
[18:09:26] [Streamer] Dynamic Objects has been loaded.
[18:09:26] [Textdraws] Loading Textdraws...
[18:09:26] [Textdraws] Loaded textdraws.
[18:09:26] [Dynamic Groups] Loading Dynamic Groups...
[18:09:26] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[18:09:26] 
-------------------------------------------
[18:09:26] Empire Gaming Roleplay

[18:09:26] Copyright © Empire Gaming, LLC (2015-....)
[18:09:26] All Rights Reserved
[18:09:26] -------------------------------------------

[18:09:26] Successfully initiated the gamemode...
[18:09:26] Number of vehicle models: 29
[18:09:26]  
[18:09:26]  ========================================== 
[18:09:26]  |                                        | 
[18:09:26]  |  A new version (v3.09.0684) of YSI is  | 
[18:09:26]  |            available from:             | 
[18:09:26]  |                                        | 
[18:09:26]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[18:09:26]  |                                        | 
[18:09:26]  | Changelog:                             | 
[18:09:26]  |                                        | 
[18:09:26]  |   3.09.0684:                           | 
[18:09:26]  |                                        | 
[18:09:26]  |   Reverted to old download location.   | 
[18:09:26]  | Improved (and fixed) version checks;   | 
[18:09:26]  | added y_bitmap, y_areas, y_races,      | 
[18:09:26]  | y_zonenames, better documentation;     | 
[18:09:26]  | MANY other bug fixes - see the github  | 
[18:09:26]  | repository for more details:           | 
[18:09:26]  |                                        | 
[18:09:26]  ========================================== 
[18:09:26]  
[18:09:26] [Dynamic Giftbox] Successfully loaded the dynamic giftbox.
[18:09:26] [LoadCrates] Loading Crates Finished
[18:09:34] [LoadHouses] 5000 houses rehashed/loaded.
[18:09:38] [LoadDynamicDoors] 3000 doors rehashed/loaded.
[18:09:38] [LoadDynamicMapIcons] 400 map icons rehashed/loaded.
[18:09:38] [LoadMailboxes] 50 mailboxes rehashed/loaded.
[18:09:38] [LoadBusinesses] 200 businesses rehashed/loaded.
[18:09:39] [LoadPlants] Successfully loaded 300 plants
[18:09:39] [SpeedCameras] Loaded 15 Speed Cameras.
[18:09:39] [LoadRelayForLifeTeams] 200 teams loaded.
[18:09:39] TotalSold0: 0 | AmountMade0: 0
[18:09:39] TotalSold1: 0 | AmountMade1: 0
[18:09:39] TotalSold2: 0 | AmountMade2: 0
[18:09:39] TotalSold3: 0 | AmountMade3: 0
[18:09:39] TotalSold4: 0 | AmountMade4: 0
[18:09:39] TotalSold5: 0 | AmountMade5: 0
[18:09:39] TotalSold6: 0 | AmountMade6: 0
[18:09:39] TotalSold7: 0 | AmountMade7: 0
[18:09:39] TotalSold8: 0 | AmountMade8: 0
[18:09:39] TotalSold9: 0 | AmountMade9: 0
[18:09:39] TotalSold10: 0 | AmountMade10: 0
[18:09:39] TotalSold11: 0 | AmountMade11: 0
[18:09:39] TotalSold12: 0 | AmountMade12: 0
[18:09:39] TotalSold13: 0 | AmountMade13: 0
[18:09:39] TotalSold14: 0 | AmountMade14: 0
[18:09:39] TotalSold15: 0 | AmountMade15: 0
[18:09:39] TotalSold16: 0 | AmountMade16: 0
[18:09:39] TotalSold17: 0 | AmountMade17: 0
[18:09:39] TotalSold18: 0 | AmountMade18: 0
[18:09:39] TotalSold19: 0 | AmountMade19: 0
[18:09:39] TotalSold20: 0 | AmountMade20: 0
[18:09:39] TotalSold21: 0 | AmountMade21: 0
[18:09:39] TotalSold22: 0 | AmountMade22: 0
[18:09:39] TotalSold23: 0 | AmountMade23: 0
[18:09:39] TotalSold24: 0 | AmountMade24: 0
[18:09:39] TotalSold25: 0 | AmountMade25: 0
[18:09:39] TotalSold26: 0 | AmountMade26: 0
[18:09:39] TotalSold27: 0 | AmountMade27: 0
[18:09:39] TotalSold28: 0 | AmountMade28: 0
[18:09:39] TotalSold29: 0 | AmountMade29: 0
[18:09:39] Price0: 1000
[18:09:39] Price1: 199
[18:09:39] Price2: 180
[18:09:39] Price3: 80
[18:09:39] Price4: 100
[18:09:39] Price5: 100
[18:09:39] Price6: 250
[18:09:39] Price7: 90
[18:09:39] Price8: 25
[18:09:39] Price9: 80
[18:09:39] Price10: 25
[18:09:39] Price11: 150
[18:09:39] Price12: 200
[18:09:39] Price13: 300
[18:09:39] Price14: 299
[18:09:39] Price15: 100
[18:09:39] Price16: 60
[18:09:39] Price17: 1
[18:09:39] Price18: 1
[18:09:39] Price19: 2
[18:09:39] Price20: 11
[18:09:39] Price21: 10000
[18:09:39] Price22: 50
[18:09:39] Price23: 149
[18:09:39] Price24: 2
[18:09:39] Price25: 300
[18:09:39] Price26: 400
[18:09:39] Price27: 500
[18:09:39] Price28: 100
[18:09:39] Price29: 29
[18:09:43] [Family Points] 8 family points has been loaded.
Find
Reply
youssefehab500
Huge Clucker
***
Posts: 218
Threads: 23
Joined: Feb 2014
Reputation: 0
#2

27.07.2015, 16:57
Try using crashdetect and show us the logs.
Find
Reply
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#3

27.07.2015, 17:09
Ehmm, Here it is:

I really dont know what to do with this XD

Код:
[19:09:32] [debug] Server crashed while executing EMPRP.amx
[19:09:32] [debug] AMX backtrace:
[19:09:32] [debug] #0 native fclose () from samp7878_5402
[19:09:32] [debug] #1 000db8c0 in ?? (24693748, 45956156) from EMPRP.amx
[19:09:32] [debug] #2 000aa654 in ?? (0) from EMPRP.amx
[19:09:32] [debug] #3 003dd014 in public DynVeh_QueryFinish (1, 0) from EMPRP.amx
[19:09:32] [debug] Native backtrace:
[19:09:32] [debug] #0 b63efe8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[19:09:32] [debug] #1 b63e8bcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[19:09:32] [debug] #2 b63e9dbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[19:09:32] [debug] #3 b63ea226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[19:09:32] [debug] #4 b63efadc in ?? () from plugins/crashdetect.so
[19:09:32] [debug] #5 b773b600 in ?? ()
[19:09:32] [debug] #6 b74be387 in gsignal () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #7 b74c1772 in abort () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #8 b74f972d in ?? () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #9 b750382a in ?? () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #10 b7505088 in ?? () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #11 b750820d in cfree () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #12 b74f3cda in fclose () from /lib/i386-linux-gnu/libc.so.6
[19:09:32] [debug] #13 0809bd64 in ?? () from ./samp7878_5402
[19:09:32] [debug] #14 080950e4 in ?? () from ./samp7878_5402
[19:09:32] [debug] #15 b63eb94b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[19:09:32] [debug] #16 b63ee8f8 in ?? () from plugins/crashdetect.so
[19:09:32] [debug] #17 b63f2916 in amx_Exec () from plugins/crashdetect.so
[19:09:32] [debug] #18 b63eabe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[19:09:32] [debug] #19 b63ee659 in ?? () from plugins/crashdetect.so
[19:09:32] [debug] #20 b633c27c in ?? () from plugins/streamer.so
[19:09:32] [debug] #21 b73bce31 in amx_Exec () from plugins/mysql.so
Find
Reply
n0minal
High-roller
*****
Posts: 4,049
Threads: 85
Joined: Mar 2013
Reputation: 0
#4

27.07.2015, 17:33
Quote:

#3 003dd014 in public DynVeh_QueryFinish (1, 0) from EMPRP.amx
Post the source code of this callback, please post also your mysql_log and the function which calls this callback...
Find
Reply
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#5

27.07.2015, 17:39
Function:
Код:
forward DynVeh_QueryFinish(iType, iExtraID);
public DynVeh_QueryFinish(iType, iExtraID) {

	new
		iFields,
		iRows,
		iIndex,
		i = 0,
		sqlid,
		szResult[128];

	cache_get_data(iRows, iFields, MainPipeline);
	switch(iType) {
		case GV_QUERY_LOAD:
		{
		    format(szResult, sizeof(szResult), "UPDATE `groupvehs` SET `SpawnedID` = %d", INVALID_VEHICLE_ID);
			mysql_function_query(MainPipeline, szResult, false, "OnQueryFinish", "i", SENDDATA_THREAD);
			while((iIndex < iRows) && (iIndex < MAX_DYNAMIC_VEHICLES)) {
			    cache_get_field_content(iIndex, "id", szResult, MainPipeline); sqlid = strval(szResult);
				if((sqlid >= MAX_DYNAMIC_VEHICLES)) {// Array bounds check. Use it.
					format(szResult, sizeof(szResult), "DELETE FROM `groupvehs` WHERE `id` = %d", sqlid);
					mysql_function_query(MainPipeline, szResult, false, "OnQueryFinish", "i", SENDDATA_THREAD);
					return printf("SQL ID %d exceeds Max Dynamic Vehicles", sqlid);
				}
				cache_get_field_content(iIndex, "gID", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_igID] = strval(szResult);
				cache_get_field_content(iIndex, "gDivID", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_igDivID] = strval(szResult);
				cache_get_field_content(iIndex, "fID", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_ifID] = strval(szResult);
				cache_get_field_content(iIndex, "rID", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_irID] = strval(szResult);
				cache_get_field_content(iIndex, "vModel", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iModel] = strval(szResult);
                switch(DynVehicleInfo[sqlid][gv_iModel]) {
					case 538, 537, 449, 590, 569, 570: {
					    DynVehicleInfo[sqlid][gv_iModel] = 0;
					}
				}
				cache_get_field_content(iIndex, "vPlate", DynVehicleInfo[sqlid][gv_iPlate], MainPipeline, 32);
				cache_get_field_content(iIndex, "vMaxHealth", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fMaxHealth] = floatstr(szResult);
				cache_get_field_content(iIndex, "vType", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iType] = strval(szResult);
				cache_get_field_content(iIndex, "vLoadMax", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iLoadMax] = strval(szResult);
				if(DynVehicleInfo[sqlid][gv_iLoadMax] > 6) {
                    DynVehicleInfo[sqlid][gv_iLoadMax] = 6;
				}
				cache_get_field_content(iIndex, "vCol1", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iCol1] = strval(szResult);
				cache_get_field_content(iIndex, "vCol2", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iCol2] = strval(szResult);
				cache_get_field_content(iIndex, "vX", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fX] = floatstr(szResult);
				cache_get_field_content(iIndex, "vY", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fY] = floatstr(szResult);
				cache_get_field_content(iIndex, "vZ", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fZ] = floatstr(szResult);
				cache_get_field_content(iIndex, "vVW", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iVW] = strval(szResult);
				cache_get_field_content(iIndex, "vInt", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iInt] = strval(szResult);
				cache_get_field_content(iIndex, "vDisabled", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iDisabled] = strval(szResult);
				cache_get_field_content(iIndex, "vRotZ", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fRotZ] = floatstr(szResult);
				cache_get_field_content(iIndex, "vUpkeep", szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iUpkeep] = strval(szResult);
				i = 1;
				while(i <= MAX_DV_OBJECTS) {
					format(szResult, sizeof szResult, "vAttachedObjectModel%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iAttachedObjectModel][i-1] = strval(szResult);
					format(szResult, sizeof szResult, "vObjectX%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectX][i-1] = floatstr(szResult);
					format(szResult, sizeof szResult, "vObjectY%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectY][i-1] = floatstr(szResult);
					format(szResult, sizeof szResult, "vObjectZ%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectZ][i-1] = floatstr(szResult);
					format(szResult, sizeof szResult, "vObjectRX%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectRX][i-1] = floatstr(szResult);
					format(szResult, sizeof szResult, "vObjectRY%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectRY][i-1] = floatstr(szResult);
					format(szResult, sizeof szResult, "vObjectRZ%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_fObjectRZ][i-1] = floatstr(szResult);
					i++;
				}
				i = 0;
				while(i < MAX_DV_MODS) {
					format(szResult, sizeof szResult, "vMod%i", i);
					cache_get_field_content(iIndex, szResult, szResult, MainPipeline); DynVehicleInfo[sqlid][gv_iMod][i++] = strval(szResult);
				}
				
				if(400 < DynVehicleInfo[sqlid][gv_iModel] < 612) {
					if(!IsWeaponizedVehicle(DynVehicleInfo[sqlid][gv_iModel])) {
						DynVeh_Spawn(iIndex);
						//printf("[DynVeh] Loaded Dynamic Vehicle %i.", iIndex);
						for(i = 0; i != MAX_DV_OBJECTS; i++)
						{
							if(DynVehicleInfo[sqlid][gv_iAttachedObjectModel][i] == 0 || DynVehicleInfo[sqlid][gv_iAttachedObjectModel][i] == INVALID_OBJECT_ID) {
								DynVehicleInfo[sqlid][gv_iAttachedObjectID][i] = INVALID_OBJECT_ID;
								DynVehicleInfo[sqlid][gv_iAttachedObjectModel][i] = INVALID_OBJECT_ID;
							}
						}
					} else {
						DynVehicleInfo[sqlid][gv_iSpawnedID] = INVALID_VEHICLE_ID;
					}	
				}
				iIndex++;
			}
		}
	}
	return 1;
}
MySQL Log: It is very and very long.. can't post it on the samp forums nor pastebin.. Wanted to post on mediafire till I saw that it was 92MB..
Find
Reply
GGRoleplay
Huge Clucker
***
Posts: 210
Threads: 11
Joined: Oct 2012
Reputation: 0
#6

27.07.2015, 17:52
Delete the mysql log, and then re-run the server then it should be significantly less or try uploading it to mega.co.nz or ****** drive
Find
Reply
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#7

27.07.2015, 18:15
Busy uploading it on mega.co.nz:
Find
Reply
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#8

27.07.2015, 18:19
https://mega.co.nz/#!JB4SUIaJ!OEF2qC...kSK4MZOhHP4MB0
Find
Reply
n0minal
High-roller
*****
Posts: 4,049
Threads: 85
Joined: Mar 2013
Reputation: 0
#9

27.07.2015, 18:39
Quote:

"UPDATE `groupvehs` SET `SpawnedID` = %d"
Why don't you specify an identifier for groupvehs? Do you have only a row in this table?
Find
Reply
mrkemal70
Big Clucker
***
Posts: 68
Threads: 8
Joined: Jan 2014
Reputation: 0
#10

27.07.2015, 18:54
I dont know what you mean, sorry for my bad english though.. How can i specify a identifier for groupvehs..
Here's a screenshot of the database.. and of groupvehs..
DATABASE:

GROUPVEHS:
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support