[Mediawiki-l] MySQL memory error deleting article (long)

[Giuseppe Briotti]

Hi all... this is my first message on this list.

The Problem:
I created a wiki web site based on MediaWiki 1.10.1 and MySQL 4.1.22 
(with phpMyAdmin 2.8.1 and MySQL client: 4.1.10). It works fine, until 
some days ago, when I encountered a memory error removing some page.

I check for the query causing the error and tested it directly in 
phpMyAdmin: same result! "5: Out of memory (Needed 7938020 bytes)"

The SELECT works fine (it returns 3 records), but it result in error 
with INSERT INTO.

Any hints? What can I ask to ISP that host my web site?

TIA

Giuseppe Briotti



Information following:

Query
-------------------------------------------------------------------------
INSERT INTO `wiki_archive`
(ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp,
ar_minor_edit,ar_rev_id,ar_text_id,ar_text,ar_flags,ar_len)
SELECT page_namespace, page_title, rev_comment, rev_user, rev_user_text,
rev_timestamp, rev_minor_edit, rev_id, rev_text_id, '', '', rev_len
FROM `wiki_page`,`wiki_revision`
WHERE page_id = '424' AND (page_id = rev_page)


Table wiki_archive:
-------------------------------------------------------------------------
Field Type Null Default
ar_namespace int(11) No 0
ar_title varchar(255) No
ar_text mediumblob No
ar_comment tinyblob No
ar_user int(10) No 0
ar_user_text varchar(255) No
ar_timestamp var(14) No
ar_minor_edit tinyint(4) No 0
ar_flags tinyblob No
ar_rev_id int(10) Sì NULL
ar_text_id int(10) Sì NULL
ar_deleted tinyint(3) No 0
ar_len int(10) Sì NULL

Index:
Key name Type Card. Fields
name_title_timestamp INDEX 1 ar_namespace, ar_title, ar_timestamp

Space used:
Type Used
Data 296 Bytes
Index 3.072 Bytes
Total 3.368 Bytes


Table wiki_page
-------------------------------------------------------------------------
Field Type Null Default
page_id int(10) No
page_namespace int(11) No 0
page_title varchar(255) No
page_restrictions tinyblob No
page_counter bigint(20) No 0
page_is_redirect tinyint(3) No 0
page_is_new tinyint(3) No 0
page_random double No 0
page_touched var(14) No
page_latest int(10) No 0
page_len int(10) No 0

Index:
Key name Type Card. Fields
PRIMARY PRIMARY 442 page_id
name_title UNIQUE 442 page_namespace, page_title
page_random INDEX 442 page_random
page_len INDEX 147 page_len

Space used:
Type Used
Data 28.936 Bytes
Index 29.696 Bytes
Total 58.632 Bytes

Table wiki_revision
-------------------------------------------------------------------------
Field Type Null Default
rev_id int(10) No
rev_page int(10) No 0
rev_text_id int(10) No 0
rev_comment tinyblob No
rev_user int(10) No 0
rev_user_text varchar(255) No
rev_timestamp var(14) No
rev_minor_edit tinyint(3) No 0
rev_deleted tinyint(3) No 0
rev_len int(10) Sì NULL
rev_parent_id int(10) Sì NULL

Index:
Key name Type Card. Fields
PRIMARY PRIMARY 1274 rev_page, rev_id
rev_id UNIQUE 1274 rev_id
rev_timestamp INDEX 1274 rev_timestamp
page_timestamp INDEX 1274 rev_page, rev_timestamp
user_timestamp INDEX 1274 rev_user, rev_timestamp
usertext_timestamp INDEX 1274 rev_user_text, rev_timestamp

Space used:
Type Used
Data 91.496 Bytes
Index 142.336 Bytes
Total 233.832 Bytes

--

Giuseppe Briotti
g.briotti at mclink.it

"Alme Sol, curru nitido diem qui 
promis et celas aliusque et idem 
nasceris, possis nihil urbe Roma 
visere maius."
                        (Orazio)