Yup, MySQL has been shut off because in it's new incarnation (we moved from
5.1 to 5.7) it consumes all of the memory and swap on the VM in as little
as 5 minutes killing the VM in the process. Until we can reign-in the
consumption, it's either the forums or the whole site. :(
On Nov 10, 2016 8:05 PM, "Be" <b...@gmx.com> wrote:
> Something's going wrong with MySQL. The static part of the website and the
> wiki are back, but the forums show this error:
>
> SQL ERROR [ mysqli ]
>
> No such file or directory [2002]
>
> BACKTRACE
>
> FILE: (not given by php)
> LINE: (not given by php)
> CALL: msg_handler()
>
> FILE: [ROOT]/includes/db/dbal.php
> LINE: 757
> CALL: trigger_error()
>
> FILE: [ROOT]/includes/db/mysqli.php
> LINE: 97
> CALL: dbal->sql_error()
>
> FILE: [ROOT]/common.php
> LINE: 108
> CALL: dbal_mysqli->sql_connect()
>
> FILE: [ROOT]/index.php
> LINE: 20
> CALL: include('[ROOT]/common.php')
>
>
> On 11/10/2016 02:03 PM, Garth Dahlstrom wrote:
>
>> Yep, it's dead again... Is it just me or does it look like mysql is
>> eating all of the memory + swap?
>>
>>
>>
>>
>>
>> On Thu, Nov 10, 2016 at 2:56 PM, Be <b...@gmx.com <mailto:b...@gmx.com>>
>> wrote:
>>
>> I see a 502 Bad Gateway error page from Cloudways now for all parts of
>> mixxx.org <http://mixxx.org>.
>>
>> On 11/10/2016 09:06 AM, Garth Dahlstrom wrote:
>> > Kernel has been updated from 4.4.0.45 to 4.4.0.47, RAM increased
>> from
>> > 768MB to 1GB, and a second virtual cpu has been added to the VM...
>> > It's back up and running for now. :\
>> >
>> > On Thu, Nov 10, 2016 at 9:36 AM, Garth Dahlstrom <ga...@mixxx.org
>> <mailto:ga...@mixxx.org>
>> > <mailto:ga...@mixxx.org <mailto:ga...@mixxx.org>>> wrote:
>> >
>> > New machine ran out of memory again... I applied tuning
>> settings
>> > from the previous server to MySQL and Apache last night, looks
>> like
>> > those settings might need to change for 16.04. Restarting it
>> now.
>> >
>> > On Thu, Nov 10, 2016 at 6:10 AM, S.Brandt <s.bra...@mixxx.org
>> <mailto:s.bra...@mixxx.org>
>> > <mailto:s.bra...@mixxx.org <mailto:s.bra...@mixxx.org>>> wrote:
>> >
>> > All down, throws 502 error.
>> >
>> > Previously there was forum error 757
>> >
>> > ``
>> > General Error
>> > SQL ERROR [ mysqli ]
>> >
>> > Expression #1 of SELECT list is not in GROUP BY clause and
>> > contains nonaggregated column 'phpbb.p.post_id' which is not
>> > functionally dependent on columns in GROUP BY clause; this
>> is
>> > incompatible with sql_mode=only_full_group_by [1055]
>> >
>> > SQL
>> >
>> > SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM
>> phpbb_topics
>> > t, phpbb_posts p WHERE p.poster_id = '11164' AND
>> p.post_approved
>> > = 1 AND t.topic_id = p.topic_id GROUP BY t.topic_id,
>> > t.topic_last_post_time ORDER BY t.topic_last_post_time DESC
>> >
>> > BACKTRACE
>> >
>> > FILE: (not given by php)
>> > LINE: (not given by php)
>> > CALL: msg_handler()
>> >
>> > FILE: [ROOT]/includes/db/dbal.php
>> > LINE: 757
>> > CALL: trigger_error()
>> >
>> > FILE: [ROOT]/includes/db/mysqli.php
>> > LINE: 182
>> > CALL: dbal->sql_error()
>> >
>> > FILE: [ROOT]/includes/search/fulltext_native.php
>> > LINE: 1009
>> > CALL: dbal_mysqli->sql_query()
>> >
>> > FILE: [ROOT]/search.php
>> > LINE: 540
>> > CALL: fulltext_native->author_search
>> > `
>> >
>> > > On Nov 9, 2016, at 22:59, RJ Ryan <rr...@mixxx.org
>> <mailto:rr...@mixxx.org> <mailto:rr...@mixxx.org
>> <mailto:rr...@mixxx.org>>> wrote:
>> > >
>> > > Huge thanks to Garth for upgrading the Mixxx website to a
>> modern OS!
>> > >
>> > > Things might be broken -- if you see any bugs or missing
>> data, please let us know (today's forum outage was unrelated).
>> > >
>> > -----------------------------------------------------------
>> -------------------
>> >
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------
>> ------------------
>> > Developer Access Program for Intel Xeon Phi Processors
>> > Access to Intel Xeon Phi processor-based developer platforms.
>> > With one year of Intel Parallel Studio XE.
>> > Training and support from Colfax.
>> > Order your platform today. http://sdm.link/xeonphi
>> >
>> >
>> >
>> > _______________________________________________
>> > Get Mixxx, the #1 Free MP3 DJ Mixing software Today
>> > http://mixxx.org
>> >
>> >
>> > Mixxx-devel mailing list
>> > Mixxx-devel@lists.sourceforge.net
>> <mailto:Mixxx-devel@lists.sourceforge.net>
>> > https://lists.sourceforge.net/lists/listinfo/mixxx-devel
>> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
>> >
>>
>> ------------------------------------------------------------
>> ------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today. http://sdm.link/xeonphi
>> _______________________________________________
>> Get Mixxx, the #1 Free MP3 DJ Mixing software Today
>> http://mixxx.org
>>
>>
>> Mixxx-devel mailing list
>> Mixxx-devel@lists.sourceforge.net
>> <mailto:Mixxx-devel@lists.sourceforge.net>
>> https://lists.sourceforge.net/lists/listinfo/mixxx-devel
>> <https://lists.sourceforge.net/lists/listinfo/mixxx-devel>
>>
>>
>>
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Get Mixxx, the #1 Free MP3 DJ Mixing software Today
http://mixxx.org
Mixxx-devel mailing list
Mixxx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mixxx-devel
