Reporting another problem - for a few hours

jtablesession::Store Failed

DB function failed with error number 1062

Duplicate entry '1-' for key 'whosonline' SQL=INSERT INTO os_session ( Session_id,Time,Username,Gid,Guest,Client_id ) VALUES (

'b8jcigs0rqtpejn512mk3pkps7','1404180183','','0','1','0' )

The number starting with 1404... looks like the seconds since 1970-01-01 00:00:00 UTC when the error occured - especially since it had incremented on every subsequent attempt to logon...

deleted...

Another one... maybe Clear Forums doing housekeeping during normal Au time?

just this - nothing else

Database Error: Unable to connect to the database:Could not connect to MySQL

Another Forums crash - but seems to have recovered...

jtablesession::Store Failed

DB function failed with error number 2006

MySQL server has gone away SQL=INSERT INTO

os_session ( Session_id,Time,Username,Gid,Guest,Client_id ) VALUES (

'm35oib1s5lup2l60p3l88r2h12','1403153886','','0','1','0' )



Database Error: Unable to connect to the database:Could not connect to MySQL

The current forum is nicely integrated in the Clearfoundation site but I rather have a less polished forum when speeds get better of the forums. Also a irritating thing if you put some output from the command shell in a code box you always have to scroll to see everything. So i'm also looking forward to new forum software.

Not saying it will be any better...but Kunena forum software was released at v3.0 yesterday!

I look forward to the new forum as well. The change can't be soon enough. I think lots of us have been dissaisfied with the performance from when it switched from the old CC one.

Hi Peter,

Good to hear this will have a change.
I like the forum software vBulletin because is also has a nice layout for tablets. Since a lot of people (including me) uaring using a tablet or a smartphone this looks to me a nice to have feature.

Logitech is using this for example. Logitec forum

We've had it with the performance of the forums and are now actively looking at alternatives. 400 database queries to load the main forum page is just ridiculous! The blog software is also broken and the URL rewrite engine (sh404SEF) is a horror show. Other bits of ClearFoundation infrastructure are okay (though the translation server is sluggish too):

- Translation: http://translate.clearcenter.com
- Build system: http://buildsys.clearfoundation.com/
- Issue Tracker: http://tracker.clearfoundation.com/
- SVN/CVS: scm.clearfoundation.com

Our mirror system is well designed to get updates out quickly, but it suffers from two weaknesses:

- If an update fails high up on the mirror hierarchy, the mirrors further down the line are marked as "offline". This increases the load on the higher mirrors which in turn might get overloaded and taken offline. Aaaaand death spiral. That's exactly what happened a few days ago.

- For most mirrors, all you need is rsync and cron. ClearFoundation's mirrors are more complex to configure and it has been hard to convince potential mirror hosts to bit the bullet.

and again from the forums...

jtablesession::Store Failed

DB function failed with error number 1062

Duplicate entry 'qf2dn4i21lrdosm3lhustju1m7' for key 1 SQL=INSERT INTO `clear_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'qf2dn4i21lrdosm3lhustju1m7','1368606257','','0','1','0' )

My server updated itself last night. So i suppose everything is back to normal.

@Tony Ellis, Good to see you here Tony Ellis. I think the forums can use such experience guy as you!

regarding the forums speeds i also annoy me sometimes when it's slow.., the Clarkconnect forums were way better!!!

The website gave me this for awhile

jtablesession::Store Failed

DB function failed with error number 1062

Duplicate entry 'jevsmht4hoe4r6vucvjj1ktek4' for key 1 SQL=INSERT INTO `clear_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'jevsmht4hoe4r6vucvjj1ktek4','1368087839','','0','1','0' 

The sooner we get better and faster software for these forums the better :-)

Tim,

it's working better now.
Small error with the Houston mirror

Transaction Summary

================================================================================

Install       1 Package(s)

Upgrade      10 Package(s)

Remove        1 Package(s)



Total size: 113 M

Total download size: 92 M

Is this ok [y/N]: y

Downloading Packages:

(1/5): clamav-db-0.97.8-1.el6.i686.rpm                                                   |  56 MB     01:38

(2/5): clamd-0.97.8-1.el6.i686.rpm                                                       | 130 kB     00:01

http://mirror2-houston.clearsdn.com/clearos/community/6/updates/i386/RPMS/kernel-2.6.32-358.6.1.v6.i686.rpm: [Errno 14] PYCURL ERROR 18 - "transfer closed with 17020642 bytes remaining to read"

Trying other mirror.

(3/5): kernel-2.6.32-358.6.1.v6.i686.rpm                                                 |  24 MB     01:35

(4/5): kernel-firmware-2.6.32-358.6.1.v6.noarch.rpm                                      |  11 MB     00:43

(5/5): mysql-5.1.69-1.el6_4.i686.rpm                                                     | 916 kB     00:03

----------------------------------------------------------------------------------------------------------------

Total                                                                           228 kB/s |  92 MB     06:54

The team fixed a couple of things - should be back to normal, although you'll need to run 'yum clean all' again to refresh the mirror list

If it's still slow please post the first section of yum output after 'determining fastest mirrors'

After 1 day still downloading from marketplace

same here.... speed is approx. 2.4 kb/s

 yum upgrade

Loaded plugins: clearcenter-marketplace, fastestmirror

ClearCenter Marketplace: fetching repositories...

Determining fastest mirrors

 * clearos: mirror2-houston.clearsdn.com

 * clearos-addons: mirror2-houston.clearsdn.com

 * clearos-extras: mirror2-houston.clearsdn.com

 * clearos-updates: mirror2-houston.clearsdn.com

 * private-clearcenter-dyndns: download1.clearsdn.com:80

 * private-clearcenter-zarafa-community: download1.clearsdn.com:80

clearos                                                  | 3.6 kB     00:00

clearos-addons                                           | 2.9 kB     00:00

clearos-extras                                           | 2.9 kB     00:00

clearos-updates                                          | 2.9 kB     00:00

clearos-updates/primary_db                               | 335 kB     00:21

Setting up Upgrade Process

Resolving Dependencies

--> Running transaction check

---> Package app-date.noarch 1:1.4.20-1.v6 will be updated

---> Package app-date.noarch 1:1.4.35-1.v6 will be an update

---> Package app-date-core.noarch 1:1.4.20-1.v6 will be updated

---> Package app-date-core.noarch 1:1.4.35-1.v6 will be an update

---> Package clamav.i686 0:0.97.7-1.el6 will be updated

---> Package clamav.i686 0:0.97.8-1.el6 will be an update

---> Package clamav-db.i686 0:0.97.7-1.el6 will be updated

---> Package clamav-db.i686 0:0.97.8-1.el6 will be an update

---> Package clamd.i686 0:0.97.7-1.el6 will be updated

---> Package clamd.i686 0:0.97.8-1.el6 will be an update

---> Package kernel.i686 0:2.6.32-358.6.1.v6 will be installed

---> Package kernel-firmware.noarch 0:2.6.32-358.2.1.v6 will be updated

---> Package kernel-firmware.noarch 0:2.6.32-358.6.1.v6 will be an update

---> Package mysql.i686 0:5.1.67-1.el6_3 will be updated

---> Package mysql.i686 0:5.1.69-1.el6_4 will be an update

---> Package mysql-libs.i686 0:5.1.67-1.el6_3 will be updated

---> Package mysql-libs.i686 0:5.1.69-1.el6_4 will be an update

---> Package mysql-server.i686 0:5.1.67-1.el6_3 will be updated

---> Package mysql-server.i686 0:5.1.69-1.el6_4 will be an update

---> Package perl-Socket6.i686 0:0.23-3.el6 will be updated

---> Package perl-Socket6.i686 0:0.23-4.el6 will be an update

--> Finished Dependency Resolution

--> Running transaction check

---> Package kernel.i686 0:2.6.32-279.2.1.v6 will be erased

--> Finished Dependency Resolution



Dependencies Resolved



================================================================================

 Package         Arch   Version           Repository                       Size

================================================================================

Installing:

 kernel          i686   2.6.32-358.6.1.v6 clearos-updates                  24 M

Updating:

 app-date        noarch 1:1.4.35-1.v6     clearos-updates                 9.3 k

 app-date-core   noarch 1:1.4.35-1.v6     clearos-updates                  19 k

 clamav          i686   0.97.8-1.el6      clearos-updates                  10 M

 clamav-db       i686   0.97.8-1.el6      clearos-updates                  56 M

 clamd           i686   0.97.8-1.el6      clearos-updates                 130 k

 kernel-firmware noarch 2.6.32-358.6.1.v6 clearos-updates                  11 M

 mysql           i686   5.1.69-1.el6_4    clearos-updates                 916 k

 mysql-libs      i686   5.1.69-1.el6_4    clearos-updates                 1.2 M

 mysql-server    i686   5.1.69-1.el6_4    clearos-updates                 8.8 M

 perl-Socket6    i686   0.23-4.el6        clearos-updates                  26 k

Removing:

 kernel          i686   2.6.32-279.2.1.v6 @anaconda-ClearOSCommunity-20120801201                                                                             9.i386/6.3.0

                                                                           84 M



Transaction Summary

================================================================================

Install       1 Package(s)

Upgrade      10 Package(s)

Remove        1 Package(s)



Total download size: 113 M

Is this ok [y/N]: y

Downloading Packages:

(1/11): app-date-1.4.35-1.v6.noarch.rpm                                | 9.3 kB     00:00

(2/11): app-date-core-1.4.35-1.v6.noarch.rpm                           |  19 kB     00:03

(3/11): clamav-0.97.8-1.el6.i686.rpm                          (0%)  7% [===-                                               ] 2.4 kB/s | 797 kB     68:46 ETA

Website/forum has been along time very slow and is still a pain in the @ss for enjoyable reading

Hmm looks like they dropped off the list for the moment... I'll ping the dev team

Yeah it's not the solution for our problem.

Marcel van Leeuwen wrote:

I was doing a "yum update" I'm also experiencing very sloowwww download from the repositories. The speed is 1 - 4kB/s. For some reason yum is not using your mirror Tim. I did a "yum clean all".

After yum clean all

clearos/primary_db 2% [ ] 1.2 kB/s | 24 kB

I was doing a "yum update" I'm also experiencing very sloowwww download from the repositories. The speed is 1 - 4kB/s. For some reason yum is not using your mirror Tim. I did a "yum clean all".

Tim Burgess wrote:

Which mirror is it pulling from? (mine is in the UK with 100mbit upload)
http://master-mirror.clearsdn.com/clearos/mirrorlist/

Yum will used cached speed information when it downloads to select the appropriate mirror, just run 'yum clean all' and try again to refresh the mirror speeds?

Now I installed a new system and after 7 hours still downloading from marketplace.


after clea yum

clearos/primary_db 2% [ ] 1.1 kB/s | 24 kB

Which mirror is it pulling from? (mine is in the UK with 100mbit upload)
http://master-mirror.clearsdn.com/clearos/mirrorlist/

Yum will used cached speed information when it downloads to select the appropriate mirror, just run 'yum clean all' and try again to refresh the mirror speeds?