Loading on device list

Neha Sharma7 years ago

Hi,
I successfully installed traccar version 3.6 but when we are add the device with using web pannel the all data of device is saved in database but not show in web pannel and loading show always on show device list side this problem is working on last 3 days please help me.
Thanks,

Anton Tananaev7 years ago

First of all, why did you install an old version?

As for the problem, it usually happens when you use MySQL with MyISAM engine. If that's the case, you should re-create database with InnoDB engine.

Neha Sharma7 years ago

My apologies, the traccar version we installed is 3.8. Below we are getting following logs in "/opt/traccar/logs" file.

2016-12-27 02:52:38  INFO: [C902C9A1] connected
2016-12-27 02:52:38 DEBUG: [C902C9A1: 5060 < 163.172.125.79] HEX: 494e56495445207369703a3438383235343038363332403139382e3231312e32312e3637205349502f322e300d0a5669613a205349502f322e302f544350203136332e3137322e3132352e37393a31383630313b6272616e63683d7a39684734624b2d3532343238372d312d2d2d656234616637346135663635373433653b72706f72740d0a4d61782d466f7277617264733a2037300d0a436f6e746163743a203c7369703a313032403136332e3137322e3132352e37393a31383630313b7472616e73706f72743d7463703e3b2b7369702e696e7374616e63653d223c75726e3a757569643a32343933314536392d433332392d364233432d344535302d3430313944354631414535383e220d0a546f3a203c7369703a3438383235343038363332403139382e3231312e32312e36373e0d0a46726f6d3a2022313032223c7369703a313032403139382e3231312e32312e36373e3b7461673d38393439313034660d0a43616c6c2d49443a202d6637585f64344b67554f69595563596e324a4176672e2e0d0a435365713a203120494e564954450d0a416c6c6f773a20494e564954452c2041434b2c2043414e43454c2c204f5054494f4e532c204259452c2052454645522c204e4f544946592c204d4553534147452c2052454749535445522c205355425343524942452c20494e464f0d0a436f6e74656e742d547970653a206170706c69636174696f6e2f7364700d0a537570706f727465643a207265706c616365730d0a557365722d4167656e743a20436973636f2d534950476174657761792f494f532d31322e780d0a416c6c6f772d4576656e74733a20686f6c642c2074616c6b2c20636f6e666572656e63650d0a436f6e74656e742d4c656e6774683a203534380d0a0d0a763d300d0a6f3d2d20323432333539303730203120494e20495034203136332e3137322e3132352e37390d0a733d706f72747369702e636f6d0d0a633d494e20495034203136332e3137322e3132352e37390d0a743d3020300d0a6d3d617564696f203230303034205254502f415650203020382031382039372033203938203920313030203939203130322031323120313035203130310d0a613d7274706d61703a302050434d552f383030300d0a613d7274706d61703a382050434d412f383030300d0a613d7274706d61703a313820473732392f383030300d0a613d666d74703a313820616e6e6578623d6e6f0d0a613d7274706d61703a393720694c42432f383030300d0a613d7274706d61703a332047534d2f383030300d0a613d7274706d61703a393820414d522f383030300d0a613d7274706d61703a3920473732322f383030300d0a613d7274706d61703a3130302053504545582f383030300d0a613d7274706d61703a393920414d522d
2016-12-27 02:52:38 DEBUG: [C902C9A1: 5060 < 163.172.125.79] HEX: 57422f31363030300d0a613d7274706d61703a3130322053504545582f31363030300d0a613d7274706d61703a3132312047373232312f31363030300d0a613d666d74703a31323120626974726174653d32343030300d0a613d7274706d61703a313035206f7075732f34383030300d0a613d7274706d61703a3130312074656c6570686f6e652d6576656e742f383030300d0a613d666d74703a31303120302d31360d0a613d73656e64726563760d0a
2016-12-27 02:52:39  WARN: [C902C9A1] error - Connection reset by peer - IOException (...)
2016-12-27 02:52:39  INFO: [C902C9A1] disconnected
2016-12-27 12:21:47  INFO: [A469016F] connected
2016-12-27 12:21:47 DEBUG: [A469016F: 5050 < 94.102.49.174] HEX: 47455420687474703a2f2f7777772e62616964752e636f6d2f63616368652f676c6f62616c2f696d672f67732e67696620485454502f312e310d0a486f73743a207777772e62616964752e636f6d0d0a557365722d4167656e743a204d6f7a696c6c610d0a49662d4d6f6469666965642d53696e63653a205468752c2031392041707220323031322030393a35313a323020474d540d0a0d0a
2016-12-27 12:22:27  INFO: [A469016F] disconnected

Now can you please help me out or changing the database engine is the only solution, then if i need to change database engine please provide some links to do so.

Thanks for your valued time Anton.

Anton Tananaev7 years ago

You can change the engine type, but the problem is that because constraints are missing, you won't get them even after the change.

I guess the easiest way is to create a new database, let Traccar initialise the schema, and then copy over all the data.