DreamOn

March 19, 2021

15 hours ago, CoffeeCake said:

Have you followed this?

https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/

Have you checked your hardware? Failing disk perhaps?

That's not a particularly large query and queries should never crash your database daemon.

Have you checked your disk for corruption/failure?

The problem appears both on prod and local environments.

9 hours ago, shiobi said:

I'm having the same problem!! I thought there was a problem with my current MariaDB installation. I had to disable Unread Activity Stream to solve this temporarily.

I am using MariaDB 10.5.9.

Good to see I'm not alone!

shiobi · March 18, 2021

3 minutes ago, CoffeeCake said:

MySQL is crashing? How do you know?

See: https://dev.mysql.com/doc/refman/8.0/en/gone-away.html

Because after the crash, MySQL restart, the site is down during 5 seconds the time that MySQL restarted completely.

Here are the MySQL logs:

Mar 18 15:07:06 sd-135083 mariadbd[16352]: 210318 14:07:06 [ERROR] mysqld got signal 11 ;
Mar 18 15:07:06 sd-135083 mariadbd[16352]: This could be because you hit a bug. It is also possible that this binary
Mar 18 15:07:06 sd-135083 mariadbd[16352]: or one of the libraries it was linked against is corrupt, improperly built,
Mar 18 15:07:06 sd-135083 mariadbd[16352]: or misconfigured. This error can also be caused by malfunctioning hardware.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Mar 18 15:07:06 sd-135083 mariadbd[16352]: We will try our best to scrape up some info that will hopefully help
Mar 18 15:07:06 sd-135083 mariadbd[16352]: diagnose the problem, but since we have already crashed,
Mar 18 15:07:06 sd-135083 mariadbd[16352]: something is definitely wrong and this may fail.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Server version: 10.5.9-MariaDB-1:10.5.9+maria~buster
Mar 18 15:07:06 sd-135083 mariadbd[16352]: key_buffer_size=134217728
Mar 18 15:07:06 sd-135083 mariadbd[16352]: read_buffer_size=131072
Mar 18 15:07:06 sd-135083 mariadbd[16352]: max_used_connections=16
Mar 18 15:07:06 sd-135083 mariadbd[16352]: max_threads=153
Mar 18 15:07:06 sd-135083 mariadbd[16352]: thread_count=16
Mar 18 15:07:06 sd-135083 mariadbd[16352]: It is possible that mysqld could use up to
Mar 18 15:07:06 sd-135083 mariadbd[16352]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467864 K  bytes of memory
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Hope that's ok; if not, decrease some variables in the equation.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Thread pointer: 0x7f24540128c8
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Attempting backtrace. You can use the following information to find out
Mar 18 15:07:06 sd-135083 mariadbd[16352]: where mysqld died. If you see no messages after this, something went
Mar 18 15:07:06 sd-135083 mariadbd[16352]: terribly wrong...
Mar 18 15:07:06 sd-135083 mariadbd[16352]: stack_bottom = 0x7f249b153d58 thread_stack 0x49000
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(my_print_stacktrace)[0x55bba07c815e]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(handle_fatal_signal)[0x55bba0255895]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(__restore_rt)[0x7f28bf618730]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(Type_handler_newdecimal::calc_pack_length(unsigned int) const)[0x55bb9ff0f6b8]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SEL_ARG::tree_delete(SEL_ARG*))[0x55bba0378ae3]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SEL_ARG::tree_delete(SEL_ARG*))[0x55bba0379163]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SEL_IMERGE::and_sel_tree(RANGE_OPT_PARAM*, SEL_TREE*, SEL_IMERGE*))[0x55bba0379519]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SEL_IMERGE::and_sel_tree(RANGE_OPT_PARAM*, SEL_TREE*, SEL_IMERGE*))[0x55bba03796b4]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SEL_IMERGE::and_sel_tree(RANGE_OPT_PARAM*, SEL_TREE*, SEL_IMERGE*))[0x55bba037984b]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(Item_cond_and::get_mm_tree(RANGE_OPT_PARAM*, Item**))[0x55bba0379c6a]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x55bba037be9f]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(JOIN::optimize_inner())[0x55bba00bf87f]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(JOIN::optimize())[0x55bba00c03b3]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55bba00c0477]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55bba00c0d6e]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(LEX::mark_first_table_as_inserting())[0x55bba005e381]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(mysql_execute_command(THD*))[0x55bba0067496]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(Prepared_statement::execute(String*, bool))[0x55bba007b345]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55bba007b502]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(Prepared_statement::execute_bulk_loop(String*, bool, unsigned char*, unsigned char*))[0x55bba007bfc5]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55bba007c12b]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bba0064151]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(do_command(THD*))[0x55bba0065654]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x55bba0155b71]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(handle_one_connection)[0x55bba0155f0d]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55bba047e74b]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(start_thread)[0x7f28bf60dfa3]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: ??:0(clone)[0x7f28beb034cf]
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Trying to get some variables.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Some pointers may be invalid and cause the dump to abort.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Query (0x7f245405b2c8): /*community_xxx_net_production::community_xxx_net::IPS\Content\Search\Mysql\_Query::search:360*/ SELECT main.* FROM `ips_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class=? OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) ) AND ( ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) AND index_is_last_comment=1 ) OR ( index_class=? AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND index_is_last_comment=1 ) ) AND ( ( ( index_class IN('IPS\\forums\\Topic','IPS\\forums\\Topic\\Post') ) AND (( index_container_id=5 AND index_date_updated > 1516188909) OR ( index_container_id=6 AND index_date_updated > 1516188909) OR ( index_container_id=7 AND index_date_updated > 1516188909) OR ( index_container_id=8 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1516188909) OR ( index_container_id=11 AND index_date_updated > 1516188909) OR ( index_container_id=12 AND index_date_updated > 1516188909) OR ( index_container_id=13 AND index_date_updated > 1516478902) OR ( index_container_id=14 AND index_date_updated > 1516188909) OR ( index_container_id=16 AND index_date_updated > 1516188909) OR ( index_container_id=17 AND index_date_updated > 1516188909) OR ( index_container_id=18 AND index_date_updated > 1516188909) OR ( index_container_id=19 AND index_date_updated > 1516188909) OR ( index_container_id=20 AND index_date_updated > 1516188909) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(5,6,7,8,9,11,12,13,14,16,17,18,19,20) ) )) AND ( index_item_id NOT IN (2768,7789,7816,7897,8096,8865,9752,10654,10814,11525,11537,11656,11662,11680,11691,11699,11707,11724,11728,11731,11740,11760,11771,11774,11776,11799,11820,11822,11824,11834,11857,11889,11892,11893,11899,11905,11933,11937,11955,11963,11974,11975,11985,11986,11991,11995,12014,12021,12036,12040,12044,12045,12053,12076,12082,12083,12088,12091,12092,12093,12094,12104,12112,12117,12123,12129,12132,12139,12156,12157,12163,12168,12169,12170,12171,12176,12181,12184,12186,12187,12188,12193,12204,12206,12209,12214,12219,12220,12221,12224,12235,12237,12241,12243,12247,12248,12249,12271,12295,12302,12313,12323,12333,12339,12366,12372,12374,12376,12378,12379,12380,12382,12383,12384,12396,12407,12415,12421,12424,12425,12431,12434,12439,12442,12446,12448,12453,12455,12460,12475,12479,12481,12482,12503,12547,12550,12555,12559,12560,12561,12564,12567,12571,12572,12575,12576,12578,12585,12591,12592,12595,12602,12604,12605,12616,12617,12637,12645,12651,12652,12655,12659,12660,12672,12673,12674,12692,12704,12713,12715,12725,12752,12753,12755,12764,12770,12778,12785,12787,12789,12794,12796,12804,12805,12807,12809,12810,12822,12836,12855,12874,12875,12885,12901,12902,12911,12916,12920,12934,12939,12951,12968,12973,13002,13005,13008,13013,13028,13030,13044,13047,13055,13064,13075,13079,13117,13120,13125,13130,13134,13136,13137,13148,13184,13216,13222,13246,13248,13256,13265,13267,13268,13280,13281,13286,13294,13310,13313,13320,13321,13338,13340,13353,13357,13359,13362,13366,13370,13373,13377,13384,13403,13408,13428,13450,13477,13483,13500,13510,13519,13520,13528,13532,13534,13558,13605,13607,13614,13616,13618,13633,13634,13643,13664,13699,13707,13716,13721,13723,13753,13757,13763,13778,13779,13807,13811,13822,13835) ) ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND (( index_container_id=1 AND index_date_updated > 1516188909) OR ( index_container_id=3 AND index_date_updated > 1579780331) OR ( index_container_id=5 AND index_date_updated > 1516188909) OR ( index_container_id=6 AND index_date_updated > 1603212814) OR ( index_container_id=7 AND index_date_updated > 1516188909) OR ( index_container_id=8 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1599467191) OR ( index_container_id=10 AND index_date_updated > 1599144351) OR ( index_container_id=11 AND index_date_updated > 1585992440) OR ( index_container_id=14 AND index_date_updated > 1594651097) OR ( index_container_id=17 AND index_date_updated > 1596532823) OR ( index_container_id=27 AND index_date_updated > 1516188909) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(1,3,5,6,7,8,9,10,11,14,17,27) ) )) AND ( index_item_id NOT IN (12,27,53,3,119,14,72,139,138,144,147,35,39,41,46,57,59,61,63,71,73,75,99,25,110) ) ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND (( index_container_id=1 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1516188909) OR ( index_container_id=11 AND index_date_updated > 1516188909) OR ( index_container_id=12 AND index_date_updated > 1516188909) OR ( index_container_id=14 AND index_date_updated > 1516188909) OR ( index_container_id=15 AND index_date_updated > 1516188909) OR ( index_container_id=16 AND index_date_updated > 1516188909) OR ( index_container_id=20 AND index_date_updated > 1516188909) OR ( index_container_id=24 AND index_date_updated > 1516188909) OR ( index_container_id=25 AND index_date_updated > 1516188909) OR ( index_container_id=26 AND index_date_updated > 1516188909) OR ( index_container_id=31 AND index_date_updated > 1613304577) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(1,9,11,12,14,15,16,20,24,25,26,31) ) )) AND ( index_item_id NOT IN (5,8,10,13,45,51,67,76,84,88,89,94,102) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(3,index_permissions) OR FIND_IN_SET('m19519',index_permissions) ) ) AND index_hidden=? AND index_date_updated>? ORDER BY index_date_commented DESC LIMIT 0,25
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Connection ID (thread ID): 39596
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Status: NOT_KILLED
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
Mar 18 15:07:06 sd-135083 mariadbd[16352]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Mar 18 15:07:06 sd-135083 mariadbd[16352]: information that should help you find out what is causing the crash.
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Writing a core file...
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Working directory at /var/lib/mysql
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Resource Limits:
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Limit                     Soft Limit           Hard Limit           Units
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max cpu time              unlimited            unlimited            seconds
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max file size             unlimited            unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max data size             unlimited            unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max stack size            8388608              unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max core file size        0                    unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max resident set          unlimited            unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max processes             128375               128375               processes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max open files            100000               100000               files
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max locked memory         65536                65536                bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max address space         unlimited            unlimited            bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max file locks            unlimited            unlimited            locks
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max pending signals       128375               128375               signals
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max msgqueue size         819200               819200               bytes
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max nice priority         0                    0
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max realtime priority     0                    0
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Max realtime timeout      unlimited            unlimited            us
Mar 18 15:07:06 sd-135083 mariadbd[16352]: Core pattern: core
Mar 18 15:07:06 sd-135083 kernel: [8909720.734022] mariadbd[16506]: segfault at 68 ip 000055bb9ff0f6b8 sp 00007f249b14fc70 error 4 in mariadbd[55bb9ff01000+972000]Mar 18 15:07:06 sd-135083 kernel: [8909720.734026] Code: 05 e8 ec ce 28 00 48 8b 7d 90 48 85 ff 74 0b 80 7d a0 00 75 05 e8 d8 ce 28 00 48 89 df e8 10 0a 96 00 48 c7 43 58 00 00 00 00 <8b> 04 25 68 00 00 00 0f 0b 90 48 83 c2 01 75 10 e8 a3 2b ff ff 48
Mar 18 15:07:06 sd-135083 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Mar 18 15:07:06 sd-135083 systemd[1]: mariadb.service: Failed with result 'signal'.
Mar 18 15:07:11 sd-135083 systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Mar 18 15:07:11 sd-135083 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 10.
Mar 18 15:07:11 sd-135083 systemd[1]: Stopped MariaDB 10.5.9 database server.
Mar 18 15:07:11 sd-135083 systemd[1]: Starting MariaDB 10.5.9 database server...
[...]

The request causing this crash is huge:

Quote

SELECT main.* FROM `ips_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class=? OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) ) AND ( ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) AND index_is_last_comment=1 ) OR ( index_class=? AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND index_is_last_comment=1 ) ) AND ( ( ( index_class IN('IPS\\forums\\Topic','IPS\\forums\\Topic\\Post') ) AND (( index_container_id=5 AND index_date_updated > 1516188909) OR ( index_container_id=6 AND index_date_updated > 1516188909) OR ( index_container_id=7 AND index_date_updated > 1516188909) OR ( index_container_id=8 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1516188909) OR ( index_container_id=11 AND index_date_updated > 1516188909) OR ( index_container_id=12 AND index_date_updated > 1516188909) OR ( index_container_id=13 AND index_date_updated > 1516478902) OR ( index_container_id=14 AND index_date_updated > 1516188909) OR ( index_container_id=16 AND index_date_updated > 1516188909) OR ( index_container_id=17 AND index_date_updated > 1516188909) OR ( index_container_id=18 AND index_date_updated > 1516188909) OR ( index_container_id=19 AND index_date_updated > 1516188909) OR ( index_container_id=20 AND index_date_updated > 1516188909) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(5,6,7,8,9,11,12,13,14,16,17,18,19,20) ) )) AND ( index_item_id NOT IN (2768,7789,7816,7897,8096,8865,9752,10654,10814,11525,11537,11656,11662,11680,11691,11699,11707,11724,11728,11731,11740,11760,11771,11774,11776,11799,11820,11822,11824,11834,11857,11889,11892,11893,11899,11905,11933,11937,11955,11963,11974,11975,11985,11986,11991,11995,12014,12021,12036,12040,12044,12045,12053,12076,12082,12083,12088,12091,12092,12093,12094,12104,12112,12117,12123,12129,12132,12139,12156,12157,12163,12168,12169,12170,12171,12176,12181,12184,12186,12187,12188,12193,12204,12206,12209,12214,12219,12220,12221,12224,12235,12237,12241,12243,12247,12248,12249,12271,12295,12302,12313,12323,12333,12339,12366,12372,12374,12376,12378,12379,12380,12382,12383,12384,12396,12407,12415,12421,12424,12425,12431,12434,12439,12442,12446,12448,12453,12455,12460,12475,12479,12481,12482,12503,12547,12550,12555,12559,12560,12561,12564,12567,12571,12572,12575,12576,12578,12585,12591,12592,12595,12602,12604,12605,12616,12617,12637,12645,12651,12652,12655,12659,12660,12672,12673,12674,12692,12704,12713,12715,12725,12752,12753,12755,12764,12770,12778,12785,12787,12789,12794,12796,12804,12805,12807,12809,12810,12822,12836,12855,12874,12875,12885,12901,12902,12911,12916,12920,12934,12939,12951,12968,12973,13002,13005,13008,13013,13028,13030,13044,13047,13055,13064,13075,13079,13117,13120,13125,13130,13134,13136,13137,13148,13184,13216,13222,13246,13248,13256,13265,13267,13268,13280,13281,13286,13294,13310,13313,13320,13321,13338,13340,13353,13357,13359,13362,13366,13370,13373,13377,13384,13403,13408,13428,13450,13477,13483,13500,13510,13519,13520,13528,13532,13534,13558,13605,13607,13614,13616,13618,13633,13634,13643,13664,13699,13707,13716,13721,13723,13753,13757,13763,13778,13779,13807,13811,13822,13835) ) ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND (( index_container_id=1 AND index_date_updated > 1516188909) OR ( index_container_id=3 AND index_date_updated > 1579780331) OR ( index_container_id=5 AND index_date_updated > 1516188909) OR ( index_container_id=6 AND index_date_updated > 1603212814) OR ( index_container_id=7 AND index_date_updated > 1516188909) OR ( index_container_id=8 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1599467191) OR ( index_container_id=10 AND index_date_updated > 1599144351) OR ( index_container_id=11 AND index_date_updated > 1585992440) OR ( index_container_id=14 AND index_date_updated > 1594651097) OR ( index_container_id=17 AND index_date_updated > 1596532823) OR ( index_container_id=27 AND index_date_updated > 1516188909) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(1,3,5,6,7,8,9,10,11,14,17,27) ) )) AND ( index_item_id NOT IN (12,27,53,3,119,14,72,139,138,144,147,35,39,41,46,57,59,61,63,71,73,75,99,25,110) ) ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND (( index_container_id=1 AND index_date_updated > 1516188909) OR ( index_container_id=9 AND index_date_updated > 1516188909) OR ( index_container_id=11 AND index_date_updated > 1516188909) OR ( index_container_id=12 AND index_date_updated > 1516188909) OR ( index_container_id=14 AND index_date_updated > 1516188909) OR ( index_container_id=15 AND index_date_updated > 1516188909) OR ( index_container_id=16 AND index_date_updated > 1516188909) OR ( index_container_id=20 AND index_date_updated > 1516188909) OR ( index_container_id=24 AND index_date_updated > 1516188909) OR ( index_container_id=25 AND index_date_updated > 1516188909) OR ( index_container_id=26 AND index_date_updated > 1516188909) OR ( index_container_id=31 AND index_date_updated > 1613304577) OR ( index_date_updated > 1516188909 AND ( index_container_id NOT IN(1,9,11,12,14,15,16,20,24,25,26,31) ) )) AND ( index_item_id NOT IN (5,8,10,13,45,51,67,76,84,88,89,94,102) ) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(3,index_permissions) OR FIND_IN_SET('m19519',index_permissions) ) ) AND index_hidden=? AND index_date_updated>? ORDER BY index_date_commented DESC LIMIT 0,25

😯

shiobi · March 18, 2021

2 hours ago, CoffeeCake said:

Your server is likely underpowered and/or needs its configurations optimized. MySQL server goes away errors are typically related to timeouts. Timeouts happen when things take too long, and things take too long when they're not optimized or overloaded. You may consider using elasticsearch instead of MySQL for searches if the size of your community makes sense for that.

Work with your web host to diagnose or take a look at some of the third-party providers that do this work for you if you cannot.

https://invisioncommunity.com/third-party/providers/

Thanks for help.

Server is OK, Xeon E3, RAM 32 GB, SSD...

MySQL crashes after only 2 seconds, while timeout is much more.

It's very weird.

shiobi · March 18, 2021

Hello,

With my admin account, MySQL crashes when I want to access to mysite.com/discover/unread:

MySQL server has gone away

2021/03/18 10:59:23 [error] 3683#3683: *8384 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught IPS\Db\Exception: MySQL server has gone away in /srv/www/community.xxx.net/current/web/ips/system/Db/Db.php:638
Stack trace:
#0 /srv/www/community.xxx.net/current/web/ips/system/Db/Db.php(948): IPS\_Db->preparedQuery('/*community_lec...', Array)
#1 /srv/www/community.xxx.net/current/web/ips/system/Session/Store/Database.php(77): IPS\_Db->insert('core_sessions', Array, true)
#2 /srv/www/community.xxx.net/current/web/ips/system/Session/Front.php(369): IPS\Session\Store\_Database->updateSession(Array)
#3 [internal function]: IPS\Session\_Front->write('d1065fa5b910835...', '')
#4 [internal function]: session_write_close()
#5 {main}
  thrown in /srv/www/community.xxx.net/current/web/ips/system/Db/Db.php on line 638PHP message: PHP Stack trace:PHP message: PHP   1. IPS\IPS::exceptionHandler($exception = class IPS\Db\Exception { public $query = 'SELECT main.* FROM `ips_core_search_index` AS `main` WHERE ( ( index_class IN(\'IPS\\\\core\\\\Statuses\\\\Status\',\'IPS\\\\core\\\\Statuses\\\\Reply\') ) OR index_class=? OR ( index_class IN(\'IPS\\\\blog\\\\Entry\',\'IPS\\\\blog\\\\Entry\\\\Comment\') ) OR ( index_class IN(\'IPS\\\\downloads\\\\File\',\'IPS\\\\downloads\\\\File\\\\Comment\',\'IPS\\\\downloads\\\\File\\\\Review\') ) OR index_class=? ) AND ( ( ( index_class IN(\'IPS\\\\core\\\\Statuses\\\\Status\',\'IPS\\\\core\\\\Statuses\\\\Reply\') ) AN'; public $binds = [0 => 'IPS\\forums\\Topic\\Post', 1 => 'IPS\\downloads\\File\\PendingVersion', 2 => 'IPS\\forums\\Topic\\Post', 3 => 1616057744]; protected $message = 'MySQL server has gone away'; private ${Exception}string = ''; protected $code = 2006; protected $file = '/srv/www/community.xxx.net/current/web/ips/system/Db/Db.php'; protected $line = 678; private ${Exception}trace = ...PHP message: PHP   2. IPS\IPS::genericExceptionPage($message = 'MySQL server has gone away')

With all others members, there is no problem.

I manage to "solve" problem choosing "I will choose which content to include" + "Topics" instead of "All content".

IPS Support don't assist with server related issues.

I try various mysqld config options without success.

If someone have an idea how to solve this problem!

Thanks 🙂

March 15, 2021

14 minutes ago, Morrigan said:

That could be a bug OR they have more permissions than you think they have.

Should I contact IPS support?

March 15, 2021

Thanks @Morrigan but unfortunately it doesn't work:

And login as a moderator, he can see this:

March 15, 2021

1 hour ago, bfarber said:

Your moderators must have permission to see the draft in that case. You can edit moderator permissions in the AdminCP under Members > Moderators by editing the respective member/group moderator records.

Thanks for help but there is no option for that.

Under Members > Groups > Edit :

Under Members > Staff > Moderators :

March 15, 2021

Hello,

As administrator, I create a blog entry and save it as a draft, it is not published to public.

The members cannot see this blog entry, it's OK.

But the moderators can see it, why? Can I disable this?

I have searched in permissions in CP Admin but I didn't find anything.

Can you help?

Thanks.

November 30, 2020

5 hours ago, Sonya* said:

You do not need blogs if you would like to have only one blog. IPS Blogs are designed for community members. It's a multi-blog solution. If you need a blog written by community owner only or even a group of approved members than you should stay with Pages. See also IPS community blog https://invisioncommunity.com/news/ that is based on Pages and not Blogs.

Pages is surely not so powerful like WordPress out of the box. Pages are still highly customizable. If you outline what you exactly miss in Pages, then it can be extended. I cannot think of anything that cannot be done with Pages.

IPS will never provide WordPress functionality for the blogs, or Magento/Presta Shop features for Commerce. IPS is for building communities first, not writing blogs and not building powerful shop solutions. On the other side BuddyPress or Magento Forum will never reach out to IPS. They are just not designed to be a strong community software.

Thank for your reponse.

IPS Converts can convert WordPress posts to IPS pages?

November 29, 2020

2 hours ago, Meddysong said:

Invision Community has a specific app for blogging: https://invisioncommunity.com/features/content/#blogs

With Blogs, we can't define only one blog as the main content of the site like a WordPress.

It will be accessible only at https://mysite.com/blogs/membername

November 29, 2020

7 minutes ago, Fast Lane! said:

I love Pages but WP is FAR more seo optimized. I can't compete with my competitions site on SEO. Also, they due AMP via a plugin which gives them extra Google love on mobile search. Pages is also SUPER heavy on page resources (not needed JavaScript and css) which kills the pagespeed scores lowering things further.

Again I use Pages but would suggest IP developers take heed if they ever want to woo people away from WordPress.

Thanks!

I will stay to WordPress so...

It's a shame IPS doesn't provide a light app just for blog posting.

I don't like WordPress very much because of his dinosaur code, even if some boilerplates and themes make it better.

I will try to look at some modern CMS alternatives like OctoberCMS, Bolt, PyroCMS...

November 29, 2020

Hello,

I currently have a WordPress blog with over 400 articles. I also use the forums, blogs and downloads from IPS.
WordPress and IPS each have their own domain name.
I created a plugin that automatically syncs WordPress users with IPS members.

For convenience, I wonder if it would be a good idea to switch from WordPress to IPS Pages for the blog part and only use IPS.

I have advanced use of WordPress. I am using blade as a template engine, webpack to compile the assets, use composer to manage plugins and I create a script that deploys my site from local to remote using my git repo when it's OK.

I hate GUI to design a website, I don't want to deploy my changes without versionning it, I prefer to code and deploy then.

Do you think IPS Pages is a good solution for me?
Can I don't use IPS GUI and only use code to do what I want?
Could I create my blog posts as easy as WordPress?

Thank you!

October 11, 2020

On 9/23/2020 at 4:17 PM, bfarber said:

I can't reproduce - this looks like a problem with your install, specifically. I expect it's a legacy thing where the template was inserted but stored differently than it would now.

You may be able to fix the issue by removing the plugin completely and re-adding it. Alternatively you may be able to fix the issue by removing the template row from core_theme_templates manually in phpmyadmin.

I just created a new plugin with a widget and a template and can export it as many times as I want without issue.

Thanks, just removed the template row in core_theme_templates and it works!

September 23, 2020

Hello,

Since IPS 4.5, I can not anymore download my plugin containing a widget.

When clicking on download button, this error appears:

OverflowException thrown with message ""

Stacktrace:
#6 OverflowException in /srv/www/community.site.com/current/web/ips/system/Theme/Theme.php:5038
#5 IPS\_Theme:addTemplate in /srv/www/community.site.com/current/web/ips/applications/core/modules/admin/applications/plugins.php:1995
#4 IPS\core\modules\admin\applications\_plugins:download in /srv/www/community.site.com/current/web/ips/system/Dispatcher/Controller.php:90
#3 IPS\Dispatcher\_Controller:execute in /srv/www/community.site.com/current/web/ips/system/Node/Controller.php:62
#2 IPS\Node\_Controller:execute in /srv/www/community.site.com/current/web/ips/applications/core/modules/admin/applications/plugins.php:48
#1 IPS\core\modules\admin\applications\_plugins:execute in /srv/www/community.site.com/current/web/ips/system/Dispatcher/Dispatcher.php:152
#0 IPS\_Dispatcher:run in /srv/www/community.site.com/current/web/ips/admin/index.php:14

The problem comes from the template file: my-plugin/dev/html/widgetName.phtml.

When I delete this widgetName.phtml file, download is OK.

Can you help?

Thanks!

July 20, 2020

Thanks @Adriano Faria!

It's a shame it is not included in IPS...

July 20, 2020

Hello,

I would like to create a parent category without files in it which list all files inside sub-categories.

Actually, the parent category show "No file in this category", and I would like it shows files in children.

How can I do it?

Thanks.

May 11, 2020

@AutoItScript : could you share source code of the plugin on Github? Community can maybe take over

April 24, 2020

Thanks for help.

I just create a new version of the plugin, upload to the site and it works now.

Very strange!

April 24, 2020

Hello,

I install new plugins but IPS doesn't load their CSS and JS files.

I try to clear cache, desinstall/resintall the plugin without success.

For example a plugin has one CSS file and one JS file which are not loaded.

When I check the code source of the pages, the CSS and JS files of the plugin are missing.

It works on a local env with IN_DEV enabled.

Can you help?

Thanks!

---

EDIT 1 : for information, after installing the plugins, when I entered the custom parameters for the plugin, they were not taken into account.

Also, the default parameters were not written in the text fields in the form settings of the plugin.

I had to uninstall and reinstall the plugin several times for the settings to be saved.

Strange

---

EDIT 2 : the cAcpLoginBox_logo has mysteriously disappeared for a few days, I don't know if it's related.

April 22, 2020

5 hours ago, bfarber said:

The method you are describing is fine. Plugins can't really add their own classes cleanly like an application can so unless you want to build an application instead of a plugin, just add your methods to an existing class.

Thanks @bfarber.

So I have to define function with unique name to prevent conflict with others plugins?

April 22, 2020

Hello,

I'm creating a plugin for IPS with many hooks.

I want all my plugin hooks can access to a PHP function but I don't know where to define this function, I would like to define a custom class in the plugin but how?

For the moment, I have created a hook of \IPS\Settings with my PHP function:

class hook13 extends _HOOK_CLASS_
{
	public function myFunction()
	{
		...

myFunction() is reachable by all plugin hooks via \IPS\Settings::i()->myFunction() but it's not clean, the PHP function is reachable by all others plugins and could create conflict.

Do you know how can I have a PHP function reachable by all hooks in a plugin?

Thanks!

January 16, 2019

No available anymore?

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by DreamOn