Catalina - Capri - 25s International Assocaition Logo(2006)  
Assn Members Area · Join
Association Forum
Association Forum
Home | Profile | Register | Active Topics | Forum Users | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Catalina/Capri 25/250 Sailor's Forums
 Catalina 25 Specific Forum
 C25 Forum
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JanS48
Navigator

Member Avatar

USA
111 Posts

Initially Posted - 10/08/2020 :  06:27:08  Show Profile  Reply with Quote
Greetings all
Are all the posts gone? I'm only seeing one when I log in.
Thanks
Jan

82 C25 SR FK
Sailing out of Newport Harbor.

Davy J
Master Marine Consultant

Members Avatar

USA
1497 Posts

Response Posted - 10/08/2020 :  08:01:45  Show Profile  Reply with Quote
Looking at the sub-forums, it appears the threads from about mid June to now are missing. Even searching for some threads that I know I participated in, do not show up.

Davy J


2005 Gemini 105Mc
PO 1987 C25 #5509 SR/SK
Tampa Bay
Go to Top of Page

redeye
Master Marine Consultant

Members Avatar

3408 Posts

Response Posted - 10/08/2020 :  08:01:50  Show Profile  Reply with Quote
I think they had a server crash or some such so they had a restart. I imagine someone is trying to get the olds posts back up even as we speak.

We may be starting a new, which is also fun.

I kinda posted and deleted a post this morning just for the fun and to give them something to look at. how it might be working now.

Ray in Atlanta, Ga.
"Lee Key" '84 Catalina 25 SR/FK
Go to Top of Page

Stinkpotter
Master Marine Consultant

Members Avatar

Djibouti
8550 Posts

Response Posted - 10/08/2020 :  20:12:52  Show Profile  Reply with Quote
Apparently everything from mid-June to today is gone.

Dave Bristle
Association "Port Captain" for Mystic, CT
PO of 1985 C-25 SR/FK #5032 Passage, ex-USCG-OUPV
Now on Eastern 27 Sarge (but still sailing when I can).

Passage, Mystic, and Sarge--click to enlarge.
Go to Top of Page

Stinkpotter
Master Marine Consultant

Members Avatar

Djibouti
8550 Posts

Response Posted - 10/08/2020 :  20:14:38  Show Profile  Reply with Quote
...and new posts are slower to take than ever.

Dave Bristle
Association "Port Captain" for Mystic, CT
PO of 1985 C-25 SR/FK #5032 Passage, ex-USCG-OUPV
Now on Eastern 27 Sarge (but still sailing when I can).

Passage, Mystic, and Sarge--click to enlarge.
Go to Top of Page

sethp001
Mainsheet C-25 Tech Editor

Members Avatar

812 Posts

Response Posted - 10/08/2020 :  20:16:59  Show Profile  Reply with Quote
There were some issues with the forum migration to new equipment and with the data backup by our website hosting company. Posts from June 17 to October 6 are permanently gone. Everything else is still there. To see the most recent previous topics, change the dropbox at the bottom of the list from "the last 30 days" to a longer time frame.



Seth
"Outlier" 1987 Catalina 25 SR/SK/Traditional Interior #5541
"Zoo" 1977 Morgan Out Island 30
"Nomad" 1980 Prindle 16
"Lost" 1988 Catalina Capri 14.2 (sold - yay!)
"Marine Tex 1" Unknown Origin POS 8' Fiberglass Dinghy
https://whichsailboat.com/2014/07/27/catalina-25-review/
Go to Top of Page

Commodore
Russ Johnson

Members Avatar

USA
637 Posts

Response Posted - 10/08/2020 :  22:56:02  Show Profile  Reply with Quote
On Tuesday, Oct-6 the forum crashed.
While the website itself was available, the forum application could not connect to the database.
Meaning, the forum was down and users received an error messages when trying to access the forum.

After working with the website hosting company, there has been an unrecoverable data loss.
All forum data from Jun-17 to Oct-6 has been permanently lost.

For more details, please review this post. You can also post comments there.
Association Forum - Crash and Data Loss Oct-6
http://www.catalina-capri-25s.org/forum/topic.asp?TOPIC_ID=31937

We are truly sorry for this situation.
Russ Johnson
Commodore

Russ Johnson, Commodore 2009-2020 (commodore at catalina-capri-25s.org)
Go to Top of Page

Lee Panza
Captain

Members Avatar

USA
417 Posts

Response Posted - 10/10/2020 :  18:36:59  Show Profile  Visit Lee Panza's Homepage  Reply with Quote
Russ:

The information that we generate in this forum is of value to future boatowners, and losing it amounts to the forum having been non-existent during that black-out. At the very least, the hosting service should credit the Association with the fees charged during that period of time. It equates to nearly 30% of a year's worth of this forum's primary expense.


The trouble with a destination - any destination, really - is that it interrupts The Journey.

Lee Panza
SR/SK #2134
San Francisco Bay
(Brisbane, CA)
Go to Top of Page

Steve Milby
Past Commodore

Members Avatar

USA
5464 Posts

Response Posted - 10/10/2020 :  19:50:51  Show Profile  Reply with Quote
To prevent future losses, can the website data be backed up regularly?

Steve Milby C&C 35 Landfall ("Captiva Wind"); Cal 25 ("Fahrvergnügen")
Past Commodore
Go to Top of Page

Voyager
Master Marine Consultant

Members Avatar

USA
4631 Posts

Response Posted - 10/11/2020 :  13:24:13  Show Profile  Reply with Quote
Not for nothing, how large is the database? I’m guessing with photos and some 20@+ years of archives it would far exceed the 2GB I get for free from Google or MS Office.

Bruce Ross
Passage ~ SR-FK ~ C25 #5032

Port Captain — Milford, CT
Go to Top of Page

Commodore
Russ Johnson

Members Avatar

USA
637 Posts

Response Posted - 10/11/2020 :  14:53:23  Show Profile  Reply with Quote
Hey guys,

These are all good questions.
Here are some clarifications from my other post.
You can post comments there.
Association Forum - Crash and Data Loss Oct-6
http://www.catalina-capri-25s.org/forum/topic.asp?TOPIC_ID=31937

We have weekly backups of the forum database.
The problem is, every week the website company was backing up the same file from Jun-17.
There are several copies of the Jun-17 database file.

The notice we received:
The website was moving to a new server.
There is a new website admin tool call "Plesk".
There is nothing needed on your part to complete the migration.

What was not in the notice.
Moving the website also means copying the database to a new server.
They didn't communicate there was two copies of the database running at the same time.
They didn't communicate we needed to manually disconnect from the old database server and connect to the new database server.
They didn't communicate they were shutting down the old database server.

It is standard practice to keep websites and databases on separate servers.
That was the configuration before and the configuration now.
The notice only mentions the website and there is no mention of the database.

Next, it is common to connect to a database by either the server name or IP address.
We are using the server name. In the Plesk tool, it only displays the IP address.
When "moving" a database to a new server, IT "usually" updates the server name to point to the new IP address.
This is a database alias, which they didn't update or communicate they were not going to update.

I've been through many IT projects in my career, but this company didn't follow standard practices.
Examples:
When two copies of the same database are running, check if anyone is connected to the old database.
Update the database alias to the new IP address.
Before shutting down a database, make it unavailable. Change the connection string, change the database name, change the password, anyone one of those will do.
Before unplugging a server, stop the services. In this case stop the MySQL database service.
Once you follow any of those steps, you let the machine run for a few days.
In our case, 3-months.
The website company didn't do any of those things.
They copied the database to a new server in June, they didn't check anything, they shutdown and unplugged the machine on the same day.

Using the Plesk admin tool:
You could see the database backups, it was not clear this was the database copy from Jun-17.
You could see the database was running, it was not clear this was the database copy from Jun-17.
You could run queries and see forum data, it was not clear this was data from Jun-17.

In hindsight, had we spent more time using the Plesk admin tool, we could have run queries to see the most recent forum post or see the most recent forum user.
Then determine new data was not being added to the new database (had we known there was a new database).
Since the forum was running well, this about of troubleshooting was not considered.

Thank you for your comments.
I'm going through the 5-stages of grief.
I may be upset, but not at you or the forum users.
Thank you for your understanding.

Russ Johnson, Commodore 2009-2020 (commodore at catalina-capri-25s.org)

Edited by - Commodore on 10/11/2020 14:57:53
Go to Top of Page

Lee Panza
Captain

Members Avatar

USA
417 Posts

Response Posted - 10/11/2020 :  18:00:39  Show Profile  Visit Lee Panza's Homepage  Reply with Quote
Russ: it won't retrieve our lost data, but we should - at the very LEAST - get a refund of 30% of the cost of web-hosting service.

The trouble with a destination - any destination, really - is that it interrupts The Journey.

Lee Panza
SR/SK #2134
San Francisco Bay
(Brisbane, CA)
Go to Top of Page

Commodore
Russ Johnson

Members Avatar

USA
637 Posts

Response Posted - 10/11/2020 :  18:25:27  Show Profile  Reply with Quote
quote:
Originally posted by Lee Panza

Russ: it won't retrieve our lost data, but we should - at the very LEAST - get a refund of 30% of the cost of web-hosting service.

Lee,
That would be about $100.
I would gladly pay double that myself.
Russ

Russ Johnson, Commodore 2009-2020 (commodore at catalina-capri-25s.org)
Go to Top of Page

redeye
Master Marine Consultant

Members Avatar

3408 Posts

Response Posted - 10/12/2020 :  05:10:32  Show Profile  Reply with Quote
What are the 5 stages of Grief..... I only remember the bourbon stage. It pretty much goes black after that. Might have to rebuild my database....


Thank You for all your work. I hate database work ( or maybe working with the other people that are supposto be doing database work )

Ray in Atlanta, Ga.
"Lee Key" '84 Catalina 25 SR/FK
Go to Top of Page

Voyager
Master Marine Consultant

Members Avatar

USA
4631 Posts

Response Posted - 10/12/2020 :  07:37:40  Show Profile  Reply with Quote
quote:
Originally posted by redeye


Thank You for all your work.



I 2nd Ray’s sentiment.

As I said in my post on the other thread (paraphrasing), we’re all still here and we can re-post the important topics if we like.

I just need some help recalling all the topics:
• Dreaded turning ball
• Raising a boat off the trailer without a travel lift
• Long haul trailering across the country
• Replacing the head
• Adding hand holds to the cabin
• New interior cushions from Catalina Yachts
• Outboard motor sound and spark plug failure
• Lake Lanier windstorm
• Extending the settee to allow for more comfortable sleep
• Rewiring the mast connector on the cabintop.
To name a few ...

If others had their favorites, please add to the list.

Bruce Ross
Passage ~ SR-FK ~ C25 #5032

Port Captain — Milford, CT

Edited by - Voyager on 10/12/2020 07:43:21
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Association Forum © since 1999 Catalina Capri 25s International Association Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.06
Notice: The advice given on this site is based upon individual or quoted experience, yours may differ.
The Officers, Staff and members of this site only provide information based upon the concept that anyone utilizing this information does so at their own risk and holds harmless all contributors to this site.