NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
neek
Joined: 01 Apr 2010 Posts: 6
|
Posted: Tue Jun 07, 2011 4:57 am Post subject: Database connection profiles dissappear after restarting 7.0 |
|
|
Product Version: NetBeans IDE 7.0 (Build 201104080000)
Java: 1.6.0_23; Java HotSpot(TM) Client VM 19.0-b09
System: Linux version 2.6.38.6-27.fc15.i686 running on i386; UTF-8; en_GB (nb)
Userdir: /home/neek/.netbeans/7.0
Hi all,
I've had this issue since 6.x, hoped moving to 7.x would fix it. I generally want about 20 database connection profiles in my Services->Databases list. They're all MySQL connections, to either a local db, or via ssh tunnels to remote databases. I create them by right clicking the "Databases" root node, choosing New Connection, driver "MySQL (Connector/J Driver)" (the default .jar shipped with netbeans, which never changes), and setting up the connection settings. Nothing unusual here.
I often find that restarting netbeans results in a few of them disappearing. They don't appear in the list. I can re-create them, use them happily for a few days, and after some time restart Netbeans and find they're gone. I can't tell if it's the same ones that keep disappearing, I'm never paying close enough attention to notice which ones are there and which not.
I've noticed ~/.netbeans/7.0/config/Databases/Connections, in which I have 60 xml files. Only 12 of them have content, the others are 0 bytes long. Only those with content result in a Databases node. This morning, I find 12 nodes in my Databases list, and only 12 of the 60 files have content (about 400 bytes each). They're all owned by my user, permissions are good, I can see no problems with reading/writing these files.
So, it seems something is causing these jdbc_mysql___host_post_stuff.xml files to be truncated, or wiped somehow.
Is there a log I can monitor that might tell me when this is happening?
I've removed the 0 byte xml files and will monitor the situation to see if I notice any other useful info. The problem might have gone away now that I've cleared away the crufty files.
Nick |
|
| Back to top |
|
 |
neek
Joined: 01 Apr 2010 Posts: 6
|
Posted: Wed Jun 08, 2011 5:45 am Post subject: Still a problem. Connected to closing netbeans? |
|
|
Well, it just happened again. Seems to be related to closing Netbeans.
- booted machine this morning, worked until about 11:30am, quit netbeans by clicking the 'x' in the title bar, waited a few minutes doing other tasks, rebooted machine.
- on reboot, loaded netbeans, two connection profiles that I created yesterday are gone.
Contents of Connections dir (with connection names obscured by 'x' chars):
| Code: | [neek Connections]$ ls -ltr
total 48
-rw-rw-r-- 1 neek neek 424 Jun 3 23:29 jdbc_paradox_____tmp_rsdata___on.xml
-rw-rw-r-- 1 neek neek 409 Jun 3 23:29 jdbc_mysql___localhost_3307_xxxx_1.xml
-rw-rw-r-- 1 neek neek 388 Jun 3 23:29 jdbc_mysql___localhost_3306_xx__.xml
-rw-rw-r-- 1 neek neek 408 Jun 3 23:29 jdbc_mysql___localhost_3307_xxxx.xml
-rw-rw-r-- 1 neek neek 423 Jun 6 17:27 jdbc_mysql___localhost_3307_xxxx_5.xml
-rw-rw-r-- 1 neek neek 424 Jun 6 21:39 jdbc_mysql___localhost_3306_xxxx_7.xml
-rw------- 1 neek neek 0 Jun 7 10:51 nohup.out
-rw-rw-r-- 1 neek neek 405 Jun 7 16:13 jdbc_mysql___localhost_3306_xxxx_1.xml
-rw-rw-r-- 1 neek neek 413 Jun 7 22:22 jdbc_mysql___localhost_3308_xxxx_2.xml
-rw-rw-r-- 1 neek neek 0 Jun 7 22:22 jdbc_mysql___localhost_3307_xxxx_2.xml
-rw-rw-r-- 1 neek neek 405 Jun 8 11:29 jdbc_mysql___localhost_13306_xxx.xml
-rw-rw-r-- 1 neek neek 403 Jun 8 11:29 jdbc_mysql___localhost_13306_xxx_1.xml
-rw-rw-r-- 1 neek neek 405 Jun 8 11:29 jdbc_mysql___localhost_13306_xxx_3.xml
-rw-rw-r-- 1 neek neek 400 Jun 8 11:29 jdbc_mysql___localhost_3306_xxxx_6.xml
-rw-rw-r-- 1 neek neek 0 Jun 8 11:29 jdbc_mysql___localhost_3306_xxxx_1.xml |
As you can see, one was lost yesterday, the other at 11:30 today when I quit netbeans.
It happens to both local connections (port 3306) and ssh tunnelled connections (3307). So, it doesn't seem to be related to connectivity, as he 3306 database was definitely available at the time.
I have two logs of interest in ~/.netbeans/var/log ..
| Code: | [neek log]$ ls -ltr
total 2172
-rw-rw-r-- 1 neek neek 977541 Jun 3 23:29 metrics.1
-rw-rw-r-- 1 neek neek 106473 Jun 7 22:22 messages.log.2
-rw-rw-r-- 1 neek neek 163036 Jun 8 11:29 messages.log.1
-rw-rw-r-- 1 neek neek 479444 Jun 8 11:50 uigestures.1
-rw-rw-r-- 1 neek neek 370254 Jun 8 11:52 metrics
-rw-rw-r-- 1 neek neek 49838 Jun 8 11:56 messages.log
-rw-rw-r-- 1 neek neek 43741 Jun 8 11:58 uigestures |
So messages.log.1 was finished with when I quit netbeans. There is no mention of any jdbc or xml files in it. I must say, there are also no timestamps on the log lines, which makes it impossible for me to tell what was logged when.
messages.log.0 has been created after the reboot when restarting netbeans, at 11:50, and has no useful into in it. The connection .xml file has already been lost by then.
Any clues still gratefully received
Nick |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can attach files in this forum You can download files in this forum
|
|