Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:248:\"Can't create/write to file '/tmp/#sql_7f5b_0.MYI' (Errcode: 30)\nquery: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 615 ORDER BY v.weight, t.weight, t.name\";s:5:\"%file\";s:67:\"/var/www/drupal/dpcore/drupal-6.19/modules/taxonomy/taxonomy.module\";s:5:\"%line\";i:633;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:203:\"Incorrect key file for table './drupaldb/cache_content.MYI'; try to repair it\nquery: SELECT data, created, headers, expire, serialized FROM cache_content WHERE cid = 'content:610:615'\";s:5:\"%file\";s:53:\"/var/www/drupal/dpcore/drupal-6.19/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:533:\"Incorrect key file for table './drupaldb/cache_content.MYI'; try to repair it\nquery: UPDATE cache_content SET data = 'a:1:{s:15:\\"field_news_date\\";a:1:{i:0;a:4:{s:5:\\"value\\";s:10:\\"1276518660\\";s:8:\\"timezone\\";s:13:\\"Europe/Berlin\\";s:11:\\"timezone_db\\";s:3:\\"UTC\\";s:9:\\"date_type\\";s:9:\\"datestamp\\";}}}', created = 1284055579, expire = 0, headers = '', serialized = 1 WHERE cid = ' in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:221:\"Incorrect key file for table './drupaldb/cache_menu.MYI'; try to repair it\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:page-cid:node/610:1'\";s:5:\"%file\";s:53:\"/var/www/drupal/dpcore/drupal-6.19/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:333:\"Incorrect key file for table './drupaldb/cache_menu.MYI'; try to repair it\nquery: UPDATE cache_menu SET data = 'links:primary-links:tree-data:d1a237786261a07db4df6742f3aadbec', created = 1284055579, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:primary-links:page-cid:node/610:1'\";s:5:\"%file\";s:53:\"/var/www/drupal/dpcore/drupal-6.19/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '' in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:223:\"Incorrect key file for table './drupaldb/cache_menu.MYI'; try to repair it\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:page-cid:node/610:1'\";s:5:\"%file\";s:53:\"/var/www/drupal/dpcore/drupal-6.19/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:337:\"Incorrect key file for table './drupaldb/cache_menu.MYI'; try to repair it\nquery: UPDATE cache_menu SET data = 'links:secondary-links:tree-data:eddedf6f60449527ae115ed169b66fe2', created = 1284055579, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:secondary-links:page-cid:node/610:1'\";s:5:\"%file\";s:53:\"/var/www/drupal/dpcore/drupal-6.19/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '& in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128
DES-Bike at Lange Nacht der Wissenschaften 2010 | DES-Testbed
Home › DES-Bike at Lange Nacht der Wissenschaften 2010

DES-Bike at Lange Nacht der Wissenschaften 2010

Posted June 14th, 2010 by Dipl.-Inf. Felix Juraschek

The DES-Bike is a Persistence of Vision (PoV) display mounted into a bike wheel. It consists of an LED bar with 34 RGB-LEDs and an MSB-A2 wireless sensor nodes. The sensor node adjusts the LED switch time via a reed switch to the current bike speed, resulting in a fixed image location for the observer.

 

DES-Bike images

Sample images displayed on DES-Bike

The sensor node allows us to connect the DES-Bike with the wireless sensor network of the DES-Testbed using the Chipcon CC1100 transceiver. Additionally, the sensor node is equipped with a Bluetooth module that enables connections with nearby wireless mesh routers of the DES-Testbed. The hardware for this fun device was designed and constructed by Dr.-Ing Achim Liers. 

Next to all the fun of riding the DES-Bike around displaying colorful images, we will use the DES-Bike for tracking applications on our campus based on the wireless sensor network of the DES-Testbed. Depending on the location of the DES-Bike, information of the current state of the DES-Testbed is displayed such as its closest neighboring sendor node. 

 

The set-up of the DES-Bike, consisting of an RGB-LED bar with 34 LEDs and one of our MSB-A2 sensor nodes. The sensor node allows us to connect the DES-Bike to the DES-Testbed using the Chipcon CC1100 transceiver of the MSB-A2 sensor nodes. Additionally, a Bluetooth module enables communication with nearby WiFi mesh backbone routers.

 

We presented the DES-Bike at the Lange Nacht der Wissenschaften 2010. The DES-Bike was connected to a laptop computer on which a programm with a simple GUI allowed visitors to select images and text messages and send them via Bluetooth to the DES-Bike. A selection of sample images can be seen below. 

 

More sample images for the DES-Bike


Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:210:\"Incorrect key file for table './drupaldb/node_counter.MYI'; try to repair it\nquery: UPDATE node_counter SET daycount = daycount + 1, totalcount = totalcount + 1, timestamp = 1284055579 WHERE nid = 610\";s:5:\"%file\";s:71:\"/var/www/drupal/dpcore/drupal-6.19/modules/statistics/statistics.module\";s:5:\"%line\";i:54;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:367:\"Incorrect key file for table './drupaldb/accesslog.MYI'; try to repair it\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('DES-Bike at Lange Nacht der Wissenschaften 2010', 'node/610', '', '38.107.191.106', 0, '69f327e833e9ced60d48730ebeaa9024', 417, 1284055579)\";s:5:\"%file\";s:71:\"/var/www/drupal/dpcore/drupal-6.19/modules/statistics/statistics.module\";s:5:\"%line\";i:64;}', 3, '', 'http://www.des-testbed.net/cont in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128

Warning: Incorrect key file for table './drupaldb/watchdog.MYI'; try to repair it query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:272:\"Incorrect key file for table './drupaldb/sessions.MYI'; try to repair it\nquery: UPDATE sessions SET uid = 0, cache = 0, hostname = '38.107.191.106', session = '', timestamp = 1284055579 WHERE sid = '69f327e833e9ced60d48730ebeaa9024'\";s:5:\"%file\";s:55:\"/var/www/drupal/dpcore/drupal-6.19/includes/session.inc\";s:5:\"%line\";i:70;}', 3, '', 'http://www.des-testbed.net/content/des-bike-lange-nacht-der-wissenschaften-2010', '', '38.107.191.106', 1284055579) in /var/www/drupal/dpcore/drupal-6.19/includes/database.mysqli.inc on line 128