typical error and more > a helping hand

[Regano]

gamed: err : 从数据库取得server data超时,worldtag=1

This error comes out rarely.
And Gamedbd is downed.

gdeliveryd: err : gdelivery:: connect GameDB failed

This error comes out every day.
However, a game can be played satisfactorily.
How is it solved if it carries out?

me to.
Average 30min Login after this error.

[Psytrac]

gamed: err : 从数据库取得Reading Database server data 超时timed out ,worldtag=1

^likely the database is messed up

you want to clean the directories listed here on the gamedbd gamesys.conf file:


[storage]
this---homedir = /dbf/dbhome
this---datadir = dbdata
maybe this --logdir = dblogs
backupdir = /dbf/backup
cachesize = 16777216
errpfx = Storage
checkpoint_interval = 60
backup_lockfile = /tmp/.lockgamedbd
quit_lockfile = /tmp/.quitgamedbd
compress = 1

[Regano]

I forgot to write the environment.
My environment
https://forum.ragezone.com/f452/comp...ackage-736572/
It is of pw-151-server_07.JAN.2014-ubuntu12.04.3_amd64.iso.
.
Machine
Vmware Workstation.
RAM 6GB
CPU core i7 4771 (4 thread allocation)
Network Bridge
.
CPU/RAM Usage.

Spoiler:

ps aux
USER        PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root          1  0.0  0.0  24292  2280 ?        Ss   05:44   0:01 /sbin/init
root          2  0.0  0.0      0     0 ?        S    05:44   0:00 [kthreadd]
root          3  0.0  0.0      0     0 ?        S    05:44   0:00 [ksoftirqd/0]
root          5  0.0  0.0      0     0 ?        S<   05:44   0:00 [kworker/0:0H]
root          7  0.0  0.0      0     0 ?        S<   05:44   0:00 [kworker/u:0H]
root          8  0.0  0.0      0     0 ?        S    05:44   0:00 [migration/0]
root          9  0.0  0.0      0     0 ?        S    05:44   0:00 [rcu_bh]
root         10  0.0  0.0      0     0 ?        S    05:44   0:02 [rcu_sched]
root         11  0.0  0.0      0     0 ?        S    05:44   0:00 [watchdog/0]
root         12  0.0  0.0      0     0 ?        S    05:44   0:00 [watchdog/1]
root         13  0.0  0.0      0     0 ?        S    05:44   0:00 [ksoftirqd/1]
root         14  0.0  0.0      0     0 ?        S    05:44   0:00 [migration/1]
root         16  0.0  0.0      0     0 ?        S<   05:44   0:00 [kworker/1:0H]
root         17  0.0  0.0      0     0 ?        S    05:44   0:00 [watchdog/2]
root         18  0.0  0.0      0     0 ?        S    05:44   0:00 [ksoftirqd/2]
root         19  0.0  0.0      0     0 ?        S    05:44   0:00 [migration/2]
root         21  0.0  0.0      0     0 ?        S<   05:44   0:00 [kworker/2:0H]
root         22  0.0  0.0      0     0 ?        S    05:44   0:00 [watchdog/3]
root         23  0.0  0.0      0     0 ?        S    05:44   0:00 [ksoftirqd/3]
root         24  0.0  0.0      0     0 ?        S    05:44   0:00 [migration/3]
root         25  0.0  0.0      0     0 ?        S    05:44   0:00 [kworker/3:0]
root         26  0.0  0.0      0     0 ?        S<   05:44   0:00 [kworker/3:0H]
root         27  0.0  0.0      0     0 ?        S<   05:44   0:00 [cpuset]
root         28  0.0  0.0      0     0 ?        S<   05:44   0:00 [khelper]
root         29  0.0  0.0      0     0 ?        S    05:44   0:00 [kdevtmpfs]
root         30  0.0  0.0      0     0 ?        S<   05:44   0:00 [netns]
root         31  0.0  0.0      0     0 ?        S    05:44   0:00 [bdi-default]
root         32  0.0  0.0      0     0 ?        S<   05:44   0:00 [kintegrityd]
root         33  0.0  0.0      0     0 ?        S<   05:44   0:00 [kblockd]
root         34  0.0  0.0      0     0 ?        S<   05:44   0:00 [ata_sff]
root         35  0.0  0.0      0     0 ?        S    05:44   0:00 [khubd]
root         36  0.0  0.0      0     0 ?        S<   05:44   0:00 [md]
root         37  0.0  0.0      0     0 ?        S<   05:44   0:00 [devfreq_wq]
root         40  0.0  0.0      0     0 ?        S    05:44   0:00 [khungtaskd]
root         41  0.0  0.0      0     0 ?        S    05:44   0:00 [kswapd0]
root         42  0.0  0.0      0     0 ?        SN   05:44   0:00 [ksmd]
root         43  0.0  0.0      0     0 ?        SN   05:44   0:00 [khugepaged]
root         44  0.0  0.0      0     0 ?        S    05:44   0:00 [fsnotify_mark]
root         45  0.0  0.0      0     0 ?        S    05:44   0:00 [ecryptfs-kthrea]
root         46  0.0  0.0      0     0 ?        S<   05:44   0:00 [crypto]
root         57  0.0  0.0      0     0 ?        S<   05:44   0:00 [kthrotld]
root         58  0.0  0.0      0     0 ?        S    05:44   0:03 [kworker/1:1]
root         60  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_0]
root         61  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_1]
root         63  0.0  0.0      0     0 ?        S<   05:44   0:00 [binder]
root         83  0.0  0.0      0     0 ?        S<   05:44   0:00 [deferwq]
root         84  0.0  0.0      0     0 ?        S<   05:44   0:00 [charger_manager]
root         85  0.0  0.0      0     0 ?        S    05:44   0:04 [kworker/2:1]
root        186  0.0  0.0      0     0 ?        S<   05:44   0:00 [mpt_poll_0]
root        187  0.0  0.0      0     0 ?        S<   05:44   0:00 [mpt/0]
root        293  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_2]
root        296  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_3]
root        299  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_4]
root        301  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_5]
root        302  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_6]
root        303  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_7]
root        304  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_8]
root        305  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_9]
root        306  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_10]
root        307  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_11]
root        308  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_12]
root        309  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_13]
root        310  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_14]
root        311  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_15]
root        312  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_16]
root        313  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_17]
root        314  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_18]
root        317  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_19]
root        318  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_20]
root        319  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_21]
root        320  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_22]
root        322  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_23]
root        323  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_24]
root        324  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_25]
root        325  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_26]
root        326  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_27]
root        327  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_28]
root        328  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_29]
root        329  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_30]
root        330  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_31]
root        331  0.0  0.0      0     0 ?        S    05:44   0:00 [scsi_eh_32]
root        357  0.0  0.0      0     0 ?        S    05:44   0:00 [kworker/u:28]
root        358  0.0  0.0      0     0 ?        S    05:44   0:00 [kworker/u:29]
root        361  0.0  0.0      0     0 ?        S<   05:44   0:00 [kdmflush]
root        373  0.0  0.0      0     0 ?        S<   05:44   0:00 [kdmflush]
root        381  0.0  0.0      0     0 ?        S    05:44   0:09 [jbd2/dm-0-8]
root        382  0.0  0.0      0     0 ?        S<   05:44   0:00 [ext4-dio-unwrit]
root        494  0.0  0.0  17236   636 ?        S    05:44   0:00 upstart-udev-bridge --daemon
root        498  0.0  0.0  22504  2248 ?        Ss   05:44   0:00 /sbin/udevd --daemon
root        786  0.0  0.0      0     0 ?        S<   05:44   0:00 [ttm_swap]
root        791  0.0  0.0  22500  1768 ?        S    05:44   0:00 /sbin/udevd --daemon
root        792  0.0  0.0  22500  1516 ?        S    05:44   0:00 /sbin/udevd --daemon
root        802  0.0  0.0      0     0 ?        S<   05:44   0:00 [kpsmoused]
root        806  0.0  0.0      0     0 ?        S    05:44   0:00 [kworker/2:2]
syslog      820  0.0  0.0 249472  1436 ?        Sl   05:44   0:00 rsyslogd -c5
root        836  0.0  0.0  15192   392 ?        S    05:44   0:00 upstart-socket-bridge --daemon
102         925  0.0  0.0  23928  1228 ?        Ss   05:44   0:00 dbus-daemon --system --fork --activation=upstart
root        938  0.0  0.0      0     0 ?        S    05:44   0:00 [kworker/1:2]
root        945  0.0  0.0      0     0 ?        S    05:44   0:04 [kworker/3:2]
root       1001  0.0  0.0  21192  1756 ?        Ss   05:44   0:00 /usr/sbin/bluetoothd
root       1008  0.0  0.0  50036  2876 ?        Ss   05:44   0:00 /usr/sbin/sshd -D
root       1030  0.0  0.0      0     0 ?        S<   05:44   0:00 [krfcommd]
root       1092  0.0  0.0  15788   964 tty4     Ss+  05:44   0:00 /sbin/getty -8 38400 tty4
root       1099  0.0  0.0  15788   964 tty5     Ss+  05:44   0:00 /sbin/getty -8 38400 tty5
root       1104  0.0  0.0  15788   964 tty2     Ss+  05:44   0:00 /sbin/getty -8 38400 tty2
root       1105  0.0  0.0  15788   964 tty3     Ss+  05:44   0:00 /sbin/getty -8 38400 tty3
root       1107  0.0  0.0  15788   964 tty6     Ss+  05:44   0:00 /sbin/getty -8 38400 tty6
root       1110  0.0  0.0   4332   696 ?        Ss   05:44   0:00 acpid -c /etc/acpi/events -s /var/run/acpid.socket
daemon     1115  0.0  0.0  16912   380 ?        Ss   05:44   0:00 atd
root       1116  0.0  0.0  19116   924 ?        Ss   05:44   0:00 cron
root       1120  0.0  0.0  15984   700 ?        Ss   05:44   0:03 /usr/sbin/irqbalance
whoopsie   1137  0.0  0.0 200100  4968 ?        Ssl  05:44   0:00 whoopsie
root       1320  0.0  0.0   4404   740 ?        S    05:44   0:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/ubuntu.pid
root       1399  0.0  0.0      0     0 ?        S    05:44   0:02 [flush-252:0]
nobody     1681  0.0  0.4 184796 29280 ?        Sl   05:44   0:07 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-dir=/opt/lampp/lib/mysql/plugin --user=nobody --log-error=/opt/lampp/var/mysql/ubuntu.err --pid-file=/opt/lampp/var/mysql/ubuntu.pid --socket=/opt/lampp/var/mysql/mysql.sock --port=3306
root       1726  0.0  0.3  52404 18772 ?        Ss   05:44   0:01 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
root       1737  0.1  3.0 3371436 188656 ?      Sl   05:44   0:45 /usr/java/jre1.5.0_21/bin/java -Djava.util.logging.config.file=/opt/apache-tomcat-5.5.28/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/opt/apache-tomcat-5.5.28/common/endorsed -classpath /opt/apache-tomcat-5.5.28/bin/bootstrap.jar -Dcatalina.base=/opt/apache-tomcat-5.5.28 -Dcatalina.home=/opt/apache-tomcat-5.5.28 -Djava.io.tmpdir=/opt/apache-tomcat-5.5.28/temp org.apache.catalina.startup.Bootstrap start
nobody     1752  0.0  0.2  48472 12840 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
nobody     1753  0.0  0.2  52404 14724 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
nobody     1754  0.0  0.2  52404 14724 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
nobody     1755  0.0  0.2  52404 14724 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
nobody     1756  0.0  0.2  52404 14724 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
nobody     1757  0.0  0.2  52404 14724 ?        S    05:44   0:00 /opt/lampp/bin/httpd -k start -DSSL -DPHP5 -E /opt/lampp/logs/error_log
root       1787  0.0  0.0  65144  1980 tty1     Ss   05:44   0:00 /bin/login --       
root       1848  0.0  0.0  87576  1924 ?        Sl   05:44   0:07 ./logservice logservice.conf
root       1856  0.1  0.1  94520  7164 ?        Sl   05:44   0:34 ./uniquenamed gamesys.conf
root       1867  0.0  0.0   4404   612 ?        S    05:44   0:00 /bin/sh ./authd
root       1869  0.1  1.1 3708120 70080 ?       Sl   05:44   0:36 /usr/java/jre1.6.0_12/bin/java -cp /PWServer/151/authd/lib/mysql.jar:/PWServer/151/authd/lib/jio.jar:/PWServer/151/authd/lib/application.jar:/PWServer/151/authd/lib/commons-collections-3.1.jar:/PWServer/151/authd/lib/commons-dbcp-1.2.1.jar:/PWServer/151/authd/lib/commons-pool-1.2.jar:/PWServer/151/authd/lib/commons-logging-1.0.4.jar:/PWServer/151/authd/lib/log4j-1.2.9.jar:.: authd table.xml 123456
root       1884  0.3  0.3 197820 23900 ?        Sl   05:44   1:39 ./gamedbd gamesys.conf
root       1927  0.0  0.0 170312  3096 ?        S    05:44   0:03 ./gacd gamesys.conf
root       1929  0.0  0.0  21176  1996 ?        S    05:44   0:04 ./gfactiond gamesys.conf
root       1931  0.0  0.0  34784  4444 ?        S    05:44   0:12 ./gdeliveryd gamesys.conf
root       1933  0.0  0.0  18624  2848 ?        S    05:44   0:27 ./glinkd gamesys.conf 1
root       1935  5.8 17.5 1287004 1071644 ?     Sl   05:44  32:05 ./gs gs01
root       1966  0.0  0.0      0     0 ?        S<   05:47   0:00 [kworker/2:1H]
root       2203  0.0  0.0      0     0 ?        S<   06:46   0:00 [kworker/3:1H]
root       2204  0.0  0.0      0     0 ?        S<   06:46   0:00 [kworker/1:1H]
root       2220  0.0  0.0      0     0 ?        S<   06:54   0:00 [kworker/0:1H]
root       2293  0.0  0.0      0     0 ?        S    13:03   0:00 [kworker/0:2]
root       2308  0.0  0.0  82104  3956 ?        Rs   14:34   0:00 sshd: root@notty    
root       2311  0.0  0.0 2091636 3808 ?        Sl   14:34   0:00 /usr/sbin/console-kit-daemon --no-daemon
root       2378  0.0  0.0 186468  3092 ?        Sl   14:34   0:00 /usr/lib/policykit-1/polkitd --no-debug
root       2564  0.0  0.0  20772  1716 ?        Ss   14:34   0:00 -bash
root       2572  0.0  0.0      0     0 ?        S    14:37   0:00 [kworker/0:1]
root       2721  0.1  0.0  23020  4264 tty1     S+   14:52   0:00 -bash
root       2779  0.0  0.0  15284  1136 ?        R    14:55   0:00 ps aux

[storage]
homedir			=	./dbhome
datadir			=	./dbdata
logdir			=	./dblogs
backupdir		=	./backup
cachesize		=	16777216
errpfx			=	Storage
checkpoint_interval	=	60
backup_lockfile	=	/tmp/.lockgamedbd
quit_lockfile	=	/tmp/.quitgamedbd
compress		=	1

[storagewdb]
homedir			=	./dbhomewdb
datadir			=	./dbdata
logdir			=	./dblogs
backupdir		=	./backup
checkpoint_interval	=	60
times_incbackup	=	1
tables			=	auction,city,equipment,friends,messages,status,user,clsconfig,factioninfo,inventory,rolename,storehouse,userfaction,base,config,factionname,mailbox,sellpoint,task,translog,waitdel,gtask,order,shoplog,syslog,userstore,webtrade,webtradesold,serverdata,factionfortress,factionrelation,force,friendext,globalcontrol,crslogicuid,rolenamehis,kingelection,playershop,weborderitem,playerprofile,uniquedata,recalluser
cache_high_default	=	8000
cache_low_default	=	7500
base_cache_high		=	50000
base_cache_low		=	45000
status_cache_high	=	50000
status_cache_low	=	45000
equipment_cache_high=	50000
equipment_cache_low	=	45000
inventory_cache_high=	50000
inventory_cache_low	=	45000
backup_lockfile	=	/tmp/.lockgamedbd
quit_lockfile	=	/tmp/.quitgamedbd

./dbhome directory does not exist.
./dbdata directory is empty.
./dblogs directory is empty.

The ./dbhomewdb/dblogs has log.55824486.
The ./dbhomewdb/dbdata there are multiple files.

[Psytrac]

dbdata is the database file itself, it either needs repairs or it needs to be deleted

[Regano]

Thank You

[Regano]

plz sPCK.exe Support Over 3GB.

[shadowvzs]

I don't have map at heaven n hell world but have problem with hell world leaving platform (not teleport back to world) and a21,a22 and world up also heaven platform work just hell world no, it's write something instance name with blue color

[Edit]
Unable to enter instance

message cause the region.clt file, because missed this from region.clt:

[trans]
126 122 0
-767.900024,312.316010,808.729980
10.000000,15.000000,10.000000
23.709999,365.790009,-335.720001

[pwAdmin]

i am getting gs offline

log

脜盲脰脙脦脛录镁:'gs.conf' 脜盲脰脙脭枚虏鹿脦脛录镁:'gsalias.conf'
掳脵卤娄赂贸脰脨脦茂脝路29500(1赂枚)鲁卢鹿媒脕脣露脩碌镁脡脧脧脼0
鲁玫脢录禄炉掳脵卤娄赂贸脢媒戮脻脢搂掳脺
碌脷脪禄虏陆鲁玫脢录禄炉脢搂掳脺拢卢麓铆脦贸潞脜:-31

translated

You blind neck Xiute shin magnesium record: 'gs.conf' You blind neck Xiu Cheng Te tibia gold captive deer magnesium record: 'gsalias.conf'
Gu Lou captive halogen bribe Mau Mau neck Cute bloated Road 29500 (1 bribe pieces) Lu Lu Lu Lu repair bunk medium Wrist lip magnesium brisket meat extort extort Lang 0
Lumeimeilu Lululugu Luloulumao Meimeilujie Meiloulusui
Lulichilu Krupp Lulu Mei Meilululu Meiloulusui Longlulumao Temaoluyou: -31

but i can't find the problem

[shadowvzs]

According the 1st post probabil you have problem with item with id 29500, maybe check stack size in elements.data or if it's in gshop then it's price.

[sonvu2406]

i have my own unique name offline, is there any idea for this?

[DeathRow Anons]

Does anyone know whats this error cloud be


env TZ =
ÅäÖÃÎļþ:'gs.conf' ÅäÖÃÔö²¹Îļþ:'gsalias.conf'
×°±¸ºó°ó¶¨¹¦ÄÜ´ò¿ª
°Ù±¦¸óÄÚ¹²ÓÐ2745Ñù»õÎï
°Ù±¦¸óÖÐÎïÆ·61651(1¸ö)³¬¹ýÁ˶ѵþÉÏÏÞ0
³õʼ»¯ºèÀûÉ̳ÇÊý¾Ýʧ°Ü
µÚÒ»²½³õʼ»¯Ê§°Ü£¬´íÎóºÅ:-32

does anyone know what this error could be

[Steve Langley]

-32 is a shop error. either gshop, gshop1 or gshop2

[darmek]

I don't know why, but my client get closed when I open g-shop with some characters.
But, the strange was when I created a new one on the same account, the gshop open normally.

Is a way to track what is closing my client? Or some how to fix this?

[Psytrac]

I don't know why, but my client get closed when I open g-shop with some characters.
But, the strange was when I created a new one on the same account, the gshop open normally.

Is a way to track what is closing my client? Or some how to fix this?

ec.log should tell you