Re: [Galette-discussion] Plantage serveur MySQL

2018-07-11 Par sujet Guillaume Rousse

Le 11/07/2018 à 18:24, Jean-Marc Briand a écrit :
J'ai d'autres bases sur mon serveur qui ne devraient pas être 
sollicitées par galette (aubapar1 et d'autres ...)


C'est moi ou c'est un bug ?
C'est ta configuration qui est manifestement sous-dimensionnée pour ton 
usage, cf http://www.solomonson.com/content/how-fix-errno-24-mysql


A+
--
Guillaume

--
Galette users discussions

http://galette.eu - http://galette.eu/documentation
http://bugs.galette.eu/projects/galette/

List documentation: https://listengine.tuxfamily.org/lists.galette.eu/users/



[Galette-discussion] Plantage serveur MySQL

2018-07-11 Par sujet Jean-Marc Briand

Bonjour Johan et tou·te·s,

Aujourd'hui, à l'installation d'une galette-0.9.1.2 toute chaude dans 
une base MySQL vierge, tout se passe bien.
Mais dans l'interface d'administration, au clic sur "Ajouter un 
adhérent" ou "Configuration > Générer les données factices > Générer", 
j'ai un plantage systématique du serveur MySQL. Les autres liens 
fonctionnent normalement.


Extrait de /var/log/mysql/error.log :

2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/yw30ans_users.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_acls.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_links.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_nature.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_pages.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_referrers.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_triples.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywcoluba_users.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_acls.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_links.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_nature.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_pages.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_referrers.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_triples.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywespenv_users.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_acls.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_links.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_nature.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_pages.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_referrers.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_triples.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:30 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./aubapar1/ywexpUBA_users.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:31 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./galette091/galette_preferences.frm' (errno: 24 - Too many open files)
2018-07-11 17:57:31 13875 [ERROR] /usr/sbin/mysqld: Can't open file: 
'./galette091/galette_preferences.frm' (errno: 24 - Too many open files)

2018-07-11 17:57:31 13875 [ERROR] Error in accept: Too many open files

J'ai d'autres bases sur mon serveur qui ne devraient pas être 
sollicitées par galette (aubapar1 et d'autres ...)


C'est moi ou c'est un bug ?

JM


--
Galette users discussions

http://galette.eu - http://galette.eu/documentation
http://bugs.galette.eu/projects/galette/

List documentation: https://listengine.tuxfamily.org/lists.galette.eu/users/



Re: [Galette-discussion] Problème avec l'Ajout de colonnes triées dans le listing membre

2018-07-11 Par sujet Contact CID Auditeur

Salut,

En mode debug :


 Détails

*Type :* Error

*Code :* 0

*Message :* Call to a member function limit() on boolean

*Fichier :* /home/oh2lebt2/asso.oitar.info/lib/Galette/Core/Pagination.php

*Ligne :* 176


 Trace

#0 /home/oh2lebt2/asso.oitar.info/lib/Galette/Repository/Members.php(245): 
Galette\Core\Pagination->setLimits(false)
#1 /home/oh2lebt2/asso.oitar.info/includes/routes/members.routes.php(345): 
Galette\Repository\Members->getMembersList(true)
#2 [internal function]: Closure->{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Array)
#3 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41):
 call_user_func(Object(Closure), Object(Slim\Http\Request), 
Object(Slim\Http\Response), Array)
#4 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Route.php(335): 
Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), 
Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#5 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(236): 
Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#6 [internal function]: Closure->{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\Route))
#7 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): 
call_user_func_array(Object(Closure), Array)
#8 [internal function]: 
Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\Route))
#9 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70):
 call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\Route))
#10 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117):
 Slim\Route->Slim\{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response))
#11 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Route.php(313): 
Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), 
Object(Slim\Http\Response))
#12 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/App.php(495): 
Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#13 
/home/oh2lebt2/asso.oitar.info/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47):
 Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#14 [internal function]: 
RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\App))
#15 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): 
call_user_func_array(Object(RKA\SessionMiddleware), Array)
#16 [internal function]: 
Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\App))
#17 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70):
 call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Slim\App))
#18 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(370): 
Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#19 [internal function]: Closure->{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#20 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): 
call_user_func_array(Object(Closure), Array)
#21 [internal function]: 
Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#22 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70):
 call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#23 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(395): 
Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#24 [internal function]: Closure->{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#25 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): 
call_user_func_array(Object(Closure), Array)
#26 [internal function]: 
Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#27 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70):
 call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#28 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(452): 
Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#29 [internal function]: Closure->{closure}(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#30 
/home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): 
call_user_func_array(Object(Closure), Array)
#31 [internal function]: 
Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), 
Object(Slim\Http\Response), Object(Closure))
#32