Xangis
Foundation Developer
Posts: 124
Join date: 2011-12-30
Location: Beaverton, OR
 | | Subject: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error Sat 9 Jun - 0:59 | |
| I'm still working on getting a world server up and running based on the code in trunk. After getting past my problem with the message number text file, I discovered another problem. A few of the services are expecting a database a bit different than in the install.sql: | Code: | wmgr_1.out:ERROR [2012-06-08 18:18:15,771] main Database.registerStatusReportingPlugin com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'run_id' in 'field list'
wmgr_1.out:ERROR [2012-06-08 19:30:47,875] main Engine: Engine.registerStatusReportingPlugin: Registration of plugin 'WorldManager1' failed! |
This causes problems with the instance manager, as seen in instance.out:
| Code: | instance.out:ERROR [2012-06-08 19:32:43,973] Instance-2 CreateInstanceHook: no world manager for instance, templateName=sampleworld template
instance.out:ERROR [2012-06-08 19:32:43,973] Instance-2 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,975] SelfMessage Unexpected RPC response requestId=25 from=instance,27
instance.out:ERROR [2012-06-08 19:32:43,984] Instance-4 CreateInstanceHook: no world manager for instance, templateName=bigbrother template
instance.out:ERROR [2012-06-08 19:32:43,985] Instance-4 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,993] SelfMessage Unexpected RPC response requestId=30 from=instance,32
instance.out:ERROR [2012-06-08 19:32:43,996] Instance-6 CreateInstanceHook: no world manager for instance, templateName=frontier template
instance.out:ERROR [2012-06-08 19:32:43,996] Instance-6 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,999] SelfMessage Unexpected RPC response requestId=35 from=instance,37
instance.out:ERROR [2012-06-08 19:32:44,004] Instance-8 CreateInstanceHook: no world manager for instance, templateName=video template
instance.out:ERROR [2012-06-08 19:32:44,004] Instance-8 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:44,012] SelfMessage Unexpected RPC response requestId=40 from=instance,42 |
I modified the database to add the run_id column to the plugin_status table and all of those errors went away. My first try was an int, but that didn't work so I went with varchar:
| Code: | alter table plugin_status add column run_id varchar(50); |
Things still aren't quite right yet, since it looks like the WORLD_NAME and WORLD_DIR variables aren't getting set during startup script execution:
| Code: | instance.out:ERROR [2012-06-08 19:36:44,035] Instance-2 CreateInstanceHook: world file not found fileName=../config//.mvw
instance.out:ERROR [2012-06-08 19:36:44,043] Instance-4 CreateInstanceHook: world file not found fileName=../config//bigbrother.mvw
instance.out:ERROR [2012-06-08 19:36:44,049] Instance-6 CreateInstanceHook: world file not found fileName=../config//frontier.mvw
instance.out:ERROR [2012-06-08 19:36:44,061] Instance-8 CreateInstanceHook: world file not found fileName=../config//video.mvw |
Still, I'm getting closer to having a working sampleworld server online based on trunk... it feels like once I get those path variables sorted things will be good.  |
|
Xangis
Foundation Developer
Posts: 124
Join date: 2011-12-30
Location: Beaverton, OR
| | Subject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error Sat 9 Jun - 1:34 | |
| Looks like run_id should actually be a bigint. Seems to be in the install.sql file, so I must have set up the db with an older version or something... |
|
Xangis
Foundation Developer
Posts: 124
Join date: 2011-12-30
Location: Beaverton, OR
| | Subject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error Sat 9 Jun - 4:19 | |
| To continue the conversation with myself...
The server from 2008-06-23 has an install.sql that doesn't include run_id in the plugin_status table. That's what I used initially. |
|
CobaltBlues
Moderator
Posts: 203
Join date: 2011-11-21
Location: Chicago Land
| | Subject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error Mon 11 Jun - 20:54 | |
| Yes I encountered this and modified the install.sql to include the field. |
|
Delurin
Head of Platform Development
Posts: 406
Join date: 2011-08-02
| | Subject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error Mon 11 Jun - 22:04 | |
| It looks like they had removed it in the version after the 2008-6-23 because we are running just fine with out it.
|
|
