Gossamer Forum
Home : Products : Gossamer Links : Discussions :

MySQL crashes during reindex

Quote Reply
MySQL crashes during reindex
Hello!

I want to use INTERNAL indexing on my Links SQL sites. This works fine for my smaller site (2000 links/200 categories) but not my larger sites (30,000 links/3000 categories) as MySQL crashes partway through the reinidexing process.

Due to the large numbers of links, I run a reindex from telnet
Code:
perl nph-index.cgi --reindex
MySQL crashes after around 8,000 links have been indexed, and MySQL then needs to be restarted.

I have a dedicated server, PIII-900Mhz, 256MB RAM, 40GB IDE HD running Linux, Apache & MySQL 3.23.43.

Any ideas?

Many thanks,

Robert Gowans

ps. This is the error message:

Code:
[root@server1 admin]# perl nph-index.cgi --reindex
Started at Mon Dec 29 06:25:44 2003.

Reindexing Links SQL Database ...

47475 links.
1000 2000 3000 4000 5000 6000 7000 8000
Done!

Reindexing Category Database ... 0 categories.
Content-type: text/html

<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "fetchrow_arrayref" on an undefined value at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
Can't call method "fetchrow_arrayref" on an undefined value at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
DBI::db=HASH(0x8394698)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver.pm line 214.
[root@server1 admin]# perl nph-index.cgi --change-driver=NONINDEXED
Please be warned that this action may take an extended period of time to complete

Updating Links Table search driver...
Content-type: text/html

<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "prepare" without a package or object reference at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 36.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
Can't call method "prepare" without a package or object reference at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 36.
Quote Reply
Re: [mrrob] MySQL crashes during reindex In reply to
What error message do you get if you set debug to 2 in Setup > Misc ?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL crashes during reindex In reply to
Hi Andy,

This is the last part of the message.

Cheers

Rob









Code:
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'polished',
'loops',
'precious',
'gold',
'offer',
'just',
'right',
'touch',
'glamour',
'any',
'ensemble',
'gentle',
'curves',
'earring',
'formed',
'one',
'continuous',
'tube',
'14-karat',
'yellow',
'gold'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {
'are' => 'is a stopword',
'each' => 'is a stopword',
'of' => 'is a stopword',
'the' => 'is a stopword',
'to' => 'is a stopword',
'with' => 'is a stopword'
};
GT::SQL::Search::INTERNAL::Indexer (32466): Words: $VAR = [
'14-kt',
'yg',
'loop',
'earrings'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'14-kt',
'loop',
'earrings'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {
'yg' => 'is too small a word'
};
GT::SQL::Search::INTERNAL::Indexer (32466): Words: $VAR = [
'http',
'click',
'linksynergy',
'com',
'fs-bin',
'click',
'id',
'fbuo3u7nj1g',
'offerid',
'38611',
'180',
'type',
'14',
'subid',
'0',
'bnid',
'67746'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'click',
'linksynergy',
'fs-bin',
'click',
'fbuo3u7nj1g',
'offerid',
'38611',
'180',
'type',
'subid',
'bnid',
'67746'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {
'0' => 'is too small a word',
'14' => 'is too small a word',
'com' => 'is a stopword',
'http' => 'is a stopword',
'id' => 'is too small a word'
};
GT::SQL::Driver::MYSQL::sth (32466): Executing query: INSERT INTO lsql_Links_Word_List (Word, Frequency) VALUES (67746, 1)
GT::Base (32466): GT::SQL::Driver::MYSQL::sth::execute called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 273 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x84730c4), 67746, 1).
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x8454a3c), Links::Link=HASH(0x82fa400), HASH(0x844f2d8)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 149 with arguments
(Links::Link=HASH(0x82fa400), HASH(0x844f2d8)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.

GT::SQL::Search::INTERNAL::Indexer (32466): Words: $VAR = [
'give',
'your',
'jewelry',
'collection',
'an',
'update',
'with',
'these',
'14-karat',
'yellow',
'gold',
'hoop',
'earrings',
'a',
'swirling',
'scallop',
'pattern',
'cut',
'into',
'elegant',
'gold',
'makes',
'these',
'hoops',
'an',
'addition',
'you',
'won',
't',
'want',
'to',
'pass',
'up'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'give',
'jewelry',
'collection',
'update',
'14-karat',
'yellow',
'gold',
'hoop',
'earrings',
'swirling',
'scallop',
'pattern',
'cut',
'elegant',
'gold',
'makes',
'hoops',
'addition',
'won',
'want',
'pass'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {
'a' => 'is too small a word',
'an' => 'is a stopword',
'into' => 'is a stopword',
't' => 'is too small a word',
'these' => 'is a stopword',
'to' => 'is a stopword',
'up' => 'is too small a word',
'with' => 'is a stopword',
'you' => 'is a stopword',
'your' => 'is a stopword'
};
GT::SQL::Search::INTERNAL::Indexer (32466): Words: $VAR = [
'14-kt',
'scalloped',
'hoop',
'earrings'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'14-kt',
'scalloped',
'hoop',
'earrings'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {};
GT::SQL::Search::INTERNAL::Indexer (32466): Words: $VAR = [
'http',
'click',
'linksynergy',
'com',
'fs-bin',
'click',
'id',
'fbuo3u7nj1g',
'offerid',
'38611',
'180',
'type',
'14',
'subid',
'0',
'bnid',
'928054'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Accepted Words: $VAR = [
'click',
'linksynergy',
'fs-bin',
'click',
'fbuo3u7nj1g',
'offerid',
'38611',
'180',
'type',
'subid',
'bnid',
'928054'
];
GT::SQL::Search::INTERNAL::Indexer (32466): Rejected Words: $VAR = {
'0' => 'is too small a word',
'14' => 'is too small a word',
'com' => 'is a stopword',
'http' => 'is a stopword',
'id' => 'is too small a word'
};
GT::SQL::Driver::MYSQL::sth (32466): Executing query: INSERT INTO lsql_Links_Word_List (Word, Frequency) VALUES (928054, 1)
GT::Base (32466): GT::SQL::Driver::MYSQL::sth::execute called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 273 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x84730c4), 928054, 1).
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x8454a3c), Links::Link=HASH(0x82fa400), HASH(0x844f2d8)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 149 with arguments
(Links::Link=HASH(0x82fa400), HASH(0x844f2d8)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.

GT::SQL::Search::INTERNAL::Indexer (32466): CANTEXECUTE at GT::SQL::Table::reindex line 979.
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 149 with arguments
(Links::Link=HASH(0x82fa400), HASH(0x844f2d8)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.

Done!

Reindexing Category Database ... GT::SQL (32466): Creating new table object for lsql_Category at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 120.
GT::SQL::Table (32466): Loading state for lsql_Category at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 178.
GT::SQL::Table (32466): State loaded for lsql_Category at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 182.
GT::SQL::Driver::MYSQL (32466): Using stored connection: DBI:mysql:shopsavesmiledb-links:localhost at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver.pm line 77.
Links::Category (32466): Query: SELECT COUNT(*) FROM lsql_Category
GT::SQL::Driver::MYSQL (32466): Preparing query: SELECT COUNT(*) FROM lsql_Category at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
GT::SQL::Driver::MYSQL::sth (32466): Executing query: SELECT COUNT(*) FROM lsql_Category
GT::Base (32466): GT::SQL::Driver::MYSQL::sth::execute called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 950 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x84ce068)).
GT::Base (32466): GT::SQL::Table::do_query called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x849f5cc), SELECT COUNT(*) FROM lsql_Category , ARRAY(0x843d27c)).
GT::Base (32466): GT::SQL::Table::select called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 277 with arguments
(Links::Category=HASH(0x849f5cc), ARRAY(0x84c3834)).
GT::Base (32466): GT::SQL::Base::count called at nph-index.cgi line 155 with arguments
(Links::Category=HASH(0x849f5cc)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.

GT::SQL::Table (32466): Failed to execute query: 'SELECT COUNT(*) FROM lsql_Category ' Reason: MySQL server has gone away at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 117.
GT::Base (32466): GT::SQL::Table::do_query called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x849f5cc), SELECT COUNT(*) FROM lsql_Category , ARRAY(0x843d27c)).
GT::Base (32466): GT::SQL::Table::select called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 277 with arguments
(Links::Category=HASH(0x849f5cc), ARRAY(0x84c3834)).
GT::Base (32466): GT::SQL::Base::count called at nph-index.cgi line 155 with arguments
(Links::Category=HASH(0x849f5cc)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.
0 categories.
GT::SQL::Driver::MYSQL (32466): Preparing query: INSERT INTO lsql_Category_Word_List (Word, Frequency) VALUES (?, ?) at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
Links::Category (32466): Creating new table object for lsql_Category_Word_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 120.
GT::SQL::Table (32466): Loading state for lsql_Category_Word_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 178.
GT::SQL::Table (32466): State loaded for lsql_Category_Word_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 182.
Links::Category (32466): Creating new table object for lsql_Category_Score_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 120.
GT::SQL::Table (32466): Loading state for lsql_Category_Score_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 178.
GT::SQL::Table (32466): State loaded for lsql_Category_Score_List at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 182.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Word_List at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Word_List at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Frequency FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Frequency FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Word_ID, COUNT(*) FROM lsql_Category_Score_List WHERE Item_ID = ? GROUP BY Word_ID at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Word_ID, COUNT(*) FROM lsql_Category_Score_List WHERE Item_ID = ? GROUP BY Word_ID at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Score_List at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Score_List at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Score_List WHERE Item_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Score_List WHERE Item_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: INSERT INTO lsql_Category_Score_List (Word_ID, Item_ID, Score, Word_Pos) VALUES (?, ?, ?, ?) at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: INSERT INTO lsql_Category_Score_List (Word_ID, Item_ID, Score, Word_Pos) VALUES (?, ?, ?, ?) at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: UPDATE lsql_Category_Word_List SET Frequency = ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: UPDATE lsql_Category_Word_List SET Frequency = ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Word_ID,Word,Frequency FROM lsql_Category_Word_List WHERE Word = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Word_ID,Word,Frequency FROM lsql_Category_Word_List WHERE Word = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: UPDATE lsql_Category_Word_List SET Frequency = Frequency - ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: UPDATE lsql_Category_Word_List SET Frequency = Frequency - ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing query: INSERT INTO lsql_Category_Word_List (Word, Frequency) VALUES (?, ?) at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
Links::Category (32466): Returning table object for lsql_Category_Word_List from cache at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 116.
Links::Category (32466): Returning table object for lsql_Category_Score_List from cache at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Base.pm line 116.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Word_List at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Word_List at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Frequency FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Frequency FROM lsql_Category_Word_List WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Word_ID, COUNT(*) FROM lsql_Category_Score_List WHERE Item_ID = ? GROUP BY Word_ID at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Word_ID, COUNT(*) FROM lsql_Category_Score_List WHERE Item_ID = ? GROUP BY Word_ID at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Score_List at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Score_List at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: DELETE FROM lsql_Category_Score_List WHERE Item_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: DELETE FROM lsql_Category_Score_List WHERE Item_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: INSERT INTO lsql_Category_Score_List (Word_ID, Item_ID, Score, Word_Pos) VALUES (?, ?, ?, ?) at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: INSERT INTO lsql_Category_Score_List (Word_ID, Item_ID, Score, Word_Pos) VALUES (?, ?, ?, ?) at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: UPDATE lsql_Category_Word_List SET Frequency = ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: UPDATE lsql_Category_Word_List SET Frequency = ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: SELECT Word_ID,Word,Frequency FROM lsql_Category_Word_List WHERE Word = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: SELECT Word_ID,Word,Frequency FROM lsql_Category_Word_List WHERE Word = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Driver::MYSQL (32466): Preparing RAW query: UPDATE lsql_Category_Word_List SET Frequency = Frequency - ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 125.
GT::SQL::Driver::MYSQL (32466): RAW STH is prepared: UPDATE lsql_Category_Word_List SET Frequency = Frequency - ? WHERE Word_ID = ? at GT::SQL::Driver::prepare_raw line 127.
GT::SQL::Search::INTERNAL::Indexer (32466): CANTEXECUTE at GT::SQL::Table::reindex line 979.
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x84cfa6c), Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 171 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.
GT::SQL::Search::INTERNAL::Indexer (32466): CANTEXECUTE at GT::SQL::Table::reindex line 979.
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x84cfa6c), Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 171 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.
Links::Category (32466): Query: SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000
GT::SQL::Driver::MYSQL (32466): Preparing query: SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000 at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
GT::SQL::Driver::MYSQL::sth (32466): Executing query: SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000
GT::Base (32466): GT::SQL::Driver::MYSQL::sth::execute called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 950 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x84cdf90)).
GT::Base (32466): GT::SQL::Table::do_query called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x849f5cc), SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000, ARRAY(0x84cdf9c)).
GT::Base (32466): GT::SQL::Table::select called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 241 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84d8050), ARRAY(0x84d3028)).
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x84cfa6c), Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 171 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.

GT::SQL::Table (32466): Failed to execute query: 'SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000' Reason: MySQL server has gone away at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 117.
GT::Base (32466): GT::SQL::Table::do_query called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x849f5cc), SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000, ARRAY(0x84cdf9c)).
GT::Base (32466): GT::SQL::Table::select called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 241 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84d8050), ARRAY(0x84d3028)).
GT::Base (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x84cfa6c), Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): GT::SQL::Table::reindex called at nph-index.cgi line 171 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
GT::Base (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
GT::Base (32466): main::main called at nph-index.cgi line 28 with no arguments.
Content-type: text/html

<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "fetchrow_arrayref" on an undefined value at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
<PRE><B>Stack Trace</B>
======================================
Links (32466): Links::environment called at /home/virtual/site5/fst/var/www/cgi-bin/admin/Links.pm line 431 with no arguments.
Links (32466): Links::fatal called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244 with arguments
(Can't call method "fetchrow_arrayref" on an undefined value at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
).
Links (32466): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 979 with arguments
(GT::SQL::Search::INTERNAL::Indexer=HASH(0x84cfa6c), Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
Links (32466): GT::SQL::Table::reindex called at nph-index.cgi line 171 with arguments
(Links::Category=HASH(0x849f5cc), HASH(0x84cfae4)).
Links (32466): main::reindex called at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
Links (32466): GT::Plugins::dispatch called at nph-index.cgi line 40 with arguments
(GT::Plugins, /home/virtual/site5/fst/var/www/cgi-bin/admin/Plugins, reindex_database, CODE(0x823a0cc)).
Links (32466): main::main called at nph-index.cgi line 28 with no arguments.


<B>System Information</B>
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.2
DBI.pm Version: 1.21
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT ID,Description,Name FROM lsql_Category
LIMIT 0,10000' Reason: MySQL server has gone away
@INC =
/home/virtual/site5/fst/var/www/cgi-bin/admin
/usr/lib/perl5/5.6.1/i386-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.6.1/i386-linux
/usr/lib/perl5/vendor_perl/5.6.1
/usr/lib/perl5/vendor_perl
.

<B>ENVIRONMENT</B>
======================================
BASH_ENV => /root/.bashrc
GT_TMPDIR => /home/virtual/site5/fst/var/www/cgi-bin/admin/tmp
HISTSIZE => 1000
HOME => /root
HOSTNAME => server.server.com
INPUTRC => /etc/inputrc
LANG => en_US.iso885915
LESSOPEN => |/usr/bin/lesspipe.sh %s
LOGNAME => root
LS_COLORS => no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL => /var/spool/mail/root
OLDPWD => /home/virtual/website-name/var/www/cgi-bin
PATH => /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
PWD => /home/virtual/website-name/var/www/cgi-bin/admin
SHELL => /bin/bash
SHLVL => 1
SSH_CLIENT => 81.227.184.112 1649 22
SSH_TTY => /dev/pts/0
TERM => vt100
USER => root
USERNAME => root
_ => /usr/bin/perl
</PRE>Can't call method "fetchrow_arrayref" on an undefined value at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
DBI::db=HASH(0x838f6d0)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /home/virtual/site5/fst/var/www/cgi-bin/admin/GT/SQL/Driver.pm line 214.
[root@server admin]#
Quote Reply
Re: [mrrob] MySQL crashes during reindex In reply to
This looks like your problem;

Quote:
GT::SQL::error = Failed to execute query: 'SELECT ID,Description,Name FROM lsql_Category LIMIT 0,10000' Reason: MySQL server has gone away

Looks like MySQL is crashing or something Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL crashes during reindex In reply to
Yes, that's what I thought.

Here are my MySQL VARIABLES & STATUS - could there be something suspicous there? I'm no MySQL expert... Crazy

Cheers

Rob

Code:
mysql> show variables
-> ;
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_log_buffer_size | 32768 |
| bdb_home | /var/lib/mysql/ |
| bdb_max_lock | 10000 |
| bdb_logdir | |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (March 13, 2003) |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | YES |
| have_gemini | NO |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 0 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_mirrored_log_groups | 1 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_long_queries | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_recover_options | 0 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /var/run/mysqld/mysqld.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| record_rnd_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | EST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 3.23.56 |
| wait_timeout | 28800 |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+



Code:
mysql> show status
-> ;
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| Aborted_clients | 0 |
| Aborted_connects | 7 |
| Bytes_received | 201505 |
| Bytes_sent | 692828 |
| Com_admin_commands | 264 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 4 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 93 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 664 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 101 |
| Connections | 277 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 0 |
| Handler_read_first | 7 |
| Handler_read_key | 3149 |
| Handler_read_next | 96546 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 282102 |
| Handler_update | 101 |
| Handler_write | 93 |
| Key_blocks_used | 852 |
| Key_read_requests | 108002 |
| Key_reads | 829 |
| Key_write_requests | 232 |
| Key_writes | 232 |
| Max_used_connections | 1 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 13 |
| Open_files | 26 |
| Open_streams | 0 |
| Opened_tables | 19 |
| Questions | 1260 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 23 |
| Select_range_check | 0 |
| Select_scan | 25 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Table_locks_immediate | 1008 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 276 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 19716 |
+--------------------------+--------+
112 rows in set (0.00 sec)
Quote Reply
Re: [mrrob] MySQL crashes during reindex In reply to
Hi Rob,

Unfortunately, the problems with the mysql server going away (crashing) are some of the most difficult issues to solve so this may not be a quick fix to do.

There are a couple of things I can think of that may help and the cleanest one may be to upgrade the mysql version to latest 4.0 version and then changing the search driver from INTERNAL to MYSQL. That way, the amount of impact on the mysql server will be minimized and the search results will actually come up faster. The internal driver manages all the tables from within Links SQL and it generates a very large number of queries for indexing and for search, the MYSQL index driver sets up the proper text search indexes and relies on mysql to handle all the searching and indexing so no extra queries are needed for indexing and only one query ends up being required for searching.

Best Regards,
Aki
Quote Reply
Re: [mrrob] MySQL crashes during reindex In reply to
Hi Rob,

Do you think it would be possible to up the memory on the system at least temporarily? Everything seems to check out including your version of Mysql but, in trying to change the driver from NONINDEXED to MYSQL (the switch caused the error to appear faster than switching to INTERNAL), following the code, it would manage to add one FULLTEXT index to a table then on the next query it would fail.

Simulating the queries by hand using the mysql commandline tool (the "official" mysql client software) the same error occurred so I don't believe it's an issue with Links SQL.

Code:
mysql> create fulltext index ft_Description_URL on lsql_Links ( Description, URL );
create fulltext index ft_Title on lsql_Links ( Title );
ERROR 2013: Lost connection to MySQL server during query
mysql> create fulltext index ft_Title on lsql_Links ( Title );
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server

A couple of reasons could be causing this.

If the compiler used to create your copy of mysql was the same version as that on your server, it could also be a source of problems (version 2.96 has been reported to cause crashes / table corruption)

I have a feeling though, that it may be something to do with memory though I am not sure yet.

This is a bit of a shot in the dark still but hopefully this will be all that is required.

Another option could be host with us, Gossamer Host, where you would avoid these kinds of issues altogether and have access to the mysql v4 boolean fulltext searching which is considerably faster than internal for large databases.

Best Regards,
Aki
Quote Reply
Re: [Aki] MySQL crashes during reindex In reply to
Aki,

Many thanks for your help so far.

I've arranged for a 512MB memory upgrade, so I'll let you know how it goes once that has been installed.

Cheers

Rob
Quote Reply
Re: [mrrob] MySQL crashes during reindex In reply to
Hi Aki,

I tried running the reindex after the 512MB upgrade (768MB total) and it failed after 10,000 links.

The CPU utilization was high, whilst the memory usage appeared to be low.

Any ideas?

Many Thanks,

Rob