For Admins everything is normal, but for anonymus users site is offline.

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'args' at row 1: UPDATE {background_process} SET callback=:db_update_placeholder_0, args=:db_update_placeholder_1, uid=:db_update_placeholder_2, token=:db_update_placeholder_3 WHERE (handle = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => s:28:"cache_graceful_execute_queue"; [:db_update_placeholder_1] => a:6:{i:0;s:60:"frontpage:news_top3:results:f7ab2335d110778af627f93cb0451b6d";i:1;a:2:{i:0;s:29:"_cache_graceful_views_execute";i:1;s:903117:"O:4:"view":59:{s:8:"db_table";s:10:"views_view";s:10:"base_table";s:4:"node";s:10:"base_field";s:3:"nid";s:4:"name";s:9:"frontpage";s:3:"vid";s:1:"1";s:11:"description";s:73:"Последние новости на главной и сайдбаре";s:3:"tag";s:7:"content";s:10:"human_name";s:55:"Фронтальные новости и сайдбар";s:4:"core";s:1:"0";s:11:"api_version";N;s:8:"disabled";b:0;s:7:"editing";b:0;s:4:"args";a:0:{}s:8:"use_ajax";b:0;s:6:"result";a:0:{}s:12:"current_page";N;s:14:"items_per_page";N;s:6:"offset";N;s:10:"total_rows";N;s:17:"exposed_raw_input";a:0:{}s:8:"old_view";a:2:{i:0;N;i:1;O:4:"view":58:
....
"height";s:3:"450";s:3:"uid";s:3:"126";s:8:"filename";s:22:"view_491501_423138.jpg";s:3:"uri";s:43:"public://field/image/view_491501_423138.jpg";s:8:"filemime";s:10:"image/jpeg";s:8:"filesize";s:5:"44857";s:6:"status";s:1:"1";s:9:"timestamp";s:10:"1357802496";s:11:"rdf_mapping";a:0:{}}}}}}s:10:"total_rows";i:0;s:12:"current_page";N;}s:6:"expire";i:1357879320;}s:7:"created";s:10:"1357879289";s:6:"expire";s:10:"1357879350";s:10:"serialized";s:1:"1";}}} [:db_update_placeholder_2] => 0 [:db_update_placeholder_3] => cab1fd0a8d8e5217125f7b0458f86e23 [:db_condition_placeholder_0] => cache_graceful:frontpage:news_top3:results:f7ab2335d110778af627f93cb0451b6d ) в функции background_process_set_process() (строка 648 в файле /www/p/progoroda/www/sites/all/modules/background_process/background_process.module).
CommentFileSizeAuthor
#3 Error.txt203.27 KBdmitlantis

Comments

gielfeldt’s picture

gielfeldt commented

Hi

Thanks for the bug report.

The column for "args" is a BLOB which should be able to hold 64KiB. I'm not sure why the view would be this large. If you can add some debugging code, perhaps we can find out.

in cache_graceful.module:52 add:

$data = serialize($this->view);
if (strlen($data) > 64000) {
  watchdog('cache_graceful', "Views objects larger than 64KB: " . print_r($data, TRUE), array(), WATCHDOG_DEBUG);
}

To solve your immediate problem, you might get away with just altering the column to a larger datatype:

ALTER TABLE background_process MODIFY args LONGBLOB;
gielfeldt’s picture

gielfeldt commented
Status: Active » Postponed (maintainer needs more info)
dmitlantis’s picture

dmitlantis commented
StatusFileSize
new Error.txt203.27 KB

I've do that. Now, when i visit /admin/reports/dblog, this error occures:

gielfeldt’s picture

gielfeldt commented

Arg ... same error, just in locale :-). I guess it probably shouldn't try to translate the views object.

Try this instead:

$data = serialize($this->view);
if (strlen($data) > 64000) {
  watchdog('cache_graceful', "Views objects larger than 64KB: !data", array('!data' => print_r($data, TRUE)), WATCHDOG_DEBUG);
}
gielfeldt’s picture

gielfeldt commented

In any case, I think I'll update the cache graceful module to use a longblob for the args. It makes sense to do so.

gielfeldt’s picture

gielfeldt commented

I of course meant the Background Process module. I've updated the Background Process module to increase the size of the args column.

I've look at the dump of the view in your error_1.txt. I don't think there's anything wrong with it, it's just big.

I believe you can remove the debug-code I posted, and then it should work for you. Can you confirm this? If so, I will make a new release of Background Process.

gielfeldt’s picture

gielfeldt commented
Status: Postponed (maintainer needs more info) » Fixed

fixed in dev

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

holtzermann17’s picture

holtzermann17 commented
Status: Closed (fixed) » Active

Dear Gielfeldt:

Should this also be fixed in 7.x-1.10-dev?

git clone --branch 7.x-1.10-dev http://git.drupal.org/project/background_process.git

more background_process.install
...

      'args' => array(
        'type' => 'blob',
        'not null' => FALSE,
      ),
gielfeldt’s picture

gielfeldt commented

Hi, that's an old an obsolete/intermediate branch and shouldn't be used for anything. All the relevant dev branches are up to date with big blob size.

gielfeldt’s picture

gielfeldt commented
Status: Active » Closed (fixed)
gielfeldt’s picture

gielfeldt commented
Issue summary: View changes

asdf