Some python error

[JoeDaFlow]

Hello people, I'd like to request some help with a Python error at my gameserver.

 

Here it goes.

 

Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor18.invoke(Unknown
Source)
java.lang.RuntimeException
        at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:
227)
        at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.python.core.PyReflectedFunction.__call__(Unknown Source)
        at org.python.core.PyMethod.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyInstance.invoke(Unknown Source)
        at org.python.pycode.serializable._pyx1291673371593.buildHtml$19(__init_
_.py:343)
        at org.python.pycode.serializable._pyx1291673371593.call_function(__init
__.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.pycode.serializable._pyx1291673371593.onAdvEvent$14(__init
__.py:831)
        at org.python.pycode.serializable._pyx1291673371593.call_function(__init
__.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyMethod.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyObject._jcallexc(Unknown Source)
        at org.python.core.PyObject._jcall(Unknown Source)
        at org.python.proxies.main$Quest$425.onAdvEvent(Unknown Source)
        at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:447
)
        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQue
stEvent(L2PcInstance.java:1798)
        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.
runImpl(RequestBypassToServer.java:224)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:62)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9
97)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

AutoAnnounce: Please show us your love by voting at www.l2sephion.com
Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor18.invoke(Unknown
Source)
java.lang.RuntimeException
        at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:
227)
        at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.python.core.PyReflectedFunction.__call__(Unknown Source)
        at org.python.core.PyMethod.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyInstance.invoke(Unknown Source)
        at org.python.pycode.serializable._pyx1291673371593.buildHtml$19(__init_
_.py:343)
        at org.python.pycode.serializable._pyx1291673371593.call_function(__init
__.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.pycode.serializable._pyx1291673371593.onAdvEvent$14(__init
__.py:831)
        at org.python.pycode.serializable._pyx1291673371593.call_function(__init
__.py)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyTableCode.call(Unknown Source)
        at org.python.core.PyFunction.__call__(Unknown Source)
        at org.python.core.PyMethod.__call__(Unknown Source)
        at org.python.core.PyObject.__call__(Unknown Source)
        at org.python.core.PyObject._jcallexc(Unknown Source)
        at org.python.core.PyObject._jcall(Unknown Source)
        at org.python.proxies.main$Quest$425.onAdvEvent(Unknown Source)
        at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:447
)
        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQue
stEvent(L2PcInstance.java:1798)
        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.
runImpl(RequestBypassToServer.java:224)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:62)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9
97)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

 

Here it goes my script.

http://pastebin.com/7ntKyswe

 

Thank you fellows.

[Tryskell]

When come this error ? At GS load, or when you try to use this NPC ?

 

Basically it's a connection you forget to close. The bad thing is you have no help about failing line.

 

I would search around here, where all connections are supposed to be closed :

 

        try:
                pvps.close()
                pks.close()
                pvprs.close()
                pkrs.close()
                con.close()
        except : pass

 

I have no clue how works Python, well try to check how works others scripts which use SQL stuff.

[JoeDaFlow]

When come this error ? At GS load, or when you try to use this NPC ?

 

Basically it's a connection you forget to close. The bad thing is you have no help about failing line.

 

I would search around here, where all connections are supposed to be closed :

 

        try:
                pvps.close()
                pks.close()
                pvprs.close()
                pkrs.close()
                con.close()
        except : pass

 

I have no clue how works Python, well try to check how works others scripts which use SQL stuff.

This Error comes when you chat to NPC, Unfortunately I couldn't define when yet.

[JoeDaFlow]

Up

[Tryskell]

Unfortunately I couldn't define when yet.

Define it, your code is long and boring to read.

[JoeDaFlow]

Define it, your code is long and boring to read.

The code is, The error no.

In addition, If I could define the error, I had nothing to do here.

[JoeDaFlow]

Up.

[JoeDaFlow]

Up.

[JoeDaFlow]

 

The whole fucking Forum, Ain't noone to help me with that sh1t? Jeez.

[Tryskell]

The whole -beep-ing Forum, Ain't noone to help me with that sh1t? Jeez.

I said to you higher to do some tests to define when errors come, I'm willing to help but I won't search your damn code for yourself.

 

Your problem if you don't want help helpers.

[JoeDaFlow]

The code is, The error no.

In addition, If I could define the error, I had nothing to do here.

Is that hard to get?

[Tryskell]

I don't think you get it, test your damn links, when you got the error on logs you got a location to search. This will cut research time by 10 or more.

 

If that can help you, someone got exactly the same error, so I dunno if he used the same script or if it's Freya bug.

 

Anyway you're alone to fix it now, I don't come back on this topic.

[mogo]

The problem is in the try: block, pasted few posts back. Object 'pvps' does not have a method named 'close' so it throws an exception, and the rest of the code in try block doesn't get executed (it instantly jumps to the 'except' part, which does nothing) thus leaving the connection 'con' still open (con.close() is never executed). So it sits there open for a minute, then timeouts and prints the error :)

[JoeDaFlow]

The problem is in the try: block, pasted few posts back. Object 'pvps' does not have a method named 'close' so it throws an exception, and the rest of the code in try block doesn't get executed (it instantly jumps to the 'except' part, which does nothing) thus leaving the connection 'con' still open (con.close() is never executed). So it sits there open for a minute, then timeouts and prints the error :)

So could you please post the Fix of it?

[JoeDaFlow]

Up

[JoeDaFlow]

Up