Official Community Forums
 
HomeHome  FAQFAQ  SearchSearch  MemberlistMemberlist  UsergroupsUsergroups  RegisterRegister  Log in  The Wiki  Website  github Project  

Share | 
 

 Unknown column 'run_id' in 'field list' causes "No Default Instance" Error

View previous topic View next topic Go down 
AuthorMessage
Xangis
Foundation Developer
avatar

Posts : 124
Join date : 2011-12-30
Location : Beaverton, OR

PostSubject: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   Sat 9 Jun - 10: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. Smile
Back to top Go down
http://zetacentauri.com
Xangis
Foundation Developer
avatar

Posts : 124
Join date : 2011-12-30
Location : Beaverton, OR

PostSubject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   Sat 9 Jun - 11: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...
Back to top Go down
http://zetacentauri.com
Xangis
Foundation Developer
avatar

Posts : 124
Join date : 2011-12-30
Location : Beaverton, OR

PostSubject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   Sat 9 Jun - 14: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.
Back to top Go down
http://zetacentauri.com
CobaltBlues
Moderator
Moderator
avatar

Posts : 202
Join date : 2011-11-21
Location : Chicago Land

PostSubject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   Tue 12 Jun - 6:54

Yes I encountered this and modified the install.sql to include the field.
Back to top Go down
http://www.multiversemmo.com
Delurin
Head of Platform Development


Posts : 424
Join date : 2011-08-03

PostSubject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   Tue 12 Jun - 8: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.
Back to top Go down
Sponsored content




PostSubject: Re: Unknown column 'run_id' in 'field list' causes "No Default Instance" Error   

Back to top Go down
 
Unknown column 'run_id' in 'field list' causes "No Default Instance" Error
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» 2000 Point Grey Knights List (Draigo)
» Inquisition list (1750)
» 1000 pt Eldar list
» 1850 Necron List
» Thoughts on a mobile Tau list 1850 points

Permissions in this forum:You cannot reply to topics in this forum
 :: Development :: Server Scripting and Development-
Jump to: