Raised This Month: $ Target: $400
 0% 

[SQL] Multiple SQL Plugins crash Server at mapchange.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Kia
AlliedModders Donor
Join Date: Apr 2010
Location: In a world of madness
Old 10-26-2013 , 14:43   [SQL] Multiple SQL Plugins crash Server at mapchange.
Reply With Quote #1

Hello everyone,

I'm currently running 5-6 plugins using SQL and connecting to the same server, the problem is that after the first mapchange after the server started the Server is crashing (HLDS.exe is no longer responding).
When I remove two plugins, it works.
The Crash Screen from Windows tells me that the SQL module is evolved in the crashes.
So, my question is, is there a limit of sql connections at the same time or what else could cause the crash?
__________________
Kia is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 10-26-2013 , 23:36   Re: [SQL] Multiple SQL Plugins crash Server at mapchange.
Reply With Quote #2

I Think it is the method used in connections. Or all maybe some 2~3 plugins still used save / load on some events.
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
Kia
AlliedModders Donor
Join Date: Apr 2010
Location: In a world of madness
Old 10-27-2013 , 02:12   AW: Re: [SQL] Multiple SQL Plugins crash Server at mapchange.
Reply With Quote #3

Quote:
Originally Posted by ^SmileY View Post
I Think it is the method used in connections. Or all maybe some 2~3 plugins still used save / load on some events.
All plugins are only getting data when a player connects, but the server crashes even if nobody is connected at mapchange.
__________________
Kia is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 10-27-2013 , 04:15   Re: [SQL] Multiple SQL Plugins crash Server at mapchange.
Reply With Quote #4

Any plugin have the plugin_end() function? Closing SQL Connection??
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
Kia
AlliedModders Donor
Join Date: Apr 2010
Location: In a world of madness
Old 10-27-2013 , 04:28   Re: [SQL] Multiple SQL Plugins crash Server at mapchange.
Reply With Quote #5

All of them have this :

PHP Code:
public plugin_end()
{
    if(
g_SqlConnection != Empty_Handle)
    {
        
SQL_FreeHandle(g_SqlConnection//free connection handle here
    
}

__________________
Kia is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 23:15.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode