search

Enochen / bastmush

Automatically exported from code.google.com/p/bastmush
0 stars 0 forks source link

database lock after upgrading kills spellup plugin? #130

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What is your username on Aardwolf?
Fiendish

I got the following report from Nao when trying to help him get the spellup 
plugin loaded. (Restarting MUSHclient fixed the issue for him)

From : Nao: Error mini spellup Forum : Personal - #351092 To : Fiendish Date : Sat Jan 14 12:12:59 2012

D:\AardMush\logs\\stats.db : upgrading database from 1 to 7
PERFORMING DATABASE BACKUP. DON'T TOUCH ANYTHING!
D:\AardMush\logs\\stats.db : upgrading database from 1 to 7
PERFORMING DATABASE BACKUP. DON'T TOUCH ANYTHING!
db: D:\AardMush\logs\\stats.db
CHECKING INTEGRITY
"integrity_check"="ok"
INTEGRITY CHECK PASSED
BACKING UP DATABASES
md "D:\AardMush\logs\\db_backups\" >"D:\AardMush\bastmush_temp_file.txt" 2>&1
copying db to D:\AardMush\logs\\db_backups\\stats.db.v1
 >"D:\AardMush\bastmush_temp_file.txt" 2>&1
        1 fichier(s) copi(s).
FINISHED DATABASE BACKUP. YOU MAY NOW GO BACK TO MUDDING.
finished updating to version 2
finished updating to version 3
finished updating to version 4
finished updating to version 5
finished updating to version 6
finished updating to version 7
Done upgrading!
Run-time error
Plugin: miniwin_spellup (called from world: Aardwolf)
Function/Sub: OnPluginInstall called by Plugin miniwin_spellup
Reason: Executing plugin miniwin_spellup sub OnPluginInstall
no such table: recoveries
stack traceback:
        [C]: in function 'nrows'
        [string "Plugin"]:1733: in function 'OnPluginEnable'
        [string "Plugin"]:1697: in function <[string "Plugin"]:1694>
Added plugin D:\AardMush\worlds\plugins\Bast\miniwin_spellup.xml
Run-time error
Plugin: bast_spellup (called from world: Aardwolf)
Function/Sub: OnPluginInstall called by Plugin bast_spellup
Reason: Executing plugin bast_spellup sub OnPluginInstall
no such table: recoveries
stack traceback:
[C]: in function 'nrows'
[string "Plugin"]:1286: in function 'OnPluginEnable'
[string "Plugin"]:1262: in function <[string "Plugin"]:1259>
(Friend) Unnoticed Ninja: 'otherwise i could beat her'
Deathruler Apocolyte Nobletalks: 'try nanjiki'
Run-time error
Plugin: xBroadcast_SpellSkills (called from world: Aardwolf)
Function/Sub: recoveries_redirect called by trigger
Reason: processing trigger "multi_line_recoveries"
no such table: recoveries

stack traceback:
[C]: in function 'rows'
[string "Plugin"]:490: in function <[string "Plugin"]:469>
Run-time error
Plugin: miniwin_spellup (called from world: Aardwolf)
Function/Sub: OnPluginBroadcast called by Plugin miniwin_spellup
Reason: Executing plugin miniwin_spellup sub OnPluginBroadcast
database is locked
stack traceback:
C]: in function 'nrows'
D:\AardMush\worlds\plugins\Bast\lua\sqlitedb.lua:36: in function 'checkversion'
D:\AardMush\worlds\plugins\Bast\lua\chardb.lua:52: in function 'initialize'
D:\AardMush\worlds\plugins\Bast\lua\objectlua\Class.lua:19: in function 'new'
D:\AardMush\worlds\plugins\Bast\lua\bastspell.lua:79: in function 'load_spells'
string "Plugin"]:1674: in function <[string "Plugin"]:1655>
Run-time error
Plugin: bast_spellup (called from world: Aardwolf)
Function/Sub: OnPluginBroadcast called by Plugin bast_spellup
Reason: Executing plugin bast_spellup sub OnPluginBroadcast
database is locked
stack traceback:


Original issue reported on code.google.com by `Fiendi...@gmail.com` on 14 Jan 2012 at 5:25
GoogleCodeExporter commented 9 years ago 
I just got a similar error when loading the spellup_miniwin plugin for the 
first time on a new install.

Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\stats.db : 
upgrading database from 1 to 7
PERFORMING DATABASE BACKUP. DON'T TOUCH ANYTHING!
db: Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\stats.db
CHECKING INTEGRITY
"integrity_check"="ok"
INTEGRITY CHECK PASSED
BACKING UP DATABASES
md "Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\db_backups\" 
>"Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\bastmush_temp_file.txt"
 2>&1
copying db to 
Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\db_backups\\stats.d
b.v1
copy /Y "Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\stats.db" 
"Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\logs\\db_backups\\stats.
db.v1" 
>"Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\bastmush_temp_file.txt"
 2>&1
FINISHED DATABASE BACKUP. YOU MAY NOW GO BACK TO MUDDING.
finished updating to version 2
finished updating to version 3
finished updating to version 4
finished updating to version 5
finished updating to version 6
finished updating to version 7
Done upgrading!
Run-time error
Plugin: miniwin_spellup (called from world: Aardwolf)
Function/Sub: OnPluginInstall called by Plugin miniwin_spellup
Reason: Executing plugin miniwin_spellup sub OnPluginInstall
no such table: recoveries
stack traceback:
        [C]: in function 'nrows'
        ...entpackage\MUSHclient\worlds\plugins\Bast\lua\chardb.lua:1027: in function 'getallrecoveries'
        ...package\MUSHclient\worlds\plugins\Bast\lua\bastspell.lua:105: in function 'load_recoveries'
        [string "Plugin"]:1733: in function 'OnPluginEnable'
        ...kage\MUSHclient\worlds\plugins\Bast\lua\pluginhelper.lua:354: in function 'OnPluginInstall'
        [string "Plugin"]:1697: in function <[string "Plugin"]:1694>
Added plugin 
Z:\home\avi\Documents\aardwolfclientpackage\MUSHclient\worlds\plugins\Bast\miniw
in_spellup.xml
Run-time error
Plugin: bast_spellup (called from world: Aardwolf)
Function/Sub: OnPluginInstall called by Plugin bast_spellup
Reason: Executing plugin bast_spellup sub OnPluginInstall
no such table: recoveries
stack traceback:
        [C]: in function 'nrows'
        ...entpackage\MUSHclient\worlds\plugins\Bast\lua\chardb.lua:1027: in function 'getallrecoveries'
        ...package\MUSHclient\worlds\plugins\Bast\lua\bastspell.lua:105: in function 'load_recoveries'
        [string "Plugin"]:1286: in function 'OnPluginEnable'
        ...kage\MUSHclient\worlds\plugins\Bast\lua\pluginhelper.lua:354: in function 'OnPluginInstall'
        [string "Plugin"]:1262: in function <[string "Plugin"]:1259>
Run-time error
Plugin: xBroadcast_SpellSkills (called from world: Aardwolf)
Function/Sub: recoveries_redirect called by trigger
Reason: processing trigger "multi_line_recoveries"
no such table: recoveries
stack traceback:
        [C]: in function 'rows'
        ...entpackage\MUSHclient\worlds\plugins\Bast\lua\chardb.lua:988: in function 'updaterecoveries'
        [string "Plugin"]:490: in function <[string "Plugin"]:469>
Run-time error
Plugin: miniwin_spellup (called from world: Aardwolf)
Function/Sub: OnPluginBroadcast called by Plugin miniwin_spellup
Reason: Executing plugin miniwin_spellup sub OnPluginBroadcast
database is locked
stack traceback:
        [C]: in function 'nrows'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:127: in function 'checkfortable'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:52: in function 'checkversiontable'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:40: in function 'checkversion'
        ...entpackage\MUSHclient\worlds\plugins\Bast\lua\chardb.lua:52: in function 'initialize'
        ...e\MUSHclient\worlds\plugins\Bast\lua\objectlua\Class.lua:19: in function 'new'
        ...package\MUSHclient\worlds\plugins\Bast\lua\bastspell.lua:79: in function 'load_spells'
        [string "Plugin"]:1674: in function <[string "Plugin"]:1655>
Run-time error
Plugin: bast_spellup (called from world: Aardwolf)
Function/Sub: OnPluginBroadcast called by Plugin bast_spellup
Reason: Executing plugin bast_spellup sub OnPluginBroadcast
database is locked
stack traceback:
        [C]: in function 'nrows'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:127: in function 'checkfortable'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:52: in function 'checkversiontable'
        ...tpackage\MUSHclient\worlds\plugins\Bast\lua\sqlitedb.lua:40: in function 'checkversion'
        ...entpackage\MUSHclient\worlds\plugins\Bast\lua\chardb.lua:52: in function 'initialize'
        ...e\MUSHclient\worlds\plugins\Bast\lua\objectlua\Class.lua:19: in function 'new'
        ...package\MUSHclient\worlds\plugins\Bast\lua\bastspell.lua:79: in function 'load_spells'
        [string "Plugin"]:1228: in function <[string "Plugin"]:1083>

Original comment by Fiendi...@gmail.com on 22 Apr 2012 at 6:08

GoogleCodeExporter commented 9 years ago 
Why does it run backup before finished upgrading? That seems bad.

Original comment by Fiendi...@gmail.com on 22 Apr 2012 at 6:12

GoogleCodeExporter commented 9 years ago 
This was fixed, the update function used a newer version of the table instead 
of the one for that version.

Original comment by enda...@gmail.com on 6 Dec 2012 at 4:07