1

Error defragmenting database

Topic: Error defragmenting database

We had started with this problem fews days ago.  The wialonb3 service  stop working.
It seems an error in defragmenting database and always shows defragmentation level is 20%.

I am copy part of the log files for the last three days. We had use a script to restart the service automatic, but this problem is producing alot  noise with customs.

Thanks a lot any help about this problem.

2015/12/25 08:00:00:007: storage_messages_env::do_defrag: trying databases defragmentation
2015/12/25 08:00:00:007: storage_messages_db::do_defrag(1): starting
2015/12/25 08:12:46:241: Stopping ADF service...
2015/12/25 08:12:46:719: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): finished
2015/12/25 08:12:47:569: storage_messages_env::do_defrag: error defragmenting 1 database
2015/12/25 08:12:47:569: storage_messages_env::do_defrag: finished databases defragmentation
2015/12/25 09:05:46:304: Starting ADF service...
2015/12/25 09:05:46:309: adf_init_app('environment.txt')
2015/12/25 09:05:47:258: storage_messages_env::open_environment: opened 2 databases with 104234373 messages and 21590889 new messages, fragmentation level is 20%.
2015/12/25 09:05:50:764: ADF service started(PID=16839).
2015/12/25 09:06:03:720: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): started
2015/12/26 08:00:00:307: storage_messages_env::do_defrag: trying databases defragmentation
2015/12/26 08:00:00:307: storage_messages_db::do_defrag(1): starting
2015/12/26 08:12:21:209: Stopping ADF service...
2015/12/26 08:12:21:608: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): finished
2015/12/26 08:12:22:457: storage_messages_env::do_defrag: error defragmenting 1 database
2015/12/26 08:12:22:457: storage_messages_env::do_defrag: finished databases defragmentation
2015/12/26 08:13:02:016: Starting ADF service...
2015/12/26 08:13:02:017: adf_init_app('environment.txt')
2015/12/26 08:13:02:645: storage_messages_env::open_environment: opened 2 databases with 104307744 messages and 21664260 new messages, fragmentation level is 20%.
2015/12/26 08:13:02:808: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): started
2015/12/26 08:13:03:752: ADF service started(PID=16473).
2015/12/27 07:59:57:570: storage_messages_env::do_defrag: trying databases defragmentation
2015/12/27 07:59:57:570: storage_messages_db::do_defrag(1): starting
2015/12/27 08:12:23:227: Stopping ADF service...
2015/12/27 08:12:24:524: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): finished
2015/12/27 08:12:25:429: storage_messages_env::do_defrag: error defragmenting 1 database
2015/12/27 08:12:25:429: storage_messages_env::do_defrag: finished databases defragmentation
2015/12/27 08:13:01:392: Starting ADF service...
2015/12/27 08:13:01:393: adf_init_app('environment.txt')
2015/12/27 08:13:03:108: storage_messages_env::open_environment: opened 2 databases with 104513258 messages and 21869774 new messages, fragmentation level is 20%.
2015/12/27 08:13:03:272: storage_messages_cache::msgs_thread('671ffb1138602adcd0fdc7d476c2f744'): started
2015/12/27 08:13:04:229: ADF service started(PID=4836).

2

Error defragmenting database

Re: Error defragmenting database

Hello.

Make sure, there is enough free space left on your HDD before the defragmentation starts (it should be enough to store one extra file of the siza, that metches the biggest one in the $wialonb3folder$/storage/md - if there is enough space and there are still errors, send us an ssh access to support@gurtam.com and we'll check your logs (make sure to provide link to this topic also)

3

Error defragmenting database

Re: Error defragmenting database

as told - during defragmentation, there was less 20 Gb left on the storage and the process was killed