https://bugzilla.wikimedia.org/show_bug.cgi?id=33558

       Web browser: ---
             Bug #: 33558
           Summary: update.php stuck on update revision on large db
           Product: MediaWiki
           Version: 1.19-svn
          Platform: All
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Installation
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected]
    Classification: Unclassified


Hi, I am working on deployment.wmflabs.org together with Mark Herhberger

I imported full db of simple wiki there to mediawiki 1.18wmf1 using mwimport,
the wiki db was ok, however when I attempted to upgrade to latest head of svn,
the update.php stuck on updating rev_sha1 on revision table

the process is now running, but seems to be idle,

desc revision;
+----------------+---------------------+------+-----+----------------+----------------+
| Field          | Type                | Null | Key | Default        | Extra   
      |
+----------------+---------------------+------+-----+----------------+----------------+
| rev_id         | int(10) unsigned    | NO   | PRI | NULL           |
auto_increment |
| rev_page       | int(10) unsigned    | NO   | MUL | NULL           |         
      |
| rev_text_id    | int(10) unsigned    | NO   |     | NULL           |         
      |
| rev_comment    | tinyblob            | NO   |     | NULL           |         
      |
| rev_user       | int(10) unsigned    | NO   | MUL | 0              |         
      |
| rev_user_text  | varbinary(255)      | NO   | MUL |                |         
      |
| rev_timestamp  | binary(14)          | NO   | MUL |                |         
      |
| rev_minor_edit | tinyint(3) unsigned | NO   |     | 0              |         
      |
| rev_deleted    | tinyint(3) unsigned | NO   |     | 0              |         
      |
| rev_len        | int(10) unsigned    | YES  |     | NULL           |         
      |
| rev_parent_id  | int(10) unsigned    | YES  |     | NULL           |         
      |
+----------------+---------------------+------+-----+----------------+----------------+

it seems that update script didn't even start with generation of sha_1 keys for
some reason, when I tried this on smaller db I've seen the output after few
seconds, however on this db it stuck for some reason. Did anyone experienced
anything similar? is it a bug of update.php or there is a better way to convert
table

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to