Databases
StackOverflow2013
Postsdbo
POacts_as_xapian jobs table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POacts_as_xapian jobs table
    primarykey
    data
    text
    <p>Can someone explain to me the inner workings of acts_as_xapian_jobs table?</p> <p>I ran into an issue with the <code>acts_as_xapian</code> plugin recently, where I kept getting the following error when it creates an object with xapian indexed fields:</p> <pre><code>Mysql::Error: Duplicate entry 'String-2147483647' for key 2: INSERT INTO `acts_as_xapian_jobs` (`action`, `model`, `model_id`) VALUES ('update', 'String', 23730251831560) </code></pre> <p>It turns out the <code>model_id</code> exceeded the max int value of 2147483647. The workaround was to update <code>model_id</code> to use bigint. Why would the <code>model_id</code> be so huge? By looking at content of <code>acts_as_xapian_jobs</code>, it seems it creates a row for every field that is being indexed.. Understanding how a job gets created in the table would help a great deal.</p> <p>Here's a sampling of the table: </p> <pre><code>mysql&gt; select * from acts_as_xapian_jobs limit 5\G *************************** 1. row *************************** id: 19 model: String model_id: 23804037900560 action: update *************************** 2. row *************************** id: 49 model: String model_id: 23804037191200 action: update *************************** 3. row *************************** id: 79 model: String model_id: 23804037932180 action: update *************************** 4. row *************************** id: 109 model: String model_id: 23804037101700 action: update *************************** 5. row *************************** id: 139 model: String model_id: 23804037722160 action: update </code></pre> <p>Thanks in advance,</p> <p>Amie </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USGrnbeagle
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload