sem_wait: invalid argument / corrupt DB

05/10/2011 19:19 RumorUS#1
when I 'sh start' on tehdaroo's files on my root I get spam in my putty window like this:

Code:
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
sem_wait: invalid argument
...and so on


Also in my database when I try to repair tables I get this problem:

[Only registered and activated users can see links. Click Here To Register...]

I previously had 2008 files running perfectly there and I removed that database and serverfiles from the root and put these new ones. The 2010 files work on Virtualbox but not on the root :S.

someone please help me out :).
05/10/2011 19:21 ThinSmoke#2
syserr?
05/10/2011 19:32 ThinSmoke#3
from the core o_o
05/10/2011 19:38 RumorUS#4
I deleted all logs and ran server, the problem seems to be in database only. The other folders did not generate a log at all.

/db/syserr

Code:
SYSERR: May 10 19:15:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 10 19:16:16 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: May 10 19:16:16 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: May 10 19:16:16 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May 10 19:16:23 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
/db/syslog

[Only registered and activated users can see links. Click Here To Register...]
05/10/2011 19:42 ThinSmoke#5
May 10 19:16:27 :: --mysql_set_character_set(latin1)
May 10 19:16:39 :: AsyncSQL: closing mysql connection.

reinstall your database :/
05/10/2011 19:44 RumorUS#6
Quote:
Originally Posted by GothicCore View Post
May 10 19:16:27 :: --mysql_set_character_set(latin1)
May 10 19:16:39 :: AsyncSQL: closing mysql connection.

reinstall your database :/
so rm -R /var/db/mysql then untar it again? ...and what about rights and ownership and all that?
05/10/2011 19:45 ThinSmoke#7
rights chmod -R 777 /var/db/mysql and chown -R mysql /var/db/mysql
05/10/2011 19:51 RumorUS#8
Quote:
Originally Posted by GothicCore View Post
rights chmod -R 777 /var/db/mysql and chown -R mysql /var/db/mysql
I have same problem as before