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(a)mclink.it
"Alme Sol, curru nitido diem qui
promis et celas aliusque et idem
nasceris, possis nihil urbe Roma
visere maius."
(Orazio)