Topic: JBidwatcher Help / 2.5.5 - high cpu usage when scrolling/viewing long 'complete' tab list

The g9fecd73 jbidwatcher has a regression when viewing a long ‘complete’ auction listing. Mine is on the order of 1500-2000 items and selecting the tab or scrolling the listings when already selected results in high cpu usage on at least one core. CPU runs at 100% for seconds to minutes depending upon request and UI can become unresponsive for long periods. Previous version was sluggish on initial selection of tab but generally responsive after that.

Win XP, 32-bit, JRE is 1.7.0-51.

Topic: JBidwatcher Help / 2.1.4.1 accesses my.jbidwatcher.com when this service is disabled

Using 2.1.4.1, I’ve never enabled the ‘My JBidwatcher’ service in configure
but I’ve noticed it going out to what appears to be the service point regardless:

Sun Mar 06 02:23:20 EST 2011: Failed to get https://my.jbidwatcher.com/services/account: I’m sorry Dave, I’m afraid I can’t do that.

Bug or expected?

Topic: JBidwatcher Help / In 'Auction > Add' Dialog, trailing characters are not scrubbed

Found while manually moving auction items from pre8 to .4.1. The
‘Action > Add’ popup allows some trailing characters. For example, both:

and

(with trailing double-quote) can be added and they become distinct
entries in the current auction list in 2.1.4.1. Appears to be mostly
harmless so far.

[ Follow-up ]

Ah, it does appear to cause exceptions:

Sat Mar 05 15:48:13 EST 2011: There was a problem parsing the title.
Sat Mar 05 15:48:27 EST 2011: Error writing C:\Documents and Settings\mcb\.jbidw
atcher\auctionsave\290541160855".jpg
C:\Documents and Settings\mcb\.jbidwatcher\auctionsave\290541160855".jpg (The fi
lename, directory name, or volume label syntax is incorrect)
java.io.FileNotFoundException: C:\Documents and Settings\mcb\.jbidwatcher\auctio
nsave\290541160855".jpg (The filename, directory name, or volume label syntax is
incorrect)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.(Unknown Source)
at java.io.FileOutputStream.(Unknown Source)
at com.jbidwatcher.util.ByteBuffer.save(ByteBuffer.java:43)
at com.jbidwatcher.auction.Thumbnail.getValidImagePath(Thumbnail.java:31
)
at com.jbidwatcher.auction.ThumbnailLoader.messageAction(ThumbnailLoader
.java:34)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.ja
va:55)
at java.lang.Thread.run(Unknown Source)

Topic: JBidwatcher Help / Time synchronisation

Does your computer’s clock (I’m guessing a windows system) lose time in step with JBidwatcher?

Topic: JBidwatcher Help / 2.1.4.1 (and 2.1.*) throwing constant java exceptions and eventually failing

This has been going on since last year but I’ve kept my 2.1pre* versions around and
I’ve been using them. But that isn’t working well enough with recent eBay changes
so I’m here in the forums. Host is Windows XP 32-bit, Java is Version 6 Update 24.

Behavior: on startup, UI appears good. ‘current’ tab refreshes quickly and does
what it should. ‘complete’ tab, however, does almost nothing. After 30 minutes,
it is less than 5% complete judging from activity bar. The UI generally seems to
slow down as this condition persists eventually resulting in tabs not repainting
and more general unresponsiveness. Earlier versions also had a tendency to
hard-to-restore DB corruption if they were killed, not certain about 2.1.4.1 yet.

Logs and exceptions of interest.

This one occurs every second without stopping:

Tue Mar 01 11:08:07 EST 2011: Exception during the check() operation of class com.jbidwatcher.ui.AuctionsManager
at com.jbidwatcher.util.db.ActiveRecord.convertResultsToList(ActiveRecord.java:170)
at com.jbidwatcher.util.db.ActiveRecord.findAllByPrepared(ActiveRecord.java:152)
at com.jbidwatcher.auction.AuctionEntry.findAllNeedingUpdates(AuctionEntry.java:1663)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)

Tue Mar 01 11:08:08 EST 2011: Exception during the check() operation of class com.jbidwatcher.ui.AuctionsManager
at com.jbidwatcher.util.db.ActiveRecord.convertResultsToList(ActiveRecord.java:170)
at com.jbidwatcher.util.db.ActiveRecord.findAllByPrepared(ActiveRecord.java:152)
at com.jbidwatcher.auction.AuctionEntry.findAllNeedingUpdates(AuctionEntry.java:1663)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)

Startup is a series of horrors starting with:

Tue Mar 01 10:55:43 EST 2011: JBidwatcher 2.1.4.1-
Tue Mar 01 10:55:43 EST 2011: Sun Microsystems Inc. Java, version 1.6.0_24 on Windows XP
Tue Mar 01 10:55:43 EST 2011: Logging to C:\Documents and Settings\mcb\.jbidwatcher\errors.28.log
Tue Mar 01 10:55:45 EST 2011: Scripting is not enabled.
Tue Mar 01 10:55:46 EST 2011: Loading listings from the database (34/2830/2848 entries, 2830/2848 auctions)
Tue Mar 01 10:55:46 EST 2011: Done with the initial load (got 34 active entries)
Tue Mar 01 10:55:50 EST 2011: Time delta with ebay.com is -9531
Tue Mar 01 10:55:50 EST 2011: Time delta with ebay.co.uk is -9859
Tue Mar 01 10:55:56 EST 2011: Can’t get row (id = ‘187815’).
Java exception: ‘: java.lang.NullPointerException’.
java.sql.SQLException: Java exception: ‘: java.lang.NullPointerException’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
at com.jbidwatcher.util.db.Table.execute(Table.java:247)
at com.jbidwatcher.util.db.Table.getRow(Table.java:341)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:329)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:325)
at com.jbidwatcher.util.db.Table.findFirstBy(Table.java:128)
at com.jbidwatcher.util.db.ActiveRecord.findFirstByUncached(ActiveRecord.java:235)
at com.jbidwatcher.util.db.ActiveRecord.findFirstBy(ActiveRecord.java:245)
at com.jbidwatcher.auction.AuctionInfo.findFirstBy(AuctionInfo.java:530)
at com.jbidwatcher.auction.AuctionEntry.getAuction(AuctionEntry.java:1350)
at com.jbidwatcher.auction.server.AuctionServerManager.importListingsToUI(AuctionServerManager.java:232)
at com.jbidwatcher.auction.server.AuctionServerManager.access$300(AuctionServerManager.java:27)
at com.jbidwatcher.auction.server.AuctionServerManager$2.run(AuctionServerManager.java:189)
Caused by: java.sql.SQLException: Java exception: ‘: java.lang.NullPointerException’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 22 more
Caused by: java.lang.NullPointerException
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
at org.apache.derby.impl.store.access.btree.OpenBTree.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
… 15 more

And:

Tue Mar 01 10:55:56 EST 2011: Can’t get row (name = ‘complete’).
No current connection.
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.jbidwatcher.util.db.Database.prepare(Database.java:180)
at com.jbidwatcher.util.db.Table.getRow(Table.java:339)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:329)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:325)
at com.jbidwatcher.util.db.Table.findFirstBy(Table.java:128)
at com.jbidwatcher.util.db.ActiveRecord.findFirstByUncached(ActiveRecord.java:235)
at com.jbidwatcher.util.db.ActiveRecord.findFirstBy(ActiveRecord.java:245)
at com.jbidwatcher.auction.Category.findFirstBy(Category.java:66)
at com.jbidwatcher.auction.Category.findFirstByName(Category.java:28)
at com.jbidwatcher.auction.AuctionEntry.setCategory(AuctionEntry.java:1142)
at com.jbidwatcher.auction.AuctionEntry.getCategory(AuctionEntry.java:1129)
at com.jbidwatcher.auction.server.AuctionServerManager.importListingsToUI(AuctionServerManager.java:246)
at com.jbidwatcher.auction.server.AuctionServerManager.access$300(AuctionServerManager.java:27)
at com.jbidwatcher.auction.server.AuctionServerManager$2.run(AuctionServerManager.java:189)
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 22 more

And may more with some theme on the null pointer/no connection problems.
About 6MB of error log in 40 minutes.

Log file:

Tue Mar 01 10:55:47 EST 2011: Notify: Failed to load all auctions.
Tue Mar 01 10:55:50 EST 2011: Successfully synchronized time with ebay.com.
Tue Mar 01 10:55:50 EST 2011: Successfully synchronized time with ebay.co.uk.
Tue Mar 01 10:55:50 EST 2011: Server time is now: Tue Mar 01 10:55:41 EST 2011
Tue Mar 01 10:55:50 EST 2011: Getting the sign in cookie for ebay.com
Tue Mar 01 10:55:54 EST 2011: Done getting the sign in cookie for ebay.com
Tue Mar 01 10:55:54 EST 2011: Getting the sign in cookie for ebay.co.uk
Tue Mar 01 10:55:56 EST 2011: Done getting the sign in cookie for ebay.co.uk
Tue Mar 01 10:55:57 EST 2011: Updating null
Tue Mar 01 10:55:58 EST 2011: Link issues:
Tue Mar 01 10:55:58 EST 2011: eBay (or the link to eBay) appears to be down.
Tue Mar 01 10:55:58 EST 2011: eBay (or the link to eBay) appears to be down for the moment.
Tue Mar 01 10:55:58 EST 2011: Checking for a newer version.
Tue Mar 01 10:55:58 EST 2011: No new versions on the server.