Errore savataggio permessi

4 contenuti / 0 new
Ultimo contenuto
Errore savataggio permessi

Salve, sono nuovo di qui, spero di essere nella sezione giusta.
Premetto che ho installato circa 20-22 moduli. Il problema è, da qualche giorno provo a modificare i permessi associati a dei ruoli ma non riesco, drupal infatti tenta il caricamento per circa 1 minuto o poco più, dopodichè mi restituisce un messaggio di errore:

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: DELETE FROM {role_permission} WHERE (rid = :db_condition_placeholder_0) AND (permission IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19, :db_condition_placeholder_20, :db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24, :db_condition_placeholder_25, :db_condition_placeholder_26, :db_condition_placeholder_27, :db_condition_placeholder_28, :db_condition_placeholder_29, :db_condition_placeholder_30, :db_condition_placeholder_31, :db_condition_placeholder_32, :db_condition_placeholder_33, :db_condition_placeholder_34, :db_condition_placeholder_35, :db_condition_placeholder_36, :db_condition_placeholder_37, :db_condition_placeholder_38, :db_condition_placeholder_39, :db_condition_placeholder_40, :db_condition_placeholder_41, :db_condition_placeholder_42, :db_condition_placeholder_43, :db_condition_placeholder_44, :db_condition_placeholder_45, :db_condition_placeholder_46, :db_condition_placeholder_47, :db_condition_placeholder_48, :db_condition_placeholder_49, :db_condition_placeholder_50, :db_condition_placeholder_51, :db_condition_placeholder_52, :db_condition_placeholder_53, :db_condition_placeholder_54, :db_condition_placeholder_55, :db_condition_placeholder_56, :db_condition_placeholder_57, :db_condition_placeholder_58, :db_condition_placeholder_59, :db_condition_placeholder_60, :db_condition_placeholder_61, :db_condition_placeholder_62, :db_condition_placeholder_63, :db_condition_placeholder_64, :db_condition_placeholder_65, :db_condition_placeholder_66, :db_condition_placeholder_67, :db_condition_placeholder_68, :db_condition_placeholder_69, :db_condition_placeholder_70, :db_condition_placeholder_71)) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => manage slideshows [:db_condition_placeholder_2] => administer blocks [:db_condition_placeholder_3] => administer ckeditor [:db_condition_placeholder_4] => customize ckeditor [:db_condition_placeholder_5] => allow CKFinder file uploads [:db_condition_placeholder_6] => administer css injection [:db_condition_placeholder_7] => administer comments [:db_condition_placeholder_8] => post comments [:db_condition_placeholder_9] => skip comment approval [:db_condition_placeholder_10] => edit own comments [:db_condition_placeholder_11] => access contextual links [:db_condition_placeholder_12] => access dashboard [:db_condition_placeholder_13] => administer filters [:db_condition_placeholder_14] => use text format filtered_html [:db_condition_placeholder_15] => use text format full_html [:db_condition_placeholder_16] => use text format php_code [:db_condition_placeholder_17] => administer image styles [:db_condition_placeholder_18] => administer lightbox2 [:db_condition_placeholder_19] => download original image [:db_condition_placeholder_20] => administer languages [:db_condition_placeholder_21] => translate interface [:db_condition_placeholder_22] => administer menu [:db_condition_placeholder_23] => bypass node access [:db_condition_placeholder_24] => administer content types [:db_condition_placeholder_25] => administer nodes [:db_condition_placeholder_26] => access content overview [:db_condition_placeholder_27] => view own unpublished content [:db_condition_placeholder_28] => view revisions [:db_condition_placeholder_29] => revert revisions [:db_condition_placeholder_30] => delete revisions [:db_condition_placeholder_31] => create article content [:db_condition_placeholder_32] => edit own article content [:db_condition_placeholder_33] => edit any article content [:db_condition_placeholder_34] => delete own article content [:db_condition_placeholder_35] => delete any article content [:db_condition_placeholder_36] => create page content [:db_condition_placeholder_37] => edit own page content [:db_condition_placeholder_38] => edit any page content [:db_condition_placeholder_39] => delete own page content [:db_condition_placeholder_40] => delete any page content [:db_condition_placeholder_41] => access overlay [:db_condition_placeholder_42] => use PHP for settings [:db_condition_placeholder_43] => administer password policies [:db_condition_placeholder_44] => unblock expired accounts [:db_condition_placeholder_45] => force password change [:db_condition_placeholder_46] => administer url aliases [:db_condition_placeholder_47] => create url aliases [:db_condition_placeholder_48] => administer search [:db_condition_placeholder_49] => administer shortcuts [:db_condition_placeholder_50] => customize shortcut links [:db_condition_placeholder_51] => switch shortcut sets [:db_condition_placeholder_52] => administer modules [:db_condition_placeholder_53] => administer site configuration [:db_condition_placeholder_54] => administer themes [:db_condition_placeholder_55] => administer software updates [:db_condition_placeholder_56] => administer actions [:db_condition_placeholder_57] => access administration pages [:db_condition_placeholder_58] => access site in maintenance mode [:db_condition_placeholder_59] => view the administration theme [:db_condition_placeholder_60] => access site reports [:db_condition_placeholder_61] => block IP addresses [:db_condition_placeholder_62] => administer taxonomy [:db_condition_placeholder_63] => edit terms in 1 [:db_condition_placeholder_64] => delete terms in 1 [:db_condition_placeholder_65] => access toolbar [:db_condition_placeholder_66] => administer permissions [:db_condition_placeholder_67] => administer users [:db_condition_placeholder_68] => access user profiles [:db_condition_placeholder_69] => change own username [:db_condition_placeholder_70] => cancel account [:db_condition_placeholder_71] => select account cancellation method ) in user_role_revoke_permissions() (linea 3082 di /nfs/c08/h03/mnt/118913/domains/**********.it/html/modules/user/user.module).

Come posso risolvere il problema?
E' una cosa abbastanza urgente, comunque grazie in anticipo.

Drupal Version:

Meggis (non verificato)
Ritratto di Anonimo

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction:

You can set it to higher value in /etc/my.cnf permanently with this line

[mysqld]
innodb_lock_wait_timeout=120
and restart mysql. If you cannot restart mysql at this time, run this:

SET GLOBAL innodb_lock_wait_timeout = 120;
You could also just set it for the duration of your session

SET innodb_lock_wait_timeout = 120;
followed by your query

Give it a Try !!!

@Meggis

spostare il time-out su innodb per drupal ... non è in generale una buona idea e solitamente se il server non è tuo non è nemmeno praticabile... (cosidera quel timeout il tempo per eseguire le transazioni del motore di innodb, più è lungo e piu le cose si accavallano)

@nokigatta

prova a capire chi va lungo con uno dei seguenti cron "Avanzati"
- https://drupal.org/project/elysia_cron (consigliato)
- https://drupal.org/project/ultimate_cron

e poi vedi come proseguire (magari scopri che frazionando il cron non serve far nulla...)

Meggis (non verificato)
Ritratto di Anonimo

How to debug Lock wait timeout exceeded?

http://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeou...

Tips is not mine... That's all!