Server Crashed - setSQLfromFile

[kpma1985]

Hi,

i got a problem.


2012-08-07 16:29:58.501958|ERROR |FileManager | | accept() failed: 24
2012-08-07 16:29:58.502124|CRITICAL|DatabaseQuery | | setSQLfromFile( file:sql/client_delete_prune.sql) failed
2012-08-07 16:29:58.502627|ERROR |FileManager | | accept() failed: 24
2012-08-07 16:29:58.502999|ERROR |FileManager | | accept() failed: 24
2012-08-07 16:29:58.503125|ERROR |FileManager | | accept() failed: 24
2012-08-07 16:29:58.503250|ERROR |FileManager | | accept() failed: 24


Received SIGCHLD from Kernel



do anyone know what this is?? I checked the Database and it seems to be ok -.-


Thanks

[SilentStorm]

Either you specified a bad (aka non existing) Path to the SQL Files, or your SQL Files are missing / corrupt.
Do you use an ini File for the Server? - If so please post its contents.
How do you start your Server?
Post the output of ls -alh while in the directory you installed TeamSpeak Server into.

[kpma1985]

hi!

here is the INI file

query_port=10011
query_ip=212.224.XXX.XXX
dbplugin=ts3db_sqlite3
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_sqlite/
logpath=logs
logquerycommands=0
create_default_virtualserver=0
clear_database=0

and here the output of ls -alh

total 948M
drwxr----- 9 teamspeak teamspeak 4.0K Aug 7 20:39 .
drwxr-xr-x 6 teamspeak teamspeak 4.0K Aug 7 18:52 ..
-rw-r----- 1 teamspeak teamspeak 27M Oct 3 2011 2011-06-11.ts3server.sqlitedb
-rw-r----- 1 teamspeak teamspeak 24K Apr 23 06:48 LICENSE
-rw------- 1 teamspeak teamspeak 20 Aug 2 15:11 adminaccount
-rw-r----- 1 teamspeak teamspeak 0 Aug 2 15:00 db_dump.sqldumpecho
drwxr-x--- 2 teamspeak teamspeak 4.0K Aug 2 14:14 doc
-rw-r----- 1 teamspeak teamspeak 307 May 31 2011 empty_config.ini
drwxr-x--- 703 teamspeak teamspeak 36K Aug 7 16:06 files
-rwxr-x--- 1 teamspeak teamspeak 4.6K Oct 3 2011 gameserver.sh
-rwxr-x--- 1 teamspeak teamspeak 204K Jun 29 10:01 libts3db_mysql.so
-rwxr-x--- 1 teamspeak teamspeak 896K Aug 3 09:36 libts3db_sqlite3.so
-rw-r----- 1 teamspeak teamspeak 873 Mar 6 21:51 licensekey.dat
drwxr-x--- 2 teamspeak teamspeak 6.1M Aug 7 20:14 logs
-rw-r----- 1 root root 5 Aug 7 20:12 process.pid
-rwxr-x--- 1 teamspeak teamspeak 0 Aug 7 20:12 query_ip_blacklist.txt
-rwxr-x--- 1 teamspeak teamspeak 67 Aug 7 20:12 query_ip_whitelist.txt
-rw-r----- 1 teamspeak teamspeak 112 Oct 3 2011 serverkey.dat
drwxr-x--- 2 teamspeak teamspeak 4.0K Jun 29 10:01 serverquerydocs
drwxr-x--- 4 teamspeak teamspeak 4.0K Aug 7 18:53 sql
-rw-r----- 1 teamspeak teamspeak 140K Oct 3 2011 sql_update.sql
drwxr-x--- 4 teamspeak teamspeak 4.0K Jul 3 13:09 ts3_permupdate
-rw-r----- 1 teamspeak teamspeak 44M Aug 3 10:17 ts3server.backup.sql
-rwxr-x--- 1 teamspeak teamspeak 331 Aug 7 20:13 ts3server.ini
-rw-r----- 1 teamspeak teamspeak 200K Aug 7 20:33 ts3server.log
-rw-r----- 1 teamspeak teamspeak 36M Aug 7 20:39 ts3server.sqlitedb
-rwxr-x--- 1 teamspeak teamspeak 264M Jul 3 09:52 ts3server.sqlitedb-03-07-2012
-rw-r----- 1 teamspeak teamspeak 36M Aug 3 10:56 ts3server.sqlitedb.bakbak
-rwxr-x--- 1 teamspeak teamspeak 264M Aug 2 15:24 ts3server.sqlitedb____
-rwxrwx--- 1 teamspeak teamspeak 264M Aug 3 10:00 ts3server.sqlitedb_aaaa
-rwxr-x--- 1 teamspeak teamspeak 6.7M Jun 29 10:01 ts3server_linux_x86
-rwxr-x--- 1 teamspeak teamspeak 1.2K Jun 29 10:01 ts3server_minimal_runscript.sh
-rwxr-x--- 1 teamspeak teamspeak 3.7K Jun 29 10:01 ts3server_startscript.sh
drwxr-x--- 2 teamspeak teamspeak 4.0K Jun 29 10:01 tsdns

I download and replaced the sql folder,too

[kpma1985]

Hi,

it happened again

2012-08-07 18:50:28.504794|CRITICAL|DatabaseQuery |   | setSQLfromFile( file:sql/client_get_by_uid.sql) failed
2012-08-07 18:50:28.504922|ERROR   |FileManager   |   | accept() failed: 24
2012-08-07 18:50:28.505522|ERROR   |FileManager   |   | accept() failed: 24
2012-08-07 18:50:28.505702|ERROR   |FileManager   |   | accept() failed: 24


Received SIGCHLD from Kernel
Der Prozess wurde beendet 
tail: ts3server.log: file truncated

I start the Server with:

./ts3server_linux_x86 inifile=/home/ts/x86/ts3server.ini dbplugin=ts3db_sqlite3 serveradmin_password=XXXXX create_default_virtualserver=0

[SilentStorm]

Server should be started with ./ts3server_startscript.sh start inifile=ts3server.ini any of your other Parameters (like create_default_virtualserver = 0) can be specified in the ini File. you don't need to (and shouldn't) start the server with the serveradmin_password Parameter unless you forgot it and even then it only needs to be done once.
Please post output of ulimit -a

[kpma1985]

okay, I'll change the start parameter.

here is the output

ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16382
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited