OK. It might be something that I am doing, but if I run the Mapserver (4.5.0) and Mine

Failed to commit SQLite3 transaction: database is locked </blockquote

should work with the mapserver <a href="https://github.com/minetest-mapserver/mapserve

Mapserver cause dev Minetest to crash.,about minetest-mapserver/mapserver_mod

Comments (6)

BuckarooBanzay commented on July 16, 2024

Failed to commit SQLite3 transaction: database is locked

I heard of this problem several times already but couldn't fix it because of missing informations to reproduce that :/

Can you give me the following:

Your operating system info (windows, linux, 32bit, 64bit, ...)
Your filsystem info (vfat, ntfs, etc)
The world/map-files this happened to (a stripped-down/clean world will do to as long as the error still persists)

Thanks in advance

from mapserver_mod.

enkidu-smith commented on July 16, 2024

I run Ubuntu 21.10 (Impish Indri) (64bit). The filesystem is ext4 using LVM. I've included the world.mt below. I run the Mapserver binary (4.5.0) and Minetest compiled (5.6.0-dev-c31b301) The issue doesn't occur until I set 'load_mod_mapserver = true' in world.mt. Just to be sure, I cleared out the whole world and recreated it, and the error recurred. Thanks very much. enable_damage = true creative_mode = false mod_storage_backend = sqlite3 auth_backend = sqlite3 player_backend = sqlite3 backend = sqlite3 gameid = minetest world_name = Fifth load_mod_unified_inventory = true load_mod_sounding_line = true load_mod_ropes = true load_mod_moreores = true load_mod_moreblocks = true load_mod_mesecons_torch = true load_mod_mesecons_switch = true load_mod_mesecons_stickyblocks = true load_mod_mesecons_solarpanel = true load_mod_mesecons_pressureplates = true load_mod_mesecons_powerplant = true load_mod_pipeworks = true load_mod_mesecons_pistons = true load_mod_mesecons_alias = true load_mod_travelnet = true load_mod_mesecons_walllever = true load_mod_basic_materials = true load_mod_mesecons = true load_mod_mesecons_wires = true load_mod_signs_lib = true load_mod_mesecons_mvps = true load_mod_mesecons_movestones = true load_mod_mapserver = true load_mod_mesecons_blinkyplant = true load_mod_mesecons_commandblock = true load_mod_mesecons_lamp = true load_mod_mesecons_insulated = true load_mod_mesecons_noteblock = true load_mod_mesecons_hydroturbine = true load_mod_mesecons_receiver = true load_mod_mesecons_button = true load_mod_mesecons_detector = true load_mod_mesecons_materials = true load_mod_mesecons_doors = true load_mod_mesecons_gates = true load_mod_mesecons_extrawires = true load_mod_mesecons_random = true load_mod_mesecons_fpga = true load_mod_mesecons_delayer = true load_mod_mesecons_lightstone = true load_mod_mesecons_luacontroller = true load_mod_mesecons_microcontroller = true

…

On Wed, 23 Feb 2022 at 20:08, Buckaroo Banzai ***@***.***> wrote: Failed to commit SQLite3 transaction: database is locked I heard of this problem several times already but couldn't fix it because of missing informations to reproduce that :/ Can you give me the following: - Your operating system info (windows, linux, 32bit, 64bit, ...) - Your filsystem info (vfat, ntfs, etc) - The world/map-files this happened to (a stripped-down/clean world will do to as long as the error still persists) Thanks in advance — Reply to this email directly, view it on GitHub <#22 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABN4VRKX73CFENT5TQYE4YDU4SBWPANCNFSM5PAQUDFQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

-- My Amazon author page : https://amazon.com/author/cliffpratt My Facebook author page : https://www.facebook.com/cliffprattauthor My Search on Kobo : https://www.kobo.com/search?query=Cliff+Pratt

from mapserver_mod.

BuckarooBanzay commented on July 16, 2024

I run the Mapserver binary (4.5.0) and Minetest compiled (5.6.0-dev-c31b301)

In which stage does that happen?
There is the initial and incremental rendering stage? (mapserver logs in the console)
it is possible that the database is locked in the initial stage as it adds another mtime column, but it shouldn't do anything after that because its re-opened read-only 😕

The issue doesn't occur until I set 'load_mod_mapserver = true' in world.mt.

Uhm, this shouldn't even matter, the the mod only communicates over http and doesn't do anything to the database...

from mapserver_mod.

enkidu-smith commented on July 16, 2024

I updated minetest and recompiled, just in case it was something on their side. No change.

On Thu, 24 Feb 2022 at 23:45, Buckaroo Banzai ***@***.***> wrote: I run the Mapserver binary (4.5.0) and Minetest compiled (5.6.0-dev-c31b301) In which stage does that happen?

OK, I start minetestserver, then I start the mapserver. If I then do *nothing*, including connecting via client, everything continues to run. I can look at the map though. If I connect to the server (from my second machine) minetestserver eventually crashes, even if I don't do anything.

There is the initial and incremental rendering stage? (mapserver logs in the console) it *is* possible that the database is locked in the initial stage as it adds another mtime column, but it shouldn't do anything after that because its re-opened read-only 😕 The issue doesn't occur until I set 'load_mod_mapserver = true' in world.mt. Uhm, this shouldn't even matter, the the mod only communicates over http and doesn't do anything to the database... OK, understood. Here is the first part of the output from the mapserver.

it continues like this. ***@***.***:~/.minetest/worlds/Fifth$ ./mapserver -debug INFO[0000] Starting mapserver version=4.5.0 INFO[0000] Loading colors filename=colors/vanessa.txt prefix=colormapping size=1335774 INFO[0000] Loading colors filename=colors/advtrains.txt prefix=colormapping size=497 INFO[0000] Loading colors filename=colors/scifi_nodes.txt prefix=colormapping size=1315 INFO[0000] Loading colors filename=colors/mc2.txt prefix=colormapping size=69267 INFO[0000] Loading colors filename=colors/mtg.txt prefix=colormapping size=14912 INFO[0000] Loading colors filename=colors/miles.txt prefix=colormapping size=1289240 INFO[0000] Loading colors filename=colors/custom.txt prefix=colormapping size=853 INFO[0000] Migrating database filename=mapserver.sqlite prefix=mapobjectdb.sqlite INFO[0000] Migration completed elapsed=1.199624ms prefix=mapobjectdb.sqlite INFO[0000] Starting http server port=8080 webdev=false INFO[0000] using embed mode prefix=mapobjectdb INFO[0000] Starting incremental rendering job LastMtime=1645742929 DEBU[0000] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0005] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0010] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0015] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0020] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0025] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0030] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0035] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0040] FindMapBlocksByMtime lastmtime=1645742929 limit=10000

…

— Reply to this email directly, view it on GitHub <#22 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABN4VRJNAPVLKABUPX56WETU4YD5XANCNFSM5PAQUDFQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

-- My Amazon author page : https://amazon.com/author/cliffpratt My Facebook author page : https://www.facebook.com/cliffprattauthor My Search on Kobo : https://www.kobo.com/search?query=Cliff+Pratt

from mapserver_mod.

enkidu-smith commented on July 16, 2024

For the record, I migrated the map to PostgreSQL, and it worked fine. I can still do tests using Sqlite3 if you need me to. Cliff

…

On Fri, 25 Feb 2022 at 13:33, Cliff Pratt ***@***.***> wrote: I updated minetest and recompiled, just in case it was something on their side. No change. On Thu, 24 Feb 2022 at 23:45, Buckaroo Banzai ***@***.***> wrote: > I run the Mapserver binary (4.5.0) and Minetest compiled > (5.6.0-dev-c31b301) > > In which stage does that happen? > OK, I start minetestserver, then I start the mapserver. If I then do *nothing*, including connecting via client, everything continues to run. I can look at the map though. If I connect to the server (from my second machine) minetestserver eventually crashes, even if I don't do anything. > There is the initial and incremental rendering stage? (mapserver logs in > the console) > it *is* possible that the database is locked in the initial stage as it > adds another mtime column, but it shouldn't do anything after that > because its re-opened read-only 😕 > > The issue doesn't occur until I set 'load_mod_mapserver = true' in > world.mt. > > Uhm, this shouldn't even matter, the the mod only communicates over http > and doesn't do anything to the database... > > OK, understood. Here is the first part of the output from the mapserver. it continues like this. ***@***.***:~/.minetest/worlds/Fifth$ ./mapserver -debug INFO[0000] Starting mapserver version=4.5.0 INFO[0000] Loading colors filename=colors/vanessa.txt prefix=colormapping size=1335774 INFO[0000] Loading colors filename=colors/advtrains.txt prefix=colormapping size=497 INFO[0000] Loading colors filename=colors/scifi_nodes.txt prefix=colormapping size=1315 INFO[0000] Loading colors filename=colors/mc2.txt prefix=colormapping size=69267 INFO[0000] Loading colors filename=colors/mtg.txt prefix=colormapping size=14912 INFO[0000] Loading colors filename=colors/miles.txt prefix=colormapping size=1289240 INFO[0000] Loading colors filename=colors/custom.txt prefix=colormapping size=853 INFO[0000] Migrating database filename=mapserver.sqlite prefix=mapobjectdb.sqlite INFO[0000] Migration completed elapsed=1.199624ms prefix=mapobjectdb.sqlite INFO[0000] Starting http server port=8080 webdev=false INFO[0000] using embed mode prefix=mapobjectdb INFO[0000] Starting incremental rendering job LastMtime=1645742929 DEBU[0000] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0005] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0010] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0015] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0020] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0025] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0030] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0035] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 DEBU[0040] FindMapBlocksByMtime lastmtime=1645742929 limit=10000 > — > Reply to this email directly, view it on GitHub > <#22 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABN4VRJNAPVLKABUPX56WETU4YD5XANCNFSM5PAQUDFQ> > . > Triage notifications on the go with GitHub Mobile for iOS > <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> > or Android > <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. > > You are receiving this because you authored the thread.Message ID: > ***@***.***> > -- My Amazon author page : https://amazon.com/author/cliffpratt My Facebook author page : https://www.facebook.com/cliffprattauthor My Search on Kobo : https://www.kobo.com/search?query=Cliff+Pratt

-- My Amazon author page : https://amazon.com/author/cliffpratt My Facebook author page : https://www.facebook.com/cliffprattauthor My Search on Kobo : https://www.kobo.com/search?query=Cliff+Pratt

from mapserver_mod.

BuckarooBanzay commented on July 16, 2024

should work with the mapserver v4.6.0 and above (if not: reopen please)

from mapserver_mod.

Mapserver cause dev Minetest to crash. about mapserver_mod HOT 6 CLOSED

Comments (6)

Related Issues (10)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent