[Mediawiki-l] Importing db dump created with pg_dump leads to mediawiki errors

Thomas Schweikle tps at vr-web.de
Thu Mar 31 11:01:20 UTC 2011 

Hi!

Moving a Mediawiki installation from one server to an other with

tar -cvpzf mediawiki.tgz /mediawiki
pg_dump -U adminuser -W -h database-host -f mediawiki.sql

on the new database server:

su - postgres
createdb wikidb
createuser wikidb
- none admin
- allow creation of databases
- disallow grants

psql:
alter role wikidb with password 'wikidbuserpass';
\q

then on the wikiserver:
psql -U adminuser -h databaseserver -W -f mediawiki.sql 2>&1\
  | tee dbimport.log

Only six errors:

psql:mediawiki.sql:1114: ERROR:\
  functiongin_extract_tsquery(pg_catalog.tsquery,\
  internal, smallint) does not exist
psql:mediawiki.sql:1117: ERROR:\
  operator class "gin_tsvector_ops" does not exist\
  for access method "gin"
psql:mediawiki.sql:1134: ERROR:\
  function gtsquery_consistent(bigint, internal,\
  integer) does not exist
psql:mediawiki.sql:1137: ERROR:\
  operator class "gist_tp_tsquery_ops" does not\
  exist for access method "gist"
psql:mediawiki.sql:1153: ERROR:\
  function gtsvector_consistent(pg_catalog.gtsvector,\
  internal, integer) does not exist
psql:mediawiki.sql:1156: ERROR:\
  operator class "gist_tsvector_ops" does not exist\
  for access method "gist"

IMHO these relations missing isn't fatal.

Next step: unpacking the mediawiki itself:
tar -xvzf mediawiki.tgz

Double checking all paths and configurations, then enabling the site
in apache2. All OK, no errors so far. Having moved "LocalConfig.php"
out of the way MediaWiki responds with its installation page.

Now moving "LocalConfig.php" to its place again, then accessing
our MediaWiki leads to:
Warning: pg_query(): Query failed: ERROR: relation "objectcache"
does not exist LINE 1: ...diaWikiBagOStuff::_doquery */
value,exptime FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"objectcache" does not exist LINE 1: ...tuff::_doquery 87.157.7.114
*/ value,exptime FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"objectcache" does not exist LINE 1: ...tuff::_doquery 87.157.7.114
*/ value,exptime FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"objectcache" does not exist LINE 1: ...MediaWikiBagOStuff::_doquery
87.157.7.114 */ FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"objectcache" does not exist LINE 1: ...tuff::_doquery 87.157.7.114
*/ value,exptime FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"objectcache" does not exist LINE 1: ...MediaWikiBagOStuff::_doquery
87.157.7.114 */ FROM objectcach... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 Warning: pg_query(): Query failed: ERROR: relation
"page" does not exist LINE 1: ...che::loadFromDB 87.157.7.114 */
page_title FROM page WHER... ^ in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php
on line 580 MediaWiki internal error.

Original exception: exception 'DBUnexpectedError' with message 'A
database error has occurred
Query: SELECT value,exptime FROM objectcache WHERE
keyname='wikiaa:messages:en'
Function: MediaWikiBagOStuff::_doquery
Error: 1 ERROR: relation "objectcache" does not exist
LINE 1: ...diaWikiBagOStuff::_doquery */ value,exptime FROM
objectcach...
^
' in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php:1063
Stack trace:
#0
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/Database.php(616):
DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT
value,ex...', 'MediaWikiBagOSt...', false)
#1
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/BagOStuff.php(454):
Database->query('SELECT value,ex...', 'MediaWikiBagOSt...')
#2
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/BagOStuff.php(324):
MediaWikiBagOStuff->_doquery('SELECT value,ex...')
#3
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/BagOStuff.php(240):
SqlBagOStuff->_query('SELECT value,ex...', 'wikiaa:messages...')
#4
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(245):
SqlBagOStuff->get('wikiaa:messages...')
#5
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(589):
MessageCache->load('en')
#6
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(526):
MessageCache->getMsgFromNamespace('Mainpage', 'en')
#7 [internal function]: MessageCache->get('mainpage', true, true)
#8
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/StubObject.php(58):
call_user_func_array(Array, Array)
#9
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/StubObject.php(76):
StubObject->_call('get', Array)
#10 [internal function]: StubObject->__call('get', Array)
#11
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(598):
StubObject->get('mainpage', true, true)
#12
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(563):
wfMsgGetKey('mainpage', true, true, true)
#13
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(511):
wfMsgReal('mainpage', Array, true, true)
#14
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Title.php(287):
wfMsgForContent('mainpage')
#15
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Wiki.php(110):
Title::newMainPage()
#16
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/index.php(60):
MediaWiki->checkInitialQueries(NULL, 'view')
#17 {main}

Exception caught inside exception handler: exception
'DBUnexpectedError' with message 'A database error has occurred
Query: SELECT page_title FROM page WHERE page_is_redirect = '0' AND
page_namespace = '8' AND (page_title not like '%%/%%') AND (page_len
> 10000)
Function: MessageCache::loadFromDB
Error: 1 ERROR: relation "page" does not exist
LINE 1: ...che::loadFromDB 87.157.7.114 */ page_title FROM page WHER...
^
' in
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/DatabasePostgres.php:1063
Stack trace:
#0
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/Database.php(616):
DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT
page_ti...', 'MessageCache::l...', false)
#1
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/db/Database.php(1026):
Database->query('SELECT page_ti...', 'MessageCache::l...')
#2
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(339):
Database->select('page', 'page_title', Array, 'MessageCache::l...')
#3
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(268):
MessageCache->loadFromDB('en')
#4
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(589):
MessageCache->load('en')
#5
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/MessageCache.php(526):
MessageCache->getMsgFromNamespace('Internalerror', 'en')
#6
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(598):
MessageCache->get('internalerror', true, false)
#7
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(563):
wfMsgGetKey('internalerror', true, false, true)
#8
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/GlobalFunctions.php(469):
wfMsgReal('internalerror', Array, true)
#9
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(114):
wfMsg('internalerror')
#10
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(204):
MWException->getPageTitle()
#11
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(167):
MWException->htmlHeader()
#12
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(186):
MWException->reportHTML()
#13
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(284):
MWException->report()
#14
/aiomundo/www/xompu.de_subfolders/wiki/mediawiki-1.15.1/includes/Exception.php(344):
wfReportException(Object(DBUnexpectedError))
#15 [internal function]: wfExceptionHandler(Object(DBUnexpectedError))
#16 {main}

Since no tool displays the relations and tables created importing
the database, I could only have a look at the dump: relation
"objectcache" just doesn't exist, as relation "page" does not exist
within the dump (used psql-commands \l, \d, \dt. The graphical tool
had similar problems).

Shall I treat this as an error of MediaWiki or as one related to
PostgreSQL. As far as I see pg_dump does dump the whole database
into a file called the way I did.


-- 
Thomas

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 219 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20110331/c099ebaa/attachment-0001.pgp

More information about the MediaWiki-l mailing list