Author Topic: Opengoo crashes the mysql service  (Read 2818 times)

tportier

  • Newbie
  • *
  • Posts: 2
    • View Profile
    • Email
Opengoo crashes the mysql service
« on: August 14, 2009, 04:41:59 am »
Hello,

I have tested Opengoo on two separate servers with the same configuration :
- Apache 2.2.9
- Php 5.2.6
- Mysql 4.1.9-nt

I've tested on ie 8 and firefox 3.

Opengoo starts to function normaly (I create workspaces, upload documents....) but after a while the mysql service crashes and I have to restart it to continue my tests.

Have you ever had to face this problem?

My opengoo log :

Session "default" started at 2009-08-14T06:51:55+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Lost connection to MySQL server during query' - SELECT * FROM `og_users` WHERE (`id` IN (SELECT `user_id` FROM `og_project_users` WHERE `og_project_users`.`project_id` IN (-1,11)) OR `id` IN (SELECT `user_id` FROM `og_group_users` WHERE `og_group_users`.`group_id` IN (SELECT `user_id` FROM `og_project_users` WHERE `og_project_users`.`project_id` IN (-1,11)))) ORDER BY `og_users`.`display_name`
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Lost connection to MySQL server during query'' in D:\Website\test\opengoo3\environment\library\database\adapters\AbstractDBAdapter.class.php:386
    Stack trace:
    #0 D:\Website\test\opengoo3\environment\library\database\adapters\AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
    #1 D:\Website\test\opengoo3\environment\library\database\DB.class.php(209): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
    #2 D:\Website\test\opengoo3\application\models\project_users\ProjectUsers.class.php(72): DB::executeAll('SELECT * FROM `...')
    #3 D:\Website\test\opengoo3\application\models\project_users\ProjectUsers.class.php(42): ProjectUsers->getUsersByWorkspaces(Array, NULL)
    #4 D:\Website\test\opengoo3\application\models\projects\Project.class.php(1212): ProjectUsers->getUsersByProject(Object(Project))
    #5 D:\Website\test\opengoo3\application\views\dashboard\widget_dashboard_info.php(34): Project->getUsers(false)
    #6 D:\Website\test\opengoo3\environment\classes\template\Template.class.php(76): include('D:\Website\test...')
    #7 D:\Website\test\opengoo3\application\views\dashboard\widget.php(36): Template->includeTemplate('D:\Website\test...')
    #8 D:\Website\test\opengoo3\environment\classes\template\Template.class.php(76): include('D:\Website\test...')
    #9 D:\Website\test\opengoo3\application\views\dashboard\index.php(182): Template->includeTemplate('D:\Website\test...')
    #10 D:\Website\test\opengoo3\environment\classes\template\Template.class.php(76): include('D:\Website\test...')
    #11 D:\Website\test\opengoo3\environment\classes\template\Template.class.php(47): Template->includeTemplate('D:\Website\test...')
    #12 D:\Website\test\opengoo3\environment\classes\template\template.php(35): Template->fetch('D:\Website\test...')
    #13 D:\Website\test\opengoo3\environment\classes\controller\PageController.class.php(115): tpl_fetch('D:\Website\test...')
    #14 D:\Website\test\opengoo3\environment\classes\Env.class.php(141): PageController->getContent()
    #15 D:\Website\test\opengoo3\init.php(149): Env::executeAction('dashboard', 'index')
    #16 D:\Website\test\opengoo3\index.php(9): require('D:\Website\test...')
    #17 {main}
Time since start: 15.5334742069 seconds
« Last Edit: August 14, 2009, 05:28:56 am by tportier »

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: Opengoo crashes the mysql service
« Reply #1 on: August 24, 2009, 10:54:08 am »
Hi,

Can you try upgrading your MySQL? It should be a bug in your version of MySQL. No SQL query should crash a server.

signorcuoco

  • Newbie
  • *
  • Posts: 14
    • View Profile
Re: Opengoo crashes the mysql service
« Reply #2 on: November 03, 2009, 10:50:18 am »
Any news on this? I have a similar problem. Did it disappear after upgrading?

I can' t upgrade myself, because I'm on a hosted service with mysql server version 4.1.21 and client version  5.0.32 (I don't know if it matters.), but I can put them under pression..

signorcuoco

  • Newbie
  • *
  • Posts: 14
    • View Profile
Re: Opengoo crashes the mysql service
« Reply #3 on: December 01, 2009, 06:58:30 am »
The problem disappeared here after moving OpenGoo to a MySQL5 server.