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
