Jump to content
  • 0

Some python error


Question

Posted

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.

15 answers to this question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted

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.

  • 0
Posted

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.

  • 0
Posted

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.

  • 0
Posted

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 :)

  • 0
Posted

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?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • L2 PVPTOP - HTML DESIGN    
    • Do not trust this guy, he will scam you. I have sent proof to the mods, I have posted proof on another thread and I can send proof to anyone who DMs me. Avoid this guy. So not only did he scam me out of $51 USDTthen delete his messages and blocked me (I have proof) . You can see his Facebook group is constantly changing names depending on his most current scam. If you see this message and you still decide to go forward with sending your money to him, that’s on you. I can’t stress this enough. This guy is a scammer. 
    • So Goldbar thinks that deleted his side of the conversation makes it easier to claim he didn’t scam me. But I sent him $51 USDT to his ERC-20 account it was verified, he acted like it was fine but then deleted his messages and blocked me. Seriously do not trust this guy. 
    • Hi everyone, let me introduce myself—I'm Martin, a junior developer. I'm diving into the world of L2 servers, and honestly, I'm super overwhelmed about where to start learning the right way to set up, configure, and run a server. There are so many datapacks—free, private—but it's so much that my head feels like it's going to explode. I'm currently looking for someone or an active project willing to take me on as an intern. I'm not looking to make money—I'm just here to learn and grow out of pure passion for L2. I've already been working with L2jMobius H5. I managed to edit the Community Board, add a buffer, GM Shop, and teleports. I've also created custom NPCs for the GM Shop, and imported new custom weapons and armors—complete with original glow effects, like the Valakas and Antharas weapons. But there's still a lot I don't know, and it can get overwhelming. That’s why I’m looking for someone—or an active non-profit project—willing to take me on as an intern. I’m not looking to make money; I just want to learn, contribute, and grow out of pure passion for L2. If you’re working on a project and could use a motivated learner who’s eager to help, I’d love to connect!
    • Our next easy-botting project, Kain, is right around the corner! Launching tomorrow, Saturday, April 26th at 9:00 ET (UTC -4)! If you haven’t, check out the features and join our Discord to catch up on the latest drama. See you very soon! Read more about L2Toggle and Kain on our site and forum!  
  • Topics

×
×
  • Create New...