Informix Gives -155 Error

I have been running Informix 7.22.TC1 successfully on Windows NT servers with the WebLogic 1.1 JDBC driver.

On Web server restart, my application suddenly shows an error in connection pool creation. Investigating the online server shows the databases gone, and when I use the SQLEditor window, the databases appear but give the -155 error. This happened on one server yesterday, and to another one today.

How can I resurrect the databases from this error? What’s the cause? Am I being hacked?

If you have purchased Informix support, now’s a good time to call them. If you don’t have a support contract, and if the data is high-value, you should call Informix support and inquire about getting them to help. If that’s not workable, there are a few things you may be able to do.

First, check to see whether the database files are still in place. Go to the directories (usually IFMXDATAyour_instance_name) and see if the files are there. If so, copy them into another directory. If they’re not there, or if they have a zero size, you’ll have to restore them from an archive. If you have a good, recent archive, it may be easier to restore from it even if you have data files in place.

If you have found intact data files and moved them into another directory, you can reinstall Informix and initialize a new instance. This will be needed if something has managed to destroy the Informix executables or corrupt the configuration data. Make sure that the size of the new rootdbs is exactly the same as the original instance (usually 30MB if you did a default install).

Once the new instance is created, shut down the database and delete the data files for the new instance. Move the original files back into the old location. Restart the database and any data from the old data files should be intact if the files weren’t corrupted.

How did it happen? Check your online.log and see if you can see what the error messages indicate. You may have been hacked. It’s possible that someone got into your directories and deleted the database files.

By the way, Informix 7.22 is a pretty old version. I’d suggest upgrading to 7.30.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

Top 5 B2B SaaS Marketing Agencies for 2023

In recent years, the software-as-a-service (SaaS) sector has experienced exponential growth as more and more companies choose cloud-based solutions. Any SaaS company hoping to stay ahead of the curve in this quickly changing industry needs to invest in effective marketing. So selecting the best marketing agency can mean the difference

technology leadership

Why the World Needs More Technology Leadership

As a fact, technology has touched every single aspect of our lives. And there are some technology giants in today’s world which have been frequently opined to have a strong influence on recent overall technological influence. Moreover, those tech giants have popular technology leaders leading the companies toward achieving greatness.

iOS app development

The Future of iOS App Development: Trends to Watch

When it launched in 2008, the Apple App Store only had 500 apps available. By the first quarter of 2022, the store had about 2.18 million iOS-exclusive apps. Average monthly app releases for the platform reached 34,000 in the first half of 2022, indicating rapid growth in iOS app development.