Kunena 6.4.8 Released

The Kunena team has announce the arrival of Kunena 6.4.8 [K 6.4.8] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.

Please Read This First:

This category is only for reporting defects with K 3.0.

Do not use this category:

to ask general questions about how to use K 3.0 or to ask when new versions of Kunena will be released;
to ask about other (older) versions of Kunena; or
if you have tried to install K 3.0 on J! 1.5; or
if you installed K 3.0 on a live, production site and you want your site restored to its previous state; or
if this website ( www.kunena.org ) works but works differently to how you expected.

You must include your K 3.0 configuration report; if you do not include your configuration report, your topic may be closed (locked) or deleted without any further warnings from the moderators.

Topics that have been closed (resolved) will be archived and no further discussion on those topics will be allowed.

Question Recurrent error - Could not connect to mysql database!

Afdhaal
Topic Author
Offline
New Member

10 years 9 months ago - 10 years 9 months ago #163093 by Afdhaal

Recurrent error - Could not connect to mysql database! was created by Afdhaal

Hi there,

I'm using kunena for more than 3 years. I was and I'm so happy using it in my educational website as the forum solution.

But recently few weeks ago I'm getting recurrent mysql error which says "Could not connect to mysql database". Initially I thought that it could be due to restrictions of the shared hosting. So I moved my site to a VPS (1GB ram & 1 core) in digitalocean!
But still I'm getting the error. As soon as I restart the mysql, everything comes back to normal. Also when I repair and optimize the mysql database of the site everyday, the incidents of the error is less. But still I couldn't figure out the problem why I'm still getting it.

I have only installed Kunena, akeeba backup & akeeba admin tools as extensions.

My forum:

Code:

http://istudyroom.com/Forum

Configuration:

This message contains confidential information

Database collation check: The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 20M

Kunena menu details:

Warning: Spoiler!

ID Name Menutype Link Path In trash

679 Forum kunenamenu view=home&defaultmenu=681 forum No

680 Index kunenamenu view=category&layout=list forum/index No

681 Recent Topics kunenamenu view=topics&mode=replies forum/recent No

682 New Topic kunenamenu view=topic&layout=create forum/newtopic No

683 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies No

684 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest No

685 Profile kunenamenu view=user forum/profile No

686 Rules kunenamenu view=misc forum/help No

687 Search kunenamenu view=search forum/search No

Joomla default template details : isrsapphire | author: Kyle Ledbetter | version: 1.0 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.7 | creationdate: 2015-02-01

Kunena version detailed: Kunena 3.0.7 | 2015-02-01 [ Galah ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:

board_offline 0

enablerss 1

threads_per_page 30

messages_per_page 20

messages_per_page_search 15

showhistory 1

historylimit 10

shownew 1

disemoticons 0

template blue_eagle

showannouncement 1

avataroncat 0

catimagepath category_images

showchildcaticon 1

rtewidth 450

rteheight 300

enableforumjump 1

reportmsg 1

username 0

askemail 0

showemail 0

showuserstats 1

showkarma 1

useredit 1

useredittime 0

useredittimegrace 600

editmarkup 1

allowsubscriptions 1

subscriptionschecked 1

allowfavorites 1

maxsubject 50

maxsig 300

regonly 0

pubwrite 0

floodprotection 0

mailmod 0

mailadmin 0

captcha 0

mailfull 1

allowavatarupload 1

allowavatargallery 1

avatarquality 75

avatarsize 512

imageheight 1200

imagewidth 800

imagesize 1048

filetypes txt,docx,pptx,rtf,pdf,zip,tar.gz,tgz,tar.bz2

filesize 70000

showranking 1

rankimages 1

userlist_rows 30

userlist_online 1

userlist_avatar 1

userlist_name 1

userlist_posts 1

userlist_karma 1

userlist_email 0

userlist_joindate 1

userlist_lastvisitdate 1

userlist_userhits 1

latestcategory 0

showstats 1

showwhoisonline 1

showgenstats 1

showpopuserstats 1

popusercount 10

showpopsubjectstats 1

popsubjectcount 10

usernamechange 0

showspoilertag 1

showvideotag 1

showebaytag 1

trimlongurls 1

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 1

sessiontimeout 3600

highlightcode 0

rss_type topic

rss_timelimit month

rss_limit 100

rss_included_categories

rss_excluded_categories

rss_specification rss2.0

rss_allow_html 1

rss_author_format name

rss_author_in_title 1

rss_word_count 0

rss_old_titles 1

rss_cache 900

defaultpage recent

default_sort asc

sef 1

showimgforguest 1

showfileforguest 1

pollnboptions 5

pollallowvoteone 1

pollenabled 1

poppollscount 5

showpoppollstats 1

polltimebtvotes 00:15:00

pollnbvotesbyuser 100

pollresultsuserslist 1

maxpersotext 50

ordering_system mesid

post_dateformat ago

post_dateformat_hover datetime

hide_ip 1

imagetypes jpg,jpeg,gif,png

checkmimetypes 1

imagemimetypes image/jpeg,image/jpg,image/gif,image/png

imagequality 80

thumbheight 32

thumbwidth 32

hideuserprofileinfo put_empty

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

debug 0

catsautosubscribed 0

showbannedreason 1

version_check 1

showthankyou 1

showpopthankyoustats 1

popthankscount 10

mod_see_deleted 0

bbcode_img_secure text

listcat_show_moderators 1

lightbox 1

show_list_time 8760

show_session_type 0

show_session_starttime 400

userlist_allowed 0

userlist_count_users 1

enable_threaded_layouts 0

category_subscriptions post

topic_subscriptions every

pubprofile 1

thankyou_max 10

email_recipient_count 0

email_recipient_privacy bcc

captcha_post_limit 0

keywords 0

userkeywords 0

image_upload registered

file_upload registered

topic_layout flat

time_to_create_page 1

show_imgfiles_manage_profile 1

hold_newusers_posts 0

hold_guest_posts 0

attachment_limit 20

pickup_category 1

article_display intro

send_emails 1

fallback_english 1

cache 1

cache_time 180

iptracking 1

rss_feedburner_url

autolink 1

access_component 0

statslink_allowed 1

superadmin_userlist 0

ebay_language 0

ebaylanguagecode en-us

userlist_usertype 0

sefutf8 0

changename 0

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:

en-GB English (en-GB)

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	30
messages_per_page	20
messages_per_page_search	15
showhistory	1
historylimit	10
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	0
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	512
imageheight	1200
imagewidth	800
imagesize	1048
filetypes	txt,docx,pptx,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	70000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	10
showpopsubjectstats	1
popsubjectcount	10
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
sessiontimeout	3600
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	80
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	10
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	8760
show_session_type	0
show_session_starttime	400
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	20
pickup_category	1
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	180
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	1
superadmin_userlist	0
ebay_language	0
ebaylanguagecode	en-us
userlist_usertype	0
sefutf8	0
changename	0

Joomla! languages installed:
en-GB	English (en-GB)

Third-party components: None

Third-party SEF components: sh404sef 4.4.6.2271

Plugins: Search - Kunena Search 3.0.1

Modules: Kunena Latest 3.0.1

Mysql error log:

Warning: Spoiler!

150331 22:00:09 [Note] Plugin 'FEDERATED' is disabled.
150331 22:00:09 InnoDB: The InnoDB memory heap is disabled
150331 22:00:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:00:09 InnoDB: Compressed tables use zlib 1.2.8
150331 22:00:09 InnoDB: Using Linux native AIO
150331 22:00:09 InnoDB: Initializing buffer pool, size = 64.0M
150331 22:00:09 InnoDB: Completed initialization of buffer pool
150331 22:00:09 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1657582635
150331 22:00:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1657592733
150331 22:00:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 22:00:10 InnoDB: Waiting for the background threads to start
150331 22:00:11 InnoDB: 5.5.41 started; log sequence number 1657592733
150331 22:00:11 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 22:00:11 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 22:00:11 [Note] Server socket created on IP: '127.0.0.1'.
150331 22:00:11 [Note] Event Scheduler: Loaded 0 events
150331 22:00:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_attachments' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_attachments'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_categories' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_categories'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_messages'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages_text' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_messages_text'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_sessions' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_sessions'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_thankyou' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_thankyou'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_topics' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_topics'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_read' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_user_read'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_topics' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_user_topics'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_users' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_users'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_sh404sef_urls' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_sh404sef_urls'
150331 22:12:14 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:14 InnoDB: The InnoDB memory heap is disabled
150331 22:12:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:14 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:14 InnoDB: Using Linux native AIO
150331 22:12:14 InnoDB: Initializing buffer pool, size = 64.0M
150331 22:12:14 InnoDB: Completed initialization of buffer pool
150331 22:12:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1658424049
150331 22:12:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1658472540
150331 22:12:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 22:12:15 InnoDB: Waiting for the background threads to start
150331 22:12:16 InnoDB: 5.5.41 started; log sequence number 1658472540
150331 22:12:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 22:12:16 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 22:12:16 [Note] Server socket created on IP: '127.0.0.1'.
150331 22:12:16 [Note] Event Scheduler: Loaded 0 events
150331 22:12:16 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 22:12:16 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_sh404sef_urls' is marked as crashed and should be repaired
150331 22:12:16 [Warning] Checking table: './istudyroom/jml_sh404sef_urls'
150331 22:12:37 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:37 InnoDB: The InnoDB memory heap is disabled
150331 22:12:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:37 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:37 InnoDB: Using Linux native AIO
150331 22:12:37 InnoDB: Initializing buffer pool, size = 64.0M
InnoDB: mmap(68681728 bytes) failed; errno 12
150331 22:12:37 InnoDB: Completed initialization of buffer pool
150331 22:12:37 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150331 22:12:37 [ERROR] Plugin 'InnoDB' init function returned error.
150331 22:12:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150331 22:12:37 [ERROR] Unknown/unsupported storage engine: InnoDB
150331 22:12:37 [ERROR] Aborting

150331 22:12:37 [Note] /usr/sbin/mysqld: Shutdown complete

150331 22:12:38 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:38 InnoDB: The InnoDB memory heap is disabled
150331 22:12:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:38 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:38 InnoDB: Using Linux native AIO
150331 22:12:38 InnoDB: Initializing buffer pool, size = 64.0M
InnoDB: mmap(68681728 bytes) failed; errno 12
150331 22:12:38 InnoDB: Completed initialization of buffer pool
150331 22:12:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150331 22:12:38 [ERROR] Plugin 'InnoDB' init function returned error.
150331 22:12:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150331 22:12:38 [ERROR] Unknown/unsupported storage engine: InnoDB
150331 22:12:38 [ERROR] Aborting

150331 22:12:38 [Note] /usr/sbin/mysqld: Shutdown complete

150331 23:43:22 [Note] Plugin 'FEDERATED' is disabled.
150331 23:43:22 InnoDB: The InnoDB memory heap is disabled
150331 23:43:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 23:43:22 InnoDB: Compressed tables use zlib 1.2.8
150331 23:43:22 InnoDB: Using Linux native AIO
150331 23:43:22 InnoDB: Initializing buffer pool, size = 64.0M
150331 23:43:22 InnoDB: Completed initialization of buffer pool
150331 23:43:23 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1658472708
150331 23:43:23 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1658481424
150331 23:43:23 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 23:43:23 InnoDB: Waiting for the background threads to start
150331 23:43:24 InnoDB: 5.5.41 started; log sequence number 1658481424
150331 23:43:24 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 23:43:24 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 23:43:24 [Note] Server socket created on IP: '127.0.0.1'.
150331 23:43:24 [Note] Event Scheduler: Loaded 0 events
150331 23:43:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_attachments' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_attachments'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_categories' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_categories'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_messages'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages_text' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_messages_text'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_sessions' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_sessions'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_topics' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_topics'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_read' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_user_read'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_topics' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_user_topics'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_users' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_users'

Eagerly waiting for your response!

Last edit: 10 years 9 months ago by Afdhaal.

Please Log in or Create an account to join the conversation.

xillibit
Offline
Administrator

10 years 9 months ago #163094 by xillibit

Replied by xillibit on topic Recurrent error - Could not connect to mysql database!

Hello,

Do-you have empty space on hard disk ?

In your log, i can see that MySQL has been not shutdown correctly, i think it's you that you have tried to restart mysql :

150331 22:12:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.

I don't provide support by PM, because this can be useful for someone else.

The following user(s) said Thank You: Afdhaal

Please Log in or Create an account to join the conversation.

Afdhaal
Topic Author
Offline
New Member

10 years 9 months ago #163095 by Afdhaal

Replied by Afdhaal on topic Recurrent error - Could not connect to mysql database!

Hi xillibit,

I have allocated 10Gb for the joomla website with the forum and I have more than 8Gb free space.

The error used to occur every other day. When I get the error, I restart the mysql. As soon as I restart it, everything comes back to normal.

I'm pretty confused because I had the same problem when I was using shared hosting at ipage. Now the same problem is with my VPS. (To host the sites, I'm using webmin control panel.)

Please Log in or Create an account to join the conversation.

xillibit
Offline
Administrator

10 years 9 months ago #163105 by xillibit

Replied by xillibit on topic Recurrent error - Could not connect to mysql database!

I think it will more helpfull to ask directly on ubuntu forums or dba.stackexchange.com because i'am bit stick with your issue

I don't provide support by PM, because this can be useful for someone else.

The following user(s) said Thank You: Afdhaal

Please Log in or Create an account to join the conversation.

Afdhaal
Topic Author
Offline
New Member

10 years 9 months ago #163113 by Afdhaal

Replied by Afdhaal on topic Recurrent error - Could not connect to mysql database!

Thanks for the reply xillibit!
I'll ask it at ubuntu forum!
Have a great day!

Please Log in or Create an account to join the conversation.

raunharman
Offline
New Member

10 years 5 months ago #167062 by raunharman

Replied by raunharman on topic Recurrent error - Could not connect to mysql database!

Which table in the database are the reply messages stored?

Please Log in or Create an account to join the conversation.

Time to create page: 0.318 seconds