db upgrade 1.1.4

[lindeamon]

ok victor.
does this apply also to any database of chosen ? can i use sqlite if i want ?

thank you very much

[lindeamon]

do i have to do initialize ?
when do i have to do initialize ?

10x again

[victor]

You should not initialize database if it already contains data. Initialization is for fresh installation on empty database.

Generally I do not recommend to use SQLite in production. It has both performance and upgrade issues, although performance can be insufficient only for relatively large installations. Upgrade problems are related to the fact that SQLite does not support DROP COLUMN operation - so if database upgrade requires column removal from the table, it will fail. It is possible to do upgrade manually in these cases, but it is time consuming and requires digging into the source code of nxdbmgr to see what SQL queries should be executed.

Best regards,
Victor

[lindeamon]

ok victor.

i have installed everything from the start.

1. installed the mysql
2. installed version 1.0.12
3. imported the db export i had.

up to here everything worked fine.

4. uninstalled the 1.0.12
5. installed version 1.1.4 and pointed him to the mysql server and did not tell him to initialize.
6. the setup upgraded the db successfully.

the core service does not come up and the eventlog indicates this malfunctions:

1. event id:46, error initializing component locks table
2. event id:43, sql query failed (query = "select var_value from config where var_name=?"):

i have tried to run the services through command line and added the -D 9 at the end for debug mode but got the error: "startservicecontroldispatcher() failed: the service process could not connect to the service controller."

what do you think is wrong ?

10x,
lindeamon

[victor]

If you run netxmsd.exe from command line, you should omit -d switch, like this:

netxmsd.exe -D 9

Best regards,
Victor

[lindeamon]

you are right.i have changed the service config and i got the messages i wrote in my last post

i hope you have the answer to the problem.

[victor]

I have replicated this issue on my system. Looks like a bug in MySQL driver. I'll post a patch when I fix it.

Best regards,
Victor

[lindeamon]

so what you are saying is that will not be able to use this new vesrion ?
bummer
ok, i will wait for the patch.
b.t.w - i have restored everything to version 1.1.3 and everything is working fine again.

[victor]

Yes, unfortunately there is a bug in MySQL driver in 1.1.4. I'll try to made a patch tomorrow. Other DB engines should work fine. I do most of the development using Oracle and PostgreSQL, and at some point forgot to make necessary tests at MySQL.

Best regards,
Victor

[Jmp_3f8h]

Hi Victor,

I'm getting this error upgrading to version 1.1.4 (from 1.1.3):

C:\Program Files\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.1.4

Upgrading database...
Upgrading from version 236 to 237
SQL query failed ([Microsoft][SQL Native Client][SQL Server]The object 'DF__business___paren__09746778' is dependent on column 'parent_id'.):
ALTER TABLE business_services DROP COLUMN parent_id
Rolling back last stage due to upgrade errors...
Database upgrade failed

Now I rolled back to version 1.1.3, any hints?

Another question: where can I find the mobile client for Android?

Thank you very much for your support.

Marco.

[victor]

Hi!

Same problem as here: https://www.netxms.org/forum/installation/1-1-4-database-upgrade-error/. In short, try to run manually

ALTER TABLE business_services DROP CONSTRAINT DF__business___paren__09746778;

Best regards,
Victor

[victor]

MySQL driver patch for 1.1.4. Just replace existing mysql.ddr with attached one.

Best regards,
Victor

---

mysql.ddr

[lindeamon]

thank you victor.

there is something not clear to me yet.how can i do a replace if the installation is a new one ?
do i have to do an installation without configuring the server,replace the driver and then do the server configuration part ?

10x,
lindeamon

[lindeamon]

sorry victor,

i have remmebered why we needed the patch.to replace the old one after the db upgrade.
just ignore my former post.

thank you,
lindeamon

[lindeamon]

hi victor,

i have installed version 1.1.3 and let it work for a day or two and it worked ok.i have uninstalled it and installed version 1.1.4.
i have gone through all the steps of the setup and when the server configuration wizard came up i have replaced the mysql.ddr file with the one you gave me in this post and finished the wizard and nothing works.
i have tried to upgrade the db through command line and it says the db version is the latest.
i invoked the netxmsd in command line with debug 9 and it said it had connected to the database but failed with this message "error initializing component locks table"

best regards,
lindeamon

[lindeamon]

i forgot to say that i did not initialized the databse.

[victor]

Could you please try this driver?

Best regards,
Victor

---

mysql.ddr

[lindeamon]

ok

i will give it a try and tell you if it worked.

[lindeamon]

hi victor,

to cut the story short i did everything as i mentioned in the last time and everything went fine but service did not came up.running the service from command line told that my db has a version of 232 and the server is compiled for version 240.
i did an upgrade and it failed and the error message said :" sql query failed (table 'business_services' already exists): " and then it writes the sql command: "create table business_services........" and all of it's data.

Best Regards,
Lindeamon

[lindeamon]

hi victor,

i have tried to delete the table mentioned in the former post and failed with other tables like node_links.
fyi

lindeamon