use mysql as queue type,but mysql table is empty

[wandiankan]

I use mysql as queue type,but when I add job to gearman, the mysql table is empty?

mysql gearman version is the trunk today

example:
worker:bin/gearman -w -f aa -- sleep 100
client:bin/gearman -f a 'aaa'

DEBUG INFO:
 INFO 2012-04-25 00:54:29.426659 [ main ] Initializing MySQL module
   INFO 2012-04-25 00:54:29.434699 [ main ] Initializing Gear
   INFO 2012-04-25 00:54:29.435010 [ main ] Starting up, verbose set to DEBUG
  DEBUG 2012-04-25 00:54:29.435274 [ main ] Method for libevent: epoll -> libgearman-server/gearmand.cc:321
  DEBUG 2012-04-25 00:54:29.435660 [ main ] Trying to listen on 0.0.0.0:4730 -> libgearman-server/gearmand.cc:456
   INFO 2012-04-25 00:54:29.435731 [ main ] Listening on 0.0.0.0:4730 (8)
  DEBUG 2012-04-25 00:54:29.435763 [ main ] Trying to listen on :::4730 -> libgearman-server/gearmand.cc:456
   INFO 2012-04-25 00:54:29.435812 [ main ] Listening on :::4730 (9)
  DEBUG 2012-04-25 00:54:29.435838 [ main ] Creating wakeup pipe -> libgearman-server/gearmand.cc:756
  DEBUG 2012-04-25 00:54:29.435865 [ main ] Creating 4 threads -> libgearman-server/gearmand.cc:335
  DEBUG 2012-04-25 00:54:29.435888 [ main ] Initializing libevent for IO thread -> libgearman-server/gearmand_thread.cc:89
  DEBUG 2012-04-25 00:54:29.435944 [ main ] Creating IO thread wakeup pipe -> libgearman-server/gearmand_thread.cc:290
  DEBUG 2012-04-25 00:54:29.436159 [ main ] staring up Epoch thread -> libgearman-server/timer.cc:58
  DEBUG 2012-04-25 00:54:29.436371 [ main ] Thread 1 created -> libgearman-server/gearmand_thread.cc:143
  DEBUG 2012-04-25 00:54:29.436524 [ main ] Initializing libevent for IO thread -> libgearman-server/gearmand_thread.cc:89
  DEBUG 2012-04-25 00:54:29.436591 [ 1 ] Entering thread event loop -> libgearman-server/gearmand_thread.cc:260
  DEBUG 2012-04-25 00:54:29.436597 [ main ] Creating IO thread wakeup pipe -> libgearman-server/gearmand_thread.cc:290
  DEBUG 2012-04-25 00:54:29.436777 [ main ] Thread 2 created -> libgearman-server/gearmand_thread.cc:143
  DEBUG 2012-04-25 00:54:29.436805 [ main ] Initializing libevent for IO thread -> libgearman-server/gearmand_thread.cc:89
  DEBUG 2012-04-25 00:54:29.436858 [ main ] Creating IO thread wakeup pipe -> libgearman-server/gearmand_thread.cc:290
  DEBUG 2012-04-25 00:54:29.436846 [ 2 ] Entering thread event loop -> libgearman-server/gearmand_thread.cc:260
  DEBUG 2012-04-25 00:54:29.436955 [ main ] Thread 3 created -> libgearman-server/gearmand_thread.cc:143
  DEBUG 2012-04-25 00:54:29.436983 [ main ] Initializing libevent for IO thread -> libgearman-server/gearmand_thread.cc:89
  DEBUG 2012-04-25 00:54:29.437022 [ 3 ] Entering thread event loop -> libgearman-server/gearmand_thread.cc:260
  DEBUG 2012-04-25 00:54:29.437034 [ main ] Creating IO thread wakeup pipe -> libgearman-server/gearmand_thread.cc:290
  DEBUG 2012-04-25 00:54:29.437141 [ main ] Thread 4 created -> libgearman-server/gearmand_thread.cc:143
   INFO 2012-04-25 00:54:29.437165 [ main ] MySQL queue replay
  DEBUG 2012-04-25 00:54:29.437197 [ 4 ] Entering thread event loop -> libgearman-server/gearmand_thread.cc:260
   INFO 2012-04-25 00:54:29.437440 [ main ] Adding event for listening socket (8)
   INFO 2012-04-25 00:54:29.437477 [ main ] Adding event for listening socket (9)
  DEBUG 2012-04-25 00:54:29.437498 [ main ] Adding event for wakeup pipe -> libgearman-server/gearmand.cc:805
  DEBUG 2012-04-25 00:54:29.437527 [ main ] Entering main event loop -> libgearman-server/gearmand.cc:361

[Sorin Baba (kenzo-bu)]

Only bg jobs are stored into the table. Can you try to submit a bg job to see if it's stored? For me it worked.