Last modified: 2013-07-30 00:10:52 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T51531, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 49531 - MySQL Binary
MySQL Binary
Status: NEW
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.19
All All
: Low normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-06-13 15:47 UTC by Mark A. Hershberger
Modified: 2013-07-30 00:10 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Mark A. Hershberger 2013-06-13 15:47:10 UTC
From https://www.mediawiki.org/wiki/Thread:Project:Support_desk/Passthru%28%29/reply_%2812%29:

  When installing using MySQL/Binary Tables, my host times out and some db
  tables are not created, and after a page reload 1.19 gives some errors and
  don't finish.

The installer should detect this if it can and only allow UTF-8 installations.
Comment 1 Mark A. Hershberger 2013-06-14 11:31:43 UTC
Adding this since I think it is relevant and the original poster didn't want to set up an account here:

Tried another install of 1.19.7 using another table prefix inside same db...

(ENGINE=InnoDB, DEFAULT CHARSET=binary)

This time it didn't give error after the timeout (php-cgi.exe - The FastCGI process exceeded configured activity timeout) and finished without errors.

But can't browse the site, with error:

A database error has occurred. Did you forget to run maintenance/update.php after upgrading?
See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT lc_value FROM `ond_l10n_cache` WHERE lc_lang = 'pt-br' AND lc_key = 'deps' LIMIT 1
Function: LCStore_DB::get
Error: 1146 Table '<db name>.ond_l10n_cache' doesn't exist (<the crap db server>)

My solution is to use MyISAM as engine.

(ENGINE=MyISAM, DEFAULT CHARSET=binary)

It doesn't timeout or give errors during install. It creates more tables in DB (this indicates that after the timeout using InnoDB, the installer did not create all tables it should and also didn't inform about it).

Yesterday, I installed a 1.16.5 also using MyISAM, without a single error, not even needing to modify files. How can I trust 1.19 as I don't know what other error is hidden out there?
Comment 2 Chad H. 2013-06-14 11:38:09 UTC
(In reply to comment #1)
> My solution is to use MyISAM as engine.
> 

MyISAM is never a solution, just another problem.

If InnoDB install is broken, then use Sqlite is a far better solution. But I'm curious why it doesn't work for InnoDB.
Comment 3 Mark A. Hershberger 2013-06-14 11:59:13 UTC
(In reply to comment #2)
>  But I'm
> curious why it doesn't work for InnoDB.

I am, too.  Could you follow up on the thread to see if he can provide more information?

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links