Error on delete

Aslan · September 3, 2015 at 5:09 PM

98% of the time such things are caused by internal server issues. However, 2% of the time its an underlying issue with code. The fact that I get this instantly (less than 1 second) makes me suspect code. This happens anytime you move an item to the trash or attempt to delete. Trash completes, but delete does not.

PHP

WCF::destruct() Unhandled exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away




#0 /public_html/wcf/lib/data/DatabaseObjectEditor.class.php(68): wcf\system\database\Database->prepareStatement('UPDATE\twcf1_ses...')
#1 /public_html/wcf/lib/data/acp/session/ACPSessionEditor.class.php(42): wcf\data\DatabaseObjectEditor->update(Array)
#2 /public_html/wcf/lib/system/session/SessionHandler.class.php(857): wcf\data\acp\session\ACPSessionEditor->update(Array)
#3 /public_html/wcf/lib/system/WCF.class.php(175): wcf\system\session\SessionHandler->update()
#4 [internal function]: wcf\system\WCF::destruct()
#5 {main}

Display More

edit: Above is what was displayed in an overlay. Below is the full error log in AdminCP.

PHP

Thu, 03 Sep 2015 15:03:50 +0000
Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
File: /public_html/wcf/lib/system/database/Database.class.php (231)
PHP version: 5.6.12
WCF version: 2.1.6 (Typhoon)
Request URI: /filebase/index.php?ajax-proxy/&
Referrer: https://woltlabdev.com/filebase/file/1-test-1/
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.157 Safari/537.36
Information: ""
Stacktrace: 
  #0 /public_html/wcf/lib/data/language/LanguageEditor.class.php(70): wcf\system\database\Database->prepareStatement('SELECT\tlanguage...')
  #1 /public_html/wcf/lib/data/language/LanguageEditor.class.php(52): wcf\data\language\LanguageEditor->writeLanguageFiles(Array)
  #2 /public_html/wcf/lib/data/language/Language.class.php(161): wcf\data\language\LanguageEditor->updateCategory(Object(wcf\data\language\category\LanguageCategory))
  #3 /public_html/wcf/lib/data/language/Language.class.php(97): wcf\data\language\Language->loadCategory('wcf.ajax')
  #4 /public_html/wcf/lib/system/exception/AJAXException.class.php(110): wcf\data\language\Language->get('wcf.ajax.error....')
  #5 /public_html/wcf/lib/action/AJAXInvokeAction.class.php(169): wcf\system\exception\AJAXException->__construct('SQLSTATE[HY000]...', 503, '#0 /home/qvkgaf...', Array, 'da122da85c054eb...')
  #6 /public_html/wcf/lib/action/AJAXInvokeAction.class.php(99): wcf\action\AJAXInvokeAction->throwException(Object(wcf\system\database\DatabaseException))
  #7 /public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AJAXInvokeAction->execute()
  #8 /public_html/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
  #9 /public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
  #10 /public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
  #11 /public_html/filebase/index.php(10): wcf\system\request\RequestHandler->handle('filebase')
  #12 {main}

Display More

Aslan · September 3, 2015 at 5:33 PM

The other error I found was this. Against, it happens instantly (less than 1 second).

I am of course investigating the host and will follow up. But as it only happens on delete and it happens instantly... It could be either or.

PHP

Thu, 03 Sep 2015 15:03:50 +0000
Message: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
File: /public_html/wcf/lib/system/database/Database.class.php (231)
PHP version: 5.6.12
WCF version: 2.1.6 (Typhoon)
Request URI: /filebase/index.php?ajax-proxy/&
Referrer: https://woltlabdev.com/filebase/file/1-test-1/
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.157 Safari/537.36
Information: ""
Stacktrace: 
  #0 /public_html/filebase/lib/data/file/FileEditor.class.php(125): wcf\system\database\Database->prepareStatement('UPDATE\tfilebase...')
  #1 /public_html/filebase/lib/data/file/FileAction.class.php(754): filebase\data\file\FileEditor::rebuildFileData(Array)
  #2 [internal function]: filebase\data\file\FileAction->trash()
  #3 /public_html/wcf/lib/data/AbstractDatabaseObjectAction.class.php(196): call_user_func(Array)
  #4 /public_html/wcf/lib/action/AJAXProxyAction.class.php(77): wcf\data\AbstractDatabaseObjectAction->executeAction()
  #5 /public_html/wcf/lib/action/AJAXInvokeAction.class.php(96): wcf\action\AJAXProxyAction->invoke()
  #6 /public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AJAXInvokeAction->execute()
  #7 /public_html/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
  #8 /public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
  #9 /public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
  #10 /public_html/filebase/index.php(10): wcf\system\request\RequestHandler->handle('filebase')
  #11 {main}

Display More

gn5VmUKCtv6ekrMf · September 3, 2015 at 6:36 PM

General error: 2006 MySQL server has gone aw
Ask your hoster...

Aslan · September 3, 2015 at 6:39 PM

It's not always cut and dry like that. 98 or 99% of the time it is hosting issue, but there is that 1 or 2% margin of error when it could be code.

Quote from MysteryCode

General error: 2006 MySQL server has gone aw
Ask your hoster...

vBulletin 5 is good example of code gone wrong.

In this case concerning WBB, the only thing I did was update. Before that all was working.

(I am of course checking with the host and will follow up)

Barungar · September 3, 2015 at 8:39 PM

It isn't a MariaDB database server, is it? Because MariaDB seems to causes many strange "DB crashs".

Aslan · September 3, 2015 at 11:05 PM

Quote from Barungar

It isn't a MariaDB database server, is it? Because MariaDB seems to causes many strange "DB crashs".

It is a MariaDB Server, but I've never had any issue with MariaDB.

That said... My host and I came to the conclusion that the issue appears to be WoltLab with MariaDB 10.0.21

MySQL Problem

I would think is more of a WoltLab issue as it does not affect Ip.Board, XenForo, vBulletin, phpBB, SMF, FluxBB, or any other forum software free or paid that I have encountered.

Morik · September 3, 2015 at 11:32 PM

It's a problem with the innoDB solution offered by mariadb...
The other softwares using MyISAM and this isn't affected by those random crashs.

Aslan · September 3, 2015 at 11:36 PM

Quote from Morik

It's a problem with the innoDB solution offered by mariadb...
The other softwares using MyISAM and this isn't affected by those random crashs.

Incorrect. The other software is using InnoDB.

Both Ip.Board and XenForo for example use InnoDB exclusively as does WoltLab. The issue is only with WoltLab.

Morik · September 3, 2015 at 11:40 PM

Interesting, but do they use foreignkeys with ondelete cascade ?
As far as i know they all run on both, myisam and innodb so i think they are not exclusivly optimized for innodb only like wbb

Aslan · September 3, 2015 at 11:42 PM

Quote from Morik

Interesting, but do they use foreignkeys with ondelete cascade ?
As far as i know they all run on both, myisam and innodb so i think they are not exclusivly optimized for innodb only like wbb

(By excluse I meant by default)

The only MyIsam tables are their search tables, everything else is InnoDB... which is the same with WoltLab.

Upon a fresh install of either IP.Board, XenForo, or WoltLab you will end up with all your tables in InnoDB format. Only WoltLab is having this issue with MariaDB.

Macondiana · September 3, 2015 at 11:43 PM

Are you self hosting the forum?

Thought you changed to shared hosting so why are you using MariaDB

Aslan · September 3, 2015 at 11:46 PM

Quote from GTB

Are you self hosting the forum?

Thought you changed to shared hosting so why are you using MariaDB

Shared host is using MariaDB. Even if I moved to a VPS or Dedicated, I too would be using MariaDB.

All of which is irrlevent to the problem.

Macondiana · September 3, 2015 at 11:49 PM

Quote from Aslan

All of which is irrlevent to the problem.

Sorry I spoke!

Morik · September 3, 2015 at 11:51 PM

Well the thing is its a bug with the version 10.0.21 of mariadb, using version 10.0.20 will solve your problems (which isn't possible by using a shared hosting, i know).
And i just think it has to do something with the foreign keys used by wbb to clean up all data when deleting anything within the software. I also thought that xenforo doesn't use those foreign keys with on delete cascade, but last time i'll checkt a xenforo db was with version 1.2 so maybe they have changed it...

Macondiana · September 3, 2015 at 11:53 PM

Could this linked to timeout setting be the issue.

https://www.drupal.org/node/1014172#comment-3899398

Aslan · September 3, 2015 at 11:54 PM

Quote from GTB

Sorry I spoke!

Apology accepted.

LOL

^ I'm only teasing you of course.

(I just don't want to get off topic or into debate about my hosting.)

Aslan · September 3, 2015 at 11:57 PM

NO.

Quote from GTB

Could this linked to timeout setting be the issue.

https://www.drupal.org/node/1014172#comment-3899398

No. Has nothing to do with it.

**Alexander Ebert** · September 3, 2015 at 11:59 PM Official Post

The issue came with MariaDB 10.0.21 and is a bug in that version, downgrading to 10.0.20 fixes it while you wait for the next update.

Aslan · September 4, 2015 at 12:01 AM

Quote from Alexander Ebert

The issue came with MariaDB 10.0.21 and is a bug in that version, downgrading to 10.0.20 fixes it while you wait for the next update.

The error is exclusive to WoltLab and downgrading is not possible.

Talking to MariaDB Development...

Quote

have them check their code before pointing fingers

**Alexander Ebert** · September 4, 2015 at 12:04 AM Official Post

The issue occurs in a specific query scenario and this bug is not present in any MySQL versions nor in any MariaDB version except for 10.0.21.

Error on delete

Participate now!

Similar Threads

Last step installatuion fail

Error when I delete a media provider

[Ready] Grammar Use & Punctuation: ACP - Community - Forums + General Areas + User Groups

Is there a way to limit the amount of media tags in a post?

Namespace declaration statement

ACP - Error when I try to delete an attachment