jtablesession::Store Failed, DB function failed error 1062

[lcdweb]

Our 1.5 site went down this morning with the following error:

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session (
`session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES (
'a095cf5b6baa793e26769c528f03d8ea','1208358762','','0','1','0' )

Clearing out the session table resolved the issue, but I'm concerned why it happened, where it came from, and how I prevent it from recurring. Anyone else experience this issue?

-Brian

[KDawg]

Has anyone found more current reasons why this error would occur? I am running 1.5.2 and discovered this error as well. The error cleared and can't be reproduced, but it is a major concern because if you Google this error you will find that Google has indexed a very large number of Joomla sites where the GoogleBot found this same error and thinks it's a valid page for the site, therefore cataloging it in the search results!

I'd be surprised if many others have not seen this error (as evidenced by Google). If a site can be taken down by this bug until one happens to notice it, and only then brought back online by a PHPMyAdmin->Repair of the jos_session table, then that is a serious reliability issue for Joomla.

Anyone have any updates?

Merci bien.

[seola]

For god sake this just happened with me also. Just 5 minutes ago.

I installed 1.53 version Jooomla few days ago, today I added Mootools from Yootheme, I have yoocarousel and yoogmaps

Can this cause problem?

[seola]

I repaired the table and my site is a mess.

OMG !!!

Warning: array_slice() [function.array-slice]: The first argument should be an array in /home/bb/public_html/seo/modules/mod_yoo_carousel/helper.php on line 104

Warning: Invalid argument supplied for foreach() in /home/bb/public_html/seo/components/com_content/models/section.php on line 352

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bb/public_html/seo/libraries/joomla/database/database/mysql.php on line 338

I mean why is this happening at all!!!

OK I resolved the situation

2 tables crashes, sessions and content so I had to repair them, But I really need some answers why is this happening???

[Metal Wing]

I've been having troubles like that for 2 days now.

Here is my research findings:

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session (
`session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES (
'a095cf5b6baa793e26769c528f03d8ea','1208358762','','0','1','0' )

The error above, means that something is wrong with the jos_sessions table. Repairing it might work. Dropping and recreating might or might make it worse.

In my case I had to disable SEFurls and my ARTIO JoomSEF in order to get all errors out of the way.

[mckael]

hello everybody,

i encountered the same problem. i tried to truncate the table jos_session but it didn't be successful. So after deleting it, i tried recreating it and when i display my site in the root folder http://x.x.x.x/ i came to an Error 404.
How to solve it please, anyone have any ideas ?

Many thanks,

[seola]

session table is just for logged in data, so it is not important, what you should do is try to repair it, if that does not work than you should empty it, that did the trick with my site

But dont delete it, probably you should import just that table in your database from another backup

[abdi123]

hi guys,

i have this same problem too (error 1062) and subsequent error 1016,
running joomla 1.0.13, mysql 4.1 on yahoo hosting.
already tried to repair the jos_sessions table - it did fix the issue temporarily - but still did not fix the issue.

i'm curious whether this is a security hole or not - but from the website log - it doesnt record any suspicious activities.

could we fix this issue once and for all? any help would be appreciated.

thank you.

[TrvlFox]

I just had this very same error. My site is down. I'm on Joomla 1.3

Could this be a bug? It just happened automatically. I could use some help on the steps to take.



Exact error message
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a2c6abda82d49c50355c38b253ef1d6c','1219451441','','0','1','0' )

[TrvlFox]

I ran a DB repair and that worked. My site is up, but I think we need to find out the answer to this problem.

[ichimonban]

Getting same Error.

The site is J1.5.6, Site 5 Linux,

jtablesession::store failed
DB function failed with error number 1062
Duplicate entry 'ef429f4004a58e83b8cf1929c7bb1d86' for key 1 SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ef429f4004a58e83b8cf1929c7bb1d86','1225261992','','0','1','1' )

It seems to have cleared up with repairing the session table.

Ichimonban

http://www.urbandezign.com
Boise's Finest Web Design

[brsacjab]

Just had the same error

J1.5.7, Site 5 Linux

Did a repair on the session table, started working again...

Noticed the server was restarted ~ 3hrs ago...maybe abrupt shutdown left table broken or bad data?

[nana111]

i got the same error
jtablesession::Store Failed
DB function failed with error number 1016
Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '45ba19d7d475bc9d9c46c79971fca7c9','1227243742','','0','1','0' )

is it true that to repair the session table through phpmyadmin then it will work??

[brsacjab]

That worked for me. Seems the error is related to the session table being truncated.

[Metal Wing]

i got the same error
jtablesession::Store Failed
DB function failed with error number 1016
Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '45ba19d7d475bc9d9c46c79971fca7c9','1227243742','','0','1','0' )

is it true that to repair the session table through phpmyadmin then it will work??

Yes it works (Unless you have a component that keeps screwing it up all the time). Repairing it is also much safer than 'backup - delete - re-add' method.

[jboulton]

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'bb8af4cbb574fd0d74bce53f522e38fd','1228342746','','0','1','0' )

I repaired the table and here were my results:

chamber_iT90.jos_session repair info Found block that points outside data file at 90524
chamber_iT90.jos_session repair info Found block that points outside data file at 91068
chamber_iT90.jos_session repair info Found block that points outside data file at 97816
chamber_iT90.jos_session repair info Found block that points outside data file at 98440
chamber_iT90.jos_session repair info Found block that points outside data file at 99528
chamber_iT90.jos_session repair warning Number of rows changed from 20 to 8

I don't know what the problem is;however I'm not impressed with this issue.

Database Version: 5.0.67-community
Database Collation: utf8_general_ci
PHP Version: 5.2.6
Web Server: Apache/2
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.7 Production/Stable [ Wovusani ] 9-September-2008 23:00 GMT

[rpackett]

My site has gone down with the same error:
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '571ddeb9ed6b510fcb97746200dde527','1229877492','','0','1','0' )

but repairing the table did not work. I tried empyting the table, I'm still getting the same error.

Help anyone!

Nevermind!! I found the problem and fixed it.

[brsacjab]

Worst case scenario I encountered recently. The database/table itself hath disappeared...

Host doesn't know why... So, remember to backup you files AND db regularly.

Fortunately, I was able to restore a previous db and make the changes to get it current.

[OsNo]

Had the same error 2 times.
before it got down the first time my server had an uptime of several weeks.
then i changed some settings in joomla
- put in legacy mode
- added template
- posted a new message

several days later the whole thing went down (with the same error message)
a couple of days later i went to the server... (cause it appeared to be a bigger problem, i couldn't login through ssh)... pulled the plug and rebooted it.... it restarted and all was fine again.

This afternoon it all happened again.
This time i already had some open SSH connections so i could test some stuff.

When i tried to restart apache it told me it couldn't access the logs.
Then i looked at my DCclient.... it was disconnected giving tons of errors saying my filesystem has gone ... read-only

so my /home/ and /tmp/ directories became read-only for some reason.
making the whole system malfunctioning.

I am running an Ubuntu Intrepid Ibex, MySQL, Apache2,....

So, i don't think Joomla could cause such a problem, unless there is a serious security leak.
So fellow server owners, help me find the server problem.

My hard drives are far from full btw.

hope we find a solution soon
Cheers


EDIT:

I seem to have found the problem,
Most linux servers remount there file systems on found errors, but they remount them read-only
So this screws up all logging including joomla's.

SOLUTION:
if you own the server, or have access to it: do an fsck and repair the harddrive. (needs to be done in a maintenance rootshell.), if errors keep coming back... consider buying a new harddrive.
if you don't: contact your hosting service and ask them to do this for you

NOTE:
you could just remove the on-error=remount-ro option from the fstab, but it's there for a reason, so i wouldn't recommend it. Could cause data loss.

[KidA]

Add my name to the list. Twice in the last week or so. Repairing the sessions table fixes it for me.

[KDawg]

My site has gone down with the same error:
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '571ddeb9ed6b510fcb97746200dde527','1229877492','','0','1','0' )

but repairing the table did not work. I tried empyting the table, I'm still getting the same error.

Help anyone!

Nevermind!! I found the problem and fixed it.

Insanely curious why rpackett "found the problem and fixed it" and didn't bother telling us what s/he found???

[cespinoza]

Hi, I got the same error,

jtablesession::Store Failed
DB function failed with error number 145
Table './jbgorg_sites/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a0650b658ee06670453ee8d1c1d7318a','1233257241','','0','1','0' )

Could you tell me how to repair the jos_session table?

[nikkie]

I'm using 1.5.7 and had the same problem. myPhpAdmin reported that the jos_session table was marked as "crashed." It gave me only the option to flush it, which of course didn't work given that the table was marked crashed. I dumped the table structure of jos_session from another 1.5.6 installation, which produced the following:

Code: Select all

CREATE TABLE IF NOT EXISTS `jos_session` (
  `username` varchar(150) default '',
  `time` varchar(14) default '',
  `session_id` varchar(200) NOT NULL default '0',
  `guest` tinyint(4) default '1',
  `userid` int(11) default '0',
  `usertype` varchar(50) default '',
  `gid` tinyint(3) unsigned NOT NULL default '0',
  `client_id` tinyint(3) unsigned NOT NULL default '0',
  `data` longtext,
  PRIMARY KEY  (`session_id`(64)),
  KEY `whosonline` (`guest`,`usertype`),
  KEY `userid` (`userid`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I then dropped the bad table and executed the above SQL, which restored everything completely.

I don't know if what worked for me is suitable for anyone else. Proceed with caution.

[cespinoza]

When I had this problem, I reported it to my hosting provider and they told me that it was an error in their global mysql service and they had to fix it. Else I had to repair the jos_session table from MyPhPAdmin:

1) Enter your Hosting Cpanel
2) Select PhpMyAdmin
3) Select your data base
4) Check the table jos_session
5) At the bottom search for a drop list and select the option: repair the table

That worked for me.

[arenita]

Ive already tried reparing the table but doesnt work.
Still appearin same error msg:

jtablesession::Store Failed
DB function failed with error number 1054
Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '70d78888785b2ec2840ba64eef9e2bf8','1233700284','','0','1','0' )

Also, If I try to log into administrator page... same error coming

[brad]

Try to do a restore of your database from a backup.

Oh, and people.. please.. keep your Joomla installs up to date.. I can't believe some of you are not yet running 1.5.9, do you want to be hacked?

[arenita]

Ive installed Joomla 1.5.9... but the version that was in the other server is older... Do you recomend me to install the older version with this DB backup and then update?
I dont know if its working installing the newest from the beggining

[cespinoza]

Please, review this documentation:

http://docs.joomla.org/Do_you_have_to_u ... la!_1.5%3F
http://docs.joomla.org/How_do_you_upgra ... la!_1.5%3F
http://docs.joomla.org/Upgrade_Instructions

[tompen]

I'm becoming more and more convinced that Joomla is not the source of the problem even though it might be the cause. But right now it would be more than interesting to know what versions of mysql, apache and php you are all running. Because I really need a new host for my client, but it would be nice to know that I'm not walking into the same trap again.

My own server, joomla running without a glitch (though installing modules is a bitch for one reason or another, but that's not a problem suited for this topic):

Ubuntu 5.4
Mysql: 5.0.51a
PHP: 5.2.4-2
Apache: 2.2.8

The error-server (talkactive.net):

FreeBSD 6.2
Mysql: 5.0.45
PHP: 5.2.3
Apache: 2.0.59

[cespinoza]

These are mine: Joomla 1.5.9

ProgramVersion
Apache:2.2.11
CentOS:5.2
cPanel:11.24.4-RELEASE
Curl:7.12.1
MySQL5.1.30
phpMyAdmin2.11.9.4
Python:2.4.3ProgramVersion
Perl:5.8.8
PHP:5.2.4
ionCube Loader:3.1.32
Zend Optimizer:3.2.2
Ruby:1.8.5
Rails:2.2.2
OpenSSL:0.9.8b

But this error has nothing to do with the software version, as I have told you before this is an error in the mysql service of the hosting provider.