Menu

UcanaccessSQLException: SNAPSHOT Resource temporarily unavailable

2022-04-01
2022-05-03
  • ChrisChapman

    ChrisChapman - 2022-04-01

    I am using ucanaccess 5.0.0
    I am finding that after a day or so connected, I get this error. The only way I have found to resolve this is to completely reboot my RPi4. Is there a way to reload the snapshot?

    ucanaccess_jars = [
            "/home/auto/UCanAccess-5.0.0-bin/ucanaccess-5.0.0.jar",
            "/home/auto/UCanAccess-5.0.0-bin/lib/commons-lang3-3.8.1.jar",
            "/home/auto/UCanAccess-5.0.0-bin/lib/commons-logging-1.2.jar",
            "/home/auto/UCanAccess-5.0.0-bin/lib/hsqldb-2.5.0.jar",
            "/home/auto/UCanAccess-5.0.0-bin/lib/jackcess-3.0.1.jar",
        ]
    
        classpath = ":".join(ucanaccess_jars)
    
        cnxn = jaydebeapi.connect(
            "net.ucanaccess.jdbc.UcanaccessDriver",
            f"jdbc:ucanaccess://{db_path};COLUMNORDER=DISPLAY;skipIndexes=true;inactivityTimeout=0",
            ["", ""],
            classpath
        )
    

    I would rather not boot the RPi every day if I can help it, I have tried to reload the program, close the connection and, with not a lot of success, tried to restart and clear the JVM.

    Any help would be greatly appreciated.

     
  • ChrisChapman

    ChrisChapman - 2022-05-03

    Not solved the problem, but have moved the Raspberry Pi on to an ethernet connection and not seen this problem since. Looks like it is likely to be an issue with network connectivity.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.