scj_1to2_db_converter

admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

везде одно и тоже

Mysql error 2006: MySQL server has gone away (WARNING:: Mysql is overloaded, take a look at your server perfomance)

вас наверняка перегружен винт
Don't forget to run script update
Axcel
Posts: 1403
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

т.е. один смарт конверчу, ок, другой - винт перегружен, и всегда в одном месте
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

а попробуйте руками

select * from outrules

проходит запрос?
Don't forget to run script update
Axcel
Posts: 1403
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

MariaDB [(none)]> use axcel_s57;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [axcel_s57]> select * from outrules;
Empty set (0.00 sec)

MariaDB [axcel_s57]>
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

уверен на 99% что проблема в нагрузке винта
но я понимаю что вы все равно так не поверите
скидывайте шел и что конвертить, я сам запущу
Don't forget to run script update
Axcel
Posts: 1403
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

Отправил данные в ПМ.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

добавил workaround
Don't forget to run script update
Axcel
Posts: 1403
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

Всё заработало, спасибо!
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: scj_1to2_db_converter

Post by admin »

отлично)
Don't forget to run script update
Axcel
Posts: 1403
Joined: Sun Dec 09, 2012 12:43 pm

Re: scj_1to2_db_converter

Post by Axcel »

конвертировал слейв, не получается подцепиться к мастеру:

already_linked
Fatal error: Uncaught exception 'Exception' with message 'No DB connection (db_link) ( /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/libs/sessions.class.php (93) <= /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/libs/sessions.class.php (37) <= () <= )' in /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/db_modules/mysql.php:163 Stack trace: #0 /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/libs/sessions.class.php(93): db_query('REPLACE INTO `a...') #1 [internal function]: Session->write('h3q41oiqlqsc2jr...', '') #2 /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/libs/sessions.class.php(37): session_write_close() #3 [internal function]: Session->__destruct() #4 {main} thrown in /home/axcel/web/MY_DOMAIN.com/public_html/scj2/includes/db_modules/mysql.php on line 163
Post Reply